PostgreSQL Beginner to Advanced for Data Analytics
What you’ll learn
Ability to solve business problems through data oriented analytical approaches
Postgres SQL best practices
An understanding on how the real world datasets and solutions looks like for data analysts
Focused learning – Top 20% concepts which drives 80% value
Interactive assignments, quizzes and downloadable SQL files
Requirements
No programming experience needed
Basic understanding of the data analytics field
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.
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 SQL use case in Analytics
Section 2: Setting up the environment
Lecture 3 Installing Postgres for Windows
Lecture 4 PGAdmin 4 walkthrough
Lecture 5 Load the csv files for sample dataset
Section 3: Beginners
Lecture 6 SELECT, FROM and LIMIT keyword
Lecture 7 CREATE and INSERT command
Lecture 8 WHERE keyword
Lecture 9 ORDER BY, LIMIT and FETCH keyword
Lecture 10 GROUP BY and HAVING command
Lecture 11 Use case – Finding the granularity of any table
Lecture 12 JOINS in Postgres
Lecture 13 UNION, UNION ALL, INTERSECT and EXCEPT commands
Lecture 14 Writing sequence and Execution sequence
Section 4: Intermediate
Lecture 15 CASE WHEN statements
Lecture 16 Use case – Careful while using WHERE with OUTER JOINS
Lecture 17 Subqueries in Postgres
Lecture 18 Use case – CROSS JOINS
Lecture 19 SELF JOIN and NATURAL JOIN
Lecture 20 GROUPING SETS, CUBE and ROLLUP commands
Lecture 21 Window Functions
Lecture 22 Use case – Finding the Mean, Median and Mode
Lecture 23 Use case – Lag and Lead Window functions
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
Course Information:
Udemy | English | 4h 16m | 2.00 GB
Created by: Shakti Jajpura
You Can See More Courses in the Developer >> Greetings from CourseDown.com