SQL Fundamentals for Data Analysts (Coursera)

SQL Fundamentals for Data Analysts (Coursera)

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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

• 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
This course is part of the BI Essentials for Finance Analysts (Power BI Edition) Specialization.

Syllabus

Getting Started
Welcome to the SQL Fundamentals course.

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

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

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

Working with Multiple Tables
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.

Advanced Functions and Queries
In this module, we will learn how to use SQL in popular BI tools and create summary reports using advanced functions.

Qualified Assessment

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Foundations of mining non-structured medical data (Coursera) Coursera
EIT Digital

Foundations of mining non-structured medical data (Coursera)

The goal of this course is to understand the foundations of Big Data and the data that is being generated in the health domain and how the use of technology would help to integrate and exploit all those data to extract meaningful information that can be later used in different sectors of the health domain from physicians to management, from patients to care givers, etc.

Jul 27th 2026
5-12 Weeks
Spatial Data Science and Applications (Coursera) Coursera
Yonsei University

Spatial Data Science and Applications (Coursera)

Spatial (map) is considered as a core infrastructure of modern IT world, which is substantiated by business transactions of major IT companies such as Apple, Google, Microsoft, Amazon, Intel, and Uber, and even motor companies such as Audi, BMW, and Mercedes. Consequently, they are bound to hire more and more spatial data scientists. Based on such business trend, this course is designed to present a firm understanding of spatial data science to the learners, who would have a basic knowledge of data science and data analysis, and eventually to make their expertise differentiated from other nominal data scientists and data analysts.

Aug 10th 2026
5-12 Weeks
Cloud Data Security (Coursera) Coursera
University of Minnesota

Cloud Data Security (Coursera)

This course gives learners an opportunity to explore data security in the cloud. In this course, learners will: dive into the data services offered by cloud providers and compare their security features; analyze a data breach and trace it back to the vulnerability that made it possible; learn about database injection and aggregation attacks; follow the life cycle of a data item and its relationship to privacy and integrity; associate modern privacy requirements with US and European laws.

Jul 27th 2026
4 Weeks
Business intelligence and data analytics: Generate insights (Coursera) Coursera
Macquarie University

Business intelligence and data analytics: Generate insights (Coursera)

‘Megatrends’ heavily influence today’s organisations, industries and societies, and your ability to generate insights in this area is crucial to your organisation’s success into the future. This course will introduce you to analytical tools and skills you can use to understand, analyse and evaluate the challenges and opportunities ‘megatrends’ will inevitably bring to your organisation.

Jul 27th 2026
5-12 Weeks
Understanding China, 1700-2000: A Data Analytic Approach, Part 2 (Coursera) Coursera
The Hong Kong University of Science and Technology - HKUST

Understanding China, 1700-2000: A Data Analytic Approach, Part 2 (Coursera)

The purpose of this course is to summarize new directions in Chinese history and social science produced by the creation and analysis of big historical datasets based on newly opened Chinese archival holdings, and to organize this knowledge in a framework that encourages learning about China in comparative perspective. Our course demonstrates how a new scholarship of discovery is redefining what is singular about modern China and modern Chinese history.

Aug 3rd 2026
4 Weeks
Building Web Applications in Django (Coursera) Coursera
University of Michigan

Building Web Applications in Django (Coursera)

In this course, you will learn how Django communicates with a database through model objects. You will explore Object-Relational Mapping (ORM) for database access and how Django models implement this pattern. We will review the Object-Oriented (OO) pattern in Python. You will learn basic Structured Query Language (SQL) and database modeling, including one-to-many and many-to-many relationships and how they work in both the SQL and Django models. You will learn how to use the Django console and scripts to work with your application objects interactively.

Jul 27th 2026
4 Weeks