PostgreSQL Tutorials for Beginners
4.3 (43 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
14,681 students enrolled

PostgreSQL Tutorials for Beginners

It has been prepared for the beginners to help them understand the concepts related to PostgreSQL Database
4.3 (43 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
14,681 students enrolled
Created by SimpliCode Point
Last updated 12/2018
English
English [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • This tutorial is designed to give details to PostgreSQL, relational database concepts, and the SQL language
  • Learn Syntax, Data Types, Create Database, Select Database and Drop Database
  • Learn Schema, details about query and clause
Course content
Expand all 36 lectures 03:54:51
+ Table Structure
14 lectures 01:17:50
Table Structure
07:35
Inserting Data in Table
07:08
Retreiving the Data
04:27
Sorting of Data
03:18
Analyzing of Various Queries
08:35
Destroying a Table
02:35
Customization of Queries
08:07
Understanding Null Values
04:32
Performing Complex Clause
07:34
Uses of Distinct Keyword
04:16
Set Show and Reset
04:30
SQL Aggregates
05:09
Group By and Having Clause
04:57
Concept of Joining Tables
05:07
+ Joining Tables
17 lectures 02:06:34
Requirement for Joining Tables
04:38
Creating Join Tables
08:40
Inserting Customer Value
12:08
Three or Four Table Joins
10:14
Additional Join
12:23
One to Many Joins
08:04
Concept of Self Joins
10:55
Concept of Referential Integrity
03:33
Numbering Rows
05:53
Creating Functions for Sequences
08:07
Combining Selects
07:54
Understanding Subqueries
06:18
Executing Subqueries
08:29
Update with FROM Clause
05:33
Creating Tables using Select
03:36
Concept of Performance
05:53
Understanding PostgreSQL
04:16
Requirements
  • Some basic knowledge on DBMS and SQL language.
  • No particular programming experience is required.
Description

PostgreSQL is a powerful, open source object-relational database system. This tutorial is designed to give details to PostgreSQL, relational database concepts, and the SQL language. It has been prepared for the beginners to help them understand the concepts related to PostgreSQL Database.

The training will include the following:

  • Overview

  • Environment Setup

  • Syntax

  • Data Types

  • Create Database

  • Select Database

  • Drop Database

  • Create Table

  • Drop Table

  • Schema

  • Insert Query

  • Select Query

  • Operators

  • Expressions

  • Where Clause

  • AND & OR Clauses

  • Update Query

  • Delete Query

  • Like Clause

  • Limit Clause

  • Order By Clause

  • Group By

  • With Clause

  • Having Clause

  • Distinct Keyword

Who this course is for:
  • Professionals
  • Students