| |
A630
MySQL: Fundamentals of Database Design
|
|
|
Description:
|
|
|
Information can be stored, linked, and managed using a database application such as MySQL. In this hands-on course, you will work with the fundantals of databases design using MySQL.
|
| |
| |
PreRequisite: |
| |
|
You should have some familiarity with the Microsoft Windows environment, Microsoft Office applications, or similar office productivity applications.
|
| |
| |
Duration: |
|
|
|
8
hour(s)
|
| |
| |
Course Detail: |
|
|
|
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. Target: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 database(s).
|
| |
| |
Topics:
|
|
|
|
1. Familiarizing Yourself with the Fundamentals of Databases
- Identify the Database Development Life Cycle
- Explore the MySQL RDBMS
2. Creating a Preliminary Database Design
- Analyze Database Requirements
- Identify Key Fields
- Create Entity Relationship Diagrams
3. Applying Normalization Techniques
- Normalize Tables
- Denormalize Tables
4. 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
5. Working with Databases
- Use SQL Compound Statements
- Create Triggers
6. Managing Databases
- Create Indexes
- Create Views
- Create Transactions
7. Administering a Database
- Perform Database Administration
- Perform Backup and Recovery
|
| |
| |
Date & Time: |
|
