Unlock Knowledge for Less! Get 10% off on all online courses with code GH7D7Z !

What you'll get

  • Job Credibility
  • Certification Valid for Life
  • On-demand video*
  • E-Book
  • Self-Paced Learning
  • Certificate of Completion

Exam details

  • Mode of Exam : Online
  • Duration : 1 Hour
  • Multiple Choice Questions are asked
  • No. of Questions are asked : 50
  • Passing Marks : 25 (50%)
  • There is no negative marking

Description

If you are interested in learning PostgreSQL , then you have come to the correct place, this course is for you. This course is designed step by step from basic to advanced level of concepts. The aim of this course which is comprehensive and concise is to assist you on setting up MySQL and then PostgreSQL. You will be known with many real life examples too. 

In this course you will learn an Introduction to MYSQL and PostgreSQL, their benefits, their uses, their importance, the whole overview of this course and everything you will learn from this course. 

No prior knowledge is required. This course will teach you absolutely everything from basic to core. Just a computer or a laptop running Mac, Windows, or Linux is required and here all the software used in the course is free. 

This course is for anyone who is interested in learning PostgreSQL , engineers, programming enthusiasts, computer science students all can take this course.

The full course will be taught from scratch, from the root to the core. Now it is expected that when you are about to finish this course you will be well known with the high performances by using postgreSQL.  You will get many job opportunities and after this course which will ofcourse be an advantage to you. You will be provided with great knowledge, so what are you waiting for? Enroll your name in this course now.

Course Content

Total: 29 lectures
  • Getting started with postgresql
  • Accessing Data Programmatically
  • Aggregate Functions
  • Backup and Restore
  • Backup script for a production DB
  • COALESCE
  • Comments in postgresql
  • Common Table Expressions (WITH)
  • Connect to PostgreSQL from Java
  • Data Types
  • Dates, Timestamps, and Intervals
  • Event Triggers
  • Export PostgreSQL database table header and data to CSV file
  • EXTENSION dblink and postgres_fdw
  • Find String Length / Character Length
  • Inheritance
  • INSERT
  • JSON Support
  • Postgres cryptographic functions
  • Postgres Tip and Tricks
  • PostgreSQL High Availability
  • Programming with PL/pgSQL
  • Recursive queries
  • Role Management
  • SELECT
  • Table Creation
  • Triggers and Trigger Functions
  • UPDATE
  • Window Functions

Reviews

Please login or register to review
Frequently Asked Questions