Course Features
Free Demo Classes
Placement Training
Updated Syllabus
Doubt Resolution
Fasttrack Training
Affordable Price
PostgreSQL Training
Technology Training
PostgreSQL is an open source database management system. It supports both SQL for relational and JSON for non-relational queries . It is more suited for Data Warehousing and data analysis applications which need fast read-write speeds.Our course will teach you this complex system in the easiest of ways. It will start with basic intro to RDBMS system with a emphasis on PostgreSQL.By the end of this course you will be able to understand Use PostgreSQL in your projects,Understand the important features of Postgres and Understand the Object Relational model.
Syllabus
- PostgreSQL Administration Tools
- PostgreSQL Database Objects
- PostgreSQL Database Drivers
- Configuration Files in PostgreSQL
- Managing Connections
- Roles in PostgreSQL
- Extensions
- Backup and Restore
- PostgreSQL Tablespace
- Environment Variables
- Interactive versus Non Interactive psql
- psql Customizations
- psql Gems
- Importing and Exporting Data
- pgAdmin Features
- pgScript
- Graphical Explain
- Job Scheduling with pgAgent
- Numerics
- Textuals
- Temporals
- Arrays
- Range Types
- JSON
- XML
- Full Text Search
- Custom and Composite Data Types
- Basic Table Creation
- Inherited Tables
- Partitioned Tables
- Unlogged Tables
- TYPE OF
- Foreign Key Constraints
- Unique Constraints
- Check Constraints
- Exclusion Constraints
- PostgreSQL Stock Indexes
- Operator Classes
- Functional Indexes
- Partial Indexes
- Multicolumn Indexes
- Views
- Constructions
- Functions
- Common Table Expressions
- Lateral Joins
- Function Basics
- Triggers and Trigger Functions
- Aggregates
- writing
- function SQL, PL / pgSQL, PL / Python etc
- Parallelized Queries
- Query Planner
- Replication Overview
- Setting Up Full Server Replication
- Foreign Data Wrappers
Feel Free To Contact TutorsBot
For Queries & Other Support