Tables and Entity Relationship diagrams - SQL Tutorial

Contents

• Introduction Introduction

  • The data-driven world

    42s
  • What you should know

    2m 22s
  • CoderPad tour

    1m 58s
• 1. The Basics of Database Structures 1. The Basics of Database Structures

  • Relational database theory

    2m 46s
  • (Locked)
    The SQLite database engine

    3m 2s
• 2. The SQL Stack 2. The SQL Stack

  • WSDA Music (sample database)

    1m 50s
  • (Locked)
    Learning tips

    1m 34s
• 3. The SQLite Database Environment 3. The SQLite Database Environment

  • How to access the DB Browser for SQLite software

    1m 6s
  • (Locked)
    Load the sample database file

    2m 19s
  • (Locked)
    Getting familiar with a database

    2m 47s
  • (Locked)
    The browse data area

    2m 5s
  • (Locked)
    The query writing area

    2m 25s
• 4. Composing Queries 4. Composing Queries

  • Queries

    1m 54s
  • (Locked)
    Query commenting

    3m 45s
  • (Locked)
    Query composition

    6m 49s
  • (Locked)
    Query composition best practices

    2m 48s
  • (Locked)
    Column custom names

    4m 9s
  • (Locked)
    Sorting query results

    3m 58s
  • (Locked)
    Limiting query results

    3m
  • (Locked)
    Solution: Concise track pricing report

    2m 28s
• 5. Discovering Insights in Data 5. Discovering Insights in Data

  • Types of SQL operators

    2m 35s
  • (Locked)
    Filter and analyze numeric data

    3m 56s
  • (Locked)
    BETWEEN and IN operators

    4m 5s
  • (Locked)
    Filter and analyze text data

    4m 58s
  • (Locked)
    Search records without an exact match

    6m 19s
  • (Locked)
    Filter and analyze using dates

    5m 48s
  • (Locked)
    Filter records based on more than one condition

    3m 36s
  • (Locked)
    Logical operator OR

    2m 39s
  • (Locked)
    Brackets and order

    6m 1s
  • (Locked)
    IF THEN logic with CASE

    9m 52s
  • (Locked)
    Solution: Categorize tracks by price

    4m 36s
• 6. Accessing Data from Multiple Tables 6. Accessing Data from Multiple Tables

  • Joins explained

    1m 41s
  • (Locked)
    How tables share a relationship, part 1

    5m 53s
  • (Locked)
    How tables share a relationship, part 2

    4m 22s
  • (Locked)
    Simplifying JOINs

    5m 41s
  • (Locked)
    Types of JOINs

    2m 55s
  • (Locked)
    The INNER JOIN

    2m 20s
  • (Locked)
    The LEFT JOIN

    2m 59s
  • (Locked)
    The RIGHT JOIN

    3m 29s
  • (Locked)
    Tables and Entity Relationship diagrams

    4m 41s
  • (Locked)
    Joining many tables

    5m 45s
  • (Locked)
    Solution: Analyzing customer support interactions

    3m 3s
• 7. SQL Functions 7. SQL Functions

  • Calculating with functions

    1m 43s
  • (Locked)
    String, date, and aggregate function types

    39s
  • (Locked)
    Connecting strings

    4m 57s
  • (Locked)
    Separating text

    4m 19s
  • (Locked)
    UPPER and LOWER string functions

    1m 59s
  • (Locked)
    Date functions

    5m 42s
  • (Locked)
    Aggregate functions

    4m 26s
  • (Locked)
    Nesting functions

    3m 10s
  • (Locked)
    Solution: Customer postal code transformation

    3m 12s
• 8. Grouping 8. Grouping

  • Grouping your query results

    57s
  • (Locked)
    Filtering with a grouped condition

    5m 48s
  • (Locked)
    Grouping with the WHERE clause

    2m 7s
  • (Locked)
    Grouping with the HAVING clause

    4m 17s
  • (Locked)
    Grouping with the WHERE and HAVING clause

    2m 49s
  • (Locked)
    Grouping by many fields

    2m 58s
  • (Locked)
    Solution: Calculate Average spend per city

    2m 29s
• 9. Nesting Queries 9. Nesting Queries

  • Subqueries and aggregate functions

    1m 22s
  • (Locked)
    SELECT clause subquery

    5m 29s
  • (Locked)
    Aggregated subqueries

    5m 9s
  • (Locked)
    Non-aggregate subqueries

    3m 15s
  • (Locked)
    IN clause subquery

    3m 49s
  • (Locked)
    DISTINCT clause subquery

    6m 29s
  • (Locked)
    Solution: Uncovering unpopular tracks

    3m 13s
• 10. Stored Queries 10. Stored Queries

  • View introduction

    1m 30s
  • (Locked)
    Creating a view

    4m 40s
  • (Locked)
    Editing a view

    3m 59s
  • (Locked)
    Joining views

    3m 10s
  • (Locked)
    Deleting views

    2m 4s
• 11. Adding, Modifying, and Deleting Data 11. Adding, Modifying, and Deleting Data

  • Analysis and administration

    1m 38s
  • (Locked)
    Inserting data

    5m 35s
  • (Locked)
    Updating data

    3m 37s
  • (Locked)
    Deleting data

    3m 5s
• 12. Scenario: Mock SQL Interview 12. Scenario: Mock SQL Interview

  • Preparing for a Non-Technical Interview

    3m 19s
  • (Locked)
    Non-Technical Interview Practice

    5m 22s
• Conclusion Conclusion

  • (Locked)
    Next steps and tips

    1m 59s