RKG Logo training-ITBiz
RKG Logo
Home Courses Fees Schedule REGISTER NOW Corporate Training Locations
Microsoft Office Tools
Adobe Acrobat Courses
SharePoint Training
Microsoft Dynamics
Social Media Courses
Project Management
Application Devp Tools
Oracle Developer Tools
Data Warehouse & BI
Data Base & System Admin
Programming Languages
Reporting Tools
Networking & Security
Web Technologies
Medical Records
Business Skills
ERP Training
Corporate Training On-Site
Microsoft MySQL DBA
Software Version MySQL 5.x
Course Duration 2 Days
Course Type Class Room and Instructor-Led On-Line (E-Learning) Hands-On Training
Course Overview 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.
Intended Audience for this course 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.
Course Topics
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

Enroll Online   

Live Chat
Enroll Online
Enroll By Fax
Fee & Schedule
Send Message
Follow us on .....
For further information call 949-387-3772 or FAX 949-681-8247 or email to info@SONUtraining.com
SONU Training is the training wing of RKG Technologies Inc
Disclaimer: RKG Technologies is not linked with Microsoft, Oracle, Adobe, IBM or any other software company we provide training
Copyright © 2004 RKG Technologies Inc. All rights reserved.