(212) 684-5151

Fundamentals of Databases using MySQL
Fundamentals of Databases using MySQL

Price: $325.00

Course Code: MY | Hours: 8

Fundamentals of Databases using MySQL Training 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.

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.

What You'll Learn in this Class:

  • 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:

Students should have a basic understanding of Windows, including how to use files and folders.

Related Classes:

See Also:

Prerequisites:

Students should have a basic understanding of Windows, including how to use files and folders.

Related Classes:

See Also:

Fundamentals of Databases Using MySQL Training Outline

Lesson 1: Familiarizing Yourself with the Fundamentals of Databases

• Topic 1A: Identify the Database Development Life Cycle
• Topic 1B: Explore the MySQL RDBMS

Lesson 2: Creating a Preliminary Database Design

• Topic 2A: Analyze Database Requirements
• Topic 2B: Identify Key Fields
• Topic 2C: Create Entity Relationship Diagrams

Lesson 3: Applying Normalization Techniques

• Topic 3A: Normalize Tables
• Topic 3B: Denormalize Tables

Lesson 4: Using the SQL Commands to Work with Tables

• Topic 4A: Discuss Structured Query Language (SQL)
• Topic 4B: Create Tables Using the Data Definition Language (DDL) Commands
• Topic 4C: Modify Data Using Data Manipulation Language (DML) Commands

Lesson 5: Working with Databases

• Topic 5A: Use SQL Compound Statements
• Topic 5B: Create Triggers

Lesson 6: Managing Databases

• Topic 6A: Create Indexes
• Topic 6B: Create Views
• Topic 6C: Create Transactions

Lesson 7: Administering a Database

• Topic 7A: Perform Database Administration
• Topic 7B: Perform Backup and Recovery