Learn MySQL and Solve 42 Practical Problems
There are a lot of tutorials out there talking about basics of SQL language and statements, which is good. However, a lot of times, just learning the syntax won't bring you any further. That's what I feel when I was learning SQL. I would like to find Quizs and Problems to practice on the knowledge I learned. Yet, often times, it's difficult to find good problems to work on.
More
This course will first introduces the basics of SQL statements through MySQL, one of the most popular databases out there. If you are beginner, I definitely recommend you to go through this section. If you are seasoned developer, you are welcome to have a review. I encourage you to practice while learning those basic statements.
After that, you can jump into the more interesting section - solving problems. There are 42 problems divided into 3 categories, basic, intermediate and advanced. It will start with the very basics of SQL statements to make sure you understand what building tools and then moving to more advanced problems.
Almost every time, in an interview for a developer related position, there will be SQL questions. During those SQL questions, you will often face problems involving joining tables, a tough topic for a lot of people who has just begun with SQL. There aren't many good practice out there and that's why I would like to share in this course.
How to use this course?
In order to retain the knowledge you have learned, you will have to solve those problems yourself. You may follow the lessons to go through each of the problem, but you have to come back and solve the problems yourself. Besides that, to fight memory loss on what you have learned, you need to constantly come back to those problems to convert short term memory into long term memory, especially before interview. Not every key words or statement is covered in this course. You can always find quick tutorials and documents on it. The more valuable information is the practical problems and the process of solving it. I can provide you the former part but it's you who act as the second part.
- It's good to have some basic understanding on Database but not required
- Anyone who want's to learn or enhance their SQL skills
What you'll learn:
- Understand basic statements of MySQL
- Write MySQL statements to interact with database
- know how to use MySQL database tool to connect to database
- know how to join tables to address business problems
Watch Online Learn MySQL and Solve 42 Practical Problems
# | Title | Duration |
---|---|---|
1 | Overview | 03:07 |
2 | Introduction | 06:11 |
3 | MySQL Server Installation | 08:04 |
4 | How To Maintain Memory | 02:52 |
5 | Sample Database | 02:43 |
6 | Select Statement to query data | 04:24 |
7 | Distinct to eliminate duplicate records | 04:27 |
8 | Filter data records with where clause | 02:30 |
9 | 2. Logic And and OR | 03:09 |
10 | Greater Than, Less Than and Between operator | 03:01 |
11 | IN and NOT operator | 02:17 |
12 | LIKE operator to select records based on patterns | 05:29 |
13 | LIMIT operator to limit the number of records displayed | 01:53 |
14 | ORDER BY clause to sort data | 04:10 |
15 | Using Alias to make queries more readable | 03:15 |
16 | MySQL INNER JOIN to join two or multiple tables | 09:11 |
17 | MySQL LEFT JOIN to include left set when joining tables | 07:35 |
18 | MySQL self joining tables | 04:40 |
19 | GROUP BY to put same value records into groups | 09:11 |
20 | HAVING clause to filter data after grouping | 05:07 |
21 | Subquery in MySQL | 04:37 |
22 | Combining result sets by UNION | 03:51 |
23 | Create Table | 03:37 |
24 | Insert records into tables | 08:18 |
25 | Storage Engines | 07:15 |
26 | Update record values | 03:21 |
27 | Delete records | 04:49 |
28 | Manage database | 03:51 |
29 | Drop statement | 01:34 |
30 | Sample Database for problems | 03:53 |
31 | Problems 1 - 6 | 11:22 |
32 | Problems 7 - 12 | 12:08 |
33 | Problems 13 - 19 | 18:06 |
34 | Problems 20 - 23 | 12:08 |
35 | Problems 24 - 27 | 14:40 |
36 | Problems 28 - 29 | 14:23 |
37 | Problems 30 | 03:12 |
38 | Problems 31 - 32 | 10:36 |
39 | Problems 33 - 34 | 08:05 |
40 | Problems 36 - 38 | 11:50 |
41 | Problems 39 - 42 | 09:43 |