Skip to main content

Microsoft Sql Server Training Series – 16 Courses

Beginner to Advanced188 Hours1110 Course Videos1405 Test Questions

$249.00

A 16-course Microsoft SQL Server bundle covering T-SQL, administration, design, BI, Power BI and Azure SQL, from SQL Server 2012 to 2019. It has 188 hours of training across 1110 videos.

  • Login details sent straight after payment
  • Self-paced. Study on any device
  • StemBoss Certificate of Completion
  • 14-day refund promise

Secure checkout. Pay by card, Apple Pay or Google Pay.

The Microsoft SQL Server Training Series is a bundle of 16 courses that takes you from your first T-SQL query to running, securing and reporting on SQL Server databases. It covers SQL Server 2012 through to 2019, plus Azure SQL and Power BI, so it suits beginners and working database staff alike. You get 188 hours of training across 1110 videos, plus 1405 test questions.

What you will learn

  • How to write T-SQL queries, from simple selects to transactions
  • How to design tables, keys and indexes for a sound database
  • How to install, set up and maintain SQL Server
  • How to back up and restore databases
  • How to protect data with encryption, auditing and activity monitoring
  • How to build data warehouses and move data with SSIS
  • How to build cubes and data models with SSAS
  • How to create reports with SSRS and dashboards with Power BI
  • How to deploy and manage Azure SQL databases
  • How to tune queries and improve performance

Topics covered

  • T-SQL querying: from query tools through to transactions.
  • Database design and architecture: tables, structure and on-premises versus Azure.
  • SQL Server administration: installation, configuration and maintenance.
  • Security: encryption, permissions and database activity monitoring.
  • Business intelligence: BI basics, data modelling and data mining.
  • Integration, Analysis and Reporting Services: SSIS, SSAS and SSRS.
  • Power BI: preparing data, building models and visuals.
  • Azure SQL: cloud databases and storage.
  • Big Data Clusters: running SQL Server with Spark and HDFS.
  • SQL Server 2012: fundamentals, administration and data warehouse builds.

Who this course is for

  • Beginners who want a full path into SQL Server
  • Database administrators who look after SQL Server
  • SQL Server developers who write and tune queries
  • Business intelligence and reporting professionals
  • Data warehouse designers

Before you start

A basic idea of what a database is will help, along with general computer skills and some time using Windows. You do not need to know SQL already, as the querying courses start from the basics. Work through the courses in order of your goal, for example querying first, then design and administration, then BI.

Jobs this course supports

  • Database administrator
  • SQL Server developer
  • Business intelligence developer
  • Data warehouse designer
  • SQL Server engineer

Skill level

Beginner to Advanced
Duration

188 Hours
Videos

1110 Course Videos
Questions

1405 Test Questions
Prerequisites

Basic computer skills and some idea of what a database is. Windows familiarity helps.
Best for

Database administrators, SQL Server developers, BI professionals, data warehouse designers
Topics covered

T-SQL querying, database design, administration, security and encryption, SSIS, SSAS, SSRS, Power BI, Azure SQL, Big Data Clusters
Format

Online video lessons, self-paced, 16 courses
Language

English
Closed captions

Yes
Certificate

StemBoss Certificate of Completion

What is inside this bundle

Open any course to see what it covers.

