SQL 101 #93
Description
We should create a very basic guide to what SQL is and how we use SQL at the shed.
As a basis for this I spoke to the latest academy intake and together we came up with a list of things that might be useful to have as a start.
Fundementals
Join types, LEFT Vs INNER & APPLY ETC
Aggregation
Security, protecting PII, SQL injection, access and roles.
Performance
Basic understanding of how estimating the impact of running a query, is this a tadpole or whale query.
Simple ways of reducing the size of a query.
Introduction to Indexes
Db Type
Main providers and differences
NoSQL vs Trad SQL
When to use each
Different cloud offerings cosmos vs big query etc
ETL Design
Some examples of the types of ETL loads we have typically done for clients
Database design
Normalisation vs Dimensional
Key Value Pairs
Json
Where would you look you look for help
Geeks for geek website
Stack Overflow.
Don’t Panic / SQL Surfers
Misc
Data Retention -Costs / benefit & GDPR