PostGreSQL for Developers

Training Calendar

Previous Year Previous Month Next Year Next Month

February 2018

Mon	Tue	Wed	Thu	Fri	Sat	Sun
	1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28

psmb

Total Visitors

Today:	1
Yesterday:	10
This Week:	11
Last Week:	6
This Month:	22
Last Month:	185
Total:	46493

PostGreSQL for Developers

Course Overview

This PostgreSQL training course is ideal for those looking to migrate to PostgreSQL. This PostgreSQL training course was designed for specifically for developers with SQL knowledge and experience and focuses on the features and functionality that are specific to PostgreSQL. Attendees will learn how to apply their SQL knowledge and experience to the PostgreSQL platform.

Download Brochure

Pre-requisites

Having knowledge and experience with relational databases and SQL.

PostGreSQL Developers - Schedule

Day 1
09.00am – 10.00am	Getting Started Installation Architectural Fundamentals
10.00am – 10.30am	Breakfast
10.30am – 12.45pm	Creating a Database Accessing a Database The SQL Language Introduction Concepts
12.45pm – 02.15pm	Lunch
02.15pm – 05.00pm	Creating a New Table Populating a Table With Rows Querying a Table PostgreSQL Select statement
Day 2
09.00am – 10.00am	PostgreSQL PostgreSQL Select Distinct
10.00am – 10.30am	Breakfast
10.30am – 12.45pm	PostgreSQL Where PostgreSQL In PostgreSQL Between PostgreSQL Like
12.45pm – 02.15pm	Lunch
02.15pm – 05.00pm	Joins Between Tables PostgreSQL Union PostgreSQL Inner Join PostgreSQL Left Join
Day 3
09.00am – 10.00am	Aggregate Functions PostgreSQL Group By
10.00am – 10.30am	Breakfast
10.30am – 12.45pm	PostgreSQL Having PostgreSQL Subquery
12.45pm – 02.15pm	Lunch
02.15pm – 05.00pm	Updates PostgreSQL Update statement with combination of conditions
Day 4
09.00am – 10.00am	Deletions PostgreSQL Delete statement with combination of conditions
10.00am – 10.30am	Breakfast
10.30am – 12.45pm	Advanced Features Introduction Views
12.45pm – 02.15pm	Lunch
02.15pm – 05.00pm	Foreign Keys Transactions Conclusion