MySQL Development and Administration: Hands-On

Frequently Asked Questions

What is this course about? This course provides a comprehensive introduction to the MySQL relational database management system. Course participants gain the skills necessary to administer and maintain MySQL databases while addressing the scalability and reliability issues associated with the database. What is MySQL? MySQL is a commercial-grade, open-source relational database management system. It runs on a variety of platforms, including UNIX/Linux, Windows and Macintosh. Its very low cost (MySQL is free for most users), its ease of maintenance, and its high speed combine to make MySQL ideal for many application areas. What is open-source? What is LAMP? Open-source software is software distributed for free. Anyone can install, use and modify the software. Although typically the software has been developed for no commercial gain, various for-profit companies offer support and maintenance for a fee. LAMP is an acronym for Linux, Apache, MySQL and PHP-a combination of open-source programs used by many organizations around the world. Who will benefit from this course? Typical course participants include developers, Web site designers, Web creators, database administrators, Webmasters, technical managers and project leaders who require an in-depth understanding of MySQL. The course is also valuable for anyone evaluating database servers, including database consultants, Web development consultants and system architects. What background knowledge do I need? A basic familiarity with the Windows or Linux operating system is required. How much time is spent on each topic? Content Hours Introduction to MySQL 1.0 Creating SQL queries 3.5 Designing MySQL databases 3.5 Managing MySQL RDBMSs 3.5 Building stored procedures 2.0 MySQL scalability and reliability 2.5 Times, including the workshops, are estimates; exact times may vary according to the needs of each class. What do the hands-on exercises cover? The hands-on exercises are designed to reinforce the material presented in the course notes. Exercises include creating and modifying MySQL user accounts and privileges, designing and building database tables, manipulating data using SQL queries, and removing SQL from external applications with stored procedures. What platform is used for the hands-on exercises? The course runs on both Windows XP and Linux. Students can select the operating system they prefer for the hands-on exercises, as the exercises are identical on both platforms. If I do not intend to use MySQL in a Web-based environment, is this course relevant to me? Yes. MySQL can be used in a variety of non-Web-based applications, including stand-alone operation and client-server architectures. The course covers administration and maintenance of MySQL, and is valuable even for those intending to use the database server as a standalone product. How does this course relate to other Learning Tree courses? 382, Relational Database Design, Tools and Techniques: Hands-On provides invaluable insight into database design, and is highly recommended for anyone unfamiliar with relational database concepts 519, Introduction to PHP for Web Development: Hands-On provides the skills for building dynamic Web applications, including scripts with MySQL connectivity Other courses in the Learning Tree Web Development curriculum that may be of interest include: 470, Developing a Web Site: Hands-On  provides the knowledge and skills you need to develop a well-designed Web site 487, Designing and Building Great Web Pages: Hands-On provides you with extensive hands-on experience designing and delivering professional Web pages 489, JavaScript for Web Development: Hands-On provides in-depth hands-on experience writing client-side JavaScript. 986, Developing Ajax Web 2.0 Applications: Hands-On provides the knowledge and practical skills required to efffectively design, create and implement Ajax-enabled Web sites 143, Linux®: A Comprehensive Hands-On Introduction provides the essential knowledge and skills required to leverage the wide range of Linux graphical and command-line tools

MySQL is a trademark of MySQL AB.