PostgreSQL FREE 2 Hour Course
PostgreSQL(a top open source DBMS) course for beginners to intermediate. In this video you will learn almost everything related to PostgreSQL from installation to work with Database, Tables, Schemas, Arrays, Joins and a lot more. So, we will discuss every following topic in brief detail:
0:00:00 Introduction
0:01:33 PostgreSQL vs MySQL & MongoDB
0:03:33 installing PostgreSQL
0:05:28 DDL Commands
0:06:05 Types of Keys
0:06:37 Constraints in DB
0:07:11 DML Keywords
0:07:48 Logical Operators
0:08:18 Aggregate Functions
0:08:31 Create a Database
0:08:57 List Databases
0:10:18 Connect to a Database
0:10:31 Delete/Drop Database
0:12:25 Errors in Database
0:13:23 Create Tables
0:15:10 List Tables
0:15:36 Insert Data into Tables
0:24:10 ALTER-TABLE Command
0:26:47 Delete/Drop Tables
0:27:40 Data Types
0:33:29 Add, Update, Delete User Accounts
0:38:00 Schema
0:42:45 Indexes
0:49:14 Coalesce function
0:57:45 Arrays
1:12:14 Joins
1:18:00 WHERE Clause
1:21:52 Store and Query JSON
1:36:05 LIKE Condition
1:44:37 Date, Timestamp & Time
1:52:08 UPSERT Command
1:58:58 Triggers
—————- OUR FREE COURSES —————-
**********************************************************************
C++ Data Structures and Algorithm Design Principles FREE COURSE:
https://www.youtube.com/watch?v=lF1UOAvkPnE&t=5452s
**********************************************************************
MySQL 2 Hour FREE COURSE for Beginners:
https://www.youtube.com/watch?v=Y0FrR8yWesk
**********************************************************************
Linux Mint Full Course 3 Hours:
https://www.youtube.com/watch?v=fwoHfVeBK2s&t=1217s
**********************************************************************
FREE 4 Hour Ubuntu Course for Beginners:
https://www.youtube.com/watch?v=t7uvq6z41Ro&t=344s
**********************************************************************
OpenCV 3 Hour Course:
https://www.youtube.com/watch?v=dqScBVWKOR8&t=1283s
**********************************************************************
Become a Programmer in 2 Hours:
https://www.youtube.com/watch?v=ohzXAckRr5o&t=1533s
Comments are closed.