“Maximizing Database Management and Reporting Efficiency with MyGuitarShop”

in this class we learned using the MyGuitarShop database. This included an introduction to relational databases, query numeric data from MySQL tables, date and time type, MySQL table and column aliases, creating and updating tables, writing queries using group by and having clauses, stored procedures and using logical and physical backups. Reflect on how these lessons can be applied toward more effective database management and reporting.