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.
ADMSQL01F26
Instructors:
- Cecelia Allison
| Date | Time | Location |
|---|---|---|
| Tue, Sep 8th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Sep 9th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Sep 10th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Sep 11th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Sep 12th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Sep 13th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Sep 14th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Sep 15th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Sep 16th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Sep 17th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Sep 18th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Sep 19th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Sep 20th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Sep 21st 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Sep 22nd 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Sep 23rd 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Sep 24th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Sep 25th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Sep 26th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Sep 27th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Sep 28th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Sep 29th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Sep 30th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Oct 1st 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Oct 2nd 2026 | 12:01 AM - 11:59 PM | Online |
ADMSQL02F26
Instructors:
- Cecelia Allison
| Date | Time | Location |
|---|---|---|
| Mon, Oct 5th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Oct 6th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Oct 7th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Oct 8th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Oct 9th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Oct 10th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Oct 11th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Oct 12th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Oct 13th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Oct 14th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Oct 15th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Oct 16th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Oct 17th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Oct 18th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Oct 19th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Oct 20th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Oct 21st 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Oct 22nd 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Oct 23rd 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Oct 24th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Oct 25th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Oct 26th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Oct 27th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Oct 28th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Oct 29th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Oct 30th 2026 | 12:01 AM - 11:59 PM | Online |
ADMSQL03F26
Instructors:
- Cecelia Allison
| Date | Time | Location |
|---|---|---|
| Mon, Nov 2nd 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Nov 3rd 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Nov 4th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Nov 5th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Nov 6th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Nov 7th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Nov 8th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Nov 9th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Nov 10th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Nov 11th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Nov 12th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Nov 13th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Nov 14th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Nov 15th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Nov 16th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Nov 17th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Nov 18th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Nov 19th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Nov 20th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Nov 21st 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Nov 22nd 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Nov 23rd 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Nov 24th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Nov 25th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Nov 26th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Nov 27th 2026 | 12:01 AM - 11:59 PM | Online |
ADMSQL04F26
Instructors:
- Cecelia Allison
| Date | Time | Location |
|---|---|---|
| Mon, Dec 7th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Dec 8th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Dec 9th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Dec 10th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Dec 11th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Dec 12th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Dec 13th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Dec 14th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Dec 15th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Dec 16th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Dec 17th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Dec 18th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Dec 19th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Dec 20th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Dec 21st 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Dec 22nd 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Dec 23rd 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Dec 24th 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Dec 25th 2026 | 12:01 AM - 11:59 PM | Online |
| Sat, Dec 26th 2026 | 12:01 AM - 11:59 PM | Online |
| Sun, Dec 27th 2026 | 12:01 AM - 11:59 PM | Online |
| Mon, Dec 28th 2026 | 12:01 AM - 11:59 PM | Online |
| Tue, Dec 29th 2026 | 12:01 AM - 11:59 PM | Online |
| Wed, Dec 30th 2026 | 12:01 AM - 11:59 PM | Online |
| Thu, Dec 31st 2026 | 12:01 AM - 11:59 PM | Online |
| Fri, Jan 1st 2027 | 12:01 AM - 11:59 PM | Online |