An Intermediary Understanding of SQL
Date: Wednesday 22 February
Time: 2pm to 3pm
In this webinar, Richard Skeggs will provide attendees with an intermediary understanding of SQL (Structured Query Language), and will provide an understanding of how this can be used in “real-life” scenarios. The webinar will cover:
- JOINs, ANSI-89 and ANSI-92 syntax
- UNION vs UNION ALL
- NULL handling: COALESCE & Native NULL handling
- Subqueries: IN, EXISTS, and inline views
- Subqueries: Correlated
- WITH syntax: Subquery Factoring/CTE
SQL is a useful language for programming, and can be relatively straightforward to learn and understand. It can be used to query databases, data warehouses and day-to-day manipulations. It is an ideal skill to acquire for data analysts, data scientists, data engineers and marketing managers, amongst other roles.
This webinar is aimed at an intermediate level and so attendees should have a working knowledge SQL, and should have knowledge of creating a table, inserting data, querying the table, retrieving data, and aggregating data using SQL.
For those that require a basic knowledge of SQL, we would advise that you visit the following sites prior to attending the webinar: https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/p/querying-the-table