uCertify

MySQL

Develop strong data management skills with our comprehensive MySQL training course.

(MYSQL.AJ1) / ISBN : 978-1-64459-480-3
(Add-on)
Get A Free Trial

About This Course

Our MySQL course is designed to develop the technical skills required for managing and manipulating databases. From foundational concepts to advanced techniques, you’ll explore database creation, SQL queries, data manipulation, and integration with popular tools like Node.js, Microsoft Access, and Excel. Hands-on exercises and real-world examples, illustrated in our MySQL online course, reinforce learning, ensuring you gain practical experience in building and optimizing database solutions.   

Skills You’ll Get

  • Learn MySQL online in a safe, non-productive environment
  • Create SQL queries for data manipulation, retrieval, and analysis
  • Design optimized database schemas and models
  • Manage user permissions, backups, and database optimization
  • Integrate MySQL with Node.js, Microsoft Access, and Excel
  • Import, export, and transform data within MySQL
  • Apply learned skills to solve real-world MySQL database management challenges
  • Optimize database queries and structures for performance

 

Download Course Outline

1

Preface

  • Who this course is for
  • What this course covers
  • To get the most out of this course
2

Background Concepts

  • Introducing databases
  • Exploring MySQL
  • Exercise 1.01: Organizing data in a relational format
  • Exploring MySQL architecture
  • Storage engines (InnoDB and MyRocks)
  • Data modeling
  • Normalization
  • Activity 1.01: Creating an optimized table for an employee project
  • Summary
3

Creating a Database

  • Developing databases
  • The MySQL Workbench GUI
  • Accessing MySQL through the command-line interface
  • Creating a database
  • Using Workbench to add a table
  • MySQL table indexes and foreign keys
  • Reverse engineering a database
  • Activity 2.01 – modifying the EER diagram, the model, and the database
  • Summary
4

Using SQL to Work with a Database

  • An introduction to working with databases using SQL
  • Working with data
  • Backing up databases
  • Restoring databases
  • Working with SQL code to maintain a database
  • Creating a new database
  • Creating and modifying tables
  • SQL queries to create indexes and foreign keys
  • Activity 3.1 – creating a table with indexes and foreign keys
  • Altering table queries
  • Adding data to a table
  • Updating data in a record
  • Deleting data from tables
  • Blobs, files, and file paths
  • Activity 3.2 – adding image file paths to the database
  • Summary
5

Selecting, Aggregating, and Applying Functions

  • An introduction to querying data
  • Querying tables in MySQL
  • Exercise 4.01 – working with simple queries
  • Filtering results
  • Exercise 4.02 – filtering results
  • Using functions on data
  • Exercise 4.03 – using functions
  • Aggregating data
  • Exercise 4.04 – aggregating data
  • Case statements
  • Exercise 4.05 – writing case statements
  • Activity 4.01 – collecting information for a travel article
  • Summary
6

Correlating Data across Tables

  • Introduction to processing data across tables
  • Joining two tables
  • Analyzing subqueries
  • Common table expressions
  • Analyzing query performance with EXPLAIN
  • Activity 5.01: The Sakila video store
  • Activity 5.02: Generating a list of years
  • Summary
7

Stored Procedures and Other Objects

  • Introduction to database objects
  • Exploring various database objects
  • Working with views
  • Activity 6.01 – updating the data in a view
  • Working with user-defined functions
  • Working with stored procedures
  • Working with IN, OUT, and INOUT
  • Exploring triggers
  • Using transactions
  • Summary
8

Creating Database Clients in Node.js

  • Introduction to database management with Node.js
  • Best practices for SQL client development
  • JavaScript using Node.js
  • Connecting to MySQL
  • Activity 7.01 – building a database application with Node.js
  • Summary
9

Working with Data Using Node.js

  • Interacting with databases
  • Inserting records in Node.js
  • Updating the records of a table
  • Activity 8.01 – multiple updates
  • Displaying data in browsers
  • ODBC connections
  • Activity 8.02 – designing a customer database
  • Summary
10

Microsoft Access – Part 1

  • Introduction to MS Access
  • MS Access database application configurations
  • Upsizing an MS Access database to MySQL
  • Manually exporting MS Access tables
  • Adjusting field properties
  • Migrating with wizards
  • Linking to your tables and views
  • Refreshing linked MySQL tables
  • Activity 9.01 – linking the remaining MySQL tables to your MS Access database
  • Summary
11

Microsoft Access – Part 2

  • Introduction to MS Access
  • Migrating an MS Access application to MySQL
  • Activity 10.01 – Converting gender and job statistics
  • Calling MySQL functions
  • Activity 10.02 – Creating a function and calling it
  • Calling MySQL stored procedures
  • Activity 10.03 – Creating MySQL stored procedures and using them in VBA
  • Using parameters
  • Activity 10.04 – Parameterized stored procedure (series list)
  • Activity 10.05 – Multiple parameters stored procedure (date list)
  • The Bad Bits form
  • Summary
