PostgreSQL Table of Contents

Table of Content


Database Basics

  • Client/Server Basics
  • What is a Data?
  • What is a Database?
  • What is DBMS or Database Management System?
  • Data Models
  • Relational Theory
  • Relational Model
  • Databases and Tables
  • What is RDBMS?
  • RDBMS Architecture
  • Database Communication Protocols
  • SQL and the Relational Model
  • Relational Operations
  • SQL Evolution

PostgreSQL Basics

  • Understanding PostgreSQL and Its Uses
  • Download and Install PostgreSQL Client pgAdmin
  • Setup a Practice Database Using Referenced .tar File
  • Create Database, Table, Insert, and Query Data – Part 1
  • Create Database, Table, Insert, and Query Data – Part 2
  • PostgreSQL Relationships Using What’s Called a Primary Key and Foreign Key

PostgreSQL Data Retrieval

  • Introduction to the SELECT Statement to Retrieve Rows of Data
  • Introduction to the SELECT DISTINCT Statement
  • SELECT Statement with WHERE Clause
  • Insert Data into Tables, Update, and Delete Rows

Count Rows in PostgreSQL

  • Count All Rows Using the COUNT Function
  • Use COUNT with the DISTINCT Clause
  • Order Query Results with the ORDER BY Clause
  • Using ORDER BY with ASC and DESC Modifiers

PostgreSQL Conditional Clauses

  • Query Rows of Data Using the BETWEEN Operator
  • Introduction to NOT BETWEEN
  • Search for a Specified Pattern in a Column Using the LIKE Operator
  • Match a Value to a List of Values with the IN Operator

PostgreSQL Mathematical Operations

  • Using MIN and MAX Functions
  • Using MIN and MAX with the ROUND Function
  • Using the AVG and SUM Functions
  • Using AVG and SUM with the ROUND Function

Using Joins in PostgreSQL

  • Group Data with the GROUP BY Clause
  • The HAVING Clause
  • PostgreSQL Aliases and the LIMIT Clause
  • Exploring Inner Joins
  • Exploring Outer Joins

PostgreSQL Datatypes and Table Constraints

  • Common PostgreSQL Datatypes
  • Common PostgreSQL Constraints
  • Advanced Administration of Your Database with ALTER TABLE

PostgreSQL Administration

  • Server Configuration
  • Logging
  • Backup and Recovery
  • Client Authentication
  • Vacuuming
  • Database Roles
  • Database Monitoring

Apply Now!!

 For Support