What this book covers
Chapter 1, Background Concepts, introduces the concepts of databases, database management systems, relational databases, and the general structure of MySQL.
Chapter 2, Creating a Database, discusses how a database is created in MySQL. We will look at how to create a database and a table, how to set up indices and keys, and how to model database systems using ER and EER diagrams.
Chapter 3, Using SQL to Work with Databases, shows how SQL can be used to work with MySQL databases. We will look at ways to back up and restore databases. We will also look at ways to create databases and tables, as well as inserinserting data, updating data, altering table structures, truncating tables, deleting data, and dropping tables.
Chapter 4, Selecting, Aggregating, and Applying Functions, discusses methods of selecting and analyzing data from databases. We will look at selecting and filtering data, as well as methods to apply functions and aggregations to data.
Chapter 5, Correlating Data across Tables, discusses methods of joining tables together. We will also look at subqueries and common table expressions.
Chapter 6, Stored Procedures and other Objects, discusses the various types of database objects that exist in MySQL. This includes views, functions, store procedures, triggers, and transactions.
Chapter 7, Creating Database Clients with Node.js, discusses the methods of using Node.js with a MySQL database. We will look at setting up development MySQL servers, the basics of Node.js, and the methods of connecting to MySQL to create databases and tables.
Chapter 8, Working with Data Using Node.js, expands our knowledge of using Node.js to interface with MySQL. We will see how we can insert, update, and display data through Node.js. We will also learn how to set up and use ODBC connections.
Chapter 9, MS Access Part 1, shows how to interface with MySQL through MS Access. We will look at methods for configuring MS Access, adjusting field properties, and migrating data to link with MySQL.
Chapter 10, MS Access Part 2, looks at advanced topics of MS Access interactions with MySQL. This will include working with passthrough queries, calling MySQL objects, and working with MS Access forms.
Chapter 11, MS Excel VBA and MySQL Part 1, works with MS Excel, using VBA to connect with MySQL databases to retrieve and alter data.
Chapter 12, MS Excel VBA and MySQL Part 2, expands our knowledge of MS Excel to discuss methods of reading, inserting, updating, and pushing data from Excel to MySQL.
Chapter 13, Further Applications of MySQL, looks at various applications we can use to further our MySQL skills and abilities. We will learn how to use X DevAPI and examine concepts such as inserting documents, loading data from CSVs, and exporting/importing various file formats.
Chapter 14, User Permissions, shows how user permissions are used to provide secure access to MySQL databases. We will look at how users are created, how permissions are granted, and how users can be used with a MySQL database.
Chapter 15, Logical Backups, shows how to create logical backups in MySQL. We will learn about different types of restores and methods for scheduling backups on a MySQL server.