Hot Deal • 16 Courses • 188+ Hours • Lifetime Access

Microsoft SQL Server Mega Training Series

Your complete Microsoft SQL Server training begins here! Microsoft has long been a leader in database technology and they continue to be a dominant choice among many companies and users alike.  This extensive training series covers Microsoft SQL Server versions 2012 through 2019, all of which are still widely in use today. In this training series, you will explore SQL Server administration, database design, analysis services, reporting services, PowerBI, and more. 

Regular Price $199

Sale Price: $69.00

TOTAL HOURS

188 Hours
of Training

INCLUDED COURSES

16 Full-length
Courses

LECTURES

1010 Course
Videos

PREP QUESTIONS

1405 Prep
Test Questions

This Microsoft SQL Server Training Series Contains the Following Courses

Microsoft SQL Server 2019 - Introduction to Data Analysis

Microsoft SQL Server 2019 - Introduction to Data Analysis

77 Course Videos
13 Hrs 58 Min in Duration
75 Test Prep Questions

$99.00 when purchased separately

This course will discuss the responsibilities and functions of a data analyst.  Which includes the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. This...

This course will discuss the responsibilities and functions of a data analyst.  Which includes the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. 

This course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.  Power BI is a member of the Power Platform.  Power Apps is another component that enables everyone to build and use apps that connect to business data. This course will show you how to use the Power Apps visual to pass context-aware data to a canvas app, which updates in real-time as you make changes to your report. This will allow your app users to derive business insights and take actions from right within their Power BI reports and dashboards. 

This course will also include information on basic T-SQL query development.

  • Ingest, clean, and transform data
  • Model data for performance and scalability
  • Design and create reports for data analysis
  • Apply and perform advanced report analytics
  • Manage and share report assets
  • Create paginated reports in Power BI
  • Embed Power Apps into Power BI
  • Understand the similarities and differences between Transact-SQL and other computer languages.
  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
Instructor: James Ring-Howell

Microsoft SQL Server 2019 - Querying SQL Server

Microsoft SQL Server 2019 - Querying SQL Server

67 Course Videos
10 Hrs 5 Min in Duration
75 Test Prep Questions

$99.00 when purchased separately

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server.  You will learn how to write queries that return data from tables as well as create, update, or delete data in a database.  These queries will allow filtering and sorting and effectively use the various data types provided by SQL Server.  This course also covers the use of dynamic tables of various sorts which can allow a more sophisticated SQL user to hide implementation details from other end users accessing data from reporting tools. Finally, the course will provide details on the what...

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server.  You will learn how to write queries that return data from tables as well as create, update, or delete data in a database.  These queries will allow filtering and sorting and effectively use the various data types provided by SQL Server.  This course also covers the use of dynamic tables of various sorts which can allow a more sophisticated SQL user to hide implementation details from other end users accessing data from reporting tools. Finally, the course will provide details on the what and how of error handling and transaction management. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The primary target audience for this course is: Database Administrators, Database Developers and BI professionals.

In this course, you will learn how to: 

  • Understand the similarities and differences between Transact-SQL and other computer languages. 
  • Write SELECT queries 
  • Query multiple tables 
  • Sort and filter data 
  • Describe the use of data types in SQL Server 
  • Modify data using Transact-SQL 
  • Use built-in functions 
  • Group and aggregate data 
  • Use subqueries 
  • Use table expressions 
  • Use set operators 
  • Use window ranking, offset and aggregate functions 
  • Implement pivoting and grouping sets
  • Execute stored procedures 
  • Program with T-SQL 
  • Implement error handling 
  • Implement transactions 

Instructor: James Ring-Howell

SQL Server 2019 Database Design

SQL Server 2019 Database Design

37 Course Videos
6 Hrs 22 Min in Duration
75 Test Prep Questions

$99.00 when purchased separately

