Advanced SQL
| Course code: | 26-SS-247 |
|---|---|
| Dates: | April 6 - May 1, 2026 Alternate Course Dates |
| Location: | Online |
| Instructor: | Cecelia Allison |
| Fee: | $295.00 |
Description
Advanced SQL takes your query skills to the next level by introducing techniques for complex data manipulation and decision-making. You’ll learn to write subqueries, join queries, and UNION queries that pull data from multiple tables, as well as explore transaction processing to ensure accuracy and stored procedures to streamline query execution.
Course Outcomes
- Construct advanced subqueries using keywords such as IN, EXISTS, ANY, and ALL to efficiently link and filter data across queries.
- Perform complex joins, including nested joins and joins that incorporate aggregate functions, to retrieve and analyze data from multiple related tables.
- Create and manage union queries, including UNION and UNION ALL, to combine result sets from multiple queries while applying filtering conditions.
- Implement transaction processing to ensure data integrity through commit and rollback operations.
- Develop and use stored procedures to streamline repeated tasks and enforce business logic within the database.
- Create and apply database triggers to automate responses to data changes and enforce rules at the database level.
- Professionals with intermediate SQL experience.
- Students who have completed Intermediate SQL.
Notes
Registration Deadline: Participants can register up to 5 days after the course begins.Course Access: Offered in partnership with LERN. Log in 24/7—no live meetings.
Course Format: Weekly units include readings, audio-slide lectures, self-quizzes, and discussion forums.
Tips for Success: Log in 2–3 times a week and contribute 2–3 thoughtful posts per unit for the best experience.
Recognized Credentials: Earn nationally recognized CEUs from the Learning Resources Network (LERN), a 501(c)(3) nonprofit association—perfect for meeting professional development goals or licensure requirements.
Cancellation/Refund Policy: VCU Continuing and Professional Education offers this class/certificate in partnership with LERN. Therefore, you may cancel your registration up until you receive your login and password from LERN and receive a full refund minus any credit card processing fees. Cancellations must be received via email at ocpe@vcu.edu
In the unlikely event that this program is cancelled or postponed due to insufficient enrollments or unforeseen circumstances, the university will fully refund registration fees, but cannot be held responsible for any other expenses, including change or cancellation charges to include but not limited to airlines, hotels, travel agencies, or other organizations.
Online courses offered with the Learning Resources Network (LERN) continue to run, as scheduled during inclement weather. If there are changes to meeting status, you will receive an email at the address you provided upon registration informing you of the cancelation.
*exempt-this offering is ineligible for waiver use
Student/Participant Conduct:
Participants are subject to all university policies applicable to students, unless a specific university or VCU Continuing and Professional Education policy explicitly states otherwise. University policies governing students are available at https://vcu.public.doctract.com including:
Student Code of Conduct
Honor System and Standards of Academic Conduct
Preventing and Responding to Discrimination
Title IX Sexual Harassment Policy-Interim
Sex-Based Misconduct Policy-Interim
For Academic Accommodations, please visit https://ocpe.vcu.edu/courses/policies.html#accommodations
There are still openings remaining at this time.
