Online Class: MySQL

no certificate
with CEU Certificate*
-
11Lessons
-
13Exams &
Assignments -
1,380Students
have taken this course -
8Hours
average time -
0.8CEUs
Course Description
If you've decided to build a website or need a database, MySQL is an open-source option that's very cost effective and affordable. Without knowing how to install, configure, design and maintain the database, you risk having a poor performing environment that can be detrimental to your application. This MySQL course helps new and intermediate level database administrators and programmers understand how to set up run, and maintain MySQL.
We first discuss very basics of MySQL and why the database is popular over other options. We then move on to table design. Table design is the heart of your application, because it determines the way your data is stored. It also determines the effectiveness of data integrity, which protects your data from corruption and inaccuracies. A good table design is paramount for quality software, and we help you understand data design and modeling.
This course covers database maintenance and configuration as well. We explain good architecture and habits that allow you to build scalable solutions instead of configuring your database for a small application that must be then reconfigured for a more scalable project. Scalability should be a primary concern if you want your application and database to grow without issues.
Course Motivation
MySQL has a large portion of the online market. Where Microsoft SQL Server and Oracle were once dominant, MySQL's free architecture and improved interface through the years have made it one of the top three databases used across the world. It's used by some of the largest websites including Facebook and Pinterest. Small startups that use WordPress inherently use MySQL since the application is integrated with the database. Webmasters, ecommerce startups, bloggers, and programmers can all benefit by understanding and learning MySQL administration.What is MySQL?
There are two regions in a website design: the front-end and the back-end. The front-end is the site design and interface users see when they open the site. The back-end is the database. The database is the power horse for an application. It houses all the data and information needed by the front-end. Webmasters have several options when choosing a database, and one of these options is MySQL.
Before you understand MySQL, it helps to understand database functionality. A database is made up of tables, stored procedures, and functions. These three parts drive the back-end of your application.
Tables are the database engine's storage components. Architecture of database storage is extremely technical, but an easy way to envision a database table is to visualize a spreadsheet. Spreadsheets have columns and rows. Where these columns and rows intercept are fields. The fields contain one item of data.
When you set up a spreadsheet, your columns make up the components of your data. For instance, a spreadsheet that contains customer information has a first name, last name and address column. Each row has a column of information. These rows represent your records. Using the customer example, each row is a customer.
This is a simplified way to explain a MySQL table, but it helps new database users envision how data is stored and represented. If you look at a MySQL table, it's laid out like a spreadsheet of information. The trick is to understand how to retrieve, filter, edit and delete data. This is what we do throughout this course.
Stored procedures are the programming objects within your database. For instance, suppose you want to select the last customer who ordered, and then send that customer an email. You could write a stored procedure. You can view stored procedures as small functions for your application. They perform certain functionality, which usually results in displayed, editing, inserting or updating data.
Functions are similar to regular programming functions. They act as standard procedures that you use regularly in your SQL programming. For instance, suppose you need to add two numbers each time you query your MySQL tables. Instead of writing stored procedure code each time you add the numbers, you can create a function and use it to save you programming time.
Why is MySQL So Popular?
MySQL isn't popular just because it's free. Most free software isn't associated with high-end enterprise solutions, but MySQL is an exception to this rule. MySQL can be used with small startups or high-traffic enterprise applications. Banks, social networks, universities and government agencies use MySQL as their database solution.
Because companies can go from small startup to large enterprise without changing its database solution, MySQL is scalable. Scalability is often disregarded when startups have tight budgets, but since MySQL is free, it's a good option for a startup that expects growth. It's also high performance. Performance is paramount to application stability. Small databases with only a few records will normally function well even if they are poorly designed. However, if the database tables grow to millions of records, application performance and stability can be affected, which then affects your customers and employees.
MySQL is also secure. Security is a sensitive issue, since the protection of your customer and employee records should be a major concern. With MySQL, administrators can encrypt data and set up authentication to protect all company assets.
There are several more open-source database applications on the market that were deployed after MySQL. MySQL's success is partly due to the numerous hosting companies that offer services with unlimited MySQL database services. Oracle and SQL Server are expensive platforms, and most hosting companies only offer 1 SQL Server if you choose to work with it instead of an open-source database solution. Since MySQL is free and open-source, hosting companies offer unlimited databases with a lower cost than Microsoft platforms. This type of marketing gave MySQL its strong foundation in application development in global cloud and desktop applications.
Relational Data Integrity
MySQL is a relational database. These systems offer data integrity. They are distinct from systems such as Mongo that relies on document style records. Relational databases are used in numerous applications, but the major reason they are used to create applications is for data integrity and transactional style record manipulation.
Relational databases work on the concept of a primary and foreign key relationship. The primary key is the main unique field that identifies a record. This unique identifier is then stored in other tables to build a relationship between a main table and a secondary related table. In this course, we use the concept of a customer and an order. Each customer has its own unique identifier, and then this identifier is stored in the order table. When you need to query MySQL with a list of customers and related orders, you join the two tables using specific SQL syntax.
MySQL is also a transactional database, which means that you can roll back changes to your database. For instance, suppose you want to delete a customer but you don't want to delete the customer if there are active order records associated with the customer. You attempt to delete the customer, but MySQL's relational foreign key constraints give you an error when you attempt to delete it. You can then roll back any changes you made based on commit and rollback features. You commit changes if there were no errors found, or you can roll back previous statements if an error is thrown by the database server.
Data integrity is what sets MySQL and other relational databases apart from more modern databases such as NoSQL. NoSQL databases such as Mongo are used for analytical data and capturing any number of unstructured data. MySQL requires your data to be more structured, so it's a reliable database system for people who want to secure the structure and relationship between tables.
In bigger businesses, MySQL and NoSQL databases work together. The MySQL database stores structured data such as orders and customer information, and the NoSQL database stores unstructured data such as marketing and traffic numbers. You can export data from a MySQL database to a NoSQL database to work with them both for their best features.
In this course, we review relationships such as primary and foreign keys, transactional changes, committing and rolling back changes, and how structured data is stored in the MySQL database. It's important to understand relationships and relational data to effectively build and maintain a MySQL database architecture. If it's engineered incorrectly, you can have difficulties with performance and maintaining your data. We discuss configuring and maintaining performance on your database. We also discuss replication and how you can configure replicated database servers to create a mirrored backup of your existing MySQL database. We also discuss how you can manage replication for the best performance.
- Completely Online
- Self-Paced
- Printable Lessons
- Full HD Video
- 6 Months to Complete
- 24/7 Availability
- Start Anytime
- PC & Mac Compatible
- Android & iOS Friendly
- Accredited CEUs

Course Lessons
Lesson 1: Introduction to MySQL
Lesson 1 Video
Lesson discussions: Reasons for Taking this Course
Complete Assignment: Introduction : Why are you taking this course?
Lesson 2: Installing MySQL
Lesson 2 Video
Complete Assignment: MySQL Installation
Assessment: Lesson 1 and 2 Exam
Lesson 3: Designing Databases
Lesson 3 Video
Assessment: Lesson 3 Exam
Lesson 4: Basic SQL
Lesson 4 Video
Assessment: Lesson 4 Exam
Lesson 5: Database Structures
Lesson 5 Video
Assessment: Lesson 5 Exam
Lesson 6: Doing Advanced Queries
Lesson 6 Video
Assessment: Lesson 6 Exam
Lesson 7: Advanced MySQL Concepts
Lesson 7 Video
Assessment: Lesson 7 Exam
Lesson 8: Managing Users and Privileges
Lesson 8 Video
Assessment: Lesson 8 Exam
Lesson 9: Backing Up and Restoring MySQL Databases
Lesson 9 Video
Assessment: Lesson 9 Exam
Lesson 10: MySQL Options File and Configuring and Tuning the MySQL Server
Lesson 10 Video
Assessment: Lesson 10 Exam
Lesson 11: Setting Up MySQL Replication
Lesson 11 Video
Lesson discussions: Let us know what you think of this course; Course Comments; Program Evaluation Follow-up Survey (End of Course)
Assessment: Lesson 11 Exam
Assessment: The Final Exam
Learning Outcomes
- Describe what MySQL is.
- Summarize basic install procedures for MySQL.
- Summarize types of databases and how to design them.
- Identify basic SQL functions.
- Describe database structures.
- Summarize advanced queries and advanced concepts in MySQL.
- Summarize managing users and privileges in MySQL.
- Summarize backing up and restoring MySQLdatabases.
- Describe MySQL options and configuring and tuning the MySQL server.
- Describe setting up mysql replication.
- Demonstrate mastery of lesson content at levels of 70% or higher.
Additional Course Information

- Document Your Lifelong Learning Achievements
- Earn an Official Certificate Documenting Course Hours and CEUs
- Verify Your Certificate with a Unique Serial Number Online
- View and Share Your Certificate Online or Download/Print as PDF
- Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media

Choose Your Subscription Plan
No Certificate / No CEUs
This course only
Includes certificate | X |
Includes CEUs | X |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 6 months |
No. of courses | 1 course |
Certificate & CEUs
This course only
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 6 months |
No. of courses | 1 course |
Certificates & CEUs
Includes all 600+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 12 Months |
No. of courses | 600+ |
Certificates & CEUs
Includes all 600+ courses
Includes certificate |
![]() |
Includes CEUs |
![]() |
Self-paced |
![]() |
Instructor support |
![]() |
Time to complete | 24 Months |
No. of courses | 600+ |
Related Courses
-
45 hours 4.5 CEUs Ultimate Excel Training Bundle $125.00
-
30 hours 3.0 CEUs Microsoft Office 2021: Word, Excel, PowerPoint and Outlook $110.00
-
13 hours 1.3 CEUs Adobe Illustrator 101 $95.00
-
8 hours 0.8 CEUs Adobe Premiere 101 $95.00
-
11 hours 1.1 CEUs Excel 2021 $80.00
-
7 hours 0.7 CEUs Google Sheets $95.00
-
7 hours 0.7 CEUs Computer Literacy Level 1 - Computer Basics $95.00
-
7 hours 0.7 CEUs Google Slides $95.00
-
6 hours 0.6 CEUs Computer Literacy Level 2 - Internet Basics $95.00
-
7 hours 0.7 CEUs PowerPoint 2021 $95.00
-
9 hours 0.9 CEUs Microsoft Project 2021 $95.00
-
6 hours 0.6 CEUs Computer Literacy Level 3 - Living and Working Online $95.00
-
7 hours 0.7 CEUs Final Cut Pro X $95.00
-
12 hours 1.2 CEUs Adobe After Effects $95.00
-
7 hours 0.7 CEUs Introduction to Logic $95.00
-
6 hours 0.6 CEUs Adobe Captivate $95.00
-
5 hours 0.5 CEUs Adobe Muse 101 $95.00
-
8 hours 0.8 CEUs MySQL $95.00
-
6 hours 0.6 CEUs Google Docs $95.00
-
6 hours 0.6 CEUs Cybersecurity 101 $95.00
-
12 hours 1.2 CEUs Adobe Photoshop 101 $95.00
-
16 hours 1.6 CEUs Advanced Excel 2019 $95.00
-
5 hours 0.5 CEUs Developing Great Social Skills $95.00
-
7 hours 0.7 CEUs Microsoft Word 2021 $95.00
-
8 hours 0.8 CEUs Adobe InDesign 101 $95.00
-
8 hours 0.8 CEUs Microsoft Access 2019 $95.00