All Courses Introduction To Relational Databases Using Postgres
Introduction To Relational Databases Using Postgres
In this course, you will embark on a journey that will take you from the fundamental concepts of relational databases to becoming a proficient Postgres practitioner. Whether you are a beginner looking to establish a solid foundation in database management and understand the significance of writing queries in a relational database
Instructors:
S Soumen
You have opted to be notified for this course. You will receive an email when the course becomes available.
0 Enrolled
26 Lessons

In the following course, we will learn about the following concepts:

  1. Database Fundamentals: 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.
  2. PostgreSQL Installation and Setup: You'll learn how to install and configure PostgreSQL, making your first steps into the world of this powerful database system.
  3. Data Modeling: We'll delve into designing efficient database schemas, normalizing data, and creating relationships that ensure data integrity.
  4. SQL Mastery: You'll become proficient in Structured Query Language (SQL), used to interact with PostgreSQL. From basic queries to advanced operations, you'll be well-versed in SQL.
  5. Indexing and Optimization: Discover how to optimize your database for performance, including indexing strategies and query optimization techniques.
Course Content
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