Training on SQL Server, Power BI and more by the Microsoft Experts at Opsgility

SQL Server and Data Services

Upgrade your teams skills with the latest capabilities of SQL Server. Opsgility trainers are experts in Microsoft SQL Server and can deliver training globally to get your team up-to-speed. Beyond SQL server, learn how to use Power BI and Big Data Services in Azure to extract and process data to add value to your core business.

Course Options

SQL Server and Data Services Training | Instructor-Led Courses

IL - MOC 10985: Introduction to SQL Databases
Beginner | 3 Days | more...
In this course, you will learn fundamental database concepts for Microsoft SQL Server 2016, including database types, database languages and database designs.This course incorporates material from the Official Microsoft Learning Product 10985: Introduction to SQL Databases.
This course will look at the process of migrating workloads to Azure. You will leave with the information needed to develop a solid migration plan to keep mission-critical apps and data protected as your customers transition and modernize their application, data, and infrastructure environment.
IL - Cloud Workshop: Migrating SQL databases to Azure
Intermediate | 1 Day | more...
In this workshop, you will work as a group to setup and configure a serverless architecture within Azure using a combination of Azure Functions, Logic Apps, Event Grid, Cosmos DB, and Azure Storage. The focus is on removing server management from the equation, breaking down the solution into smaller components that are individually scalable, and allowing the customer to only pay for what they use
IL - MOC 20768: Developing SQL Data Models
Intermediate | 3 Days | more...
In this course, you will learn about business intelligence (BI) solutions that implement multidimensional databases and create tabular semantic data models for analysis using SQL Server Analysis Services (SSAS).
IL - MOC 20761C: Querying Data with Transact-SQL
Beginner | 5 Days | more...
This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum.
IL - MOC 10986: Updating Your Skills to SQL Server 2016
Intermediate | 3 Days | more...
Update your SQL Server skills with this introduction to the new features of SQL Server 2016. You’ll learn the new features for performance, security, availability and scalability, reporting and Power BI, data access, and SQL Server OLAP, and you’ll learn about new SQL Server cloud functionality.
IL - MOC 20765: Provisioning SQL Databases
Intermediate | 5 Days | more...
This course provides you with the knowledge and skills to provision a Microsoft SQL Server 2016 database. You will cover SQL Server 2016 provision both on-premise and in Azure, and you’ll cover installing from new and migrating from an existing install.This course incorporates material from the Official Microsoft Learning Product 20765: Provisioning SQL Databases, and it can assist you in your preparation for Exam 70-765: Provisioning SQL Databases
In this course, professionals who administer and maintain SQL Server databases and who develop applications that deliver content from SQL Server databases will gain the knowledge and skills to administer a SQL server database infrastructure.This course incorporates material from the Official Microsoft Learning Product 20764: Administering a SQL Database Infrastructure and can assist you in preparing for the 70-764: Administering a SQL Database Infrastructure exam.
In this course you will learn how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. You will discover how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.
IL - MOC 20767: Implementing a SQL Data Warehouse
Intermediate | 5 Days | more...
In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution. You will discover how to create a data warehouse, how to implement extract, transform, and load (ETL) with SQL Server Integration Services (SSIS), and how to validate and cleanse data with Data Quality Services (DQS) and Master Data Services.This course incorporates material from the Official Microsoft Learning Product 20767: and it can assist you in your preparation for Exam 70-767: Implementing a SQL Data Warehouse.
IL - SQL Server 2016 Advanced Features
Advanced | 3 Days | more...
This is a custom 3-day SQL Server 2016 training course. This 400 level course covers In-Memory OLTP, Column store Indexing, Real-time Analytics, Query Store, JSON data in SQL Server and Extended Events with Availability Groups.
Contoso has asked you to deploy their infrastructure in a resilient manner to insure their infrastructure will be available for their users and gain an SLA from Microsoft. In this hands-on lab, you will take an existing deployment in Azure and re-architect it for resiliency.

A cloud workshop is a 1-day event that consists of an overview of the technology, a deep dive whiteboard design session and Hands-on lab where participants will a subset of the solution.

