DATA & TECH
SQL for Analysts: Ask a Database Anything
Write the SQL that answers real business questions, from your first SELECT to joins, aggregation, subqueries, window functions and queries you can hand to a manager with confidence.
- 12 lessons
- ~3 hours
- Beginner-friendly
- Project + certificate
Free account required to open the lessons. Any price is shown before you pay.
- Free to startOpen a free account and start. Any price is shown before you pay.
- Earned, not boughtCertificates are never sold. You pass a graded project, and anyone can verify it.
- Self-pacedShort lessons you take at your own pace. Your progress is saved.
- Built for real workLessons follow how the work is actually done and paid for, and end in a project you can show.
What you'll learn
- Setting up a free local database
- SELECT, WHERE, ORDER BY and LIMIT
- GROUP BY, HAVING and aggregate functions
- INNER, LEFT and self joins
- Dates, text and CASE expressions
- Subqueries and common table expressions
- Window functions: running totals and rankings
- Understanding keys, tables and relationships
- Checking and reconciling query results
- Turning business questions into queries
- Writing readable, maintainable SQL
- Dialect differences across SQLite, MySQL, PostgreSQL and SQL Server
About this course
Every serious company keeps its data in a database, and the analysts who can ask it questions directly, without waiting for someone else to export a spreadsheet, are the ones who get answers first and get promoted. This course teaches SQL the way analysts actually use it. You set up a free database on your own laptop from the course's practice files (the same Mama Ngozi Foods business used across Skillnaija's data courses: sales, products, customers, branches and staff), then learn to select and filter, sort and limit, aggregate with GROUP BY and HAVING, join tables, work with dates and text, build subqueries and common table expressions, use window functions for running totals and rankings, and write clean, readable queries that others can maintain. Along the way you learn how databases are designed, why joins produce wrong totals when keys are misunderstood, how to check your own numbers, and how to turn a manager's vague question into a precise query. Syntax differences between SQLite, MySQL, PostgreSQL and SQL Server are pointed out where they matter, so what you learn transfers to any Nigerian employer's system.
Kemi Adebayo started as an analyst at Mama Ngozi Foods on a Monday. By Wednesday she had asked the accountant for the sales figures three times and received three different Excel files, each exported on a different day, each with a different total for March. On Thursday Mrs Ngozi Okonkwo, the general manager, asked her a simple question in the corridor: 'How many invoices did Agege raise last month, and how many of them are still unpaid?' Kemi had no way to answer it that she trusted. The accountant's software knew. It kept every invoice in a database. Nobody in the office knew how to ask that database anything without going through the accountant. By the end of this course, Kemi can, and so can you.
Who it's for
Beginner-friendly. You can start from scratch: no prior experience is assumed.
The lessons 12 lessons, ending in a graded project
- 1What a database is, and getting one for free15 min
- 2SELECT, WHERE, ORDER BY, LIMIT: asking your first real questions16 min
- 3Counting and summing: GROUP BY and HAVING16 min
- 4Joining tables: names instead of codes16 min
- 5Dates, text and CASE: shaping the answer16 min
- 6Subqueries: a question inside a question16 min
- 7Common table expressions: queries you can read15 min
- 8Window functions: rankings, running totals and month-over-month16 min
- 9Set operations, data quality and the checks you run before trusting a report16 min
- 10Changing data and building tables, carefully16 min
- 11From a manager's question to a query16 min
- 12SQL at work: dialects, tools and next steps17 min
- Project: Your Management Query PackGraded
THE PROJECT AND YOUR CERTIFICATE
Your Management Query Pack
One document (Google Doc with view access, or an uploaded PDF or Word file) with every query as text, its results, and the findings report. A link to a public repository with a .sql file is welcome in addition.
Certificates on Skillnaija are earned, not issued for attendance: you submit this project, an examiner grades the real work against a published rubric (you need 65% to pass), and passing issues a certificate anyone can verify. If you don't pass yet, you get written feedback and can try again.
- The database is set up correctly and the three checks are present and consistent14%
- The branch-by-month query is correct, joins properly, handles refunds and is ordered as asked18%
- The product, share and inactive-customer queries are correct and use the right join or subquery18%
- The window-function ranking and the HAVING query are correct and the threshold is justified16%
- The CTE and month-over-month query are correct and the seasonality comment is sound16%
- The findings report is clear, reconciles totals, and states a real limitation18%
Frequently asked questions
Is SQL for Analysts: Ask a Database Anything free?
Most Skillnaija courses can be started free with a free account: your first two courses are free to start, then one new course each month. Some courses are paid; the course page in the app shows whether SQL for Analysts: Ask a Database Anything is one, and its price, before you pay. You can also buy any course on its own for twelve months, or open every course with the All-Access Pass. Certificates are never sold: you earn one by passing the course's project.
How long does SQL for Analysts: Ask a Database Anything take to complete?
6 weeks · ~4 hrs/week. There are 12 lessons, about 3 hours of material in total. You learn at your own pace and your progress is saved.
Do I need any experience to start SQL for Analysts: Ask a Database Anything?
Beginner-friendly. You can start from scratch — no prior experience is assumed.
What will I learn in SQL for Analysts: Ask a Database Anything?
You will build practical skills in Setting up a free local database, SELECT, WHERE, ORDER BY and LIMIT, GROUP BY, HAVING and aggregate functions, INNER, LEFT and self joins, Dates, text and CASE expressions, Subqueries and common table expressions, Window functions: running totals and rankings, Understanding keys, tables and relationships, Checking and reconciling query results, Turning business questions into queries, Writing readable, maintainable SQL, Dialect differences across SQLite, MySQL, PostgreSQL and SQL Server. Every lesson is written in plain English, with examples drawn from how the work is actually done and paid for, in Nigeria and beyond.
Do I get a certificate for SQL for Analysts: Ask a Database Anything?
Yes, but it has to be earned. You complete the course project — Your Management Query Pack and submit it for grading. Passing the project issues a verifiable certificate; finishing the lessons alone does not.
Ready to start SQL for Analysts: Ask a Database Anything?
It is self-paced, and it ends with something you can show an employer.
Start learning free