
Exam 70-768: Developing SQL Data Models
Business Intelligence is one of the most in-demand aspects of Information Technology. As data continues to drive the entire business process, the ability to collect, manage, and provide fast, efficient access to decision makers throughout the enterprise is a vital function.rnrnMicrosoft's SQL Server Analysis Services provides the tools to create and manage multidimensional cube and tabular data models that make BI data accessible. This course will help you understand and implement SQL Server 2016 data models and will help you in your preparation for Microsoft's 70-768 Developing SQL Data Models certification exam.rnrnYou can achieve an MCSA: SQL 2016 BI Development certification by passing exams 70-768 which is covered in this course, along with exam 70-767, Implementing a SQL Data Warehouse, also available from VTC.rnrnIn this course, Mark Long brings over 20 years of experience with SQL Server along to help you get acquainted with SQL Server 2016 and help you get prepared to take the 70-768 exam.
Course content
Welcome/Intro7 lessons
SQL Server 2016 Essentials7 lessons
Installing SQL Server12 lessons
- Getting SQL Server 2016 pt. 14:351 credit or ad
- Getting SQL Server 2016 pt. 24:101 credit or ad
- Installing SQL Server 2016 pt. 16:531 credit or ad
- Installing SQL Server 2016 pt. 24:351 credit or ad
- Getting SQL Server Management Studio3:591 credit or ad
- Verifying the Installation5:371 credit or ad
- Attaching the Sample dB pt. 15:281 credit or ad
- Attaching the Sample dB pt. 23:021 credit or ad
- SQL Server Data Tools5:431 credit or ad
- Getting and Installing SSDT2:121 credit or ad
- Database Diagrams pt. 16:191 credit or ad
- Database Diagrams pt. 26:141 credit or ad
Data Marts and Warehouses17 lessons
- Mart or Warehouse pt. 16:551 credit or ad
- Mart or Warehouse pt. 26:521 credit or ad
- Data Warehouse Structure6:141 credit or ad
- Star Schema4:091 credit or ad
- Snowflake Schema2:571 credit or ad
- Dimensional Modeling pt.6:481 credit or ad
- Dimensional Modeling pt. 26:541 credit or ad
- Dimension Types5:441 credit or ad
- Designing Dimensions6:261 credit or ad
- Understanding Granularity5:331 credit or ad
- SSIS and ETL6:441 credit or ad
- SSIS Installation Notes6:441 credit or ad
- SSIS Package Example pt. 16:361 credit or ad
- SSIS Package Example pt. 27:091 credit or ad
- SSIS Package Example pt. 35:551 credit or ad
- Deploying SSIS Packages pt. 14:411 credit or ad
- Deploying SSIS Packages pt. 26:561 credit or ad
SQL Server Analysis Services9 lessons
- SSAS Basics pt. 16:421 credit or ad
- SSAS Basics pt. 26:491 credit or ad
- Installing SSAS pt. 16:251 credit or ad
- Installing SSAS pt. 26:081 credit or ad
- Connecting to SSAS2:231 credit or ad
- Configuring SSAS4:461 credit or ad
- SSAS Partitions7:051 credit or ad
- Processing6:271 credit or ad
- Processing Options5:551 credit or ad
Multidimensional Cubes22 lessons
- Organizational Data Evolution pt. 16:411 credit or ad
- Organizational Data Evolution pt. 25:281 credit or ad
- Determining Server Mode5:511 credit or ad
- Understanding Data Sources6:531 credit or ad
- Understanding the Data Source View4:311 credit or ad
- Creating a Data Source View pt. 16:501 credit or ad
- Creating a Data Source View pt. 25:231 credit or ad
- Configuring Dimensions6:551 credit or ad
- Configuring the Date Dimension5:461 credit or ad
- Creating a Cube5:071 credit or ad
- Understanding Hierarchies6:171 credit or ad
- Creating a Hierarchy5:431 credit or ad
- Attribute Relationships4:181 credit or ad
- Creating Attribute Relationships pt. 16:371 credit or ad
- Creating Attribute Relationships pt. 23:541 credit or ad
- Viewing the Cube in SSDT4:251 credit or ad
- Viewing the Cube in Excel5:411 credit or ad
- Calculated Members4:551 credit or ad
- Using a Calculated Member2:571 credit or ad
- KPIs5:121 credit or ad
- Creating a KPI4:171 credit or ad
- Viewing a KPI3:401 credit or ad
Multidimensional Queries5 lessons
Tabular Data Modeling15 lessons
- Installing SSAS Tabular6:441 credit or ad
- Connecting to the Tabular Instance4:421 credit or ad
- Creating a Tabular Project6:301 credit or ad
- Integrated Workspace6:471 credit or ad
- Building the Data Model pt. 16:461 credit or ad
- Building the Data Model pt. 25:261 credit or ad
- Creating Measures pt. 16:221 credit or ad
- Creating Measures pt. 24:071 credit or ad
- Managing Relationships5:041 credit or ad
- Creating Hierarchies4:021 credit or ad
- Deploying the Model3:361 credit or ad
- Using the Tabular Model3:161 credit or ad
- Creating a KPI6:211 credit or ad
- Using a KPI3:141 credit or ad
- DAX Basics5:361 credit or ad