Setup Ubuntu VM on GCP Using Docker to Learn Python and SQL

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn how to set up a comprehensive development environment for Python and SQL using an Ubuntu 18.04 VM on Google Cloud Platform (GCP) with Docker. Gain hands-on experience in cloud computing, virtualization, and containerization while setting up essential tools like Jupyter Lab and PostgreSQL. Explore GCP's web console, pricing, and firewall configurations, and master Docker basics for efficient container management. Install and configure Python tools, set up a PostgreSQL database using Docker, and learn to access it through various interfaces including Docker CLI, SQL Workbench, and Jupyter Lab. By the end of this tutorial, you'll have a fully functional environment ready for diving deeper into Python programming and SQL mastery.

Syllabus

Setup Ubuntu VM on GCP - Signing up for GCP.
Setup Ubuntu VM on GCP - Overview of GCP Web Console.
Setup Ubuntu VM on GCP - Overview of GCP Pricing.
Setup Ubuntu VM on GCP - Provision Ubuntu VM from GCP.
Setup Ubuntu VM on GCP - Setup Docker.
Setup Ubuntu VM on GCP - Validating Python.
Setup Ubuntu VM on GCP - Setup Jupyter Lab.
Setup Postgres Database - Introduction.
Setup Postgres Database - Docker Cheat Sheet.
Setup Postgres Database - Setup Postgres using Docker.
Setup Postgres Database - Accessing Postgres using Docker CLI.
Setup Postgres Database - Create Database and User.
Setup Postgres Database - Execute SQL Scripts.
Mastering SQL - Postgresql - Getting Started - Setup SQL Workbench.
Setup Postgres Database - SQL Workbench and Postgres.
Mastering SQL - Postgresql - Getting Started - SQL Workbench Features.
Setup Postgres Database - Jupyter Lab and Postgresql.