Laserfiche WebLink
General Course Description <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 (OLAP) cubes. This <br />certification will qualify you for a position as a BI developer. <br />Prerequisites <br />A High school diploma or equivalency is required. <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 />Bow 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 />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 />Price <br />$8400.00 <br />Course <br />Total Hours <br />Database Fundamentals <br />36 <br />Intro to SQL Databases <br />36 <br />SQL Querying —Level 1 Fundamentals of Querying <br />98 <br />SQL Querying - Level 2 Advanced Querying <br />18 <br />Querying Data with Transact SQL <br />54 <br />Developing SQL Data Models <br />36 <br />Implementing a Data Warehouse with Microsoft SQL Server <br />54 <br />Communication Strategies <br />9 <br />Developing Successful Interpersonal Skills <br />31.5 <br />Writing for the Business Professional <br />31.5 <br />`THREE Microsoft Exam Vouchers and Exam Prep (2 for MCSA and MTA 98-364) <br />Price <br />$7,360.00 <br />