70-461: Querying SQL Server 201283 topics
  1. Creating Queries-Part 1
  2. Creating Queries-Part 2
  3. Creating Queries-Part 3
  4. Creating Queries-Part 4
  5. Creating Queries-Part 5
  6. Constraints-Part 1
  7. Constraints-Part 2
  8. Constraints-Part 3
  9. Constraints-Part 4
  10. Constraints-Part 5
  11. Select Statement-Part 1
  12. Select Statement-Part 2
  13. Select Statement-Part 3
  14. Select Statement-Part 4
  15. Data Types-Part 1
  16. Data Types-Part 2
  17. Data Types-Part 3
  18. Data Types-Part 4
  19. Data Types-Part 5
  20. Data Types-Part 6
  21. Data Types-Part 7
  22. Data Types-Part 8
  23. Data Types-Part 9
  24. Data Types-Part 10
  25. Sorting Results-Part 1
  26. Sorting Results-Part 2
  27. Sorting Results-Part 3
  28. Sorting Results-Part 4
  29. Sorting Results-Part 5
  30. Sorting Results-Part 6
  31. Tables Part 1
  32. Tables Part 2
  33. Tables Part 3
  34. Tables Part 4
  35. Tables Part 5
  36. Tables Part 6
  37. Inserting Data-Part 1
  38. Inserting Data-Part 2
  39. Inserting Data-Part 3
  40. Inserting Data-Part 4
  41. Inserting Data-Part 5
  42. Inserting Data-Part 6
  43. Functions
  44. Parse
  45. Logical Functions
  46. Group By
  47. Programming-Part 1
  48. Programming-Part 2
  49. Programming-Part 3
  50. Programming-Part 4
  51. Programming-Part 5
  52. Programming-Part 6
  53. Storage Procedures-Part 1
  54. Storage Procedures-Part 2
  55. Dynamic SQL-Part 1
  56. Dynamic SQL-Part 2
  57. Sub-Queries And Table Expressions-Part 1
  58. Sub-Queries And Table Expressions-Part 2
  59. Sub-Queries And Table Expressions-Part 3
  60. Sub-Queries And Table Expressions-Part 4
  61. Set Operators-Part 1
  62. Set Operators-Part 2
  63. Window Functions-Part 1
  64. Window Functions-Part 2
  65. User Defined Functions-Part 1
  66. User Defined Functions-Part 2
  67. Advanced Analytical Functions
  68. Pivot
  69. Grouping Sets
  70. Error Handling-Part 1
  71. Error Handling-Part 2
  72. Manage Transactions-Part 1
  73. Manage Transactions-Part 2
  74. Manage Transactions-Part 3
  75. System Databases-Part 1
  76. System Databases-Part 2
  77. System Databases-Part 3
  78. System Databases-Part 4
  79. Query Planning-Part 1
  80. Query Planning-Part 2
  81. Index-Part 1
  82. Index-Part 2
  83. Index-Part 3
70-462: Administering SQL Server 2012 Databases62 topics
  1. Overview
  2. DataStorage-Part 1
  3. DataStorage-Part 2
  4. Install-Part 1
  5. Install-Part 2
  6. Configuring-Part 1
  7. Configuring-Part 2
  8. Changing Memory-Part 1
  9. Changing Memory-Part 2
  10. Email-Part 1
  11. Email-Part 2
  12. User Databases-Part 1
  13. User Databases-Part 2
  14. User Databases-Part 3
  15. User Databases-Part 4
  16. User Databases-Part 5
  17. Setting Security-Part 1
  18. Setting Security-Part 2
  19. Server Roles-Part 1
  20. Server Roles-Part 2
  21. Setting Permissions-Part 1
  22. Setting Permissions-Part 2
  23. Querying Data From Multiple Tables-Part 1
  24. Querying Data From Multiple Tables-Part 2
  25. Querying Data From Multiple Tables-Part 3
  26. Querying Data From Multiple Tables-Part 4
  27. Querying Data From Multiple Tables-Part 5
  28. Encrypting And Compressing-Part 1
  29. Encrypting And Compressing-Part 2
  30. Encrypting And Compressing-Part 3
  31. Functions-Part 1
  32. Functions-Part 2
  33. Functions-Part 3
  34. Functions-Part 4
  35. Functions-Part 5
  36. Functions-Part 6
  37. Managing Backups-Part 1
  38. Managing Backups-Part 2
  39. Managing Backups-Part 3
  40. Managing Backups-Part 4
  41. Managing Backups-Part 5
  42. Managing Backups-Part 6
  43. Managing Backups-Part 7
  44. Stored Procedures-Part 1
  45. Stored Procedures-Part 2
  46. Stored Procedures-Part 3
  47. Stored Procedures-Part 4
  48. Managing SQL Performance-Part 1
  49. Managing SQL Performance-Part 2
  50. Managing SQL Performance-Part 3
  51. Managing SQL Performance-Part 4
  52. Managing SQL Performance-Part 5
  53. Managing SQL Performance-Part 6
  54. Managing SQL Performance-Part 7
  55. Set Operators-Part 1
  56. Set Operators-Part 2
  57. Set Operators-Part 3
  58. Set Operators-Part 4
  59. Set Operators-Part 5
  60. Managing Database Infrastructures-Part 1
  61. Managing Database Infrastructures-Part 2
  62. Managing Database Infrastructures-Part 3
