Ready to start learning?

[ Course ]

Microsoft Sql Server Training Series – 16 Courses

Learn essential SQL Server skills to troubleshoot and optimize queries, ensuring accurate reports and dashboards with this comprehensive training series.

190 Hrs 15 Min1,011 Videos1,405 QuestionsCertificate of CompletionClosed Captions

Fixing a bad join is not glamorous work, but it is the kind of work that saves a report, a dashboard, or an entire payroll run. If you have ever written a query where the microsoft sql server left join returns all rows from left table documentation problem comes up because the output looks wrong, you already know the difference between “I think this query should work” and “I know exactly why it works.” That difference is what this Microsoft SQL Server Training Series is built to teach. I built this course to help you move from guessing at results to understanding how SQL Server actually behaves, especially when joins, filters, indexing, security, and reporting all start interacting in real systems.

This is an on-demand training bundle, so you can start immediately and work through the material on your own schedule. The scope is broad on purpose: administration, query writing, database design, data warehousing, reporting, business intelligence, and Power BI. That matters because SQL Server jobs are rarely siloed in the real world. A database analyst may need to tune a query in the morning, troubleshoot permissions after lunch, and verify a report definition before the end of the day. This training gives you the working knowledge to handle those moments without hand-waving.

What This Microsoft SQL Server Training Series Actually Teaches

This series is not just a tour of features. It is structured to make you competent in the parts of SQL Server that matter most on the job. You will learn how to query data correctly, administer databases safely, design schemas that hold up under pressure, and build reporting and business intelligence solutions that business users can trust. The included courses span SQL Server 2012 through SQL Server 2019 concepts, which is still a very practical range because many organizations run mixed environments or have not fully migrated to the newest release.

One thing I emphasize with students is that SQL Server knowledge is layered. You do not truly understand query writing until you understand the effects of indexes, cardinality, null handling, and join order. You do not really understand administration until you know how security, backup strategy, and performance monitoring connect. And you do not really understand BI until you can trace data from a source table into a warehouse, then into a report, then into a decision.

That is why the bundle includes:

Querying SQL Server with T-SQL
Database administration fundamentals and practical management tasks
Data warehouse design and implementation concepts
Database development and schema design practices
Business intelligence and reporting workflows
Introduction to Power BI for analysis and visualization

If you are coming in with existing experience, this course helps you tighten weak spots. If you are newer to SQL Server, it gives you the map you need so you do not learn in random fragments. The key is that you are not just memorizing syntax. You are learning how SQL Server thinks.

Understanding Joins, Filters, and the Real Behavior of Queries

This is where many people get tripped up, and frankly, this is where I want you to slow down and pay attention. A lot of users search for things like microsoft sql server left join where clause turns into inner join documentation because they write a LEFT JOIN, add a WHERE clause condition, and suddenly the result behaves like an INNER JOIN. That is not a SQL Server “bug.” It is the logical result of filtering out NULL-extended rows after the join has already happened. If you do not understand that distinction, you will write queries that look correct but silently remove the very rows you meant to preserve.

In this training, I treat joins as a subject worth mastering, not just skimming. You will learn the difference between INNER JOIN, LEFT JOIN, and other join types in practical terms. You will also learn how predicates in the WHERE clause can change the outcome, why moving a condition into the ON clause may preserve outer join behavior, and how to reason about query flow instead of guessing. That is the skill behind search phrases like sql server left join where clause turns into inner join documentation and microsoft sql server left join where clause behaves like inner join documentation.

Here is the real lesson: query design is not just syntax placement. It is logic. If you are writing reporting queries, support queries, or data extraction scripts, the ability to predict output is essential. In this course, you will build that habit through examples that connect theory to the data you actually see on screen.

A LEFT JOIN only protects unmatched rows until you filter them away. That one fact explains a surprising number of “missing record” problems in SQL Server.

T-SQL Skills You Will Use Every Week

Good T-SQL work is part language skill and part discipline. This course teaches you both. You will work through query construction, filtering, grouping, aggregation, subqueries, and performance-aware design decisions. You will also gain the kind of practical habits that make a query maintainable months later when someone else has to read it.

You will encounter topics that seem small but matter in production. For example, the trim function sql server is one of those details people ignore until a report fails because of extra spaces in a source system. Learning to clean and normalize strings correctly is not glamorous, but it prevents bad joins, incorrect comparisons, and messy output. The same is true for date handling, null logic, and string conversion. Those are not “beginner” topics. They are the foundation of reliable SQL.

You will also see the difference between t-sql vs sql server, which is an important distinction. T-SQL is the language you use to write queries and procedural logic. SQL Server is the database platform that executes those commands and provides the engines, services, security layers, and administrative tools around them. If you confuse the two, it becomes hard to troubleshoot problems or understand where a failure actually occurred.

By the end of this section of the training, you should be able to:

Write queries that return the data you intend, not just data that happens to appear
Use joins, aggregates, and filters correctly
Clean messy text values and handle nulls with confidence
Read and explain a query to another developer or analyst
Recognize when query logic, not data quality, is causing a bad result

Database Administration, Integrity, and Security

Administration is where many SQL Server learners realize the platform is bigger than query writing. A database can be technically functional and still be operationally risky if security, backups, recovery strategy, and constraints are poorly handled. This course gives you a grounded view of administration so you understand how to protect data and keep systems usable.

One of the most important concepts here is relational integrity. If you have ever wondered how to implement foreign keys in sql server to improve database integrity?, this training shows you why foreign keys are not just an academic feature. They prevent orphaned rows, enforce relationships between tables, and make your data model behave like a real business system instead of a pile of unrelated tables. When you apply constraints properly, you reduce bad data at the source instead of trying to repair it later with cleanup scripts.

You will also cover indexing and why it matters so much for both performance and maintenance. A poorly indexed table can turn a simple search into a painful scan. A badly designed security model can expose sensitive records to the wrong users. A weak backup plan can make a recoverable incident into a disaster. SQL Server administration is mostly about avoiding those expensive mistakes before they happen.

