Class #1 of the MySQL class is scheduled for this Monday, May 2nd at 7:00pm at CalTek. Address, directions, and parking information can be found
here.
Due to space limitations the class is now full so no more students are currently being accepted.
Class #1 will cover an introduction to the class, resources available, MySQL & MySQL AB, MySQL Software and Components, and an intro in getting information about MySQL database and table information, and data directories structure.
*Complete syllabus for Class #1 are continued in the further reading section.*
_Instructor:_
*David Benjamin :: david_AT_peterbenjamin_(dot)_com*
_Class Contact:_
*Sharon Lake :: sharon_AT_linuxchixla_(dot)_org*
_Lab Help:_
*Steve Glasser :: steve_AT_fpig_(dot)_net*
*_CLASS #1 SYLLABUS_*
Class 1 – Introduction. (Chapter 1 & 2 / MySQL-M 1, 2, 3.3, 3.4, 5, 8, 21, 22)
_20% exam material (5% Chapter 1, 10% Chapter 2)_
- Class Goals
To be introduced to the basic MySQL knowledge needed to pass the MySQL Core Certification. The MySQL Core Certification includes testing the knowledge needed to maintain a basic MySQL installation and use MySQL as a backend database for applications.
- MySQL Core and Professional Certifications
- Certifications available
- MySQL certification information can be found on the MySQL site.http://www.mysql.com/training/certification/
- Core Certification - tests basic MySQL knowledge sufficient to main a basic MySQL installation and create application p6t5yy7rograms that use MySQL as a backend database
- Professional Certification - covers installation, large table maintenance, storage engines, and optimizations.
- MySQL Certification Study Guide (ISBN: 0672326329)
- Study Guide Errata: http://www.mysql.com/training/certification/studyguides/errata.html
- Starting February 1st, 2005, the MySQL Certification Exams will be updated to reflect the changes that have taken place with the release of MySQL Server version 4.1.
- 4.1 Test Update information (http://www.mysql.com/training/certification/41update.html)
- MySQL Version 4.1 Exam Preparation addendum pdf (http://www.mysql.com/training/certification/mysql-certification-41addendum.pdf)
- MySQL Certification Self Test http://www.mysql.com/training/certification/self test/core/index.php
- Knoppix LiveCD. A Knoppix LiveCD will be available with the MySQL 4.1 server and client, the MySQL manual, and the sample 'World' database already pre-installed.
- Installed Components
- MySQL server -- user: root password: lampsig
- MySQL client
- MySQL Manual (pdf and html versions available). http://dev.mysql.com/doc/
- MySQL Certificate Study Guide Sample Chapter and Errata http://www.mysql.com/training/certification/studyguides/errata.html
- phpMyAdmin http://localhost/phpmyadmin
- Sample world Database installed. http://dev.mysql.com/doc/world-setup.html
http://dev.mysql.com/get/Downloads/Manual/world.sql.gz/from/pick
- What is MySQL
- MySQL and MySQL AB
- Dual Licensing
- GPL
- Commercial
- Major Program Components (mysqld server, mysql client programs)
- Server: mysqld / mysqld-max) & mysqld-nt / mysql-max-nt)
- Client(s)
- mysql
- MySQL Control Center (MySQLcc) -- No longer in development.
- MySQL Administrator -- Server administration
- MySQL Query Browser -- SQL browser
- mysqlimport
- mysqladmin
- mysqlcheck
- Difference Between Major MySQL Distributions
- States: pre-alpha, alpha, beta, gamma, production
- Production Versions: MySQL 4.0, 4.1, and 5)
- MySQL APIs
- Interfaces provided within MySQL (C client library, ODBC connector, JDBC connector)
- Third party interfaces (PERL DBD::mysql, PHP, Python, etc.) While these APIs are downloadable from the MySQL site, they do not receive official support.
- Interpreting the DESCRIBE output
- Field
- Type
- Null
- Key
- Default
- Extra
- Server / client architecture
- Creating New Database
- Root user vs. User. Brief overview of Grant tables (Note: not covered in MySQL Core Certification)
- Demonstration: create Sample World Database from MySQL command line
- Demonstration: populating the world database by importing Sample World Database .sql file
- Where is/are the data directory(ies)
- Intro to switching default databases with use (covered in depth in MySQL client)