Laserfiche WebLink
General Course Description r <br />SQL Server is a vital tool for businesses and large organizations around the world, as it allows them to gain better insight into their data <br />and leverage the information to make more informed decisions. This information can mean the difference between success and failure <br />as businesses continually work to understand industry trends, customer behavior, and more. Earning an MCSA: SQL 2016 Business <br />Intelligence Development certification validates your extract, transform, and load (ETL) and data warehouse skills, along with those <br />for implementing BI solutions using multidimensional and tabular data models and online analytical processing (CLAP) cubes. This <br />certification will qualify you for a position as a BI developer. <br />Admissions Requirement: See Page 288 "Admissions Process" <br />Minimum of prior education: Basic knowledge of PC desktop operation <br />Minimum graduation requirements: Attendance 80%, Exams passed at 70% <br />Instruction Mode: Classroom, Online, Hybrid <br />Prerequisites <br />Basic knowledge of PC desktop operation <br />Acquired Skills <br />Skills acquired are not limited to, but include: Create Transact -SQL SELECT queries. Query data by using subqueries and APPLY. Create <br />database programmability objects by using Transact -SQL. Implement error handling and transactions. Implement data types and <br />NULLS <br />Design and implement dimension tables. Design and implement fact tables. Design and implement indexes for a data warehouse <br />workload. Design storage for a data warehouse. Design and implement partitioned tables and views. Design and implement an extract, <br />transform, and load (ETL) control flow by using a SQL Server Integration Services (SSIS) package. Design and implement an ETL data <br />flow by using an SSIS package. Implement an ETL solution that supports incremental data extraction. Create a multidimensional <br />database by using Microsoft SQL Server Analysis Services (SSAS). Design and publish a tabular data model. Configure memory limits, <br />configure Non -Union Memory Architecture (NUMA), configure disk layout, determine SSAS instance placement. <br />Job Titles (Job Titles related to IT Training stretch Horizontally, they can vastly vary, the list below is a sampling but not limited to) <br />(SOC) 43-0000 Office and Administrative Support Occupations <br />(SOC) 15-1200 Computer Occupations <br />(SOC) 11-0000 Management Occupations <br />Data Warehousing Specialist Business Intelligence Analysts Data Management Specialist <br />Statisticians Computer and Information Systems <br />Specialist <br />Course Information <br />Hours: 324 <br />Approximately 18 Weeks <br />Course <br />Total Hours <br />Database Fundamentals <br />36 <br />Intro to SQL Databases <br />36 <br />Azure Data Fundamentals <br />18 <br />SQL Querying —Level 1 Fundamentals of Querying <br />18 <br />SQL Querying - Level 2 Advanced Querying <br />18 <br />Querying Data with Transact SQL <br />45 <br />