Advanced SQL
Enhance your SQL skills by mastering advanced query techniques to support more effective decision-making. This course covers advanced subqueries, complex join operations, and UNION queries for querying multiple tables. Participants will also learn transaction processing to ensure SQL statements execute reliably and how to create stored procedures to store and execute SQL statements efficiently. Prior experience with introductory and intermediate SQL concepts is required.
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.
Options
ADASQL01F26
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 |
Map / Location
ADASQL02F26
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 |
Map / Location
ADASQL03F26
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 |
Map / Location
ADASQL04F26
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 |
Map / Location
