ECBS 5146 SQL and Different Shapes of Data: Glossary

Key Points

Course intro. First steps in SQL.
  • #INTRO

  • #LOCAL ENVIRONMENT

  • #BASIC SQL

  • #YOUR FIRST DATABASE

  • #DUMPS

DB administration. Queries.
  • #ALTERING DB

  • #SECURITY

  • #DATA TYPES

  • #LOGICAL OPERATORS

  • #FILTERING

Aggregations.
  • #CONDITIONAL LOGIC

  • #AGGREGATING

  • #GROUPING

Data modeling. Joins.
  • #DATA MODELLING

  • #RELATIONAL DATASETS

  • #JOINS

Stored Procedures.
  • #STORED PROCEDURES

  • #REUSE CODE

  • #CLEANING DATA

Data warehouse architectures.
  • #DATA WAREHOUSE ARCHITECTURE

  • #VIEWS

  • #TRIGGERS

  • #ETL

  • #DATA MARTS

Different Shapes of Data. APIs.
  • #CSV

  • #XML

  • #JSON

  • #API

  • #POSTMAN

  • #EUROSTAT API

  • #WORLDBANK API

  • #NOAA CLIMATE DATA API

Command Line Exercises.
  • #BASH

  • #GIT BASH

  • #SENTIMENT ANALYSIS

Knime.
  • #DATA SCIENCE BY GARTNER

  • #KNIME

  • #EUROSTAT WORKFLOW

  • #CLIMATE WORKFLOW

Data Architecture Tradeoffs.
  • #SERVER ARCHITECTURES

  • #CLOUD

  • #SQL SWISSKNIFE

  • #NOSQL

  • #SCHEMALESS

  • #BEYOND TABULAR

NoSQL.
  • #BASE

  • #NOSQL FAMILIES

  • #JUPYTER NOTEBOOK

  • #REDIS

  • #MONGO

  • #SOLR

  • #NETWORK SCIENCE

  • #NEO4J

  • #PARADISE PAPERS