1000+ Unique Technologies Projects Delivered | 500+ Corporate Customers Worldwide | 50000+ Professionals Trained on 40+ Domains in Over 30 Countries | Just Launched B2I Offerings | Live, Instructor-led.

PostgreSQL

This web-based training course on PostgreSQL functionality, administration and development, is available online to all individuals, institutions, corporates and enterprises in India (New Delhi NCR, Bangalore, Chennai, Kolkatta), US, UK, Canada, Australia, Singapore, United Arab Emirates (UAE), China and South Africa. No matter where you are located, you can enroll for any training with us - because all our training sessions are delivered online by live instructors using interactive, intensive learning methods.

PostgreSQL database system has been developed for some serious level database management and development and provides industrial level strengths by providing installations worth terabytes of data. Being a completely open-source tool it is fast and easy to use and is under constant development and growth all over the globe. The database tool provides a full text search tool and is used as a default database management tool deployed on Heroku. Using triggers and indexes and the built-in full-text to speech features, working with postgreSQL is inherently an easy job and provides a wide array of features and capabilities.

Reviews , Learners(390)



Course Details

The course aims to introduce the various segments and areas of PostgreSQL administration, installation, configuration and setup, security, database creation and includes the introduction to the common SQL statements which are used for manipulating data. The trainees will be taught about the basic data structures and the various methods which are used for importing, exporting and backing up data. After the basics, various other topics of log reading, table structure optimization and use of PostgreSQL queries in NoSQL queries and big data reporting will be taught about in this PostgreSQL database training course. This PostgreSQL database management training course does not require any pre-requisites, but it is advised that the participants have a familiarity with database structures and administration to successfully complete this course.


Introduction to Databases

  • Data Normalization techniques
  • Using Indexes, Relationships and Keys
  • Introduction and overview to RDBMS
  • Introduction overview to PostgreSQL 9.4

Installation and Configuration

  • Downloading PostgreSQL
  • Enterprise vs. open source comparison
  • Installation and configuration of services
  • How to use the Command Line Client
  • Installation and Configuration of PostgreSQL 9.x: RHEL/CentOS
  • Installation and Configuration PostgreSQL 9.x: Debian/Ubuntu

Administration and Security Features

  • How to create a Database
  • How to create a Table
  • Creating and Deleting Users
  • Assigning Permissions
  • Installation and Configuration of myPgAdmin
  • Methods of accepting External Connections
  • How to insert data
  • How to view data
  • How to delete data
  • Methods of Backing Up and Restoring Databases
  • Methods of Replication using Master Server Configuration
  • Methods of Replication using Slave Server Configuration
  • Database Clustering Techniques
  • How to create and delete Databases
  • Methods of adding users in the tool
  • How to create a Table and Inserting Data in it
  • How to configure the Database for External Connections
  • Methods of Database Backup and Restore techniques

Datatypes in PostgreSQL

  • Introduction to Datatypes and their usage
  • Character Datatypes and their implementation
  • Numeric Datatypes and their implementation
  • Serial Datatypes and their usage
  • Boolean Datatype and their usage
  • Using Special Datatype - NULL
  • Using Date Datatype
  • Implementation of Time Datatype
  • Using Timestamps

Our Clients

B2B Technical Trainings Projects Delivered


Read More