off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

Beginner's Guide to PostgreSQL

Nail Down the Basics of Database Concepts on Your Road to PostgreSQL Enlightenment

What's Inside

With an ever-increasing focus on big data and cloud-based initiatives, it’s time you learn to work effectively with data. Start the route to PostgreSQL expertise with this extremely approachable beginner’s guide. You’ll learn basic database concepts like creating tables and manipulating data—a great baseline to use with any modern database systems—before moving on to using the open-source relational database PostgreSQL. You’ll get all the nitty-gritty on what SQL is, and how to use it in real world applications.

Gain an understanding of database concepts w/ 70 lectures & 6 hours of instruction
Learn the written language used to communicate w/ databases
Get a step-by-step look at how a database is structured
Learn how to install PostgreSQL
Insert & manipulate data w/ PostgresSQL
Write SQL queries
Get an introduction to data w/ an approachable class meant for all levels

Course Curriculum

Introduction

An Introduction to the Course - 2:19
Start
Database Overview - 5:15
Start
Identities in database tables - 2:45
Start
Normalization - 4:10
Start
Relationships - 7:00
Start
Relationship Quiz
Start
Relationship Types - 5:47
Start
Relationship Types Quiz
Start
Database Management Systems - 3:14
Start
PostgreSQL features - 3:34
Start
PostgreSQL Windows Installation - 5:40
Start

Database Usage Basics

Connecting to Database Server with pgAdmin III - 3:30
Start
Configuring PostgreSQL to Accept External Connections - 7:29
Start
Creating Databases - 6:21
Start
Creating Tables - 6:59
Start
Inserting and viewing data in pgAdmin III - 9:46
Start
DataTypes Intro - 1:19
Start
Numeric DataTypes in PostgreSQL - 10:58
Start
Serial Datatypes For Row Ids - 4:34
Start
Character Types - 6:11
Start
The Date Datatype - 5:05
Start
The time datatype - 3:53
Start
Timestamps - 7:28
Start
The boolean datatype - 2:36
Start
NULL Values - 5:05
Start
Requirements - 2:23
Start
Car Repair Shop DB Requirements
Start
Designing the repair shop database Pt1 - 8:06
Start
Designing the repair shop database Pt2 - 4:27
Start
Designing the repair shop database Pt3 - choosing datatypes - 2:42
Start
Car Repair Shop DB Table and Column Definitions
Start
Building the Database - Part 1 - 7:25
Start
Applying constraints to table columns - 8:03
Start
Creating relationships between tables in pgAdmin III - 5:08
Start
Creating the remaining tables - 12:34
Start
Users and Privileges - 14:10
Start
Backup and Restore in PostgreSQL with pgAdmin III - 9:06
Start

SQL in PostgreSQL

Introduction to SQL - 2:49
Start
The CREATE TABLE command - 5:48
Start
The CREATE TABLE command with constraints PT 1 - 6:29
Start
The CREATE TABLE command with constraints pt.2 - 3:56
Start
Script: First Two Create Table commands
Start
The CREATE TABLE command with foreign keys PT 1 - 4:01
Start
The CREATE TABLE command with foreign keys PT 2 - 5:18
Start
Scripts: Create Tables with Foreign keys
Start
CREATE TABLE quiz
Start
Drop Table - 4:22
Start
The Alter Table command - 12:48
Start
Script: Drop And Alter Table commands
Start
Insert Into SQL Command - 9:30
Start
Insert scripts used in the previous video
Start
The Update Statement - 15:30
Start
Update Script file
Start
The DELETE FROM Statement - 5:09
Start
Deletes with cascades - 8:02
Start
Script: Delete from commands for the previous videos
Start
The TRUNCATE command - 5:08
Start
Truncate Script
Start
Filling the database with data - 4:04
Start
Full Db Script
Start
The SELECT command - 3:30
Start
pgAdmin III's Graphical Query Builder - 2:39
Start
The WHERE clause (PT I) - 4:57
Start
The WHERE clause (PT 2) - BETWEEN and IN - 4:36
Start
The WHERE clause (PT 3) - IS [NOT] NULL - 3:15
Start
The WHERE clause (PT 4) - LIKE and ILIKE - 9:32
Start
The WHERE clause - using the graphical query builder - 10:38
Start
The WHERE Clause Command Script
Start
The LIMIT and OFFSET clauses - 5:23
Start
QUIZ - Limits and Offests
Start
The ORDER BY clause - 6:57
Start
Order By commands
Start
Aggregate functions - Count, Max, Min, Avg - 11:10
Start
Joins tables in a query through relationships
Start

off original price!

The coupon code was not applied because it has already been redeemed or expired. Please click on "My Courses" to see if the course is already on your account.

Get started now!