Skip to content

Instantly share code, notes, and snippets.

@mark-walle
mark-walle / 01-Understanding_SQL_Sublanguages.md
Last active May 30, 2022 20:28
Querying Data with SQL from PostgreSQL
  1. DDL: Data Definition Language
  2. DCL: Data Control Language
  3. DQL: Data Query Language
  4. DML: Data Manipulation Language
  5. DTL: Data Transaction Language

1. DDL: Data Definition Language

DDL is the first steps in every database creation as they define the objects that will contain and manage the data and server-side code.

@mark-walle
mark-walle / Scala Essential Training for Data Science.md
Last active April 3, 2020 18:20
Scala Essential Training for Data Science - Notes from Section 1 - Introduction to Scala - https://www.lynda.com/Scala-tutorials/Scala-Essential-Training-Data-Science/559182-2.html

Scala Essential Training for Data Science

Below are notes taken for the "Scala Essential Training for Data Science": https://www.lynda.com/Scala-tutorials/Scala-Essential-Training-Data-Science/559182-2.html

In this course we will need to install Scala, Postgres, and Spark. The Lynda course we will be following along with provides manual installation instructions that do not use tools package management tools. To simplify installations directions, I encourage using a command line based package management tool. On MacOS there is Homebrew (https://brew.sh/), in Windows there is Chocolatey (https://chocolatey.org/), and on Linux distributions there is SDKMAN! (https://sdkman.io/) and on Debian based systems APT (https://wiki.debian.org/AptCLI).

In the case of Linux users, I will provide SDKMAN! installation instructions in some cases, and APT instructions in others, depending on which is more straightforwar