• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

MySQL Database Development Mastery

MySQL Database Development Mastery

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 4 hours 19 minutes

  • All levels

Description

This course will help you to get familiarized with the concepts of MySQL Server and MySQL Workbench needed for database development and management. From basic SQL queries and statements to handling relationships and aggregate functions, you will learn all that you need with the help of real-time activities.

MySQL is a database that is used by the biggest social media platforms, such as Facebook, Twitter, and YouTube. Thanks to its performance, reliability, and ease-of-use, MySQL has become one of the most popular open-source databases. This course will help you get to grips with the fundamentals of the two most powerful MySQL assets-MySQL Server and MySQL Workbench-for effectively designing and maintaining databases.
The course begins with an introduction to MySQL Server and its databases and demonstrates the process of installing MySQL Server and MySQL Workbench on your machine. Once the setup is complete, you'll explore the concepts of manipulating data and tables with MySQL queries. Moving on, you will discover how to connect, create, and remove a database; how to insert data into the table using SQL scripts and Workbench; how to select, update, and delete data in the table; along with learning some CRUD operations. As you progress, you'll understand the importance of relationships, foreign keys, and normalization in MySQL. Finally, you will delve into aggregate functions, such as AVG, COUNT, MIN, and MAX, and find out how to perform calculations on a set of values and return a single value.
By the end of this course, you'll have gained the basic MySQL Server and MySQL Workbench skills needed to design and maintain databases. The code files are placed here: https://github.com/PacktPublishing/MySQL-Database-Development-Mastery

What You Will Learn

Familiarize yourself with MySQL Server and MySQL Workbench
Find out how to create a database from scratch
Manipulate data and tables with CRUD operations
Create relationships with the Workbench table design tool
Use aggregate functions to perform quick mathematical operations
Export your query results to an Excel sheet using MySQL Workbench

Audience

Whether you are a beginner-level or an experienced database administrator or developer looking to get familiar with MySQL Server and MySQL Workbench database development techniques, this course is for you. You can get started with this course without any prior knowledge of database concepts.

Approach

With the help of useful examples and activities, this course will help you learn how to use MySQL Server and MySQL Workbench for designing and managing databases.

Key Features

Discover how to create and manage databases in MySQL Server and MySQL Workbench * Gain a comprehensive understanding of SQL queries, statements, and structures * Build a small school management database to understand the development principles of a database

Github Repo

https://github.com/PacktPublishing/MySQL-Database-Development-Mastery

About the Author
Trevoir Williams

Trevoir Williams is a software engineer and part-time lecturer. With a master's degree in computer science, he has spent over a decade teaching web, software, and database development courses. He also has extensive industry experience in web application development, Azure Cloud system, and server administration. He enjoys teaching IT and development courses and hopes to impart knowledge of the latest developments in industry standards and techniques to his students.

Course Outline

1. Introduction

2. Manipulating Tables and Data - CRUD Operations

3. Relationships and Foreign Keys

4. Aggregate Functions

5. BONUS Discounts

Course Content

  1. MySQL Database Development Mastery

About The Provider

Packt
Packt
Birmingham
Founded in 2004 in Birmingham, UK, Packt’s mission is to help the world put software to work in new ways, through the delivery of effective learning and i...
Read more about Packt

Tags

Reviews