Learn MySQL and Solve 42 Practical Problems

4h 24m 35s
English
Paid

Course description

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.

Read more about the course

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.

Requirements:
  • It's good to have some basic understanding on Database but not required
Who this course is for:
  • 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

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 41 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Overview

All Course Lessons (41)

#Lesson TitleDurationAccess
1
Overview Demo
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

Unlock unlimited learning

Get instant access to all 40 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Make a Google search engine clone: JavaScript PHP and MySQL

Make a Google search engine clone: JavaScript PHP and MySQL

Sources: udemy
Do you want to become an expert in JavaScript, PHP and MySQL?Do you want to build a real search engine just like Google? If so, you’re in the right place!
5 hours 47 minutes 11 seconds
Ludicrous Speed Postgres

Ludicrous Speed Postgres

Sources: Creston Jamison
This course is dedicated to optimizing PostgreSQL performance with a focus on proper schema design and efficient database usage. It is designed for those...
12 hours 27 minutes 44 seconds
MySQL High Performance Tuning Guide

MySQL High Performance Tuning Guide

Sources: udemy
Tips for Tuning MySQL like a Pro. Learn how to prevent MySQL performance problems. Understand how MySQL optimizes and executes queries.
2 hours 49 minutes 22 seconds
Ultimate Expert Guide: Mastering PostgreSQL Administration

Ultimate Expert Guide: Mastering PostgreSQL Administration

Sources: udemy
With the increasing popularity of Open Source Databases, organisations are looking for best alternatives among the widely available choices in the market. Among
10 hours 19 minutes 42 seconds
Complete SQL Mastery

Complete SQL Mastery

Sources: codewithmosh (Mosh Hamedani)
Big databases are everywhere these days. Facebook, Netflix, Uber, Airbnb use SQL-driven databases - to name just a few. So, to be a successful developer or data scientist you ne...
10 hours 47 minutes 7 seconds