Module 1 - Query Tools
Module 2 - Introduction to T-SQL Querying
Module 3 - Basic SELECT Queries
Module 4 - Querying Multiple Tables
Module 5 - Sorting and Filtering Data
Module 6 - Introduction to Business Intelligence and Data Modeling
Module 7 - Prepare Data
Module 8 - Clean, Transform, and Load Data
Module 9 - Design a Data Model
Module 10 - Create Model Calculations using DAX
Module 11 - Create Reports
Module 12 - Create Dashboards
Module 13 - Create Paginated Reports
Module 14 - Perform Advanced Analytics
Module 15 - Create and Manage Workspaces
Module 16 - Create Power App Visuals
Module 17 - Analysis Services and Power BI

Module 1 - Query Tools
Module 2 - Introduction to T-SQL Querying
Module 3 - Basic SELECT Queries
Module 4 - Querying Multiple Tables
Module 5 - Sorting and Filtering Data
Module 6 - Working with SQL Server Data Types
Module 7 - Using DML to Modify Data
Module 8 - Using Built-In Functions
Module 9 - Grouping and Aggregating Data
Module 10 - Using Subqueries
Module 11 - Using Table Expressions
Module 12 - Using Set Operators
Module 13 - Using Window Ranking, Offset, and Aggregate Functions
Module 14 - Pivoting and Grouping Sets
Module 15 - Implementing Error Handling
Module 16 - Managing Transactions

Module 1 - Designing and Building Tables
Module 2 - Enforcing Data Integrity
Module 3 - Indexing
Module 4 - Stored Procedures, Functions, and Triggers
Module 5 - Blob and Filestream Data
Module 6 - Full-Text Search
Module 7 - Azure vs On-Prem

Module 1 - Introduction to Business Intelligence and Data Modeling
Module 2 - Multidimensional Databases
Module 3 - Cubes and Dimensions
Module 4 - Measures and Measure Groups
Module 5 - Introduction to MDX
Module 6 - Customizing Cube Functionality
Module 7 - Tabular Data Models
Module 8 - Data Analysis Expressions (DAX)
Module 9 - Data Mining

Module 1 - Prepare Data
Module 2 - Clean, Transform, and Load Data
Module 3 - Design a Data Model
Module 4 - Create Model Calculations using DAX
Module 5 - Create Reports
Module 6 - Create Dashboards
Module 7 - Create Paginated Reports
Module 8 - Perform Advanced Analytics
Module 9 - Create and Manage Workspaces
Module 10 - Create Power App Visuals
Module 11 - Analysis Services and Power BI

Module 1: What are Big Data Clusters?
Module 2: Big Data Cluster Architecture
Module 3: Deployment of Big Data Clusters
Module 4: Loading and Querying Data in Big Data Clusters
Module 5: Working with Spark in Big Data Clusters
Module 6: Machine Learning on Big Data Clusters
Module 7: Create and Consume Big Data Cluster Apps
Module 8: Maintenance of Big Data Clusters

Module 1: Installation
Module 2: Data Storage
Module 3: Data Recover
Module 4: Monitoring
Module 5: Security
Module 6: Maintenance

Module 1: Deploy a Microsoft Azure SQL Database
Module 2: Plan for SQL Server Installation
Module 3: Deploy SQL Server Instances
Module 4: Deploy SQL Server Databases to Azure Virtual Machines
Module 5: Configure Secure Access to Microsoft Azure SQL Databases
Module 6: Configure SQL Server performance settings
Module 7: Manage SQL Server instances
Module 8: Manage SQL Storage
Module 9: Perform Database Maintenance

Module 1: Configure Encryption
Module 2: Configure Data Access and Permissions
Module 3: Configure Auditing
Module 4: Develop a Backup Strategy
Module 5: Restore Databases
Module 6: Manage Database Integrity
Module 7: Monitor Database Activity
Module 8: Monitor Queries
Module 9: Manage Indexes
Module 10: Monitor SQL Server Instances
Module 11: Implement Log Shipping
Module 12: Implement Failover Cluster Instances
Module 13: Implement Always On Availability Groups

Module 1: Intro To Business Intelligence
Module 2: Database Essentials
Module 3: Business Intelligence Development
Module 4: Business Intelligence Results
Module 5: Advanced Reporting And Development
Module 6: SQL Server Integration Services (SSIS)
Module 7: SQL Server 2014 New Features
Module 8: Course Review And Exam Prep

