Basic PostgreSQL Administration

Sponsored links

This course is aimed at database administrators and developers who will adopt PostgreSQL in the near future, or who are considering such an adoption. It is assumed that participants will have basic UNIX knowledge, how to use the command line and simple administration tasks, as well as basic SQL and programming knowledge, preferably in C, PHP or Java.

This course is run regularly at credativ's offices. On-site training can also be arranged.

Delivery:
  • Classroom
Regions:
  • The West Midlands
Category:

Further Details

9:00 - 10:45



    • Introduction, course overview


    • PostgreSQL history, current versions, website, resources


    • PostgreSQL system architecture, system requirements



    10:45 - 11:20



      • Break



      11:20 - 13:15




        • Installation of binary packages



        • Introduction to various interfaces and tools



        • Tools. pgAdmin, phpPgAdmin, Visual Explain, Tora, Kexi, Rekall, OpenOffice






        13:15 - 14:15


          • Lunch break



          14:15 - 15:30


            • Overview of PostgreSQL SQL syntax, data types and queries



            • Overview of advanced SQL



            • Complex queries and index creation



            • Query plan reading and data type selection



            15.30 - 15.45


              • Break



              15:45 - 17:00


                • Administration



                • Performance Tuning




                • Encoding



                • Data backup and rollback of data

                This Training Course is taught in classrooms in the following locations:
                Coventry

                Guide Price: 250