Introduction to Database Design using MySQL (1 Day Training)
 

 

Hands-on Training includes:

  • Small group (max 12 student)
  • One computer per student
  • Training Material
  • Certified Instructor
  • Quick Reference Guide
  • One hour of Free Consulting Services

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 utilizing MySQL. This course will also help students who are preparing for the CIW Database Design Specialist Exam ID0-541; Sun Certified MySQL Associate (SCMA); Sun Certified MySQL Developer (SCMDEV); Sun Certified MySQL Database Administrator (SCMDBA);

Target Audience
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.

Objectives

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. Upon successful completion of this course, students will be able to:

  • identify the fundamental concepts of databases and explore the MySQL RDBMS interface elements.
  • create a preliminary database design.
  • apply normalization techniques to a database.
  • use SQL commands to execute simple queries.
  • use SQL compound statements to query efficiently.
  • manage databases by creating views, indexes, and transactions.
  • administer and maintain a database.

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.

Delivery Method

Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

  • Familiarizing Yourself with the Fundamentals of Databases
  • Identify the Database Development Life Cycle
  • Explore the MySQL RDBMS
  • Creating a Preliminary Database Design
  • Analyze Database Requirements
  • Identify Key Fields
  • Create Entity Relationship Diagrams
  • Applying Normalization Techniques
  • Normalize Tables
  • Denormalize Tables
  • Using the SQL Commands to Work with Tables
  • Discuss Structured Query Language (SQL)
  • Create Tables Using the Data Definition Language (DDL) Commands
  • Modify Data Using Data Manipulation Language (DML) Commands
  • Working with Databases
  • Use SQL Compound Statements
  • Create Triggers
  • Managing Databases
  • Create Indexes
  • Create Views
  • Create Transactions
  • Administering a Database
  • Perform Database Administration
  • Perform Backup and Recovery

For more information, call 714-505-3475

For Schedule, click here.