Description
PostgreSQL is an open-source database server with low maintenance, low cost of ownership and an important role in production environments. After an introduction and history, we dive into the database with a realistic scenario. First part: focus on data manipulation language, especially queries. PostgreSQL fully supports the latest SQL ISO standard. The second section covers data definition language, including the creation of objects such as tables, views, materialized views, sequences, and indexes. We also demonstrate table inheritance and table partitioning. The latest modules review the PostgreSQL implementation of integrity constraints and provide tips on transactions, locking and competition management.
Audience
Anyone who needs to open or develop a PostgreSQL database, such as analysts or even technical designers, database administrators and developers, client application developers, and Business Intelligence professionals.
Methods
Instructor-led workshop with practical exercises.
Contents
- Introduction to PostgreSQL
- Brief history
- Licensing and conventions
- Installing client software
- Clients and Connectivity
- Connecting to PostgreSQL
- Psql
- PgAdmini II
- Data Manipulation Language
- Select clause
- Where clause
- Values lists
- Limit and Offset
- Order by
- Group By and Having
- Windowing functions (analytical)
- Joins
- Union, Intersect and Except
- Subqueries
- Common Table Expressions
- Conversion Type
- Full Text Search
- Insert, Update and Delete
- Data-modifying statements in With clause
- Data Definition Language
- Metadata and the systems catalog
- Tables
- Creating tables
- Table inheritance
- Table partitioning
- Views
- Materialized views
- Sequences
- Indexes
- Integrity
- Primary key or OID
- Unique key
- Foreign key and referential integrity
- Domains and check constraints
- Performance and Concurrency
- Transactions and MVCC
- Transaction isolation and locking
- Concurrency Control
Certification
Participation certificate: At the end of the training, participants will receive a certificate that they have completed this course.