MySQL Crash Course: A Hands-on Introduction to Database Development by Rick Silv

Description: MySQL Crash Course by Rick Silva "Covers all things MySQL from the basics of creating a table to the complexities of managing an entire database. Teaches how to build efficient databases through examples, exercises, and three hands-on projects. Topics include creating simple databases and tables, updating and deleting data, working with multiple tables, and avoiding common mishaps"-- FORMAT Paperback LANGUAGE English CONDITION Brand New Publisher Description 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.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.MySQL Crash Course is a fast-paced, no-nonsense introduction to relational database development. Its filled withpractical examples and expert advice that will have you up and running quickly.Youll learn the basics of SQL, how to create a database, craft SQL queries to extract data, and work with events,procedures, and functions. Youll see how to add constraints to tables to enforce rules about permitted data and useindexes to accelerate data retrieval. Youll even explore how to call MySQL from PHP, Python, and Java.Three final projects will show you how to build a weather database from scratch, use triggers to prevent errors in anelection database, and use views to protect sensitive data in a salary database.Youll also learn how to-Query database tables for specific information, order the results, comment SQL code, and deal with null valuesDefine table columns to hold strings, integers, and dates, and determine what data types to useJoin multiple database tables as well as use temporary tables, common table expressions, derived tables, andsubqueriesAdd, change, and remove data from tables, create views based on specific queries, write reusable stored routines, and automate and schedule eventsThe perfect quick-start resource for database developers, MySQL Crash Course will arm you with the tools you needto build and manage fast, powerful, and secure MySQL-based data storage systems. Author Biography 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 hes not joining database tables, hes playing banjo at a local bluegrass jam. Table of Contents 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 Review "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 youre looking to learn MySQL (and specifically 8.0) quickly and efficiently, Rick Silvas [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 Details ISBN1718503008 Author Rick Silva Language English ISBN-10 1718503008 ISBN-13 9781718503007 Format Paperback Publisher No Starch Press,US Year 2023 Imprint No Starch Press,US Place of Publication San Francisco Country of Publication United States Publication Date 2023-05-23 AU Release Date 2023-05-23 NZ Release Date 2023-05-23 US Release Date 2023-05-23 UK Release Date 2023-05-23 Pages 352 Subtitle A Hands-on Introduction to Database Development DEWEY 005.756 Audience General Audience Age 10 We've got this At The Nile, if you're looking for it, we've got it. With fast shipping, low prices, friendly service and well over a million items - you're bound to find what you want, at a price you'll love! TheNile_Item_ID:159241041;

Price: 78.03 AUD

Location: Melbourne

End Time: 2024-11-20T02:48:45.000Z

Shipping Cost: 0 AUD