Vous avez déjà un compte client ORSYS
Se connecter
Vous êtes nouveau chez ORSYS
Créer un compte
Vous ne souhaitez pas créer de compte
Poursuivre sans me connecter

Course : Getting Started with PostgreSQL

Getting Started with PostgreSQL


Average of customer reviews Average of customer reviews Average of customer reviews Average of customer reviews
4,4 / 5


The PostgreSQL DBMS has most of the features found in commercial products like Oracle or DB2. This training will teach you how to use it effectively, particularly to create and operate a database, or program in PL/pgSQL language.


INTER
IN-HOUSE
CUSTOM

Practical course in person or remote class
Disponible en anglais, à la demande

Ref. POS
  3d - 21h00
Price : 2010 € E.T.

Download in PDF format

Share this course by email




The PostgreSQL DBMS has most of the features found in commercial products like Oracle or DB2. This training will teach you how to use it effectively, particularly to create and operate a database, or program in PL/pgSQL language.



Intended audience
Developers, operators, and anyone else who wants to use PostgreSQL better or migrate to PostgreSQL.

Prerequisites
Basic knowledge of an operating system (Windows, Linux/Unix).

Course schedule

1
Introduction

  • Overview of PostgreSQL, versions.
  • The relational model, the schema.
  • Tables, constraints. User interfaces.

2
SQL with PostgreSQL

  • The SQL standard. Positioning of PostgreSQL. Setting up a database's schema.
  • PostgreSQL data type. Tables. Sequences. Views. Integrity constraints on tables.
  • Adding, editing, and deleting data.
  • Querying a database's schema. Selection, restriction, sorting, joining.
  • Complex queries. Using operators. SQL features of PostgreSQL.
  • Advanced features of PostgreSQL. Transactions. Views. Tables. Table inheritance.
Hands-on work
Creating a schema. SQL DDL scripts. Creating views. Transaction scenarios.

3
PL/pgSQL language

  • Instructions, types of language. Blocks of code.
  • Control structures. Errors and exceptions.
  • Cursors. Declaration, movement, and closing.
  • Procedures and functions.
  • Adding subprograms to a database.
  • Triggers. Structure.
Hands-on work
Stored functions.

4
Data maintenance

  • Importing/exporting data.
  • With COPY TO and COPY FROM. With Psql.
  • Backing up and restoring data.
  • pg_dump tools. Request optimization
  • Indexes. The optimizer. EXPLAIN and VACUUM.
Hands-on work
Importing/exporting data. Creating an index and analyzing a query execution plan.

5
Managing users and groups.

  • Creation. Authentication.
  • Grant privileges.
Hands-on work
Creating users, allocating rights. Authentication tests.

6
Configuring PostgreSQL

  • Installing and starting a database.
  • Postmaster. The Postgresql.conf file.
  • System tables.
Hands-on work
Installing a database and configuration.

7
Additional instruction

  • Programming interfaces.
  • Connecting PostgreSQL with PHP, JDBC, ODBC.


Customer reviews
4,4 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.


Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class

Dernières places
Date garantie en présentiel ou à distance
Session garantie