For people aiming toward database support, junior DBA, systems analyst, or SQL-focused developer roles, this material is especially valuable. Employers want people who can do more than run a query. They want someone who understands the consequences of the query.

Indexing, Usage Stats, and Performance Thinking

Performance work is where practical judgment matters more than mythology. Many people chase “faster SQL” by blindly adding indexes or rewriting queries without understanding what the server is already doing. In this course, you learn to think like someone who can measure rather than guess. That includes understanding usage patterns, table access behavior, and when an index actually helps versus when it just adds maintenance overhead.

One search query that comes up often is sys.dm_db_index_usage_stats last update time interpretation for sql server tables -filetype:txt -filetype:pdf -filetype:epub -filetype:doc -filetype:docx -filetype:xls -filetype:xlsx -filetype:ppt -filetype:csv -site:youtube.com -site:tiktok.com -site:ins. People are trying to determine whether an index is being used, whether maintenance is worthwhile, and how to interpret server-side usage data. That is exactly the kind of practical administration knowledge that separates a surface-level learner from someone who can support a live database.

In this training, you will learn how to think about indexing in relation to query patterns, table size, selectivity, and reporting workloads. You will also learn why usage statistics are useful but not absolute truth. A low-use index may still matter for a critical monthly process. A high-use index may still be a poor design if it creates too much write overhead. Real performance tuning requires context, not superstition.

This is also where the course helps you speak intelligently with developers and analysts. When someone says, “The database is slow,” you should be able to ask better questions: Which query? Which table? Which predicate? Which index? Which workload? That is the mindset you build here.

Data Warehousing and Business Intelligence Foundations

When you move into data warehousing and reporting, the conversation changes from “How do I store data?” to “How do I shape data so people can use it?” That is a much more strategic problem. This training covers data warehouse concepts, dimensional thinking, and the implementation choices that support reporting and analytics instead of transaction processing.

You will see how operational systems differ from reporting systems and why forcing one to behave like the other usually creates pain. Fact tables, dimension tables, ETL concepts, and reporting structures all matter because they determine whether your numbers are consistent and easy to interpret. A business intelligence environment is only useful if the underlying data is trustworthy and the logic is repeatable.

The reporting side of this bundle includes SQL Server Reporting Services concepts and business intelligence workflows, along with an introduction to Power BI. That combination matters because modern organizations rarely rely on a single reporting tool. They want SQL Server expertise on the back end and visualization skill on the front end. If you can understand how data flows from source system to warehouse to report to dashboard, you are much more valuable than someone who only knows one piece of the pipeline.

Typical roles that benefit here include:

BI developer
Data analyst
Reporting analyst
Database developer
SQL Server administrator
Junior data engineer

Salary varies by region and experience, but SQL Server-capable professionals commonly compete for roles ranging from the mid-$60,000s into six figures as responsibilities expand into BI, administration, and performance tuning. The real value is not the title; it is the range of problems you can solve.

Who This Course Is For and Where It Fits in Your Career

This series is for you if you want practical, job-relevant SQL Server knowledge without spending your time in a classroom waiting for someone else to catch up. It is especially useful if you are moving into a database-heavy role, supporting an existing SQL Server environment, or preparing to work more confidently with analysts, developers, and business users.

You should consider this course if you are:

Starting out in database administration or database development
Working in support and need stronger SQL troubleshooting skills
A developer who wants to write cleaner, faster, more reliable queries
An analyst who needs better reporting and data extraction skills
A BI professional who wants a stronger grasp of SQL Server foundations

What I like about a bundle like this is that it prevents the “one-topic trap.” Too many learners know just enough SQL to get through one task, then stall when they need to design a relationship, optimize a query, or explain a report result. This course helps you become adaptable. You will not only know how to make SQL Server do a thing; you will understand why it behaves the way it does and what to do when it does not cooperate.

How the On-Demand Format Helps You Learn Better

On-demand training is the right format when the material is technical and cumulative. SQL Server concepts build on each other, and you should be able to pause, replay, and revisit sections when you need to. That is much more effective than trying to keep pace in a room where the instructor has to move on whether you are ready or not.

This self-paced format lets you work the way real technical learning works: watch, test, get confused, try again, and then lock the concept in. That cycle is especially important for topics like joins, indexing, security, and data modeling. Those subjects are easy to recognize at a glance and harder to use correctly under pressure. Repetition is not a weakness here. It is the method.

For students who like structure, I recommend this approach:

Start with querying fundamentals and join logic.
Move into administration and integrity concepts.
Study indexing and performance with care.
Work through warehousing and BI topics once the relational basics feel solid.
Return to difficult sections and rewatch them with your own notes in front of you.

If you do that, you will get much more from the material than someone who tries to rush through it once and call it done. SQL Server rewards careful learners.

What You Should Be Able to Do After Completing the Series

After you finish this training, the goal is not simply to say you “saw” SQL Server topics. The goal is that you can function more confidently in a real environment. You should be able to build and explain queries, identify logical errors in join behavior, apply constraints that protect data, and understand how SQL Server supports administrative and reporting workflows.

More specifically, you should be able to:

Write T-SQL that returns accurate results in common business scenarios
Explain why a LEFT JOIN may stop behaving like a true outer join when filters are applied in the wrong place
Use SQL Server features to support integrity, security, and maintainability
Discuss the basics of warehouse design and reporting architecture
Recognize performance issues and begin troubleshooting them intelligently
Work more confidently with Power BI and SQL Server reporting workflows

If you are pursuing SQL-related work, these are the kinds of practical skills employers notice quickly. A hiring manager may not ask you to recite theory, but they will care whether you can explain why a query failed, why a report dropped rows, or why a table design created a maintenance problem. This course prepares you for those conversations.

SQL Server is a platform that rewards precision. If you learn the logic behind the tools, you become much harder to replace and much easier to trust. That is the real value of this training.

Microsoft® and Microsoft SQL Server are trademarks of Microsoft®. This content is for educational purposes.

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

