SQL for PostgreSQL

Book Now - 2 Delivery Methods Available:
Classroom Virtual Classroom Private Group - Virtual Self-Paced OnlineOverview
The SQL for PostgreSQL course is designed to give delegates practical experience in writing SQL statements and scripts using PostgreSQL. The basic SELECT statement, the use of SQL functions, and the basic table and view handling statements are introduced.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Objectives
The delegate will learn and acquire skills as follows:
- Creating SQL statements to query database tables
- Using standard aggregate functions and related SELECT statement clauses
- Joining Tables
- Using basic subqueries and the set operators
- Using numeric, character and date functions
- Using conversion and other miscellaneous functions
- Using SQL parameters
- Using complex subqueries
- Creating and altering tables and views
- Inserting, updating and deleting rows in database tables
- Creating and listing indexes
- Managing sequences
Target Audience
This is an ideal course for anyone who needs to use and understand the Structured Query Language (SQL) to query, report and update data in a PostgreSQL database.
Additional Information
- Course technical content is subject to change without notice.
- Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.
Training Partners
We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.
Modules
Prerequisites
There are no formal pre-requisites for this SQL for PostgreSQL course, although an understanding of relational databases and exposure to information technology in general would be useful.
Additional Learning
The courses below may help you meet the knowledge level required to take this course.
-
PL/SQL
A 2-day Training Course on PL/SQL; Designed for those who need to write program scripts using Oracle's Procedure Language; corresponds to exam 1Z0-001
Scheduled Dates
Please select from the dates below to make an enquiry or booking.
Pricing
Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.
Code | Location | Duration | Price | Sep | Oct | Nov | Dec | Jan | Feb |
---|---|---|---|---|---|---|---|---|---|
PSQL |
Virtual Classroom (London)
|
3 Days | $1,405 |
06-08
18-20
|
|
|
|