This repo is a knowledge base for SQL with example
Structure
- Overview of databases (i.e. what is a database and examples that exist)
- Types of databases (hisotry of DBs db2, relational, cloud warehouse, OLAP, nosql, etc)
- SQL Standard & Implementation & Dialects / language
Locally
- Install, setup, secure, and deploy DB
- Administer example DB ... create schemas,tables, views, functions, etc ... develop DB using automation
Cloud
- OLTP hosted in the cloud
- TB platform
Purpose:
- the purpose is to talk about the past, present, and future of SQL and databases
Visuals:
- Current Database landscape