MYSQL.AJ1
MySQL
Develop strong data management skills with our comprehensive MySQL training course.
- Practice in 35 Praktische Übungen — nothing to install
- 16 Interaktive Lektionen Und 157 topics mapped to the official exam objectives
- 203 Testfragen zur Praxis
Intermediate Selbstgesteuert · 1 Jahr Zugang
35 Praktische LiveLabs
Practice real IT tasks in guided environments.
- Reale Umgebungen
- Automatisch bewertet
- Keine Installation
16Interaktive Lektionen
157Topics
35LiveLab
203Testfragen zur Praxis
54Karteikarten
54Glossar der Begriffe
01 / Fähigkeiten, die Sie erwerben
What you will be able to do
Try Free →
Keine Kreditkarte benötigt
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 Strukturierte Lektionen Umfassende Abdeckung der zentralen Kursziele
-
35 Praktische LiveLabs Interaktive, geführte Szenarien mit sofortiger Auswertung
-
203 Übungsfragen Bewertungstests mit ausführlichen Antwortbegründungen
-
1 Jahr voller Zugang Selbstgesteuertes Lernen, jederzeit auf allen Geräten zugänglich
02 / Lektionen & Labore
See exactly what you will learn and practice
Unterrichtsplan
16 Interaktive Lektionen · 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 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
03 Creating a Database 9 topics · 6 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
04 Using SQL to Work with a Database 16 topics · 4 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
05 Selecting, Aggregating, and Applying Functions 13 topics · 4 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
06 Correlating Data across Tables 8 topics · 3 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
07 Stored Procedures and Other Objects 10 topics · 4 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
08 Creating Database Clients in Node.js 6 topics · 2 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
09 Working with Data Using Node.js 8 topics · 1 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
10 Microsoft Access – Part 1 10 topics · 2 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
11 Microsoft Access – Part 2 12 topics · 2 LiveLab +
- 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 LiveLab in this lesson — see the labs panel →
12 MS Excel VBA and MySQL – Part 1 9 topics · 2 LiveLab +
- 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 LiveLab 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 LiveLab +
- 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 LiveLab 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
Praktische Übungen Our edge
35 LiveLabs- 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
Labore laufen direkt im Browser — nichts zu installieren.
03 / FAQS
Fragen, bevor Sie beginnen
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 Jahr voller Zugang
- 35 LiveLab enthalten
- Abschlusszertifikat
Keine Kreditkarte benötigt