| MySQL Database Utilization/Administration |
| |
| This course teaches the student how to create a Relational Database Management System (RDBMS) using MySQL. The student will be instructed on how to create a new database and maintain it. Once we have created a database we will utilize it through standard SQL queries for updates, inserting new data and deleting data. MySQL is a popular RDBMS used in the Open Source Community that is very cost effective. |
|
| Covered Topics: |
General MySQL Use
- Introduction to MySQL and SQL
- Working with Data in MySQL
- MySQL SQL Syntax and Use
- Query Optimization
Using MySQL Programming Interfaces
- Introduction to MySQL Programming
- The MySQL C API
- The Perl DBI API
- The PHP API
MySQL Administration
- Introduction to MySQL Administration
- The MySQL Data Directory
- General MySQL Administration
- Security
- Database Maintenance and Repair
|
| Prerequisites: |
- Introduction to UNIX, or equivalent
- Knowledge of the vi editor
|
| Audience: |
| This course is designed for individuals that are new to the administration of a MySQL database. |
|
| |
| Course Benefits: |
| Student will be able to administer a MySQL RDBMS for their company and understand how to mine information from this database. This course provides the foundation to build on more advanced topics incorporating MySQL into 3 tier solutions. |
| Materials Furnished: |
|
| Recommended Follow-On Course: |
- PHP
- Web Database Applications with PHP and MySQL
- Intermediate Unix & Shell Programming
|
|
|
|
|
|
