PostgreSQL Training - Tutorsbot

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.

Course Features

Free Demo Classes

Placement Training

Updated Syllabus

Doubt Resolution

Fasttrack Training

Affordable Price

Syllabus

Basics of PostgreSQL

  • PostgreSQL Administration Tools
  • PostgreSQL Database Objects
  • PostgreSQL Database Drivers

Database Administration Tools

  • Configuration Files in PostgreSQL
  • Managing Connections
  • Roles in PostgreSQL
  • Extensions
  • Backup and Restore
  • PostgreSQL Tablespace

psql Overview

  • Environment Variables
  • Interactive versus Non Interactive psql
  • psql Customizations
  • psql Gems
  • Importing and Exporting Data

Using pgAdmin

  • pgAdmin Features
  • pgScript
  • Graphical Explain
  • Job Scheduling with pgAgent

PostgreSQL Data Types

  • Numerics
  • Textuals
  • Temporals
  • Arrays
  • Range Types
  • JSON
  • XML
  • Full Text Search
  • Custom and Composite Data Types

Tables, Constraints, and Indexes

  • 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

SQL Futures in PostgreSQL

  • Views
  • Constructions
  • Functions
  • Common Table Expressions
  • Lateral Joins

Writing Functions in PostgreSQL

  • Function Basics
  • Triggers and Trigger Functions
  • Aggregates
  • writing
  • function SQL, PL / pgSQL, PL / Python etc

Query Performance and Replication

  • Parallelized Queries
  • Query Planner
  • Replication Overview
  • Setting Up Full Server Replication
  • Foreign Data Wrappers

Feel Free To Contact TutorsBot

For Queries & Other Support

Call UsChat
Enquiry