PostgreSQL: Getting Started
Pluralsight
Course Summary
In this course we will go over basics of PostgreSQL, often called the world's most advanced open source database.
-
+
Course Description
PostgreSQL is commonly known as Postgres and is is often referred to as a the world's most advanced open source database. In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of join, and a few best practices.
-
+
Course Syllabus
Installation and Configuration- 24m 9s
—Getting Started 0m 34s
—PostgreSQL or Postgres 1m 17s
—A Brief History of the Name 2m 9s
—What Is PostgreSQL? 0m 56s
—PostgreSQL Important Features 2m 30s
—PostgreSQL Limits 1m 24s
—Prominent Users of PostgreSQL 1m 28s
—What Is This Course About? 1m 55s
—Important Downloads 1m 36s
—Installing PostgreSQL 3m 0s
—Loading Sample Data 5m 46s
—Summary 1m 29sPostgreSQL: Creating and Accessing Database Tables- 24m 37s
—Getting Started 0m 47s
—Scenario Setup 0m 46s
—Scenario 1: Restore Database 3m 2s
—Scenario 2: Restore Table Schema Only 3m 45s
—Scenario 3 Part 1: Copy a Single Table Schema 6m 26s
—Scenario 3 Part 2: Copy a Single Table Data 4m 57s
—Scenario 4: Generate HTML Report for Dependencies 3m 59s
—Summary 0m 52sPostgreSQL: Data Operations - Select, Update, Delete- 29m 54sPostgreSQL: Database Joins Retrieving Data From Multiple Tables- 30m 37sPostgreSQL: Summary- 3m 33s
This course is listed under
Open Source
, Development & Implementations
and Data & Information Management
Community
Related Posts: