Learn key SQL concepts such as how to create database objects, write effective queries and many more
Sub Category
- Other IT & Software
{inAds}
Objectives
- 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
Pre Requisites
- Computer with decent configuration (At least 4 GB RAM and Dual Core, 8 GB RAM and Quad Core is highly desired)
- Any standard browser (preferably Chrome)
- High Speed Internet
- Engineering or Science Degree
- Ability to use computer
- Knowledge or working experience with databases is highly desired
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)