Who this course is for - SQL Tutorial

Contents

• Introduction Introduction

  • Don't let your reporting system hold you back

    39s
  • Who this course is for

    20s
  • What is SQL?

    4m 12s
• 1. Prepare to Code in SQL 1. Prepare to Code in SQL

  • Get familiar with phpMyAdmin

    3m 45s
  • (Locked)
    Understand the demo database

    1m 34s
  • (Locked)
    Using ChatGPT to check SQL code

    3m 14s
• 2. Use SQL to Report Data 2. Use SQL to Report Data

  • Retrieve data with SELECT

    5m 31s
  • (Locked)
    Filter results with the WHERE clause

    5m 4s
  • (Locked)
    Use LIKE, IN, and wildcards with WHERE

    5m 39s
  • (Locked)
    Sort SQL results with ORDER BY

    1m 42s
  • (Locked)
    Use string functions on your data

    6m 41s
  • (Locked)
    More advanced string functions

    8m 35s
  • (Locked)
    Change report headings with an alias

    2m 28s
  • (Locked)
    Use date functions with WHERE

    8m 50s
  • (Locked)
    Challenge: Query a table

    1m 7s
  • (Locked)
    Solution: Query a table

    1m 23s
  • (Locked)
    Challenge: Convert case

    50s
  • (Locked)
    Solution: Convert case

    2m 30s
• 3. Group Your SQL Results 3. Group Your SQL Results

  • (Locked)
    Use GROUP BY with count

    5m 47s
  • (Locked)
    Filter grouped results with HAVING

    4m 31s
  • (Locked)
    Deduplicate with SELECT DISTINCT

    6m 30s
  • (Locked)
    Merge rows with GROUP BY

    2m 24s
  • (Locked)
    Challenge: Cost analysis

    1m 17s
  • (Locked)
    Solution: Cost analysis

    1m 32s
• 4. Merge Data from Multiple Tables 4. Merge Data from Multiple Tables

  • (Locked)
    Make your queries faster

    1m 47s
  • (Locked)
    Understand SQL indexes and keys

    7m 16s
  • (Locked)
    EDIT: Visualize your database

    7m 58s
  • (Locked)
    Merge data across tables with JOIN

    5m 2s
  • (Locked)
    Understand SQL JOINS

    4m 16s
  • (Locked)
    Combine rows with SQL UNION

    4m 49s
  • (Locked)
    Merge data across tables with IN

    2m 11s
  • (Locked)
    Select from a selection with subqueries

    2m 56s
  • (Locked)
    Challenge: Join tables

    1m 4s
  • (Locked)
    Solution: Join tables

    4m 37s
• 5. More Advanced SQL 5. More Advanced SQL

  • (Locked)
    Save your queries using a VIEW

    8m 28s
  • (Locked)
    Use variables

    5m 17s
  • (Locked)
    Use functions

    8m 4s
  • (Locked)
    Use procedures

    4m 58s
• Continuing Your SQL Learning Journey Continuing Your SQL Learning Journey

  • (Locked)
    Next steps and additional resources

    1m 2s