70-463: Implementing a Data Warehouse with SQL Server 201268 topics
  1. Introduction To Data Warehouse-Part1
  2. Introduction To Data Warehouse-Part2
  3. Introduction To Data Warehouse-Part3
  4. Introduction To Data Warehouse-Part4
  5. Introduction To Data Warehouse-Part5
  6. Introduction To Data Warehouse-Part6
  7. Creating Dimensions And Changing Granularity Of Dimensions-Part1
  8. Creating Dimensions And Changing Granularity Of Dimensions-Part2
  9. Creating Dimensions And Changing Granularity Of Dimensions-Part3
  10. Creating Dimensions And Changing Granularity Of Dimensions-Part4
  11. Creating Dimensions And Changing Granularity Of Dimensions-Part5
  12. Creating Dimensions And Changing Granularity Of Dimensions-Part6
  13. Creating Fact Tables And Column Store Indexes-Part1
  14. Creating Fact Tables And Column Store Indexes-Part2
  15. Creating Fact Tables And Column Store Indexes-Part3
  16. Creating Fact Tables And Column Store Indexes-Part4
  17. Creating Fact Tables And Column Store Indexes-Part5
  18. Implementing Data Warehouse-Part1
  19. Implementing Data Warehouse-Part2
  20. Implementing Data Warehouse-Part3
  21. Implementing Data Warehouse-Part4
  22. Working With Integration Services-Part1
  23. Working With Integration Services-Part2
  24. Working With Integration Services-Part3
  25. Working With Integration Services-Part4
  26. Working With Integration Services-Part5
  27. Working With Integration Services-Part6
  28. Managing Control Flow-Part1
  29. Managing Control Flow-Part2
  30. Managing Control Flow-Part3
  31. Managing Control Flow-Part4
  32. Managing Control Flow-Part5
  33. Working With Dynamic Variables-Part1
  34. Working With Dynamic Variables-Part2
  35. Working With Dynamic Variables-Part3
  36. Working With Dynamic Variables-Part4
  37. Working With Dynamic Variables-Part5
  38. Working With Dynamic Variables-Part6
  39. Working With Dynamic Variables-Part7
  40. Working With Dynamic Variables-Part8
  41. Implementing DataFlow-Part1
  42. Implementing DataFlow-Part2
  43. Implementing DataFlow-Part3
  44. Implementing DataFlow-Part4
  45. Implementing DataFlow-Part5
  46. Implementing DataFlow-Part6
  47. Implementing DataFlow-Part7
  48. Implementing DataFlow-Part8
  49. Managing DataFlow-Part1
  50. Managing DataFlow-Part2
  51. Managing DataFlow-Part3
  52. Managing DataFlow-Part4
  53. Managing SSIS Package Execution-Part1
  54. Managing SSIS Package Execution-Part2
  55. Managing SSIS Package Execution-Part3
  56. Managing SSIS Package Execution-Part4
  57. Managing SSIS Package Execution-Part5
  58. Managing SSIS Package Execution-Part6
  59. Debugging And Troubleshooting-Part1
  60. Debugging And Troubleshooting-Part2
  61. Debugging And Troubleshooting-Part3
  62. Debugging And Troubleshooting-Part4
  63. Deploying Packages-Part1
  64. Deploying Packages-Part2
  65. Deploying Packages-Part3
  66. Securing Packages And Databases-Part1
  67. Securing Packages And Databases-Part2
  68. Working With MDS And Windows Azure
70-464: Developing Microsoft SQL Server 2012 Databases20 topics
  1. Module 1: SQL 2012 And The 464 Test
  2. Module 2: Working With Data Types
  3. Module 3: Tables
  4. Module 4: Data Constraints
  5. Module 5: Planning In Indexing
  6. Module 6: Table Structures
  7. Module 7: Improving Performance with Non-Clustered Indexes
  8. Module 8: Using Indexes And Execution Plans
  9. Module 9: Working with Views
  10. Module 10: Designing and Implementing Stored Procedures
  11. Module 11: Merging Data and Passing Tables
  12. Module 12: Designing and Implementing User Functions
  13. Module 13: Creating Highly Concurrent SQL Server Applications
  14. Module 14: Handling Errors in T-SQL
  15. Module 15: Triggers
  16. Module 16: Implementing Managed Code
  17. Module 17: Storing XML in SQL
  18. Module 18: Querying XML
  19. Module 19: Working with the Spatial Data
  20. Module 20: Working With Full-Text Indexes and Queries
