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!

4

Students

--

Projects

0

Reviews (0)

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 of Dundee, studying Applied Computing.

The University of Dundee is one of the most prestigious for computing-related courses, and I was offered the chance to participate in their computing scholarships due to academic achievement.

I have worked for "Eseye", an M2M company, as an intern doing mainly backend developing, and currently work for Skyscanner, one of Scotland's largest technology companies, programming mainly in Python and web languages. I also run an online training company, which is what brings you my courses in this platform!

I hope that my courses are interesting to you, enjoyable and that you learn from them!