In this workshop, attendees will migrate a retail chain to from an existing data warehouse from an on-premises SQL Server into Azure SQL Data Warehouse. Prepare a detailed migration plan including data preparation, importing data into Azure SQL Data Warehouse, and architecting a data orchestration strategy to move data from the existing on-premises source systems to Azure SQL Data Warehouse. This workshop includes: Whiteboard design session and Hands-on lab

In this workshop, you will gain a better understanding of how new features of SQL Server 2019 enables more Big Data and analytics capabilities through the use of Big Data Clusters, data virtualization and orchestration, query processing enhancements, and through better scalability through distributed storage and compute.
IL - Cloud Workshop: SQL Server hybrid cloud
Advanced | 1 Day | more...

A cloud workshop is a 1-day event that consists of an overview of the technology, a deep dive whiteboard design session and Hands-on lab where participants will a subset of the solution.

In this workshop, students will work with a media publishing company to design a hybrid cloud disaster recovery solution. Students will design the solution to handle large spikes in load and harden the security to include encryption of PCI data. Additionally students will implement an archival strategy to keep databases sizes in check. This workshop will include: Whiteboard design session.

IL - MOC 20778: Analyzing Data with Power BI
Intermediate | 2 days | more...
The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.Audience profileThe course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data. At course completion
IL - Power BI for Data Professionals
Intermediate | 3 Days | more...
This course covers using Power BI Desktop to create and deploy data sets and reports as well as deploying, sharing, and securing assets in 

We will start off by reviewing the components of the Power BI ecosystem. Then we will begin to build a model in Power BI Desktop by acquiring data using Power Query/M. Next, we will shape and model the data using M and DAX. Then we will build calculations to support analysis and reporting. 

Once we have a working data set, we will build a report using default and custom visuals, buttons, and bookmarks. Then we’ll add dynamic row-level security roles.  

Next, we’ll explore various ways to deploy and share the data model and the report in This will include organization of work spaces, user roles within the work space, row-level security, and use of Power BI apps. We will also look at scheduling the refresh of data in imported and composite datasets. 

The course will wrap up by looking at some re-usability and life-cycle management techniques including version control, pre-production environments, use of shared and certified data sets, and suggested quality checks before deploying to production. 

This course covers all aspects of Azure SQL Database performance. This course will cover the performance monitoring and troubleshooting tools available in Azure SQL Database. We will cover designing performant databases in Azure SQL Database, leveraging in-memory and columnstore technologies. Finally, we will wrap up by discussing elastic database pools and the special challenges they bring to monitoring and tuning performance
In this workshop, you will learn how to use advanced features of the managed PostgreSQL PaaS service on Azure to make your database more scalable and able to handle the rapid ingest of streaming data while simultaneously generating and serving pre-aggregated data for reports. You will design a resilient stream processing pipeline to ingest, process, and save real-time data to Postgres. Next, you will learn how to explore and gain insights from flat files at scale, perform aggregates, and save the valuable information to your database. Finally, you will create complex reports containing advanced visualizations, using a drag-and-drop interface, and use them to build a customizable dashboard that gets updated in real-time.
In this hands-on course, students will learn about running SQL Server in Azure. This course will review basic Azure networking and storage using the Azure Resource Manager architecture to prepare students for building SQL Server solutions in Azure. The primary focus of this course is SQL Server cloud and hybrid-cloud solutions on both Azure Platform as a Service (PaaS) and Azure Infrastructure as a Service (IaaS). This course will cover best practices for deploying SQL Server on Azure Virtual Machines including standalone SQL Servers and hybrid Availability Groups. The course will look at SQL Server features that take advantage of Azure Storage such as SQL Server Managed Backup, Azure Snapshot Backups, and SQL Server data files hosted on Azure Storage. Finally, this course will provide you with an introduction to Azure SQL Database and archiving cold data with SQL Server Stretch Database. 

Training Options


Dedicated training at your location or delivered virtually by Opsgility and Microsoft Certified Trainers.

  • Expert trainers
  • Immersive training with intense hands-on training.
  • Global Availability
  • Duration 1 - 5 days

Opsgility's online training platform offers on-demand training on SQL Server and Power BI. We offer on-demand training with interactive hands-on lab environments to walk you through the ins-and-outs of using SQL in your environment.
Keep checking back for updates!

Contact us about SQL Server or other Data Services training