Training Calendar

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

psmb

Total Visitors

45.9%Malaysia Malaysia
20.9%United States United States
6.1%Philippines Philippines
4.5%Australia Australia
2.5%India India
2.5%Russian Federation Russian Federation
2.5%Canada Canada
1.5%Singapore Singapore
1%Nepal Nepal
1%Nigeria Nigeria

Today: 1
Yesterday: 1
This Week: 12
Last Week: 16
This Month: 30
Last Month: 93
Total: 12423

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.

 

 

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