Universal Class: Over 500 Online Certificate Courses
 

Online Class: MySQL


$55.00
no certificate
- OR -
$80.00
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
 
  • 11
    Lessons
  • 13
    Exams &
    Assignments
  • 10
    Hours
    average time
  • 1.0
    CEUs
  • 354
    Students
    have taken this course
 
 
 
 
 

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.

Show More
  • 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
 
 
 

Related Courses

  • Learn HTML - Create Webpages Using HTML5
    Learn HTML - Create Webpages Using HTML5
    This course teaches you how to create webpages from scratch using the most current standard in HTML -- HTML5. HTML5 is the latest standard in web page coding. Whether you're a new or seasoned web designer, you need to know the latest in HTML archite...
    $75.00
    1.0 CEUs 10h
  • Introduction to CSS
    Introduction to CSS
    Ever wonder how the latest website designs are made? Cascading Style Sheets (CSS) are the main coding files used to lay out a website and its design. CSS3 is the latest in styling standards, and it brings several new properties and declarations you ...
    $75.00
    1.1 CEUs 11h
  • Introduction to JavaScript
    Introduction to JavaScript
    JavaScript is the globally used client-side scripting language for the web. Most browsers support the language by default, so you can get started using JavaScript and HTML with a simple text editor and browser for testing. Client-side, programming l...
    $75.00
    1.0 CEUs 10h
  • Introduction to SQL
    Introduction to SQL
    This comprehensive course teaches and demonstrates all aspects of SQL. While you'll learn everything there is to do with SQL, this course assumes you have no prior SQL experience and is for the complete beginner. Structured Query Language (SQL) is t...
    $75.00
    1.7 CEUs 17h
  • Ultimate Excel Bundle
    Ultimate Excel Bundle
    Learn Excel 2016 Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an addr...
    $125.00
    4.6 CEUs 46h
  • Office 2016: Word, Excel, PowerPoint and Outlook
    Office 2016: Word, Excel, PowerPoint and Outlook
    Microsoft Word 2016: Microsoft Word 2016 is the latest version of the popular word processing software offered as part of the Microsoft Office suite. This course will teach you all the skills you'll need to successfully use Word 2016. You'll learn ...
    $110.00
    3.2 CEUs 32h
  • JQuery Programming
    JQuery Programming
    JQuery is one of the most popular frameworks on the web that deals with client-side scripting for styling web pages and performing asynchronous events. It's built on the JavaScript language, so anyone familiar with the JavaScript language will pick ...
    $85.00
    0.9 CEUs 9h
  • Microsoft Project 2016
    Microsoft Project 2016
    Microsoft Project 2016 is a project management software program created for businesses and freelance professionals to help better manage individual projects that occur within companies. Although no project management software should be used to repla...
    $75.00
    0.8 CEUs 8h
  • PowerPoint 2016
    PowerPoint 2016
    PowerPoint 2016 is a presentation creator that can be used to create stunning slideshows and basic videos. It can also be used to create slide presentations, handouts, transparencies, and much more. While creating presentations using some programs c...
    $75.00
    0.7 CEUs 7h
  • Adobe Captivate
    Adobe Captivate
    Adobe Captivate is a responsive authoring tool that allows you to create eLearning content, such as eLearning courses, software demonstrations, branched scenarios, games, quizzes, and screencasts. The files you create in Adobe Captivate 9 can be exp...
    $75.00
    0.6 CEUs 6h
  • Microsoft Access 2016
    Microsoft Access 2016
    Microsoft Access 2016 is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access w...
    $95.00
    1.2 CEUs 12h
  • Advanced Excel 2016
    Advanced Excel 2016
    Excel 2016 Advanced Skills Course With most software programs on the market today, you can thrive with just a basic knowledge of the tools and options built into the individual program. However, that is not necessarily true when it comes to Excel 20...
    $85.00
    1.7 CEUs 17h
  • Adobe After Effects
    Adobe After Effects
    Adobe After Effects allows you to create videos containing animation and special effects for graphics-related projects. You can use After Effects to animate, alter, and composite media using various tools and optional plug-ins. The program is widely...
    $90.00
    1.0 CEUs 10h
  • MySQL
    MySQL
    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 environ...
    $80.00
    1.0 CEUs 10h
  • Adobe Fireworks 101
    Adobe Fireworks 101
    Adobe Fireworks is a program that is part of the Adobe Creative Suite family of products. Formerly known as Macromedia Fireworks, the program is a bitmap and vector graphics editor that is typically used to create interactive graphics and website pr...
    $75.00
    1.0 CEUs 10h
  • Final Cut Pro X
    Final Cut Pro X
    Final Cut Pro X is a video editing and movie making software application created by Apple for OS X. Unlike previously released versions of the video editing program Final Cut, Final Cut Pro X is an all-new application. It has been designed from sc...
    $75.00
    1.0 CEUs 10h
  • C# Programming
    C# Programming
    C# is a powerful backend coding language used for Microsoft web and desktop applications. C# is a C-style language, so you can take C# and learn other languages such as Java, C and C++. This course will get you started with C# and the language style...
    $120.00
    1.7 CEUs 17h
  • Adobe Muse 101
    Adobe Muse 101
    Adobe Muse CC is the newest addition to Adobe's web design programs. Unlike Dreamweaver, which requires knowing a lot of code, Muse CC is a WYSIWYG (or what you see is what you get) design editor. Most tasks that you complete in Muse CC are done wit...
    $75.00
    1.0 CEUs 10h
  • Adobe Illustrator 101
    Adobe Illustrator 101
    Course Introduction Adobe Illustrator is a powerful drawing software program offered by Adobe. Anyone, regardless of artistic or computer ability, can use Illustrator to draw shapes and lines, create text, or import graphics and pictures. You can ...
    $75.00
    1.0 CEUs 10h
  • Excel 2016
    Excel 2016
    Microsoft Excel is a spreadsheet program that comes packaged with the Microsoft Office family of software products. Just like the other programs by Microsoft, Excel can be used for a wide variety of purposes such as creating an address book, grocery...
    $75.00
    1.2 CEUs 12h
  • Adobe InDesign 101
    Adobe InDesign 101
    Adobe InDesign is a software program created by Adobe Systems, the same company that creates Photoshop, Illustrator, and a number of other programs. Whereas Photoshop is used for image editing and Illustrator is used for drawing, InDesign is used to...
    $75.00
    1.0 CEUs 10h
  • Adobe Premiere 101
    Adobe Premiere 101
    Adobe Premiere Pro is a video editing program that is part of the Adobe Creative Cloud software collection, as well as Adobe CS6 – or Adobe Creative Suite. Premiere Pro is used to edit videos, including movies, and is quickly becoming the go-t...
    $95.00
    1.0 CEUs 10h
  • Adobe Photoshop 101
    Adobe Photoshop 101
    This course will teach you everything you need to know to make full use of the world's most popular graphics editing program -- Adobe Photoshop. Adobe Photoshop is a complex graphics and image editing software and paint program. It has become a main...
    $75.00
    1.0 CEUs 10h
 
 

Course Lessons

Average Lesson 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) 4.7 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(146 votes)

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
Show More
 

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 (Self-Paced, Online Class)
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 Online 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+
 
Follow Us Online
  • Follow us on Google Plus Follow us on FaceBook Follow us on Twitter Follow us on YouTube
© Copyright 1999-2018 Universal Class™ All rights reserved.