Reduzierte Artikel in dieser Kategorie
| Verlag | No Starch Press |
| Auflage | 2023 |
| Seiten | 304 |
| Format | 17,8 x 1,9 x 23,4 cm |
| Gewicht | 661 g |
| Artikeltyp | Englisches Buch |
| EAN | 9781718503007 |
| Bestell-Nr | 71850300UA |
With databases lurking in the background of every website, knowing how to manage them with MySQL is a no-brainer. This practical, hands-on introduction teaches readers all they need to know.
This complete guide to all things MySQL will take readers from the absolute basics of creating a table to the complexities of managing an entire database. Learn to build efficient databases through interesting examples, exercises, and three hands-on projects creating databases for weather, voter, and salary data. The book leads readers through all of MySQL s intricacies, without the technical jargon. It s designed to help build confidence in creating simple databases and tables before learning more advanced concepts, including how to update and delete data, work with multiple tables, and avoid common mishaps. By the end of the book, readers will be database management pros, who know how to carry out comprehensive data projects with ease.
Inhaltsverzeichnis:
Introduction
Part I: Getting Started
Chapter 1: Installing MySQL and Tools
Chapter 2: Creating Databases and Tables
Part II: Selecting Data from a MySQL Database
Chapter 3: Introduction to SQL
Chapter 4: MySQL Data Types
Chapter 5: Joining Database Tables
Chapter 6: Complex Joins with Multiple Tables
Chapter 7: Comparing Values
Chapter 8: Calling Built-in MySQL Functions
Part III: Database Objects
Chapter 9: Inserting, Updating, and Deleting Data
Chapter 10: Creating Views and Materialized Views
Chapter 11: Creating Functions and Procedures
Chapter 12: Creating Triggers
Chapter 13: Creating Events
Part IV: Advanced Topics
Chapter 14: Tips and Tricks
Chapter 15: Calling MySQL from Programming Languages
Part V: Projects
Chapter 16: Creating a Weather Database and Loading Data
Chapter 17: Using Triggers to Track Changes to Voter Data
Chapter 18: Using Views to Hide Salary Data
Afterword
Appendix A: List of Bui lt-in Functions
