現時市面上大部分資料庫 (Database) 軟件均提供 SQL 介面，著名的計有 Oracle、Sybase、IBM DB2、Microsoft SQL 等伺服器程式，當然它們的價值也絕不便宣。但礙於現代的應用程式編寫，幾乎全部都離不開資料處理，因此大部分系統均被架設為SQL伺服器; SQL程度語言更為成為現時程式編寫的必學配件。 MySQL 是開源世界中一個非常受歡迎的資料庫軟件，其功能之大並不遜於時下的商業資料庫軟件。現時世界各地各大小網站，大部分的資料庫後台都採用 MySQL。同時，MySQL 跟 Linux 作業系統一向有密不可分的關係。除了其大部分工具及開發均在 Linux 上進行外，各大 Linux 版本亦習慣以 GPL 軟件授權形式發行 MySQL 資料庫軟件，作為常設資料庫元件;加上過去數年，每年都獲得多項世界各地權威電腦雜誌的嘉許，MySQL 很快便成為 Linux 上最受歡迎的資料庫軟件。

課程包括 :
- MySQL Core Certification 筆記課本
- 模擬試題連參考答案
- 課程實習 CD-ROM 一隻
- 一人一機實習，針對各科考試要點溫習
- 再配合不同層次的 Lab Test 練習
- 本課程由擁有多年 Linux 工作及程式編寫經驗之導師任教


授課語言 :    以廣東話授課為主，亦會以英語輔助。


課程全長 :     8 堂 / 共 24 小時 (每堂 3 小時)


開課日期 :     MSQL0826         8 月 26 日 (逢星期 二，7 - 10 p.m)
　

課程費用 :    今個月報讀只需 $ 2,380

舊生報讀只需  $ 2,180

匯豐信用卡分期 $ 218 x 12 個月 (為保持課程質素，全部均包括筆記課本，模擬試題等。) 不用再等，請即致電 2380 9888 留返個位俾自己 !! MySQL 模擬試題下載

參加考試 :
MySQL 考試編號為 001-003，考生需要在 90 分鐘內完成 70 題選擇題，答對超過 70%。凡修讀本課程之同學，我們將可為你辨理一切考試有關之報名手續，費用全免。


課程內容 :

Chapter 1. MySQL and MySQL AB
Section 1.1. The Difference Between MySQL and MySQL AB
Section 1.2. How MySQL AB Operates
Section 1.3. MySQL Core Values
Section 1.4. MySQL Dual Licensing
Section 1.5. Organization and Structure of the MySQL Reference Manual
Section 1.6. The MySQL Mailing Lists

Chapter 2. MySQL Software
Section 2.1. Major Program Components Used in MySQL
Section 2.2. Major Operating System Families Supported by MySQL
Section 2.3. Differences Between Major MySQL Distributions
Section 2.4. Available MySQL Client Interfaces

Chapter 3. Using MySQL Client Programs
Section 3.1. Invoking Command-Line Client Programs
Section 3.2. The mysql Client Program
Section 3.3. Using mysqlimport
Section 3.4. Using mysqldump
Section 3.5. Checking Tables with mysqlcheck and myisamchk
Section 3.6. Using MySQLCC
Section 3.7. MySQL Connectivity Drivers

Chapter 4. Data Definition Language
Section 4.1. General Database and Table Properties
Section 4.2. Storage Engines and Table Types
Section 4.3. Limits on Number and Size of Database Components
Section 4.4. Identifier Syntax
Section 4.5. CREATE DATABASE and DROP DATABASE
Section 4.6. CREATE TABLE
Section 4.7. DROP TABLE
Section 4.8. ALTER TABLE
Section 4.9. Creating and Dropping Indexes
Section 4.10. Column Types
Section 4.11. Using SHOW and DESCRIBE to Review Table Structures

Chapter 5. The SELECT Statement
Section 5.1. Identifying What Values to Display
Section 5.2. Restricting a Selection Using WHERE
Section 5.3. Using ORDER BY to Sort Query Results
Section 5.4. Limiting a Selection Using LIMIT
Section 5.5. Aggregate Functions, GROUP BY, and HAVING
Section 5.6. Using DISTINCT to Eliminate Duplicates
Section 5.7. Concatenating SELECT Results with UNION

Chapter 6. Basic SQL
Section 6.1. Using SQL Expressions and Functions
Section 6.2. Using LIKE for Pattern Matching
Section 6.3. Using IN() to Test Membership in a List of Values
Section 6.4. Case Sensitivity of Identifiers and Reserved Words
Section 6.5. Using Reserved Words as Identifiers
Section 6.6. NULL Values
Section 6.7. Comments in SQL Statements

Chapter 7. Update Statements
Section 7.1. The INSERT and REPLACE Statements
Section 7.2. The UPDATE Statement
Section 7.3. The DELETE and TRUNCATE TABLE Statements

Chapter 8. Joins
Section 8.1. Writing Inner Joins
Section 8.2. Writing Outer Joins
Section 8.3. Converting Subqueries to Joins
Section 8.4. Resolving Name Clashes Using Qualifiers and Aliases
Section 8.5. Multiple-Table UPDATE and DELETE Statements

Chapter 9. Importing and Exporting Data
Section 9.1. The LOAD DATA INFILE Statement
Section 9.2. The SELECT … INTO OUTFILE Statement
Section 9.3. Datafile Format Specifiers
Section 9.4. Importing and Exporting NULL Values

Chapter 10. MySQL Architecture
Section 10.1. Client/Server Overview
Section 10.2. Choosing the Right Client
Section 10.3. Connecting the Client to the Server
Section 10.4. How MySQL Uses Disk Space
Section 10.5. How MySQL Uses Memory
Section 10.6. Log and Status Files
Section 10.7. MySQL Storage Engines

Chapter 11. MySQL Installation and Configuration
Section 11.1. Running MySQL on Windows
Section 11.2. Running MySQL on Unix
Section 11.3. Runtime MySQL Configuration
Section 11.4. Compiling MySQL from a Source Distribution
Section 11.5. Upgrading MySQL
Section 11.6. Optimizing the Operating System for MySQL Use
Section 11.7. Configuring Disks for MySQL Use
Section 11.8. Choosing Hardware for MySQL Use

Chapter 12. Security Issues
Section 12.1. Securing MySQL
Section 12.2. User Account Management
Section 12.3. Client Access Control

Chapter 13. Optimizing for Query Speed
Section 13.1. Index Optimization and Index Usage
Section 13.2. Using EXPLAIN to Analyze Queries
Section 13.3. General Query Enhancement
Section 13.4. Optimizing the Logical Database Structure

Chapter 14. MyISAM Tables
Section 14.1. Special MyISAM Features
Section 14.2. MyISAM-Specific Optimizations
Section 14.3. MyISAM Locking Strategies
Section 14.4. MyISAM Backup and Recovery
Section 14.5. Checking and Repairing MyISAM Tables
Section 14.6. MyISAM Table Maintenance

Chapter 15. InnoDB Tables
Section 15.1. The InnoDB Tablespace and Logs
Section 15.2. InnoDB Transaction Support
Section 15.3. How InnoDB Uses Locks
Section 15.4. InnoDB-Specific Optimizations
Section 15.5. InnoDB Backup and Recovery
Section 15.6. Checking and Repairing InnoDB Tables
Section 15.7. InnoDB Maintenance

Chapter 16. Advanced Server Features
Section 16.1. Interpreting mysqld Server Information
Section 16.2. Tuning Memory Parameters
Section 16.3. Using the Query Cache
Section 16.4. Using Multiple Servers
Section 16.5. Replication