Mastering SQL using Postgresql

Mastering SQL using Postgresql

What you’ll learn

  • 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
Deal Score0
External links may contain affiliate links, meaning we get a commission if you decide to make a purchase