The MySQL Workshop
With this hands-on guide, you'll explore essential MySQL topics and discover how easy it is to set up and run a MySQL database. Interactive exercises and challenging activities will help you to get hands-on experience in managing large databases with MySQL.
Offered by
Difficulty Level
Intermediate
Completion Time
24h12m
Language
English
About Book
Who Is This Book 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.
The MySQL Workshop
- About Book
- Who Is This Book For?
- Book Content
Book content
chapters • 24h12m total length
Background Concepts
Creating a Database
Using SQL to Work with a Database
Selecting, Aggregating, and Applying Functions
Correlating Data across Tables
Stored Procedures and Other Objects
Creating Database Clients in Node.js
Working with Data using Node.js
Microsoft Access Part 1
Microsoft Access Part 2
MS Excel VBA and MySQL - Part 1
MS Excel VBA and MySQL - Part 2
Getting Data into MySQL
Manipulating User Permissions
Logical Backups
Related Resources
Access Ready-to-Use Books for Free!
Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!