menu logo orsys formation
CONTACT - +33 (0)1 49 07 73 73
CONTACT - 📞 +33 (0)1 49 07 73 73    drapeau francais   drapeau anglais
Consult our trainings :

Getting Started with PostgreSQL Training

Hands-on course
meilleur vente
Duration : 3 days
Ref : POS
Price  2019 : Contact us
  • Program
  • Participants / Prerequisite
  • Intra/Tailored
Program

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.

PROGRAM

Introduction

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

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.

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.

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.

Managing users and groups.

  • Creation. Authentication.
  • Grant privileges.

Hands-on work
Creating users, allocating rights. Authentication tests.

Configuring PostgreSQL

  • Installing and starting a database.
  • Postmaster. The Postgresql.conf file.
  • System tables.

Hands-on work
Installing a database and configuration.

Additional instruction

  • Programming interfaces.
  • Connecting PostgreSQL with PHP, JDBC, ODBC.
Participants / Prerequisite

» Participants

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

» Prerequisite

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

Contact Informations

By checking this box, I certify that I have read and accepted the conditions for the use of my data regarding the General Data Protection Regulation (GDPR).
You can at any time modify the use of your data and exercise your rights by sending an email to rgpd@orsys.fr
By checking this box, I agree to receive commercial and promotional communications from ORSYS Training*. You can unsubscribe at any time by using the link included in our communications.

Book your place

Submit your request

Time schedule

Generally, courses take place from 9:00 to 12:30 and from 14:00 to 17:30.
However, on the first day attendees are welcomed from 8:45, and there is a presentation of the session between 9:15 and 9:30.
The course itself begins at 9:30. For the 4- or 5-day hands-on courses, the sessions finish at 15:30 on the last day
linkedin orsys
twitter orsys
it! orsys
instagram orsys
pinterest orsys
facebook orsys
youtube orsys