YoVDO

Get Started With PostgreSQL

Offered By: egghead.io

Tags

PostgreSQL Courses SQL Courses Data Filtering Courses Data Integrity Courses Data Manipulation Courses Data Aggregation Courses

Course Description

Overview

It’s amazing how much you can accomplish with a basic knowledge of SQL. In this course we’ll learn how to store lots of information (many millions of things!) and answer nearly any question we might have about that information (on the order of milliseconds!)
We’ll learn enough to make you say you “know SQL” -- table creation, inserts, selects, updates, deletes, aggregations, indexes, joins, and constraints. Along the way we’ll model real world problems so that you can see just how powerful SQL will make you!
If you’re interested in the Postgres client that is used in this course you can download it here to check it out and follow along.

Syllabus

  • Create a Postgres Table
  • Insert Data into Postgres Tables
  • Filter Data in a Postgres Table with Query Statements
  • Update Data in Postgres
  • Delete Postgres Records
  • Group and Aggregate Data in Postgres
  • Sort Postgres Tables
  • Ensure Uniqueness in Postgres
  • Use Foreign Keys to Ensure Data Integrity in Postgres
  • Create Foreign Keys Across Multiple Fields in Postgres
  • Enforce Custom Logic with Check Constraints in Postgres
  • Speed Up Postgres Queries with Indexes
  • Find Intersecting Data with Postgres’ Inner Join
  • Select Distinct Data in Postgres

Taught by

Brett Cassette

Related Courses

Introduction to Databases
Meta via Coursera
Analyzing Big Data with SQL
Cloudera via Coursera
Managing Google Workspace 日本語版
Google Cloud via Coursera
Creating Advanced Reports with SAS Visual Analytics
SAS via Coursera
Query Client Data with LibreOffice Base
Coursera Project Network via Coursera