Learn PostgreSQL - Full Course for Beginners

Learn PostgreSQL - Full Course for Beginners

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.


⭐️ 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:60) 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

Thanks for reading ❤

Follow me on Facebook | Twitter


Learn More

The Complete Python & PostgreSQL Developer Course

SQL & PostgreSQL for Beginners

An Introduction to Queries in PostgreSQL

Spring Boot with PostgreSQL, Flyway, and JSONB

Node.js - Express Persistent Session Store with PostgreSQL + Sequelize

Secure Node.js, Express.js and PostgreSQL API using Passport.js

Build a Basic App with Spring Boot and JPA using PostgreSQL

Originally published at https://www.youtube.com/watch?v=qw--VYLpxG4

sql postgresql database

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

AlaSQL in Action: The JavaScript SQL Database

Overview on AlaSQL, the popular lightweight client-side in memory SQL database, including a real life example of AlaSQL in action. I was surprised to see that there aren’t more posts about this popular lightweight client-side in-memory SQL database online apart from this awesome article I found.

Backup Database using T-SQL Statements

Introduction In this article, We will discuss how to backup our database in MS-SQL Server using T-SQL Statements. We need to use BACKUP DATABASE statement to create full database backup, along with…

Row Counts of Tables in a SQL Schema & Database - PostgreSQL and YugabyteDB

See how to get total row counts of data in tables across various dimensions (per-table, per-schema, and in a given database)–a useful SQL technique!