Challenge: Delete records - SQL Tutorial

Contents

• Introduction Introduction

  • SQL for data engineering

    37s
  • What you should know

    1m 41s
  • Using Codespaces

    1m 39s
• 1. SQL Introduction 1. SQL Introduction

  • What is SQL and why learn it?

    8m 4s
  • Role of SQL in data engineering

    5m 53s
  • (Locked)
    Setting up the SQL environment: Install PostgreSQL

    7m 55s
  • (Locked)
    Walkthrough: PostgreSQL

    7m 22s
• 2. SQL Basics 2. SQL Basics

  • Introduction to databases and tables

    9m 5s
  • SQL syntax and basic queries

    12m 11s
  • Selecting and filtering data

    5m 18s
  • (Locked)
    Sorting data with ORDER BY

    7m 48s
  • (Locked)
    Combining conditions with AND and OR

    7m 26s
  • (Locked)
    Challenge: Combine filter and ORDER BY

    34s
  • (Locked)
    Solution: Combine filter and ORDER BY

    45s
• 3. Data Manipulation 3. Data Manipulation

  • (Locked)
    Introduction to data manipulation

    3m 25s
  • (Locked)
    Inserting data into tables

    9m 51s
  • (Locked)
    Updating existing records

    8m 14s
  • (Locked)
    Deleting records from tables

    8m 52s
  • (Locked)
    Challenge: Delete records

    25s
  • (Locked)
    Solution: Delete records

    23s
• 4. Advanced Data Querying 4. Advanced Data Querying

  • (Locked)
    Introduction to joins

    5m 2s
  • (Locked)
    Inner join explained

    7m 9s
  • (Locked)
    Left and right joins explained

    7m 18s
  • (Locked)
    Full outer joins

    10m 41s
  • (Locked)
    Using the UNION operator

    9m 2s
  • (Locked)
    Using the CASE statement for conditional logic

    7m 12s
  • (Locked)
    Using GROUP BY to aggregate data

    8m 52s
  • (Locked)
    Common aggregation functions: SUM, AVG, COUNT, etc.

    6m 38s
  • (Locked)
    Filtering GROUP BY results with the HAVING clause

    7m 52s
  • (Locked)
    Challenge: Joins

    37s
  • (Locked)
    Solution: Joins

    1m 49s
• 5. SQL Functions 5. SQL Functions

  • (Locked)
    Introduction to SQL functions

    4m 30s
  • (Locked)
    Using mathematical functions

    4m 56s
  • (Locked)
    Working with date functions

    9m 2s
  • (Locked)
    Working with time functions

    7m 6s
  • (Locked)
    String functions: Concatenation and trimming

    5m 45s
  • (Locked)
    String functions: Changing case and extracting substrings

    7m 22s
  • (Locked)
    Challenge: Play with strings

    48s
  • (Locked)
    Solution: Play with strings

    50s
• 6. SQL Analytical Functions 6. SQL Analytical Functions

  • (Locked)
    Introduction to analytical functions

    5m 31s
  • (Locked)
    Using the RANK() function

    7m 16s
  • (Locked)
    Using the DENSE_RANK() function

    4m 27s
  • (Locked)
    Exploring the ROW_NUMBER() function

    6m 35s
  • (Locked)
    Understanding the LAG() and LEAD() functions

    7m 55s
  • (Locked)
    Running totals with SUM() OVER()

    7m 29s
  • (Locked)
    Calculating moving averages

    7m 33s
  • (Locked)
    Challenge: Find out the sum

    33s
  • (Locked)
    Solution: Find out the sum

    44s
• 7. Views and Stored Procedures 7. Views and Stored Procedures

  • (Locked)
    Introduction to views

    4m 10s
  • (Locked)
    Creating and using views

    8m 2s
  • (Locked)
    Introduction to stored procedures

    4m 57s
  • (Locked)
    Creating and executing stored procedures

    5m 44s
  • (Locked)
    Challenge: Select via view

    27s
  • (Locked)
    Solution: Select via view

    2m
• 8. Indexes and Performance 8. Indexes and Performance

  • (Locked)
    Introduction to indexes

    4m 28s
  • (Locked)
    Creating and managing indexes

    6m 9s
  • (Locked)
    Understanding query performance

    8m 12s
  • (Locked)
    Basic performance tuning techniques

    7m 20s
  • (Locked)
    Challenge: Indexes

    35s
  • (Locked)
    Solution: Indexes

    49s
• 9. Database Security and User Management 9. Database Security and User Management

  • (Locked)
    Introduction to database security

    5m 55s
  • (Locked)
    Understanding users and roles in SQL

    4m 41s
  • (Locked)
    Creating users and assigning roles

    8m 35s
  • (Locked)
    Granting and revoking permissions

    9m 33s
  • (Locked)
    Using roles for permission management

    6m 34s
  • (Locked)
    Best practices for managing roles and permissions

    7m 10s
  • (Locked)
    Challenge: Create a role

    27s
  • (Locked)
    Solution: Create a role

    1m 1s
• 10. Debugging: Common Mistakes and SQL Errors 10. Debugging: Common Mistakes and SQL Errors

  • (Locked)
    Understanding SQL syntax errors

    9m 43s
  • (Locked)
    Logical errors in SQL

    7m 35s
  • (Locked)
    Debugging NULL values

    6m 48s
  • (Locked)
    Practical example: Debugging real SQL issues

    6m 26s
• 11. ETL Overview 11. ETL Overview

  • (Locked)
    What is ETL and its importance

    6m 28s
  • (Locked)
    ETL process flow

    5m 30s
  • (Locked)
    Common ETL tools

    7m 23s
• 12. Real-World Project 12. Real-World Project

  • (Locked)
    Final project: Insurance claims analysis

    3m 4s
  • (Locked)
    Final project solution: Insurance claims analysis

    12m 53s
• Conclusion Conclusion

  • (Locked)
    Next steps

    51s