Universal Class: Over 500 Online Certificate Courses
 

Online Class: MySQL


Computer Programming Picture
$55.00
no certificate
- OR -
$80.00
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
 
 
 
 
 
 
 

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.

  • Completely Online
  • Self-Paced
  • Instructor Feedback
  • 6 Months to Complete
  • 24/7 Availability
  • Start Anytime
  • PC & Mac Compatible
  • Android & iOS Friendly
  • Accredited CEUs
Universal Class is an IACET Accredited Provider
 
 
 
 
 

Students who took this course also took these courses...

 
 
 

Request More Information

Request More Information
Have a question? Check out our FAQ or contact us for more information.
 
Computer Programming Picture Computer Programming Picture
 
 

Course Lessons

Average Lesson Rating: (122 votes)
4.7 / 5 Stars (Average Rating) 4.7 / 5 Stars (Average Rating) 4.7 / 5 Stars (Average Rating) 4.7 / 5 Stars (Average Rating) 4.7 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
7/22/2017 11:41:13 AM

Lesson 1: Introduction to MySQL

Webmasters, ecommerce startups, bloggers, and programmers can all benefit by understanding and learning MySQL administration. 1 Total Points
  • Lesson 1 Video
  • Complete Assignment: Introduction : Why are you taking this course?

Lesson 2: Installing MySQL

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

Lesson 3: Designing Databases

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

Lesson 4: Basic SQL

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. 9 Total Points
  • Lesson 4 Video
  • Review 2 Articles: MySQL by Examples for Beginners; Retrieving Data with SQL Queries
  • Complete: Lesson 4 Exam

Lesson 5: Database Structures

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

Lesson 6: Doing Advanced Queries

Advanced queries are typically used for reporting, joining multiple tables, nesting queries, and transaction locking. All of these concepts are covered in this lesson. 10 Total Points
  • Lesson 6 Video
  • Review 2 Articles: A Deeper Look at Advanced Select Queries; Moving from Simple to Complex MySQL Queries
  • Complete: Lesson 6 Exam

Lesson 7: Advanced MySQL Concepts

Advanced MySQL help new administrators with manipulating data either through inserting records from other queries or CSV files. 10 Total Points
  • Lesson 7 Video
  • Review 2 Articles: Transactions and MySQL; MySQL Architecture and Concepts
  • Complete: Lesson 8 Exam

Lesson 8: Managing Users and Privileges

By managing users, you keep granular control over your data and protect it from unauthorized access. 10 Total Points
  • Lesson 8 Video
  • Review Article: How To Create a New User and Grant Permissions in MySQL
  • Review Video: Mysql - Users And Privileges
  • Complete: Lesson 8 Exam

Lesson 9: Backing Up and Restoring MySQL Databases

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

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

This lesson discusses performance tuning and configurations for your MySQL server and its databases. 10 Total Points
  • Lesson 10 Video
  • Review 2 Articles: Using Option Files; Tuning Your MySQL Database
  • Complete: Lesson 10 Exam

Lesson 11: Setting Up MySQL Replication

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. 70 Total Points
  • Lesson 11 Video
  • Review 2 Articles: How to Set Up Replication; How To Set Up Master Slave Replication in MySQL
  • Take Poll: Let us know what you think of this course
  • Complete: Lesson 11 Exam
  • Complete: The Final Exam
161
Total Course Points

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
Languages: English - United States, Canada and other English speaking countries
Category:
Course Type: Computer Skill
CEU Value: 1.0 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
Instructor: UniversalClass Staff Instructor
Syllabus: View Syllabus
Duration: Continuous: Enroll anytime!
Course Fee: $55.00 (no CEU Certification) || with CEU Certification: $80.00

Choose Your Subscription Plan

Course Only
One Course
No Certificate / No CEUs
$55
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
$80
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
Best Value
ALL COURSES
Certificates & CEUs
$189
per year
You save 50%!
Billed once
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 500+
Platinum Monthly
ALL COURSES
Certificates & CEUs
$59 first month
$29.00 / each consecutive month thereafter
 
Billed monthly
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete Monthly
No. of courses 500+
 

Related Courses

Follow Us Online
  • Follow us on Google Plus Follow us on FaceBook Follow us on Twitter Follow us on YouTube
© Copyright 1999-2017 Universal Class™ All rights reserved.