Postgres Developer Fundamentals and Developer Advanced

Postgres-Training-SG

Postgres Developer Fundamentals and Developer Advanced Training

Postgres Developer Fundamentals is a 4-day instructor-led training that gives you the essential skills for database development in Postgres. Learn about Postgres data types, database objects, indexes, transactions, and working with connectors and drivers, with basic installation.

Target Audience: For experienced Database Developers who are new to Postgres and want to gain the essential skills required to effectively design and implement Postgres databases for applications while incorporating Postgres features.

Click below to see Training Content, Details and Pre-requisites:

Postgres Developer Fundamentals

Course Coverage:

  • PostgreSQL Introduction:
  • Introduction to PostgreSQL
  • Describe the sample tables used in the course
  • Installation:
  • Installation Options
  • Postgres Installation
  • PostgreSQL Source Code
  • Database Clusters
  • Start and Stop Postgres
  • pgAdmin III:
  • PgAdmin3
  • PEM Client
  • Registering a server
  • Viewing and Editing Data
  • Query Tool
  • Databases
  • Languages
  • Schemas
  • Database Objects
  • Maintenance
  • Tablespaces
  • Roles
  • Command Line Tool: PSQL
  • Command Line Tool: EDB*Plus
  • Transactions and Concurrency:
  • Transaction Definition
  • Effects of Concurrency on Transactions
  • Transaction Isolation Levels
  • Sharing Data Snapshots
  • Locking Modes
  • Multi-Version Concurrency Control Overview (MVCC)
  • Internal Identifiers
  • PostgreSQL Connectors and Extensions:
  • JDBC
  • Installing JDBC Connectors
  • Connecting Java Applications to PostgreSQL
  • .NET Connectors
  • Extensions
  • Database Design:
  • Object Hierarchy
  • Creating Databases
  • Users
  • Access Control
  • Creating Schemas
  • Schema Search Path
  • Data Types:
  • Numeric Types
  • Character Types
  • Date and Time
  • Arrays
  • JSON and JSONB
  • Other Data Types
  • SQL Primer:
  • Tables
  • Constraints
  • Table Inheritance
  • Viewing Data Using SELECT
  • SQL Queries: DML
  • Quoting in PostgreSQL
  • Other Database Objects:
  • Views
  • Materialized Views
  • Sequences
  • Domains
  • Indexes:
  • Types of Indexes
  • Creating an Index
  • Index on Expression
  • Unique Indexes
  • Partial Indexes
  • Removing Indexes
  • Viewing Index Usage
  • Re-indexing
  • SQL Functions:
  • Operators
  • String Functions
  • Date Functions
  • Numeric Function
  • JSON Functions
  • XML Functions
  • Aggregate Functions
  • Data Type Conversion
  • Large Objects:
  • Data Types for large data
  • Adding lo extenstion
  • Using Java File Stream for inserting
  • image in postgres
  • Large Objects:
  • Introduction to PLPGSQL
  • PL/PGSQL
  • Creating Functions using PL/PGSQL

Postgres Developer Advanced

Course Coverage:

  • Postgres Developer Advanced covers the advanced skills needed by Postgres database developers in a 2-day online instructor-led training. You will learn about using data adapters to interact with additional data sources, a multi-step plan for SQL tuning, and approaches for data security and localization. This is the second class in the Postgres Developers Track and follows Postgres Developer Fundamentals.
  • Procedural Languages
  • What is a Procedural Langauge
  • Introduction to PL/pgSQL
  • Working of PL/pgSQL
  • How to Create PL/pgSQL Functions
  • How to use Control Statements
  • How to Handle Exceptions in PL/pgSQL
  • Declaring and Using Cursors
  • Rules and Triggers
  • How to define Rules
  • Write Database Trigger Procedures
  • Create Triggers in PostgreSQL
  • Add Triggers on Views
  • SQL Tuning
  • Statement Processing
  • Common Query Performance Issues
  • SQL Tuning Goals
  • SQL Tuning Steps
    • ‒ Identify slow queries
    • ‒ Review the query execution plan
    • ‒ Optimizer statistics and behaviour
    • ‒ Restructure SQL statements
    • ‒ Indexes
  • Background Worker Processes
  • What is Background Worker
  • How to Setup Background Worker
  • Examples of Pre-built Background Worker Processes
  • Localization
  • PostgreSQL Locale Support
  • Working with different Locales
  • PostgreSQL Character Sets
  • Changing Server and Client Encoding
  • Foreign Data Wrappers
  • What are Postgres
  • Foreign Data Wrappers
  • How to Setup FDWs
  • Example – postgres_fdw
  • Example – file_fdw
  • Full Text Searching
  • What is Full-Text Search
  • How to store and query Full Text Search data in Postgres
  • Data Encryption
  • What is Database Security
  • PostgreSQL options for Eata Encryption and Security
  • What is Host Based Access Control
  • How to implement Row level Security
  • Introduction to pg_crypto Extension
  • Working with Geo Data: Postgis
  • What is PostGIS
  • Installation of PostGIS
  • Creation of spatial database
  • Load and retrieve data in a spatial database

Training Details:

  • Training fees: Enquire here
  • Location: Singapore
  • Date & Time: 9th to 12th April 2018, 9.30 am – 5.30 pm
  • Batch strength: 12-13 students

Training Pre-requisites:

  • Basic experience in database administration and understanding of Relational Database concepts will be helpful. Understanding of Linux environment and basic commands will help in better understanding of the hands-on lab sessions.

Delivery Approach:

  • Training includes lessons, hands-on labs and follow-up exercises to teach you how to use Postgres.
  • All attendees must attend this class in person. There is no remote access to the training.

Only limited seats, register fast!

To know more on training fees and other course details, fill the ‘Book a Seat’ form or drop us an email on success@ashnik.com