Course Syllabus: MySQL

no certificate
with CEU Certificate*
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 programmers understand how to set up 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.
Finally, we discuss how to work with PHP and your MySQL server. PHP and MySQL work seamlessly together, and you'll become a stronger data designer if you understand the application creation process. This course gets you started with very basic SQL design and configuration to building a basic application that displays your information to your customers.
Course Requirements
There are no pre requisites. Anyone over the age of 13 is welcome to join this course. It is recommended though that individuals have some basic computer programming knowledge.
Course Topics
Introduction to MySQL
Designing Databases
Basic SQL
Database Structures
Doing Advanced Queries
Advanced MySQL Concepts
Managing Users and Privileges
Backing Up and Restoring MySQL Databases
MySQL Options File and Configuring and Tuning the MySQL Server
Setting Up MySQL Replication
Introduction to PHP and MySQL
Course Materials
No additional course materials required to complete this course.
Grading Policy
A brief 10 pt. quiz will follow each lesson. Students will successfully complete this course by mastering all learning outcomes with 70% or higher overall grade.
Learning Outcomes
- Describe what MySQL is.
- Know basic install procedures for MySQL.
- Know types of databases and how to design them.
- Identify basic SQL functions.
- Describe database structures.
- Know advanced queries and advanced concepts in MySQL.
- Know managing users and privileges in MySQL.
- Know backing up and restoring MySQLdatabases.
- Describe MySQL options and configuring and tuning the MySQL server.
- Describe setting up mysql replication, and
- Demonstrate mastery of lesson content at levels of 70% or higher.
Assessment Guide
Introduction : Why are you taking this course? | 1 |
MySQL Installation | 1 |
Lesson 1 and 2 Exam | 10 |
Lesson 3 Exam | 10 |
Lesson 4 Exam | 9 |
Lesson 5 Exam | 10 |
Lesson 6 Exam | 10 |
Lesson 8 Exam | 10 |
Lesson 8 Exam | 10 |
Lesson 9 Exam | 10 |
Lesson 10 Exam | 10 |
Lesson 11 Exam | 10 |
The Final Exam | 60 |
Total Points: | 161 |
Related Articles
- Understanding the Basics SQL
- Overview of MySQL
- Understanding Advanced MySQL Concepts
- Database Design in MySQL
- How to Create and Configure Databases in MySQL
- About The Latest Versions of HTML5 and CSS
- Using The Pen Tool and Other Special Effects Tools in Adobe Photoshop
- Creating Object Interactivity in Adobe Fireworks
- Retrieving and Managing External Data in Excel 2019
- Adobe Fireworks: Developing The Workflow
- Get Started with Adobe Photoshop
- JavaScript and Web Page Integration
- How to Sort and Filter Data in Excel 2019
- How to Script Forms with JavaScript
- How to Style CSS Lists