Learn MySQL and Solve 42 Practical Problems

Learn theory from beginning together and then practice with 42 practical problems with guided answer

4.80 (101 reviews)
Udemy
platform
English
language
Databases
category
instructor
669
students
4.5 hours
content
Dec 2016
last update
$54.99
regular price

What you will 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

Description

WELCOME TO MY COURSE - "Learn MySQL and Solve 42 Practical Problems"

Why this course?

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.

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

Content

Introduction Section

Download this source files first !!!!
Overview
Introduction
MySQL Server Installation
How To Maintain Memory

MySQL Basics - Query Data

Sample Database
Select Statement to query data
Distinct to eliminate duplicate records

MySQL Basics - Filter Data

Filter data records with where clause
2. Logic And and OR
Greater Than, Less Than and Between operator
IN and NOT operator
LIKE operator to select records based on patterns
LIMIT operator to limit the number of records displayed

MySQL Basics - Sort Data and Join Table

ORDER BY clause to sort data
Using Alias to make queries more readable
MySQL INNER JOIN to join two or multiple tables
MySQL LEFT JOIN to include left set when joining tables
MySQL self joining tables

MySQL Basics - GROUP BY, Subquery and UNION

GROUP BY to put same value records into groups
HAVING clause to filter data after grouping
Subquery in MySQL
Combining result sets by UNION

Manage Tables and Databases

Create Table
Insert records into tables
Storage Engines
Update record values
Delete records
Manage database
Drop statement

Basic Problems

Sample Database for problems
Problems 1 - 6
Problems 7 - 12
Problems 13 - 19

Intermediate Problems

Problems 20 - 23
Problems 24 - 27
Problems 28 - 29
Problems 30

Advanced Problems

Problems 31 - 32
Problems 33 - 34
Problems 36 - 38
Problems 39 - 42

Screenshots

Learn MySQL and Solve 42 Practical Problems - Screenshot_01Learn MySQL and Solve 42 Practical Problems - Screenshot_02Learn MySQL and Solve 42 Practical Problems - Screenshot_03Learn MySQL and Solve 42 Practical Problems - Screenshot_04

Reviews

Akshay
September 20, 2023
Very well made course. Exactly what is required for anyone with no knowledge of the basics along with enough questions to get a solid grasp of the concepts and usage.
Vikas
June 4, 2022
Course is really awesome and while learning the course I realized that some of the advanced queries solution described in the videos can be solved in a much easier way than the method adopted by the trainer. Not taking any credit the creator of this course deserves lot of appreciation for bringing out some really practical scenarios. Explantion of logics behind the solution could have been done in a more elaborate manner...(my reason for 4 star rating)
Fola
May 29, 2020
Very good course! The tutorial sections are clear and provide a good amount of knowledge on the related SQL subject. The numerous SQL related problem tasks however are the highlight of this course, they provide a fairly difficult challenge but still rewarding, the instructors audio could be improved as at times the speech was not entirely audible.
Roberts
April 4, 2020
I like the structured and clear approach and thought given to how we remember new material. Sometimes the presentation can be a little more engaging, but overall steps to the last problems are very good. There could be more explanation on correlated subqueries. Overall I enjoyed the course a lot.
Shripad
February 23, 2020
The Trainer hadn't explained about newer version of mysql. The version that is currently present is 8.0 and it was tough to figure out how to install Mysql
Vincent
September 29, 2019
It is extremely helpful to work through the problems applying what I have learned at the beginning of this course and other MySQL courses. I'm hoping the instructor will put out more practical problems soon.
Soumen
September 6, 2019
Its a good handy practical course which made me learn mysql within a short time interval and with more efforts you can master in it.
Volodymyr
March 5, 2019
Le Deng is good teacher i like how he structures his courses, his explanations are clear and concise and don't know why people give him such a poor rating its a second course I'm doing and its great I'm learning a lot.
Onos
June 1, 2018
If you are looking to hone your MySQL skills and solve comprehensive set of problems based on real life scenario, then look no further. The instructor mostly delivered as promised but his responsiveness (or lack thereof) and missing content in one of the sections (wrong video upload) is somewhat disappointing hence the 4 star rating.
Jean
December 4, 2017
I like this course. However, I found the first parts are too basic, at leats In and some functions. I took this course more for the last part, the problems.
Jupadim
September 17, 2017
This course went into vivid explanation of simple to complex sql queries for both the total beginners and veterans alike, good enough for any developer that aims at gaining confidence in tackling scenarios that may involve some level of complexity in daily operations on the job. Course has good coverage of the subject matter and is well presented, kudos to a passionate tutor.
Smita
September 8, 2017
Very systematic. Liked the course lots but would like to know how good we get at the advanced stuff like join after the course examples are done.
Benjamin
June 15, 2017
Clear and not overly wordy. The examples are simple, but good and well presented. It's a basic course, but I'd have liked some more complex examples later on, maybe in a "bringing it all together" series of videos.
Dusan
January 9, 2017
This is the exact delivery of the mysql query practices that I had in mind. You are given sample database and number of queries to write., starting from the very easy ones. Reason why I am not giving 5 star is because the author did not included more advanced and challenging queries.

Charts

Price

Learn MySQL and Solve 42 Practical Problems - Price chart

Rating

Learn MySQL and Solve 42 Practical Problems - Ratings chart

Enrollment distribution

Learn MySQL and Solve 42 Practical Problems - Distribution chart

Related Topics

1044300
udemy ID
12/18/2016
course created date
2/8/2020
course indexed date
Bot
course submited by