Training Calendar

Previous YearPrevious MonthNext YearNext Month
November 2024
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
29
30

psmb

Total Visitors

38.2%United States United States
21.2%China China
19.1%Canada Canada
8.5%Russian Federation Russian Federation
6.3%Malaysia Malaysia
2.1%United Kingdom United Kingdom
2.1%France France
2.1%Germany Germany

Yesterday: 1
This Week: 1
Last Week: 6
This Month: 12
Last Month: 9
Total: 50085

PostGreSQL for Developers

  • Print

 

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