Fundamentals of Databases Using MySQL

Displaying courses for United States [Change]

Overview

In this course, students 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.

Objectives

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.

Audience

Target students can be persons 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.

Syllabus

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

Training provider

Teaching mode:
Online - Self paced
Classroom - Instructor Led
Duration: 1 day
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

SQL
United States
This skill has an average salary of
US$93,553
and is mentioned in
7.30%
of job ads in this area.
Database
United States
This skill has an average salary of
US$77,701
and is mentioned in
14.10%
of job ads in this area.
Database design
United States
This skill has an average salary of
US$92,361
and is mentioned in
0.58%
of job ads in this area.
Database Administration
United States
This skill has an average salary of
US$94,469
and is mentioned in
0.52%
of job ads in this area.