CF

Learn MySQL and Solve 42 Practical Problems

4h 24m 35s
English
Paid

There are a lot of tutorials available that discuss the basics of SQL language and statements, which is beneficial. However, simply learning the syntax often won't take you much further. This is what I experienced when I was learning SQL. I wanted to find quizzes and problems to practice and reinforce the knowledge I had acquired. Unfortunately, finding quality problems to work on can be challenging.

Course Overview

This course will start by introducing the basics of SQL statements through MySQL, one of the most popular databases in use today. If you are a beginner, I highly recommend going through this section. If you are an experienced developer, feel free to use it as a refresher. Practicing while learning these basic statements is encouraged.

Once the basics are covered, you can delve into the more engaging section of solving problems. You will tackle 42 problems categorized into three levels: basic, intermediate, and advanced. This progression ensures you understand the foundational tools before moving on to more complex issues.

SQL questions are almost always a part of interviews for developer positions. Commonly, they involve challenges like joining tables, which can be difficult for newcomers to SQL. There is a lack of quality practice material, and this course aims to address that gap.

How to Use This Course

Solve the problems yourself to consolidate your knowledge. While you can follow the lessons to go through each problem, it's important to return and solve the problems independently. To combat memory loss and convert short-term memory to long-term memory—especially before interviews—revisit these problems regularly. Not every keyword or statement is covered in this course, but you can always refer to tutorials and documentation as needed. The essential part of this course is the practical problems and your process of solving them. I'll provide the problems, but it's up to you to engage with them fully.

Requirements

  • Having some basic understanding of databases is beneficial but not necessary.

Who This Course Is For

  • Anyone who wants to learn or enhance their SQL skills.

What You'll Learn

  • Understand basic MySQL statements.
  • Write MySQL statements to interact with databases.
  • Know how to use MySQL database tools to connect to databases.
  • Learn how to join tables to solve business problems.

About the Author: Udemy

Udemy thumbnail

Udemy is the largest open marketplace for online courses on the internet. Founded in 2010 by Eren Bali, Oktay Caglar, and Gagan Biyani and headquartered in San Francisco, the company went public on the Nasdaq in 2021 under the ticker UDMY. The platform hosts well over two hundred thousand courses across software development, IT and cloud, data science, design, business, marketing, and creative skills, taught by tens of thousands of independent instructors. Roughly seventy million learners use it worldwide, and the corporate arm — Udemy Business — supplies a curated subset of that catalog to enterprise customers.

Because Udemy is a marketplace rather than a single editorial publisher, the catalog is uneven by design. The strongest material lives in the long-form, project-based courses authored by working engineers — full-stack JavaScript, React, Node.js, Python data science, AWS, Docker and Kubernetes, mobile development with Flutter and React Native, and cloud certification preparation. The CourseFlix listing under this source is the slice of that catalog that has been mirrored here for offline-friendly viewing, organized by topic and updated as new releases land. Pricing on Udemy itself swings dramatically with the site's near-permanent sales, which is why the platform is best treated as a deep reference catalog: pick instructors with strong reviews and a track record of updating their material rather than buying on the headline price alone.

Watch Online 41 lessons

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

Related courses

  • PostgreSQL Fundamentals thumbnailUpdated 11mo ago

    PostgreSQL Fundamentals

    By: Big Machine
    Embark on an exciting journey to master the fundamentals of SQL while exploring the fascinating world of databases with PostgreSQL.
    2h 5m5/5
  • DBMS thumbnailUpdated 8mo ago

    DBMS

    By: takeUforward (Striver)
    This course is dedicated to the study of Database Management Systems (DBMS) - technologies that allow for efficient storage, processing, and protection of data.
    21h 30m5/5
  • Database Mastery: SQL to Prisma thumbnailUpdated 9mo ago

    Database Mastery: SQL to Prisma

    By: JavaScript Mastery, Adrian Hajdin
    Master key technologies with a practical approach! You will gain applied knowledge, clear explanations.
    16m

Frequently asked questions

What are the prerequisites for taking this course?
There are no strict prerequisites for this course, making it suitable for beginners. However, familiarity with basic programming concepts may be beneficial. The course starts with an introduction to basic SQL statements using MySQL, which is recommended for those new to SQL.
What practical skills will I gain from this course?
You will learn to execute various SQL statements using MySQL, such as SELECT, JOIN, and GROUP BY, while solving 42 practical problems. These problems are categorized into basic, intermediate, and advanced levels, which will enhance your problem-solving skills and understanding of complex SQL queries.
Who is the target audience for this course?
The course is designed for both beginners and experienced developers who want to deepen their understanding of SQL through MySQL. It's particularly useful for those preparing for developer interviews, as SQL questions are commonly included in technical assessments.
How does this course compare in depth and scope to other SQL courses?
Unlike many SQL courses that focus solely on syntax, this course emphasizes practical problem-solving with 42 diverse problems. It delves into various SQL operations like INNER JOIN, LEFT JOIN, and subqueries, providing a richer learning experience through hands-on practice.
What specific tools or platforms will I use in this course?
The course uses MySQL as the primary database platform. Students will install the MySQL Server and work with sample databases to practice SQL statements, making it a practical choice for those looking to work with one of the most popular relational databases.
What topics are not covered in this course?
The course does not cover advanced database administration topics, such as security, backup and recovery, or performance tuning. It focuses on SQL query writing and problem-solving within the MySQL environment.
What is the expected time commitment for completing this course?
While the total runtime of the video lessons is not specified, the course includes 41 lessons and 42 practical problems. Students should expect to spend additional time solving these problems beyond the video content to fully grasp the concepts and improve their SQL skills.