Course Highlights
  • Government certification
  • Certification valid for life
  • Lifelong e-learning access
  • Learning Hours: 12 hrs
  • Life Time Job Support
  • Job Profile Tagging
Curriculum

14 Topics
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

6 Topics
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

4 Topics
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

4 Topics
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

4 Topics
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

4 Topics
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

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

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

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

  Write a Review

Certified PostgreSQL Professional

Go to Paid Course