Jul 20
[ Day 3 / 15 ]
JUL 17 '26
time studied - 2:15
Working through chapter 3 of Debarros 2ed today. It was about the SELECT function. Which helps with selecting, filtering, and sorting of data. Which best meets one of. SQL's key uses:
"To extract knowledge / gain insight from data"
Given this goal we are then given more tools!
SELECT --- FROM table_name
WHERE
ORDER BY
LIKE & ILIKE
AND & OR
wildcard characters such as _ & %
These are tools we use to interview the database and get a better idea of whether it is robust, aka complete and accurate.
From there we can more accurately gather, load, and clean the data :)
another victory for forward momentum and growing in this practice!