SQL Fundamentals for Data Analysts

This course is part of multiple programs.

Instructor: CFI (Corporate Finance Institute)

Access provided by BIDAcademy

10,554 already enrolled

7 modules

Gain insight into a topic and learn the fundamentals.

69 reviews

Beginner level

No prior experience required

5 hours to complete

Flexible schedule

Learn at your own pace

7 modules

Gain insight into a topic and learn the fundamentals.

69 reviews

Beginner level

No prior experience required

5 hours to complete

Flexible schedule

Learn at your own pace

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

1 assignment

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is available as part of

When you enroll in this course, you'll also be asked to select a specific program.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 7 modules in this course

Focus on the skills you need to get started with SQL as a data analyst, allowing you to read & transform data and gather insights from a company database.

• Learn the basic SQL syntax that will help you access a whole new world of data. • Focus on the read-only functionality that matters for a data analyst, and get to insights quickly. • Perform the basics of data sorting, filtering, and aggregation in SQL to start uncovering valuable insights • Solidify your understanding through real-world scenarios, applying your newfound SQL skills in a variety of practical exercises

Welcome to the SQL Fundamentals course.

What's included

1 video1 reading

In this module, we will learn to retrieve and filter data using basic SQL queries.

What's included

31 videos

31 videos Total 45 minutes

Introduction 1 minute
Installation and Introduction to Azure Data Studio 1 minute
Creating a Connection to a Database 2 minutes
What is Adventure Works? 1 minute
Example SQL Code 2 minutes
Saving Your Queries in Notepad 2 minutes
SELECT and FROM 2 minutes
SELECT Specific Columns 3 minutes
Creating a Column Alias 2 minutes
Using WHERE to Filter Rows 2 minutes
Checking the Impact of a WHERE Filter 0 minutes
Limiting Results to 1 Invoice Number for Testing 1 minute
Using GROUP BY to Combine Rows 2 minutes
Using GROUP BY to Combine Invoice Numbers 2 minutes
Using HAVING to Filter Grouped Rows 1 minute
Filtering Grouped Invoices with HAVING 1 minute
SQL Order of Operations 3 minutes
Using ORDER BY to Sort Query Rows 1 minute
Recap and Common Errors 2 minutes
Filtering Rows TOP N 2 minutes
Filtering Rows TOP N Percent 2 minutes
Filtering Rows OFFSET FETCH 2 minutes
Filtering Rows DISTINCT 2 minutes
ORDER BY Another Column 1 minute
ORDER BY Another Column 1 minute
Exercise 1a 1 minute
Exercise 1a Review 1 minute
Exercise 1b 1 minute
Exercise 1b Review 0 minutes
Exercise 1c 1 minute
Exercise 1c Review 1 minute

In this module, we will learn manipulate data with the help of numerical date and text functions.

What's included

40 videos

40 videos Total 79 minutes

Introduction 1 minute
Recap of Aggregate Functions 1 minute
Counting Rows with COUNT( ) Aggregation 2 minutes
How Aggregate Functions Respond to NULL Values 1 minute
The Importance of Data Types 1 minute
Numeric Data Types 2 minutes
Numeric Functions 2 minutes
Where is the Boolean Data Type 2 minutes
Date and Time Data Types 1 minute
Date Parts 0 minutes
Date and Time Functions 1 minute
Date and Time Functions in Practice 4 minutes
The DATEADD Function 1 minute
Working with Specific Dates 2 minutes
Server Properties Collation 4 minutes
Text or String Data Types 2 minutes
String Functions 1 minute
The CONCAT String Function 2 minutes
LEN UPPER LOWER REPLACE String functions 2 minutes
Flexible LEFT and RIGHT Functions 3 minutes
Comparison Operators 3 minutes
Comparison Operators - Dealing with NULL 3 minutes
Logical Operators 1 minute
Logical Operators - Common Errors 4 minutes
Advanced Logical Operators - IN and BETWEEN 1 minute
IN and BETWEEN in Practice 4 minutes
Advanced Logical Operators - LIKE 1 minute
LIKE in Practice 3 minutes
Using IIF Statements to Create a Conditional Column 1 minute
Using a CASE Statement for Multiple Conditions 4 minutes
Basic SQL Formatting 1 minute
Using IIF in a WHERE Statement 1 minute
Replacing NULL Using IIF, ISNULL and COALESCE 3 minutes
Using CAST to Change the Data Type 1 minute
Practical Examples Using CAST 4 minutes
Using a NATIONAL for UNICODE Best Practice 2 minutes
Exercise 2a 0 minutes
Exercise 2a Review 1 minute
Exercise 2b 1 minute
Exercise 2b Review 2 minutes

In this module, we will learn the difference between OLTP and data warehouse and also understand the essential terminology related to SQL.

What's included

12 videos

12 videos Total 21 minutes

Introduction 1 minute
A History of SQL 1 minute
SQL Terminology 3 minutes
RDBMS Installation Options 2 minutes
Data Security 3 minutes
Types of Database System 2 minutes
Data Normalization in OLTP Systems 3 minutes
De-normalization in DW Systems 1 minute
Fact and Dimension Tables 1 minute
Relationships & Keys 1 minute
The Star Schema 1 minute
Snowflake Hybrid Schema 2 minutes

In this module, we will learn to combine data from multiple tables using a single query. Additionally, we will understand how SQL databases deal with many-to-many relationships.