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