PostgreSQL Bootcamp: SQL and PostgreSQL Database Masterclass
3.8 (36 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.
2,838 students enrolled

PostgreSQL Bootcamp: SQL and PostgreSQL Database Masterclass

Become a Database Guru from Basic to Advance SQL PostgreSQL queries. Use SQL queries for Data analysis and Visualization
3.8 (36 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.
2,838 students enrolled
Created by Prathap G
Last updated 6/2019
English
English [Auto]
Current price: $51.99 Original price: $74.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6 hours on-demand video
  • 1 article
  • 48 downloadable resources
  • 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
  • How to Install PostgreSQL and PgAdmin 4
  • Retrieve the data using SQL queries.
  • Insert, update and delete data from tables in PostgreSQL.
  • Filtering, Grouping and slicing the data from the tables in PostgreSQL.
  • Various Built In functions in PostgreSQL.
  • Learn Data conversion functions in PostgreSQL.
  • Step by STEP approach in constructing a complex SQL queries.
  • Learn how to Join the data between various data sets.
  • Learn all the SET Operators in PostgreSQL.
  • Use the real Time NORTHWIND data set in the queries.
Requirements
  • No prerequisite software required. You should be able to use PC/laptop comfortably.
  • No Prior Knowledge of PostgreSQL required.
Description

*** This Course purchase includes video lectures, practice files, quizzes, & assignments, 1-on-1 instructor support, LIFETIME access and a 100%MONEY-BACK GUARANTEE***

Please note that this course will be continuously getting updated with more videos to keep you up to date on PostgreSQL. You will find lot of new lecture covering new features in the area of  PostgreSQL. Best part about this course is that, You can also demand a lecture on a specific topic of  PostgreSQL, which comes under the scope and I will make sure that the section on that Topic is added .

This course is designed for the beginners and freshers to gain knowledge on PostgreSQL and to use them in their projects/assignments. You will find different techniques to construct the SQL queries. The professionals who have zero knowledge or very less knowledge on SQL queries, will find this course extremely useful.

Learning SQL and PostgreSQL also helps you to become better data analyst and eventually would help you to get into the field of Data Science/ Data Analysis/ Data Visualization.

I will Guide you through a STEP by STEP approach on how to write SQL Queries. I will also explain about different ways to write very efficient SQL queries. I will first start with the installation of  PostgreSQL database and PgAdmin 4 and then will install the North wind database model. I will then start writing some of the Simple SQL Queries and then slowly move towards filtering, grouping  and slicing the data. Then, I will be working on more complicated topics like Joins, Operators, Inbuilt Functions and eventually by the end of the course you would be able to write complicated SQL queries.

You should be able to complete this course in a week time, if you dedicate 2 hours of your time daily and this journey will take you from zero to Hero.

Important Topics covered:

  • Installation of PostgreSQL and Pgadmin 4

  • What is a SQL and Database and its Background

  • Understanding the Northwind Data Model

  • Selecting the data from Tables

  • Filtering the data from Tables

    Usage of Arithmetic and Logical Operators

  • Understand the GROUP BY , HAVING

  • Understand Various SET Operators

  • Learn Various Joins in PostgreSQL

  • Step by Step approach in creation of Complex SQL Queries

  • Sorting of Data

  • String, Number In Built Functions

  • Data Conversion Functions

  • DML and DDL Statements

Briefly, The knowledge of SQL and PostgreSQL is a must for IT professionals and this course is one stop shop for gaining this necessary and in-demand skill.

Trust me, I will make sure you have an awesome learning experience and will hold your hand and take you step by step!!! 

Happy PostgreSQL Learning :-)

Who this course is for:
  • Beginner who want to learn DBMS/PostgreSQL management system.
  • Anyone with a basic knowledge of SQL, but is new to PostgreSQL.
  • Aspirants seeking career opportunities in RDMS Database and SQL.
  • DBA, Developers, Support Analyst who need to create PostgreSQL SQL queries in their day to day work.
  • Database developers interested in Data science.
Course content
Expand all 61 lectures 05:57:07
+ Introduction
5 lectures 32:40
Understand the NorthWind Data Model
07:01
pgAdmin and psql
07:20
Setting Up NorthWind Database
05:58
+ Retrieve data using SELECT statement
5 lectures 24:20
What is SELECT ?
03:31
Alias in SELECT
06:43
Literals in SELECT
03:41
Operations among Columns
06:27
Concatenation Operator
03:58
+ Data Filter in SELECT
7 lectures 40:23
Usage of Where Clause
04:39
Logical Operator (AND, OR, NOT)
05:13
BETWEEN Operator
06:31
IN , NOT IN Operators
05:56
Comparison Operators
04:16
LIMIT and FETCH Operators
04:00
+ Data Exploration using SELECT
3 lectures 11:48
DISTINCT CLause
04:15
Ordering the data
04:34
Handling NULL data
02:59
+ Joins
7 lectures 32:08
INNER Join
06:23
LEFT OUTER Join
04:19
RIGHT OUTER Join
04:53
FULL OUTER Join
05:27
SELF Join
05:01
CROSS Join
03:00
+ SET Operators
4 lectures 13:07
Basics of SET Operators
02:40
UNION Operator
05:16
INTERSECT Operator
02:56
EXCEPT Operator
02:15
+ Aggregate Function
2 lectures 13:34
What is Aggregate Function
03:12
SUM, AVG, COUNT, MAX, MIN
10:22
+ Group Data
2 lectures 15:51
Basics of Grouping data
03:25
Group By and Having
12:26
+ Build Complex Queries
1 lecture 16:51
How to construct complex queries
16:51
+ String and Number Built in Functions
10 lectures 58:10
Length, Lower , Upper Functions
05:05
Ltrim, Rtrim, Btrim, Trim Functions
09:19
InitCap, Left , Right Functions
05:22
Ascii, Chr, Concat, Concat_ws Functions
06:30
Strpos, Position Functions
02:59
Substring Function
06:28
Lpad, Rpad, Split_Part Functions
07:08
Repeat, Reverse Functions
02:28
Translate, Replace Functions
04:56
Numeric Functions
07:55