12

MS Excel VBA and MySQL – Part 1

  • Introduction to Excel
  • Exploring the ODBC connection
  • Exploring the Excel VBA structure
  • Learning about VBA libraries
  • Connecting to the MySQL database using VBA
  • Reading data from MySQL using VBA
  • Populating charts
  • Activity 11.01 – Creating a chart (artist track sales)
  • Summary
13

Working With Microsoft Excel VBA – Part 2

  • An introduction to MySQL connections
  • Connecting to the MySQL database using ODBC
  • Exploring generic data read functions
  • Creating connections to MySQL in Excel
  • Inserting data using MySQL for Excel
  • Updating data using MySQL for Excel
  • Pushing data from Excel
  • Pivot tables
  • Activity 12.01 – building a MySQL-based Excel document
  • Summary
14

Getting Data into MySQL

  • An introduction to data preparation
  • Working with the X DevAPI
  • Inserting documents
  • Loading data from a SQL file
  • Loading data from a CSV file
  • Loading data from a JSON file
  • Using the CSV storage engine to export data
  • Using the CSV storage engine to import data
  • Searching and filtering JSON documents
  • Using JSON functions and operators to query JSON columns
  • Using generated columns to query and index JSON data
  • Activity 13.01 – Exporting report data to CSV for Excel
  • Summary
15

Manipulating User Permissions

  • Introduction to user permissions
  • Exploring users and accounts
  • Exercise 14.01 – creating users and granting permissions
  • Changing users
  • Flush privileges
  • Changing permissions
  • Exercise 14.02 – modifying users and revoking permissions
  • Using roles
  • Exercise 14.03 – using roles to manage permissions
  • Troubleshooting access problems
  • Activity 14.01 – creating users for managing the world schema
  • Summary
16

Logical Backups

  • An introduction to backups
  • Understanding the basics of backups
  • Logical and physical backup
  • Types of restore
  • Scheduling backups
  • Using point-in-time recovery with binlog files
  • Activity 15.01 – backing up and restoring a single schema
  • Activity 15.02 – performing a point-in-time restore
  • Summary

1

Background Concepts

  • Creating a Relational Database
  • Creating a New Database Using MS Access
  • Normalizing Data from 2NF to 3NF
  • Normalizing Data from 1NF to 2NF
2

Creating a Database

  • Creating a Connection With the MySQL Workbench GUI
  • Creating a Database using MySQL Workbench
  • Creating a Table Using MySQL Workbench
  • Creating an Index
  • Creating a Foreign Key
  • Creating an EER Diagram
3

Using SQL to Work with a Database

  • Modifying an Existing Table
  • Adding a Record
  • Updating a Record
  • Deleting Data from a Table
4

Selecting, Aggregating, and Applying Functions

  • Filtering Results
  • Using Functions
  • Aggregating Data
  • Using CASE Statements
5

Correlating Data across Tables

  • Joining Two Tables
  • Using Common Table Expressions (CTEs)
  • Using the EXPLAIN Command
6

Stored Procedures and Other Objects

  • Creating a View
  • Creating a Stored Procedure
  • Using Triggers
  • Implementing a Transaction
7

Creating Database Clients in Node.js

  • Testing the Output of a Node.js Script
  • Writing to a Disk File
8

Working with Data Using Node.js

  • Creating a LAN DSN/ODBC Connection
9

Microsoft Access – Part 1

  • Creating an ODBC for a MySQL Database Schema
  • Upsizing a Table from Microsoft Access to MySQL
10

Microsoft Access – Part 2

  • Calling a MySQL Function
  • Creating a Parameterized Stored Procedure
11

MS Excel VBA and MySQL – Part 1

  • Activating the Developer tab and the VBA IDE
  • Creating a Code Module
12

Getting Data into MySQL

  • Importing a SQL File using MySQL Workbench

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

No, MySQL is not a coding language. It’s a database management system (DBMS) that uses SQL for interacting with, managing, and monitoring data. You use SQL to write commands that eventually manage and manipulate data within a MySQL database.  

You can learn to use MySQL in a few weeks. In some cases, the time duration can extend to several months. Also, it depends on your prior knowledge and learning pace. 

Yes, MySQL is still in high demand. It’s a widely used database system for web applications, e-commerce platforms, and data-driven businesses. The ability to work with MySQL is a valuable skill for many roles like database administrators, data analysts, and web developers.

SQL (Structured Query Language) is a standard language that manages relational databases. It's used to structure data, perform queries, and manipulate information within a database. Whereas, MySQL is a specific database management system that implements the SQL standard. It's a software product used to store, manage, and retrieve data efficiently.

The best MySQL course for beginners depends on your learning style and goals. Look at our catalog for top-selling courses like SQL for Mere Mortals, MySQL, PHP MySQL Web Development, and more for practical exercises mirroring real-world challenges.

Related Courses

All Courses
We use cookies for improving site experience and analytics. Learn More