Advanced SQL: 
Business Applications

Core Skills
 This advanced SQL module builds on concepts taught in SQL I to set participants on a path to mastery.  SQL (Structured Query Language) is the predominate programming language for extracting data from databases. It allows users to efficiently pull data from enterprise level databases and is critical to any individual or business looking to generate new business insights. 

Business Applications: 
SQL in the Workplace

Core Skills
 This advanced SQL module builds on concepts taught in SQL I to set participants on a path to mastery.  SQL (Structured Query Language) is the predominate programming language for extracting data from databases. It allows users to efficiently pull data from enterprise level databases and is critical to any individual or business looking to generate new business insights. 

prerequisites

Successful completion of

Taken within the last year

duration

Full day or
two half-days

Virtual or in-person

certification

afterskills SQL II
practitioner

Awarded upon completion

course description_

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
ENQUIRE