PostGreSQL/Querying PostgreSQL Databases

Querying PostgreSQL Databases Certification Training Course Overview

The Querying PostGreSQL Databases course from Koenig offers insightful training on intermediate level querying of SQL using PostGreSQL. PostgreSQL or just Postgres, is a relational database that is open source. This ACID-compliant RDBMS is available for various platforms. It is completely transactional in nature and chiefly employs the SQL:2008 standard. PostgreSQL has extensible data types, functions, operators, aggregates, index methods, procedural languages, and a lot of extensions by third parties.

Querying PostgreSQL Databases (24 Hours) Download Course Contents

Live Virtual Classroom
Group Training 1100
08 - 13 Nov GTR 08:30 AM - 12:30 PM CST
(4 Hours/Day)
06 - 08 Dec 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training (GTR) 1300
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here
   Recording Available only $99

Course Modules

Module 1: Introduction to PostgreSQL Server
  • Overview
  • History
  • PostgreSQL Internals
Module 1: Introduction to PostgreSQL Server
  • Overview
  • History
  • PostgreSQL Internals
Module 2: Introduction to SQL Language
  • Writing SQL Queries
  • Structure of SQL Queries
Module 2: Introduction to SQL Language
  • Writing SQL Queries
  • Structure of SQL Queries
Module 3: Working with Data Types
  • Details are not available.
Module 3: Working with Data Types
  • Details are not available.
Module 4: Working with Built-In-Functions
  • Details are not available.
Module 4: Working with Built-In-Functions
  • Details are not available.
Module 5: Querying and Filtering Data
  • Where Clause
  • NULL Values
  • ORDER BY
  • DISTINCT
Module 5: Querying and Filtering Data
  • Where Clause
  • NULL Values
  • ORDER BY
  • DISTINCT
Module 6: Working with Type Conversions and Operators
  • Logical, Mathematical, Comparison, Bit String Operators
  • UNION and UNION All
Module 6: Working with Type Conversions and Operators
  • Logical, Mathematical, Comparison, Bit String Operators
  • UNION and UNION All
Module 7: Working with Joins
  • Details are not available.
Module 7: Working with Joins
  • Details are not available.
Module 8: Working with Group and Aggregation
  • Details are not available.
Module 8: Working with Group and Aggregation
  • Details are not available.
Module 9: Working with Windows Function
  • Details are not available.
Module 9: Working with Windows Function
  • Details are not available.
Module 10: Working with Views, Sub Query Expressions and Common Table Expressions
  • Details are not available.
Module 10: Working with Views, Sub Query Expressions and Common Table Expressions
  • Details are not available.
Module 11: Working with Functions
  • Details are not available.
Module 11: Working with Functions
  • Details are not available.
Module 12: Querying Metadata of PostgreSQL
  • System Information Functions
  • System Administration Functions
Module 12: Querying Metadata of PostgreSQL
  • System Information Functions
  • System Administration Functions
Module 13: Introduction to DML
  • Details are not available.
Module 13: Introduction to DML
  • Details are not available.
Module 14: Introduction to Indexes and Collations
  • Details are not available.
Module 14: Introduction to Indexes and Collations
  • Details are not available.
Module 15: Introduction of PGADMIN III
  • Details are not available.
Module 15: Introduction of PGADMIN III
  • Details are not available.
Download Course Contents

Request More Information

Course Prerequisites
  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows/Linux operating system and its core functionality.

Upon Completion of this Course, you will accomplish following:

  • An Introduction to concepts of database and RDBMS
  • Introduction to SQL and PostgreSQL
  • Querying, Filtering and Retrieving Data
  • Creating Tables and Ensuring Data Integrity
  • Manipulating Data in Tables
  • Working with Views, Subqueries and Functions

Give an edge to your career with Other Technologies certification training courses. Students can join the classes for Querying PostgreSQL Databases at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

Top Trending Technologies

 Cisco Routing and Switching Training & Certification Courses
 Cisco Data Center Training & Certification Courses
 Cisco Collaboration Certification Training Courses
 CCNA Certification Training Courses
 Wireless/Cisco Training & Certification Courses
 Cisco Service Provider Training & Certification Courses

FAQ's