This course focuses on skills necessary to architect well-performing databases in SQL Server.  It covers the principles and the practical tools necessary to understand and create all of the objects you would need to have a complete database.  This includes a discussion of tables, data integrity, and indexes.  As well as basic programming, file storage, and full-text searching. One of the primary benefits of commercial-grade databases is the availability of indexes to speed lookups.  You will learn the benefits and the requirements for generating useful indexes in both OLTP (transactional) and OLAP (reporting) databases.  Another major benefit of business-focused RDBMS (Relational...

This course focuses on skills necessary to architect well-performing databases in SQL Server.  It covers the principles and the practical tools necessary to understand and create all of the objects you would need to have a complete database.  This includes a discussion of tables, data integrity, and indexes.  As well as basic programming, file storage, and full-text searching. One of the primary benefits of commercial-grade databases is the availability of indexes to speed lookups.  You will learn the benefits and the requirements for generating useful indexes in both OLTP (transactional) and OLAP (reporting) databases.  Another major benefit of business-focused RDBMS (Relational Database Management Systems) is the use of enforced relationships and constraints.  This course will cover all the standard techniques to maintain consistent quality data in your database using referential integrity and various types of automatic data validations.  One way of increasing both security and performance in a database is using stored procedures, functions, and triggers.  You will learn what each of these objects is and how to write the T-SQL code to generate them.  We will also cover the use of SQL Management Studio to perform these various operations using visual tools where possible.  At the end of the course, you should be able to create a highly functional business database.

Course Prerequisites 

  • Basic knowledge of the Microsoft Windows operating system 
  • Working knowledge of Transact-SQL 
  • Working knowledge of relational databases 

In this course, you will learn how to: 

  • Design and Implement Tables. 
  • Ensure Data Integrity through Constraints. 
  • Describe indexes, including Optimized and Columnstore indexes 
  • Design and Implement Stored Procedures. 
  • Design and Implement User Defined Functions. 
  • Respond to data manipulation using triggers. 
  • Store and Query Blobs and Text Documents. 
Instructor: James Ring-Howell

Microsoft SQL Server 2019 Analysis Services (SSAS)

Microsoft SQL Server 2019 Analysis Services (SSAS)

50 Course Videos
8 Hrs 56 Min in Duration
75 Test Prep Questions

$99.00 when purchased separately

Analysis Services is a combination of two analytical engines (VertiPaq for multidimensional cubes and Data Mining and xVelocity for Tabular Data Models) used in decision support and business analytics. It provides enterprise-grade semantic data model capabilities for business intelligence (BI), data analysis, and reporting applications such as Power BI, Excel, Reporting Services, and other data visualization tools. This course provides a full introduction to the use of both of these engines in an enterprise environment.  You will learn about creating cubes and their constituent components, the use of MDX to query the cubes, as well as how to customize a cube...

Analysis Services is a combination of two analytical engines (VertiPaq for multidimensional cubes and Data Mining and xVelocity for Tabular Data Models) used in decision support and business analytics. It provides enterprise-grade semantic data model capabilities for business intelligence (BI), data analysis, and reporting applications such as Power BI, Excel, Reporting Services, and other data visualization tools. This course provides a full introduction to the use of both of these engines in an enterprise environment.  You will learn about creating cubes and their constituent components, the use of MDX to query the cubes, as well as how to customize a cube with KPI, actions, perspectives, and language translations.  You will also learn about the differences and similarities between cubes and tabular data models, how to create a tabular data model, and the use of DAX to query the model. The third major component of the course is a form of Machine Learning called Data Mining.  Data Mining is the analysis of large data set to reveal hidden patterns and trends. This course will teach you how to create a Data Mining solution, how to compare and validate different data mining options (models) for a given data set, and how to use your chosen model in a consumer-friendly client.

Introduction to Microsoft Power BI

Introduction to Microsoft Power BI

65 Course Videos
10 Hrs 52 Min in Duration
75 Test Prep Questions

$99.00 when purchased separately

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. This course will show how to build paginated reports within...

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. This course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.  Power BI is a member of the Power Platform.  Power Apps is another component that enables everyone to build and use apps that connect to business data. This course will show you how to use the Power Apps visual to pass context-aware data to a canvas app, which updates in real-time as you make changes to your report. This will allow your app users to derive business insights and take actions from right within their Power BI reports and dashboards.  Finally, this course will explore the intersections between Power BI and Microsoft’s enterprise-level data modeling and analysis platform, SQL Server Analysis Services.

Microsoft SQL Server 2019 - Big Data

Microsoft SQL Server 2019 - Big Data

41 Course Videos
7 Hrs 6 Min in Duration
75 Test Prep Questions

$99.00 when purchased separately

This course focuses on one of SQL Server 2019’s most impactful features—Big Data Clusters. You will learn about data virtualization and data lakes for this complete artificial intelligence (AI) and machine learning (ML) platform within the SQL Server database engine. You will be shown how to use Big Data Clusters to combine large volumes of streaming data for analysis along with data stored in a traditional database. For instance, you can stream large volumes of data from Apache Spark in real-time while executing Transact-SQL queries to bring in relevant additional data from your corporate, SQL Server database. This course provides everything...

This course focuses on one of SQL Server 2019’s most impactful features—Big Data Clusters. You will learn about data virtualization and data lakes for this complete artificial intelligence (AI) and machine learning (ML) platform within the SQL Server database engine. You will be shown how to use Big Data Clusters to combine large volumes of streaming data for analysis along with data stored in a traditional database. For instance, you can stream large volumes of data from Apache Spark in real-time while executing Transact-SQL queries to bring in relevant additional data from your corporate, SQL Server database. This course provides everything necessary to get started working with Big Data Clusters in SQL Server 2019. You will learn about the architectural foundations that are made up from Kubernetes, Spark, HDFS, and SQL Server on Linux. You will be shown how to configure and deploy Big Data Clusters.  You will be ready to use and unveil the full potential of SQL Server 2019: combining different types of data spread across widely disparate sources into a single view that is useful for business intelligence and machine learning analysis.

  • What a Big Data Cluster is
  • How to deploy BDC
  • How to analyze large volumes of data directly from SQL Server 
  • How to analyze large volumes of data via Apache Spark
  • How to manage data stored in HDFS from SQL Server as if it were relational data
  • How to implement advanced analytics solutions through machine learning
  • How to expose different data sources as a single logical source using data virtualization

This course is intended for data engineers, data scientists, data architects, and database administrators who want to employ data virtualization and big data analytics in their environments.

Microsoft SQL Server 2019 Administration

Microsoft SQL Server 2019 Administration

41 Course Videos
6 Hrs 24 Min in Duration
75 Test Prep Questions

$99.00 when purchased separately

With this course, students can learn about SQL Server installation, data storage, data recovery, monitoring, security, and maintenance. Instructor James Ring-Howell brings with him over 40 years of applicable IT experience and has taught technical courses for over two decades. This Microsoft SQL Server 2019 Admin course is specifically for obtaining working IT skills and is not certification-specific training. The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility or work in environments where databases play a key role in their primary job. The secondary...

With this course, students can learn about SQL Server installation, data storage, data recovery, monitoring, security, and maintenance. Instructor James Ring-Howell brings with him over 40 years of applicable IT experience and has taught technical courses for over two decades. 


This Microsoft SQL Server 2019 Admin course is specifically for obtaining working IT skills and is not certification-specific training. 


The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility or work in environments where databases play a key role in their primary job. The secondary audience for this course is individuals who develop applications that deliver content from SQL Server databases.


  • Install and Configure SQL Server 2019 
  • Work with Databases and Storage 
  • Plan and Implement a Backup Strategy 
  • Restore SQL Server 2019 Databases 
  • Import and Export Data 
  • Monitor SQL Server 2019 
  • Manage SQL Server Security 
  • Audit Data Access and Encrypt Data 
  • Perform Ongoing Database Maintenance 
  • Automate SQL Server 2019 Management 
  • Monitor SQL Server 2019 by Using Alerts and Notifications


Microsoft SQL Server is a relational database management system (RDBMS) that supports a wide variety of transaction processing, business intelligence, and analytics applications in corporate IT environments. Microsoft SQL Server is one of the three market-leading database technologies, along with Oracle Database and IBM's DB2. 

Like other RDBMS software, Microsoft SQL Server is built on top of SQL, a standardized programming language that database administrators (DBAs) and other IT professionals use to manage databases and query the data they contain. SQL Server is tied to Transact-SQL (T-SQL), an implementation of SQL from Microsoft that adds a set of proprietary programming extensions to the standard language. 

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2019 database. The training focuses on teaching individuals how to use SQL Server 2019 product features and tools related to maintaining the server environment and the databases it contains and is designed for customers who are interested in learning SQL Server 2016, SQL 2017, or SQL Server 2019. It covers the new features in SQL Server 2019, but also the important capabilities across the SQL Server data platform.  

Topics include Installation, Data Storage, Data Maintenance and Recovery, Monitoring, Security, and Server Maintenance. This course requires that you meet the following prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of Transact-SQL. Working knowledge of relational databases. Some experience with database design is recommended.

Microsoft 70-765 SQL Server 2016 Provisioning SQL Databases

Microsoft 70-765 SQL Server 2016 Provisioning SQL Databases

102 Course Videos
22 Hrs 58 Min in Duration
247 Test Prep Questions

$99.00 when purchased separately

Instructor Chrys Thorsen prepares students to learn about the content within the legacy Microsoft Certification Exam 70-765. Though this is a legacy course, students will benefit from being able to provision databases on Microsoft SQL Server 2016 and Microsoft Azure. This course is intended for IT professionals responsible for installing and maintaining a Microsoft SQL Server environment. 

Instructor Chrys Thorsen prepares students to learn about the content within the legacy Microsoft Certification Exam 70-765. Though this is a legacy course, students will benefit from being able to provision databases on Microsoft SQL Server 2016 and Microsoft Azure. This course is intended for IT professionals responsible for installing and maintaining a Microsoft SQL Server environment. 

Microsoft 70-764  SQL 2016 - Administering a SQL Database Infrastructure

Microsoft 70-764 SQL 2016 - Administering a SQL Database Infrastructure

106 Course Videos
21 Hrs 14 Min in Duration
250 Test Prep Questions

$99.00 when purchased separately

Chrys Thorsen guides students through this Microsoft SQL 70-764 course on preparation for legacy Microsoft Certification Exam 70-764. By the end of this training, you will be able to administer a Microsoft SQL 2016 server. This course is intended for IT professionals responsible for installing and maintaining a Microsoft SQL Server environment. Course subject matter is still valuable for IT training students wanting to learn about database infrastructure.

Chrys Thorsen guides students through this Microsoft SQL 70-764 course on preparation for legacy Microsoft Certification Exam 70-764. By the end of this training, you will be able to administer a Microsoft SQL 2016 server. This course is intended for IT professionals responsible for installing and maintaining a Microsoft SQL Server environment. Course subject matter is still valuable for IT training students wanting to learn about database infrastructure.

Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012

Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012

47 Course Videos
19 Hrs 17 Min in Duration
43 Test Prep Questions

$99.00 when purchased separately

This exam is intended for business intelligence (BI) architects, who are responsible for the overall design of a BI infrastructure and how it relates to other data systems in use.

This exam is intended for business intelligence (BI) architects, who are responsible for the overall design of a BI infrastructure and how it relates to other data systems in use.

Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012

Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012

47 Course Videos
12 Hrs 46 Min in Duration
42 Test Prep Questions

$99.00 when purchased separately

This course prep for the 70-466 exam and focuses on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.

This course prep for the 70-466 exam and focuses on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.

Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012

Microsoft 70-465: Designing Database Solutions for Microsoft SQL Server 2012

56 Course Videos
10 Hrs 45 Min in Duration
40 Test Prep Questions

$99.00 when purchased separately

This course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies. It describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.

This course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2012 and other Microsoft technologies. It describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

59 Course Videos
9 Hrs 46 Min in Duration
59 Test Prep Questions

$99.00 when purchased separately

This course is preparation for the 70-464 exam and introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.

This course is preparation for the 70-464 exam and introduces SQL Server 2012 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.

Microsoft 70-461: Querying SQL Server 2012

Microsoft 70-461: Querying SQL Server 2012

84 Course Videos
12 Hrs 22 Min in Duration
53 Test Prep Questions

$99.00 when purchased separately

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 and is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course is preparation for exam 70-461.

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 and is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course is preparation for exam 70-461.

Microsoft 70-462: Administering SQL Server 2012 Databases

Microsoft 70-462: Administering SQL Server 2012 Databases

62 Course Videos
8 Hrs 24 Min in Duration
45 Test Prep Questions

$99.00 when purchased separately

This course is preparation for the 70-462 Exam. The lectures provide students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database and focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.

This course is preparation for the 70-462 Exam. The lectures provide students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database and focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database.

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

69 Course Videos
6 Hrs 55 Min in Duration
101 Test Prep Questions

$99.00 when purchased separately

This course is preparation for the 70-463 exam and describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

This course is preparation for the 70-463 exam and describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Microsoft SQL Server Mega Training Series

Regular Price $199

Sale Price: $89.00

Regular Price $199

Sale Price: $69.00