Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
26 Videos (1h 2m)
    • introduction

      1:06
    • Why Learn SQL?

      4:46
    • Installing PostgreSQL

      2:23
    • Install Northwind Database

      2:26
    • Selecting All Data From a Table

      2:38
    • Selecting Specific Fields

      1:48
    • Selecting Distinct Values

      2:12
    • Counting Results Revised

      3:16
    • Combining fields in SELECT

      1:38
    • WHERE with text fields

      2:13
    • WHERE with Numeric Fields

      2:17
    • 11 WHERE with Date fields

      1:42
    • 12 WHERE using AND

      2:44
    • 13 WHERE using OR

      2:56
    • WHERE Using NOT

      1:19
    • WHERE Combining AND OR NOT

      2:25
    • Using BETWEEN

      2:00
    • Using IN

      2:01
    • ORDER BY

      3:14
    • Using MIN and MAX

      2:06
    • Using AVG and SUM

      2:05
    • LIKE to Match Patterns

      4:01
    • Renaming Column With Alias

      3:06
    • LIMIT to Control

      2:26
    • NULL Values

      2:22
    • Conclusion

      0:52

About This Class

Learning SQL was one of the most valuable skills I learned while building Match.  We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running.  The better we got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users.  

I want to teach you how to use PostgreSQL.  We will walk through

  • Basic selection statements
  • Finding unique values with DISTINCT
  • Calculating values by combing fields
  • Using WHERE to narrow results down
  • Logical operators AND, OR and NOT
  • Ordering results
  • Using aggregate operators MAX, MIN, AVG, and SUM
  • Using LIKE to match text patterns

8

Students

--

Projects

0

Reviews (0)

Will Bunker

Co-founder of what became Match.com

Dave Kennedy and I started what became the largest dating site of the 90's, from a telephone closet at an insurance company. I taught myself from the ground up how to build a site that became one of the top 100 visited sites by 1999. Since then, I have helped found several more businesses and invested in over 160 tech companies.

I love to learn new stuff and have a found a way to reach my dreams by learning the latest technologies. You can too. I've helped dozens of others learn ...

See full profile

Technology Data Science