Database Basics for Financial Professionals

This course focuses primarily on using and querying databases that already exist—you'll learn to connect, extract data, and write reports. While you'll understand database design principles (like keys and relationships) so you can work effectively with any database, you won't build production systems from scratch. As the instructor notes, most financial professionals will query and report on databases built by others, though understanding the design helps you use them better.

No prior SQL or database experience is required. The course treats SQL as a simple, readable language—you'll literally write sentences like "go get this data from this place and organize it this way." The instructor emphasizes that it took him about a week to reach practical proficiency, and the material is designed for financial professionals, not programmers.

The course uses free tools: Microsoft SSMS (SQL Server Management Studio) is featured, along with DBeaver and Excel, all available at no cost. The instructor provides a free learning database (learnsql.cpetoday.com) with sample credentials so you can connect and practice immediately using tools you likely already have or can download.

Yes, that's a core outcome. You'll learn to write basic SELECT queries, filter data with WHERE clauses, join multiple tables, and aggregate results with SUM and GROUP BY. The instructor demonstrates real examples like "select all customers from the USA" and building sales reports by channel and product—tasks you'll be equipped to do independently by the end.

The course balances both: early sections establish fundamental concepts (keys, relationships, normalization) with visual diagrams, but the middle and late portions feature live SQL demonstrations in actual database tools, Power Query walkthroughs, and Power BI dashboard building. You'll see working queries executed and results returned, then modify them in real time.