Module 1: Introduction To Business Intelligence And Data Modeling
Module 2: Implementing Reports The SQL Server Reporting Services
Module 3: Supporting Self Service Reporting
Module 4: Managing Report Execution And Delivery
Module 5: Creating Multidimensional Databases
Module 6: Working With Cubes And Dimensions
Module 7: Working With Measures And Measure Groups
Module 8: Introduction To MDX
Module 9: Customizing Cube Functionality
Module 10: Implementing A Tabular Data Model
Module 11: Introduction To DAX
Module 12: Implementing An Analysis Services Tabular Data Model
Module 13: SQL Analysis Services
Module 14: Creating Data Visualizations With Power View
Module 15: Supporting Self Service Reporting
Module 16: Performing Predictive Analysis With Data Mining
Module 17: Predictive Analytics

Module 1: Designing A Database Server Infrastructure
Module 2: Designing A Logical Database Scheme
Module 3: Designing A Physical Database Implementation
Module 4: Incorporating Data Files Into the Database
Module 5: Tuning Database Performance
Module 6: Designing Database Security
Module 7: Policy Based Management
Module 8: Monitoring Server Health
Module 9: Designing Database Backup Solution
Module 10: Automating Multi Server Maintenance
Module 11: Managing SQL Server With Windows Powershell
Module 12: Replicating Data
Module 13: Planning High Availability
Module 14: Review of SQL Statements
Module 15: Eleven Rules of Database Design

Module 1: SQL 2012 And The 464 Test
Module 2: Working With Data Types
Module 3: Tables
Module 4: Data Constraints
Module 5: Planning In Indexing
Module 6: Table Structures
Module 7: Improving Performance with Non-Clustered Indexes
Module 8: Using Indexes And Execution Plans
Module 9: Working with Views
Module 10: Designing and Implementing Stored Procedures
Module 11: Merging Data and Passing Tables
Module 12: Designing and Implementing User Functions
Module 13: Creating Highly Concurrent SQL Server Applications
Module 14: Handling Errors in T-SQL
Module 15: Triggers
Module 16: Implementing Managed Code
Module 17: Storing XML in SQL
Module 18: Querying XML
Module 19: Working with the Spatial Data
Module 20: Working With Full-Text Indexes and Queries

Lesson 1: Getting Started with SQL Server 2012
Lesson 2: Working with T-SQL
Lesson 3: Writing SELECT Queries
Lesson 4: Working with SQL Data Types
Lesson 5: Sorting and Filtering Data
Lesson 6: Querying Data from Multiple Tables
Lesson 7: Modifying Data
Lesson 8: Working with SQL Server Built-in Functions
Lesson 9: Programming in T-SQL
Lesson 10: Implementing Stored Procedures
Lesson 11: Working with Subqueries and Table Expressions
Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions
Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets
Lesson 14: Managing Error Handling and Transactions
Lesson 15: Querying SQL Server System
Lesson 16: Optimizing Query Performance

Lesson 1: Identifying the SQL Server Platform
Lesson 2: Deploying SQL Server
Lesson 3: Configuring SQL Server
Lesson 4: Managing Databases in SQL Server 2012
Lesson 5: Managing SQL Server Security
Lesson 6: Implementing Advanced Security Settings
Lesson 7: Applying Encryption and Compression
Lesson 8: Working with Indexes and Log Files
Lesson 9: Working with Backup and Restore
Lesson 10: Implementing High Availability
Lesson 11: Optimizing Server Performance
Lesson 12: Troubleshooting Issues and Recovering Databases
Lesson 13: Performing Advanced Database Management Tasks

Lesson 1: Introduction to Data Warehouse
Lesson 2: Creating Dimensions and Changing Granularity of Dimensions
Lesson 3: Creating Fact Tables and ColumnStore Indexes
Lesson 4: Implementing Data Warehouse in SQL Server 2012
Lesson 5: Working with Integration Services
Lesson 6: Managing Control Flow
Lesson 7: Working with Dynamic Variables
Lesson 8: Implementing Data Flow
Lesson 9: Managing Data Flow
Lesson 10: Managing SSIS Package Execution
Lesson 11: Debugging and Troubleshooting
Lesson 12: Deploying Packages
Lesson 13: Securing Packages and Databases
Lesson 14: Working with MDS and Windows