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