This course takes you from SQL newbie to problem solver, packed with practical challenges that reinforce what you learn. It's super hands-on and geared for every level!
Learn theory from beginning together and then practice with 42 practical problems with guided answer
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.
Understand basic statements of MySQL
Write MySQL statements to interact with database
know how to use MySQL database tool to connect to database
5 Lectures
6 Lectures
5 Lectures
4 Lectures
7 Lectures
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,...
I liked the combination of theory and practice.
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.
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)
great material to practice at the same and get stronger
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.
Have great examples to do hands-on practice! Very helpful!
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.
well explained in an easy way with examples.
The course is not complete. There is a duplicate lecture at number 29 of lecture 23. The captions are not updated. We have paid money for this. I hope the lecturer sees that and updates his course contents
Your email address will not be published. Required fields are marked *
Raghavendra R.
very good and practical course , thank you.