1.1 Course Introduction
1.2 Module 1 Introduction
1.3 Introduction to Power BI
1.4 Get data from various data sources
1.5 Preview source data

Module 2 – Clean, Transform, and Load Data

2.1 Module 2 Introduction
2.2 DimEmployee Example
2.3 DimEmployeeSalesTerritory Example
2.4 DimReseller Example
2.5 FactResellersSales Example
2.6 ResellerSalesTargets Example
2.7 Color Formats Example

Module 3 – Design a Data Model

3.1 Module 3 Introduction
3.2 Introduction to Data Modeling
3.3 Model Relationships
3.4 Table Configuration
3.5 Model interface
3.6 Quick Measures
3.7 Many-to-many relationships
3.8 Row-level security

Module 4 – Create Model Calculations using DAX

4.1 Module 4 Introduction
4.2 DAX context
4.3 Calculated Tables
4.4 Calculated Columns
4.5 Managing Date Tables
4.6 Measures
4.7 Filter Manipulation
4.8 Time Intelligence

Module 5 – Create Reports

5.1 Module 5 Introduction
5.2 Basic Report Creation
5.3 Example Page 1
5.4 Example Page 2
5.5 Example Page 3
5.6 Report Publishing
5.7 Enhancing Reports
5.8 Drill-Through Pages
5.9 Conditional Formatting
5.10 Buttons and Bookmarks

Module 6 – Create Dashboards

6.1 Module 6 Introduction
6.2 Dashboard Basics
6.3 Real Time Dashboards
6.4 Enhanced Dashboards

Module 7 – Create Paginated Reports

7.1 Module 7 Introduction
7.2 Introduction to Power BI Report Builder
7.3 Report Layouts
7.4 Report Data
7.5 Report Tables

Module 8 – Perform Advanced Analytics

8.1 Module 8 Introduction
8.2 Introduction to Advanced Analytics
8.3 Scatter Chart
8.4 Forecast
8.5 Decomposition Tree
8.6 Key Influencers

Module 9 – Create and Manage Workspaces

9.1 Introduction to Workspaces
9.2 Working with Workspaces and the Portal

Module 10 – Create Power App Visuals

10.1 Module 10 Introduction
10.2 Introduction to Power Apps Visual
10.3 Creating the App
10.4 Basic Power Apps Concepts
10.5 Refreshing the Report

Module 11 – Analysis Services and Power BI

11.1 Module 11 Introduction
11.2 Introduction to Analysis Services
11.3 Connecting with Multidimensional Models
11.4 Premium Workspaces and Analysis Services
11.5 Course Wrap Up

Module 1: What are Big Data Clusters?

1.1 Introduction
1.2 Linux, PolyBase, and Active Directory
1.3 Scenarios

Module 2: Big Data Cluster Architecture

2.1 Introduction
2.2 Docker
2.3 Kubernetes
2.4 Hadoop and Spark
2.5 Components
2.6 Endpoints

Module 3: Deployment of Big Data Clusters

3.1 Introduction
3.2 Install Prerequisites
3.3 Deploy Kubernetes
3.4 Deploy BDC
3.5 Monitor and Verify Deployment

Module 4: Loading and Querying Data in Big Data Clusters

4.1 Introduction
4.2 HDFS with Curl
4.3 Loading Data with T-SQL
4.4 Virtualizing Data
4.5 Restoring a Database

Module 5: Working with Spark in Big Data Clusters

5.1 Introduction
5.2 What is Spark
5.3 Submitting Spark Jobs
5.4 Running Spark Jobs via Notebooks
5.5 Transforming CSV
5.6 Spark-SQL
5.7 Spark to SQL ETL

Module 6: Machine Learning on Big Data Clusters

6.1 Introduction
6.2 Machine Learning Services
6.3 Using MLeap
6.4 Using Python
6.5 Using R

Module 7: Create and Consume Big Data Cluster Apps

7.1 Introduction
7.2 Deploying, Running, Consuming, and Monitoring an App
7.3 Python Example – Deploy with azdata and Monitoring
7.4 R Example – Deploy with VS Code and Consume with Postman
7.5 MLeap Example – Create a yaml file
7.6 SSIS Example – Implement scheduled execution of a DB backup

Module 8: Maintenance of Big Data Clusters

8.1 Introduction
8.2 Monitoring
8.3 Managing and Automation
8.4 Course Wrap Up

Module 1: Installation

SQL Admin Intro
Installation

Module 2: Data Storage

Introduction to Data Storage with SQL Server
Managing Storage for System Databases
Managing Storage for User Databases
Moving Database Files

Module 3: Data Recover

Intro to Data Recovery
Understanding SQL Server Recovery Models
Planning a Backup Strategy
Backing up Databases and Transaction Logs
Using SSMS For Backup
Understanding the Restore Process
How to Restore a Database
Using SSMS For Restore
T-SQL Backup and Restore
Advanced Restore Scenarios
Introduction to Transferring Data
Importing and Exporting Table Data
Copying or Moving a Database

Module 4: Monitoring

Introduction to Monitoring SQL Server
Dynamic Management Views and Functions
Server Reports
System Performance Monitor
Tracing SQL Server Workload Activity
Extended Events
Database Tuning Advisor

Module 5: Security

Introduction to SQL Server Security
Managing Server-Level Security
Managing Database-Level Security
Row Level Security (RLS) Using Policies
Database Security Tools
Contained Database
Auditing Data Access in SQL Server
Implementing Transparent Data Encryption

Module 6: Maintenance

Introduction to Maintenance
Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance
Automating SQL Server Management
Monitoring SQL Server Errors
Configuring Database Mai

Module 1: Deploy a Microsoft Azure SQL Database

Introduction
Introducing the Azure SQL Database Part 1
Introducing the Azure SQL Database Part 2
Setting Up Azure Lab
Chose a Service Tier Part 1
Chose a Service Tier Part 2
Create Servers and Databases Part 1
Creating a Azure SQL Server and Database Lab
Create Servers and Databases Part 2
Create Servers and Databases Part 3
Connecting SSMS to Azure SQL Lab Part 1
Connecting SSMS to Azure SQL Lab Part 2
Create a Sysadmin Account
Creating Azure SQL Logins and Users Lab
Congure Elastic Pools
Creating and Conguring an Elastic Pool Lab

