SQL – MySQL for Data Analytics and Business Intelligence

About Course

Learn SQL with this comprehensive and practical course, taught in MySQL – the most popular SQL database management system. This course will teach you everything you need to know about SQL, from the basics to advanced concepts. You will learn how to work with a real-life database and gain the skills needed for a successful career in data analytics and business intelligence.

This free course will cover:

The basics of SQL
Data types and operators
Creating, modifying, and deleting tables
Selecting, inserting, updating, and deleting data
Joining tables
Creating views and stored procedures
Using functions and aggregates
Working with subqueries
Understanding database security

This course is perfect for beginners with no prior experience in SQL. You will learn everything you need to know about SQL in a step-by-step manner. The course also includes plenty of downloadable exercises, course notes, and quiz questions to help you learn and practice. This course is offered free of charge and is available on Theetay, a website that provides free access to online courses from platforms like Udemy, Udacity, Coursera, MasterClass, and NearPeer.

Benefits of learning SQL:

High-paying career: The average salary of a SQL developer is $103,400.
In-demand skill: As data continues to grow in importance, so too will the demand for SQL skills.
Analytical reasoning: Learning SQL can help you develop analytical reasoning skills.

Enroll in this free course today and start your journey to becoming a SQL expert.

Become an expert in SQL
Learn how to code in SQL
Boost your resume by learning an in-demand skill
Create, design, and operate with SQL databases
Start using MySQL – the #1 Database Management System
Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
Adopt professionally tested SQL best practices
Gain theoretical insights about relational databases
Work with a sophisticated real-life database throughout the course
Get maximum preparation for real-life database management
Add data analytical tools to your skillset
Develop business intuition while solving tasks with big data
Study relational database management theory that you will need in your workplace every day
Learn how to create a database from scratch
The ability to take control of your dataset – insert, update, and delete records from your database
Be confident while working with constraints and relating data tables
Become a proficient MySQL Workbench user
Acquire top-notch coding techniques and best practices
Know how to answer specific business questions by using SQL’s aggregate functions
Handle complex SQL joins with ease
Approach more advanced topics in programming like SQL’s triggers, sequences, local and global variables, indexes, and more
Merge coding skills and business acumen to solve complex analytical problems
Become a proficient SQL user by writing flawless and efficient queries
Tons of exercises that will solidify your knowledge
The freedom to query anything you like from a database

Course Content

01 – Introduction to databases SQL and MySQL

A Message from the Professor
001 – What does the course cover.mp4

00:00
002 – Why SQL.mp4

00:00
003 – Why MySQL.mp4

00:00
004 – Introduction to databases.mp4

00:00
Section Quiz

02 – SQL theory

03 – Basic database terminology

04 – Installing MySQL and getting acquainted with the interface

018 – Installing MySQL.mp4

00:00
019 – Additional note Installing Visual C.html

00:00
020 – Installing MySQL on macOS and Unix systems.html

00:00
021 – The ClientServer Model.html

00:00
022 – Setting up a connection.mp4

00:00
023 – Read me.html

00:00
024 – New Authentication Plugin Creating a New User.mp4

00:00
025 – Introduction to the MySQL interface.mp4

00:00
Section Quiz

05 – First steps in SQL

026 – Creating a Database Part I.mp4

00:00
027 – SQL files.html

00:00
028 – Creating a Database Part I exercise.html

00:00
029 – Creating a Database Part I solution.html

00:00
030 – Creating a Database Part II.mp4

00:00
031 – Creating a Database Part II exercise.html

00:00
032 – Creating a Database Part II solution.html

00:00
033 – Introduction to data types.mp4

00:00
034 – String data types.mp4

00:00
035 – Integers.mp4

00:00
036 – Fixed and floatingpoint data types.mp4

00:00
037 – Other useful data types.mp4

00:00
038 – Creating a table.mp4

00:00
039 – Creating a table exercise.html

00:00
040 – Creating a table solution.html

00:00
041 – Using databases and tables.mp4

00:00
042 – Using databases and tables exercise.html

00:00
043 – Using databases and tables solution.html

00:00
044 – Additional notes on using tables.mp4

00:00
045 – Additional notes on using tables exercise.html

00:00
Section Quiz

06 – MySQL constraints

046 – PRIMARY KEY constraint.mp4

00:00
047 – PRIMARY KEY constraint exercise.html

00:00
048 – PRIMARY KEY constraint solution.html

00:00
049 – FOREIGN KEY constraint Part I.mp4

00:00
050 – FOREIGN KEY constraint Part II.mp4

