In this advanced SQL class, you’ll learn to add If-Else logic to your queries with CASE statements and use string functions to extract exactly the text you need. You’ll also work with subqueries, which let you dynamically pull data from anywhere in a database and use that result in another query.
If you (or others) don’t have permissions to query tables directly, you’ll discover how to query using Views instead. You’ll also learn to use functions with parameters and how to run reusable stored procedures.
By the end of this advanced, hands-on course, you’ll have mastered deeper SQL techniques that will better prepare you for work in data analysis, data science, or any position that requires SQL to manage and analyze data in databases.
SQL proficiency equivalent to our SQL Level 2 course is required, including JOINs, aggregate functions, GROUP BY and HAVING, as well as working with CAST and date/time.
Receive instruction from subject‑matter experts who bring proven government experience.
Courses that are regularly updated based on feedback and industry developments, ensuring versions are mapped to federal competencies.
The instructor was wonderful and so knowledgeable. The course materials were extremely relevant to what my job is. I feel like I can be better because of this class.
— 2025 student
Directly addressing the day-to-day challenges of federal employees.
Your trusted training partner, equipping public service professionals with the skills and knowledge to excel in their roles and drive meaningful impact.
Attend this course Live Online. Engage with expert instructors, ask questions, and get feedback on your exercises and projects.
At Graduate School USA, you’ll learn in small groups and receive personalized attention.
Get the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.
Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
Shareable on
You can also access recordings of each session in your student portal within one business day of the session’s end. Recordings are available for one month after the session.
