The MySQL Workshop

By Thomas Pettit , Scott Cosentino , Daniël van Eeden and 1 more
    Advance your knowledge in tech with a Packt subscription

  • Instant online access to over 7,500+ books and videos
  • Constantly updated with 100+ new titles each month
  • Breadth and depth in over 1,000+ technologies

About this book

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 book, you'll have the knowledge, skills, and confidence to advance your career and tackle your own ambitious projects with MySQL.

Publication date:
April 2022

About the Authors

  • Thomas Pettit

    Thomas Pettit began developing software as a hobby. He changed tracks from being a truck driver to being a software developer by earning a graduation degree in software development at the age of 35. He taught basic computers in a community adult education centre in Melbourne for 2 years before commencing his software development career. Tom has worked for several government agencies including defense, law enforcement, and transport as well as large and small private businesses. Tom has mentored several up and coming software developers during his career and takes great joy in assisting others to improve their skills and further their career prospects.

    Browse publications by this author
  • Scott Cosentino

    Scott is a developer and teacher who is passionate about learning. He works primarily in software development and computer security. Aside from this, he has taught students a variety of programming-related topics.

    Browse publications by this author
  • Dani√´l van Eeden

    Danil van Eeden started his career as a UNIX system administrator and then progressed to become a database administrator. After working as a consultant, he joined he a travel company where he helped to scale MySQL to several machines. His job also included giving training to developers and talking at conferences. He has contributed multiple patches to MySQL and related projects.

    Browse publications by this author
  • Dániel Szabó

    Daniel Erno Szabo is a 28-year-old IT geek. He is currently working as a DevOps engineer for an American company in Hungary. His main profile is automation and custom solutions based on different languages covering Windows and Linux. His favorite language is Python, but he is also fluent in Ruby, PowerShell, and C#. He loves learning, teaching, and sharing his knowledge with other people. In his free time, he is a YouTuber and a ferret owner.

    Browse publications by this author
The MySQL Workshop
Unlock this book and the full library for $5 a month*
Start now