PostgreSQL - Beginner to Advanced for Data Analytics

Learn Postgres while doing hands-on querying real world datasets specifically designed for data analytics
Free Download 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.
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
Homepage