Course Content
Udemy – SQL – MySQL for Data Analytics and Business Intelligence
0/30
01 – Introduction to databases SQL and MySQL
14:14
02 – SQL theory
20:37
03 – Basic database terminology
34:58
04 – Installing MySQL and getting acquainted with the interface
24:45
05 – First steps in SQL
41:31
06 – MySQL constraints
34:32
07 – SQL best practices
09:46
08 – Loading the employees database
02:20
09 – SQL SELECT statement
01:08:50
10 – SQL INSERT statement
12:20
11 – SQL UPDATE Statement
08:56
12 – SQL DELETE Statement
09:08
13 – MySQL Aggregate functions
19:07
14 – SQL Joins
01:12:21
15 – SQL Subqueries
16:12
16 – SQL Self Join
07:45
17 – SQL Views
07:13
18 – Stored routines
45:41
19 – Advanced SQL Topics
42:44
20 – SQL Window Functions
01:02:10
21 – SQL Common Table Expressions CTEs
23:45
22 – SQL Temporary Tables
15:45
23 – Combining SQL and Tableau Introduction
15:29
24 – Combining SQL and Tableau Task 1
26:11
25 – Combining SQL and Tableau Task 2
13:42
26 – Combining SQL and Tableau Task 3
10:33
27 – Combining SQL and Tableau Task 4
08:56
28 – Combining SQL and Tableau Task 5
06:05
29 – Practice SQL 10 Final Query Questions
30 – BONUS LECTURE
Udemy – SQL – MySQL for Data Analytics and Business Intelligence

    00:00 – 63 – Coding techniques and best practices Part I

    05:34 – 64 – Coding techniques and best practices Part II

    Previous
    Next
    0% Complete