Module 2: Plan for SQL Server Installation

Plan for an IaaS or On-Premises Deployment Part 1
Plan for an IaaS or On-Premises Deployment Part 2
Select the Appropriate Size for a Virtual Machine
Plan Storage Pools Based on Performance Requirements Part 1
Plan Storage Pools Based on Performance Requirements Part 2
Evaluate Best Practices for Installation
Design a Storage Layout for a SQL Server Virtual Machine

Module 3: Deploy SQL Server Instances

Deploy a SQL Server Instance in IaaS and On-Premises
Restoring AdventureWorks 2016 Database Lab
Provision an Azure Virtual Machine to Host a SQL Server Instance
Provisioning an Azure Virtual Machine to Host a SQL Server Lab
Manually Install SQL Server on an Azure Virtual Machine
Installing SQL 2016 Lab Part 1
Installing SQL 2016 Lab Part 2
Automate the Deployment of SQL Server Databases
Exploring Azure SQL Database Automation Lab
Deploy SQL Server by Using Templates
Managing JSON Templates Lab

Module 4: Deploy SQL Server Databases to Azure Virtual Machines

Migrate an On-Premises SQL Server Database to an Azure Virtual Machine
Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 1
Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 2
Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 3
Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 4
Generate Benchmark Data for Performance Needs
Generating Benchmark Data Lab Part 1
Generating Benchmark Data Lab Part 2
Perform Performance Tuning on Azure IaaS
Perform Performance Tuning on Azure IaaS Lab Part 1
Perform Performance Tuning on Azure IaaS Lab Part 2
Support Availability Sets in Azure Part 1
Support Availability Sets in Azure Part 2
Manage High Availability Lab Part 1
Manage High Availability Lab Part 2
Manage High Availability Lab Part 3
Manage High Availability Lab Part 4
Manage High Availability Lab Part 5

Module 5: Configure Secure Access to Microsoft Azure SQL Databases

Configure Firewall Rules
Creating Firewall Rules Lab
Configure Always Encrypted for Azure SQL Database
Implementing Always Encrypted Lab
Configure Cell-Level Encryption
Cell-Level Encryption Lab
Configure Dynamic Data Masking
Dynamic Data Masking Lab
Configure Transparent Data Encryption (TDE)
Transparent Data Encryption (TDE) Lab

Module 6: Configure SQL Server performance settings

Configure SQL Performance Settings
Configuring SQL Performance Settings Lab
Configure Max Server Memory
Configuring SQL Memory Lab
Configure Database Performance Settings
Configure Database Performance Settings Lab
Configure Operators and Alerts
Configure alerts in Azure and On-Premise SQL Server Lab

Module 7: Manage SQL Server instances

Create Databases
Creating Databases Lab
Manage Files and File Groups
Managing Files and File Groups Lab
Manage System Database Files
Manage System Database Files Lab
Configure tempdb
Configure tempdb Lab

Module 8: Manage SQL Storage

Manage SMB File Shares
Manage SMB File Shares Lab
Manage Stretch Databases
Configure Azure Storage
Change Service Tiers
Change Service Tiers Lab Part 1
Review Wait Statistics
Manage Storage Pools
Recover from Failed Storage
Managing Storage Lab Part 1
Managing Storage Lab Part 2

Module 9: Perform Database Maintenance

Monitoring Tools
Using Monitoring Tools Lab Part 1
Using Monitoring Tools Lab Part 2
Azure Performance Tuning
Automate Maintenance Tasks
Update Statistics and Indexes
Update Statistics and Indexes Lab Part 1
Update Statistics and Indexes Lab Part 2
Verify Database Integrity
Verify Database Integrity Lab
Recover from Database Corruption
Recover from Database Corruption Lab
Conclusion

Module 1: Configure Encryption

Introduction
Exam Objectives and Lab Setup
Restoring AdventureWorks 2016 Database Lab Part 1
Restoring AdventureWorks 2016 Database Lab Part 2
Restoring AdventureWorks 2016 Database Lab Part 3
Configure Encryption
Cell-Level Encryption Part 1
Cell-Level Encryption Part 2
Cell-Level Encryption Lab Part 1
Cell-Level Encryption Lab Part 2
Transparent Data Encryption
Transparent Data Encryption Lab
Always Encrypted
Always Encrypted Lab
Backup Encryption
Backup Encryption Lab
Connection Encryption
Encryption Troubleshooting

Module 2: Configure Data Access and Permissions

Create and Maintain Users
Create and Maintain Users Lab Part 1
Create and Maintain Users Lab Part 2
Configure and Maintain Custom Roles
Configure and Maintain Custom Roles Lab
Manage Database Object Permissions Part 1
Manage Database Object Permissions Part 2
Manage Database Object Permissions Lab Part 1
Manage Database Object Permissions Lab Part 2
Configure User Options for Azure SQL Database
Configure Row-Level Security
Configure Dynamic Data Masking
Configure Dynamic Data Masking Lab

Module 3: Configure Auditing

Manage a SQL Server Audit
Manage a SQL Server Audit Lab
Query the SQL Server Audit Log
Manage an Azure SQL Server Audit

Module 4: Develop a Backup Strategy

Backup Types Part 1
Backup Types Part 2
Manage, Backup, and Restore Databases Lab Part 1
Manage, Backup, and Restore Databases Lab Part 2
Backup Very Large Databases Part 1
Backup Very Large Databases Part 2
Backup Very Large Databases Part 3
Backup Very Large Databases Part 4
4.9 Managing Very Large Databases Lab Part 1
4.10 Managing Very Large Databases Lab Part 2
4.11 Managing Very Large Databases Lab Part 3
Configure Alerting for Failed Backups
Configure Alerting for Failed Backups Lab Part 1
Configure Alerting for Failed Backups Lab Part 2
Back up Databases to Azure
Manage Transaction Log Backups
Configure Database Recovery Models
Set Database Recovery Model Lab
Configure Backup Automation
Configure Backup Automation Lab

