Course Content
Subtitle Guide – Hướng dẫn thêm phụ đề
0/1
Set up subtitle for video – Hướng dẫn thêm phụ đề
1. Course Introduction
0/3
Subtitle File Resource
1. Welcome to the Course
01:28
2. Syllabus Explanation
03:42
2. Installation and Setup
0/9
Subtitle File Resource
1. Section Introduction
00:41
2. Databases, SQL and MySQL
03:08
3. Relational Database Management System
02:18
4. MySQL Installation for Windows
15:00
5. MySQL Installation for Mac
12:17
6. MySQL Installation for Linux
11:07
7. MySQL Workbench Overview
13:13
8. Create Database
03:24
3. Data Definition Language
0/8
Subtitle File Resource
1. Section Introduction
01:33
2. Data Types
06:34
3. Primary and Foreign Keys
02:53
4. Creating the Coffee Store Database
08:54
5. Modifying Tables Adding and Removing Columns
03:08
6. Deleting Tables
01:28
7. Truncating Tables
01:39
4. More On Alter Table
0/10
Subtitle File Resource
1. Section Introduction
01:26
2. Creating Our Test Database
05:30
3. Add and Remove Primary Key
05:25
4. Add and Remove Foreign Key
04:56
5. Add Unique Constraint
03:25
6. Change Column Name
03:15
7. Change Column Data Type
04:44
8. Exercise 1
01:30
9. Solution 1
08:27
5. Data Manipulation Language
0/6
Subtitle File Resource
1. Section Introduction
00:50
2. Inserting Data Into Tables
05:37
3. Updating Data in Tables
06:07
4. Deleting Data from Tables
02:49
5. Completing the Coffee Store Database
02:38
6. Selecting from a Table
0/19
Subtitle File Resource
1. Section Introduction
01:14
2. Select Statement
01:46
3. Where Clause
04:53
4. Using Inequality Symbols
03:03
5. Null Values
03:10
6. Exercise 1
01:06
7. Solution 1
03:55
8. In, Not In
03:44
9. Between
04:04
10. Like
04:52
11. Order By
06:19
12. Exercise 2
00:55
13. Solution 2
04:23
14. Distinct
05:11
15. Limit
02:56
16. Column Name Alias
02:03
17. Exercise 3
00:50
18. Solution 3
03:45
7. Selecting From Multiple Tables
0/9
Subtitle File Resource
1. Section Introduction
01:08
2. What Are Joins
03:08
3. Inner Join
08:55
4. Left Join
05:23
5. Right Join
03:15
6. Joining more than Two Tables
04:33
7. Exercise 1
01:06
8. Solution 1
05:55
8. Database Design
0/11
Subtitle File Resource
1. Section Introduction
01:23
2. Normalization – What is it
05:23
3. 1st Normal Form (1NF)
03:30
4. 2nd Normal Form (2NF)
06:27
5. 3rd Normal Form (3NF)
09:30
6. Relationships
01:05
7. Relationships – One to One
02:30
8. Relationships – One to Many
02:01
9. Relationships – Many to Many
04:00
10. Constraints
03:53
9. Creating a Cinema Booking System Database
0/11
Subtitle File Resource
1. Section Introduction
01:11
2. Database Schema Overview
07:26
3. Create Films Table
04:55
4. Create Customers Table
02:53
5. Create Rooms Table
02:19
6. Create Screenings Table
04:45
7. Create Seats Table
03:53
8. Create Bookings Table
03:52
9. Create Reserved_Seat Table
04:35
10. Insert the Data
05:22
10. Aggregate Functions
0/13
Subtitle File Resource
1. Section Introduction
00:41
2. What are Aggregate Functions
02:30
3. Count
02:38
4. Sum
02:36
5. Min and Max
02:39
6. Average
02:09
7. Exercise 1
00:46
8. Solution 1
04:09
9. Grouping Data
08:52
10. Having Clause
01:44
11. Exercise 2
00:44
12. Solution 2
04:11
11. Subqueries
0/8
Subtitle File Resource
1. Section Introduction
00:32
2. What Are Subqueries
04:11
3. Non-Correlated Subqueries Part 1
05:11
4. Non-Correlated Subqueries Part 2
05:48
5. Correlated Subqueries
04:41
6. Exercise 1
01:19
7. Solution 1
06:59
12. MySQL Functions – String Functions and Date Functions
0/14
Subtitle File Resource
1. Section Introduction
01:08
2. What Are MySQL Functions
01:46
3. Concatenation
06:49
4. Substrings
08:09
5. Upper and Lower Case
03:50
6. Exercise 1
01:12
7.Solution 1
09:52
8. Date Function
07:30
9. Month Function
04:37
10. Year Function
03:11
11. Exercise 2
01:07
12. Solution 2
04:08
Solution 1
09:52
13. Challenges
0/14
Subtitle File Resource
1. Section Introduction
00:56
2. Challenge One
00:27
3. Solution One
01:51
4. Challenge Two
00:22
5. Solution Two
04:34
6. Challenge Three
00:26
7. Solution Three
03:31
8. Challenge Four
00:26
9. Solution Four
04:08
10. Challenge Five
00:37
11. Solution Five
07:20
12. Challenge Six
00:38
13. Solution Six
03:55
14. Bonus Material
0/2
Subtitle File Resource
1. Bonus – Please Watch!
00:48
SQL for Beginners: Learn SQL using MySQL and Database Design
Exercise Files
5customers_table.rtf
Size: 1.30 KB
5orders_table.rtf
Size: 3.31 KB
Join the conversation
Previous
Next

Please contact me via telegram

DMCA.com Protection Status