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.
ADASQL01S26
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 |
ADASQL02S26
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 |
ADASQL03S26
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 |
