MySQL for Beginners

MySQL Logo
DKV Logo

Calendar

Dates
Timing Location
27 – 30 December 2015 9:00AM – 5:00PM Dubai Knowledge Village

Arabic_Man_Office

Duration

4 days

Participation Fees

$1,750 USD per participant

Course Description

This instructor led,hands-on class covers the fundamentals of SQL and relational databases,using MySQL as a teaching tool.Students who can benefit from this course are new or existing users of MySQL, who have little or no previous experience with a relational database management system.

Download Detailed Course Description

Audience

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

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

Introduction

  • Features and Benefits of MySQL
  • MySQL Products and Service
  • Community vs. Enterprise
  • 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

Functions

  • 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

Conclusion

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

‚Äč

Share Button
Skip to toolbar