Skip to content
Backend Development | Mastering SQL with PostgreSQL
Chapters videos
Table
Chapter Name
Exercise Name
Link
Notes
Chapter Name
Exercise Name
Link
Notes
Introduction to RDBMS
Setting Up PostgreSQL on Windows
Open
Introduction to RDBMS
Setting Up PostgreSQL on MacOS
Open
Introduction to RDBMS
Introduction to RDBMS
Open
Introduction to RDBMS
Introduction to SQL
Open
Fundamentals of PSQL
Database Overview
Open
Fundamentals of PSQL
Basic PSQL Commands
Open
Fundamentals of PSQL
Fetching Results using SELECT statement
Open
Fundamentals of PSQL
DISTINCT & COUNT
Open
Fundamentals of PSQL
WHERE clause
Open
Fundamentals of PSQL
AND OR operator
Open
Fundamentals of PSQL
Between and IN Operator
Open
Fundamentals of PSQL
Wild Card and Order By
Open
Fundamentals of PSQL
Using GUI client
Open
SQL Aggregations & Joins
Understanding Level of Data
Open
SQL Aggregations & Joins
Aggregation Functions in SQL
Open
SQL Aggregations & Joins
Changing Level of Data using Aggregation
Open
SQL Aggregations & Joins
Aggregation using Group By and Having Keywords
Open
SQL Aggregations & Joins
Inner Join
Open
SQL Aggregations & Joins
Left Join
Open
SQL Aggregations & Joins
Full Outer Join
Open
SQL Aggregations & Joins
Cross Join
Open
SQL Aggregations & Joins
Union and Union ALL
Open
Database and Table Management
Understanding Data Types
Open
Database and Table Management
Primary and Foreign Key
Open
Database and Table Management
Create, Update & Delete Operations
Open
Database and Table Management
Constraints functions
Open
Database and Table Management
Alter & Truncate
Open
Database and Table Management
Creating Views & Views using SQL queries
Open
Database and Table Management
Creating Database in Dbeaver
Open
Schema Design and Transaction Management
Indexes in SQL
Open
Schema Design and Transaction Management
Handling Transactions and Rollbacks
Open
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.