MySQL Cookbook : 100+ recipes for database development and administration in MySQL

Enregistré dans:
Détails bibliographiques
Auteur principal: Negrin, Elias. (Auteur)
Support: E-Book
Langue: Anglais
Publié: New Delhi : BPB Publications.
Autres localisations: Voir dans le Sudoc
Résumé: 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
Accès en ligne: Accès à l'E-book
LEADER 03826nmm a2200409 i 4500
001 ebook-280850034
005 20241014154539.0
007 cu|uuu---uuuuu
008 241014s2024||||ii ||||g|||| ||||||eng d
035 |a FRCYB88958088 
035 |a FRCYB26088958088 
035 |a FRCYB24888958088 
035 |a FRCYB29388958088 
035 |a FRCYB084688958088 
035 |a FRCYB087588958088 
035 |a FRCYB56788958088 
035 |a FRCYB097088958088 
035 |a FRCYB087088958088 
040 |a ABES  |b fre  |e AFNOR 
041 0 |a eng  |2 639-2 
100 1 |a Negrin, Elias.  |4 aut.  |e Auteur 
245 1 0 |a MySQL Cookbook :  |b 100+ recipes for database development and administration in MySQL   |c Elias Negrin. 
264 1 |a New Delhi :  |b BPB Publications. 
264 2 |a Paris :  |b Cyberlibris,  |c 2024. 
336 |b txt  |2 rdacontent 
337 |b c  |2 rdamedia 
337 |b b  |2 isbdmedia 
338 |b ceb  |2 RDAfrCarrier 
500 |a Couverture (https://static2.cyberlibris.com/books_upload/136pix/9789355519290.jpg). 
506 |a L'accès en ligne est réservé aux établissements ou bibliothèques ayant souscrit l'abonnement  |e Cyberlibris 
520 |a 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 
559 2 |b 1. Using the MySQL Client Program  |b 2. Using MySQL Shell  |b 3. Using MySQL Replication  |b 4. Writing MySQL-based Programs  |b 5. Querying Data from Tables: Tables Management  |b 6. Working with Strings  |b 7. Working with Dates and Times  |b 8. Sorting Query Results  |b 9. Using Stored Routines, Triggers, and Scheduled Events  |b 10. Importing and Exporting Data  |b 11. Validating and Reformatting Data  |b 12. Generating and Using Sequences  |b 13. Working with JSON  |b 14. Server Administration  |b 15. Monitoring the Database Server and Security 
856 |q HTML  |u https://srvext.uco.fr/login?url=https://univ.scholarvox.com/book/88958088  |w Données éditeur  |z Accès à l'E-book 
886 2 |2 unimarc  |a 181  |a i#  |b xxxe## 
993 |a E-Book  
994 |a BNUM 
995 |a 280850034