00:00
051 – FOREIGN KEY constraint Part II exercise.html

00:00
052 – FOREIGN KEY constraint Part II solution.html

00:00
053 – UNIQUE Constraint.mp4

00:00
054 – UNIQUE Constraint exercise.html

00:00
055 – DEFAULT Constraint.mp4

00:00
056 – DEFAULT Constraint exercise.html

00:00
057 – DEFAULT Constraint solution.html

00:00
058 – NOT NULL Constraint Part I.mp4

00:00
059 – NOT NULL Constraint Part I exercise.html

00:00
060 – NOT NULL Constraint Part I solution.html

00:00
061 – NOT NULL Constraint Part II.mp4

00:00
Section Quiz

07 – SQL best practices

08 – Loading the employees database

09 – SQL SELECT statement

066 – SELECT FROM.mp4

00:00
067 – SELECT FROM exercise.html

00:00
068 – SELECT FROM solution.html

00:00
069 – WHERE.mp4

00:00
070 – WHERE exercise.html

00:00
071 – WHERE solution.html

00:00
072 – AND.mp4

00:00
073 – AND exercise.html

00:00
074 – AND solution.html

00:00
075 – OR.mp4

00:00
076 – OR exercise.html

00:00
077 – OR solution.html

00:00
078 – Operator precedence.mp4

00:00
079 – Operator precedence exercise.html

00:00
080 – Operator precedence solution.html

00:00
081 – IN NOT IN.mp4

00:00
082 – IN NOT IN exercise 1.html

00:00
083 – IN NOT IN solution 1.html

00:00
084 – IN NOT IN exercise 2.html

00:00
085 – IN NOT IN solution 2.html

00:00
086 – LIKE NOT LIKE.mp4

00:00
087 – LIKE NOT LIKE exercise.html

00:00
088 – LIKE NOT LIKE solution.html

00:00
089 – Wildcard characters.mp4

00:00
090 – Wildcard characters exercise.html

00:00
091 – Wildcard characters solution.html

00:00
092 – BETWEEN AND.mp4

00:00
093 – BETWEEN AND exercise.html

00:00
094 – BETWEEN AND solution.html

00:00
095 – IS NOT NULL IS NULL.mp4

00:00
096 – IS NOT NULL IS NULL exercise.html

00:00
097 – IS NOT NULL IS NULL solution.html

00:00
098 – Other comparison operators.mp4

00:00
099 – Other comparison operators exercise.html

00:00
100 – Other comparison operators solution.html

00:00
101 – SELECT DISTINCT.mp4

00:00
102 – SELECT DISTINCT exercise.html

00:00
103 – SELECT DISTINCT solution.html

00:00
104 – Introduction to aggregate functions.mp4

00:00
105 – Introduction to aggregate functions exercise.html

00:00
106 – Introduction to aggregate functions solution.html

00:00
107 – ORDER BY.mp4

00:00
108 – ORDER BY exercise.html

00:00
109 – ORDER BY solution.html

00:00
110 – GROUP BY.mp4

00:00
111 – Using Aliases AS.mp4

00:00
112 – Using Aliases AS exercise.html

00:00
113 – Using Aliases AS solution.html

00:00
114 – HAVING.mp4

00:00
115 – HAVING exercise.html

00:00
116 – HAVING solution.html

00:00
117 – WHERE vs HAVING Part I.mp4

00:00
118 – WHERE vs HAVING Part II.mp4

00:00
119 – WHERE vs HAVING Part II exercise.html

00:00
120 – WHERE vs HAVING Part II solution.html

00:00
121 – LIMIT.mp4

00:00
122 – LIMIT exercise.html

00:00
123 – LIMIT solution.html

00:00
Section Quiz

10 – SQL INSERT statement

124 – The INSERT statement Part I.mp4

00:00
125 – The INSERT statement Part II.mp4

00:00
126 – The INSERT statement exercise 1.html

00:00
127 – The INSERT statement solution 1.html

00:00
128 – The INSERT statement exercise 2.html

00:00
129 – The INSERT statement solution 2.html

00:00
130 – Inserting data INTO a new table.mp4

00:00
131 – Inserting Data INTO a New Table exercise.html

00:00
132 – Inserting Data INTO a New Table solution.html

00:00
Section Quiz

11 – SQL UPDATE Statement

12 – SQL DELETE Statement

13 – MySQL Aggregate functions

144 – COUNT.mp4

00:00
145 – COUNT exercise.html

00:00
146 – COUNT solution.html

00:00
147 – SUM.mp4

00:00
148 – SUM exercise.html

