Mastering SQL using Postgresql
Learn key SQL concepts such as how to create database objects, write effective queries and many more
4.40 (256 reviews)
29,036
students
9.5 hours
content
Sep 2022
last update
$69.99
regular price
What you will 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
Related Topics
3663356
udemy ID
11/27/2020
course created date
12/9/2020
course indexed date
Bot
course submited by