Hot Deal • 3 Courses • 24+ Hours • Lifetime Access

Microsoft SQL Trio

Your Microsoft SQL Server training begins here! This training series covers the latest SQL technologies. It contains Microsoft SQL server Big Data, Administration, and introduction to Microsoft Power BI. These courses will focus on how to access and process data from a range of data sources. It will also show you how to use Big Data Clusters to combine large volumes of streaming data for analysis along with data stored in traditional databases. Purchase this bundle today and get everything you need for Microsoft SQL server information!

Regular Price $399

Sale Price: $99.00

TOTAL HOURS

24 Hours
of Training

INCLUDED COURSES

3 Full-length
Courses

LECTURES

147 Course
Videos

PREP QUESTIONS

225 Prep
Test Questions

This Microsoft SQL Trio Contains the Following Courses

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 SQL Trio Series

Regular Price $399

Sale Price: $99.00