3.78 out of 5
3.78
31 reviews on Udemy

PostgreSQL Tutorials for Beginners

It has been prepared for the beginners to help them understand the concepts related to PostgreSQL Database
Instructor:
SimpliCode Point
14,350 students enrolled
English [Auto-generated]
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

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

Introduction

1
Introduction to PostgreSQL

Benefits of Database

1
Benefits of PostgreSQL
2
Aspect of Database
3
Types of Data
4
Issuing Database Commands

Table Structure

1
Table Structure
2
Inserting Data in Table
3
Retreiving the Data
4
Sorting of Data
5
Analyzing of Various Queries
6
Destroying a Table
7
Customization of Queries
8
Understanding Null Values
9
Performing Complex Clause
10
Uses of Distinct Keyword
11
Set Show and Reset
12
SQL Aggregates
13
Group By and Having Clause
14
Concept of Joining Tables

Joining Tables

1
Requirement for Joining Tables
2
Creating Join Tables
3
Inserting Customer Value
4
Three or Four Table Joins
5
Additional Join
6
One to Many Joins
7
Concept of Self Joins
8
Concept of Referential Integrity
9
Numbering Rows
10
Creating Functions for Sequences
11
Combining Selects
12
Understanding Subqueries
13
Executing Subqueries
14
Update with FROM Clause
15
Creating Tables using Select
16
Concept of Performance
17
Understanding PostgreSQL
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.8
3.8 out of 5
31 Ratings

Detailed Rating

Stars 5
4
Stars 4
11
Stars 3
12
Stars 2
4
Stars 1
0
0c26c1d518b54e507d96c4cf15005f9f
30-Day Money-Back Guarantee

Includes

4 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion