MySQL Cookbook

MySQL Cookbook
Author :
Publisher : BPB Publications
Total Pages : 511
Release :
ISBN-10 : 9789355519290
ISBN-13 : 935551929X
Rating : 4/5 (29X Downloads)

Book Synopsis MySQL Cookbook by : Elias Negrin

Download or read book MySQL Cookbook written by Elias Negrin and published by BPB Publications. This book was released on 2024-08-21 with total page 511 pages. Available in PDF, EPUB and Kindle. Book excerpt: DESCRIPTION MySQL Cookbook – MySQL is a popular open-source database, and SQL is the top language for querying, creating, and managing data in databases. Developers and administrators widely use it for general and specific applications. MySQL powers business IT applications like CRM and ERP, APIs, web and e-commerce platforms, database management, data analytics, and increasingly, big data and data science projects. It starts with MySQL Workbench for beginners and moves to MySQL Shell for advanced scripting. Learn data redundancy, disaster recovery, and server connections in various languages. Core functions like SELECT, JOINs, INSERT, UPDATE, and DELETE are explained. Explore string, date, and time functions, sorting, stored procedures, triggers, and data manipulation. Finally, it covers user management, backups, performance, and security best practices. By the end of this book, you will be adept at interacting with MySQL databases, crafting efficient queries, and confidently managing your data for optimal performance and security. KEY FEATURES ● Gain confidence and skills to solve data problems with hands-on MySQL exercises. ● Learn practical MySQL skills by solving common database issues. ● Connect to servers, issue queries, retrieve data, and manage MySQL tasks. WHAT YOU WILL LEARN ● Connect to a server, issue queries, and retrieve results from MySQL Server. ● Store, retrieve, and manipulate strings and work with dates and times. ● Sort query results and generate aggregations. ● Use stored routines, triggers, and scheduled events. ● Perform basic MySQL administration tasks and monitoring fundamentals. WHO THIS BOOK IS FOR Whether you are a developer, an administrator, a faculty member teaching databases, or a student aiming to enhance your skills, this book provides valuable insights and hands-on knowledge to tackle database-related questions and problems effectively. TABLE OF CONTENTS 1. Using the MySQL Client Program 2. Using MySQL Shell 3. Using MySQL Replication 4. Writing MySQL-based Programs 5. Querying Data from Tables: Tables Management 6. Working with Strings 7. Working with Dates and Times 8. Sorting Query Results 9. Using Stored Routines, Triggers, and Scheduled Events 10. Importing and Exporting Data 11. Validating and Reformatting Data 12. Generating and Using Sequences 13. Working with JSON 14. Server Administration 15. Monitoring the Database Server and Security


MySQL Cookbook Related Books

Shucked
Language: en
Pages: 365
Authors: Erin Byers Murray
Categories: Biography & Autobiography
Type: BOOK - Published: 2011-10-11 - Publisher: St. Martin's Press

GET EBOOK

Bill Buford's Heat meets Phoebe Damrosch's Service Included in this unique blend of personal narrative, food miscellany, and history In March of 2009, Erin Byer
Have Her Over for Dinner
Language: en
Pages: 86
Authors: Matt Moore
Categories: Biography & Autobiography
Type: BOOK - Published: 2010-03 - Publisher: Matt Moore

GET EBOOK

Let's face it, today we are inundated with articles about cooking, food, and wine in almost every part of our lives. From The Wall Street Journal to Playboy Mag
CRU Oyster Bar Nantucket Cookbook
Language: en
Pages: 495
Authors: Erin Zircher
Categories: Cooking
Type: BOOK - Published: 2019-05-21 - Publisher: St. Martin's Griffin

GET EBOOK

A cookbook that captures the laid-back, but elegant lifestyle of Nantucket and the wonderful dishes of its locals' and tourists' favorite CRU Oyster Bar. CRU Oy
Carmine's Family-Style Cookbook
Language: en
Pages: 340
Authors: Michael Ronis
Categories: Cooking
Type: BOOK - Published: 2008-10-14 - Publisher: St. Martin's Press

GET EBOOK

Anyone who has visited Carmine's flagship Times Square restaurant knows that Carmine's food is the best of classic Italian cuisine—each dish prepared simply t
Jeremiah Tower Cooks
Language: en
Pages: 304
Authors: Jeremiah Tower
Categories: Cooking
Type: BOOK - Published: 2002-10-02 - Publisher:

GET EBOOK

This is a long-waited new cookbook from the father of California cuisine, who revolitionized American cooking through the use of fresh ingredients from local pr