Courses by Category
Click on a category below to see a listing of courses.

This course is available for customized on-site delivery for groups of 3 or more students.
Contact us today at 877-258-8987 for more information or a quote.

Scroll down the page for a list of upcoming course dates in our public calendar.

Implementing Databases with PostgreSQL (4 days)

Looking at deploying PostgreSQL in your enterprise? Our Implementing Databases with PostgreSQL course teaches developers the ins and outs of developing and implementing well-designed databases using PostgreSQL.

Developed by industry experts, this PostgreSQL training course focuses on teaching students how to design and implement enterprise databases using PostgreSQL, and covers topics that are of importance to good database design, such as design philosophy, normalization, and index management.

Implementing Databases with PostgreSQL Course Calendar (4 days)


Call for upcoming dates or on-site delivery.
¹ Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services. ² Include course and course materials only. ³ Requires a broadband internet connection and microphone. Note that Virtual LIVE courses are led by an instructor, and as such start and end in local time (based on the course location), this my differ from your time zone. For government and education pricing, please contact us.

Recommended Pre-requisites

We recommend that students attending this PostgreSQL training course have a basic understanding of programming concepts.

Course Outline/Agenda

Download the table of contents for our course guide (link below) for a more detailed description of this PostgreSQL course's content

The following topics are covered in this course:

Database Fundamentals
Database Normalization
Installing & Configuring PostgreSQL
Using the psql Client
Understanding PostgreSQL Data Types
- Numeric data types
- Character types
- Binary data types
- Date & time types
- Boolean values
- Array types
- Other data types
Understanding & managing sequence numbers
Creating tables (DDL)
- Using CREATE TABLE
- NOT NULL constraints
- PRIMARY KEY constraints
- FOREIGN KEY constraints
Modifying tables (ALTER TABLE)
- Creating & managing indexes
- Creating indexes
- Indexes on expressions
- Partial indexes
Data manipulation language (DML)
- Inserting data
- Using COPY to perform data loads
- Using DELETE to remove rows
- Updating data using UPDATE
Retrieving information from tables using SELECT
Performing table joins
- Cross joins
- Inner joins
- Outer joins
- Natural joins
Restricting selections using the WHERE clause
Joining tables with WHERE
Using ORDER BY to sort query results
Limiting rows returned using LIMIT
Computing summary values
Using the GROUP BY clause
Using the HAVING clause
Using DISTINCT to eliminate duplicates
Using UNION, INTERSECT and EXCEPT to join SELECT Results
Pattern matching using LIKE
Conditional expressions
- The CASE statement
- The COALESCE function
- The NULLIF function
Subquery expressions
- The EXISTS expression
- The IN (and NOT IN) expression
Working with array values
Performing type casting and conversion
PostgreSQL functions
- Numeric functions
- Character functions
- Session information functions
Transactions and concurrency

Class Size

This class is limited to a maximum of 12 students.

On-Site Delivery

This course is available for on-site delivery for groups of 3 or more students.

OTG offers discounted training for on-site courses of more than 3 students - call us at 877-258-8987 (or submit the form on the upper right side of this page) for more information.

Course Details

This course is taught by our experienced on-staff certified DBAs with over a decade of experience with MySQL, PostgreSQL, Sybase and Oracle. Our expert instructors have the knowledge and skills to impart both their knowledge and experiences to students.

Instructional Materials

The following materials are used to deliver this course:

PostgreSQL, 2nd Edition
OTG Course Guide
PostgreSQL, 2nd Edition

View course guide table of contents
Requires Adobe Acrobat Reader

Enroll in this course

PostgreSQL Admin Training Logo

View upcoming course calendar

info@otg-nc.com
877-258-8987