00:00
149 – SUM solution.html

00:00
150 – MIN and MAX.mp4

00:00
151 – MIN and MAX exercise.html

00:00
152 – MIN and MAX solution.html

00:00
153 – AVG.mp4

00:00
154 – AVG exercise.html

00:00
155 – AVG solution.html

00:00
156 – ROUND.mp4

00:00
157 – ROUND exercise.html

00:00
158 – ROUND solution.html

00:00
159 – COALESCE Preamble.html

00:00
160 – IFNULL and COALESCE.mp4

00:00
161 – Another Example of Using COALESCE.mp4

00:00
162 – Another example of using COALESCE exercise 1.html

00:00
163 – Another example of using COALESCE solution 1.html

00:00
164 – Another example of using COALESCE exercise 2.html

00:00
165 – Another example of using COALESCE solution 2.html

00:00
Section Quiz

14 – SQL Joins

166 – Introduction to JOINs.mp4

00:00
167 – Intro to JOINs exercise 1.html

00:00
168 – Intro to JOINs solution 1.html

00:00
169 – Intro to JOINs exercise 2.html

00:00
170 – INNER JOIN Part I.mp4

00:00
171 – INNER JOIN Part II.mp4

00:00
172 – INNER JOIN Part II exercise.html

00:00
173 – INNER JOIN Part II solution.html

00:00
174 – A Note on Using Joins.mp4

00:00
175 – Duplicate Records.mp4

00:00
176 – LEFT JOIN Part I.mp4

00:00
177 – LEFT JOIN Part II.mp4

00:00
178 – LEFT JOIN Part II exercise.html

00:00
179 – LEFT JOIN Part II solution.html

00:00
180 – RIGHT JOIN.mp4

00:00
181 – The new and the old join syntax.mp4

00:00
182 – The new and the old join syntax exercise.html

00:00
183 – The new and the old join syntax solution.html

00:00
184 – JOIN and WHERE Used Together.mp4

00:00
185 – Important Prevent Error Code 1055.html

00:00
186 – JOIN and WHERE Used Together exercise.html

00:00
187 – JOIN and WHERE Used Together solution.html

00:00
188 – CROSS JOIN.mp4

00:00
189 – CROSS JOIN exercise 1.html

00:00
190 – CROSS JOIN solution 1.html

00:00
191 – CROSS JOIN exercise 2.html

00:00
192 – CROSS JOIN solution 2.html

00:00
193 – Using Aggregate Functions with Joins.mp4

00:00
194 – JOIN more than two tables in SQL.mp4

00:00
195 – Join more than two tables in SQL exercise.html

00:00
196 – Join more than two tables in SQL solution.html

00:00
197 – Tips and tricks for joins.mp4

00:00
198 – Tips and tricks for joins exercise.html

00:00
199 – Tips and tricks for joins solution.html

00:00
200 – UNION vs UNION ALL.mp4

00:00
201 – UNION vs UNION ALL exercise.html

00:00
202 – UNION vs UNION ALL solution.html

00:00
Section Quiz

15 – SQL Subqueries

203 – SQL Subqueries with IN nested inside WHERE.mp4

00:00
204 – SQL Subqueries with IN nested inside WHERE exercise.html

00:00
205 – SQL Subqueries with IN nested inside WHERE solution.html

00:00
206 – SQL Subqueries with EXISTSNOT EXISTS nested inside WHERE.mp4

00:00
207 – SQL Subqueries with EXISTSNOT EXISTS nested inside WHERE exercise.html

00:00
208 – SQL Subqueries with EXISTSNOT EXISTS nested inside WHERE solution.html

00:00
209 – SQL Subqueries nested in SELECT and FROM.mp4

00:00
210 – SQL Subqueries nested in SELECT and FROM exercise 1.html

00:00
211 – SQL Subqueries nested in SELECT and FROM solution 1.html

00:00
212 – SQL Subqueries nested in SELECT and FROM exercise 2.html

00:00
213 – SQL Subqueries nested in SELECT and FROM solution 2.html

00:00
Section Quiz

16 – SQL Self Join

17 – SQL Views

18 – Stored routines

218 – Introduction to stored routines.mp4

00:00
219 – The MySQL syntax for stored procedures.mp4

00:00
220 – Stored procedures Example Part I.mp4

00:00
221 – Stored procedures Example Part II.mp4

00:00
222 – Stored procedures Example Part II exercise.html

00:00
223 – Stored procedures Example Part II solution.html

00:00
224 – Another way to create a procedure.mp4

00:00
225 – Stored procedures with an input parameter.mp4

