The Industry Portal
Back to catalogue
AnalyticsBeginner Youtube membership

Learn SQL Step by Step | Full Course

Learn SQL from the ground up with hands on MySQL, from your first query to advanced topics like triggers, stored procedures and functions, with skills that transfer to any database.

24 min·5 lessons·Beginner

What you will cover

  • Write SQL queries from scratch to pull exactly the data you need
  • Filter, sort, group and aggregate data to answer real business questions
  • Join data across multiple tables with confidence
  • Install and work with MySQL on your own machine
  • Create and manage databases and tables, and keep data clean and consistent
  • Use advanced features including triggers, loops, stored procedures and functions
  • Move your skills to other database platforms by understanding the key differences
  • Feed clean, queried data into Tableau, Alteryx or Python for analysis

About this course

Welcome to Learn SQL Step by Step, a complete and practical SQL course for anyone who works with data.

A solid understanding of SQL is now a core skill, not something that lives only inside the IT department. If you work with data but cannot query it directly, you end up relying on other people and on tools like Excel that quickly run out of road. This course gives you that querying skill from the ground up.

You will learn using MySQL, one of the most widely used databases in the world and among the most in demand skills in business today. Companies such as Uber, Airbnb and Dropbox run on MySQL, so you are learning on a powerful, real world platform that you install on your own machine. The skills transfer directly to other database platforms too, and a dedicated section covers the main differences so you can move between them with confidence.

The course is built to be practical. Each video targets a specific topic you can tackle on its own or as part of a structured journey, every section is tested with quizzes, and you get tips, shortcuts and further reading to take your knowledge further. It is kept up to date as SQL and the tools around it evolve.

By querying data properly you can cut operational cost through automation, surface insights that improve decisions at every level, and work far faster when you analyse data in Tableau, Alteryx or Python by querying the underlying databases.

It starts from the very beginning, so no prior SQL is assumed, and builds all the way to advanced topics such as triggers, loops, stored procedures and functions. The style is clear, friendly and easy to follow, and by the end you will query databases with genuine confidence.

Enrol today and kickstart your SQL journey.

Who this is for

  • Anyone new to SQL who wants to start from the beginning
  • Analysts who rely on Excel today and want to query data directly
  • Finance, data and business professionals who work with data daily
  • People preparing for a data analyst or data focused role
  • Experienced users wanting a refresher on advanced topics
  • Anyone who wants SQL on their CV to stand out

Requirements

  • • No prior SQL or database experience needed
  • • A computer where you can install MySQL (Windows or Mac)

Curriculum

5 lessons · 24 min

Your instructor

TP
The Industry Portal
Finance & treasury educator
Built and run treasury and liquidity functions inside tier 1 international banks.
Teaches the practical mechanics, not just the theory.
Every lesson maps to something you can do on the desk.

What learners say

Sign in and enrol to leave a review.

No reviews yet. Be the first to share your take.