Mastering SQL using Postgresql

• Setup Postgres Database using Docker
• Connect to Postgres using different interfaces such as psql, SQL Workbench, Jupyter with SQL magic etc.
• Understand utilities to load the data
• Performing CRUD or DML Operations
• Writing basic SQL Queries such as filtering, joins, aggregations, sorting etc
• Creating tables, constraints and indexes
• Different partitioning strategies while creating tables
• Using pre-defined functions provided by Postgresql
• Writing advanced SQL queries using analytic functions

Who this course is for:

• College students and entry level professionals to get hands on expertise with respect to SQL to be prepared for the interviews.
• Experienced application developers to understand key aspects of Databases to improve their productivity.
• Data Engineers and Data Warehouse Developers to understand the relevance of SQL and other key concepts.
• Testers to improve their query writing abilities to validate data in the tables as part of running their test cases.
• Business Analysts to write ad-hoc queries to understand data better or troubleshoot data quality issues.
• Any other hands on IT Professional who want to improve their query writing and tuning capabilities.