Practice advanced SQL queries with MySQL 5.7+

In this course, we鈥檒l 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鈥檒l not learn just by watching me聽and eating pop-corn. You need to write the queries, and I鈥檒l help you! I believe that鈥檚 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

Video

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

Did you know?

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

Enjoy &聽have fun with SQL &聽MySQL! 馃檪

Course Curriculum

Chapter 1: S01 Kick-off

Lecture 1: 2018 update

Lecture 2: S01-L01 Introduction & kick-off

Lecture 3: S01-L02 How to get most out of this course?

Lecture 4: S01-L03 Environment setup

Lecture 5: Side note: How to install MySQL

Lecture 6: Side note: Important resources

Lecture 7: S01-L04 Sample database

Lecture 8: S01-L05 What can I really do BEFORE the course?

Lecture 9: S01-L06 Checklist before jumping on section S02

Lecture 10: UPDATE [Dec 2017] – Slack

Chapter 2: S02: Coding and style conventions

Lecture 1: S02-L01 Intro: Coding style and conventions

Lecture 2: S02-L02 How to write a beautiful query? (Video part 1/2)

Lecture 3: S02-L02 How to write a beautiful query? (Video part 2/2)

Lecture 4: S02-L03 My personal best practices (Video part 1/3)

Lecture 5: S02-L03 My personal best practices (Video part 2/3)

Lecture 6: S02-L03 My personal best practices (Video part 3/3)

Lecture 7: S02-P01 Coding practice

Lecture 8: S02-P02 Coding practice

Lecture 9: S02-P03 Coding practice

Chapter 3: S03 Indexes

Lecture 1: S03-L01 Intro: Indexes & why to use them?

Lecture 2: S03-L02 Unique index

Lecture 3: S03-L03 Composite index

Lecture 4: S03-L04 Partial index

Lecture 5: S03-L05 Index hints (Use, Force, Ignore)

Lecture 6: S03-L06 Functions on indexed columns

Lecture 7: S03-L07 Using two indexes in one query for the same table

Lecture 8: S03-P01 Coding practice

Lecture 9: S03-P02 Coding practice

Lecture 10: S03-R01 Additional reading: MySQL 5.7 Create Index

Lecture 11: S03-R02 Additional reading: How MySQL Uses Indexes?

Lecture 12: S03-R03 Additional reading: Multiple-Column indexes

Lecture 13: S03-R04 Additional reading: Index hints

Chapter 4: S04 Partitions

Lecture 1: S04-L01 Intro: Partitions & why to use them?

Lecture 2: S04-L02 How to work with partitions?

Lecture 3: S04-P01 Coding practice

Lecture 4: S04-R01 Additional reading: Partitioning overview

Lecture 5: S04-R02 Additional reading: Partitioning types

Lecture 6: S04-R03 Additional reading: Partition selection

Lecture 7: S04-R04 Additional reading: Partitioning MySQL database with high load solutions

Chapter 5: S05 Variables

Lecture 1: S05-L01 Intro: Variables & why to use them?

Lecture 2: S05-L02 Session variable

Lecture 3: S05-P01 Coding practice

Lecture 4: S05-R01 Additional reading: Show Variables

Lecture 5: S05-R02 Additional reading: User-defined variables

Lecture 6: S05-R03 Additional reading: Advanced MySQL user variable techniques

Chapter 6: S06 Analytic functions

Lecture 1: S06-L01 Intro: Analytic (window) functions

Lecture 2: S06-L02 ROW_NUMBER()

Lecture 3: S06-P01 Coding practice

Lecture 4: S06-R01 Additional reading: Difference between ROW_NUMBER, RANK and DENSE_RANK

Lecture 5: S06-R02 Additional reading: PostgreSQL Window Functions

Lecture 6: S06-R03 Additional reading: How to select the first_least_max row per group

Lecture 7: S06-R04 Additional reading: How to number rows in MySQL?

Chapter 7: S07 User-defined functions

Lecture 1: S07-L01 Intro: Functions & why to use them?

Lecture 2: S07-L02 Relevant coding standards

Lecture 3: S07-P01 Coding practice

Lecture 4: S07-R01 Additional reading: Create procedure and function

Lecture 5: S07-R02 Additional reading: CREATE FUNCTION Syntax for User-Defined Functions

Lecture 6: S07-R03 Additional reading: Adding a New User-Defined Function

Lecture 7: S07-R04 Additional reading: FAQ- Stored Procedures and Functions

Chapter 8: S08 Stored procedures

Lecture 1: S08-L01 Intro: Procedures & why to use them?

Lecture 2: S08-L02 How to write procedures?

Lecture 3: S08-L03 Events

Lecture 4: S08-P02 Coding practice

Lecture 5: S08-P01 Coding practice

Lecture 6: S08-P03 Coding practice

Lecture 7: S08-R01 Additional reading: SHOW PROCEDURE STATUS Syntax

Lecture 8: S08-R02 Additional reading: Using Stored Routines (Procedures and Functions)

Lecture 9: S08-R03 Additional reading: Procedures, Functions, Triggers, LAST_INSERT_ID

Chapter 9: S09 Cursors

Lecture 1: S09-L01 Intro: Cursors & why to use them?

Lecture 2: S09-L02 Cursor in a procedure

Lecture 3: S09-P01 Coding practice

Lecture 4: S09-R01 Additional reading: Cursors

Lecture 5: S09-R02 Additional reading: Cursor DECLARE syntax

Lecture 6: S09-R03 Additional reading: Cursor FETCH syntax

Lecture 7: S09-R04 Additional reading: Cursor CLOSE syntax

Lecture 8: S09-R05 Additional reading: Cursors in MySQL stored procedures

Chapter 10: Next steps

Lecture 1: What can I really do AFTER the course?

Lecture 2: Course review

Lecture 3: Next steps & conclusion

Instructors

Michal Juhas
Tech Entrepreneur

Rating Distribution

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!