Learn PostgreSQL Tutorial - Full Course for Beginners

freeCodeCamp.org April 4, 2019
Video Thumbnail

About

No channel description available.

Latest Posts

No results found. Try different keywords.

Video Description

Learn how to use PostgreSQL in this full course. PostgreSQL is a general purpose and object-relational database management system. It is the most advanced open source database system widely used to build back-end systems. ❤️ Try interactive Databases courses we love, right in your browser: https://scrimba.com/freeCodeCamp-Databases (Made possible by a grant from our friends at Scrimba) ⭐️ Contents ⭐️ ⌨️ (0:03:16) What is a Database ⌨️ (0:05:17) What is SQL And Relational Database ⌨️ (0:09:10) What is PostreSQL AKA Postrgres ⌨️ (0:10:53) PostgreSQL Installation (Mac OS) ⌨️ (0:14:21) PostgreSQL Installation (Windows) ⌨️ (0:17:38) GUI Clients vs Terminal/CMD Clients ⌨️ (0:21:39) Setup PSQL (MAC OS) ⌨️ (0:25:22) Setup PSQL (Windows) ⌨️ (0:30:15) How to Create Database ⌨️ (0:33:35) How to Connect to Databases ⌨️ (0:38:12) A Very Dangerous Command ⌨️ (0:41:37) How To Create Tables ⌨️ (0:45:46) Creating Tables Without Constraints ⌨️ (0:49:12) Creating Tables with Constraints ⌨️ (0:55:55) Insert Into ⌨️ (0:59:14) Insert Into Example ⌨️ (1:02:36) Generate 1000 Rows with Mockaroo ⌨️ (1:12:28) Select From ⌨️ (1:15:18) Order By ⌨️ (1:19:53) Distinct ⌨️ (1:21:59) Where Clause and AND ⌨️ (1:25:29) Comparison Operators ⌨️ (1:29:35) Limit, Offset & Fetch ⌨️ (1:32:43) IN ⌨️ (1:35:43) Between ⌨️ (1:37:45) Like And iLike ⌨️ (1:43:10) Group By ⌨️ (1:46:41) Group By Having ⌨️ (1:52:08) Adding New Table And Data Using Mockaroo ⌨️ (1:55:40) Calculating Min, Max & Average ⌨️ (1:59:48) Sum ⌨️ (2:01:55) Basics of Arithmetic Operators ⌨️ (2:05:59) Arithmetic Operators (ROUND) ⌨️ (2:09:43) Alias ⌨️ (2:12:32) Coalesce ⌨️ (2:16:15) NULLIF ⌨️ (2:20:21) Timestamps And Dates Course ⌨️ (2:23:21) Adding And Subtracting With Dates ⌨️ (2:25:58) Extracting Fields From Timestamp ⌨️ (2:27:28) Age Function ⌨️ (2:29:24) What Are Primary Keys ⌨️ (2:31:23) Understanding Primary Keys ⌨️ (2:36:26) Adding Primary Key ⌨️ (2:40:55) Unique Constraints ⌨️ (2:49:15) Check Constraints ⌨️ (2:54:45) How to Delete Records ⌨️ (3:01:36) How to Update Records ⌨️ (3:05:55) On Conflict Do Nothing ⌨️ (3:11:09) Upsert ⌨️ (3:16:41) What Is A Relationship/Foreign Keys ⌨️ (3:19:48) Adding Relationship Between Tables ⌨️ (3:25:04) Updating Foreign Keys Columns ⌨️ (3:29:30) Inner Joins ⌨️ (3:35:17) Left Joins ⌨️ (3:40:53) Deleting Records With Foreign Keys ⌨️ (3:47:27) Exporting Query Results to CSV ⌨️ (3:50:42) Serial & Sequences ⌨️ (3:57:18) Extensions ⌨️ (3:59:39) Understanding UUID Data Type ⌨️ (4:05:54) UUID As Primary Keys ⌨️ (4:16:30) Conclusion ✏️ Course from Amigoscode. 🔗 Subscribe to Amigoscode YouTube channel | http://bit.ly/2HpF5V8 🔗 Visit Amigoscode.com for more courses | http://bit.ly/2JgGW0w 🔗 Full Playlist Available Here | http://bit.ly/2ClGPdY 🔗 Follow Amigoscode on Instagram | http://bit.ly/2TSkA9w 🔗 Join Amigoscode Closed Facebook Group | http://bit.ly/2FbuIkx -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://medium.freecodecamp.org And subscribe for new videos on technology: https://youtube.com/subscription_center?add_user=freecodecamp

