PostgreSQL - Complete beginner to advanced course

Focused View

Shakti Jajpura

4:15:44

189 View

1. Introduction

1. Introduction.mp4

02:29

2. SQL use case in Analytics.mp4

02:28

2. Setting up the environment

1. Installing Postgres for Windows.mp4

03:41

2. PGAdmin 4 walkthrough.mp4

09:53

3.1 All sample data files.zip

3.2 loading sample dataset.zip

3. Load the csv files for sample dataset.mp4

13:01

3. Beginners

1.1 select keyword.zip

1. SELECT, FROM and LIMIT keyword.mp4

17:26

2.1 create table keyword.zip

2. CREATE and INSERT command.mp4

37:18

3.1 where keyword.zip

3. WHERE keyword.mp4

17:30

4.1 order by and limit clause.zip

4. ORDER BY, LIMIT and FETCH keyword.mp4

08:33

5. Practice Assignment 1.html

6.1 group by and having clause.zip

6. GROUP BY and HAVING command.mp4

09:58

7.1 use case - finding granularity of any table.zip

7. Use case - Finding the granularity of any table.mp4

07:44

8.1 joins.zip

8. JOINS in Postgres.mp4

29:05

9.1 union and union all.zip

9. UNION, UNION ALL, INTERSECT and EXCEPT commands.mp4

13:27

10. Writing sequence and Execution sequence.mp4

05:38

11. Practice Assignment 2.html

4. Intermediate

1.1 case when statements.zip

1. CASE WHEN statements.mp4

09:18

2.1 careful while using where with left join.zip

2. Use case - Careful while using WHERE with OUTER JOINS.mp4

08:22

3.1 subqueries and exists, all, any keywords.zip

3. Subqueries in Postgres.mp4

10:27

4.1 cross join use case.zip

4. Use case - CROSS JOINS.mp4

11:46

5.1 self join and natural join.zip

5. SELF JOIN and NATURAL JOIN.mp4

05:44

6.1 grouping sets.zip

6. GROUPING SETS, CUBE and ROLLUP commands.mp4

11:03

7.1 window functions.zip

7. Window Functions.mp4

09:57

8.1 mode and median.zip

8. Use case - Finding the Mean, Median and Mode.mp4

04:47

9.1 lead and lag use case.zip

9. Use case - Lag and Lead Window functions.mp4

06:09

Description

Focused on practical problem solving using PostgreSQL/ postgres. Learn through real time use cases and sample datasets

What You'll Learn?

Solving analytics use cases through Postgres
Specific set of operations focused by analytics professionals
Beginner commands - SELECT, CREATE, WHERE, GROUP BY, etc.
Joins with analytics use cases
Grouping sets, CUBE and ROLLUP
Window functions
Query troubleshooting
Query optimization
Postgres coding best practices
Subqueries - ALL, ANY, EXISTS commands
Triggers
Views

Who is this for?

Anyone interested about analytics and urge to get practical hands-on work on Postgres

Separate sections for Beginners, Intermediate, Expert is created for students to choose from

More details

Description
This course is intended for anyone willing to get a good hands-on experience with PostgreSQL.
The aim to have all the concepts clarified, and at the same time, keeping the content very interactive. The datasets we consider for all our hands-on work is very practical in nature. The assignment are designed in such a way to give you an idea of exact problems that the analytics professionals face on day-to-day basis. Therefore, the course will serve as a way to gain problem solving capabilities as an added benefit.
After successful completion of this course, you will be able to translate business problem statements into data driven solutions. For example, if there is a requirement to look at past year performance, you know exactly what KPI needs to be looked at using the data available.

Tools required - (1) PGAdmin 4, (2) PostgreSQL. There is a dedicated section in this course on setting up the environment.
The whole course is majorly divided into 3 sections - Beginners, Intermediate and Expert. Based on the current level of experience you have, you can choose to start from either of these and to also jump between sections as needed. There is negligible dependency between the lectures so you can focus on your specific learning goals rather than focusing on everything.

There is no prior coding experience mandatorily required to start this course. Only the motivation to learn is enough :)
Make the most use of the available Udemy tools like Q&A, Assignment, Notes, etc. to clarify the doubts and self evaluate.
Who this course is for:
Anyone interested about analytics and urge to get practical hands-on work on Postgres
Separate sections for Beginners, Intermediate, Expert is created for students to choose from

User Reviews

Rating

average 0

Total votes0

Focused display

Analytics professional with overall 5 years of work experience in Data Warehousing, Analytics and Data Science. Has good working knowledge of major analytics tools like SQL, Tableau, R and PythonDomain expertise in Retail, Marketing, E-commerce and App analytics. Helped multiple clients on their analytical requirements over the years.Believes is helping the community by sharing my knowledge and learning from others at the same time.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.