#sql study

[latenightsushi]

I’ve started using stories more often to capture the day-to-day, so follow me on IG or twitter if you’re interested!

IG: @latenitesushi Twitter: @latenightsushi Tumblr: @latenightsvshi

[aspiring-cognoscente]

[ Day 4 / 15 ]

JUL 20 '26

time studied - 3:53

Got started with a pet project of mine, learning how to automate tasks and build shell codes. The problem being my coding skills are so rusty that i have to whip out the informal introduction to python manual.

Meant for people who have some experience with programming I still feel a touch out of my depth even though I'm testing my understanding with coding challenges familiar to me.

Python is an interpreted language which is different from the compiled languages, C++ / Haskell, I've most often used in completing assignments during my degree (though Haskell's reliance on recursion and static typing is the most rewarding and confusing thing I've ever had the pleasure of working with).

Today SQL was about data types of which three broad categories dominate most data sets:

characters

numbers

dates and times

Each of which was split into more precise data sets with descriptions on how to best apply them. Haven't completed the chapter but looking forward to chapter 5 which focuses on importing and exporting data >:)

I'll be crawling back like Peter Ravn's oil paintings

[aspiring-cognoscente]

[ 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!

[aspiring-cognoscente]

[ Day 2 / 15 ]

JUL 16 '26

time studied - 1:52

Setup the setup! That means PostgreSQL is officially installed. I ran through the first chapter practices etc.

There was an issue with the recommended visual management tool in Debarros book. It simply would not load whatsoever.

I found an alternative called DBeaver that accomplishes the same thing and has so far been working for the authors intended purpose (even if I can't follow along step by step anymore)

There is a big difference between reading, knowing, and doing has been the wake-up call of my re-acquaintance with learning more broadly. Looking forward to doing more hands on learning.

Grateful to have reflected and continued on this journey.

[aspiring-cognoscente]

[ Day 1 / 15 ]

JUL 14 '26

Began the great work of SQL Success ⋆⭒˚.⋆!!!

Worked 3 hours of concentrated SQL learning

Fundamentals

Tables

Databases

Entities

Data integrity

Constraints

And tomorrow is more !!!

overall I'd call it a success! :)

for the 16th:

I anticipate picking up from here into learning more commands / keywords. Initializing the outlined postgreSQL setup with a visualizer to aid in my understanding.