Microsoft SQL Queries - Hands-on training for Business Users

Writing Microsoft SQL Queries - Prerequisite knowledge for working professionals, analyst, report builders and new DBA's

What you'll learn:
Microsoft SQL Query Language learn to write queries that run against a Microsoft SQL Server database.
Write SQL Queries and follow along with the Instructor as you profile tables, columns and the schema.
Hands-On SQL Query language training where you will create group by and having queries
Use the Object Explorer to understand which data types are used for the columns and the restrictions you may have when you write your queries
Understand how to write SQL queries that answer basic business questions like who, what, when and how many products have been sold
Hands-On SQL learning where you will create WHERE, TOP, OFFSET FETCH and ORDER BY Queries
Use SUM, Count, AVG and other aggregate functions and learn how data types and NULLs can effect them
Yes, SQL joins! Understand and create regular, left and right joins
Learn to write basic SQL queries using variables
Create queries using different date & time types along with formatting and functions like DateAdd and DataDiff
Using basic CTE's, Unions, and Rank Over to pre-aggregate and organize your results
Learn the Basics of Stored Procedures and Parameters that will help you simplify your day-to-day work

Requirements
No prior knowledge of the SQL language is needed, but a basic understanding of databases, tables and columns if helpful
Downloadable versions of Microsoft SQL 2019 - Trial versions are Free!
The Microsoft AdventureWorkDW2019 Training Database - It's Free!
The latest version of SQL Server Management Studio (SSMS) needs to be installed - It's Free!
The Microsoft Windows platform is required for this course. Mac OS and other systems is not supported.
See the Video for the exact database and software needed for this course.

Description
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.

Next you'll start writing basic SQL queries from a single table using a range SQL functions. We’ll ask questions and write queries that will provide the answers. Once that is complete, we’ll add some common business problems to the mix, like removing text characters from our results and work through each one to ensure we can get the answers needed.

To finish up and reinforce the basics, we’ll go through query labs that will be repetitive, but will ensure you've touched on as many different types of queries as possible so you can build your SQL skills.

Middle Sessions:

Here we start joining tables and keep adding new SQL functions, formatting and groupings to the queries so we can get the correct answers. With each new video, you’ll learn a range of methods all mixed together, so you get a feel for what it takes to actually write meaningful queries that meets the business needs.

Again, to reinforce all of the new items we've covered, we’ll go through query labs that will combine the old labs with the new and ensure you have the knowledge to keep going.

Ending Sessions:

Now that basic queries and joins are easy to do, we’ll focus on specific business labs like how to use variables in your queries and parameters in your stored procedures. We'll continue to mix, match and use as many different SQL methods available so we can solve problems and make sure your SQL skills are as fluent as possible.

Follow along with the instructor as he guides you through a time-tested process of finding the right tables, columns and data types to write queries which will return the specific data you need. You’ll use only three tools, The Microsoft SQL 2019 database engine, SQL Server Management Studio (SSMS) and the Microsoft AdventureWorksDW2019 Training Database to complete the training. Work at your own pace by pausing the video and spend as much time as you need writing your queries and working through the labs. To get the most out of this course, it's best to have one monitor to watch the video and a second monitor to do the labs.

Who this course is for
Working professionals who need learn how to write basic queries against a Microsoft SQL Server database
Anyone that needs to create reports using Power BI or Microsoft Reporting services
Anyone who is starting a career in AML, Data, Database or Programming who needs to write queries against data sets
Project managers who are responsible for enterprise data based projects
Why not have a look at the curriculum below and see what you can learn?