Module 5: Restore Databases

Perform Piecemeal Restores
Restore Databases Lab Part 1
Restore Databases Lab Part 2
Restore Databases Lab Part 3
Perform Page Recovery
Perform Point-in-Time Recovery
Perform Point-in-Time Recovery Lab
Restore File Groups
Develop a Plan to Automate and Test Restores

Module 6: Manage Database Integrity

Implement Database Consistency Checks
Implement Database Consistency Checks Lab
Identify Database Corruption
Recover From Database Corruption

Module 7: Monitor Database Activity

Monitor Current Sessions
Monitor Current Sessions Lab
Identify Sessions that Cause Blocking Activity
Identify Sessions that Consume tempdb Resources
Configure the Data Collector

Module 8: Monitor Queries

Manage the Query Store
Manage the Query Store Lab
Configure Extended Events and Trace Events
Identify Problematic Execution Plans

Module 9: Manage Indexes

Identify and Repair Index Fragmentation
Identify and Create Missing Indexes
Identify and Drop Underutilized Indexes
Manage Existing Columnstore Indexes Part 1
Manage Existing Columnstore Indexes Part 2
Partitioned Tables

Module 10: Monitor SQL Server Instances

Create and Manage Operators
Create and Manage SQL Agent Alerts
Configure Policy-Based Management
Configure Policy-Based Management Lab
Identify Available Space on Data Volumes
Identify the Cause of- Manage Performance Degradation
Identify the Cause of- Manage Performance Degradation Lab Part 1
Identify the Cause of- Manage Performance Degradation Lab Part 2

Module 11: Implement Log Shipping

Configure and Monitor Log Shipping
Configure and Monitor Log Shipping Lab Part 1
Configure and Monitor Log Shipping Lab Part 2

Module 12: Implement Failover Cluster Instances

Windows Server Failover Cluster
Manage Shared Disks
Configure Cluster Shared Volumes
Configuring WSFC Lab

Module 13: Implement Always On Availability Groups

Database Mirroring
Create an Availability Group
Manage Failover
Configure Read-Only Routing
Create Distributed Availability Groups
Configuring Always On Availability Group Lab Part 1
Configuring Always On Availability Group Lab Part 2
Conclusion

Module 1: Intro To Business Intelligence

Introduction
The Business Intelligence Solution
Overview Of Business Intelligence
BI And Power Pivot Demo
ETL Intro
Designing Data Warehouses
Design For Speed
BI Semantic Model

Module 2: Database Essentials

Basic Database Objects Demo
Stored Procedures And Triggers Demo
Database Clusters Demo
SQL Server Management
Table Triggers
DB Config Options
DB Backup
DB Files And Restore

Module 3: Business Intelligence Development

Using SQL Server Data Tools Demo
Building An IS Integration Services Package Demo
Loading Data From Remote Sources Demo

Module 4: Business Intelligence Results

Report Building Intro Setup Demo
Using Report Builder Demo
Processing Data From Web Service Demo
Reporting From Multiple Tables Demo
Report Function And Matrix Demo
Interactive Reports Demo
Sorting Report Data Demo

Module 5: Advanced Reporting And Development

Drill Through Reports
Data Visualization
Creating Store Procedure From Scratch
Memory Optimize Table

Module 6: SQL Server Integration Services (SSIS)

Building Our First Integration Project
Data Transformation
Introduction To Big Data
Transformation Using Store Procedure
Transformation Using SSIS
Building Fact Table Using Store Procedure
Building Fact Table Using SSIS

Module 7: SQL Server 2014 New Features

Backup Enhancements
Index Enhancements
Online DB Enhancements
BackUp To The Cloud
Partition Data

Module 8: Course Review And Exam Prep

BI Review
SharePoint Overview
SharePoint Demo
Exam Prep
Before You Take The Exam
Conclusion

Module 1: Introduction To Business Intelligence And Data Modeling

Introduction To Business Intelligence and Data Modeling Part1
Introduction To Business Intelligence and Data Modeling Part2
The Microsoft Business Intelligence Platform Part 1
The Microsoft Business Intelligence Platform Part 2
The Microsoft Business Intelligence Platform Part 3
The Microsoft Business Intelligence Platform Part 4

Module 2: Implementing Reports The SQL Server Reporting Services

Implementing Reports the SQL Server Reporting Services Part 1
Implementing Reports the SQL Server Reporting Services Part 2
Implementing Reports the SQL Server Reporting Services Part 3
Implementing Reports the SQL Server Reporting Services Part 4
Implementing Reports the SQL Server Reporting Services Part 5
Implementing Reports the SQL Server Reporting Services Part 6
Implementing Reports the SQL Server Reporting Services Part 7
Implementing Reports the SQL Server Reporting Services Part 8

Module 3: Supporting Self Service Reporting

Supporting Self Service Reporting Part 1
Supporting Self Service Reporting Part 2

Module 4: Managing Report Execution And Delivery

Managing Report Execution And Delivery
Managing Report Execution
Subscriptions And Data Alerts

Module 5: Creating Multidimensional Databases

Creating Multidimensional Databases
Creating Data Sources And Data Source Views
Creating And Browsing a Cube

Module 6: Working With Cubes And Dimensions

Working with Cubes And Dimensions
Sorting And Grouping Attributes

Module 7: Working With Measures And Measure Groups

Working With Measures and Measure Groups

Module 8: Introduction To MDX

Introduction To MDX
Adding Calculations To A Cube

Module 9: Customizing Cube Functionality

Customizing Cube Functionality Part 1
Customizing Cube Functionality Part 2
Customizing Cube Functionality Part 3

Module 10: Implementing A Tabular Data Model

Implementing A Tabular Data Model Part 1
Implementing A Tabular Data Model Part 2

Module 11: Introduction To DAX

Introduction to DAX
Demonstration Making A Tabular Model Part 1
Demonstration Making A Tabular Model Part 2
Using DAX

