This course covered a wide range of important topics regarding the design and use of databases. Three of the most interesting and important topics we covered were the use of MySQL and how to use joins, views, and subqueries to most efficiently retrieve data, the important of transactions and how mishandling them can create a cascading mistake, and how indexes can be very useful, but utilizing them in a database design must be well-balanced as to avoid negatively impacting performance.
No comments:
Post a Comment