MySQL Training Sessions at Sun CEC
I
will be delivering 2 - 3 MySQL training sessions a day during the Sun
Customer Engineering Conference (CEC). These sessions are targeted
towards Sun employees interested in learning a lot about MySQL, getting
certified or getting into MySQL professional services. Each session
will cover key areas of knowledge and certification topics. Each
session will also include tips and information needed to pursue MySQL
DBA certification.
These
sessions are going to provide an in-depth immersion into the MySQL
database server. We're also going to make these sessions, hands-on,
interactive and entertaining. Attendees will learn the core fundamentals for managing a MySQL database server. "What happens in Vegas, won't stay in Vegas", attendees will take back a lot of core fundamentals for managing a MySQL database server. I'm bringing my "A" game to these
sessions so I need you to bring yours. :)
Presenters
Anders Karlsson - MySQL Professional Services
David Stokes - MySQL Certification Manager
Clifford Conklin - Sun Professional Services
George Trujillo - MySQL Sr. Instructor
Domas Mituzas - Wikimedia
Training Environment
Materials used for the course will be the MySQL 5.0 Certification Study Guide. Students will need to take notes from the lectures and use the Certification Study Guide book during lectures. Sun Rays will be provided using Windows 2003. Students that have a Windows or Windows VM are welcome to bring their laptops and do the installs and hands on work with their own machines. We are planning on using MySQL 5.1.29 for the sessions.
Objective
Build
core fundamental knowledge in MySQL and show attendees the path to
certification and where to find things so they can get certified.
Intended Audience
Sun
employees with some database experience (SQL, Oracle, Postres, SQL
Server, etc) that want to get into delivering MySQL certification and
consulting.
Session Agenda
This agenda may change slightly as we get closer to the CEC.
Monday November 10, 2008
1:00 pm - 3:00 pm - Session 1 - Positioning MySQL and MySQL database installation
5:00 pm - 7:00 pm - Session 2 - Understanding the MySQL architecture
Tuesday November 11, 2008
9:00 am - 12:00 pm - Session 3 - Starting, stopping and configuring MySQL
1:00 pm - 3:00 pm - Session 4- Client programs and MySQL Administrator
5:00 pm - 7:00 pm - Session 5 - Storage engines and table/index management
Wednesday November 12, 2008
9:00 am - 12:00 pm - Session 6 - INFORMATION_SCHEMA, admin logs and diagnostics
1:00 pm - 3:00 pm - Session 7 - Locking and transactions
5:00 pm - 7:00 pm - Session 8 - User management and security
Thursday November 12, 2008
9:00 am - 12:00 pm - Session 9 - Optimizing queries, database and the server
1:00 pm - 3:00 pm - Session 10 - Backup and Recovery
5:00 pm - 7:00 pm - Session 11 - Managing multiple servers and replication
Friday November 14, 2008
The
assessment will be made up of 40 questions designed to test for
knowledge gained during the sessions and to verify you have all
information needed to pursue a path for certification.
10:00 am - 12:00 pm - Session 12 - Assessment