4.2 out of 5
4.2
17 reviews on Udemy

PostgreSQL and PGadmin Tutorial + Mini Project!

PostgreSQL and PGAdmin for Beginners
You will gain confidence in using PostgreSQL for your projects
You will learn how to integrate application logic with PostgreSQL and interact with it.
You will learn PdAdmin features like Stored Procedures, Triggers, Views, User roles, etc
You will learn how the request flows in an MVC Architecture and perform CRUD Operations
You will learn the most frequently used SQL queries
You will learn how to design a Database for a given use case
You will gain confidence to attend Interviews related to PostgreSQL and SQL

PostgreSQL is the most advanced and the most popular Open Source Relational Database used in the industry for enterprise applications. Postgresql is known for it’s standard compliance (ACID compliant), and ensures great reliability, robustness, and  performance, even with large set of concurrent users.

PostgreSQL works fine with all modern web frameworks including but not limited to,: Django (Python), node.js (JavaScript), Hibernate (Java), Ruby on rails, PHP, and many more. Due to PostgreSQL’s robustness and replication capabilities, websites can easily be scaled out to as many database servers as you need.

It has wonderful analytical capabilities and offers a powerful SQL engine, which makes processing large amounts of data in efficient manner.

Why PostgreSQL?

Posrgresql offer,

  • Better standard compliance to ACID properties

  • Better performance for read and write operations (Crucial for performing Data Analysis and Data Warehousing)

  • Better performance in handling complex queries

  • Better security with builtin SSL Support and communication is encrypted

  • Great support for cloud infrastructures like AWS, Microsoft Azure, etc

  • Supports NoSQL Features

  • Supports a wide range of programming languages (C, C++, Java, Python, Java Script, R, Perl, Ruby, etc..)

  • Offers rich set of features for administration

  • Zero downtime upgrades

Why this course?

This course will start with an assumption that you don’t know anything about Database. We will start, right form the very basic question, “What is Database?” to more and more advanced concepts (refer course content below). In short, if you want to learn PostgreSQL and you don’t even have knowledge on RDBMS, then you are in the right place! You will love this course.

Here are some organic reviews I received from students who took this course,

“This is another excellent course in the database with this tutor. I am now some part of the course and it is very engaging.”

“This course is well organized and clear explanation. No unnecessary junk, just the right content!”

“I recommend this course to anyone who want to get started with postgresql. The instructor is knowledgeable and knows his stuff well. The mini project in the end is useful”

Apart from PostgreSQL, You will learn about ‘PGadmin‘ which is administrative tool for Database Administrators. You will learn ‘SQL‘ (Postgresql specific) which is a language to communicate with the Database. You will learn about ‘JDBC‘ with is essentially a glue code, that will enable your application to interact with the Database.

We are also going to create a CRUD Application by combining all the components. We will follow the MVC design pattern to do so.

I have over 11 Years of corporate experience in creating enterprise Java applications and been teaching online/offline for over 6 years. I’ve contributed to many ambitious projects in the industry. Although, I did not work as a Database Administrator specifically, I have used PostgreSQL as the Database solution for the projects I worked on. I have great exposure to the entire stack of Java technologies and in this course, I will fill the gaps related to the Database and specifically PostgreSQL.

High Level Course Content

Introduction to the course

  • Components of DBMS and its architecture

  • RDBMS terminologies

  • Structured Query Language with PostgreSQL

  • Basic Operations

  • SQL Constraints

  • Working with Relations

  • Fetching Data

  • SQL Joins

  • Queries and Result Sets

  • Sub Queries

  • DBMS through PostgreSQL and PgAdmin

  • PostgreSQL Users and Roles

  • Database Views

  • Transactions

  • PgAdmin Stored Procedures

  • Triggers

  • Schema Objects

  • DDL, DML, DCL, TCL, and Postgres Commands

  • PgAdmin Components

  • Designing a database and good practices!

  • MVC Architecture and Mini Project

I hope to see you there!

Introduction

1
Course Intro

Getting Started

1
Introduction
2
Installation and setup
3
Rough look at servlet-JDBC-Database
4
Free Educational Videos / Join other learners / be part of discussions

Database Management System

1
Introduction to DBMS
2
A Friendly Note! :D
3
Components of DBMS and Architecture
4
Relational Database and Terminologies involved in it

Structured Query Language with PostgreSQL

1
Basic operations with SQL
2
SQL Constraints
3
Working with Relations
4
Fetching Data
5
Fetching Specific Data
6
SQL Joins
7
Combining Queries and Result Sets
8
Dealing with Sub Queries
9
Conditional Expressions

Database Management through PostgreSQL and PgAdmin

1
Users and Roles
2
Database Views
3
Transactions in Database
4
Functions or Stored Procedures
5
Triggers
6
Schema Objects Walk through
7
Database Objects Walk through
8
DDL, DML, DCL, TCL, and Postgres Commands
9
PgAdmin Components and Help resources
10
Designing a database and good practices!

MVC Architecture and Mini Project

1
Java Database Connectivity (Revamp)
2
MVC Architecture
3
Mini Project Part1
4
Mini Project Part2

Final Words

1
Final Words and a Good Bye!

[Bonus] Here is what you should do next..

1
[Bonus] Here is what you should do next..
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.2
4.2 out of 5
17 Ratings

Detailed Rating

Stars 5
7
Stars 4
7
Stars 3
3
Stars 2
0
Stars 1
0
6ef2ec556847b644daf6886f60f4f8a9
30-Day Money-Back Guarantee

Includes

5 hours on-demand video
3 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion