Postgresql

This course will take place in 3-4 Kirby Street, London, EC1N 8TS. Find on map
15 %
Discount

when you buy 3 or more courses

The discount will be automatically
applied at the checkout
Looking for a
2-12 months
training?
Choose Database Administrator
Career Programme

Looking for a 2-12 months training?

Choose

Database Administrator career programme

Upcoming dates

There are no open public schedule dates for Postgresql course. We can offer you a private training or arrange a public course for you. Contact us here and we can make arrangements for your course.

Course Outline

Postgresql course overview

Here is your chance to learn how this powerful relational database management system can make your life easier and more fun! This class covers all the basics and will get you on your way, with a solid foundation. This instructor led, hands-on class covers the fundamentals of SQL and relational databases, using postgresql[tm] as a teaching tool.

Delegates will learn:

  • Understand the features and benefits of postgresql
  • Be able to install and start the postgresql server
  • Understand the basics of Relational Databases
  • Understand the SQL and postgresql languages
  • Understand Data/Column types with regard to efficient database design
  • Be able to view a database design structure/content
  • Create a database design using an efficient structure
  • Be able to extract basic database information using the SELECT command
  • Be able to troubleshoot syntax and understand typical warnings and errors
  • Be able to delete or modify a database, and table row data
  • Grouping query data with Aggregation
  • Connect data from multiple table rows using JOIN
  • Perform nested sub-queries
  • Use of Simple Functions (String, Date, Numerical)
  • Describe postgresql connectors, their major features and differences
  • Understand postgresql storage engines, transactions and features of the common engines

This short postgresql course is hands-on, instructor-led and classroom based. This training can be taken as a part-time evening course or even on the weekends. A list of all upcoming public postgresql wtraining course is given on training dragon website.


Who is Postgresql training for?

Students who can benefit from this course:

  • New or existing users of postgresql, who have little or no previous experience with a relational database management system.


Prerequisites for Postgresql course

Required Prerequisites:

  • Basic computer literacy is required

Suggested Prerequisites:

  • Previous experience with any command-line program
  • Knowledge of database concepts


What will I get?

  • Training from professional postgresql certified trainers:

    Training Dragon consultants have been implementing professional postgresql Server Database solutions across a range of companies for many years. Those consultants write and teach our postgresql training courses, so their experience directly informs course content.

  • Practical Projects:

    This postgresql training is designed to prepare you not only for postgresql certification, but also to train you for your next job. To do this, next to certification you will also work on real-world practical postgresql related exercises in this postgresql course. This will ensure that you can apply the knowledge gained from this course to your work environment.

  • Course Material and Practice exams:

    postgresql electronic notes are included in this course. You will also take practice exams as part of the course.

  • Course Completion Certificate:

    After completing this training you will receive postgresql course completion certificate.

  • Support and Careers Advice:

    After the course if you have any problems or questions regarding postgresql, do not hesitate to contact us. Training Dragon’s trainers and career consultants are expert in their fields and if you need any help with you career choice, please speak to one of our career consultants.

  • Pass Guarantee and Train again for Free:

    We are sure that you will pass your postgresql certification exam at first attempt. However, if you don’t, you can come back within a year and take the complete course for free.

  • Official Course Curriculum:

    This postgresql certification course is based on the official Microsoft recommended course syllabus.


Postgresql Course Contents

Introduction

What is PostgreSQL?

Install PostgreSQL

Connect to Database

Download Sample Database

Load Sample Database

Explore Server and Database Objects

​Roles Management:

Backup and Restore Databases

Creating Tablespace

Changing Tablespace

Deleting Tablespaces

Reset Password

psql Commands

Describe Table

Show Databases

Show Tables

PL/PGSQL

Introduction to Stored Procedures

Block Structure

Errors and Messages

Create Function

Function Parameters

Function Overloading

Function That Returns A Table

Variables

Constants

IF Statement

CASE Statement

Loop Statements

Cursor

FUNDAMENTALS

Select

Order By

Select Distinct

Where

LIMIT

IN

Between

Like

Inner Join

Left Join

Full Outer Join

Cross Join

Natural Join

Group By

Having

Union

Intersect

Except

Subquery

Insert

Update

Delete

Data Types

Create Table

Alter Table

Drop Table

Truncate Table

CHECK Constraint

Not-Null Constraint

Foreign Key

Primary Key

UNIQUE Constraint

Functions

AGGREGATE FUNCTIONS

COUNT Function

AVG Function

MAX Function

MIN Function

SUM Function

CONDITIONAL EXPRESSIONS

CASE

NULLIF

COALESCE

STRING FUNCTIONS

CONCAT Function

TRIM Function

LENGTH Function

REPLACE

Substring

Letter Case Functions

OPERATORS

VIEWS

Managing Views

Creating Updatable Views

Materialized Views

TRIGGERS

Introduction to Trigger

Creating A Trigger

Managing Triggers  

View Complete Course outline

Daily schedule

The scheme below shows what a typical day at Training Dragon looks like.

10:00 11:30 11:45 13:00 14:00 15:30 15:45
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Tea
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Lunch
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Tea
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Video Placeholder

Looking for a
2-12 months
training?

Choose

Database Administrator career programme

Our Trainers

Emiliano
Emiliano
Leads our teaching team with many years of experience in teaching web development.
Ross
Ross
Brings many years of Python and Java software development experience to classrooms.
Olu
Olu
Microsoft and Oracle certified developer with years teaching experience in Android, .NET and databases.

Latest Reviews

Frequently Asked Questions

Have a question?
We are here to answer them