Laserfiche WebLink
CaIJOBS# 11080212000000 CRM ID: C11SoCal !Train Program Number:11030117300100 SBY: 3080 <br />General Course Description <br />Program is designed as an entry level into the Microsoft SQL environment. Students will begin with Access and Crystal Reports <br />training then will take the T-SQL coding along with XML syntax. Students will earn a Database Administration Certification and a <br />Business Intelligence Certification, Business Intelligence uses Analysis, Integration, Data Warehousing and Reporting Services <br />to produce knowledge and company planning. <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 />A Basic knowledge of PC desktop operation or equivalency is required. <br />Acquired Skills <br />Select SQL Server services to support an organization's business needs, plan for source control, unit testing, and deployment to <br />meet an organization's needs, • Evaluate advanced query techniques. • Evaluate advanced XML techniques. Approach database <br />design from a systematic perspective, gather database requirements, and formulate a conceptual design, • Analyze and evaluate <br />a logical database design. - Design a database access strategy, • Design a normalized database, Optimize a database design <br />by demoralizing <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 Administrators Network Systems and Data Network and Systems <br />Communications Analysis Administrators <br />Course Information <br />Hours: 426 <br />Approximately 22 weeks of training <br />Course <br />Hours <br />Microsoft Access Levels One and Two <br />96 <br />Crystal Reports Levels One and Two <br />64 <br />Introduction to Programming (No Courseware Included) <br />56 <br />20761 Querying Data with Transact SQL <br />70 <br />20764 Administering a SQL Database Infrastructure <br />70 <br />20767 Implementing a SQL Data Warehouse <br />70 <br />