Intermediate SQL
Learn how to write powerful SQL queries to retrieve data from single or multiple tables within a database. In this course, you’ll gain the skills to extract more meaningful insights by combining data across tables, merging columns, creating calculated fields, and organizing results using sorting and grouping techniques. You’ll also explore how to use joins and subqueries to efficiently pull data from multiple sources in a single query.
Students should have a foundational understanding of introductory SQL concepts.
Requirements:
- Windows 10 or later. Macs are not compatible.
- Necessary rights (local administrative rights) to install programs on the computer.
This course is included in the SQL Certificate course.
Cecelia Allison
Dr. Cecelia Allison is a course developer, published author, technical writer, and an online professor with more than 20 years of hands-on experience using and teaching SQL. She has taught over 90,000 students SQL worldwide.
Through her past employment as a technical specialist, software tester, and teaching SQL, she has gained extensive experience in writing and implementing SQL. She holds a Bachelor of Science in Finance, a Master of Science in Information Systems, and a Doctor of Business Administration in Management Information Systems.
ADMSQL01S26
Instructors:
- Cecelia Allison
| Date | Time | Location |
|---|---|---|
| Mon, Jun 1st 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Jun 2nd 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Jun 3rd 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Jun 4th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Jun 5th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Jun 6th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Jun 7th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Jun 8th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Jun 9th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Jun 10th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Jun 11th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Jun 12th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Jun 13th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Jun 14th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Jun 15th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Jun 16th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Jun 17th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Jun 18th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Jun 19th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Jun 20th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Jun 21st 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Jun 22nd 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Jun 23rd 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Jun 24th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Jun 25th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Jun 26th 2026 | 12:01 AM - 11:59 PM | Online |
ADMSQL02S26
Instructors:
- Cecelia Allison
| Date | Time | Location |
|---|---|---|
| Mon, Jul 6th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Jul 7th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Jul 8th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Jul 9th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Jul 10th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Jul 11th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Jul 12th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Jul 13th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Jul 14th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Jul 15th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Jul 16th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Jul 17th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Jul 18th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Jul 19th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Jul 20th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Jul 21st 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Jul 22nd 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Jul 23rd 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Jul 24th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Jul 25th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Jul 26th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Jul 27th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Jul 28th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Jul 29th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Jul 30th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Jul 31st 2026 | 12:01 AM - 11:59 PM | Online |
ADMSQL03S26
Instructors:
- Cecelia Allison
| Date | Time | Location |
|---|---|---|
| Mon, Aug 3rd 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Aug 4th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Aug 5th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Aug 6th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Aug 7th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Aug 8th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Aug 9th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Aug 10th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Aug 11th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Aug 12th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Aug 13th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Aug 14th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Aug 15th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Aug 16th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Aug 17th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Aug 18th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Aug 19th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Aug 20th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Aug 21st 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Aug 22nd 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Aug 23rd 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Aug 24th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Aug 25th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Aug 26th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Aug 27th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Aug 28th 2026 | 12:01 AM - 11:59 PM | Online |
