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.

Get Access To Every Vision Training Course

Course Description

Our Microsoft SQL Server training course takes the hassle and financial burden out of heading back to the classroom. With our comprehensive approach, video instructor led training you’ll learn core concepts and gain essential hands-on experience in a fraction of the time.

Skills Covered in this online course

Microsoft has long been a leader in database technology and continues to be a dominant choice among many companies and users. This extensive online training series covers Microsoft SQL Server versions 2012 through 2019, which are still widely in use today and will give you the essential skills needed. In this training series, you will explore SQL Server administration, database design, analysis services, reporting services, PowerBI, and more. ITU’s SQL Server training is self-paced and covers all essential topics related to technology. You will learn about database security, indexing, query design optimization, data warehousing concepts, reporting services, business intelligence operations, and more. Upon successfully completing our SQL Server training series, you will have a strong understanding of Microsoft SQL Server database types and be able to use it in various professional settings.

This Online Course Training from ITU includes video lectures from industry experts that provide an in-depth look into the world of Microsoft SQL Server. There are also quizzes to help reinforce key concepts; quizzes can be taken multiple times and are all self-paced. The course is constantly updated to ensure the material is relevant and up-to-date with the newest version of Microsoft SQL Server.

What you will learn in the Online Microsoft SQL Server Training Course

Whether you are a beginner or an experienced user, this SQL Server training online course from ITU will give you the knowledge and skills necessary to use Microsoft SQL Server confidently and effectively. You will gain a comprehensive understanding of key topics related to the technology and have an opportunity to apply your newfound knowledge through hands-on labs and quizzes. After completing the course, you can demonstrate your expertise by earning certifications in various areas, such as database security and business intelligence operations. With ITU’s self-paced learning approach, you can progress at your own pace while gaining the confidence and SQL skills necessary to succeed in the Microsoft SQL Server environment. Sign up today and get started!

This bundle includes the following courses:

  • Introduction to Microsoft Power BI
  • Microsoft 70-461: Querying SQL Server 2012
  • Microsoft 70-462: Administering SQL Server 2012 Databases
  • Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012
  • Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases
  • Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012
  • Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012
  • Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012
  • Microsoft 70-764 SQL 2016 – Administering a SQL Database Infrastructure
  • Microsoft 70-765 SQL Server 2016 Provisioning SQL Databases
  • Microsoft SQL Server 2019 – Big Data
  • Microsoft SQL Server 2019 – Introduction to Data Analysis
  • Microsoft SQL Server 2019 – Querying SQL Server
  • Microsoft SQL Server 2019 Administration
  • Microsoft SQL Server 2019 Analysis Services (SSAS)
  • SQL Server 2019 Database Design

With over 180 hours of online training, the SQL Server training series is comprehensive and allows you to advance your skills in using the most popular and widely used database system. Join us today for this excellent series.

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

Vision Your Best Career
365
Price: $139 / YEAR

Gain unlimited access to our comprehensive IT training library featuring top certifications like CompTIA, Cisco, Microsoft, AWS, and more. Explore expert-led courses in cybersecurity, networking, cloud computing, project management, and soft skills development—all designed to help you build real-world, job-ready skills. With the 365 Training Pass, you can start learning today and accelerate your path to a successful IT career.

Sign Up for my 365 access pass today
  • 855-488-5327
  • customerservice@visiontrainingsystems.com

Navigate With Us

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