Get the Newest CompTIA A+ 2025 Course for Only $12.99

Get Offer

Microsoft Sql Server Training Series – 16 Courses – Deal

Course Level: Beginner
Duration: 190 Hrs 15 Min
Total Videos: 1,011 On-demand Videos

This SQL Server training series has it all. For years, Microsoft has been the go-to brand for database technology and it remains a top preference among many corporations and individual users alike. This comprehensive training series covers versions 2012 through 2019 of Microsoft SQL Server that are still extensively utilized at present. You will be given an in-depth look into SQL Server administration, database design, analysis services, reporting services, PowerBI and more during this learning program.

Buy An all access pass to over 3,000 hours of training

Course Description

This course series is ideal for IT professionals, data analysts, and developers who want to master Microsoft SQL Server and unlock powerful data capabilities. By the end, you’ll confidently manage databases, build efficient data models, and deliver actionable insights using tools like Power BI and SSAS in real-world roles.

In this comprehensive online program, you’ll gain hands-on experience across SQL Server administration, database design, querying, data warehousing, and reporting. The training covers versions from 2012 through 2019, ensuring you stay current with widely used environments while preparing you for modern BI workloads and cloud integration considerations. You’ll learn core concepts such as security, indexing, query design, and performance tuning, all through self-paced video lessons and practical labs.

What you’ll learn includes practical skills for database administration, designing scalable data solutions, and delivering intelligent reports. The curriculum emphasizes real-world applicability, enabling you to optimize performance, implement data warehousing concepts, and leverage reporting services and Power BI to drive business decisions. You’ll also build confidence through quizzes and hands-on exercises that reinforce your new capabilities in a predictable, paced format.

  • Hands-on mastery of SQL Server administration and database design
  • Ability to implement data warehousing concepts and BI workflows
  • Proficiency with SSAS and SSRS for analytical and reporting solutions
  • Experience with query optimization, indexing, and security best practices
  • Competence in deploying and managing SQL Server environments across versions 2012–2019

Join this program to gain a robust foundation in online Microsoft SQL Server training that fits a busy schedule. With self-paced delivery, you can advance at your own pace, reinforce learning with quizzes, and apply concepts through practical labs. Enroll today to elevate your database skills and prove your expertise with industry-recognized capabilities.

Who Benefits From This Course

Included In This Course

Module 1 - Query Tools

  •    1.1 Course Introduction
  •    1.2 Intro to Management Studio
  •    1.3 Intro to command-line query tools

Module 2 - Introduction to T-SQL Querying

  •    2.1 Introducing T-SQL
  •    2.2 Understanding Sets
  •    2.3 Understanding the Logical Order of Operations in SELECT statements

Module 3 - Basic SELECT Queries

  •    3.1 Writing Simple SELECT Statements
  •    3.2 Eliminate Duplicates with DISTINCT
  •    3.3 Using Column and Table Aliases
  •    3.4 Write Simple CASE Expressions

Module 4 - Querying Multiple Tables

  •    4.1 Understanding Joins
  •    4.2 Querying with Inner Joins
  •    4.3 Querying with Outer Joins
  •    4.4 Querying with Cross Joins and Self Joins

Module 5 - Sorting and Filtering Data

  •    5.1 Sorting Data
  •    5.2 Filtering Data with Predicates
  •    5.3 Filtering with the TOP and OFFSET-FETCH
  •    5.4 Working with Unknown Values

Module 6 - Introduction to Business Intelligence and Data Modeling

  •    6.1 Introduction to Business Intelligence
  •    6.2 The Microsoft Business Intelligence Platform
  •    6.3 Exploring a Data Warehouse
  •    6.4 Exploring a Data Model

Module 7 - Prepare Data

  •    7.1 Introduction to Power BI
  •    7.2 Get data from various data sources
  •    7.3 Preview source data

Module 8 - Clean, Transform, and Load Data

  •    8.1 Data Transformation Intro
  •    8.2 Transformation Example 1
  •    8.3 Transformation Example 2
  •    8.4 Transformation Example 3
  •    8.5 Transformation Example 4
  •    8.6 Transformation Example 5
  •    8.7 Transformation Example 6

Module 9 - Design a Data Model

  •    9.1 Introduction to Data Modeling
  •    9.2 Model Relationships
  •    9.3 Table Configuration
  •    9.4 Model interface
  •    9.5 Quick Measures
  •    9.6 Many-to-many relationships
  •    9.7 Row-level security

Module 10 - Create Model Calculations using DAX

  •    10.1 DAX context
  •    10.2 Calculated Tables
  •    10.3 Calculated Columns
  •    10.4 Managing Date Tables
  •    10.5 Measures
  •    10.6 Filter Manipulation
  •    10.7 Time Intelligence