Module 12: Implementing An Analysis Services Tabular Data Model

Implementing An Analysis Services Tabular Data Model Part 1
Implementing An Analysis Services Tabular Data Model Part 2
Deploying A Tabular Data Model

Module 13: SQL Analysis Services

SQL Analysis Services Part 1
SQL Analysis Services Part 2

Module 14: Creating Data Visualizations With Power View

Creating Data Visualizations With Power View

Module 15: Supporting Self Service Reporting

Supporting Self Service Reporting

Module 16: Performing Predictive Analysis With Data Mining

Performing Predictive Analysis With Data Mining
Using The Data Mining Wizard

Module 17: Predictive Analytics

Predictive Analytics Part 1
Predictive Analytics Part 2

Module 1: Designing A Database Server Infrastructure

Introduction
Designing A Database Server Infrastructure-Part1
Designing A Database Server Infrastructure-Part2
Designing A Database Server Infrastructure-Part3
Designing A Database Server Infrastructure-Part4
Considerations For Database Server Consolidation
Managing Server Resources

Module 2: Designing A Logical Database Scheme

Designing A Logical Database Scheme-Part1
Designing A Logical Database Scheme-Part2
Designing A Logical Database Scheme-Part3
Designing A Logical Database Scheme-Part4
Designing A Logical Database Scheme-Part5

Module 3: Designing A Physical Database Implementation

Designing A Physical Database Implementation-Part1
Designing A Physical Database Implementation-Part2
Designing A Physical Database Implementation-Part3

Module 4: Incorporating Data Files Into the Database

Incorporating Data Files Into The Database-Part1
Incorporating Data Files Into The Database-Part2
Incorporating Data Files Into The Database-Part3
Incorporating Data Files Into The Database Demo
Searching Data Files
Searching Data Files Demo

Module 5: Tuning Database Performance

Tuning Database Performance-Part1
Tuning Database Performance-Part2
Tuning Database Performance-Part3
Working With Query Plans-Part1
Working With Query Plans-Part2
Working With Query Plans-Part3
Working With Query Plans-Part4

Module 6: Designing Database Security

Designing Database Security-Part1
Designing Database Security-Part2
Contained Databases
Protecting Data With Encryption

Module 7: Policy Based Management

Policy Based Management
Policy Based Management Demo

Module 8: Monitoring Server Health

Monitoring Server Health
Monitoring Server Health Demo

Module 9: Designing Database Backup Solution

Designing Database Backup Solution-Part1
Designing Database Backup Solution-Part2
Designing Database Backup Solution-Part3
Designing Database Backup Solution-Part4
Disaster Recovery Plan-Part1
Disaster Recovery Plan-Part2

Module 10: Automating Multi Server Maintenance

Automating Multi Server Maintenance
Managing Multiple Servers

Module 11: Managing SQL Server With Windows Powershell

Managing SQL Server WIth Windows Powershell
Windows Powershell Lab

Module 12: Replicating Data

Replicating Data-Part1
Replicating Data-Part2
Replicating Data-Part3

Module 13: Planning High Availability

Planning High Availability-Part1
Planning High Availability-Part2

Module 14: Review of SQL Statements

Review Of SQL Statements-Part1
Review Of SQL Statements-Part2
Review Of SQL Statements-Part3

Module 15: Eleven Rules of Database Design

Eleven Rules Of Database Design
Conclusion

Module 1: SQL 2012 And The 464 Test

Introduction
Intro To SQL Server 2012-Part1
Intro To SQL Server 2012-Part2
Management Studio Demo-Part1
Management Studio Demo-Part2
Management Studio Demo-Part3
Other SQL Server Tools

Module 2: Working With Data Types

Working With Data Types-Part1
Working With Data Types-Part2
Working With Data Types-Part3
Other Data Types

Module 3: Tables

Tables
Creating Tables

Module 4: Data Constraints

Data Constraints-Part1
Data Constraints-Part2

Module 5: Planning In Indexing

Planning In Indexing-Part1
Planning In Indexing-Part2
Planning In Indexing-Part3
Planning In Indexing-Part4

Module 6: Table Structures

Table Structures
Working With Clustered Indexes
Clustered Indexes
Designing Effective Clustered Indexes

Module 7: Improving Performance with Non-Clustered Indexes

Improving Performance With Non-Clustered Indexes-Part1
Improving Performance With Non-Clustered Indexes-Part2
Improving Performance With Non-Clustered Indexes-Part3

Module 8: Using Indexes And Execution Plans

Using Indexes
Execution Plans-Part1
Execution Plans Demo
Execution Plans-Part2

Module 9: Working with Views

Working With Views-Part1
Working With Views-Part2

Module 10: Designing and Implementing Stored Procedures

Designing And Implementing Stored Procedures-Part1
Designing And Implementing Stored Procedures-Part2
Designing And Implementing Stored Procedures-Part3

Module 11: Merging Data and Passing Tables

Merging Data And Passing Tables-Part1
Merging Data And Passing Tables-Part2
Merging Data And Passing Tables-Part3

Module 12: Designing and Implementing User Functions

Designing And Implementing User Functions

Module 13: Creating Highly Concurrent SQL Server Applications

Creating Highly Concurrent SQL Server Applications-Part1
Creating Highly Concurrent SQL Server Applications-Part2
Creating Highly Concurrent SQL Server Applications-Part3

Module 14: Handling Errors in T-SQL

Handling Error InT-SQL-Part1
Handling Error InT-SQL-Part2

Module 15: Triggers

Triggers

Module 16: Implementing Managed Code

Implementing Managed Code-Part1
Implementing Managed Code-Part2
Implementing Managed Code-Part3
Implementing Managed Code-Part4

Module 17: Storing XML in SQL

Storing XML In SQL-Part1
Storing XML In SQL-Part2

Module 18: Querying XML

Querying XML-Part1
Querying XML-Part2

Module 19: Working with the Spatial Data

Working With Spatial Data-Part1
Working With Spatial Data-Part2
Working With Spatial Data-Part3

