Training Calendar

 ◄◄  ◄  ►►  ► 
October 2017
Mon Tue Wed Thu Fri Sat Sun
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
No Image
Bangi
Date :  17-10-2017
18
No Image
Bangi
Date :  18-10-2017
19
No Image
Bangi
Date :  19-10-2017
20
21
22
27
28
29
30
31

psmb

Total Visitors

48%Malaysia Malaysia
24%United States United States
3.6%Philippines Philippines
3.3%Singapore Singapore
2.7%Australia Australia
2.4%India India
2.1%Pakistan Pakistan
2.1%Indonesia Indonesia
1.5%China China
1.2%Canada Canada

Today: 2
Yesterday: 4
This Week: 6
Last Week: 14
This Month: 26
Last Month: 94
Total: 12263

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