Please note that this course will be continuously getting
updated with more videos to keep you up to date on PostgreSQL. You
will find lot of new lecture covering new features in the area of
PostgreSQL. Best part about this course is that, You can also
demand a lecture on a specific topic of PostgreSQL, which comes
under the scope and I will make sure that the section on that Topic
is added .
This course is designed for the beginners and freshers to gain knowledge on PostgreSQL and to use them in their projects/assignments. You will find different techniques to construct the SQL queries. The professionals who have zero knowledge or very less knowledge on SQL queries, will find this course extremely useful.
Learning SQL and PostgreSQL also helps you to become better data analyst and eventually would help you to get into the field of Data Science/ Data Analysis/ Data Visualization.
I will Guide you through a STEP by STEP approach on how to write SQL Queries. I will also explain about different ways to write very efficient SQL queries. I will first start with the installation of PostgreSQL database and PgAdmin 4 and then will install the North wind database model. I will then start writing some of the Simple SQL Queries and then slowly move towards filtering, grouping and slicing the data. Then, I will be working on more complicated topics like Joins, Operators, Inbuilt Functions and eventually by the end of the course you would be able to write complicated SQL queries.
You should be able to complete this course in a week time, if you dedicate 2 hours of your time daily and this journey will take you from zero to Hero.
- Retrieve data using SELECT statement
- Data Filter in SELECT
- Data Exploration using SELECT
- SET Operators
- Aggregate Function
- Group Data
- Build Complex Queries
- String and Number Built in Functions
- Date Time Built In Functions
- Data Type Conversion Built In Functions
- Sub Query
- DML Operations
- BONUS Lecture: My other courses at Minimal price