Learn MySQL and Solve 42 Practical Problems
4.0 (22 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
237 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn MySQL and Solve 42 Practical Problems to your Wishlist.

Add to Wishlist

Learn MySQL and Solve 42 Practical Problems

Learn theory from beginning together and then practice with 42 practical problems with guided answer
4.0 (22 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
237 students enrolled
Created by Le Deng
Last updated 12/2016
English
Curiosity Sale
Current price: $10 Original price: $155 Discount: 94% off
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • 1 Article
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
Requirements
  • It's good to have some basic understanding on Database but not required
Description

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

You can find more info here:  ldeng(dot)net/courses

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

Who is the target audience?
  • Anyone who want's to learn or enhance their SQL skills
Students Who Viewed This Course Also Viewed
Curriculum For This Course
42 Lectures
04:23:54
+
Introduction Section
5 Lectures 20:11
Download this source files first !!!!
00:01



MySQL Server Installation
08:03

How To Maintain Memory
02:51
+
MySQL Basics - Query Data
3 Lectures 11:31


Distinct to eliminate duplicate records
04:26
+
MySQL Basics - Filter Data
6 Lectures 18:12

2. Logic And and OR
03:08

Greater Than, Less Than and Between operator
03:00

IN and NOT operator
02:15

LIKE operator to select records based on patterns
05:28

LIMIT operator to limit the number of records displayed
01:52
+
MySQL Basics - Sort Data and Join Table
5 Lectures 28:46

Using Alias to make queries more readable
03:14

MySQL INNER JOIN to join two or multiple tables
09:10

MySQL LEFT JOIN to include left set when joining tables
07:34

MySQL self joining tables
04:39
+
MySQL Basics - GROUP BY, Subquery and UNION
4 Lectures 22:42

HAVING clause to filter data after grouping
05:06

Subquery in MySQL
04:36

Combining result sets by UNION
03:50
+
Manage Tables and Databases
7 Lectures 32:38
Create Table
03:36

Insert records into tables
08:17


Update record values
03:20

Delete records
04:48

Manage database
03:50

Drop statement
01:33
+
Basic Problems
4 Lectures 45:25
Sample Database for problems
03:52


Problems 7 - 12
12:07

Problems 13 - 19
18:05
+
Intermediate Problems
4 Lectures 44:19

Problems 24 - 27
14:39

Problems 28 - 29
14:22

Problems 30
03:11
+
Advanced Problems
4 Lectures 40:10
Problems 31 - 32
10:35

Problems 33 - 34
08:04

Problems 36 - 38
11:49

Problems 39 - 42
09:42
About the Instructor
Le Deng
4.1 Average rating
2,018 Reviews
8,263 Students
17 Courses
ldeng.net/courses, consultant, thousands of students

Le Deng was first exposed to programming when he was at elementary school and his first language was Logo, a 2D drawing programming language. He received his BS in Electrical Engineering in China and his MS in Electrical Engineering at RIT in US. He has been both a learner and a teacher through the course. In the past few years, he has been interested in web technologies and working on his own path to become an entrepreneur. He’s life philosophy is to contribute a hand on better shaping this world and he is willing to spend just a life-time to fulfill it. He is currently working as a consultant in Boston US.