01 / Tables & SELECT queries
Read database tables and retrieve selected fields from a sample finance dataset.
Learn to query financial tables, connect transactions and turn business questions into repeatable analysis.
Read database tables and retrieve selected fields from a sample finance dataset.
Use filters, grouped totals and conditional logic to answer questions about invoices and payments.
Join related tables, identify duplicate rows and reconcile outputs to source totals.
Write reusable reporting queries and record data-quality assumptions and validation results.
SELECT queries, filters, grouped totals, joins and reconciled financial reports.
A set of reconciled SQL reports for a sample invoice dataset.
Final curriculum, instructor, duration, software access and assessment details will be confirmed before enrolment.
Analysts and finance professionals beginning to work directly with structured data.
Comfort with spreadsheet tables; no prior SQL experience required.
Analysts and finance professionals beginning to work directly with structured data.
Comfort with spreadsheet tables; no prior SQL experience required.
A set of reconciled SQL reports for a sample invoice dataset.
Request the confirmed duration, fee, delivery format, instructor and software requirements before enrolment.
This is independent professional development. It does not award a regulated designation or vendor certification.
Tell us your goals. We’ll help you explore the right course.