Microsoft SQL Server 2019 – Introduction to Data Analysis Course
$99.00
A self-paced course that takes you from your first T-SQL queries in SQL Server 2019 to data models, DAX, reports and dashboards in Power BI. Includes 13 hours 58 minutes over 77 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.
Microsoft SQL Server 2019 Introduction to Data Analysis is a self-paced course that takes you from writing your first T-SQL queries to building reports and dashboards in Power BI. It suits beginners, analysts and IT staff moving into data roles. You get 13 hours 58 minutes of training across 77 videos, plus 75 test questions.
What you will learn
- Use SQL Server Management Studio and command-line query tools
- Write SELECT queries with aliases, DISTINCT and CASE
- Join tables with inner, outer, cross and self joins
- Sort and filter data, and handle unknown (NULL) values
- Get, clean and transform data in Power BI
- Design data models with relationships and row-level security
- Write DAX measures, calculated columns and time intelligence
- Build reports, dashboards and paginated reports
- Use advanced visuals such as forecasts and key influencers
Course outline
- Query Tools
- Introduction to T-SQL Querying
- Basic SELECT Queries
- Querying Multiple Tables
- Sorting and Filtering Data
- Introduction to Business Intelligence and Data Modeling
- Prepare Data
- Clean, Transform, and Load Data
- Design a Data Model
- Create Model Calculations using DAX
- Create Reports
- Create Dashboards
- Create Paginated Reports
- Perform Advanced Analytics
- Create and Manage Workspaces
- Create Power App Visuals
- Analysis Services and Power BI
The first half teaches T-SQL in SQL Server, from query tools to joins and filtering. The second half moves into Power BI, where you prepare data, design a model, write DAX and build reports and dashboards. The course ends with advanced analytics, Power Apps visuals and a look at how Power BI works with Analysis Services.
Who this course is for
- Beginners who want to learn SQL Server and data analysis
- Data analysts who want stronger SQL Server skills
- BI developers who want to improve their reports
- IT staff and business analysts moving into data roles
Before you start
No formal prerequisites are listed. The course starts with the query tools and basic SELECT statements, so you can begin with no SQL experience. Basic spreadsheet skills will help when you reach Power BI.
The course is made up of 77 video lessons with a total running time of 13 hours 58 minutes. You can watch at your own pace, pause and replay any lesson, and come back to a topic whenever you need it. When you finish, use the 75 test questions to check what you have learned and spot any areas to review.
Jobs this course supports
- Data analyst
- Business intelligence developer
- Business analyst
- SQL developer
- Database administrator
- Data engineer
| Skill level | Beginner |
|---|---|
| Duration | 13 Hours 58 Minutes |
| Videos | 77 Course Videos |
| Questions | 75 Test Questions |
| Best for | Data analysts, BI developers, business analysts, beginners moving into data roles |
| Topics covered | SQL Server Management Studio, T-SQL SELECT queries, joins, sorting and filtering, Power BI data prep, data modelling, DAX, reports and dashboards |
| Format | Online video lessons, self-paced |
| Language | English |
| Closed captions | Yes |
| Certificate | StemBoss Certificate of Completion |
What is inside this course
17 modules and 77 lessons. Here is the full outline.
Module 1 - Query Tools3 lessons
- 1.1 Course Introduction
- 1.2 Intro to Management Studio
- 1.3 Intro to command-line query tools
Module 2 - Introduction to T-SQL Querying3 lessons
- 2.1 Introducing T-SQL
- 2.2 Understanding Sets
- 2.3 Understanding the Logical Order of Operations in SELECT statements
Module 3 - Basic SELECT Queries4 lessons
- 3.1 Writing Simple SELECT Statements
- 3.2 Eliminate Duplicates with DISTINCT
- 3.3 Using Column and Table Aliases
- 3.4 Write Simple CASE Expressions
Module 4 - Querying Multiple Tables4 lessons
- 4.1 Understanding Joins
- 4.2 Querying with Inner Joins
- 4.3 Querying with Outer Joins
- 4.4 Querying with Cross Joins and Self Joins
Module 5 - Sorting and Filtering Data4 lessons
- 5.1 Sorting Data
- 5.2 Filtering Data with Predicates
- 5.3 Filtering with the TOP and OFFSET-FETCH
- 5.4 Working with Unknown Values
Module 6 - Introduction to Business Intelligence and Data Modeling4 lessons
- 6.1 Introduction to Business Intelligence
- 6.2 The Microsoft Business Intelligence Platform
- 6.3 Exploring a Data Warehouse
- 6.4 Exploring a Data Model
Module 7 - Prepare Data3 lessons
- 7.1 Introduction to Power BI
- 7.2 Get data from various data sources
- 7.3 Preview source data
Module 8 - Clean, Transform, and Load Data7 lessons
- 8.1 Data Transformation Intro
- 8.2 Transformation Example 1
- 8.3 Transformation Example 2
- 8.4 Transformation Example 3
- 8.5 Transformation Example 4
- 8.6 Transformation Example 5
- 8.7 Transformation Example 6
Module 9 - Design a Data Model7 lessons
- 9.1 Introduction to Data Modeling
- 9.2 Model Relationships
- 9.3 Table Configuration
- 9.4 Model interface
- 9.5 Quick Measures
- 9.6 Many-to-many relationships
- 9.7 Row-level security
Module 10 - Create Model Calculations using DAX7 lessons
- 10.1 DAX context
- 10.2 Calculated Tables
- 10.3 Calculated Columns
- 10.4 Managing Date Tables
- 10.5 Measures
- 10.6 Filter Manipulation
- 10.7 Time Intelligence
Module 11 - Create Reports9 lessons
- 11.1 Basic Report Creation
- 11.2 Example Page 1
- 11.3 Example Page 2
- 11.4 Example Page 3
- 11.5 Report Publishing
- 11.6 Enhancing Reports
- 11.7 Drill-Through Pages
- 11.8 Conditional Formatting
- 11.9 Buttons and Bookmarks
Module 12 - Create Dashboards3 lessons
- 12.1 Dashboard Basics
- 12.2 Real Time Dashboards
- 12.3 Enhanced Dashboards
Module 13 - Create Paginated Reports4 lessons
- 13.1 Introduction to Power BI Report Builder
- 13.2 Report Layouts
- 13.3 Report Data
- 13.4 Report Tables
Module 14 - Perform Advanced Analytics5 lessons
- 14.1 Introduction to Advanced Analytics
- 14.2 Scatter Chart
- 14.3 Forecast
- 14.4 Decomposition Tree
- 14.5 Key Influencers
Module 15 - Create and Manage Workspaces2 lessons
- 15.1 Introduction to Workspaces
- 15.2 Working with Workspaces and the Portal
Module 16 - Create Power App Visuals4 lessons
- 16.1 Introduction to Power Apps Visual
- 16.2 Creating the App
- 16.3 Basic Power Apps Concepts
- 16.4 Refreshing the Report
Module 17 - Analysis Services and Power BI4 lessons
- 17.1 Introduction to Analysis Services
- 17.2 Connecting with Multidimensional Models
- 17.3 Premium Workspaces and Analysis Services
- 17.4 Course Wrap Up
Your learning path
Where Microsoft SQL Server 2019 - Introduction to Data Analysis Course fits. Build your skills one step at a time.
Frequently asked questions
Do I need to know SQL before I start?
No. The first modules cover the query tools, how T-SQL works and simple SELECT statements before moving on to joins and filtering.
Does the course cover Power BI as well as SQL Server?
Yes. Over half the course uses Power BI to prepare data, build data models, write DAX and create reports and dashboards.
What is DAX?
DAX is the formula language used in Power BI. You use it to build measures, calculated columns and time-based calculations.
Will I learn to build dashboards?
Yes. There are modules on reports, dashboards (including real-time ones) and paginated reports with Power BI Report Builder.
Does it link to SQL Server Analysis Services?
Yes. The final module shows how Power BI connects to Analysis Services models.
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.