70-465: Designing Database Solutions for Microsoft SQL Server 201215 topics
  1. Module 1: Designing A Database Server Infrastructure
  2. Module 2: Designing A Logical Database Scheme
  3. Module 3: Designing A Physical Database Implementation
  4. Module 4: Incorporating Data Files Into the Database
  5. Module 5: Tuning Database Performance
  6. Module 6: Designing Database Security
  7. Module 7: Policy Based Management
  8. Module 8: Monitoring Server Health
  9. Module 9: Designing Database Backup Solution
  10. Module 10: Automating Multi Server Maintenance
  11. Module 11: Managing SQL Server With Windows Powershell
  12. Module 12: Replicating Data
  13. Module 13: Planning High Availability
  14. Module 14: Review of SQL Statements
  15. Module 15: Eleven Rules of Database Design
70-466: Implementing Data Models and Reports with SQL Server 201217 topics
  1. Module 1: Introduction To Business Intelligence And Data Modeling
  2. Module 2: Implementing Reports The SQL Server Reporting Services
  3. Module 3: Supporting Self Service Reporting
  4. Module 4: Managing Report Execution And Delivery
  5. Module 5: Creating Multidimensional Databases
  6. Module 6: Working With Cubes And Dimensions
  7. Module 7: Working With Measures And Measure Groups
  8. Module 8: Introduction To MDX
  9. Module 9: Customizing Cube Functionality
  10. Module 10: Implementing A Tabular Data Model
  11. Module 11: Introduction To DAX
  12. Module 12: Implementing An Analysis Services Tabular Data Model
  13. Module 13: SQL Analysis Services
  14. Module 14: Creating Data Visualizations With Power View
  15. Module 15: Supporting Self Service Reporting
  16. Module 16: Performing Predictive Analysis With Data Mining
  17. Module 17: Predictive Analytics
70-467: Designing Business Intelligence Solutions with SQL Server 20128 topics
  1. Module 1: Intro To Business Intelligence
  2. Module 2: Database Essentials
  3. Module 3: Business Intelligence Development
  4. Module 4: Business Intelligence Results
  5. Module 5: Advanced Reporting And Development
  6. Module 6: SQL Server Integration Services (SSIS)
  7. Module 7: SQL Server 2014 New Features
  8. Module 8: Course Review And Exam Prep
70-764 SQL 2016 - Administering a SQL Database Infrastructure13 topics
  1. Module 1: Configure Encryption
  2. Module 2: Configure Data Access and Permissions
  3. Module 3: Configure Auditing
  4. Module 4: Develop a Backup Strategy
  5. Module 5: Restore Databases
  6. Module 6: Manage Database Integrity
  7. Module 7: Monitor Database Activity
  8. Module 8: Monitor Queries
  9. Module 9: Manage Indexes
  10. Module 10: Monitor SQL Server Instances
  11. Module 11: Implement Log Shipping
  12. Module 12: Implement Failover Cluster Instances
  13. Module 13: Implement Always On Availability Groups
70-765 SQL Server 2016 Provisioning SQL Databases9 topics
  1. Module 1: Deploy a Microsoft Azure SQL Database
  2. Module 2: Plan for SQL Server Installation
  3. Module 3: Deploy SQL Server Instances
  4. Module 4: Deploy SQL Server Databases to Azure Virtual Machines
  5. Module 5: Configure Secure Access to Microsoft Azure SQL Databases
  6. Module 6: Configure SQL Server performance settings
  7. Module 7: Manage SQL Server instances
  8. Module 8: Manage SQL Storage
  9. Module 9: Perform Database Maintenance
SQL Server 2019 Administration6 topics
  1. Module 1: Installation
  2. Module 2: Data Storage
  3. Module 3: Data Recover
  4. Module 4: Monitoring
  5. Module 5: Security
  6. Module 6: Maintenance
SQL Server 2019 - Querying SQL Server16 topics
  1. Module 1 - Query Tools
  2. Module 2 - Introduction to T-SQL Querying
  3. Module 3 - Basic SELECT Queries
  4. Module 4 - Querying Multiple Tables
  5. Module 5 - Sorting and Filtering Data
  6. Module 6 - Working with SQL Server Data Types
  7. Module 7 - Using DML to Modify Data
  8. Module 8 - Using Built-In Functions
  9. Module 9 - Grouping and Aggregating Data
  10. Module 10 - Using Subqueries
  11. Module 11 - Using Table Expressions
  12. Module 12 - Using Set Operators
  13. Module 13 - Using Window Ranking, Offset, and Aggregate Functions
  14. Module 14 - Pivoting and Grouping Sets
  15. Module 15 - Implementing Error Handling
  16. Module 16 - Managing Transactions
