skip to content
Certified Ethical Hacker and Computer Hacking Certification classes

Class is offered on the following dates (click on a date to register):


Monday December 4th 2017 and Tuesday December 5th 2017
Monday January 8th 2018 and Tuesday January 9th 2018





MySQL: Fundamentals of Databases


Course code: 10136

Prerequisites: None.

Price (plus GST): $595.00

Duration: 2 days

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

Outline:

  • 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