Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.
Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
21 Videos (1h 36m)
    • Welcome to the course!

      1:04
    • Installing and setting up

      4:50
    • A primer on pgAdmin 3

      6:17
    • Using the provided course data

      11:53
    • The SELECT statement

      3:50
    • The WHERE clause — filtering rows

      3:09
    • The LIMIT clause — limiting results

      2:28
    • The ORDER BY clause

      2:30
    • The UPDATE statement

      4:42
    • The DELETE statement

      2:56
    • The LIKE clause — fuzzy search

      2:10
    • What are JOINs?

      11:40
    • JOINs in code

      5:18
    • GROUP BY on JOINs

      5:48
    • ORDER BY on JOINs

      2:58
    • pgAdmin CREATE scripts

      2:30
    • Data management with PostgreSQL

      7:09
    • The SERIAL data type for auto-incrementing

      1:51
    • PRIMARY KEY and FOREIGN KEY

      6:26
    • INDEX and the btree algorithm

      5:47
    • Congratulations!

      0:19

About This Class

Learn PostgreSQL today in this short course, whether you are a beginner, or looking to efficiently refresh your knowledge.

In this course we'll cover:

  • The basic building blocks of SQL queries, such as filtering, ordering, limiting, and grouping.
  • The different types of JOINs and what each is used for.
  • Database management and what an INDEX is.

If you're looking to learn how you can interact with a relational database in an effective way, start taking this course today.

I designed the course to be highly interactive, so you can follow along and try out each of the examples using some provided data. You'll retain knowledge best by using it!

I'm always available to answer questions and help out individually, no matter what you need.

I'll see you on the inside!

13

Students

--

Projects

Jose Salvatierra

Software Engineer and Computer Science Instructor

Hi! I'm Jose. I'm a software engineer at one of Scotland's leading engineering companies.

I started programming at the age of 10 when my dad, excited that I had showed interest in similar things to himself, taught me the basics of Marin Saric's METAL. Shortly thereafter we moved on to RealBASIC. After a couple years I started learning Java and C.

Ever since, I knew I wanted to study Computer Science or something along those lines. Half a decade ago I ended up at the University o...

See full profile