Connecting to Database¶ We will be using JupyterHub based environment to master Postgresql. Let us go through the steps involved to get started using JupyterHub environment. We will use Python Kernel with sql magic command and for that we need to first load the sql extension. Create environment variable DATABASE_URL using SQL Alchemy format. Write …
Getting Started¶ As part of this section we will primarily understand different ways to get started with Postgres. Connecting to Database Using psql Setup Postgres using Docker Setup SQL Workbench SQL Workbench and Postgres SQL Workbench Features Data Loading Utilities Loading Data – Docker Exercise – Loading Data Here are the key objectives of this …
Exercises – Managing Database Objects¶ This exercise is primarily to assess your capabilities related to put all important DDL concepts in practice by coming up with solution for a typical data migration problem from one database (mysql) to another (postgres). Here are the high level steps for database migration from one type of database to …
Exercises – Managing Database Objects using Postgresql Read More »
Managing Database Objects¶ This exercise is primarily to assess your capabilities related to put all important DDL concepts in practice by coming up with solution for a typical data migration problem from one database (mysql) to another (postgres). Here are the high level steps for database migration from one type of database to another type …
Solutions – Managing Database Objects in Postgresql Read More »
Basic SQL Queries¶ Here are some of the exercises for which you can write SQL queries to self evaluate. Ensure that we have required database and user for retail data. We might provide the database as part of our labs. Here are the instructions to use psql for setting up the required database (if required) …
Solutions – Writing Basic SQL Queries using Postgresql Read More »
Analytics Functions¶ Let us take care of the exercises related to analytics functions. We will be using HR database for the same. Get all the employees who is making more than average salary with in each department. Get cumulative salary for one of the department along with department name. Get top 3 paid employees with …
Exercises – SQL Analytics or Windowing Functions using Postgresql Read More »
