Development
Databases
PostgreSQL
Up and Running With PostgreSQL 11
4.2 (159 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,457 students enrolled

Up and Running With PostgreSQL 11

The Modern and Most Used Relational Database
4.2 (159 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,457 students enrolled
Created by Nelson Jamal
Last updated 5/2019
English
English [Auto-generated]
Preview this course
Up and Running With PostgreSQL 11
Current price: $51.99 Original price: $74.99 Discount: 31% off
5 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • What PostgreSQL is
  • SQL
  • SQL Joins and Relationships
  • Aggregate Data
  • Work with SQL Dates
  • Database Constraints
  • How Sequence data type works internally
  • CRUD Operations
  • SQL Error Handling
  • Create and Connect To Database
  • The Right Way To Create Tables
  • Export Query Results to CSV File
  • SQL Arithmetic Operators
  • Data Types
Course content
Expand all 60 lectures 04:14:21
+ – Introduction
8 lectures 24:33
Welcome
Preview 01:26
What is a database
Preview 02:03
SQL and Relational Databases
Preview 03:53
What is PostreSQL AKA Postrgres
01:39
Postgres Installation (MAC OS)
Preview 03:31
Postgres Installation (Windows)
03:20
Setting up PSQL (MAC OS)
03:42
Setting up PSQL (Windows)
04:59
+ – Creating databases and tables
6 lectures 26:11
Creating a database
03:23
Connecting to databases
04:38
A very dangerous command
03:28
Create table syntax + Datatypes
04:13
Create Table Without Constraints
03:35
Create Table With Constraints
06:54
+ – Insert and Querying records
6 lectures 26:17
How to Insert Data (Keynote)
03:15
Insert Into
03:26
Select From
02:54
Inserting One Thousand Records
09:56
Sorting
04:37
Removing Duplicates with Distinct Keyword
02:09
+ – Filtering Data
6 lectures 21:34
Where and And
03:32
Comparison Operators
04:02
Limit, Offset and Fetch
03:15
In keyword
03:01
Between Keyword
02:06
Like and ILike
05:38
+ – Grouping Data
5 lectures 19:00
Group By
03:31
Having
05:31
Adding a second table
03:38
Min, Max and Avg
04:13
Sum
02:07
+ – Operators
3 lectures 10:44
Arithmetic Operators
04:08
Arithmetic Operators On Tables
03:44
Aliases
02:52
+ – Handing Nulls
2 lectures 07:54
Coalesce
03:44
Handle Division by 0 with NULL IF
04:10
+ – Working with Dates
4 lectures 09:21
Timestamp and Date
03:07
Adding and Subtracting Dates With INTERVAL
02:43
Extracting Fields From TIMESTAMP
01:30
Age Function
02:01
+ – PostgreSQL Constraints
5 lectures 25:40
Primary Keys
02:01
Understanding primary keys and Dropping PK Constraint
05:10
Adding Primary Constraint
04:36
Unique Constraints
08:20
Check Constraints
05:33
+ – Modifying Data
4 lectures 22:07
Deleting Records
06:51
Updating Records
04:23
On Conflict Do Nothing
05:16
Upsert (On Conflict Do Update)
05:37
Requirements
  • Be able to use computer
Description

Overview

PostgreSQL is a general purpose and object-relational database management system, the most advanced open source database system widely used to build back end systems.

Startups including big companies such as Apple, Cisco, Redhat and more use Postgres to drive their business.

The Goal of this course is to help anyone to become familiar with Relational Databases and learn most common used SQL statements, allowing you execute queries agains any relational database.


Course Road Map

  • Introduction to PostgreSQL

  • Setup your environment and get ready to start coding for both MacOS and Windows

  • Create, Read, Update & Delete (CRUD) commands

  • Learn about different ways of filtering data using where clause

  • Work with Date and Timestamps

  • Lean how to to Join and Left Join to combine data from one more tables

  • Postgres extensions and how sequences are managed

  • Learn how to create tables with the right constraints

  • Learn how to export data to CSV files

  • Congratulations. You will be ready to right SQL and have a great understanding of Postgres database

Let's get started now

Who this course is for:
  • Passionate student who want to learn about databases