Module 11 - Create Reports

  •    11.1 Basic Report Creation
  •    11.2 Example Page 1
  •    11.3 Example Page 2
  •    11.4 Example Page 3
  •    11.5 Report Publishing
  •    11.6 Enhancing Reports
  •    11.7 Drill-Through Pages
  •    11.8 Conditional Formatting
  •    11.9 Buttons and Bookmarks

Module 12 - Create Dashboards

  •    12.1 Dashboard Basics
  •    12.2 Real Time Dashboards
  •    12.3 Enhanced Dashboards

Module 13 - Create Paginated Reports

  •    13.1 Introduction to Power BI Report Builder
  •    13.2 Report Layouts
  •    13.3 Report Data
  •    13.4 Report Tables

Module 14 - Perform Advanced Analytics

  •    14.1 Introduction to Advanced Analytics
  •    14.2 Scatter Chart
  •    14.3 Forecast
  •    14.4 Decomposition Tree
  •    14.5 Key Influencers

Module 15 - Create and Manage Workspaces

  •    15.1 Introduction to Workspaces
  •    15.2 Working with Workspaces and the Portal

Module 16 - Create Power App Visuals

  •    16.1 Introduction to Power Apps Visual
  •    16.2 Creating the App
  •    16.3 Basic Power Apps Concepts
  •    16.4 Refreshing the Report

Module 17 - Analysis Services and Power BI

  •    17.1 Introduction to Analysis Services
  •    17.2 Connecting with Multidimensional Models
  •    17.3 Premium Workspaces and Analysis Services
  •    17.4 Course Wrap Up

Module 1 - Query Tools

  •    1.1 Course Introduction
  •    1.2 Module 1 Introduction
  •    1.3 Intro to Management Studio
  •    1.4 Intro to command-line query tools

Module 2 - Introduction to T-SQL Querying

  •    2.1 Module 2 Introduction
  •    2.2 Introducing T-SQL
  •    2.3 Understanding Sets
  •    2.4 Understanding the Logical Order of Operations in SELECT statements

Module 3 - Basic SELECT Queries

  •    3.1 Module 3 Introduction
  •    3.2 Writing Simple SELECT Statements
  •    3.3 Eliminate Duplicates with DISTINCT
  •    3.4 Using Column and Table Aliases
  •    3.5 Write Simple CASE Expressions

Module 4 - Querying Multiple Tables

  •    4.1 Module 4 Introduction
  •    4.2 Understanding Joins
  •    4.3 Querying with Inner Joins
  •    4.4 Querying with Outer Joins
  •    4.5 Querying with Cross Joins and Self Joins

Module 5 - Sorting and Filtering Data

  •    5.1 Module 5 Introduction
  •    5.2 Sorting Data
  •    5.3 Filtering Data with Predicates
  •    5.4 Filtering with the TOP and OFFSET-FETCH
  •    5.5 Working with Unknown Values

Module 6 - Working with SQL Server Data Types

  •    6.1 Module 6 Introduction
  •    6.2 Writing Queries that return Date and Time Data
  •    6.3 Writing Queries that use Date and Time Functions
  •    6.4 Writing Queries that return Character Data
  •    6.5 Writing Queries that use Character Functions

Module 7 - Using DML to Modify Data

  •    7.1 Module 7 Introduction
  •    7.2 Inserting Records with DML
  •    7.3 Updating Records Using DML
  •    7.4 Deleting Records Using DML

Module 8 - Using Built-In Functions

  •    8.1 Module 8 Introduction
  •    8.2 Writing Queries with Built-In Functions
  •    8.3 Using Conversion Functions
  •    8.4 Using Logical Functions
  •    8.5 Using Functions to Work with NULL

Module 9 - Grouping and Aggregating Data

  •    9.1 Module 9 Introduction
  •    9.2 Using Aggregate Functions
  •    9.3 Using the GROUP BY Clause
  •    9.4 Filtering Groups with HAVING

Module 10 - Using Subqueries

  •    10.1 Module 10 Introduction
  •    10.2 Writing Self-Contained Subqueries
  •    10.3 Writing Correlated Subqueries
  •    10.4 Using the EXISTS Predicate with Subqueries

Module 11 - Using Table Expressions

  •    11.1 Module 11 Introduction
  •    11.2 Using Views
  •    11.3 Using Inline Table-Valued Functions
  •    11.4 Using Derived Tables
  •    11.5 Using Common Table Expressions

Module 12 - Using Set Operators

  •    12.1 Module 12 Introduction
  •    12.2 Writing Queries with the UNION operator
  •    12.3 Using EXCEPT and INTERSECT
  •    12.4 Using APPLY

Module 13 - Using Window Ranking, Offset, and Aggregate Functions

  •    13.1 Module 13 Introduction
  •    13.2 Creating Windows with OVER
  •    13.3 Exploring Window Functions

Module 14 - Pivoting and Grouping Sets

  •    14.1 Module 14 Introduction
  •    14.2 Writing Queries with PIVOT and UNPIVOT
  •    14.3 Working with Grouping Sets

