PostgreSQL Course


Welcome to PostgreSQL Online Course with live Instructor using an interactive cloud desktop environment DaDesktop. Experience remote live training using an interactive, remote desktop led by a human being!


7 hours

1,656 €


What is PostgreSQL?


PostgreSQL (or Postgres for short) is an open source relational database management systems (RDBMS). In nearly all cases the main application interface to an RDBMS is SQL, the standardized language for accessing relational databases. Beyond SQL every RDBMS needs additional tools to handle the installation process as well as maintenance and optimization tasks. As such tasks act closely to the implementation of each RDBMS, they greatly differ from RDBMS to RDBMS - unlike SQL. The purpose of This course is an introduction to the PostgreSQL specific aspects: its architecture, installing procedure, maintenance and optimization tasks. Thus it is primarily aimed to database administrators. But it is only a starting point in these objectives and many topics are omitted. For a complete treatment we recommend to get through professional training courses offered by many consulting companies. And don't forget: there is a great and complete documentation of all the stuff we try to explain in the Wikibook on hand. Additionally some special topics are summarized in the PostgreSQL wiki. The SQL interface is out of the scope of the Wikibook on hand. If you are interested in this specific topic, you may want to refer to the Wikibook SQL, which describes the SQL standard independent from any RDBMS implementation. It's a good starting point for PostgreSQL as its implementation of SQL is very close to the standard. The Wikibook on hand is based on PostgreSQL version 10.

Content

  • Introduction to PostgreSQL
  • Features
  • Featured Platforms
  • Download, Installation, First Steps
  • Glossary / Prominent Terms
  • Architecture
  • Managing the Instance
  • Configuration
  • Multiversion Concurrency Control (MVCC) and Vacuum
  • Write-Ahead-Log files (WAL)

 


Would you like to learn PostgreSQL?


Simply, click the "Book" button of PostgreSQL and proceed to the payment method. Enter your desired schedule of training. You will receive an email confirmation for PostgreSQL and a representative / trainer will get in touch with you.


Course Category:

   PostgreSQL Training

Course Trainers



Course Schedules


Date Time
December 6, 2021 (Monday) 09:30 AM - 04:30 PM
December 20, 2021 (Monday) 09:30 AM - 04:30 PM
January 3, 2022 (Monday) 09:30 AM - 04:30 PM
January 17, 2022 (Monday) 09:30 AM - 04:30 PM
January 31, 2022 (Monday) 09:30 AM - 04:30 PM
February 14, 2022 (Monday) 09:30 AM - 04:30 PM
February 28, 2022 (Monday) 09:30 AM - 04:30 PM


PostgreSQL consultancy is available.

Let us know how we can help you.


CONSULT US