MySQL Cookbook Elias Negrin
(ebook)
(audiobook)
(audiobook)
- Autor:
- Elias Negrin
- Wydawnictwo:
- BPB Publications
- Ocena:
- Stron:
- 372
- Dostępne formaty:
-
ePubMobi
Czytaj fragment
Opis
książki
:
MySQL Cookbook
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 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
BPB Publications - inne książki
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
Proszę wybrać ocenę!
Proszę wpisać opinię!
Książka drukowana
Proszę czekać...
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.