Module 20: Working With Full-Text Indexes and Queries

Working With Full-Text Indexes And Queries-Part1
Working With Full-Text Indexes And Queries-Part2
Working With Full-Text Indexes And Queries-Part3

Lesson 1: Getting Started with SQL Server 2012

Course Introduction

Lesson 2: Working with T-SQL

Creating Queries-Part 1
Creating Queries-Part 2
Creating Queries-Part 3
Creating Queries-Part 4
Creating Queries-Part 5
Constraints-Part 1
Constraints-Part 2
Constraints-Part 3
Constraints-Part 4
Constraints-Part 5

Lesson 3: Writing SELECT Queries

Select Statement-Part 1
Select Statement-Part 2
Select Statement-Part 3
Select Statement-Part 4

Lesson 4: Working with SQL Data Types

Data Types-Part 1
Data Types-Part 2
Data Types-Part 3
Data Types-Part 4
Data Types-Part 5
Data Types-Part 6
Data Types-Part 7
Data Types-Part 8
Data Types-Part 9
Data Types-Part 10

Lesson 5: Sorting and Filtering Data

Sorting Results-Part 1
Sorting Results-Part 2
Sorting Results-Part 3
Sorting Results-Part 4
Sorting Results-Part 5
Sorting Results-Part 6

Lesson 6: Querying Data from Multiple Tables

Tables Part 1
Tables Part 2
Tables Part 3
Tables Part 4
Tables Part 5
Tables Part 6

Lesson 7: Modifying Data

Inserting Data-Part 1
Inserting Data-Part 2
Inserting Data-Part 3
Inserting Data-Part 4
Inserting Data-Part 5
Inserting Data-Part 6

Lesson 8: Working with SQL Server Built-in Functions

Functions
Parse
Logical Functions
Group By

Lesson 9: Programming in T-SQL

Programming-Part 1
Programming-Part 2
Programming-Part 3
Programming-Part 4
Programming-Part 5
Programming-Part 6

Lesson 10: Implementing Stored Procedures

Storage Procedures-Part 1
Storage Procedures-Part 2
Dynamic SQL-Part 1
Dynamic SQL-Part 2

Lesson 11: Working with Subqueries and Table Expressions

Sub-Queries And Table Expressions-Part 1
Sub-Queries And Table Expressions-Part 2
Sub-Queries And Table Expressions-Part 3
Sub-Queries And Table Expressions-Part 4

Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions

Set Operators-Part 1
Set Operators-Part 2
Window Functions-Part 1
Window Functions-Part 2
User Defined Functions-Part 1
User Defined Functions-Part 2
Advanced Analytical Functions

Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets

Pivot
Grouping Sets

Lesson 14: Managing Error Handling and Transactions

Error Handling-Part 1
Error Handling-Part 2
Manage Transactions-Part 1
Manage Transactions-Part 2
Manage Transactions-Part 3

Lesson 15: Querying SQL Server System

System Databases-Part 1
System Databases-Part 2
System Databases-Part 3
System Databases-Part 4

Lesson 16: Optimizing Query Performance

Query Planning-Part 1
Query Planning-Part 2
Index-Part 1
Index-Part 2
Index-Part 3

Lesson 1: Identifying the SQL Server Platform

Overview
DataStorage-Part 1
DataStorage-Part 2

Lesson 2: Deploying SQL Server

Install-Part 1
Install-Part 2

Lesson 3: Configuring SQL Server

Configuring-Part 1
Configuring-Part 2
Changing Memory-Part 1
Changing Memory-Part 2
Email-Part 1
Email-Part 2

Lesson 4: Managing Databases in SQL Server 2012

User Databases-Part 1
User Databases-Part 2
User Databases-Part 3
User Databases-Part 4
User Databases-Part 5

Lesson 5: Managing SQL Server Security

Setting Security-Part 1
Setting Security-Part 2
Server Roles-Part 1
Server Roles-Part 2
Setting Permissions-Part 1
Setting Permissions-Part 2

Lesson 6: Implementing Advanced Security Settings

Querying Data From Multiple Tables-Part 1
Querying Data From Multiple Tables-Part 2
Querying Data From Multiple Tables-Part 3
Querying Data From Multiple Tables-Part 4
Querying Data From Multiple Tables-Part 5

Lesson 7: Applying Encryption and Compression

Encrypting And Compressing-Part 1
Encrypting And Compressing-Part 2
Encrypting And Compressing-Part 3

Lesson 8: Working with Indexes and Log Files

Functions-Part 1
Functions-Part 2
Functions-Part 3
Functions-Part 4
Functions-Part 5
Functions-Part 6

Lesson 9: Working with Backup and Restore

Managing Backups-Part 1
Managing Backups-Part 2
Managing Backups-Part 3
Managing Backups-Part 4
Managing Backups-Part 5
Managing Backups-Part 6
Managing Backups-Part 7

Lesson 10: Implementing High Availability

Stored Procedures-Part 1
Stored Procedures-Part 2
Stored Procedures-Part 3
Stored Procedures-Part 4

Lesson 11: Optimizing Server Performance

Managing SQL Performance-Part 1
Managing SQL Performance-Part 2
Managing SQL Performance-Part 3
Managing SQL Performance-Part 4
Managing SQL Performance-Part 5
Managing SQL Performance-Part 6
Managing SQL Performance-Part 7

Lesson 12: Troubleshooting Issues and Recovering Databases

Set Operators-Part 1
Set Operators-Part 2
Set Operators-Part 3
Set Operators-Part 4
Set Operators-Part 5

Lesson 13: Performing Advanced Database Management Tasks

Managing Database Infrastructures-Part 1
Managing Database Infrastructures-Part 2
Managing Database Infrastructures-Part 3

Lesson 1: Introduction to Data Warehouse

Introduction
Introduction To Data Warehouse-Part1
Introduction To Data Warehouse-Part2
Introduction To Data Warehouse-Part3
Introduction To Data Warehouse-Part4
Introduction To Data Warehouse-Part5
Introduction To Data Warehouse-Part6

