CF

SQL - MySQL for Data Analytics and Business Intelligence

9h 22m 55s
English
Paid
Updated September 2026

SQL - MySQL for Data Analytics and Business Intelligence is a 132-lesson 9 hours 22 minutes self-paced course by Udemy. Being able to pull your own data — instead of waiting on someone else to run a query for you — is the practical payoff of learning SQL, and this 132-lesson course builds that independence from the ground up in MySQL.

Course facts

Lessons
132
Duration
9 hours 22 minutes
Level
All levels
Language
English
Updated
2026-09-11
Instructor
Udemy
Price
Premium

Being able to pull your own data — instead of waiting on someone else to run a query for you — is the practical payoff of learning SQL, and this 132-lesson course builds that independence from the ground up in MySQL.

Why it's worth the time

Database skills sit underneath most business intelligence work, and demand for people who have them keeps outpacing supply — SQL developer salaries have been reported around $92,000. No prior experience is assumed; the course starts at the basics and adds complexity gradually.

What's covered

  • Designing, creating and managing relational databases in MySQL Workbench
  • Writing aggregate functions and complex joins to answer business questions
  • Advanced topics such as triggers, sequences and indexing
  • Downloadable exercises, notes and quizzes to reinforce each topic

More than 210,000 students have already taken this course, which ends with a completion certificate you can add to your resume.

Who teaches SQL - MySQL for Data Analytics and Business Intelligence? Udemy

Udemy thumbnail

Udemy is the largest open marketplace for online courses on the internet. Founded in 2010 by Eren Bali, Oktay Caglar, and Gagan Biyani and headquartered in San Francisco, the company went public on the Nasdaq in 2021 under the ticker UDMY. The platform hosts well over two hundred thousand courses across software development, IT and cloud, data science, design, business, marketing, and creative skills, taught by tens of thousands of independent instructors. Roughly seventy million learners use it worldwide, and the corporate arm — Udemy Business — supplies a curated subset of that catalog to enterprise customers.

Because Udemy is a marketplace rather than a single editorial publisher, the catalog is uneven by design. The strongest material lives in the long-form, project-based courses authored by working engineers — full-stack JavaScript, React, Node.js, Python data science, AWS, Docker and Kubernetes, mobile development with Flutter and React Native, and cloud certification preparation. The CourseFlix listing under this source is the slice of that catalog that has been mirrored here for offline-friendly viewing, organized by topic and updated as new releases land. Pricing on Udemy itself swings dramatically with the site's near-permanent sales, which is why the platform is best treated as a deep reference catalog: pick instructors with strong reviews and a track record of updating their material rather than buying on the headline price alone.

