Course curriculum

  1. 1

    • Google Subtitles Instructions

    • 1.1 What is SQL and why as developers we need to know it

    • 1.2 The software we need to get started
  2. 2

    • 2.1 Creating our property table

    • 2.2 Creating our agent table and adding a foreign key to the property table

    • 2.3 Creating our interested buyer table
  3. 3

    • 3.1 Inserting dummy data for agents

    • 3.2 Inserting the rest of our dummy data
  4. 4

    • 4.1 Basic select, update and delete statements

    • 4.2 Joining information from other tables

    • 4.3 Joining multiple tables
  5. 5

    • 5.1 Sorting and limiting

    • 5.2 Unique keyword
  6. 6

    • 6.1 Create a basic Express API function and connect to then query database

    • 6.2 Fixing error where server would crash on second request

    • 6.3 Extending our API with additional functionality to get and search tables

    • 6.4 Building on our API and where to go from here