An Intermediary Understanding of SQL
Date:
22/02/2017
Organised by:
University of Essex
Presenter:
Richard Skeggs
Level:
Intermediate (some prior knowledge)
Contact:
Richard Skeggs, 01206 873891, rskeggs@essex.ac.uk
Venue: Online
Description:
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
- Views
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
Cost:
Free
Website and registration:
http://www.blgdataresearch.org/intermediarysqlwebinar/
Region:
East of England
Keywords:
ICT and Software, SQL , Structured Query Language
Related publications and presentations: