An introduction to working with databases using SQL
In the last chapter, you learned about MySQL Workbench, and how to create a database, tables, and fields. You then learned how to import tables using an SQL script file and then set indexes and foreign keys. You learned how to create a database EER model and diagram by reverse engineering an existing database. You also learned how to modify the database structure using the EER diagram and forward engineering, the changes to the model, and finally, you learned how to synchronize the model with the live database.
In this chapter, you will learn the fundamentals of SQL queries, as well as the basics of creating backups for databases. Backups are valuable when you need to save data to prevent it from getting deleted or lost. It is important to keep backups of data; otherwise, data may become unrecoverable, creating a large amount of work to reconstruct a dataset.
To effectively work with MySQL, you will need to understand the fundamentals...