Introduction To Relational Databases Using Postgres
We'll start with the basics, ensuring you have a clear understanding of what databases are, how they work, and the significance of relational databases in modern data management
Introduction to Databases
Evolution of Databases & Introduction to Relational Databases Using PostgreSQL
Data Modelling in Relational Database
ER model & ER Diagrams
Data Integrity & Keys in Relational Database
Normalization in Relational Database
We will use SQL for querying the database
Installing Postgres in Local System | Windows
PSQL Shell & PG ADMIN in Postgres
Creating Database in PSQL Shell | Postgres
Create Table in Postgres
CREATE Table with Some Constraints | Postgres
INSERT Data into Postgres | PSQL
SELECT & WHERE Statements + Conditional And Logical Operators | Postgres
ORDER BY in Postgres
ORDER BY in Postgres
LIMIT In Postgres
IN Operator and NOT IN Operator in Postgres
LIKE & ILIKE in Postgres
Learn about aggregation Function and JOIN queries
Aggregate Function in Postgres
Inner JOIN in Postgres
Left Join in Postgres
Right Join in Postgres
Full Outer Join In Postgres
In the following section we will learn about Views, Indexes
Views in Database
Indexes In Database
Indexing Part 2
All Courses Introduction To Relational Databases Using Postgres Indexing Part 2
Indexing Part 2
S Soumen
Oct 8, 2023

Have a doubt?
Post it here, our mentors will help you out.