Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Practice advanced SQL queries with MySQL 5.7+
Rating: 4.1 out of 5(589 ratings)
5,364 students
Created byMichal Juhas
Last updated 12/2017
English

What you'll learn

  • write user defined functions
  • write stored procedures
  • simulate some of the analytic (window) functions
  • work with cursors
  • use the right indexes and partitions
  • write advanced & beautiful queries

Course content

10 sections • 79 lectures • 5h 1m total length

  • 2018 update3:12
  • S01-L01 Introduction & kick-off5:36

    Course kick-off:

    • instructor introduction
    • course structure & highlights

    Feedback:

    • Please, let me know in the reviews how you liked the course and what should I improve. I read all reviews.

    Attached resources:

    • Slides: S01-L01-slide.pdf
  • S01-L02 How to get most out of this course?4:35

    Learn how to get most out of your investment (time & money). As I prepared lots of SQL queries, practices and additional reading materials, I strongly recommend you go through the attached materials and practice, practice, practice!

    Attached resources:

    • Slides: S01-L02-slide.pdf
  • S01-L03 Environment setup3:30

    We'll take a look at the tools you should have installed at your localhost.

    For Mac I use & recommend:

    • MySQL version 5.7+
    • Postgres version 9.5+

    For Windows & Linux you can use any other tools, there's plenty of them. The tool itself is not important for this course as long as you can write & execute queries in it.

    Attached resources:

    • Slides: S01-L03-slide.pdf (306.7 kB)
    • SQLs: S01-L03-Environment.pdf (19.9 kB)
  • Side note: How to install MySQL0:09
  • Side note: Important resources0:04

    GitHub repositories you need

  • S01-L04 Sample database5:24

    I prepared for this course 2 test databases:

    1. sample_staff
    2. sample_ip

    In this lecture we'll take a deeper look at where to get the database and the tables in both databases.

    There is a detailed guide in a README.md file. 

    MySQL Workbench: As you can see in the Readme file, can also import the .sql files to MySQL Workbench. Just select in menu File - Run SQL Script. No need to "Open" it, just Run it.

    Important info: Quite a lot of people ask why the user_stat table is empty. It's intentional - you will fill it in the next lessons.

    Attached resources:

    • Slides: S01-L04-slide.pdf
    • SQLs: S01-L04-Sample-database.pdf
  • S01-L05 What can I really do BEFORE the course?3:18

    Take the same quiz before and after this course and compare how you've progressed and what you've learned.

    Attached resources:

    • Slides: S01-L05-slide.pdf
  • S01-L06 Checklist before jumping on section S023:32

    Before you proceed to next sessions & lessons, please make sure you tick all the prerequisites. In this quick lecture we'll take a look at all the prerequisites and hopefully will tick all the boxes :-)

    Attached resources:

    • Slides: S01-L06-slide.pdf
    • SQLs: S01-L06-Checklist.pdf
  • UPDATE [Dec 2017] - Slack0:07

Requirements

  • Your genuine interest in SQL is required. If you’re passionate about the data analysis, optimisation, advanced queries, it will be so much easier for me to get you to a next level!
  • Access to a MySQL database
  • Basic or intermediate SQL knowledge such as:
  • ...already can query data: SELECT COUNT, DISTINCT, LIMIT, ORDER BY, WHERE
  • ... already know conditions: BETWEEN, LIKE, IS NULL, IN, NOT IN
  • ... already know aggregation: GROUP BY, HAVING, MAX, MIN, AVG, SUM
  • ... already know joins: INNER JOIN, OUTER JOIN, CROSS JOIN
  • ... already know views: CREATE VIEW AS
  • ... already know data management: CREATE TABLE, INERT INTO, UPDATE, DELETE
  • ... already know sub-queries

Description

I designed this course especially for those who already know the basics and wonder how to get to the next level. Maybe you’re a BI analyst, IT specialist, QA analyst, automation tester, DB admin, aspiring data scientist or just passionate to learn SQL. You’ll learn how to use analytic functions, how to take advantage of table partitioning, how to write user-defined functions, procedures with cursors and even how to write beautiful code. All of that with the focus on the most popular open-source database: MySQL.

