The techniques that we discuss are used to interact with a DBMS after a database has been designed. An introduction to relational modeling and design can be found in Appendix C, and a more comprehensive introduction to MySQL and SQL can be found in many of the resources that are listed in last tutorials.
In this tutorial, we cover the following topics:
- A short introduction to relational databases and relational modeling
- A quick start guide to the winestore database and its full entity-relationship model
- The MySQL command interpreter and the basic features of MySQL
- Using SQL to create and modify databases, tables, and indexes
- Using SQL to insert, delete, and update data
SELECTstatement for querying, with examples of simple and advanced queries
- Functions and operators in SQL and MySQL
- Advanced features, including managing indexes and keys, tuning the MySQL DBMS, security, and the limitations of MySQL
We assume that you have already installed MySQL. If not, the guide in Appendix A will help you. tutorial 6 covers other selected advanced database topics that arise when writing to databases, such as supporting multiple users, transactions, and locking in MySQL. Complete examples of SQL queries and MySQL in use in a web database application can be found in tutorial 10 to tutorial 13.