What lessons are included in SQL - MySQL for Data Analytics and Business Intelligence?

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 132 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: What does the course cover?
All Course Lessons (132)
#Lesson TitleDurationAccess
1
What does the course cover? Demo
04:15
2
Why SQL?
03:18
3
Why MySQL?
01:58
4
Introduction to databases
04:45
5
SQL as a declarative language
02:12
6
Data definition language (DDL)
04:14
7
SQL keywords
01:13
8
Data manipulation language (DML)
04:56
9
Data control language (DCL)
05:04
10
Transaction control language (TCL)
03:03
11
Relational database essentials
04:52
12
Databases vs spreadsheets
08:07
13
Database terminology
04:18
14
Relational schemas - Primary key
04:56
15
Relational schemas - Foreign key
05:00
16
Relational schemas - Unique key and null values
03:08
17
Relationships
04:40
18
Installing MySQL
10:49
19
Setting up a connection
02:35
20
New Authentication Plugin - Creating a New User
06:19
21
Introduction to the MySQL interface
05:10
22
Creating a Database - Part I
05:13
23
Creating a Database - Part II
02:23
24
Introduction to data types
02:17
25
String data types
05:02
26
Integers
04:11
27
Fixed and floating-point data types
05:45
28
Other useful data types
06:13
29
Creating a table
05:18
30
Using databases and tables
03:04
31
Additional notes on using tables
02:13
32
PRIMARY KEY constraint
05:24
33
FOREIGN KEY constraint - Part I
05:26
34
FOREIGN KEY constraint - Part II
05:27
35
UNIQUE Constraint
05:01
36
DEFAULT Constraint
05:25
37
NOT NULL Constraint - Part I
05:54
38
NOT NULL Constraint - Part II
02:00
39
Coding techniques and best practices - Part I
05:35
40
Coding techniques and best practices - Part II
04:12
41
Loading the 'employees' database
02:20
42
SELECT - FROM
04:58
43
WHERE
02:31
44
AND
02:15
45
OR
03:36
46
Operator precedence
03:35
47
IN - NOT IN
03:13
48
LIKE - NOT LIKE
03:37
49
Wildcard characters
01:46
50
BETWEEN - AND
02:21
51
IS NOT NULL - IS NULL
01:38
52
Other comparison operators
04:31
53
SELECT DISTINCT
02:07
54
Introduction to aggregate functions
05:25
55
ORDER BY
03:47
56
GROUP BY
06:01
57
Using Aliases (AS)
02:09
58
HAVING
03:27
59
WHERE vs HAVING- Part I
04:05
60
WHERE vs HAVING- Part II
03:09
61
LIMIT
04:53
62
The INSERT statement - Part I
06:06
63
The INSERT statement - Part II
02:20
64
Inserting data INTO a new table
03:57
65
TCL's COMMIT and ROLLBACK
02:43
66
The UPDATE Statement - Part I
03:19
67
The UPDATE Statement - Part II
02:56
68
The DELETE Statement - Part I
04:15
69
The DELETE Statement - Part II
01:31
70
DROP vs TRUNCATE vs DELETE
03:24
71
COUNT()
04:15
72
SUM()
01:32
73
MIN() and MAX()
01:16
74
AVG()
01:59
75
ROUND()
02:07
76
IFNULL() and COALESCE()
06:26
77
Another Example of Using COALESCE()
01:37
78
Introduction to JOINs
04:24
79
INNER JOIN - Part I
06:04
80
INNER JOIN - Part II
05:34
81
A Note on Using Joins
04:10
82
Duplicate Records
04:22
83
LEFT JOIN - Part I
04:32
84
LEFT JOIN - Part II
05:47
85
RIGHT JOIN
04:31
86
The new and the old join syntax
04:18
87
JOIN and WHERE Used Together
02:54
88
CROSS JOIN
07:43
89
Using Aggregate Functions with Joins
02:18
90
JOIN more than two tables in SQL
04:28
91
Tips and tricks for joins
05:40
92
UNION vs UNION ALL
05:45
93
SQL Subqueries with IN nested inside WHERE
04:32
94
SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE
03:43
95
SQL Subqueries nested in SELECT and FROM
07:58
96
Self Join
07:46
97
Views
07:13
98
Introduction to stored routines
03:27
99
The MySQL syntax for stored procedures
04:33
100
Stored procedures - Example - Part I
02:46
101
Stored procedures - Example - Part II
04:50
102
Another way to create a procedure
03:20
103
Stored procedures with an input parameter
06:30
104
Stored procedures with an output parameter
03:21
105
Variables
06:51
106
User-defined functions in MySQL
06:15
107
Stored routines - conclusion
03:56
108
Types of MySQL Variables - Local Variables
04:57
109
Session Variables
05:22
110
Global Variables
02:19
111
User-Defined vs System Variables
04:13
112
MySQL Indexes
07:28
113
The CASE Statement
05:58
114
The Advantages of Software Integration
05:21
115
Why Combining SQL and Tableau is useful
04:55
116
Installing Tableau Public
01:52
117
Loading the 'employees_mod' Database
03:23
118
Task 1
05:34
119
Task 1: SQL Solution
04:42
120
Transferring a Dataset from SQL to Tableau
04:14
121
Chart 1: Visualizing and Analyzing the Solution in Tableau - Part I
06:18
122
Chart 1: Visualizing and Analyzing the Solution in Tableau - Part II
05:26
123
Task 2
03:51
124
Task 2: SQL Solution
03:44
125
Chart 2: Visualizing and Analyzing the Solution in Tableau
06:09
126
Task 3
02:22
127
Task 3: SQL Solution
03:15
128
Chart 3: Visualizing and Analyzing the Solution in Tableau
04:57
129
Task 4
02:46
130
Task 4: Solution in SQL
02:48
131
Chart 4: Visualizing and Analyzing the Solution in Tableau
03:23
132
Task 5: Organizing Charts 1-4 into a Beautiful Dashboard using Tableau
06:05
Unlock unlimited learning

Get instant access to all 131 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

What courses are similar to SQL - MySQL for Data Analytics and Business Intelligence?

More courses by Udemy

Frequently asked questions

What prerequisites are needed for this SQL course?
This SQL course is designed for beginners, so no prior experience in SQL or database management is required. The course starts from the basics and builds your understanding step by step, ensuring that all foundational aspects are covered.
What real-life projects will I work on in this course?
The course includes practical, real-life database project work. You will work with the 'employees' database, which allows you to apply SQL concepts and techniques in a realistic setting. This hands-on experience is crucial for understanding how SQL is used in data analytics and business intelligence.
Who is the target audience for this SQL course?
The course is ideal for anyone looking to enter the field of data analytics or business intelligence. It is also suitable for professionals who want to enhance their skills in database management and those seeking a competitive edge in the job market.
How does this course compare to other SQL courses in terms of scope?
This course is comprehensive, covering unique topics like relational database essentials, various SQL commands (DDL, DML, DCL, TCL), and best coding practices. It offers a detailed exploration of MySQL, the leading SQL database management system, unlike some courses that may not focus on this specific platform.
What specific tools or platforms does the course focus on?
The course focuses on MySQL, a leading SQL database management system. You will learn how to install MySQL, set up connections, and navigate the MySQL interface. The course is rich in demonstrations and exercises specific to MySQL, ensuring a thorough understanding of this platform.
What topics are not covered in this SQL course?
The course does not cover advanced SQL topics such as stored procedures, triggers, or advanced optimization techniques. It focuses on foundational SQL concepts and practical application using MySQL, making it suitable for beginners and those looking to strengthen their basic SQL skills.
What is the expected time commitment for completing this course?
The course consists of 132 lessons with a focus on time-efficient and concise learning. While the total runtime is not specified, the course's structure is designed to be manageable and aligned with professional best practices, allowing learners to progress at their own pace.