00:00
226 – Stored procedures with an output parameter.mp4

00:00
227 – Stored procedures with an output parameter exercise.html

00:00
228 – Stored procedures with an output parameter solution.html

00:00
229 – Variables.mp4

00:00
230 – Variables exercise.html

00:00
231 – Variables solution.html

00:00
232 – Userdefined functions in MySQL.mp4

00:00
233 – Error Code 1418.html

00:00
234 – Userdefined functions in MySQL exercise.html

00:00
235 – Userdefined functions in MySQL solution.html

00:00
236 – Stored routines conclusion.mp4

00:00
Section Quiz

19 – Advanced SQL Topics

237 – Types of MySQL Variables Local Variables.mp4

00:00
238 – Session Variables.mp4

00:00
239 – Global Variables.mp4

00:00
240 – UserDefined vs System Variables.mp4

00:00
241 – MySQL Triggers.html

00:00
242 – MySQL Triggers.mp4

00:00
243 – MySQL Triggers exercise.html

00:00
244 – MySQL Triggers solution.html

00:00
245 – MySQL Indexes.mp4

00:00
246 – MySQL Indexes exercise 1.html

00:00
247 – MySQL Indexes solution 1.html

00:00
248 – MySQL Indexes exercise 2.html

00:00
249 – MySQL Indexes solution 2.html

00:00
250 – The CASE Statement.mp4

00:00
251 – The CASE Statement exercise 1.html

00:00
252 – The CASE Statement solution 1.html

00:00
253 – The CASE Statement exercise 2.html

00:00
254 – The CASE Statement solution 2.html

00:00
255 – The CASE Statement exercise 3.html

00:00
256 – The CASE Statement solution 3.html

00:00
Section Quiz

20 – SQL Window Functions

257 – Introduction to MySQL Window Functions.mp4

00:00
258 – The ROWNUMBER Ranking Window Function and the Relevant MySQL Syntax.mp4

00:00
259 – The ROWNUMBER Ranking Window Function Exercises.html

00:00
260 – The ROWNUMBER Ranking Window Function Solution.html

00:00
261 – A Note on Using Several Window Functions in a Query.mp4

00:00
262 – A Note on Using Several Window Functions Exercise.html

00:00
263 – A Note on Using Several Window Functions Solution.html

00:00
264 – MySQL Window Functions Syntax.mp4

00:00
265 – MySQL Window Functions Syntax Exercise.html

00:00
266 – MySQL Window Functions Syntax Solution.html

00:00
267 – The PARTITION BY Clause VS the GROUP BY Clause.mp4

00:00
268 – The PARTITION BY Clause VS the GROUP BY Clause Exercise.html

00:00
269 – The PARTITION BY Clause VS the GROUP BY Clause Solution.html

00:00
270 – The MySQL RANK and DENSERANK Window Functions.mp4

00:00
271 – The MySQL RANK and DENSERANK Window Functions Exercise.html

00:00
272 – The MySQL RANK and DENSERANK Window Functions Solution.html

00:00
273 – Working with MySQL Ranking Window Functions and Joins Together.mp4

00:00
274 – Working with MySQL Ranking Window Functions and Joins Together Exercise.html

00:00
275 – Working with MySQL Ranking Window Functions and Joins Together Solution.html

00:00
276 – The LAG and LEAD Value Window Functions.mp4

00:00
277 – The LAG and LEAD Value Window Functions Exercise.html

00:00
278 – The LAG and LEAD Value Window Functions Solution.html

00:00
279 – MySQL Aggregate Functions in the Context of Window Functions Part I.mp4

00:00
280 – MySQL Aggregate Functions in the Context of Window Functions Part IExercise.html

00:00
281 – MySQL Aggregate Functions in the Context of Window Functions Part ISolution.html

00:00
282 – MySQL Aggregate Functions in the Context of Window Functions Part II.mp4

00:00
283 – MySQL Aggregate Functions in the Context of Window Functions Part IIExercise.html

00:00
284 – MySQL Aggregate Functions in the Context of Window Functions Part IISolution.html

00:00
Section Quiz

21 – SQL Common Table Expressions CTEs

285 – MySQL Common Table Expressions Introduction.mp4

00:00
286 – An Alternative Solution to the Same Task.mp4

00:00
287 – An Alternative Solution to the Same TaskExercise.html

00:00
288 – An Alternative Solution to the Same TaskSolution.html

00:00
289 – Using Multiple Subclauses in a WITH Clause Part I.mp4

00:00
290 – Using Multiple Subclauses in a WITH Clause Part II.mp4

