課程簡介

現時市面上大部分資料庫 (Database) 軟件均提供 SQL 介面,著名的計有 Oracle、Sybase、IBM DB2、Microsoft SQL 等伺服器程式,當然它們的價值也絕不便宜。但礙於現代的應用程式編寫,幾乎全部都離不開資料處理,因此大部分網站系統均安裝MySQL 作為數據庫伺服器 ,MySQL 更為成為現時網頁程式編寫的必學配件。

MySQL 是開源世界中一個非常受歡迎的資料庫軟件,其功能之大並不遜於時下的商業資料庫軟件。現時世界各地各大小網站,大部分的資料庫後台都採用 MySQL。同時,MySQL 跟 Linux 作業系統一向有密不可分的關係。除了其大部分工具及開發均在 Linux 上進行外,各大 Linux 版本亦習慣以 GPL 軟件授權形式發行 MySQL 資料庫軟件,作為常設資料庫元件,加上過去每年都獲得多項世界各地權威電腦雜誌的嘉許,MySQL 很快便成為 Linux 上最受歡迎的資料庫軟件。



適合人仕:

網頁開發人員,程式編寫人員
系統工程師,資訊科技部門主管 / 經理
對編寫網頁程式及數據庫有興趣的人士
修讀條件:

對 Windows 操作有基本認識
對互聯網及網站運作有基本概念
對網絡系統及程式編寫有基本概念
課程包括:
 
導師精心編製 Certified MySQL Associate 課程筆記
Certified MySQL Associate 電子書
課程實習 CD-ROM 一隻
一人一機實習,針對各科考試要點溫習
再配合不同層次的 Lab Test 練習
全新 5 月份更新的模擬試題連參考答案 (模擬試題 "一年" 免費更新保證,考試更有彈性)

由擁有多年網頁編寫及實戰經驗導師任教

課程電腦設備:
 
我們課程所使用的電腦全部採用 Intel Xeon 3.4Ghz 超高速四核心八線程的伺服器級處理器、 配合 16GB DDR3 記憶體、128GB SSD 固態硬碟、2TB SATA3 Hard Disk、19" LCD Display,加上每部電腦均連接上 1 Gigabit Ethernet 高速網絡,在學習過程中保證為您帶來非凡的超高速體驗。

 

授課語言:

以廣東話授課為主,亦會以英語輔助

 

課程全長:

8 堂 / 24 小時 (每堂 3 小時)


開課日期:
 
詳情請與本中心職員聯絡



課程費用:

$ 2,380

匯豐信用卡可享 12 個月 免息分期優惠 (每月只須 $ 199)
舊生或舊生介紹可享 95 折 優惠 (請預早致電留位時登記作實)
舊生在報名表上獲導師簽名推薦更可享 9 折 優惠 (有關詳情請向您的導師查詢)

 

完成本課程後可參加的相關考試:

(010-002) Certified MySQL Associate
試題數量: 50 題
考試時間: 60 分鐘
合格分數: 37/50

模擬試題參考


 

成功通過考試後獲得的國際認可證書及資格:


 


Certified MySQL Associate 課程內容 :
Chapter 1. MySQL and MySQL AB

The Difference Between MySQL and MySQL
How MySQL AB Operates
MySQL Core Values
MySQL Dual Licensing
Organization and Structure of the MySQL Reference Manual
The MySQL Mailing Lists

Chapter 2. MySQL Software

Major Program Components Used in MySQL
Major Operating System Families Supported by MySQL
Differences Between Major MySQL Distributions
Available MySQL Client Interfaces

Chapter 3. Using MySQL Client Programs

Invoking Command-Line Client Programs
The mysql Client Program
Using mysqlimport
Using mysqldump
Checking Tables with mysqlcheck and myisamchk
Using MySQLCC
MySQL Connectivity Drivers

Chapter 4. Data Definition Language

General Database and Table Properties
Storage Engines and Table Types
Limits on Number and Size of Database Components
Identifier Syntax
CREATE DATABASE and DROP DATABASE
CREATE TABLE
DROP TABLE
ALTER TABLE
Creating and Dropping Indexes
Column Types
Using SHOW and DESCRIBE to Review Table Structures

Chapter 5. The SELECT Statement

Identifying What Values to Display
Restricting a Selection Using WHERE
Using ORDER BY to Sort Query Results
Limiting a Selection Using LIMIT
Aggregate Functions, GROUP BY, and HAVING
Using DISTINCT to Eliminate Duplicates
Concatenating SELECT Results with UNION

Chapter 6. Basic SQL

Using SQL Expressions and Functions
Using LIKE for Pattern Matching
Using IN() to Test Membership in a List of Values
Case Sensitivity of Identifiers and Reserved Words
Using Reserved Words as Identifiers
NULL Values
Comments in SQL Statements

Chapter 7. Update Statements

The INSERT and REPLACE Statements
The UPDATE Statement
The DELETE and TRUNCATE TABLE Statements

Chapter 8. Joins

Writing Inner Joins
Writing Outer Joins
Converting Subqueries to Joins
Resolving Name Clashes Using Qualifiers and Aliases
Multiple-Table UPDATE and DELETE Statements

Chapter 9. Importing and Exporting Data

The LOAD DATA INFILE Statement
The SELECT … INTO OUTFILE Statement
Datafile Format Specifiers
Importing and Exporting NULL Values

Chapter 10. MySQL Architecture

Client/Server Overview
Choosing the Right Client
Connecting the Client to the Server
How MySQL Uses Disk Space
How MySQL Uses Memory
Log and Status Files
MySQL Storage Engines

Chapter 11. MySQL Installation and Configuration

Running MySQL on Windows
Running MySQL on Unix
Runtime MySQL Configuration
Compiling MySQL from a Source Distribution
Upgrading MySQL
Optimizing the Operating System for MySQL Use
Configuring Disks for MySQL Use
Choosing Hardware for MySQL Use

Chapter 12. Security Issues

Securing MySQL
User Account Management
Client Access Control

Chapter 13. Optimizing for Query Speed

Index Optimization and Index Usage
Using EXPLAIN to Analyze Queries
General Query Enhancement
Optimizing the Logical Database Structure

Chapter 14. MyISAM Tables

Special MyISAM Features
MyISAM-Specific Optimizations
MyISAM Locking Strategies
MyISAM Backup and Recovery
Checking and Repairing MyISAM Tables
MyISAM Table Maintenance

Chapter 15. InnoDB Tables

The InnoDB Tablespace and Logs
InnoDB Transaction Support
How InnoDB Uses Locks
InnoDB-Specific Optimizations
InnoDB Backup and Recovery
Checking and Repairing InnoDB Tables
InnoDB Maintenance

Chapter 16. Advanced Server Features

Interpreting mysqld Server Information
Tuning Memory Parameters
Using the Query Cache
Using Multiple Servers
Replication