Complete Tutorial - SQL and PostgreSQL Database

What Will I Learn?

Learn how to install PostgreSQL and PgAdmin 4
Insert, Delete and Update data from the tables in PostgreSQL
Learn how to Retrieve data from the tables
Filtering, Grouping and Slicing the data from the tables in PostgreSQL
Learn the data conversion functions in PostgreSQL
Learn how to write complex SQL queries
Understand the Joins in database tables
Learn all the SET Operators in PostgreSQL

Requirements

Basic Computer Knowledge

+ View More

Description

This course is mainly designed for the beginners to gain knowledge on PostgreSQL. In this course, you will be learning how to write SQL queries in step by step. Learn different ways to write efficient SQL queries.

In this course, we will install PostgreSQL database, PgAdmin 4 and finally install North wind database model. We will start this course by writing simple SQL queries and then will see how to do filtering, grouping, slicing the data and looking into more complicated topics like joins, operators and inbuilt functions.

The following topics are covered in this course:

Installation of PostgreSQL and PgAdmin 4
SQL and Database
Understandings of North wind data model
Selecting the data from tables
Filtering the data from tables
Arithmetic and Logical operators
Understand the GROUP BY and HAVING
Understand the various SET operations
Learn Joins and PostgreSQL
Writing complex queries
Sorting of Data
String, Number in built functions
Data Conversion functions
DML and DDL statements

Curriculum For This Course

59 Lessons 6 Hours

Introduction

5 Lessons 00:32:43 Hours

Introduction to PostgreSQL 00:06:35 Preview
Understand the NorthWind Data Model 00:07:02
Install PostgreSQL 00:05:48 Preview
pgAdmin and psql 00:07:20
Setting Up NorthWind Database 00:05:58

Retrieve data using SELECT statement

5 Lessons 00:24:21 Hours

What is SELECT ? 00:03:32
Alias in SELECT 00:06:43
Literals in SELECT 00:03:41
Operations among Columns 00:06:27
Concatenation Operator 00:03:58

Data Filter in SELECT

7 Lessons 00:40:26 Hours

Usage of Where Clause 00:04:39 Preview
Logical Operator (AND, OR, NOT) 00:05:13
LIKE Operator 00:09:49
BETWEEN Operator 00:06:32
IN , NOT IN Operators 00:05:56
Comparison Operators 00:04:17
LIMIT and FETCH Operators 00:04:00

Data Exploration using SELECT

2 Lessons 00:07:35 Hours

Ordering the data 00:04:35
Handling NULL data 00:03:00

Joins

7 Lessons 00:32:11 Hours

What is JOIN? 00:03:06 Preview
INNER Join 00:06:23
LEFT OUTER Join 00:04:20
RIGHT OUTER Join 00:04:54
FULL OUTER Join 00:05:27
SELF Join 00:05:01
CROSS Join 00:03:00

SET Operators

4 Lessons 00:12:46 Hours

Basics of SET Operators 00:02:40
UNION Operator 00:04:54
INTERSECT Operator 00:02:57
EXCEPT Operator 00:02:15

Aggregate Function

2 Lessons 00:13:35 Hours

What is Aggregate Function 00:03:13
SUM, AVG, COUNT, MAX, MIN 00:10:22

Group Data

2 Lessons 00:15:52 Hours

Basics of Grouping data 00:03:25
Group By and Having 00:12:27

Build Complex Queries

1 Lessons 00:16:52 Hours

How to construct complex queries 00:16:52

String and Number Built in Functions

10 Lessons 00:58:15 Hours

Length, Lower , Upper Functions 00:05:05
Ltrim, Rtrim, Btrim, Trim Functions 00:09:20
InitCap, Left , Right Functions 00:05:23
Ascii, Chr, Concat, Concat_ws Functions 00:06:30
Strpos, Position Functions 00:02:59
Substring Function 00:06:29
Lpad, Rpad, Split_Part Functions 00:07:09
Repeat, Reverse Functions 00:02:28
Translate, Replace Functions 00:04:56
Numeric Functions 00:07:56

Date Time Built In Functions

3 Lessons 00:24:06 Hours

Current Date/Time Functions 00:06:48
Age, Timeofday Functions 00:07:14
Date_part, Extract, Date_Trunc Functions 00:10:04

Data Type Conversion Built In Functions

5 Lessons 00:29:39 Hours

Cast Function 00:05:24
To_date Function 00:08:57
To_Char Function 00:06:39
To_Number Function 00:03:50
To_Timestamp Function 00:04:49

Sub Query

2 Lessons 00:15:11 Hours

Sub Query, Exists, In Operators 00:09:24
ANY, ALL Operators 00:05:47

DML Operations

4 Lessons 00:29:09 Hours

Insert Statement 00:08:16 Preview
Update Statement 00:06:22
Delete Statement 00:07:04
Commit and Rollback Statements 00:07:27

Related Courses

Linux command line tutorial - ...

Renjith Nair

Free

Master Python 3 Programming

ramya

$ 200$ 9.99

Master Golang Programming

ramya

$ 200$ 14.99

Master Ethical Hacking

Spark Databox

$ 200$ 9.99

Adobe Photoshop Lightroom Clas...

ramya

$ 54$ 20

Complete Android app developme...

Spark Databox

$ 200$ 9.99

Python Complete reference : Go...

Prabhu Y

$ 94.99$ 13

SDN Practical Hands On Trainin...

Prabhu Y

$ 99$ 9.99

Data Structures & Algorithms i...

Deepika S

$ 129.99$ 9.99

Docker for DevOps

Michael John

$ 149.99$ 12.99

Data Science with Python

Harish Gowda

$ 199.99$ 11.99

The Container, Kubernetes and ...

Sam Johnson

$ 199.99$ 14.99

UiPath Handson on Enterprise R...

Michael Jordan

$ 199.99$ 47

Informatica PowerCenter Traini...

Prerana Krishna

$ 149.99$ 14.99

Mulesoft ESB Training

Kenny James

$ 119.99$ 9.99

Master Devops Online Training

Ajay Prabhakar

$ 94.99$ 8.99

Linux System Programming - A p...

Mohan Parasuram

$ 49.99$ 11.99

Complete Tutorial - SQL and PostgreSQL Database