00:00
291 – Using Multiple Subclauses in a WITH ClauseExercise.html

00:00
292 – Using Multiple Subclauses in a WITH ClauseSolution.html

00:00
293 – Referring to Common Table Expressions in a WITH Clause.mp4

00:00
Section Quiz

22 – SQL Temporary Tables

23 – Combining SQL and Tableau Introduction

24 – Combining SQL and Tableau Task 1

306 – Task 1.mp4

00:00
307 – Task 1 Text.html

00:00
308 – Important clarification.html

00:00
309 – Task 1 SQL Solution.mp4

00:00
310 – Task 1 SQL Solution Code.html

00:00
311 – Transferring a Dataset from SQL to Tableau.mp4

00:00
312 – Chart 1 Visualizing and Analyzing the Solution in Tableau Part I.mp4

00:00
313 – Chart 1 Visualizing and Analyzing the Solution in Tableau Part II.mp4

00:00
Section Quiz

25 – Combining SQL and Tableau Task 2

26 – Combining SQL and Tableau Task 3

27 – Combining SQL and Tableau Task 4

28 – Combining SQL and Tableau Task 5

29 – Practice SQL 10 Final Query Questions

30 – BONUS LECTURE

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

5.0

Total 2 Ratings

2 Ratings

0 Rating

Areeba Khizer

4 months ago

best course on SQL

FATIMA ZAMEER

4 months ago

it was perfect

About Course

What Will You Learn?

Course Content

01 – Introduction to databases SQL and MySQL

A Message from the Professor

001 – What does the course cover.mp4

002 – Why SQL.mp4

003 – Why MySQL.mp4

004 – Introduction to databases.mp4

Section Quiz

02 – SQL theory

005 – SQL as a declarative language.mp4

006 – Data definition language DDL.mp4

007 – SQL keywords.mp4

008 – Data manipulation language DML.mp4

009 – Data control language DCL.mp4

010 – Transaction control language TCL.mp4

Section Quiz

03 – Basic database terminology

011 – Relational database essentials.mp4

012 – Databases vs spreadsheets.mp4

013 – Database terminology.mp4

014 – Relational schemas Primary key.mp4

015 – Relational schemas Foreign key.mp4

016 – Relational schemas Unique key and null values.mp4

017 – Relationships.mp4

Section Quiz

04 – Installing MySQL and getting acquainted with the interface

018 – Installing MySQL.mp4

019 – Additional note Installing Visual C.html

020 – Installing MySQL on macOS and Unix systems.html

021 – The ClientServer Model.html

022 – Setting up a connection.mp4

023 – Read me.html

024 – New Authentication Plugin Creating a New User.mp4

025 – Introduction to the MySQL interface.mp4

Section Quiz

05 – First steps in SQL

026 – Creating a Database Part I.mp4

027 – SQL files.html

028 – Creating a Database Part I exercise.html

029 – Creating a Database Part I solution.html

030 – Creating a Database Part II.mp4

031 – Creating a Database Part II exercise.html

032 – Creating a Database Part II solution.html

033 – Introduction to data types.mp4

034 – String data types.mp4

035 – Integers.mp4

036 – Fixed and floatingpoint data types.mp4

037 – Other useful data types.mp4

038 – Creating a table.mp4

039 – Creating a table exercise.html

040 – Creating a table solution.html

041 – Using databases and tables.mp4

042 – Using databases and tables exercise.html

043 – Using databases and tables solution.html

044 – Additional notes on using tables.mp4

045 – Additional notes on using tables exercise.html

Section Quiz

06 – MySQL constraints

046 – PRIMARY KEY constraint.mp4

047 – PRIMARY KEY constraint exercise.html

048 – PRIMARY KEY constraint solution.html

049 – FOREIGN KEY constraint Part I.mp4

050 – FOREIGN KEY constraint Part II.mp4

051 – FOREIGN KEY constraint Part II exercise.html

052 – FOREIGN KEY constraint Part II solution.html

053 – UNIQUE Constraint.mp4

054 – UNIQUE Constraint exercise.html

055 – DEFAULT Constraint.mp4

056 – DEFAULT Constraint exercise.html

057 – DEFAULT Constraint solution.html

058 – NOT NULL Constraint Part I.mp4

059 – NOT NULL Constraint Part I exercise.html

060 – NOT NULL Constraint Part I solution.html

061 – NOT NULL Constraint Part II.mp4

Section Quiz

07 – SQL best practices

062 – Coding techniques and best practices Part I.mp4

063 – Coding techniques and best practices Part II.mp4