Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Data powers today’s business decisions, and much of that data lives in databases. To work effectively with financial, accounting, or operational data, understanding SQL is essential. SQL enables you to convert raw data into meaningful insights, supporting accurate analysis and informed decision‑making.
Many professionals rely on an external resource to act as an intermediary to the database, which can create delays and lead to misunderstood requests. This course empowers you to bridge that gap by learning SQL yourself. You’ll gain the skills to query databases directly, extract the information you need, and work more confidently and independently with data.
Topics Include:
- The SQL Environment
- The Six Basic Clauses
- The SELECT Clause
- The FROM Clause
- The WHERE Clause
- The GROUP BY Clause
- The ORDER BY Clause
- Sample Queries
Schedule
- May 13, 2026, 1:00 p.m. - 5:00 p.m.
- May 15, 2026, 1:00 p.m. - 5:00 p.m.
Key Takeaways
Upon completion of this course, learners will be able to:
- Analyze and summarize data stored in databases.
- Connect to a database directly without the need for an intermediate resource.
- Perform well on typical SQL job interview questions.
- Increase visibility to the contents of a database.
- Use ChatGPT as a helpful resource when coding.
Who Will Benefit
This course is ideal for business professionals who work with data and want the ability to access and analyze it independently.
Prerequisite(s)
- Learners should be familiar with a Windows based personal computer.
- Learners will need a Windows based laptop with Microsoft Access to participate in the examples.
How to Access the Course
This course is a live webinar. You must attend the live course to receive verifiable CPD hours. We recommend you join five minutes prior to the scheduled starting time. To get the full experience of this interactive course, use a computer that has video and microphone capabilities.
If available, course materials can be accessed 2 business days prior to the course and should be downloaded in advance.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Scott Cuthbertson is an experienced Data Analyst, Data Scientist, Software Developer and Coding Workshop Teacher. He analyzes data, builds applications and leads workshops to show business people how they can automate their workflows. He has taught coding skills at CPA Ontario for over 10 years.