Course Introduction

First Steps

Installation & Setup

Introduction to DBMS

Components of DBMS and Architecture

Relational Database and Terminologies involved in it

Basic operations with SQL

SQL Constraints

Working with Relations

Fetching Data

Fetching Specific Data

Untitled item

SQL Joins

Combining Queries and Result Sets

Dealing with Sub Queries

Conditional Expressions

Users and Roles

Database Views

Transactions in Database

Functions or Stored Procedures

Triggers

Schema Objects Walk through

Database Objects Walk through

DDL, DML, DCL, TCL, and Postgres Commands

PgAdmin Components and Help resources

Designing a database and good practices!

Next Steps!

Learn PostgreSQL, PGAdmin & SQL to build data persistent applications 

This course serves as a comprehensive guide to PostgreSQL, one of the most popular Open Source Relational Databases, used globally for enterprise applications.
PostgreSQL continues to be the go-to choice for its exceptional performance, compliance with standards, and massive scalability, and our course assumes you are just starting out. So, don&#x27;t worry if you&#x27;re confused about what a Database is or have no prior knowledge of RDBMS. Hop in, and we&#x27;ll explore these topics together.
During the course, we&#x27;ll closely look at PostgreSQL. This advanced technology is favored for its data handling capabilities, analytical prowess, and encompassing language support, from Java and Python to Perl and Ruby. Its unique offerings, such as NoSQL features, cloud infrastructure support, and SSL-enabled security, make PostgreSQL stand out.
On this learning journey with us, you&#x27;ll not only master the principles, workings, and effective usage of PostgreSQL but also dive into PGadmin, an essential tool for Database Administrators. You will also get your hands dirty with &#x27;SQL&#x27; and writing queries the dedicated language to communicate with the Database.

More than a decade long experience in the IT industry, working with mission critical systems across a wide range of industries including telecommunications, financial services, banking, etc. My experience mostly circled around Java, Spring, Cloud and other related technologies. I have worked as a senior software engineer, Module lead, technology analyst, technology specialist in various reputed multinational corporations. Above all, I am currently pursuing my passion of teaching/consulting.

Karthikeya t

Learn Git and GitHub

10x Productivity - Supercharge Your Productivity

AWS Guide for Beginners

PostgreSQL for Beginners

this course is really helpful but then why is linux users left out ?? or are windows users paying a different price , it's just not fair

Samuel Emmanuel

unlike the mehul javascript course its way better
good job!


Yashwanth sai

Pranshu Basak

Certificate Details

PostgreSQL for Beginners

Course Goals

Karthikeya t