> > > D61918

MySQL for Beginners (D61918)

Course Description Schedule
 

Prerequisites

Required Prerequisites:

  • Basic computer literacy is required

Suggested Prerequisites:

  • 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

Introduction

  • 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

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
Classroom Training

Duration 4 days

Dates and Booking
Online Training

Duration 4 days

Dates and Booking
 
Schedule

Currently there are no training dates scheduled for this course.  Enquire a date