Getting Started with PostgreSQL
PostgreSQL Introduction
PostgreSQL Installation
PgAdmin GUI Tool
CLI psql quey and scripting tool
Course Syllabus
Structure Query Language
SQL Introduction
SQL Syntax
Lexical Structure
Value Expressions
Calling Function
Data Definition in PostgreSQL
Creating a Database in PostgreSQL
Creating a new Table
Default Values
Creating the Column
Inserting Values to the new Table
Constraints
System Columns
Modifying Tables
Privileges
Schemas
Inheritance
Table Partitioning
Foreign Data
Data Types in PostgreSQL
Numeric Types
DECIMAL Types
Character Types
Binary Data Types
Date and Time Types
Boolean Types
Enumerated Data Types
Bit String Data Types
Arrays
Data Manipulation in PostgreSQL
INSERT Command for Inserting data
UPDATE Command for Updating data
DELETE Command for Deleting data
Modified Rows Data Returning
Queries in PostgreSQL
Queries Introduction
Table Expressions
SELECT Command for Queries
Where Clause in Table
Different Types of JOINS
Combing Multiple Queries using UNION, INTERSECT, EXCEPT Command
Sorting Rows using ORDER BY Command
LIMIT and OFFSET Command
Alias in Table
VALUES Command
WITH command
Group BY command
DISTINCT Command
Functions and Operators in PostgreSQL
Logical Operators
Comparison Functions and Operators
Arithmetical Functions and Operators
String Functions and Operators
Binary String Functions and Operators
Bit String Function and Operators
Pattern Matching
Data Type Formatting Functions
Date and Time Function and Operators
Enum Support Functions
Array Functions and Operators
Aggregate Functions
Window Function
Row and Array Comparisons
Set Returning Functions
System Information Functions and Operators
System Administration Functions System Administration Functions
Trigger Functions
Event Trigger Functions
Type Conversion in PostgreSQL
Type conversion introduction
Operators
Functions
Value Storage
UNION, CASE and Related Constructs
SELECT Output Columns
Indexes in PostgreSQL
Index Introduction
Index Types
Multicolumn Indexes
Indexes and ORDER BY
Combining Multiple Indexes
Unique Indexes
Indexes on Expressions
Partial Indexed
Index-Only Scans and Covering Indexes
Indexes and Collations
Full Text Search in PostgreSQL
Full Text Search Introduction
Tables and Indexes
Controlling Text Search
Additional Features
Parsers
Dictionaries
Configuration Example
Concurrency Control
Concurrency Introduction
Transaction Isolation
Explicit Locking
Data Consistency Checks
Parallel Query
Parallel Query Working
Parallel Plans
Parallel Safety
PostgreSQL Administration Introduction
Installing PostgreSQL from Binaries
Installing PostgreSQL from Source Code
Installation procedure
After Installation Setup
Server Setup
User Account in PostgreSQL
Database Cluster
Starting Database Server
Shutting Down the Server
PostgreSQL Cluster Upgrade
Encryption
SSL Implementation with Connection
Other Secure Connection Implementation
Event Log on Windows
Server Configuration
Parameter Setting
File Locations
Connections to the Server
Authentication to the Server
Replication
Query Planning
Error Reporting
Error Logging
Lock Management
Error Handling
Client Authentication in PostgreSQL
Client Authentication Introduction
The Configuration File
Username Maps
Authentication Methods
Trust Authentication
Password Authentication
Other Types of Authentications
Database Roles and Management
Database Roles
Roles Attribute
Role Membership
Dropping Roles
Predefined Roles
Function Security
Creating Database
Template Database
Database Configuration
Destroying Database
Table spaces
Locale Support
Database Maintenance Tasks
PostgreSQL Administration Advance
Routine Vacuuming
Routine Reindexing
Backup and Restoring
SQL Dump
File System Level Backup
Continuous Archiving and Point-in-Time-Recovery
High Availability, Load Balancing and Replication
Log-Shipping Standby Servers
Failovers
Hot Standby
Monitoring the Database Activity
The Statistics Collectors
Viewing Locks
Progress Reporting
Dynamic Tracing
Monitoring Disk Usage
Reliability and the Write-Ahead Log
Logical Replication
Publication
Subscription
Architecture
Monitoring
Just-in-Time Compilation
Regression Test
Test Evaluation
Test Coverage
PostgreSQL Developer
Extending SQL
PostgreSQL Type System
User-Defined Function
User-Defined Procedures
Query Language (SQL) Functions
Function Overloading
Procedural Language Functions
User Defined Aggregates
User Defined Types
User Defined Operators
Interfacing Extensions to Indexes
Triggers in PostgreSQL
Overview of Trigger
Data Changes
Trigger Examples
Event Triggers
Overview of Triggers
Event Trigger Behaviour
Event Trigger Firing Matrix
Event Trigger Function in C
Complete Event Trigger Example
Table Rewrite Event Trigger
Rule System
Query Tree
Views and the Rule System
Materialized Views
Rules on INSERT, UPDATE, and DELETE
Rules and Privileges
Rules and Command Status
Procedural Language Introduction
Installing Procedural Language
Introduction about Procedural Language
PL/pgSQL –SQL Procedural Language
PL/pgSQL Overview
Structure of PL/pgSQL
Deceleration
Expression
Basic Statements
Control Structure
Cursors
Transaction Management
Error and Messages
Trigger Functions
PL/Tcl –Tcl Procedural Language
PL/Tcl overview
PL/Tcl Functions andArguments
Data Values in PL/Tcl
Global Data in PL/Tcl
Database Access from PL/Tcl
Trigger Function in PL/Tcl
Event Trigger Function in PL/Tcl
Explicit Sub transactions in PL/Tcl
PL/Tcl Configuration
Tcl Procedure Names
Server Programming Interface
Interface Functions
Interface Support Functions
Memory Management
Transaction Management
Visibility of Data Changes
Fazlur Rahman
He has 5 years of experience maintaining PostgreSQL and MySQL software, implementing monitoring and alerting, implementing backup and recovery processes, providing system and SQL performance, and knowledge of Python multiprocessing, Django web framework, and Celery Async framework.
PostgreSQL Training in Bangalore Key Skills
- Query Planning
- Architectural Fundamentals
- Creating a Self-Signed Certificate
- Partial Indexes
Advantages in TutorsBot
- Placement Team for Job Assurance to Course Enroller
- Professional Trainer from IT Industry
- Deidicated Support Team for Training and Development
- Practical Training Program includes Hand On Project Session
- More than 150 Subject Matter Expert Community
- Five Years of Training Services Provider
- Placed More than 850 Students