In this course, we’ll write the code & MySQL queries together. I prepared 2 test databases, 70+ lectures, 4+ hours of video and lots of examples and practices so that you can learn advanced SQL techniques by writing the code. You’ll not learn just by watching me and eating pop-corn. You need to write the queries, and I’ll help you! I believe that’s the only way for you to adopt this new knowledge.

At the end of this course you will not just know these advanced techniques, but also know how to use them in practice.

Anyways, you have nothing to lose. Try this course and if you can honestly say that you learned nothing, just email Udemy, and they will give you a 100% refund within 30 days.

Recent reviews

  • "The course was great. Now, I write beautiful queries, using coding style conventions and best practices." -Mauro

Video

  • Last course update: March 2017
  • Video quality: Very high (1080p HD, 1920x1080)
  • Length: Over 5 hours

Course Highlights

We'll go through my personal best practices in writing advanced SQL code which I adopted in the last years. Thus some of the videos are long and content-heavy. I had to divide some of them into three parts because of Udemy's limit of 20 mins/video.

If you are a BI developer, automation tester, data analyst, or a DB admin, I'm sure you'll appreciate the hands-on examples and practices. They will help you understand the concepts and learn them by writing the advanced SQL code for MySQL.

If you have a tech background, you'll like the attached .md files with all the SQL code used in the course.

Please note

  • Basics such as how to instal a database and SQL tools is not covered in the course.
  • This course focuses on MySQL, not PostgreSQL (a new course focused on PostgreSQL coming soon!).

Did you know?

  • Did you know that even SQL code can be beautiful? The more advanced SQL code I wrote for MySQL or PostgreSQL, the more I focused on writing beautiful code. It's especially important if you work with several colleagues on the same codebase.
  • I recorded all the video content (5+ hours of final footage) in one day, from early morning to late night? I believe you need to get into the zone to produce great content, be creative or to learn efficiently. Thus I recommend the same to you: purchase this course, dedicate 1 full day to it, turn off your smartphone and learn, learn, learn.
  • There's a quiz before and after the course. Take it to check your level of knowledge at the beginning of the course to assess your level of SQL & MySQL knowledge. Then take it after the course. If you learn nothing, ask for refund. (Although I'm certain this doesn't happen!)
  • As a CTO, I'm responsible for HotelQuickly's product, engineering, technical infrastructure and databases - we use MySQL & PostgreSQL. Prior to joining HotelQuickly I spent 4 years working as a data warehouse consultant, developing and optimising data marts running on Oracle.

Featured Testimonials (see them all on the bottom of this page)

  • "Let's be clear: If you used only basics of the sql, you will definitely learn lots of new stuff here. This is definitely not the introductory course to MySQL and author will not waste your time by explaining basics to you. Author is very knowledgeable about the topic and you will surely learn, at least how to write well structured queries, and you can apply those immediately in your work. In first 3 chapters you will have a lot of explanations and practices to keep you busy." -Dusan Kostic (see full below)
  • "SELECT * FROM `the_most_fascinating`.`course`   :-)  I really like it!!! Thank you a lot Michal for you very professional work!!"   -Andrey Ivashkin
  • "This is great course on MYSQL, I learned more here, than any other course I have taken so far." -David Abraham
  • "Lots of stuff you can learn from this course. There are still more to MySQL than just creating databases. I would recommend anyone to take this course after they know the basics." -Raymond John Escobar

Enjoy & have fun with SQL & MySQL! :-)

Who this course is for:

  • Those who know SQL basics and want to get to next level
  • Business intelligence (BI) analysts
  • BI developers
  • Data scientists
  • IT specialists
  • QA analysts & testers
  • Automation testers
  • DB administrators
  • NOT beginners (in this course you already need to have basic / intermediate SQL knowledge)

Report abuse