When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Specialization?

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

SQL Fundamentals for Data Analysts

This course is part of multiple programs.

Instructor: CFI (Corporate Finance Institute)

12,480 already enrolled

Included with

Learn more

7 modules

Gain insight into a topic and learn the fundamentals.

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

76 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

91% of learners achieved a positive career outcome

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

Module details

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 videosTotal 45 minutes

Introduction1 minute
Installation and Introduction to Azure Data Studio1 minute
Creating a Connection to a Database2 minutes
What is Adventure Works?1 minute
Example SQL Code2 minutes
Saving Your Queries in Notepad2 minutes
SELECT and FROM2 minutes
SELECT Specific Columns3 minutes
Creating a Column Alias2 minutes
Using WHERE to Filter Rows2 minutes
Checking the Impact of a WHERE Filter0 minutes
Limiting Results to 1 Invoice Number for Testing1 minute
Using GROUP BY to Combine Rows2 minutes
Using GROUP BY to Combine Invoice Numbers2 minutes
Using HAVING to Filter Grouped Rows1 minute
Filtering Grouped Invoices with HAVING1 minute
SQL Order of Operations3 minutes
Using ORDER BY to Sort Query Rows1 minute
Recap and Common Errors2 minutes
Filtering Rows TOP N2 minutes
Filtering Rows TOP N Percent2 minutes
Filtering Rows OFFSET FETCH2 minutes
Filtering Rows DISTINCT2 minutes
ORDER BY Another Column1 minute
ORDER BY Another Column1 minute
Exercise 1a1 minute
Exercise 1a Review1 minute
Exercise 1b1 minute
Exercise 1b Review0 minutes
Exercise 1c1 minute
Exercise 1c Review1 minute

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

What's included

40 videos

40 videosTotal 79 minutes

Introduction1 minute
Recap of Aggregate Functions1 minute
Counting Rows with COUNT( ) Aggregation2 minutes
How Aggregate Functions Respond to NULL Values1 minute
The Importance of Data Types1 minute
Numeric Data Types2 minutes
Numeric Functions2 minutes
Where is the Boolean Data Type2 minutes
Date and Time Data Types1 minute
Date Parts0 minutes
Date and Time Functions1 minute
Date and Time Functions in Practice4 minutes
The DATEADD Function1 minute
Working with Specific Dates2 minutes
Server Properties Collation4 minutes
Text or String Data Types2 minutes
String Functions1 minute
The CONCAT String Function2 minutes
LEN UPPER LOWER REPLACE String functions2 minutes
Flexible LEFT and RIGHT Functions3 minutes
Comparison Operators3 minutes
Comparison Operators - Dealing with NULL3 minutes
Logical Operators1 minute
Logical Operators - Common Errors4 minutes
Advanced Logical Operators - IN and BETWEEN1 minute
IN and BETWEEN in Practice4 minutes
Advanced Logical Operators - LIKE1 minute
LIKE in Practice3 minutes
Using IIF Statements to Create a Conditional Column1 minute
Using a CASE Statement for Multiple Conditions4 minutes
Basic SQL Formatting1 minute
Using IIF in a WHERE Statement1 minute
Replacing NULL Using IIF, ISNULL and COALESCE3 minutes
Using CAST to Change the Data Type1 minute
Practical Examples Using CAST4 minutes
Using a NATIONAL for UNICODE Best Practice2 minutes
Exercise 2a0 minutes
Exercise 2a Review1 minute
Exercise 2b1 minute
Exercise 2b Review2 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 videosTotal 21 minutes

Introduction1 minute
A History of SQL1 minute
SQL Terminology3 minutes
RDBMS Installation Options2 minutes
Data Security3 minutes
Types of Database System2 minutes
Data Normalization in OLTP Systems3 minutes
De-normalization in DW Systems1 minute
Fact and Dimension Tables1 minute
Relationships & Keys1 minute
The Star Schema1 minute
Snowflake Hybrid Schema2 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.