Setup SQL Workbench¶ Let us understand how to setup and use SQL Workbench.Why SQL Workbench Let us see the details why we might have to use SQL Workbench. Using Database CLIs such as psql for postgres, mysql etc can be cumbersome for those who are not comfortable with command line interfaces. Database IDEs such as …
Setup Postgres using Docker¶ In some cases you might want to have postgres setup on your machine. Let us understand how we can setup Postgres using Docker. If you are using our labs, the database will be pre-created by us with all the right permissions. If you are using Windows or Mac, ensure that you …
Using psql¶ Let us understand how to use psql utility to perform database operations. psql is command line utility to connect to the Postgres database server. It is typically used for the following by advanced Database users: Manage Databases Manage Tables Load data into tables for testing purposes We need to have at least Postgres …
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 …
Accessing Elements – tuples¶ Let us see details related to operations on tuples. Unlike other collections (list, set, dict) we have limited functions with tuple in Python. In [2]: %%HTML <iframe width=”560″ height=”315″ src=”https://www.youtube.com/embed/fZ-QOUk-ia4?rel=0&controls=1&showinfo=0″ frameborder=”0″ allowfullscreen></iframe> tuple is by definition immutable and hence we will not be able to add elements to a tuple or delete …
