New Dawn โ Day 7 ๐ฑ
Closing week one of SQL:
โ FETCH: works like LIMIT, restricts rows returned
โ WHERE: selects specific rows based on a condition
From not knowing what a token was, to writing full queries.
Week 1: done. โ
#dataEngineering#SQL
New Dawn โ Day 5 ๐ฑ
Went back to fundamentals today.
A database = structured collection of data, stored to be efficient, retrievable, shareable, and analyzable.
SQL has 3 parts: DDL (structure), DML (querying), DCL (access).
Every SQL statement = verb + subject + condition:
New Dawn โ Day 6 ๐ฑ
Controlling what comes back from a query:
DISTINCT - returns only unique values from a column
LIMIT - caps how many rows are returned
OFFSET - skips a number of rows first (optional)
One step at a time
#data_engineering#SQL@datafrik_co
The light @IkejaElectric is providing for my area isn't a good one, the light has been fluctuating and it keeps burning stuff. Burnt some of the security light last night, some chargers this morning. @IkejaElectric