Database Training Course

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. This tutorial will give you quick start with PostgreSQL and make you comfortable with PostgreSQL programming.

Overview

PostgreSQL

Welcome to the PostgreSQLTutorial.com website! This PostgreSQL tutorial helps you understand PostgreSQL quickly. You will learn PostgreSQL fast through many practical examples. We will show you not only problems but also how to solve them creatively in PostgreSQL.

If you are…

  1. Looking for learning PostgreSQL fast and easily.
  2. Developing applications using PostgreSQL as the back-end database management system.
  3. Migrating from other database management systems such as MySQL, Oracle, Microsoft SQL Server to PostgreSQL.

Prerequisites

Anyone with a willingness to learn.

Basic knowledge of using Computers.


PostgreSQL Training Duration

Regular classroom based training: 4 Weeks, 60 minutes of theory & practical session per day.

Modules

Course Content

This section helps you how to query data from a single table using basic data selection techniques such as selecting columns, sorting result set, and filtering rows. Then, you will learn about the advanced queries such as joining multiple tables, using set operations, and constructing the subquery. Finally, you will learn how to manage database tables such as creating new a table or modifying an existing table’s structure.

This PostgreSQL stored procedures section shows you step by step how to develop PostgreSQL user-defined functions. In PostgreSQL, procedural languages such as PL/pgSQL, C, Perl, Python and Tcl are referred to as stored procedures. The stored procedures add many procedural elements e.g., control structures, loop, complex calculation, etc., to extend SQL-standard. It allows you to develop complex functions in PostgreSQL that may not be possible using plain SQL statements.

A PostgreSQL trigger is a function invoked automatically whenever an event e.g., insert, update, or delete occurred. In this section, we will introduce you to the database triggers and show how to apply them in your databases.

A view is named query that provides another way to present data in the database tables. A view is defined based on one or more tables, which are known as base tables. When you create a view, you basically create a query and assign it a name, therefore a view is useful for wrapping a commonly used complex query.

This section provides you with the most useful PostgreSQL functions including aggregate functions, string functions, and date & time functions.

In this section, we will show you how to manage databases in PostgreSQL including creating databases, modifying existing database’s features and deleting databases. In addition, the schema management is covered.

Post an Enquiry

Post an Enquiry

Address

1/583, ECR, KOTTIVAKKAM
CHENNAI / TAMIL NADU / INDIA

E-mail

astroinfo@astrotech.in
astroeq.com@gmail.com

Contact No.

+91 9710107874
(044) 438 55 773