Training Calendar

 ◄◄  ◄  ►►  ► 
August 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
18
19
20
21
22
No Image
Kuala Lumpur
Date :  22-08-2017
23
No Image
Kuala Lumpur
Date :  23-08-2017
24
25
26
27
28
29
No Image
Kuala Lumpur
Date :  29-08-2017
30
No Image
Kuala Lumpur
Date :  30-08-2017
31

psmb

Total Visitors

40.1%Malaysia Malaysia
23.9%United States United States
5.1%Philippines Philippines
4.5%India India
2.8%Australia Australia
2.8%Indonesia Indonesia
2.5%China China
2.5%Singapore Singapore
1.4%Canada Canada
1.1%Bangladesh Bangladesh

Today: 1
Yesterday: 9
This Week: 11
Last Week: 20
This Month: 157
Last Month: 169
Total: 12129

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