The MySQL Workshop - A New, Interactive Approach To Learning MySQL
by Thomas Pettit, Scott Cosentino
(c) Packt Publishing

DATE: 04-08-2023      ▓   SIZE: 36.73 MB           ▓   PAGES: n/a
FORMAT: EPUB          ▒   DISKS: 1x50.00MB         ▒   EDITION: n/a
LANGUAGE: English     ░   ISBN: 9781839214905      ░   REMOVED: DRM

https://www.worldcat.org/search?q=bn%3A9781839214905&fq=x0%3Abook+%2B+x4%3Adigit

Learning MySQL just got a whole lot easier, thanks to this hands-on
workshop, complete with simple explanations, engaging examples, and
realistic exercises that focus on helping you to build and maintain
databases effectively Key Features: Learn how to set up and maintain a
MySQL database Run SQL queries to create, retrieve, and manipulate data Use
MySQL effectively with common business applications such as Excel and MS
Access Book Description: Do you want to learn how to create and maintain
databases effectively? Are you looking for simple answers to basic MySQL
questions as well as straightforward examples that you can use at work? If
so, this workshop is the right choice for you. Designed to build your
confidence through hands-on practice, this book uses a simple approach that
focuses on the practical, so you can get straight down to business without
having to wade through pages and pages of dull, dry theory. As you work
through bite-sized exercises and activities, you'll learn how to use
different MySQL tools to create a database and manage the data within it.
You'll see how to transfer data between a MySQL database and other sources,
and use real-world datasets to gain valuable experience of manipulating and
gaining insights from data. As you progress, you'll discover how to protect
your database by managing user permissions and performing logical backups
and restores. If you've already tried to teach yourself SQL, but haven't
been able to make the leap from understanding simple queries to working on
live projects with a real database management system, The MySQL Workshop
will get you on the right track. By the end of this MySQL book, you'll have
the knowledge, skills, and confidence to advance your career and tackle
your own ambitious projects with MySQL. What You Will Learn: Understand the
concepts of relational databases and document stores Use SQL queries,
stored procedures, views, functions, and transactions Connect to and
manipulate data using MS Access, MS Excel, and Visual Basic for
Applications (VBA) Read and write data in the CSV or JSON format using
MySQL Manage data while running MySQL Shell in JavaScript mode Use X DevAPI
to access a NoSQL interface for MySQL Manage user roles, credentials, and
privileges to keep data secure Perform a logical database backup with
mysqldump and mysqlpump Who this book is for: This book is for anyone who
wants to learn how to use MySQL in a productive, efficient way. If you're
totally new to MySQL, it'll help you get started or if you've used MySQL
before, it'll fill in any gaps, consolidate key concepts, and offer
valuable hands-on practice. Prior knowledge of simple SQL or basic
programming techniques will help you in quickly grasping the concepts
covered, but is not necessary.

Looking for suppliers of quality Ebooks in any language!