MYSQL.AJ1
MySQL
Develop strong data management skills with our comprehensive MySQL training course.
- Practice in 35 Laboratorios prácticos — nothing to install
- 16 Lecciones interactivas y 157 topics mapped to the official exam objectives
- 203 Preguntas del examen de práctica
Intermediate A tu propio ritmo · 1 año de acceso
35 LiveLabs prácticos
Practice real IT tasks in guided environments.
- Entornos reales
- Calificación automática
- Sin instalación
16Lecciones interactivas
157Topics
35Laboratorio en vivo
203Preguntas del examen de práctica
54Tarjetas didácticas
54Glosario de términos
01 / Habilidades que obtendrás
What you will be able to do
Try Free →
No se requiere tarjeta de crédito
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.
- 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
Course Highlights
-
16 Lecciones estructuradas Cobertura completa de los objetivos principales del curso
-
35 LiveLabs prácticos Escenarios interactivos guiados con evaluación instantánea
-
203 Preguntas de práctica Pruebas de evaluación con justificaciones de respuesta detalladas
-
1 año de acceso completo Aprendizaje a tu propio ritmo, accesible en cualquier momento y en todos los dispositivos
02 / Lecciones y laboratorios
See exactly what you will learn and practice
Plan de estudios
16 Lecciones interactivas · 157 topics01 Preface 3 topics +
- Who this course is for
- What this course covers
- To get the most out of this course
02 Background Concepts 9 topics · 4 Laboratorio en vivo +
- 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
4 Laboratorio en vivo in this lesson — see the labs panel →
03 Creating a Database 9 topics · 6 Laboratorio en vivo +
- 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
6 Laboratorio en vivo in this lesson — see the labs panel →
04 Using SQL to Work with a Database 16 topics · 4 Laboratorio en vivo +
- 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
4 Laboratorio en vivo in this lesson — see the labs panel →
05 Selecting, Aggregating, and Applying Functions 13 topics · 4 Laboratorio en vivo +
- 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
4 Laboratorio en vivo in this lesson — see the labs panel →
06 Correlating Data across Tables 8 topics · 3 Laboratorio en vivo +
- 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
3 Laboratorio en vivo in this lesson — see the labs panel →
07 Stored Procedures and Other Objects 10 topics · 4 Laboratorio en vivo +
- 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
4 Laboratorio en vivo in this lesson — see the labs panel →
08 Creating Database Clients in Node.js 6 topics · 2 Laboratorio en vivo +
- 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
2 Laboratorio en vivo in this lesson — see the labs panel →
09 Working with Data Using Node.js 8 topics · 1 Laboratorio en vivo +
- 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
1 Laboratorio en vivo in this lesson — see the labs panel →
10 Microsoft Access – Part 1 10 topics · 2 Laboratorio en vivo +
- 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
2 Laboratorio en vivo in this lesson — see the labs panel →
11 Microsoft Access – Part 2 12 topics · 2 Laboratorio en vivo +
- 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
2 Laboratorio en vivo in this lesson — see the labs panel →
12 MS Excel VBA and MySQL – Part 1 9 topics · 2 Laboratorio en vivo +
- 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
2 Laboratorio en vivo in this lesson — see the labs panel →
13 Working With Microsoft Excel VBA – Part 2 10 topics +
- 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 13 topics · 1 Laboratorio en vivo +
- 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
1 Laboratorio en vivo in this lesson — see the labs panel →
15 Manipulating User Permissions 12 topics +
- 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 9 topics +
- 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
Laboratorios prácticos Our edge
35 Laboratorio en vivos- Creating a Relational Database
- Creating a New Database Using MS Access
- Normalizing Data from 2NF to 3NF
- Normalizing Data from 1NF to 2NF
- 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
- Modifying an Existing Table
- Adding a Record
- Updating a Record
- Deleting Data from a Table
- Filtering Results
- Using Functions
- Aggregating Data
- Using CASE Statements
- Joining Two Tables
- Using Common Table Expressions (CTEs)
- Using the EXPLAIN Command
- Creating a View
- Creating a Stored Procedure
- Using Triggers
- Implementing a Transaction
- Testing the Output of a Node.js Script
- Writing to a Disk File
- Creating a LAN DSN/ODBC Connection
- Creating an ODBC for a MySQL Database Schema
- Upsizing a Table from Microsoft Access to MySQL
- Calling a MySQL Function
- Creating a Parameterized Stored Procedure
- Activating the Developer tab and the VBA IDE
- Creating a Code Module
- Importing a SQL File using MySQL Workbench
Los laboratorios se ejecutan en tu navegador; no hay nada que instalar.
03 / Preguntas frecuentes
Preguntas antes de empezar
Is MySQL coding?+
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.
How long does it take to learn MySQL?+
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.
Is MySQL still in demand?+
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.
What is the difference between SQL and MySQL?+
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.
Which course is best for MySQL?+
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.
Database Management Made Easier
It’s your guide to complete MySQL training! Enroll to access interactive items, video lessons, gamified test preps, and hands-on labs – all in one place.
- 1 año de acceso completo
- 35 LiveLab incluido
- Certificado de finalización
No se requiere tarjeta de crédito