{"product_id":"mysql-cookbook-100-recipes-for-database-development-and-administration-in-mysql-english-edition-9789355519290","title":"MySQL Cookbook: 100+ recipes for database development and administration in MySQL (English Edition)","description":"\u003cp\u003e\u003cstrong\u003eDESCRIPTION \u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eMySQL 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.\u003c\/p\u003e\u003cp\u003eIt 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.\u003c\/p\u003e\u003cp\u003eBy 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. \u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eKEY FEATURES \u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003e● Gain confidence and skills to solve data problems with hands-on MySQL exercises.\u003c\/p\u003e\u003cp\u003e● Learn practical MySQL skills by solving common database issues.\u003c\/p\u003e\u003cp\u003e● Connect to servers, issue queries, retrieve data, and manage MySQL tasks.\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWHAT YOU WILL LEARN\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003e● Connect to a server, issue queries, and retrieve results from MySQL Server.\u003c\/p\u003e\u003cp\u003e● Store, retrieve, and manipulate strings and work with dates and times.\u003c\/p\u003e\u003cp\u003e● Sort query results and generate aggregations.\u003c\/p\u003e\u003cp\u003e● Perform basic MySQL administration tasks and monitoring fundamentals.\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWHO THIS BOOK IS FOR\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eWhether 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.\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cbr\u003e","brand":"Bpb Publications","offers":[{"title":"Default Title","offer_id":50871196221714,"sku":"9789355519290","price":32.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0831\/4771\/8930\/files\/img_9a78d184-54b5-4328-ab57-b20edec64811.jpg?v=1737827925","url":"https:\/\/surprise-castle.myshopify.com\/products\/mysql-cookbook-100-recipes-for-database-development-and-administration-in-mysql-english-edition-9789355519290","provider":"Surprise Castle","version":"1.0","type":"link"}