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

Learn Database Administration - PostgreSQL Database Administration (DBA) for Beginners

In this video, 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 joining tables to retrieve data and much more.

The course also covers the basics of creating tables, storing data with data types, and working with expressions, operators, and strings.

Topics also includes:

Installing PostgreSQL

Loading sample database

Creating database and tables

Performing CRUD operations

Joining Tables

Using aggregate and analytic functions

Creating views and triggers

What you’ll learn

Install PostgreSQL Server

Load sample database

Create a database

Create a table

Insert data into tables

Update existing records inside a table

Delete Records in a table

Remove duplicate records

Query data from a table

Create a subquery

Get data from multiple tables

Create and manage roles

Create a view

Create tablespace

Backup and restore database

Filter and sort data

Use various operators

Use aggregate and analytic functions

Create triggers

Thanks for reading

If you liked this post, share it with all of your programming buddies!

Follow us on Facebook | Twitter

The Complete SQL Bootcamp

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

An Introduction to Queries in PostgreSQL

Build a Basic App with Spring Boot and JPA using PostgreSQL

Why We Moved From NoSQL MongoDB to PostgreSQL?

Learn to Build SQL Query| Ultimate SQL and DataBase Concepts|Simpliv

Learn to Build SQL Query| Ultimate SQL and DataBase Concepts|Simpliv

Learn to Build SQL Query| Ultimate SQL and DataBase Concepts

Description
SQL developers are earning higher salary in IT industry, but, its not about writing queries its about understanding and applying the right query at right time and this course will let you understand complex SQL Statements in an easy way .

Moreover, This Course will teach you how to extract Data from Database and write complex queries to a database This course will focus on a wider scale by Covering Structure Query Language SQL concepts as a whole, whether Students work with MySQL, Microsoft SQL Server, Oracle Server, etc.

This course have 5 Chapters in which you will learn

Chapter 1 Fundamentals

Fundamentals
Building Blocks
Selecting Records from DB
Working with Arithmetic Expressions
Chapter 2 Conditioning Sorting and Operators

Logical Operators
Comparison Operators
Operator Precedence
Sorting Results
Chapter 3 Functions

Character Functions
Number Functions
Date Functions
Conversions
General Purpose Functions
Nesting Functions
Chapter 4 Grouping

Multiple Row Functions on a single Table
Multiple Row Functions on Many Table
Chapter 5 Joins

Understanding Primary Key
Understanding Foreign Key
Understanding Need of Joins
Cartesian Product
Equie Join Simple Join Self Join
Non Equie Join
Outer Join
Self Join
Course is Designed for College and University Students who want Solid SQL and Data Base Concepts in a short period of time.

Who this course is for:

Beginners
University or College students
Anyone who wants Solid SQL Concepts
Basic knowledge
No prior knowledge is required
PC or MAC
What will you learn
SQL Fundamentals
Understand Complex SQL Concepts in Easy way using daily life examples
Construct SQL Statements
Use SQL to retrieve data from database
Selecting Data From Database
Restricting and Sorting Data from DB
Grouping Data From DB
Construct SQL statements that will let them work with more than two tables
Use SQL Functions
Work with SQL Operators and find out precedence
Nesting in SQL
Joins
To continue:

What is CRUD? | CRUD Operations with SQL and PostgreSQL

What is CRUD? | CRUD Operations with SQL and PostgreSQL

What is CRUD? | CRUD Operations with SQL and PostgreSQL - In this course we will be using SQL and PostgreSQL to perform CRUD operations

In this course we will be using SQL and PostgreSQL to perform CRUD operations

PostgreSQL is a very popular , advanced, open-source object-relational database management system used by a lot of organizations. It is a very robust database management system.

Any software or a web application will typically do these set of operations called C.R.U.D.

CRUD Stands for:

  • Create (Insert)
  • Read (Select)
  • Update
  • Delete

What we will learn include:

  • How to install PostgreSQL Database Server
  • How to Load a sample database into PostgreSQL Server
  • How to Create a database and table
  • How to insert data into a table
  • How to query and retrieve data from a table
  • How to update existing data inside a table
  • How to delete data from a table
  • How to sort retrieved data from a table
  • How to Filter data using WHERE clause
  • How to remove duplicate data
  • How to use subqueries to query and retrieve data
  • How to group data using GROUP BY clause
  • How to use the HAVING clause to group data

Thanks for reading

If you liked this post, share it with all of your programming buddies!

Follow us on Facebook | Twitter

Further reading about CRUD, SQL and PostgreSQL

How to build a CRUD Web App with Angular 8.0

Laravel 5.8 CRUD Tutorial With Example Step By Step

MEAN Stack Angular 8 CRUD Web Application

Build a Basic CRUD App with Node and React

Learn Database Administration - PostgreSQL Database Administration (DBA) for Beginners

How to write SQL queries in PostgreSQL