Power BI for Data Analysis & Reporting
From raw files, databases and APIs to a published, auto-refreshing dashboard.
View courseData & AnalyticsBeginnerContent updated Sep 2026
SQL for Data Analysis
Stop waiting for someone to export the data for you. Learn the SQL analysts use every day — from your first SELECT to CTEs and window functions — in 15 one-hour classes.
- Duration
- 3 weeks
- Classes
- 15 × 1 hour
- Level
- Beginner
- Mode
- Physical or live online
About this course
A three-week course in writing the SQL analysts actually use. You start by creating your first database in PostgreSQL and finish with CTEs and window functions, answering business questions from relational data at every step.
Who this is for
- Beginners who want the most useful first data skill
- Excel users who hit the limits of spreadsheets
- Analysts and reporting staff who need data straight from the database
- Students preparing for data, BI or software roles
What you’ll be able to do
- Write analytical SQL queries
- Use joins, grouping, subqueries, CTEs and window functions
- Answer real business questions from relational databases
Tools you’ll use
- PostgreSQL
- pgAdmin
- SQL
Curriculum
The complete content, exactly as taught. Download it as a PDF.
Week 1SQL fundamentals5 topics
- Class 1 — Introduction to SQL: databases, SQL, PostgreSQL, pgAdmin; create a database and table; INSERT; your first SELECT
- Class 2 — SELECT, FROM, DISTINCT, AS
- Class 3 — WHERE, operators, AND / OR / NOT, BETWEEN, IN, LIKE, NULL
- Class 4 — ORDER BY, ASC / DESC, LIMIT, OFFSET
- Class 5 — Text, numeric and date functions
Week 2Intermediate SQL5 topics
- Class 6 — COUNT, SUM, AVG, MIN, MAX
- Class 7 — GROUP BY, HAVING and business summaries
- Class 8 — Primary and foreign keys; INNER, LEFT, RIGHT and FULL JOIN
- Class 9 — Multi-table joins and business analysis
- Class 10 — Subqueries and correlated subqueries
Week 3SQL for data analysis5 topics
- Class 11 — CASE WHEN and segmentation
- Class 12 — Date functions and time-based analysis
- Class 13 — CTEs (WITH)
- Class 14 — Window functions: ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, running totals
- Class 15 — Revision and project instructions
Your project
Class 15 sets a business-analysis project on a relational database: you plan the questions, write the queries and present what the data shows.
Where you’ll use this
- Pulling and summarising data straight from company databases
- Customer segmentation and sales analysis
- Month-on-month and year-on-year comparisons
- Ranking, running totals and trend analysis
- Feeding clean data into Power BI, Python or R
Before you start
None. You don't need programming or database experience. A laptop you can install PostgreSQL and pgAdmin on (Windows, macOS or Linux).
Who teaches it
The course is designed and taught by data and AI practitioners — people who build data pipelines, dashboards and AI systems for businesses — so every exercise reflects how the tool is used on real work.
Certificate
You receive a GeXOn Training Center certificate when you complete the course and its project.
Every certificate carries an ID that employers can check at trainingcenter.gexonai.com/verify.
Frequently asked questions
I have never programmed. Can I do this?
Yes. SQL reads close to plain English, and Class 1 starts with installing the tools and creating your first table.
Why PostgreSQL?
It’s free, widely used and very close to standard SQL. What you learn carries over to MySQL, SQL Server and Oracle with small differences we point out.
What does it cost, and when is the next batch?
We share the fee and schedule when we confirm your batch. Register below and we’ll contact you within one working day — registering doesn’t commit you to anything.
Can my organisation send a group?
Yes. We run this course as a private batch for teams, and can build exercises around your own data. See corporate training.
Pairs well with
Related courses
Data Analysis Using Python
Clean, reshape, summarise and chart data with Pandas and Matplotlib.
View courseReady to start SQL for Data Analysis?
Register now and we’ll confirm the next batch, schedule and fee with you directly.