SQL–MySQL Complete Master Bootcamp | Beginner-Expert (2024)

MySQL for Data Analytics, Database Management, Business Intelligence & Analysis. Master SQL & Tableau. Create Reports!

Created by: Donatus Obomighie, PhD, MSc, PMP
Instructor & Engineer

What Will I Learn?

• Write complex queries with View, Stored Procedure, Trigger, Transaction, User-defined Function, Session, Table Locking and many more
• Start from beginner level to expert level and build real-world report with SQL
• Use Python to create databases, tables and write queries. Use tableau to report your data
• Write complex queries to retrieve information from single and across multiple tables by using Nested & Correlated Subqueries
• Write complex queries to retrieve data across multiple tables by using Left, Right, Inner and Full Outer joins queries
• Learn by doing tons of real-world SQL projects, challenges & assignment with solutions
• Learn to use complex sorting, filtering, extracting and aggregating queries to analyse data
• Pass your next BI , Data Analysts and Data Science Interviews and Vivas
• This SQL MySQL tutorial cover SQL Foundations, SQL beginners, SQL intermediate and SQL expert levels training
• Join and retrieve data from One, Two, Three, Four, Five, Six, Seven, Eight, Nine and Ten tables

Requirements

• No programming experience is needed - I'll teach you everything you need to know
• No paid software required - everything will be done with MySQL Workbench (which is free)
• A Mac laptop/iMac or a Windows PC
• I'll walk you through, step-by-step on how to get MySQL Workbence installed and set up
• This SQL MySQL tutorial will move you from zero to hero
• I'll walk you through on how to get MySQL Connector to run with Python

Target audience

• All Levels - Beginners, Intermediate & Experts