Library

Course: Learn PostgreSQL, PgAdmin, SQL and JDBC [Combo!]

Learn PostgreSQL, PgAdmin, SQL and JDBC [Combo!]

  • Life Time Access
  • Certificate on Completion
  • Access on Android and iOS App
About this Course

This course talks about literally everything you need to know about Database.

In this course you will learn PostgreSQL which is the most popular Database used in the industry. You will learn about 'PGadmin' which is administrative tool for Database administrators. You will learn 'SQL' which is a language to communicate with Database. You will learn about 'JDBC' with is like a glue code, that will enable your application to interact with the Database.

We will also create CRUD Application

If you...

  • Don't know much about relational database (or)
  • Don't know much about PostgreSQL (or)
  • Don't know much about PgAdmin (or)
  • Don't know much about SQL (or)
  • Don't know much about JDBC (or)
  • Don't know much about MVC Design Pattern (or)
  • Don't know how the real world MVC architecture works

Then this course is for you. You will learn all the above!

Who this course is for:

  • People who want to understand Relational Database, postgreSQL, PgAdmin
  • People who want to learn SQL
  • People who want to learn real time CRUD application using Database and JDBC
  • People who want to know about MVC Architecture with a simple application
Basic knowledge
  • It would be good to have some understanding on any programming language
  • The example application was written using Java programming language. But, the essence of any programming language will remain name. If needed take a look at my awesome course on Java Programming, servelts and JSP
What you will learn
  • You will be Comfortable using PgAdmin, psql, postgresql
  • You will know how to integrate application logic with PostgreSQL and perform CRUD operations
  • You will understand real time CRUD application that follows MVC Architecture
  • You will be comfortable learning any other database apart from PostgreSQL
Curriculum
Number of Lectures: 34
Total Duration: 04:59:43
Getting Started
  • Introduction  
  • Installation and setup  
  • Rough look at servlet-JDBC-Database  
  • Free Educational Videos / Join other learners / be part of discussions  
Database Management System
  • Introduction to DBMS  
  • A Friendly Note! :D  
  • Components of DBMS and Architecture  
  • Relational Database and Terminologies involved in it  
Structured Query Language with PostgreSQL
  • Basic operations with SQL  
  • SQL Constraints  
  • Working with Relations  
  • Fetching Data  
  • Fetching Specific Data  
  • SQL Joins  
  • Combining Queries and Result Sets  
  • Dealing with Sub Queries  
  • Conditional Expressions  
  • Section - Resource files  
Database Management through PostgreSQL and PgAdmin
  • 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!  
  • Resource files  
MVC Architecture and Mini Project
  • Java Database Connectivity (Revamp)  
  • MVC Architecture  
  • Mini Project Part 1  
  • Mini Project Part 2  
  • Resource file  
Reviews (0)