SQL Workshop
About the SQL Workshop
SQL is a most demanded skill for many roles including Business Analysts, Product Managers, Data Scientists, and Knowledge Workers who are working with data.
This hands-on workshop covers everything that is needed to know about SQL for performing data analysis using SQL Queries. The workshop covers both extracting data and loading data to SQL databases. It also focuses on the creation of database objects including views and stored procedures.
What the SQL Workshop covers?
- SELECT statement basics
- Updating data in tables
- Creating and Updating tables structure
- Using functions
- Conditional statments
- Using DML (Data Manipulation Language) to manage data
- Using DDL (Data Definition Language) to manage database objects
- Writing Stored Procedures
The course syllabus
SQL SELECT
- SELECT
- GROUP BY
- JOIN
- Nested Queries
DML - Data Manipulation Language
- INSERT
- UPDATE
- DELETE
- TRUNCATE
DDL - Data Definition Language
- CREATE TABLE
- ALTER TABLE
- DROP TABLE
SQL Lab
- Creating a Database
- Adding data
- Advanced Queries