Training Calendar

 ◄◄  ◄  ►►  ► 
August 2017
Mon Tue Wed Thu Fri Sat Sun
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
No Image
Kuala Lumpur
Date :  22-08-2017
23
No Image
Kuala Lumpur
Date :  23-08-2017
24
25
26
27
28
29
No Image
Kuala Lumpur
Date :  29-08-2017
30
No Image
Kuala Lumpur
Date :  30-08-2017
31

psmb

Total Visitors

40.1%Malaysia Malaysia
23.9%United States United States
5.1%Philippines Philippines
4.5%India India
2.8%Indonesia Indonesia
2.8%Australia Australia
2.5%China China
2.5%Singapore Singapore
1.4%Canada Canada
1.1%United Kingdom United Kingdom

Today: 1
Yesterday: 9
This Week: 11
Last Week: 20
This Month: 157
Last Month: 169
Total: 12129

MySQL for Developers

 

Course Overview

  • Do you want to learn how to develop database applications on MySQL?
  • Do you need to use MySQL Stored Procedures, Triggers, Views, and Information Schema?
  • Do you want to create complex reports, use complex queries to retrieve data and aggregate results?
  • Do you want to transfer your data from one server to another?

Then MySQL for Developers is for you! With an Authorized MySQL instructor and hands-on exercises you will learn how to develop applications with all the new features of MySQL 5.0. This instructor-led course is designed for students planning on developing applications that make use of MySQL 5.0. This course covers essential SQL statements for data design, querying, and programming. In addition, it will prepare students for the MySQL Developer certification.

 

 

Pre-requisites

Having attended the MySQL 5.0 for Beginners course or some experience with relational databases and SQL.

MySQL Developers - Schedule

Day 1

09.00am – 10.00am

Introduction

  • MySQL Overview, Products and Services
  • MySQL Enterprise Services
  • Supported Operating Services
  • MySQL Certification Program
  • Training Curriculum Paths
  • MySQL Website
  • Installing MySQL and the World Database
10.00am – 10.30am

Breakfast

10.30am – 12.45pm

MySQL Client/Server Concepts

  • MySQL General Architecture
  • How MySQL Uses Disk Space
  • How MySQL Uses Memory

MySQL Clients

  • Invoking Client Programs
  • Using Option Files
  • The MySQL Client
  • MySQL Query Browser
  • MySQL Connectors
  • Third-Party APIs

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

Querying for Table Data

  • The SELECT Statement
  • Aggregating Query Results
  • Using UNION

Handling Errors and Warnings

  • SQL Modes
  • Handling Missing or Invalid Data Values
  • Interpreting Error Messages

SQL Expressions

  • SQL Comparisons
  • Functions in SQL Expressions
  • Comments in SQL Statements

Day 2

09.00am – 10.00am

Data Types

  • Data Type Overview
  • Numeric Data Types
  • Character String Data Types
  • Binary String Data Types
  • Temporal Data Types
  • NULLs

10.00am – 10.30am

Breakfast

10.30am – 12.45pm

Obtaining Metadata

  • Metadata Access Methods
  • The INFORMATION_SCHEMA Database/Schema
  • Using SHOW and DESCRIBE
  • The mysqlshow Command

Databases

  • Database Properties
  • Good Design Practices
  • Identifiers
  • Creating Databases
  • Altering Databases
  • Dropping Databases

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

Tables

  • Creating Tables
  • Table Properties
  • Column Options
  • Creating Tables Based on Existing Tables
  • Altering Tables
  • Dropping Tables
  • Foreign Keys

                                                                        Day 3

09.00am – 10.00am

Manipulating Table Data

  • The INSERT Statement
  • The DELETE Statement
  • The UPDATE Statement
  • The REPLACE Statement
  • INSERT with ON DUPLICATE KEY UPDATE
  • The TRUNCATE TABLE Statement

10.00am – 10.30am

Breakfast

10.30am – 12.45pm

Transactions

  • What is a Transaction?
  • Transaction Commands
  • Isolation Levels
  • Locking

Joins

  • What is a Join?
  • Joining Tables in SQL
  • Basic Join Syntax
  • Inner Joins
  • Outer Joins
  • Other Types of Joins
  • Joins in UPDATE and DELETE statements

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

Subqueries

  • Types of Subqueries
  • Table Subquery Operators
  • Correlated and Non-Correlated Subqueries
  • Converting Subqueries to Joins

Views

  • What Are Views?
  • Creating Views
  • Updatable Views
  • Managing Views
  • Obtaining View Metadata

                                                                        Day 4

09.00am – 10.00am

Prepared Statements

  • Why Use Prepared Statements?
  • Using Prepared Statements from the mysql Client
  • Preparing a Statement
  • Executing a Prepared Statement
  • Deallocating a Prepared Statement

10.00am – 10.30am

Breakfast

10.30am – 12.45pm

Exporting and Importing Data

  • Exporting and Importing Data
  • Exporting and Importing Data Using SQL
  • Exporting and Importing Data Using MySQL Client Programs
  • Import Data with the SOURCE Command

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

Stored Routines

  • What is a Stored Routine?
  • Creating, Executing and Deleting Stored Routines
  • Compound Statements
  • Assign Variables
  • Parameter Declarations
  • Flow Control Statements
  • Declare and Use Handlers
  • Cursors

                                                                        Day 5

09.00am – 10.00am

Triggers

  • What are Triggers?
  • Delete Triggers
  • Restrictions on Triggers

10.00am – 10.30am

Breakfast

10.30am – 12.45pm

Storage Engines

  • SQL Parser and Storage Engine Tiers
  • Storage Engines and MySQL
  • The MyISAM Storage Engine
  • The InnoDB Storage Engine
  • The MEMORY Storage Engine
  • Other Storage Engines

12.45pm – 02.15pm

Lunch

02.15pm – 05.00pm

Optimization

  • Overview of Optimization Principles
  • Using Indexes for Optimization
  • Using EXPLAIN to Analyze Queries
  • Query Rewriting Techniques
  • Optimizing Queries by Limiting Output
  • Using Summary Tables
  • Optimizing Updates
  • Choosing Appropriate Storage Engines