Module 15 - Implementing Error Handling

  •    15.1 Module Introduction
  •    15.2 Implementing T-SQL error handling
  •    15.3 Implementing structured exception handling

Module 16 - Managing Transactions

  •    16.1 Module 16 Introduction
  •    16.2 Transactions and the Database Engine
  •    16.3 Controlling Transactions
  •    16.4 Course Wrap Up

Module 1 - Designing and Building Tables

  •    1.1 Course Introduction
  •    1.2 Module 1 Introduction
  •    1.3 Introduction to Database Design
  •    1.4 Creating Tables
  •    1.5 Data Types
  •    1.6 Schemas
  •    1.7 Altering Tables

Module 2 - Enforcing Data Integrity

  •    2.1 Module 2 Introduction
  •    2.2 Introduction to Data Integrity
  •    2.3 Data Domain Integrity
  •    2.4 Implementing Data Domain Integrity
  •    2.5 Implementing Entity and Referential Integrity

Module 3 - Indexing

  •    3.1 Module 3 Introduction
  •    3.2 Core Indexing Concepts
  •    3.3 Heaps, Clustered, and Nonclustered Indexes
  •    3.4 Data Types and Indexes
  •    3.5 Single Column and Composite Indexes

Module 4 - Stored Procedures, Functions, and Triggers

  •    4.1 Module 4 Introduction
  •    4.2 Introduction to Database Programming
  •    4.3 Creating Stored Procedures
  •    4.4 Creating User-Defined Functions
  •    4.5 Creating Triggers

Module 5 - Blob and Filestream Data

  •    5.1 Module 5 Introduction
  •    5.2 Introduction to Binary Data
  •    5.3 Considerations for BLOB data
  •    5.4 FILESTREAM Example
  •    5.5 File Table Example

Module 6 - Full-Text Search

  •    6.1 Module 6 Introduction
  •    6.2 Introduction to Full-Text Search
  •    6.3 Full-Text Catalogs
  •    6.4 Full-Text Indexes
  •    6.5 Full-Text Queries

Module 7 - Azure vs On-Prem

  •    7.1 Module 7 Introduction
  •    7.2 SQL Server on Azure VM
  •    7.3 Azure Managed SQL Instance
  •    7.4 Azure SQL Database
  •    7.5 Course Wrap Up

Module 1 - Introduction to Business Intelligence and Data Modeling

  •    1.1 Course Introduction
  •    1.2 Module 1 Introduction
  •    1.3 Introduction to Business Intelligence
  •    1.4 The Microsoft Business Intelligence Platform
  •    1.5 Exploring a Data Warehouse
  •    1.6 Exploring a Data Model

Module 2 - Multidimensional Databases

  •    2.1 Module 2 Introduction
  •    2.2 Introduction to Multidimensional Analysis
  •    2.3 Overview of Cube Security
  •    2.4 Creating and Configuring a Cube
  •    2.5 Data Sources
  •    2.6 Data Source Views
  •    2.7 Adding a Dimension to a Cube

Module 3 - Cubes and Dimensions

  •    3.1 Module 3 Introduction
  •    3.2 Dimensions
  •    3.3 Attribute Hierarchies and Relationships
  •    3.4 Sorting and Grouping Attributes
  •    3.5 Slowly Changing Dimensions

Module 4 - Measures and Measure Groups

  •    4.1 Module 4 Introduction
  •    4.2 Measures
  •    4.3 Measure Groups and Relationships
  •    4.4 Measure Group Storage

Module 5 - Introduction to MDX

  •    5.1 Module 5 Introduction
  •    5.2 MDX Fundamentals
  •    5.3 Adding Calculations to a Cube
  •    5.4 Querying a cube using MDX

Module 6 - Customizing Cube Functionality

  •    6.1 Module 6 Introduction
  •    6.2 Key Performance Indicators
  •    6.3 Actions
  •    6.4 Perspectives
  •    6.5 Translations

Module 7 - Tabular Data Models

  •    7.1 Module 7 Introduction
  •    7.2 Introduction to Tabular Data Models
  •    7.3 Creating a Tabular Data Model
  •    7.4 Configure Relationships and Attributes
  •    7.5 Configuring Data Model for an Enterprise BI Solution

Module 8 - Data Analysis Expressions (DAX)

  •    8.1 Module 8 Introduction
  •    8.2 DAX Fundamentals
  •    8.3 Calculated Columns
  •    8.4 Relationships
  •    8.5 Measures
  •    8.6 Time Intelligence
  •    8.7 KPI
  •    8.8 Parent - Child Hierarchies

Module 9 - Data Mining

  •    9.1 Module 9 Introduction
  •    9.2 Overview of Data Mining
  •    9.3 Custom Data Mining Solutions
  •    9.4 Validating a Data Mining Model
  •    9.5 Consuming a Data Mining Model
  •    9.6 Course Wrap Up

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

Vision What’s Possible
Join today for over 50% off