LAMPsig MySQL Class :: Class #1

LAMPsig Meetings

3rd Saturday of the Month 1-3pm
Tom Bradley Youth and Family Center
5213 West Pico Blvd.
Los Angeles, CA 90019

Monday, May 2. 2005

LAMPsig MySQL Class :: Class #1

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
1. Certifications available
  1. 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.
2. MySQL Certification Study Guide (ISBN: 0672326329)
  1. Study Guide Errata: http://www.mysql.com/training/certification/studyguides/errata.html
3. 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.
  1. 4.1 Test Update information (http://www.mysql.com/training/certification/41update.html)
  2. MySQL Version 4.1 Exam Preparation addendum pdf (http://www.mysql.com/training/certification/mysql-certification-41addendum.pdf)
4. 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.
1. Installed Components
  1. MySQL server -- user: root password: lampsig
  2. MySQL client
  3. MySQL Manual (pdf and html versions available). http://dev.mysql.com/doc/
  4. MySQL Certificate Study Guide Sample Chapter and Errata http://www.mysql.com/training/certification/studyguides/errata.html
  5. phpMyAdmin http://localhost/phpmyadmin
  6. 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
1. GPL
2. Commercial

Major Program Components (mysqld server, mysql client programs)
1. Server: mysqld / mysqld-max) & mysqld-nt / mysql-max-nt)
2. Client(s)
  1. mysql
  2. MySQL Control Center (MySQLcc) -- No longer in development.
  3. MySQL Administrator -- Server administration
  4. MySQL Query Browser -- SQL browser
3. mysqlimport
4. mysqladmin
5. mysqlcheck
Difference Between Major MySQL Distributions
1. States: pre-alpha, alpha, beta, gamma, production
2. Production Versions: MySQL 4.0, 4.1, and 5)
MySQL APIs
1. Interfaces provided within MySQL (C client library, ODBC connector, JDBC connector)
2. 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
1. Field
2. Type
3. Null
4. Key
5. Default
6. Extra
7. Server / client architecture
Creating New Database
1. Root user vs. User. Brief overview of Grant tables (Note: not covered in MySQL Core Certification)
2. Demonstration: create Sample World Database from MySQL command line
3. 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)

Posted by Sharon Lake in Classes: MySQL at 19:00 | Comment (1) | Trackbacks (0)
View as PDF: This entry | This month | Full blog

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

Sharon,

This is one of the most clearcut syllabi I've ever seen in the computer communities in the LA areas. Most groups, while organizing classes & meetings, do not have syllabi. Yoy did the greatest job, setting an example for LAMP-sig.

Keep it up, Sharon.

#1 Martin Huh (Link) on 2005-04-30 07:00 (Reply)

Add Comment

Name
Email
Homepage
In reply to
Comment	E-Mail addresses will not be displayed and will only be used for E-Mail notifications To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly. Enter the string from the spam-prevention image above: BBCode format allowed
	Remember Information? Subscribe to this entry

View as PDF: This entry | This month | Full blog

Deprecated: Assigning the return value of new by reference is deprecated in /home/lampsig/public_html/new/plugins/serendipity_plugin_remoterss/serendipity_plugin_remoterss.php on line 51

Deprecated: Assigning the return value of new by reference is deprecated in /home/lampsig/public_html/new/plugins/serendipity_plugin_remoterss/serendipity_plugin_remoterss.php on line 410

Deprecated: Assigning the return value of new by reference is deprecated in /home/lampsig/public_html/new/plugins/serendipity_plugin_remoterss/serendipity_plugin_remoterss.php on line 476