Lesson 2: Creating Dimensions and Changing Granularity of Dimensions

Creating Dimensions And Changing Granularity Of Dimensions-Part1
Creating Dimensions And Changing Granularity Of Dimensions-Part2
Creating Dimensions And Changing Granularity Of Dimensions-Part3
Creating Dimensions And Changing Granularity Of Dimensions-Part4
Creating Dimensions And Changing Granularity Of Dimensions-Part5
Creating Dimensions And Changing Granularity Of Dimensions-Part6

Lesson 3: Creating Fact Tables and ColumnStore Indexes

Creating Fact Tables And Column Store Indexes-Part1
Creating Fact Tables And Column Store Indexes-Part2
Creating Fact Tables And Column Store Indexes-Part3
Creating Fact Tables And Column Store Indexes-Part4
Creating Fact Tables And Column Store Indexes-Part5

Lesson 4: Implementing Data Warehouse in SQL Server 2012

Implementing Data Warehouse-Part1
Implementing Data Warehouse-Part2
Implementing Data Warehouse-Part3
Implementing Data Warehouse-Part4

Lesson 5: Working with Integration Services

Working With Integration Services-Part1
Working With Integration Services-Part2
Working With Integration Services-Part3
Working With Integration Services-Part4
Working With Integration Services-Part5
Working With Integration Services-Part6

Lesson 6: Managing Control Flow

Managing Control Flow-Part1
Managing Control Flow-Part2
Managing Control Flow-Part3
Managing Control Flow-Part4
Managing Control Flow-Part5

Lesson 7: Working with Dynamic Variables

Working With Dynamic Variables-Part1
Working With Dynamic Variables-Part2
Working With Dynamic Variables-Part3
Working With Dynamic Variables-Part4
Working With Dynamic Variables-Part5
Working With Dynamic Variables-Part6
Working With Dynamic Variables-Part7
Working With Dynamic Variables-Part8

Lesson 8: Implementing Data Flow

Implementing DataFlow-Part1
Implementing DataFlow-Part2
Implementing DataFlow-Part3
Implementing DataFlow-Part4
Implementing DataFlow-Part5
Implementing DataFlow-Part6
Implementing DataFlow-Part7
Implementing DataFlow-Part8

Lesson 9: Managing Data Flow

Managing DataFlow-Part1
Managing DataFlow-Part2
Managing DataFlow-Part3
Managing DataFlow-Part4

Lesson 10: Managing SSIS Package Execution

Managing SSIS Package Execution-Part1
Managing SSIS Package Execution-Part2
Managing SSIS Package Execution-Part3
Managing SSIS Package Execution-Part4
Managing SSIS Package Execution-Part5
Managing SSIS Package Execution-Part6

Lesson 11: Debugging and Troubleshooting

Debugging And Troubleshooting-Part1
Debugging And Troubleshooting-Part2
Debugging And Troubleshooting-Part3
Debugging And Troubleshooting-Part4

Lesson 12: Deploying Packages

Deploying Packages-Part1
Deploying Packages-Part2
Deploying Packages-Part3

Lesson 13: Securing Packages and Databases

Securing Packages And Databases-Part1
Securing Packages And Databases-Part2

Lesson 14: Working with MDS and Windows

Working With MDS And Windows Azure

This course is included in all of our team and individual training plans. Choose the option that works best for you.

[ Team Training ]

Enroll My Team.

Give your entire team access to this course and our full training library. Includes team dashboards, progress tracking, and group management.

Get Team Pricing

[ Individual Plans ]

Choose a Plan.

Get unlimited access to this course and our entire library with a monthly, quarterly, annual, or lifetime plan.

View Individual Plans

[ FAQ ]

Frequently Asked Questions.

What are the key benefits of taking the Microsoft SQL Server Training Series?

This training series is designed to enhance your understanding of SQL Server, focusing on practical skills like fixing complex joins and optimizing queries. By completing these courses, you’ll gain the ability to troubleshoot and correct common issues that can impact reporting and data accuracy.

Additionally, the series covers a broad range of topics from basic query writing to advanced optimization techniques. This comprehensive approach ensures that you’ll develop both foundational knowledge and specialized skills, making you more effective in managing SQL Server databases and improving overall data integrity.

Will this training series help me prepare for specific SQL Server certifications?

While the series is primarily focused on practical skills and real-world troubleshooting, it also aligns well with the knowledge required for various Microsoft SQL Server certifications. Courses cover core concepts like joins, indexing, and query optimization, which are often tested in certification exams.

However, to maximize your exam readiness, it’s recommended to supplement this series with official certification guides and practice exams. This approach ensures you are well-prepared for certification-specific questions and the exam environment.

Is prior experience with SQL Server necessary to benefit from this series?

Some basic familiarity with SQL and database concepts is helpful, but this series is designed to accommodate learners at various levels. Beginners can start with foundational courses that cover core SQL syntax and database principles.

For those with more experience, the series offers advanced topics like query tuning and troubleshooting complex joins. Regardless of your starting point, the courses are structured to build your skills progressively, ensuring you gain practical knowledge applicable to real-world scenarios.

What specific topics related to SQL joins does this training cover?

This training series delves into various types of SQL joins, including inner joins, left joins, right joins, and full outer joins. It emphasizes understanding how each join type affects data retrieval and report accuracy.

Students learn to identify common join issues, such as missing data or duplicated rows, and how to fix them. The courses also explore best practices for writing efficient joins and avoiding common pitfalls that can lead to incorrect query results or poor performance.

How does fixing bad joins improve overall data reporting and analysis?

Fixing bad joins ensures that data retrieved from multiple tables accurately reflects the underlying relationships. Incorrect joins can lead to missing data, duplicate records, or misleading totals, which compromise report integrity.

By mastering join troubleshooting, you’ll be able to deliver more reliable reports, dashboards, and data insights. This skill is critical in environments where precise data analysis impacts business decisions, payroll processing, or regulatory compliance.

Ready to start learning?

Individual Plans →Team Plans →