Storing and accessing data are part of a person's day-to-day activities. One of the most efficient and powerful ways of managing data is by using databases. Information can be stored, linked, and managed using a database application such as MySQL 5.1. In the Fundamentals of Databases Using MySQL course, you will work with the databases using MySQL.
Course Objective: You will work with databases by identifying the fundamental concepts of databases, creating a preliminary database design, applying normalization techniques, and familiarizing yourself with relational database management systems. Using various SQL commands, indexes, and views, you can work with and modify data efficiently within a database. Using features such as Enterprise Monitor and MySQL Administrator, you can manage users and administer and monitor a database
Target Student: This course is designed for people who are familiar with the Windows environment and any Office productivity application, and who wish to acquire competency in performing basic database operations and administration using the MySQL RDBMS or various similar SQL-based RDBMS products. The other student profile would be IT systems managers who will be working within a MySQL RDBMS-based enterprise IT department and need to interact in a productive manner with MySQL RDBMS technical professionals. It can also be used by students who wish to gain familiarity with database system terminologies and usage so as to pursue a career as a MySQL RDBMS technical professional.
Prerequisites: To be successful in this course, you should have some familiarity with the Microsoft Windows environment, Microsoft Office applications, or similar office productivity applications. The following Element K courses or equivalent experience is suggested:
Introduction to Personal Computers: Using Windows Vista™
Windows XP Professional: An Introduction
In addition, some experience with a programming language such as C++ is helpful but not required.
The following course or equivalent experience is suggested:
Introduction to Programming Using C++
Course is subject to a minimum enrollment to run. Course doesn't include courseware cost. Please contact firstname.lastname@example.org for additional cost. Course may run as a virtual instructor led if the minimum enrollment is not met.