This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Learn MySQL from scratch for Data Science and Analytics
1. Introduction
1. Introduction (2:22)
2. How to get course requirements (1:23)
3. Getting started on Windows Linux or Mac (0:48)
4. How To Ask Great Questions (1:27)
5. FAQs (1:02)
6. What is Source code (8:47)
7. Learn What is Generative AI Gen AI (14:06)
2. SQL Server setting up
1. Section Introduction (1:07)
2. MySQL Server Installation (13:44)
3. Connect MySQL Server Instance (5:49)
4. MySQL Workbench overview (10:41)
5. Download and Restore Sample Database (7:43)
3. SQL Database basics
1. Section Introduction (1:09)
2. Overview of Databases (9:15)
3. Creating Database (6:34)
4. SQL Data Types (3:47)
5. Column Data Types on Workbench (7:23)
6. Creating Table (3:44)
7. Overview of Primary and Foreign Key (3:29)
8. Primary Key (6:08)
9. Foreign Key (11:33)
10. Creating Temporary tables (12:23)
11. EER – Enhanced Entity Relationship Diagrams (4:21)
4. SQL DML (Data Manipulation Language)
1. Section Introduction (1:17)
2. Insert statement (7:12)
3. Update statement (6:02)
4. Delete statement (3:13)
5. SQL DDL (Data Definition Language)
1. Section Introduction (1:11)
2. CREATE table statement (7:51)
3. DROP statement (2:58)
4. ALTER statement (4:54)
5. TRUNCATE statement (3:02)
6. COMMENT in query (2:22)
7. RENAME table (3:15)
6. SQL DCL (Data Control Language)
1. Create Database user (3:16)
2. GRANT permissions (5:06)
3. REVOKE permissions (3:46)
7. SQL Statement Basic
1. Section Introduction (0:56)
2. SQL Statement basic (3:16)
3. SELECT Statement (3:12)
4. SELECT DISTINCT (1:30)
5. SELECT with column headings (1:27)
6. Column AS statement (2:21)
7. DASHBOARD Analytics (6:04)
8. Filtering Data rows
1. SELECT WHERE Clause – theory (3:03)
2. SELECT WHERE Clause – practical (6:16)
9. Aggregate functions for Data Analysis
1. Sum() (6:20)
2. Min()-Max() (2:40)
10. SQL Data Analytic statements
1. Order By statement (4:43)
2. SELECT TOP 3 records (1:43)
3. BETWEEN command (5:45)
4. IN operator (2:57)
5. Search Data using LIKE cards (4:35)
11. SQL Group by statement
1. Section Introduction (0:43)
2. Group by – theory (3:34)
3. Data Analytics with Group By (3:59)
4. HAVING statement (3:01)
12. JOINS
1. Overview of Joins (2:01)
2. What are Joins (2:18)
3. Inner join (6:43)
4. Left outer join (2:04)
5. Right outer join (1:53)
6. Union (2:54)
7. CERTESIAN Product or Cross Join (3:14)
8. Query Exercise (1:16)
9. Solution for Query Exercise (1:02)
13. SQL Constraints
1. Section introduction (1:23)
2. Check constraint (8:32)
3. NOT NULL constraint (2:45)
4. UNIQUE constraint (5:53)
14. Views
1. Creating Views (3:25)
2. Data Analytic Views from multiple tables (3:14)
15. Advanced SQL Functions
1. Section Introduction (1:02)
2. Timestamp (3:10)
3. Extract from timestamp (3:01)
4. Mathematical scalar functions (2:35)
5. String functions (7:14)
6. Advanced functions (3:58)
7. Sub Queries (3:11)
8. SELECT with calculations (4:44)
16. SQL Stored procedures
1. Create stored procedure (5:39)
2. Stored procedure with parameter (3:19)
3. Drop Procedure (1:20)
17. Import & Export data
1. Section Introduction (1:08)
2. Import .csv file (4:07)
3. Export Data to .csv file (2:13)
18. Backup and Restore Database
1. Section Introduction (0:44)
2. Creating Database backup (2:28)
3. Restoring Database backup (2:09)
1. Section introduction
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock