You're reading from The MySQL Workshop A practical guide to working with data and managing databases with MySQL

Product type Paperback

Published in Apr 2022

Publisher Packt

ISBN-13 9781839214905

Length 726 pages

Edition 1st Edition

Languages

SQL

Tools

MySQL

Concepts

Database Administration

Authors (2):

Scott Cosentino

Thomas Pettit

View More author details

Table of Contents (22) Chapters

Preface

1. Section 1: Creating Your Database

2. Chapter 1: Background Concepts FREE CHAPTER

3. Chapter 2: Creating a Database

4. Chapter 3: Using SQL to Work with a Database

5. Chapter 4: Selecting, Aggregating, and Applying Functions

6. Section 2: Managing Your Database

7. Chapter 5: Correlating Data across Tables

8. Chapter 6: Stored Procedures and Other Objects

9. Chapter 7: Creating Database Clients in Node.js

10. Chapter 8: Working with Data Using Node.js

11. Section 3: Querying Your Database

12. Chapter 9: Microsoft Access – Part 1

13. Chapter 10: Microsoft Access – Part 2

14. Chapter 11: MS Excel VBA and MySQL – Part 1

15. Chapter 12: Working With Microsoft Excel VBA – Part 2

16. Section 4: Protecting Your Database

17. Chapter 13: Getting Data into MySQL

18. Chapter 14: Manipulating User Permissions

19. Chapter 15: Logical Backups

20. Other Books You May Enjoy

Appendix

Working with the X DevAPI

The X DevAPI is available in MySQL Shell and the official MySQL connectors for various programming languages. The X DevAPI is what provides the NoSQL interface for MySQL. A NoSQL interface is a way to work with a database without having to use SQL. This allows you to work with a database without using or learning SQL.

Note

NoSQL is a term used to classify database interfaces that are not SQL; in most cases, the interface that is provided is based on JSON and tries to let a database behave in a way that's more similar to the APIs that most web services provide. Also, most NoSQL interfaces don't require you to have a pre-defined format of your data (known as a schema); this is called schema-less.

The main benefit of this is that it feels more natural to developers. The drawback is that a lot of the flexibility that SQL provides is not available in the X DevAPI, making it more difficult to do things such as reporting. On the other hand, having...

The rest of the chapter is locked

You're reading from The MySQL Workshop A practical guide to working with data and managing databases with MySQL

Table of Contents (22) Chapters

Working with the X DevAPI

Unlock this book and the full library FREE for 7 days

Authors (2)

Personalised recommendations for you