Complete SQL Bootcamp using PostgreSQL.

Learn initial SQL concepts, and then move to different real worldSQL case studies specifically designed for this course.
Instructor:
Gaurav Chauhan
457 students enrolled
English [Auto-generated]
Good Understanding of database management system concepts
Added Advantage in professional career towards the field of data analytics.
Lifetime access to lectures, E-Books and Practices files.
SQL - Basics
Real World Case Studies to help you practice SQL skills
PostgreSQL

Learn how to use SQL quickly and effectively with this course with PostgreSQL database management system.

You’ll learn how to read and write complex queries to a database PostgreSQL using one of the most in demand skills – SQL. These skills are also applicable to any other major SQL database, such as

– MySQL,

– Microsoft SQL Server,

– Amazon Redshift,

– Oracle

– Hadoop

– IBM DB2 and many more…

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you’ll learn quickly and receive challenges and tests along the way to improve your understanding!

Who this course is for:

  • Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis!

Introduction

1
Introduction
2
Setting up PostGreSQL
3
*** Udemy Review Update ***
4
Course files

PostgreSQL Import & PgAdmin Overview

1
PgAdmin 4 Overview

shows you PgAdmin 4 Overview

2
Import Database in PostgreSQL

Import Database in PostgreSQL

Query Data Using PostgreSQL

1
SELECT

shows you how to query data from a single table.

2
SELECT - Code
3
ORDER BY

guides you how to sort the result set returned from a query.

4
ORDER BY - Code
5
SELECT DISTINCT

provides you a clause that removes duplicate rows in the result set.

6
DISTINCT - Code

Filtering data in PostGreSQL

1
WHERE

filters rows based on a specified condition.

2
WHERE - CODE
3
LIMIT

gets a subset of rows generated by a query.

4
LIMIT-CODE
5
FETCH
6
FETCH-Code
7
LIKE

filters data based on pattern matching.

8
LIKE-Code
9
IN

selects data that matches any value in a list of values.

10
IN - Code
11
BETWEEN and ALIAS- AS

selects data that is a range of values.

12
BETWEEN , ALIAS - AS - Code
13
IS NULL

checks if a value is null or not.

14
IS NULL - Code

Joining multiple tables

1
JOINS INTUITION
2
JOINS INTUITION - Code
3
INNER JOIN

selects rows from one table that have the corresponding rows in other tables.

4
INNER JOIN - Code
5
LEFT JOIN

selects rows from one table that may or may not have the corresponding rows in other tables.

6
LEFT JOIN- Code
7
RIGHT JOIN

joins a table to itself by comparing a table to itself.

8
FULL OUTER JOIN

uses the full join to find a row in a table that does not have a matching row in another table.

9
FULL OUTER JOIN - Code

joins two or more tables using implicit join condition based on the common column names in the joined tables.

Grouping data in PostGreSQL

1
GROUP BY
2
GROUP BY- Code
3
HAVING CLAUSE

applies the condition for groups.

4
HAVING - Code

Performing Set Operations in PostGreSQL

1
UNION

combines result sets of multiple queries into a single result set.

2
UNION - Code
3
INTERSECT

combines the result sets of two or more queries and returns a single result set that has the rows appear in both result sets.

4
INTERSECT - Code
5
EXCEPT

returns the rows in the first query that does not appear in the output of the second query.

6
EXCEPT - Code
7
Grouping Sets

generate multiple grouping sets in reporting.

8
Grouping Sets - Code

Subquery in PostGreSQL

1
SUBQUERY

writes a query nested inside another query.

2
SUBQUERY - Code

query data by comparing a value with a list of values returned by a subquery.

3
SUBQUERY ANY,ALL,EXISTS Operator

retrieves data by comparing a value with a set of values returned by a subquery.

4
SUBQUERY ANY,ALL,EXISTS Operator - Code

Modifying data in PostGreSQL

1
INSERT

inserts data into a table.

2
INSERT - Code
3
UPDATE CLAUSE

updates existing data in a table.

4
UPDATE CLAUSE - Code
5
UPDATE JOIN

updates values in a table based on values in another table.

6
UPDATE JOIN- Code
7
DELETE CLAUSE

deletes data in a table.

Managing Tables

1
Data types

covers the most commonly used PostgreSQL data types.

2
CREATE TABLE, SELECT INTO & CREATE TABLE AS

guides you how to create a new table in the database.

3
ALTER TABLE - RENAME, ADD, DROP COLUMN, Change Column Data Type

changes structure of an existing table.

4
ALTER TABLE Code

adds logic to check value based on a Boolean expression.

Understanding PostgreSQL constraints

1
PRIMARY KEY

illustrates how to define a primary key when creating a table or add a primary key to an existing table.

2
FOREIGN KEY

shows you how to define foreign key constraints when creating a new table or add foreign key constraints for existing tables.

3
CONSTRAINTS

PostgreSQL in-built functions

1
Aggregate Functions - Average,Count
2
Aggregate Functions - Min, Max, Sum
3
Aggregate Functions Lecture - Code
4
Time and Date Functions

PostgreSQL date functions that allow you to manipulate date and time values more effectively.

5
Time and Date Functions - Code

PostgreSQL date functions that allow you to manipulate date and time values more effectively.

6
String Functions

PostgreSQL string functions that allow you to manipulate string data effectively.

7
String Functions - Code

PostgreSQL string functions that allow you to manipulate string data effectively.

8
Math Functions
9
Math Functions -Code

SQL Case Study One

1
SQL Case Study One Overview
2
Case Study One Schema
3
Case Study One - Questions
4
Case Study One - Solution Overview
5
Case Study One - Solutions

SQL Case Study Two

1
SQL Case Study Two Overview
2
Case Study Two Schema
3
Case Study Two - Questions
4
Case Study Two - Solution Overview
5
Case Study Two - Solutions
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!

Be the first to add a review.

Please, login to leave a review
39b2d1e5be4ec431ea1b9605b6df10e0
30-Day Money-Back Guarantee

Includes

6 hours on-demand video
43 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion