Laserfiche WebLink
MCSA=MicrosSQUServer <br />CaIJOBS# 11100111000031 CRM ID: C33SoCal <br />General Course Description <br />MCSA DB Administrator for SQL Server prepares the student to install or configure Microsoft SQL Server and manage, maintain <br />databases or multidimensional databases it includes development of strategies for data archiving, consolidation, distribution, and <br />recovery. The course stresses capacity analysis and emphasizes the tradeoffs that need to be made during design, In addition, <br />the course emphasizes that students should think about the whole environment, which includes business needs, regulatory <br />requirements, network systems, and database considerations during design. <br />Admissions Requirement: See Page 288 "Admissions Process" <br />Minimum of prior education: Basic knowledge of PC desktop operation or equivalence <br />Minimum graduation requirements: Attendance 80%, Exams passed at 70% <br />Instruction Mode: Classroom, Online, Hybrid <br />Prerequisites <br />Before attending this course, students must have basic knowledge of security protocols, have working knowledge of network <br />and database architectures and technologies, Active Directory service, have experience creating Microsoft Office Visio drawings <br />or have equivalent knowledge or have a Microsoft Certified Technology Specialist: Microsoft SQL Server credential and a Basic <br />knowledge of PC desktop operation or equivalency is required. <br />Acquired Skills <br />After completing this course, students will be able to manage and automate databases and servers. Manage supporting <br />services, analyze storage, CPU, memory, and network capacity needs, design a strategy for Database Administration. Establish <br />database conventions and standards in a Microsoft SQL Server environment. <br />Job Titles (Job Titles related to IT Training stretch Horizontally, they can vastly vary, the list below is a <br />sampling but not limited to) <br />(SOC)15-1200 Computer Occupations <br />Database Administrator Sr. Database Administrator <br />Course Information <br />Hours: 315 <br />Approximately 18 weeks of training <br />Course <br />Hours <br />20761 Querying Data with Transact SQL <br />105 <br />20764 Administering a SQL Database Infrastructure <br />105 <br />20767 Implementing a SQL Data Warehouse <br />105 <br />"Three Microsoft Exam Vouchers and Exam Preps <br />