![](https://www.haverford.edu/sites/default/files/styles/w_494/public/event-image-18081.jpg?itok=L51VL1le)
Aesop - SQL Advancement L2
Contact
Audience
- Students
Event Calendar
THIS IS A VIRTUAL EVENT. REGISTER ON HANDSHAKE.
AESOP Academy Technical Training: SQL Advancement Level 2 -- 10/05/2024, 11:00 am - 3:30 pm
SQL (Structured Query Language) is a highly demanded skill-set across industries in this data-driven era. Having a proficient command of SQL enables employees to be at the forefront of data engineering, data science, business analysis and data analytics
initiatives; therefore, it is a ‘must have’ skill for these data-centric career routes.
As we are in a digital age, acquiring SQL capabilities to become data self-sufficient is
becoming ever more essential. The answers to most pressing business questions are
buried in data warehouses, therefore having the ability to navigate a complex data
ecosystem to query the ‘gems of information’ is an invaluable skill-set for many
organizations.
Having completed our AESOP SQL Basics workshop or having prior SQL knowledge,
students will continue their upskilling journey in this course experiencing the following:
- Deeper review of JOIN types, UNION and the different impacts on data outputs. Blending multiple tables to expand dataset scope and analysis possibilities
- Better understanding and working knowledge of conditional statements: AND, OR, IN to create custom queries based on more complex business needs
- Building and understanding conditional layers within queries, e.g. how to apply layered conditional statements to solve complex requests correctly
- Building aliases and calculations within queries, e.g. creating key performance indicators (KPIs) within aggregated reports
Through a learn by doing format, AESOP students develop new techniques while
solving real world challenges to better prepare them for on the job experiences.
Register on Handshake: https://haverford.joinhandshake.com/events/1575334/share_preview