PostgreSQL For Beginners

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 6.5 Hours | Lec: 62 | 645 MB

Genre: eLearning | Language: English

Learn PostgreSQL quickly with Practical Hands-On Easy to Follow Videos

PostgreSQL is commonly known as Postgres and it is also open source database. In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of joining tables to retrieve data and much more.

The course also covers the basics of creating tables, storing data with data types, and working with expressions, operators, and strings.

Topics include:

Installing PostgreSQL

Verify postgresql installation

postgresql INSERT Statement

Postgres UNIQUE Constraints

Postgres Truncate statement

Postgres UPDATE

Postgresql INNER JOIN

Removing Duplicate Records

Postgres LIKE Operator

Postgresql OR Operator

Sorting Data

Server service

Sequences

Schema

Retrieving all Data from Table

Query Data fro specific column

Loading sample database

Postgresql DELETE Statement

Postgresql DATA Types

Postgresql CREATE Table Statement

Postgresql SubQuery

Postgresql UNION Operator

PostgreSQL ORDER BY clause

PostgreSQL UNION ALL Operator

PostgreSQL GROUP BY clause

PostgreSQL FULL OUTER JOIN

PostgreSQL CROSS JOIN

PostgreSQL combining AND | OR Operator

PostgreSQL AND Operator

PostgreSQL BETWEEN Operator

PostgreSQL NATURAL JOIN Operator

PostgreSQL SELECT statement

CRUD Operations

PostgreSQL EXCEPT Operator

Create a Database with PG4ADMIN

Create a Table with PG4ADMIN

PostgreSQL NOT Operator

PostgreSQL NOT BETWEEN Operator

PostgreSQL LIMIT Operator

PostgreSQL INTERSECT Operator

PostgreSQL Left Join

PostgreSQL IN Operator

PostgreSQL HAVING clause

Comparison operators

Cast and Operators

Filtering Data with WHERE clause

This is a practical hands-on course that will equip you with the skills and confidence to work with PostgreSQL .