Microsoft SQL Queries – Hands-on training for Business Users

Welcome!

Ready to write Microsoft SQL queries for Power BI reports or data connections in Excel? Are you currently running SQL queries that have already been written, but get stuck as soon as you are faced with writing them from scratch? You’ve come to the right place! This lecture based, hands–on class will get you started with Microsoft Transact SQL and provide you with the skills needed to write basic business queries.

Unlike other courses where you have a single task and a single query to write, we’ll jump right into business questions that are more common in day–to–day work environments. We’ll use a mix of SQL methods immediately, as an example, we’ll start with a simple select statement and quickly add concatenation and work through problems that you’ll run into when working with NULLs. It’s always easy to write queries that work perfectly in a lab, but what are the problems you’ll run into when you do this with live data? In this course, we’ll be repetitive and use as many different types of queries as possible, building you SQL business skills along the way.

Beginning Sessions:

First you will learn the basics: Getting around SQL Server Management Studio (SSMS), understanding how to profile your data before you write your first query. After that, we’ll review basic database and table structures so you know what columns and data types can be used in your queries and how to write the basic select statement that will return data.