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
- July 22, 2026, 1:00 p.m. - 5:00 p.m.
- July 24, 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 delivered as a live webinar. To receive verifiable CPD hours, you must attend the session live. We recommend joining at least 5 minutes before the scheduled start time. For the best interactive experience, please use a computer equipped with a camera and microphone.
A reminder email with the Zoom link and course details will be sent two business days before the session. If you do not receive it, please check your spam or junk folder.
The same information, including any available materials, will also be posted in advance on our Blackboard LMS.
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.