Postgresql Training Course

Course Outline

Postgresql course overview

Here is your chance to learn how this powerful relational database management system can make your life easier and more fun! This class covers all the basics and will get you on your way, with a solid foundation. This instructor led, hands-on class covers the fundamentals of SQL and relational databases, using postgresql as a teaching tool.

Delegates will learn:

• Understand the features and benefits of postgresql
• Be able to install and start the postgresql server
• Understand the basics of Relational Databases
• Understand the SQL and postgresql languages
• Understand Data/Column types with regard to efficient database design
• Be able to view a database design structure/content
• Create a database design using an efficient structure
• Be able to extract basic database information using the SELECT command
• Be able to troubleshoot syntax and understand typical warnings and errors
• Be able to delete or modify a database, and table row data
• Grouping query data with Aggregation
• Connect data from multiple table rows using JOIN
• Perform nested sub-queries
• Use of Simple Functions (String, Date, Numerical)
• Describe postgresql connectors, their major features and differences
• Understand postgresql storage engines, transactions and features of the common engines

This short postgresql course is hands-on, instructor-led and classroom based. This training can be taken as a part-time evening course or even on the weekends. A list of all upcoming public postgresql wtraining course is given on training dragon website.

Who is Postgresql training for?

Students who can benefit from this course:

• New or existing users of postgresql, who have little or no previous experience with a relational database management system.
• Software testers, IT support engineers, DBA, Developers, managers and support staff

If you are a complete beginner in databse and would like to become an expert in postgresql, please follow this path.

• Introduction to programming
• Python for Beginners
• SQL for beginners
• MTA Databse Fundamentals
• Postgresql
• Postgresql for DBA
• Postgresql for Developers

Prerequisites for Postgresql course

Required Prerequisites:

• Basic computer literacy is required
• Previous experience with any command-line program
• Knowledge of database concepts

What will I get?

• Training from professional postgresql certified trainers:

  Training Dragon consultants have been implementing professional postgresql Database solutions across a range of companies for many years. Those consultants write and teach our postgresql training courses, so their experience directly informs course content.

• Practical Projects:

  This postgresql training is designed to prepare you not only for postgresql certification, but also to train you for your next job.  You will also work on real-world practical postgresql related exercises in this postgresql course. This will ensure that you can apply the knowledge gained from this course to your work environment.

• Course Material:

  postgresql electronic notes are included in this course.

• Course Completion Certificate:

  After completing this training you will receive postgresql course completion certificate.

• Support and Careers Advice:

  After the course if you have any problems or questions regarding postgresql, do not hesitate to contact us. Training Dragon’s trainers and career consultants are expert in their fields and if you need any help with you career choice, please speak to one of our career consultants.