SQL and PostgreSQL using pgAdmin4 : Beginner to Expert

About this course

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 courseAfter 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