6. Creating Table | Coursetakers

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)

Teach online with

6. Creating Table

Complete and Continue