I'm learning a bit more about SQL and databases.
I've worked through Julia Evan's SQL zine before:
With the accompanying playground: https:
I'm working through a tutorial on MySQL from Golang after setting up MySQL via Docker
It's also just an interesting exercise in how Golang approaches data management from a pretty imperative data flow, which is very different from the functional approach I'm used to in TypeScript
Finished following the Golang tutorial, https:
Next was: https://learnxinyminutes.com/docs/sql/
Took a gander through a couple of Code Academy lessons next.
- https:
// www .codecademy .com /courses /learn -sql /lessons /manipulation /exercises /sql - https:
// www .codecademy .com /courses /learn -sql /lessons /queries /exercises /queries - https:
// www .codecademy .com /courses /learn -sql /projects /learn _sql _query _table -1
Also reading through how the api repo interacts with our databases at work to read real-world code 💜
Learning how many different types of joins there are was interesting, and W3Schools showed up again with the solid references: W3Schools:
Planetscale has a good number of blog posts on MySQL, in addition to what seems like a thorough “MySQL for Developers” course:
https:
// planetscale .com /blog /the -problem -with -using -a -uuid -primary -key -in -mysql https:
// planetscale .com /blog /why -we -chose -nanoids -for -planetscales -api https:
// planetscale .com /blog /safely -making -database -schema -changes https:
// planetscale .com /blog /backward -compatible -databases -changes Course:
MySQL for Developers — PlanetScale planetscale.com This free MySQL course covers everything you need to know to become an expert in MySQL. The course is geared toward application developers, and offers practical guidance to implement schema, indexes, query improvement, and more.
Also looking at some Astro and Next.js integrations:
https:
// www .thomasledoux .be /blog /astro -db -migrating -analytics -postgres