Practice advanced SQL queries with MySQL 5.7+

Build on your current knowledge and get to a next level in SQL. Learn by writing - lots of examples are waiting for you.

Created by: Michal Juhas
CTO Recruiter, Career Coach, Trainer

What Will I 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

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

Target audience

• 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)