SQL Server 2019 Database Design7 topics
  1. Module 1 - Designing and Building Tables
  2. Module 2 - Enforcing Data Integrity
  3. Module 3 - Indexing
  4. Module 4 - Stored Procedures, Functions, and Triggers
  5. Module 5 - Blob and Filestream Data
  6. Module 6 - Full-Text Search
  7. Module 7 - Azure vs On-Prem
SQL Server 2019 Analysis Services (SSAS)9 topics
  1. Module 1 - Introduction to Business Intelligence and Data Modeling
  2. Module 2 - Multidimensional Databases
  3. Module 3 - Cubes and Dimensions
  4. Module 4 - Measures and Measure Groups
  5. Module 5 - Introduction to MDX
  6. Module 6 - Customizing Cube Functionality
  7. Module 7 - Tabular Data Models
  8. Module 8 - Data Analysis Expressions (DAX)
  9. Module 9 - Data Mining
SQL Server 2019 - Introduction to Data Analysis17 topics
  1. Module 1 - Query Tools
  2. Module 2 - Introduction to T-SQL Querying
  3. Module 3 - Basic SELECT Queries
  4. Module 4 - Querying Multiple Tables
  5. Module 5 - Sorting and Filtering Data
  6. Module 6 - Introduction to Business Intelligence and Data Modeling
  7. Module 7 - Prepare Data
  8. Module 8 - Clean, Transform, and Load Data
  9. Module 9 - Design a Data Model
  10. Module 10 - Create Model Calculations using DAX
  11. Module 11 - Create Reports
  12. Module 12 - Create Dashboards
  13. Module 13 - Create Paginated Reports
  14. Module 14 - Perform Advanced Analytics
  15. Module 15 - Create and Manage Workspaces
  16. Module 16 - Create Power App Visuals
  17. Module 17 - Analysis Services and Power BI
SQL Server - Big Data8 topics
  1. Module 1: What are Big Data Clusters?
  2. Module 2: Big Data Cluster Architecture
  3. Module 3: Deployment of Big Data Clusters
  4. Module 4: Loading and Querying Data in Big Data Clusters
  5. Module 5: Working with Spark in Big Data Clusters
  6. Module 6: Machine Learning on Big Data Clusters
  7. Module 7: Create and Consume Big Data Cluster Apps
  8. Module 8: Maintenance of Big Data Clusters
Introduction to Microsoft Power BI11 topics
  1. Module 1 - Prepare Data
  2. Module 2 - Clean, Transform, and Load Data
  3. Module 3 - Design a Data Model
  4. Module 4 - Create Model Calculations using DAX
  5. Module 5 - Create Reports
  6. Module 6 - Create Dashboards
  7. Module 7 - Create Paginated Reports
  8. Module 8 - Perform Advanced Analytics
  9. Module 9 - Create and Manage Workspaces
  10. Module 10 - Create Power App Visuals
  11. Module 11 - Analysis Services and Power BI

Your learning path

Where Microsoft Sql Server Training Series - 16 Courses fits. Build your skills one step at a time.

Take firstLearn SQL Server 2019 - Querying SQL ServerTake firstIntroduction to Microsoft Power BI
You are hereMicrosoft Sql Server Training Series - 16 Courses
Next stepMicrosoft SQL Server Administration - 2019Next stepMicrosoft SQL Server 2019 Database DesignNext stepMicrosoft SQL Server Analysis Services (SSAS)

Frequently asked questions

Which versions of SQL Server does this series cover?

It covers SQL Server 2012 through to SQL Server 2019, plus Azure SQL in the cloud.

Can a complete beginner start with this SQL Server bundle?

Yes. The querying courses start from the basics. Some general computer skills and a basic idea of databases will help.

Does the series cover business intelligence tools?

Yes. It includes SSIS for moving data, SSAS for data models and cubes, SSRS for reports, and Power BI for dashboards.

Is database security included?

Yes. One course covers encryption, permissions and database activity monitoring.

How much content is in the series?

There are 16 courses with 188 hours of training across 1110 videos, plus 1405 test questions.

Do I get a certificate?

Yes. You get a StemBoss Certificate of Completion when you finish the course.

Can I get a refund?

Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.

Courses in this bundle

$249.00
Buy bundle