Learn PostgreSQL from Pluralsight

Pluralsight offers you 7 courses, to learn PostgreSQL now!

Pluralsight, is an American publicly held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 6,500 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.

  • flag Pluralsight
  • student Intermediate
  • database Video
  • earth English
  • clock 1h 54m

Capturing Logic with Custom Functions in PostgreSQL

Whether you are getting into PostgreSQL for the first time or an experienced developer wanting to explore function-writing more deeply^ this course is for you. You will learn foundational knowledge of how to build your own functions in PostgreSQL.

Read More
  • flag Pluralsight
  • student Beginner
  • database Video
  • earth English
  • clock 1h 57m

Combining and Filtering Data with PostgreSQL

This course will teach you how to use PostgreSQL to expand your queries to filter and combine data. Using SQL^ you’ll learn how to join data from multiple tables^ combine result sets^ and use aggregate and window functions.

Read More
  • flag Pluralsight
  • student Beginner
  • database Video
  • earth English
  • clock 1h 28m

Querying Data from PostgreSQL

In this course^ you ll learn how to use PostgreSQL to author queries that retrieve information from databases. Using SQL^ you ll learn how to select the data you need^ filter that data^ and gather data from various tables.

Read More
  • flag Pluralsight
  • student Intermediate
  • database Video
  • earth English
  • clock 2h 33m

PostgreSQL Data Manipulation Playbook

Data modifications are a critical aspect of application design. In this course^ you will learn about challenges associated with multi-user data access and the tools that PostgreSQL provides to tackle them^ so you can avoid data consistency issues.

Read More
  • flag Pluralsight
  • student Expert
  • database Video
  • earth English
  • clock 2h 28m

PostgreSQL Functions Playbook

Most programming languages come with built-in functions and SQL is no exception. In this course^ you ll learn about the ANSI SQL functions and operators implemented by PostgreSQL and a good portion of the of those unique to this popular …

Read More
  • flag Pluralsight
  • student All Levels
  • database video
  • earth English
  • clock 2h 29m

Creating and Administering Google Cloud SQL Instances

Cloud SQL is the Google Cloud Platform s managed SQL service which offers powerful and simple RDBMS functionality. Cloud SQL supports both MySQL as well as PostgreSQL on the cloud.

Read More
  • flag Pluralsight
  • student Beginner
  • database Video
  • earth English
  • clock 1h 35m

Importing Data: Python Data Playbook

In order to work with data in Python^ you need to know how to get data into Python. This playbook defines data import recipes for common data import problems you’ll encounter using Python.

Read More