MySQL Crash Course

A Hands-on Introduction to Database Development

Häftad, Engelska, 20239-12 år

461 kr

Beställningsvara. Skickas inom 3-6 vardagar. Fri frakt över 249 kr.

Beskrivning

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.

Produktinformation

Utgivningsdatum:2023-05-23
Mått:181 x 234 x 19 mm
Vikt:663 g
Ålder:9-12
Format:Häftad
Språk:Engelska
Läsålder:9-12
Antal sidor:352
Förlag:No Starch Press,US
ISBN:9781718503007

Utforska kategorier

Databaser inom Data och IT

Mer om författaren

Rick Silva is a software developer with decades of database experience. Silva has worked at Harvard Business School, Zipcar, and various financial services companies. A Boston native and a Boston College alum, he now lives in the Raleigh, North Carolina area with his wife Patti and his dog Dixie. When he's not joining database tables, he's playing banjo at a local bluegrass jam.

Recensioner i media

“A fantastic resource for anyone who wants to learn about MySQL . . . and an excellent refresher for more seasoned developers.”—Scott Stroz, MySQL Developer Advocate“Understand not just the 'what,' but the 'why' behind MySQL development."—Steven Sian, Web and Mobile Application Developer"If you’re looking to learn MySQL (and specifically 8.0) quickly and efficiently, Rick Silva’s [MySQL Crash Course] is the perfect resource. With its practical approach, clear examples, and step-by-step guidance, as [a] developer, this book will help you master MySQL!" —Frédéric Descamps, MySQL Architect at Oracle and technical reviewer of MySQL Crash Course

Innehållsförteckning

AcknowledgmentsIntroductionPART I: GETTING STARTEDChapter 1: Installing MySQL and ToolsChapter 2: Creating Databases and TablesPART II: SELECTING DATA FROM A MYSQL DATABASEChapter 3: Introduction to SQLChapter 4: MySQL Data TypesChapter 5: Joining Database TablesChapter 6: Performing Complex Joins with Multiple TablesChapter 7: Comparing ValuesChapter 8: Calling Built-in MySQL FunctionsChapter 9: Inserting, Updating, and Deleting DataPART III: DATABASE OBJECTSChapter 10: Creating ViewsChapter 11: Creating Functions and ProceduresChapter 12: Creating TriggersChapter 13: Creating EventsPART IV: ADVANCED TOPICSChapter 14: Tips and TricksChapter 15: Calling MySQL from Programming LanguagesPART V: PROJECTSChapter 16: Building a Weather DatabaseChapter 17: Tracking Changes to Voter Data with TriggersChapter 18: Protecting Salary Data with ViewsAfterwordIndex