Advanced SQL: Business Applications builds on SQL I concepts and begins with an introduction to greater SQL functionalities that can optimize and make more complex queries possible. The remainder of the course is focused purely on practice and mastery of Structured Query Language in the workplace. Beginning with business prompts one would encounter on the job, students can trial and error their answers in Afterskills' proprietary platform to rapidly up-skill in a safe and collaborative environment.
Upon completion of this course, participants will have a solid understanding of SQL syntax, how to write and debug their own queries and ultimately how to efficiently use SQL in more complex situations to generate business insights.
agenda
Topic 1:
Case
Topic 2:
Nested Queries
Topic 3:
Having
Topic 4:
Dates
Topic 5: Exercises I
Topic 6:
Exercises II
Topic 7:
Exercises III