MySQL for beginners ( SQL -4401)

Oracle University |

MySQL for Beginners (SQL-4401)


4 Days

 What you will learn

Here is your chance to learn how this powerful relational database management system can make your life easier and

more fun! This class covers all the basics and will get you on your way, with a solid foundation. This instructor led,

hands-on class covers the fundamentals of SQL and relational databases, using MySQL[tm] as a teaching tool.

Students who can benefit from this course:

New or existing users of MySQL, who have little or no previous experience with a relational database management



Required Prerequisites

Knowledge of database concepts

Previous experience with any command-line program

Basic computer literacy is required

Course Objectives

Understand the features and benefits of MySQL

Be able to install and start the MySQL server

Understand the basics of Relational Databases

Understand the SQL and MySQL languages

Understand Data/Column types with regard to efficient database design

Be able to view a database design structure/content

Create a database design using an efficient structure

Be able to extract basic database information using the SELECT command

Be able to troubleshoot syntax and understand typical warnings and errors

Be able to delete or modify a database, and table row data

Grouping query data with Aggregation

Connect data from multiple table rows using JOIN

Perform nested sub-queries

Use of Simple Functions (String, Date, Numerical)

Describe MySQL connectors, their major features and differences

Understand MySQL storage engines, transactions and features of the common engines

Course Topics


Features and Benefits of MySQL

MySQL Products and Service

Community vs. Enterprise

MySQL Certification Program

MySQL Certification Program

MySQL Website

MySQL Architecture

Install and Start MySQL

Database Basics

SQL Language and MySQL

Database Design

Database Modeling



Data Types

What is NULL?

Viewing Database Structure

Database Creation

Create a New Database Structure

Creating a Database

Creating a Table

Basic Queries

The SELECT Command

MySQL Query Browser


Database Maintenance

Delete an Entire Database

Maintaining Tables

Maintaining Columns

Indexes and Constraints

Data Manipulation

Delete/Modify Table row Data

The INSERT Command

The REPLACE Command

The UPDATE Statement

The DELETE Command


Simple Functions

Grouping With Functions

Joining Tables

Combining Multiple Tables

Inner Joins

Outer Joins

Exporting/Importing Data

Exporting Data

Importing Data

Sub queries

What is a Sub query?

Categories of Sub queries

Sub query Types

Placing Sub queries

Other Sub query Uses

Other Sub query Uses

Supplementary Information

Creating VIEWs


Storage Engines

Retrieving Metadata


Course Review

Training and Certification Website

Course Evaluation

Thank You!

QA Session





pearson vueISO 9001