Part 1: Setting Up the Database Part 2: SQL Queries and Data Manipulation Part 3: Export Data to Excel and Analyze
Tag: SQL
SQL : Advanced SQL QueriesSQL : Advanced SQL Queries
Objectives: 1. Subqueries Definition: Syntax Overview: Example: Exercise: 2. Joins with Conditions Advanced Joins: Example: Exercise: 3. Common Table Expressions (CTEs) Definition: Syntax Overview: Example: Exercise: 4. SQL Functions Overview:
SQL : Sorting Data with ORDER BYSQL : Sorting Data with ORDER BY
Objectives: 1. Introduction to ORDER BY Clause (5 minutes) Definition: Syntax Overview: Example: 2. Sorting Data in Ascending Order (10 minutes) Syntax: Example: Exercise: 3. Sorting Data in Descending Order
SQL: Grouping Data with GROUP BYSQL: Grouping Data with GROUP BY
Objectives: 1. Introduction to GROUP BY Clause Definition: Syntax Overview: Example: 2. Using COUNT() Function Syntax: Example: Exercise: 3. Using SUM() Function Syntax: Example: Exercise: 4. Using AVG() Function Syntax:
SQL : Using JOINsSQL : Using JOINs
Objectives: 1. Introduction to JOINs (5 minutes) Definition: Types of JOINs: 2. INNER JOIN (10 minutes) Syntax Overview: Example: Exercise: 3. LEFT JOIN (10 minutes) Syntax Overview: Example: Exercise: 4.
SQL : Deleting DataSQL : Deleting Data
Objectives: 1. Introduction to DELETE Statement (5 minutes) Syntax Overview: Example: 2. Deleting a Single Row (10 minutes) Basic Syntax: Exercise: 3. Deleting Multiple Rows (10 minutes) Syntax for Multiple
SQL : Updating DataSQL : Updating Data
Objectives: 1. Introduction to UPDATE Statement (5 minutes) Syntax Overview: Example: 2. Updating a Single Column (10 minutes) Basic Syntax: Exercise: 3. Updating Multiple Columns (10 minutes) Syntax for Multiple
SQL : Inserting DataSQL : Inserting Data
Objectives: 1. Introduction to INSERT INTO Statement (5 minutes) Syntax Overview: Example: 2. Inserting a Single Row (10 minutes) Basic Syntax: Exercise: 3. Inserting Multiple Rows (10 minutes) Syntax for
SQL : Sorting and Limiting ResultsSQL : Sorting and Limiting Results
Objectives: 1. Introduction to ORDER BY (5 minutes) Syntax Overview: Example: 2. Sorting in Ascending and Descending Order (10 minutes) Ascending Order (ASC): Descending Order (DESC): Examples: Exercise: 3. Limiting
SQL : Filtering Data with WHERESQL : Filtering Data with WHERE
Objectives: 1. Introduction to WHERE Clause (5 minutes) Syntax Overview: Example: 2. Comparison Operators (10 minutes) Common Comparison Operators: Examples: Exercise: 3. Logical Operators (10 minutes) Logical Operators: Examples: Exercise: