Online Class: MySQL

This MySQL course helps new and intermediate level database administrators and programmers understand how to setup, run, and maintain MySQL database infrastructures.

$95.00
no certificate
- OR -
$120.00
with CEU Certificate*
Start Right Now!
$120.00 (with CEU Certificate)
Taking multiple courses? Save with our platinum program.
 
  • 11
    Lessons
  • 13
    Exams &
    Assignments
  • 1,658
    Students
    have taken this course
  • 8
    Hours
    average time
  • 0.8
    CEUs
 
 
 

Course Description

Master MySQL: Propel Your Web Development to the Next Level

In the vast world of web development and database management, the choice of tools and platforms can make or break the efficiency and scalability of your applications. Enter MySQL – an open-source dynamo that not only offers cost-effectiveness but also packs the punch required to create robust, scalable, and dynamic web applications. But, like any powerful tool, the magic lies in mastering its potential. Whether you're crafting a new website or integrating a data-rich application, understanding MySQL's depths is pivotal. Our course is here to ensure you unlock MySQL’s unparalleled capabilities, transforming your projects from good to extraordinary.

Why MySQL Stands Out: Begin your journey with an overview of MySQL's landscape, diving into its history, core strengths, and why it consistently ranks among the top choices for database management. As we shed light on its advantages over its counterparts, you'll be equipped with the knowledge to justify its application in your projects.

Designing with Precision: At the heart of every robust application lies the intricate design of its tables. These are the foundational pillars that hold your data, determining not just storage efficiency but also data integrity. In this segment, we take you through the art and science of table design, emphasizing data modeling and integrity to protect your data from potential pitfalls like corruption or misinterpretations.

Crafting for Scalability: In the digital realm, stagnation can be detrimental. As your application grows, your database should evolve seamlessly alongside. We emphasize the principles of forward-thinking design, allowing you to visualize your application not just for its immediate needs, but for its future growth. Understand the nuances of architecture and habits that ensure when you scale, you do so with grace and efficiency, avoiding the pitfalls of retrospective adjustments.

Maintenance and Configuration Mastery: A well-designed database, like a finely-tuned engine, requires regular maintenance. Delve into the essentials of keeping your MySQL database running at its peak, exploring techniques, tools, and best practices that ensure longevity and optimum performance.

Building for Tomorrow: Beyond the technicalities, we also aim to instill a mindset of proactive planning. While designing for today, always have an eye on tomorrow. Learn the strategies that empower you to craft solutions that can stand the test of time and adapt to changing scenarios.

Future-Proof Your Projects with MySQL: In an era defined by rapid technological evolution, staying ahead of the curve is paramount. With this course, you're not just learning a tool; you're investing in a skill set that ensures your projects, whether personal or professional, have the foundational strength to evolve, adapt, and thrive.

Step into the realm of MySQL mastery and let's revolutionize the way you approach web development and database management. Your journey from novice to expert begins here!

  • 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
Universal Class is an IACET Accredited Provider
 
 

Course Lessons

Average Lesson Rating:
4.8 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(650 votes)

Lesson 1: Introduction to MySQL

1 Points
Webmasters, ecommerce startups, bloggers, and programmers can all benefit by understanding and learning MySQL administration. Additional lesson topics: Murach's MySQL, 2nd Edition; MySQL Cookbook: Solutions for Database Developers and Administrators
  • Lesson 1 Video
  • Lesson discussions: Reasons for Taking this Course
  • Complete Assignment: Introduction : Why are you taking this course?

Lesson 2: Installing MySQL

11 Points
Learn how to properly install MySQL for your platform of choice.
  • Lesson 2 Video
  • Complete Assignment: MySQL Installation
  • Assessment: Lesson 1 and 2 Exam

Lesson 3: Designing Databases

10 Points
Redesigning a database is not an option for most large businesses. You need to get it right the first time. Additional lesson topics: An Explanation of the Database Build Process; Five Steps to Ensure the Success of Your Database
  • Lesson 3 Video
  • Assessment: Lesson 3 Exam

Lesson 4: Basic SQL

