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.

1 Includes airfare from anywhere in the continental United States and some parts of Canada as well as accommodation and shuttle services.
spacer
2 Include course and course materials only.
spacer
3 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.
spacer
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
Adobe PDF Logo 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