Home Courses Instructor Labs

Complete Tutorial - SQL and PostgreSQL Database

(20 Ratings) 2242 Students Enrolled
Created By Ashok Kumar Last Updated Thu, 19-Mar-2020
  • Course Duration
    6 Hours
  • Mode of Training
    Self-Paced
  • Lessons
    59 Lessons
  • Placement Assistance
    Guaranteed
$ 99.99 $ 8.99 91% off 100% Money Back Guarantee
12k+ satisfied learners Read Reviews
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 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
  • 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
  • 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
  • Ordering the data 00:04:35
  • Handling NULL data 00:03:00
  • 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
  • Basics of SET Operators 00:02:40
  • UNION Operator 00:04:54
  • INTERSECT Operator 00:02:57
  • EXCEPT Operator 00:02:15
  • What is Aggregate Function 00:03:13
  • SUM, AVG, COUNT, MAX, MIN 00:10:22
  • Basics of Grouping data 00:03:25
  • Group By and Having 00:12:27
  • How to construct complex queries 00:16:52
  • 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
  • Current Date/Time Functions 00:06:48
  • Age, Timeofday Functions 00:07:14
  • Date_part, Extract, Date_Trunc Functions 00:10:04
  • 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, Exists, In Operators 00:09:24
  • ANY, ALL Operators 00:05:47
  • Insert Statement 00:08:16 Preview
  • Update Statement 00:06:22
  • Delete Statement 00:07:04
  • Commit and Rollback Statements 00:07:27

Complete Tutorial - SQL and PostgreSQL Database