CSUMB

CSUMB 363 - Week 4

Author

swordensen

Date Published

CSUMB logo 2


Briefly summarize 5 things what you have learned in the course so far.  

1. That mySQL workbench has ER diagrams. Which is honestly awesome because I have been using lucid charts for this which is way less powerful. Very cool!

2. I got a clearer understanding of how JOINs work and what the differences are between each type of JOIN. I feel like I can optimize some of my queries in the future.

3. What VIEWs are useful for. Honestly, I still think app developers should stay away from VIEWs and deal with the raw tables but, for DB admins I can see how VIEWs are very useful.

3.1 I still think they pollute the database though

4. I got a glimpse into what data structures engineers could use to create database engines like SQL. I don't know how useful this information is but, it's interesting at least.

5. My biggest takeaway is increase familiarity with SQL. I am more comfortable writing SQL queries without the assistance of an ORM.

List at least 3 questions you still have about databases.

1. What are some example of poor database management?

2. What strategies can I implement to avoid unmaintainable catastrophes?

3. What tools do big data engineers use at huge companies at Netflix or Google? I don't imagine they're querying their data via mySQL workbench community edition lol.


Comments

michael sorensen
michael sorensen

Just fyi, if you're interested in answering these questions you can leave comments here if you're comfortable logging into this website.

Join the conversation! Login to reply to comments