9 Points
This lesson explains the basics of all four main SQL statements: UPDATE, INSERT, SELECT, and DELETE. As a database administrator or programmer, these four statements are what you'll work with in daily tasks. Additional lesson topics: MySQL by Examples for Beginners; Retrieving Data with SQL Queries
  • Lesson 4 Video
  • Assessment: Lesson 4 Exam

Lesson 5: Database Structures

10 Points
This lesson discusses how to create databases, tables, and then altering those tables for future changes. Additional lesson topics: Create MySQL Tables; Create a database and a table using MySQL commands
  • Lesson 5 Video
  • Assessment: Lesson 5 Exam

Lesson 6: Doing Advanced Queries

10 Points
Advanced queries are typically used for reporting, joining multiple tables, nesting queries, and transaction locking. All of these concepts are covered in this lesson. Additional lesson topics: A Deeper Look at Advanced Select Queries
  • Lesson 6 Video
  • Assessment: Lesson 6 Exam

Lesson 7: Advanced MySQL Concepts

10 Points
Advanced MySQL help new administrators with manipulating data either through inserting records from other queries or CSV files. Additional lesson topics: Transactions and MySQL; MySQL Architecture and Concepts
  • Lesson 7 Video
  • Assessment: Lesson 7 Exam

Lesson 8: Managing Users and Privileges

10 Points
By managing users, you keep granular control over your data and protect it from unauthorized access. Additional lesson topics: How to Create a New User and Grant Permissions in MySQL; Mysql
  • Lesson 8 Video
  • Assessment: Lesson 8 Exam

Lesson 9: Backing Up and Restoring MySQL Databases

10 Points
Backups should be a part of any good IT policy. Backups are included in disaster recovery plans, which are used when critical systems fail. Additional lesson topics: Backup and Restore MySQL Database Using mysqldump; How to Back Up MySQL Databases From The Command Line
  • Lesson 9 Video
  • Assessment: Lesson 9 Exam

Lesson 10: MySQL Options File and Configuring and Tuning the MySQL Server

10 Points
This lesson discusses performance tuning and configurations for your MySQL server and its databases. Additional lesson topics: Using Option Files; Tuning Your MySQL Database
  • Lesson 10 Video
  • Assessment: Lesson 10 Exam

Lesson 11: Setting Up MySQL Replication

70 Points
Replication configurations assume that you have two different MySQL servers set up. This lesson explains the benefits of replication and how to set up your MySQL environment. Additional lesson topics: How to Set Up 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
161
Total Course Points
 

Learning Outcomes

By successfully completing this course, students will be able to:
  • 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

Online CEU Certificate
  • 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
Document Your CEUs on Your Resume
 
Course Title: MySQL
Course Number: 8900358
Lessons Rating: 4.8 / 5 Stars (650 votes)
Languages: English - United States, Canada and other English speaking countries
Availability: With online access available nationwide, this course reaches all U.S. states, including California, Texas, Florida, New York, Pennsylvania, Illinois, Ohio, and Georgia. Additionally, it’s open to learners in English-speaking countries such as the UK, Australia, Canada, and New Zealand.
Last Updated: May 2024
Course Type: Self-Paced, Online Class
CEU Value: 0.8 IACET CEUs (Continuing Education Units)
CE Accreditation: Universal Class, Inc. has been accredited as an Authorized Provider by the International Association for Continuing Education and Training (IACET).
Grading Policy: Earn a final grade of 70% or higher to receive an online/downloadable CEU Certification documenting CEUs earned.
Assessment Method: Lesson assignments and review exams
Syllabus: View Syllabus
Course Fee: $120.00 U.S. dollars

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
$95
for 6 months
 
Billed once
This course only
Includes certificate X
Includes CEUs X
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Certificate Course
One Course
Certificate & CEUs
$120
for 6 months
 
Billed once
This course only
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Platinum Yearly
ALL COURSES
Certificates & CEUs
$189
per year
 
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 600+
Platinum 2 Years
ALL COURSES
Certificates & CEUs
$299
for 2 years
You save $79.00!
Billed once
Includes all 600+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 24 Months
No. of courses 600+