> > > D61918GC30

MySQL for Beginners (SQL-4401) (D61918GC30)

Course Description Schedule


Erforderliche Vorkenntnisse:

  • Basic computer literacy is required

Empfohlene Vorkenntnisse:

  • Previous experience with any command-line program
  • Knowledge of database concepts

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 Content


  • 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
  • Keys
  • Normalization
  • 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
  • Troubleshooting

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
  • Transactions
  • Storage Engines
  • Retrieving Metadata


  • Course Review
  • Training and Certification Website
  • Course Evaluation
  • Thank You!
  • QA Session
Classroom Training

Duration 4 days

Price (excl. tax)
  • Germany: 1,800.- €
Dates and Booking
Online Training
Price (excl. tax)
  • Germany: 1,768.- €
Dates and Booking
Click on town name to bookSchedule
13/02/2017 - 16/02/2017 Munich
15/05/2017 - 18/05/2017 Munich