This week marks the halfway point of the course, and it's really flown by quick. I've really felt like I've learned a lot so far. There's obviously becoming more comfortable with SQL syntax, but there's also the understanding of what's going on behind each command as well. That's helped shed light on some of the real power of relational databases. Things that I previously thought must have been done all internally to a program, can actually be achieved with some simple SQL queries. I've also found learning about normalization very interesting, and both at times confusing and other times very easy to understand.
Things I'm still curious about are other database types like nosql, apache Cassandra, or elasticsearch. I'm beginning to understand how performance is affected by choices we make when designing our tables and queries, but there still seems like a lot of ground to cover there. Another question I have is around how does scaling and redundancy work for a database and keeping it all in sync. Also database heath, what are ways to make sure a database is sane and validated.
0 comments:
Post a Comment