+91 (8355) 946 930

Discovering   Possibilities

What you'll be learning

  • Installing and configuring the PostgreSQL   database
  • Fundamental of Structured Query Language(SQL) 
  • SQL query building
  • Usae PgAdmin tool
  • Data Types
  • Database Clustering
  • Query Optimizing
  • Triggers, PL/PGSQL
  • Performance tuning 
  • Security of Databases
  • Test and troubleshoot PostgreSQL.

PostgreSQL Course Content

  • Introduction to Databases - RDBMS concepts
  • Installation of PostgreSQL Servers.
  • Connecting to PostgreSQL database - locally, remotely
  • Fundamental SQL Commands, Schemas,
  • Data Types
  • Creating Databases and Tables
  • CRUD operations
  • PostgreSQL Server Administration
  • PostgreSQL programs and Utilities
  • Functions and Operators, Transactions
  • Schemas 
  • Backup and Recovery
  • Optimization
  • Replication, Partitioning
  • PostgreSQL Clustering
  • PostgreSQL Replication
  • Security of postgres servers.
Contact Us