Five Day Advanced PostgreSQL Training by Joe Conway in Bangalore

Five Day Advanced PostgreSQL Training by Joe Conway in Bangalore

 

  • Five Day Advanced PostgreSQL Training

    PostgreSQL is the most advanced open source database. Increasingly companies/organizations around the world are entrusti

    Sale Date Ended

    INR 60000
    Sold Out

Invite friends

Contact Us

Page Views : 401

About The Event

PostgreSQL is the most advanced open source database. Increasingly companies/organizations around the world are entrusting their most critical data to PostgreSQL. There is a heavy demand supply gap for a good PostgreSQL professional. This training is geared towards shaping such professionals.

 

Course Outline:

  • PostgreSQL history, current versions, website, resources
  • PostgreSQL system architecture, system requirements
  • Installation of binary packages; Introduction to various interfaces and tools
  • Tools: pgAdmin, phpPgAdmin; Data types, SQL syntax and queries
  • Common table expressions
  • User schema management; Localization and encodings
  • Indexes, Reading query plans and Performance Tuning
  • Table portioning; Data backup and rollback of data
  • Backup analyze, Vacuum
  • Monitoring; Failover; Replication
  • Concurrency/transactions; Traditional locking methods
  • MVCC; Functions; Transaction isolation
  • Server-side programming and functions
  • Server-side languages; Application programming, Procedural languages
  • Extending PostgreSQL

 

Who should attend:

Database Administrators, Database Architects or Database Developers who

  • Has basic/mid-level experience on PostgreSQL database administration and would like to move towards expert level.
  • Has extensive experience on PostgreSQL database administration and would like to renew the understanding and update themselves of the latest updates and trends.
  • Is experienced in other databases like Oracle, MySQL and have fundamental understanding of PostgreSQL and would now like to gain expertise on PostgreSQL.

 

Trainee Profile:

President/CEO of credativ,LLC, U.S. subsidiary of credativ International, the largest independent open source service and support company having offices in USA, India, Germany, Canada, UK and Netherlands. Joe is the Author and maintainer of a PostgreSQL procedural language handler for the R language, PL/R and a speaker at various Postgres and Open Source Conferences.

For more information see www.joeconway.com

 

Gist of Joe's Contribution to PostgreSQL

  • Implemented set-returning (a.k.a. table) functions.
  • Significantly improved bytea and array data types, including adding support for btree indexes.
  • Added support for polymorphic argument types.
  • Developed multi-row VALUES list capability.
  • Wrote several "contrib" libraries including "dblink" and "tablefunc" (connectby() and crosstab()).
  • Improved and consolidated several "contrib" libraries into the "fuzzystringmatch" library.
  • Created the pg_settings system catalog VIEW and related support functions.
  • Coded the original has_*_privilege functions.
  • Added shared_preload_libraries configuration parameter and related functionality.
  • Coded generate_series(), and many other miscellaneous features and fixes