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