SQL and PostgreSQL using pgAdmin4 : Beginner to Expert

SQL and PostgreSQL using pgAdmin4 : Beginner to Expert, available at $44.99, has an average rating of 4.17, with 26 lectures, based on 6 reviews, and has 21 subscribers.

You will learn about Solving real-world data analytics use cases through Postgres PGAdmin4 tool detailed walkthrough Beginner commands – SELECT, LIMIT, CREATE, INSERT, WHERE, GROUP BY, ORDER BY, LIMIT, FETCH, HAVING Joins – LEFT, RIGHT, INNER, FULL OUTER, CROSS JOIN, SELF JOIN, NATURAL JOIN Grouping sets, CUBE and ROLLUP UNION, UNION ALL, INTERSECT, EXCEPT Writing sequence and Execution sequence of the codes CASE WHEN statements Subqueries – ALL, ANY, EXISTS commands Window functions – NTILE, LAG, LEAD, ROW_NUMBER, FIRST_VALUE Postgres coding best practices Date Functions Partitioned Tables CTE (Common Table Expressions) Views Triggers Query troubleshooting Query optimization This course is ideal for individuals who are Anyone willing to get a good hands-on experience with PostgreSQL. or Are working, or are interested in working in the data analytics industry or related field. or Those who wants to learn the SQL concepts by solving real-world business problems and not just hypothetical problems. It is particularly useful for Anyone willing to get a good hands-on experience with PostgreSQL. or Are working, or are interested in working in the data analytics industry or related field. or Those who wants to learn the SQL concepts by solving real-world business problems and not just hypothetical problems.

Enroll now: SQL and PostgreSQL using pgAdmin4 : Beginner to Expert

Summary

Title: SQL and PostgreSQL using pgAdmin4 : Beginner to Expert

Price: $44.99

Average Rating: 4.17

Number of Lectures: 26

Number of Published Lectures: 26

Number of Curriculum Items: 29

Number of Published Curriculum Objects: 29

Original Price: ₹799

Quality Status: approved

Status: Live

What You Will Learn

Solving real-world data analytics use cases through Postgres
PGAdmin4 tool detailed walkthrough
Beginner commands – SELECT, LIMIT, CREATE, INSERT, WHERE, GROUP BY, ORDER BY, LIMIT, FETCH, HAVING
Joins – LEFT, RIGHT, INNER, FULL OUTER, CROSS JOIN, SELF JOIN, NATURAL JOIN
Grouping sets, CUBE and ROLLUP
UNION, UNION ALL, INTERSECT, EXCEPT
Writing sequence and Execution sequence of the codes
CASE WHEN statements
Subqueries – ALL, ANY, EXISTS commands
Window functions – NTILE, LAG, LEAD, ROW_NUMBER, FIRST_VALUE
Postgres coding best practices
Date Functions
Partitioned Tables
CTE (Common Table Expressions)
Views
Triggers
Query troubleshooting
Query optimization

Who Should Attend

Anyone willing to get a good hands-on experience with PostgreSQL.
Are working, or are interested in working in the data analytics industry or related field.
Those who wants to learn the SQL concepts by solving real-world business problems and not just hypothetical problems.

Target Audiences

Anyone willing to get a good hands-on experience with PostgreSQL.
Are working, or are interested in working in the data analytics industry or related field.
Those who wants to learn the SQL concepts by solving real-world business problems and not just hypothetical problems.

This course is intended for –

Anyone willing to get a good hands-on experience with PostgreSQL (postgres is short).
Are working, or are interested in working in the data analytics or related industry.
Those who wants to learn the SQL concepts by solving real-world business problems and not just hypothetical problems.
People who wants to gain expertise to dive into data and extract important findings.
There is no prior coding experience mandatorily required to start this course. Only the motivation to learn is enough 🙂

The aim to have all the concepts clarified, and at the same time, keeping the content very interactive.

The datasets considered is very practical in nature.
The assignment are designed in such a way, to give an idea of exact problems that the analytics professionals face on day-to-day basis.
Downloadable SQL files are attached with all the lessons. This will save time re-writing the codes.
The course will serve as a way to gain problem solving capabilities.
My learnings from last 7 years working in data analytics industry has been tutored in this course

After successful completion of this course –

You will be able to translate business problem statements into data driven solutions. For example, if someone asks you a use case of cross join, you can elaborate in very concise and practical way.
You will be much more confident using SQL irrespective of the database you work on.

Tools required –

PGAdmin 4,
PostgreSQL.

(There is a dedicated section in this course on setting up the environment and loading the sample dataset).

The course structure is divided into 3 sections –

Beginners,
Intermediate
Advance.

Based on the current level of experience, you can choose to start from either of these and to also jump between sections or lectures as you seem fit. There is no dependency between the lectures so you can focus on your specific learning goals.

We’ve included the SQL script file which is showcased in the lecture. Use these to save time re-writing the codes.

Make the most use of the available Udemy tools like Q&A, Assignment, Notes. to clarify the doubts and self evaluate.

I would also like to hear the feedback on this course to make it even better and more exhaustive with regular updates. Please provide feedbacks via ratings, reviews or direct messages.

We aim for 100% student satisfaction, you can request a 30-day refund if you are not satisfied with the course material.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to the course Structure and learning outcomes

Lecture 2: PostgreSQL use case in Analytics – How analysts use SQL on a day-to-day basis

Chapter 2: Setting up the environment

Lecture 1: Installing Postgres and PGAdmin4 for Windows

Lecture 2: PGAdmin 4 walkthrough

Chapter 3: Load sample datasets – Retail dataset

Lecture 1: Load the csv files for sample dataset and start hands-on

Chapter 4: Beginners

Lecture 1: SELECT, FROM and LIMIT keyword

Lecture 2: CREATE and INSERT command

Lecture 3: WHERE keyword

Lecture 4: ORDER BY, LIMIT and FETCH keyword

Lecture 5: GROUP BY and HAVING command

Lecture 6: Use case – Finding the granularity of any table

Lecture 7: JOINS in Postgres

Lecture 8: UNION, UNION ALL, INTERSECT and EXCEPT commands

Lecture 9: Writing sequence and Execution sequence

Chapter 5: Intermediate

Lecture 1: CASE WHEN statements

Lecture 2: Use case – Careful while using WHERE with OUTER JOINS

Lecture 3: Subqueries in Postgres

Lecture 4: Use case – CROSS JOINS

Lecture 5: SELF JOIN and NATURAL JOIN

Lecture 6: GROUPING SETS, CUBE and ROLLUP commands

Lecture 7: Window Functions

Lecture 8: Use case – Finding the Mean, Median and Mode

Lecture 9: Use case – Lag and Lead Window functions

Chapter 6: Advanced

Lecture 1: Date Functions

Lecture 2: CTE (Common Table Expressions)

Lecture 3: Partitioned Tables

Instructors

Shakti Jajpura
Analytics professional

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 2 votes
5 stars: 2 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!

Menu