MySQL Cookbook
- Wydawnictwo:
- BPB Publications
- Ocena:
- Stron:
- 372
- Dostępne formaty:
-
ePubMobi
Opis
książki
:
MySQL Cookbook
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
Wybrane bestsellery
-
Książka "Programowanie obiektowe dla studenta i technika programisty" to podręcznik, dzięki któremu każdy czytelnik, bez względu na stopień zaawansowania, zrozumie podstawowe zasady programowania strukturalnego i obiektowego. Początkujący czytelnik będzie miał możliwość nauki prawie od podstaw, a programista zaawansowany utrwali i przećwiczy posiad(48,10 zł najniższa cena z 30 dni)
48.10 zł
74.00 zł (-35%) -
Książka "Algorytmika dla studenta i technika programisty" to podręcznik, dzięki któremu czytelnik, bez względu na stopień zaawansowania, zrozumie podstawowy myślenia algorytmicznego. Książka wprowadza w tajniki programowania poprzez zrozumienie zasad projektowania metod rozwiązywania prostych jak i skomplikowanych problemów za pomocą komputera. Dla(48,10 zł najniższa cena z 30 dni)
55.50 zł
74.00 zł (-25%) -
AI for Cybersecurity teaches you how to recognize problems in Cybersecurity where AI methods bring value, to design and implement solutions using AI methods efficiently and thereby bring the advantages of AI to your organisation. It enables you to have AI methods as tools in your arsenal and gives you an understanding about where and when you can apply them to solve Cybersecurity problems.-
- pkt
W przygotowaniu
Powiadom mnie, gdy książka będzie dostępna -
-
How to automate AWS Cloud using Terraform IaC best practices Key Features ? Learn how to create and deploy AWS Cloud Resources using Terraform IaC. ? Manage large and complex AWS infrastructures. ? Manage diverse storage options like S3 and EBS for optimal performance and cost-efficiency. Description AWS Cloud Automation allows organizations to e-
- ePub + Mobi pkt
-
-
How to effectively transition your career into the SRE field Key Features ? Understand the basics of site reliability engineering to ensure that systems run smoothly. ? Learn advanced automation methods for efficient and effective operations. ? Enhance performance and scalability through optimization techniques. Description This book is a must-re-
- ePub + Mobi pkt
-
-
Toolkit for unlocking the power of Amazon RDS and propelling businesses toward success in the digital age Key Features ? Explore Amazon RDS by covering basics to advanced MySQL management on the platform. ? Real-world examples and hands-on tutorials to apply gained knowledge to solve challenges. ? Latest features, tools, and best practices in Amaz-
- ePub + Mobi pkt
-
-
Start your career in Identity and Access Management field by learning about Active Directory and automate your work using PowerShell Key Features ? Understand Active Directory design and architecture. ? Deploy AD test environment in Azure and implement it using PowerShell. ? Manage the AD environment in a secure way and automate management using D-
- ePub + Mobi pkt
-
-
Level up database administration with PostgreSQL 15 recipes for mastery Key Features ? Explore PostgreSQL 15 through 100 plus practical recipes, gaining expertise in monitoring, logging, and migration. ? Master cloud setup, scaling, and PostgreSQL 15 resource management in the cloud. ? Enhance database efficiency, streamline backup, and recovery f-
- ePub + Mobi pkt
-
-
Metaverse: A result of natural evolution of technology and human interactions Key Features ? Understand the metaverse evolutions, characteristics, myths vs reality. ? Explore the metaverse opportunities along with its adaption challenge. ? Understand our collective responsibilities in shaping up the metaverse. Description The metaverse has been a-
- ePub + Mobi pkt
-
-
Key Features ? A textbook tailored for the "Digital and Technological Solutions" course under NEP-2020. ? Covers various topics from basic tech to AI, 3D printing, cyber security, and Digital India. ? Fills educational resource gaps, providing insights into digital systems matching NEP-2020 curriculum requirements. Description Introducing a ground-
- ePub + Mobi pkt
-
Szczegóły książki
- ISBN Ebooka:
- 978-93-555-1929-0, 9789355519290
- Data wydania ebooka :
-
2024-09-11
Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna
z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie.
Jeśli masz wątpliwości skontaktuj się z nami sklep@helion.pl.
- Język publikacji:
- angielski
- Rozmiar pliku ePub:
- 39.6MB
- Rozmiar pliku Mobi:
- 39.6MB
BPB Publications - inne książki
-
Novice or expert, learn to simplify and optimize data transformations Key Features ? Practical approaches to cleansing, connecting and transforming data in Power Query. ? Real-life examples that readers can apply to their own work. ? Master Power Query for Excel and Power BI with step-by-step recipes. Description ?The Ultimate Power Query Cookboo-
- ePub + Mobi pkt
-
-
Unveiling insights, unleashing potential: Navigating the depths of data warehousing and mining for a data-driven tomorrow Key Features ? Explore concepts ranging from fundamentals to advanced techniques of data warehouses and data mining. ? Translate business questions into actionable strategies to make informed decisions. ? Gain practical impleme-
- ePub + Mobi pkt
-
-
Stay prepared for the next wave of technological innovation with VR and AR Key Features ? Gain a deep understanding of history, development, and applications in fields of gaming, education, healthcare, and architecture. ? Developing benefits and risks of virtual and extended reality. ? Case studies, examples, and discussions demonstrating how to a-
- ePub + Mobi pkt
-
-
Unleash the hidden potential of Python to emerge as a change maker of contemporary industry Key Features ? Explore Python commands for RPA, workflows and hyperautomation. ? Concise chapters with lucid examples and elaborate codes that make learning interesting. ? Practical industry use case at the end of every chapter to highlight its real world a-
- ePub + Mobi pkt
-
-
Learn to unleash the power of AI creativity Key Features ? Understand the core concepts related to generative AI. ? Different types of generative models and their applications. ? Learn how to design generative AI neural networks using Python and TensorFlow. Description This book researches the intricate world of generative Artificial Intelligence-
- ePub + Mobi pkt
-
-
Conquer the CNCF Certified Kubernetes Administrator (CKA) exam Key Features ? This Kubernetes technical guide covers the entire CNCF syllabus for the CKA exam. ? Contains extensive hands-on manifest code, command line examples and task walkthroughs. ? Includes two practice CKA exams with fully-worked solutions. Description Kubernetes is the de fa-
- ePub + Mobi pkt
-
-
Supercharge your Python skills: Build stunning apps using Visual Studio Code Key Features ? Effectively use VS Code for designing efficient Python programs. ? Learn to develop applications and master the concepts of Python. ? Master the popular VS Code and the most popular programming language Python. Description Python is the most user-friendly-
- ePub + Mobi pkt
-
-
Dive into the endless possibilities of data structures and algorithms and have fun doing it Key Features ? Become familiar with common data structures. ? Learn and understand the most popular algorithms through practical examples. ? Recognize when a particular data structure or algorithm should be used to create an efficient software solution. De-
- ePub + Mobi pkt
-
-
Master the world's most dominant programming language Key Features ? Learn JavaScript fundamentals and advanced techniques. ? Advanced JavaScript ES2015 (ES6)+ concepts uncovered. ? Expert tips for optimizing code efficiency in JavaScript. Description JavaScript Masterclass is your comprehensive guide to mastering the most used language of the we-
- ePub + Mobi pkt
-
-
Unlock the power of automation: Master PowerShell in just 7 days Key Features ? Effortlessly navigate PowerShell's syntax and command structure. ? Master creating scripts and functions for efficient automation. ? Learn practical solutions for local and remote data management. Description "PowerShell in 7 Days" covers the fundamentals of PowerShel-
- ePub + Mobi pkt
-
Dzięki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep@helion.pl
Książka drukowana
Oceny i opinie klientów: MySQL Cookbook Elias Negrin (0)
Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.