PostgreSQL - Joins, Modifying Data, and Defining Tables | Will Bunker | Skillshare

PostgreSQL - Joins, Modifying Data, and Defining Tables

Will Bunker, Co-founder of what became Match.com

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
35 Videos (2h 22m)
    • Introduction

      0:55
    • Drawing Table Relationships

      3:10
    • Inner Join for two tables

      6:11
    • Inner Joins for multiple tables

      6:11
    • Left Joins

      3:25
    • Right Joins

      3:17
    • Full Joins

      2:25
    • Self Join

      4:00
    • Group By

      8:18
    • HAVING to filter Groups

      4:40
    • UNION

      3:24
    • Subquery Using EXISTS

      8:43
    • Subquery Using ANY and ALL

      7:33
    • IN Using Subquery

      1:41
    • 38 INSERT INTO

      7:59
    • UPDATE

      3:28
    • DELETE

      2:10
    • SELECT INTO

      2:48
    • INSERT INTO SELECT

      2:38
    • CREATE DATABASE

      1:39
    • DROP DATABASE

      1:22
    • CREATE TABLE

      9:30
    • ALTER TABLE Part One

      3:40
    • ALTER TABLE Part Two

      3:10
    • ALTER TABLE Part 3

      2:11
    • CREATE INDEX

      3:35
    • DROP INDEX

      1:41
    • 51 DROP TABLE

      1:07
    • NOT NULL Constraint

      5:15
    • UNIQUE Constraint

      3:45
    • Primary key constraint

      5:54
    • 55 FOREIGN KEY constraint

      7:00
    • CHECK Constraint

      5:29
    • DEFAULT Constraint

      2:43
    • Conclusion

      0:56

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.  

This is my second course on using PostgreSQL.  We will walk through

  • Using joins to query information from more than one table
  • Subqueries - how to use a query within a query
  • Grouping records and filtering the results
  • Changing the data using INSERT, DELETE, and UPDATE
  • Creating new tables
  • Adding restrictions on information that can be added to tables
  • Creating indexes

13

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

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
Report class