You May Also Like

Upgrade Your Camera Gear

AI-recommended products based on this video

Loading...
COTUBLR 31 Inch Computer Desk, Home Office Desk, Simple Modern Small Desk for Bedroom, Writing Desk with Storage Bag, Study Table for Students, Grey Oak

COTUBLR 31 Inch Computer Desk, Home Office Desk, Simple Modern Small Desk for Bedroom, Writing Desk with Storage Bag, Study Table for Students, Grey Oak

(180)
$64.99
FREE delivery Thu, Jun 26
Loading...
ESR for iPhone 16 Pro Max Case, Camera Control Capture Button, Compatible with MagSafe, Shockproof Military-Grade Protection, Phone Case for iPhone 16 Pro Max, Classic Hybrid Case(HaloLock), Clear

ESR for iPhone 16 Pro Max Case, Camera Control Capture Button, Compatible with MagSafe, Shockproof Military-Grade Protection, Phone Case for iPhone 16 Pro Max, Classic Hybrid Case(HaloLock), Clear

(87,497)
$11.99$10.96
FREE delivery Sat, Sep 20 on your first order
500+ bought in past month
Loading...
ESR for iPhone 16 Pro Case, Camera Control, Compatible with MagSafe, Shockproof Military-Grade Protection, Magnetic Phone Case for iPhone 16 Pro, Classic Hybrid Case (HaloLock), Clear

ESR for iPhone 16 Pro Case, Camera Control, Compatible with MagSafe, Shockproof Military-Grade Protection, Magnetic Phone Case for iPhone 16 Pro, Classic Hybrid Case (HaloLock), Clear

(71,292)
$15.99$10.06
FREE delivery Sat, Jun 14 on your first order
500+ bought in past month
Loading...
INGIDO for iPhone 16 Pro Case, Liquid Silicone Case with Camera Protection Soft Gel Rubber Cover with Microfiber Lining Shockproof Protective Phone Case for iPhone 16 Pro 6.3", Stone

INGIDO for iPhone 16 Pro Case, Liquid Silicone Case with Camera Protection Soft Gel Rubber Cover with Microfiber Lining Shockproof Protective Phone Case for iPhone 16 Pro 6.3", Stone

(203)
$18.59
FREE delivery Sat, Jun 14 on your first order
50+ bought in past month
Loading...
TOCOL Magnetic for iPhone 15 Case, Upgraded Full Camera Protection, Fit for MagSafe, Rugged Phone Case for iPhone 15 6.1 Inch, Drop Protection, Anti-Scratch, Black Global Recycled Standard

TOCOL Magnetic for iPhone 15 Case, Upgraded Full Camera Protection, Fit for MagSafe, Rugged Phone Case for iPhone 15 6.1 Inch, Drop Protection, Anti-Scratch, Black Global Recycled Standard

(26,701)
$10.79
FREE delivery Sat, Sep 20 on your first order
500+ bought in past month
Loading...
NEEWER Zf Handgrip L Shape Grip for Nikon Z f, Ultra Thin Retro Formfitting Camera Mounting Baseplate with Handle & Aluminum Shutter Button Cap, Compatible with Arca Swiss Tripod Fluid Head, CA073

NEEWER Zf Handgrip L Shape Grip for Nikon Z f, Ultra Thin Retro Formfitting Camera Mounting Baseplate with Handle & Aluminum Shutter Button Cap, Compatible with Arca Swiss Tripod Fluid Head, CA073

(236)
$33.99
FREE delivery Thu, Jun 19 on your first order
Loading...
Digital Camera,3in LCD Screen Portable Camera,18X Zoom HD SLR Long Focal Length Camera with Large Capacity Battery for Photography (Standard Type)

Digital Camera,3in LCD Screen Portable Camera,18X Zoom HD SLR Long Focal Length Camera with Large Capacity Battery for Photography (Standard Type)

(3)
$56.76
FREE delivery Aug 27 - Sep 18
Loading...
Rib Prep Pro Stainless Steel Rib Membrane Remover Tool, Professional BBQ Rib Skinner and Catfish Skinner Pliers, Kitchen/Grill Gadget Kit for BBQ Rib Prep, Dishwasher Safe BBQ Accessory

Rib Prep Pro Stainless Steel Rib Membrane Remover Tool, Professional BBQ Rib Skinner and Catfish Skinner Pliers, Kitchen/Grill Gadget Kit for BBQ Rib Prep, Dishwasher Safe BBQ Accessory

(0)
$18.99
$5.99 delivery Jul 2 - 22
Loading...
KLONA Handheld Steam Cleaner, Steam Cleaner for Home with 10 Accessory Kit, Multipurpose Portable Upholstery Steamer Cleaning with Safety Lock to Remove Grime, Grease.

KLONA Handheld Steam Cleaner, Steam Cleaner for Home with 10 Accessory Kit, Multipurpose Portable Upholstery Steamer Cleaning with Safety Lock to Remove Grime, Grease.

(67)
$52.99
FREE delivery Sun, Mar 22
Loading...
Portable Steam Cleaner, Hand Held steamers for cleaning house, Home Multi Purpose-10-Piece Accessory Kit for Sofa,Carpets,Upholstery,Car,Floor,Bathroom,Mattress and More

Portable Steam Cleaner, Hand Held steamers for cleaning house, Home Multi Purpose-10-Piece Accessory Kit for Sofa,Carpets,Upholstery,Car,Floor,Bathroom,Mattress and More

(145)
$52.99
FREE delivery Wed, Jan 7
Loading...
KLONA Handheld Steam Cleaner, Steam Cleaner for Home with 10 Accessory Kit, Multipurpose Portable Upholstery Steamer Cleaning with Safety Lock to Remove Grime, Grease, and More

KLONA Handheld Steam Cleaner, Steam Cleaner for Home with 10 Accessory Kit, Multipurpose Portable Upholstery Steamer Cleaning with Safety Lock to Remove Grime, Grease, and More

(51)
$49.99
FREE delivery Mon, Jun 16
400+ bought in past month
Loading...
NEEWER Advanced 18 inch LED Ring Light for Phone, LCD Touch Screen, 2.4G Remote Lights Control, 3200-5600K, Tripod Light for iPhone Action Camera, for Studio Makeup TikTok YouTube Video Salon (Black)

NEEWER Advanced 18 inch LED Ring Light for Phone, LCD Touch Screen, 2.4G Remote Lights Control, 3200-5600K, Tripod Light for iPhone Action Camera, for Studio Makeup TikTok YouTube Video Salon (Black)

(2,807)
$181.49
FREE delivery Sun, Aug 10
Loading...
NEEWER a6700 L Plate Compatible with Sony Alpha 6700, Quick Switch Aluminum Extendable Side Plate & Anti Twist Baseplate Compatible with Arca Swiss QR System DJI RS 2 RSC 2 RS 3 Pro Gimbals, CA048

NEEWER a6700 L Plate Compatible with Sony Alpha 6700, Quick Switch Aluminum Extendable Side Plate & Anti Twist Baseplate Compatible with Arca Swiss QR System DJI RS 2 RSC 2 RS 3 Pro Gimbals, CA048

(24)
$25.99
FREE delivery Thu, Jun 19 on your first order
Loading...
SmallRig ZV-E10 II Base Plate for Sony Alpha ZV-E10 II, Bottom Mount Plate with Quick-Release Plate for Arca, QD Socket, Hand Strap Hole, 1/4"-20 Threaded Hole - 4950

SmallRig ZV-E10 II Base Plate for Sony Alpha ZV-E10 II, Bottom Mount Plate with Quick-Release Plate for Arca, QD Socket, Hand Strap Hole, 1/4"-20 Threaded Hole - 4950

(13)
$37.99
FREE delivery Sat, Jun 21
Loading...
SmallRig Baseplate for Sony Alpha 6700, Bottom Mount Plate Built-in Quick Release Plate for Arca, Supporting Quick Switch Between Tripod and Stabilizer (for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro) - 4338

SmallRig Baseplate for Sony Alpha 6700, Bottom Mount Plate Built-in Quick Release Plate for Arca, Supporting Quick Switch Between Tripod and Stabilizer (for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro) - 4338

(85)
$38.24
FREE delivery Thu, Jun 19