D62172GC10_sg

Full text

(1)Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. Thi. e. bl a r fe. s. an r t n. no a s a h MySQL Developer n) ideฺTechniques v ฺ om t Gu c ฺ 21 den s t tuGuide sp Student S @ s i n h a t r t SQL-4305 Release 1.1 e ฺ s n u o o to m ( e an icens r T l et. uy g N. D62172GC10 Edition 1.0 January 2011 D63882.

(2) Copyright © 2008, 2009, 2011, Oracle and/or its affiliates. All rights reserved.. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. Disclaimer. Thi. This document contains proprietary information, is provided under a license agreement containing restrictions on use and disclosure, and is protected by copyright and other intellectual property laws. You may copy and print this document solely for your own use in an Oracle training course. The document may not be modified or altered in any way. Except as expressly permitted in your license agreement or allowed by law, you may not use, share, download, upload, copy, print, display, perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part without the express authorization of Oracle. The information contained in this document is subject to change without notice. If you find any problems in the document, please report them in writing to: Oracle University, 500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not warranted to be error-free. Sun Microsystems, Inc. Disclaimer This training manual may include references to materials, offerings, or products that were previously offered by Sun Microsystems, Inc. Certain materials, offerings, services, or products may no longer be offered or provided.Oracle and its affiliates cannot be held responsible for any such references should they appear in the text provided.. e. bl a r fe. Restricted Rights Notice If this documentation is delivered to the U.S. Government or anyone using the documentation on behalf of the U.S. Government, the following notice is applicable:. s. an r t n. o. U.S. GOVERNMENT RIGHTS The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or disclose these training materials are restricted by the terms of the applicable Oracle license agreement and/or the applicable U.S. Government contract.. an s a h ) n ideฺ v ฺ om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t e onฺ to us o (m nse n a r ce T i l t e. Trademark Notice. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. UNIX is a registered trademark licensed through X/Open Company, Ltd.. uy g N.

(3) Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. Thi. This page intentionally left blank.. e. s. bl a r fe. o. an r t n. uy g N. an s a h ) n ideฺ v ฺ om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t e onฺ to us o (m nse n a r ce T i l t e.

(4) Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. Thi. e. s. o. uy g N an s a h ) n ideฺ v ฺ om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t e onฺ to us o (m nse n a r ce T i l t e an r t n bl a r fe.

(5) Conventions Used in This Training Guide. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. This training guide uses certain typographical conventions: • TEXT IN THIS STYLE is used for SQL statements; database, table, and column names; program listings and source code; and environment variables. Example: “To reload the grant tables, use the FLUSH PRIVILEGES statement.”. Thi. Text in this style indicates input that you type in examples. Text in this style indicates the names of executable programs and scripts, examples being mysql (the MySQL command line client program) and mysqld (the MySQL server executable). • Text in this style is used for variable input for which you should substitute a value of your own choosing. • Filenames and directory names are written like this: “The global my.cnf file is located in the /etc directory.” • Character sequences are written like this: “To specify a wildcard, use the '%' character.” • Text in this style is used for emphasis. When commands are shown that are meant to be executed from within a particular program, the prompt shown preceding the command indicates which command to use. For example, shell> indicates a command that you execute from your login shell, and mysql> indicates a statement that you execute from the mysql client program: shell> type a shell command here mysql> type a mysql statement here The “shell” is your command interpreter. On Linux, this is typically a program such as sh, csh, or bash. On Windows, the equivalent program is command.com or cmd.exe, typically run in a console window. When you enter a command or statement shown in an example, do not type the prompt shown in the example. Database, table, and column names must often be substituted into statements. To indicate that such substitution is necessary, this manual uses db_name, tbl_name, and col_name. For example, you might see a statement like this: mysql> SELECT col_name FROM db_name.tbl_name; This means that if you were to enter a similar statement, you would supply your own database, table, and column names, perhaps like this: mysql> SELECT author_name FROM biblio_db.author_list; SQL keywords are not case sensitive and may be written in any lettercase. This training guide uses uppercase. In syntax descriptions, square brackets ('[' and ']') indicate optional words or clauses. For example, in the following statement, IF EXISTS is optional: DROP TABLE [IF EXISTS] tbl_name When a syntax element consists of a number of alternatives, the alternatives are separated by vertical bars ('|'). When one member from a set of choices may be chosen, the alternatives are listed within square brackets ('[' and ']'): TRIM([[BOTH | LEADING | TRAILING] [remstr] FROM] str) When one member from a set of choices must be chosen, the alternatives are listed within braces ('{' and '}'): {DESCRIBE | DESC} tbl_name [col_name | wild] An ellipsis (...) indicates the omission of a section of a statement, typically to provide a shorter version of more complex syntax. For example, INSERT ... SELECT is shorthand for the form of INSERT statement that is followed by a SELECT statement. An ellipsis can also indicate that the preceding syntax element of a statement may be repeated. In the following example, multiple reset_option values may be given, with each of those after the first preceded by commas: RESET reset_option [,reset_option] ... Commands for setting shell variables are shown using Bourne shell syntax. For example, the sequence to set the CC environment variable and run the configure command looks like this in Bourne shell syntax: shell> CC=gcc ./configure If you are using csh or tcsh, you must issue commands somewhat differently: shell> setenv CC gcc and shell> ./configure • •. s. o. an r t n. uy g N. an s a h ) n ideฺ v ฺ om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t e onฺ to us o (m nse n a r ce T i l t e. e. bl a r fe.

(6) Supporting Images Used in This Training Guide The following is a summary of the standard images used in this manual to support the instruction:. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. IMAGE. Thi. NAME. DESCRIPTION. Preparation. This image is used to describe the steps required to be completed prior to performing a hands-on exercise.. Written Exam. This image is used to identify that the student is going to be tested upon the material previously presented in the instructional material.. e. uy g N. bl a r Throughout the course the instructorfe InLine Lab ns will conduct labs in line with the a r t instruction, which are designed - to n o help you to understand the n of“nuts a and bolts” (inner-workings) the s topic. ha n) ideฺ v ฺ image to convey to Further Practice u isthatused om This G c thetstudent there is a final Lab ฺ n to complete prior to the 21 deexercise s t sp s Stu completion of the chapter. @ i n h a t r t This image identifies an area on a Student Notes e ฺ s n u o page designated for students to o o t m write notes associated with the ( nse n class. a r e c T i l et 123. Slide Number Boxes. This image is used throughout the course guide to indicate the existence and number of a corresponding instruction slide..

(7) COURSE OBJECTIVES This course is designed for experienced database developers who wish to learn additional skills required to create complex queries and efficient structures while improving the performance of the database by learning to create and write queries that are optimized based on the data in the database.. 5. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. At the completion of this course, you should be able to:. Thi. •. Utilize the multiple indexing options available to create better response times of query executions. •. Optimize queries that are responsible for searching text fields. •. Optimize queries that search date fields. •. Optimize queries that perform calculations and aggregations. •. Create summary tables that utilize triggers, event scheduler and table merges. •. Optimize queries that retrieves data from more than one table. •. Create tables that utilize tree and hierarchical structures. e. 6. o n a • Utilize temporary tables to improve query performance s a h • Explain the affect locking levels have on query performance n) ideฺ v ฺ u ompreciset G • Create report queries that provide the end userscwith and organized data ฺ 21 den s t sp s Stu @ i n h a t r t e onฺ to us o (m nse n a r ce T i l t e. an r t n. uy g N. s. bl a r fe.

(8) Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. Table of Contents 1 1.1 1.2 1.2.1 1.3 1.3.1 1.3.2 1.3.3 1.3.4 1.3.5 1.4 1.4.1 1.4.2 1.4.3 1.4.4 1.5 1.5.1 1.5.2 1.5.3 1.5.4 1.6 1.7 1.8 1.9 1.9.1 1.9.2 1.10 1.11 1.12. Introduction ................................................................................................................................................. 1-1 Learning Objectives .................................................................................................................................... 1-1 The MySQL Overview................................................................................................................................ 1-2 MySQL Partners.......................................................................................................................................... 1-3 MySQL Products......................................................................................................................................... 1-4 MySQL Database Products ......................................................................................................................... 1-4 MySQL GUI Tools...................................................................................................................................... 1-5 Other MySQL Tools.................................................................................................................................... 1-5 MySQL Drivers........................................................................................................................................... 1-6 Solutions for Embedding MySQL............................................................................................................... 1-6 MySQL Services ......................................................................................................................................... 1-7 MySQL Training ......................................................................................................................................... 1-7 MySQL Certification................................................................................................................................... 1-7 MySQL Consulting ..................................................................................................................................... 1-7 MySQL Support .......................................................................................................................................... 1-7 The MySQL Enterprise Subscription .......................................................................................................... 1-8 MySQL Enterprise Server ........................................................................................................................... 1-8 24x7 Enterprise Support.............................................................................................................................. 1-8 MySQL Enterprise Monitor ........................................................................................................................ 1-9 Obtaining a MySQL Enterpise Subscription ..............................................................................................1-12 Supported Operating Systems ....................................................................................................................1-13 MySQL Certification Program ...................................................................................................................1-14 Training Curriculum Paths .........................................................................................................................1-15 MySQL Website.........................................................................................................................................1-19 MySQL Community Web Page..................................................................................................................1-20 MySQL Online Documentation .................................................................................................................1-22 Installing MySQL.......................................................................................................................................1-25 Installing the 'world' database.....................................................................................................................1-26 Chapter Summary.......................................................................................................................................1-27. 2.4 2.4.1 2.5 2.6 2.7. When MySQL Uses an Index...................................................................................................................... 2-8 When MySQL Does Not Use an Index ....................................................................................................... 2-9 Retrieving Index Information .....................................................................................................................2-11 Optimize Indexes........................................................................................................................................2-16 Summary ....................................................................................................................................................2-19. 3 3.1 3.2 3.3 3.3.1 3.4 3.5 3.6 3.7 3.8 3.8.1 3.9 3.10. Searching Date and Text Fields................................................................................................................... 3-1 Overview ..................................................................................................................................................... 3-1 Strings in Multiple Columns ....................................................................................................................... 3-2 Case Sensitivity ........................................................................................................................................... 3-4 Binary searches ........................................................................................................................................... 3-7 INET_ATON and INET_NTOA................................................................................................................3-11 Searching Dates..........................................................................................................................................3-13 String Dates to SQL Dates .........................................................................................................................3-16 Dates to Integer Values ..............................................................................................................................3-18 Dates to Strings ..........................................................................................................................................3-23 Time values to Strings................................................................................................................................3-24 Nonspecific Date Searches.........................................................................................................................3-28 Summary ....................................................................................................................................................3-30. s. an r t n. no a s a h n) ideฺ v ฺ om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t e onฺ to us o (m nwith se Indexes ......................................................................................................... 2-1 2 Improving Performance n a r e 2.1 Overview 2-1 lic t T ..................................................................................................................................................... 2.2 yeQuery Executions in MySQL ...................................................................................................................... 2-2 2.2.1 gu Query Optimizer.......................................................................................................................................... 2-3 N hi 2.3 Why Indexes?.............................................................................................................................................. 2-4. T. e. bl a r fe.

(9) Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. 4 4.1 4.2 4.2.1 4.2.2 4.2.3 4.2.4 4.3 4.3.1 4.3.2 4.4 4.5. Improving Inserts ........................................................................................................................................ 4-1 Overview ..................................................................................................................................................... 4-1 INSERT Process.......................................................................................................................................... 4-2 Multiple Row Inserts ................................................................................................................................... 4-3 INSERT ... SELECT ................................................................................................................................... 4-4 LOAD DATA INFILE ................................................................................................................................ 4-4 Transactional Multiple Inserts..................................................................................................................... 4-8 Storage Engine Specifics............................................................................................................................. 4-9 Speeding up Bulk Inserts with MyISAM .................................................................................................... 4-9 Speeding up Bulk Inserts with InnoDB......................................................................................................4-10 MySQL Extensions ....................................................................................................................................4-11 Summary ....................................................................................................................................................4-18. 5 5.1 5.2 5.3 5.4 5.5 5.5.1 5.5.2 5.6 5.7 5.8 5.9. Complex Calculations ................................................................................................................................. 5-1 Overview ..................................................................................................................................................... 5-1 Aggregate Multiplication ............................................................................................................................ 5-2 Running Total Query................................................................................................................................... 5-5 Avoiding Divide by Zero ............................................................................................................................ 5-7 Calculate the Median Value ........................................................................................................................ 5-9 Median Value via Implicit Temporary Tables ...........................................................................................5-10 Creating a Median Stored Procedure..........................................................................................................5-13 Simulating RANK ......................................................................................................................................5-16 Divide and Conquer ...................................................................................................................................5-18 Miscellaneous.............................................................................................................................................5-26 Summary ....................................................................................................................................................5-27. 6.5.3 6.5.4 6.5.5 6.6. Double Checking EXPLAIN......................................................................................................................6-26 JOIN - Best Practices .................................................................................................................................6-33 Simulating INTERSECT and MINUS .......................................................................................................6-34 Summary ....................................................................................................................................................6-35. 7. 7.1. 7.2. 7.3. 7.3.1. 7.3.2. 7.4. 7.4.1. 7.4.2. 7.4.3. 7.4.4. 7.4.5.. Hierarchical Data......................................................................................................................................... 7-1 Overview ..................................................................................................................................................... 7-1 Graphs, Trees and Hierarchies .................................................................................................................... 7-2 Adjacency List Structures ........................................................................................................................... 7-5 Search Tree Depths ..................................................................................................................................... 7-9 Modify Tree Values ...................................................................................................................................7-15 Nested Set Structures .................................................................................................................................7-16 Search Tree Depths ....................................................................................................................................7-18 Display Depth.............................................................................................................................................7-19 Displaying a specific branch ......................................................................................................................7-20 Inserting Nodes ..........................................................................................................................................7-22 Deleting Nodes...........................................................................................................................................7-25. s. an r t n. no a s a h n) ideฺ v ฺ om t Gu c 6 Improving Performance of Joins ................................................................................................................. 6-1 ฺ 1 n 2 e 6.1 Overview ..................................................................................................................................................... 6-1 s pt Stud 6.2 Query Optimizer.......................................................................................................................................... 6-2 s @ this 6.2.1 Greedy Optimizer........................................................................................................................................ 6-4 n a r 6.3 EXPLAIN.................................................................................................................................................... 6-6 t e ฺ s n 6.4 JOIN's.......................................................................................................................................................... 6-8 o to u o 6.4.1 Nested JOIN's.............................................................................................................................................6-14 m 6.4.2 Self Joins ....................................................................................................................................................6-15 n ( ense a r 6.4.3 FULL ic lJOIN..................................................................................................................................6-16 t T OUTER 6.5 yeImproving JOIN performance ....................................................................................................................6-21 u Reducing Rows Touched by Joins .............................................................................................................6-22 6.5.1 g N hi 6.5.2 Covering the Index .....................................................................................................................................6-24. T. e. bl a r fe.

(10) Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. 7.5. 7.5.1. 7.5.2. 7.6.. Path Enumeration .......................................................................................................................................7-28 Search the depths of the path......................................................................................................................7-29 Retrieving hierarchical data from the paths................................................................................................7-31 Summary ....................................................................................................................................................7-32. 8. 8.1. 8.2. 8.3. 8.3.1. 8.4. 8.4.1. 8.5. 8.6.. Advanced Index Structures ......................................................................................................................... 8-1 Overview ..................................................................................................................................................... 8-1 MySQL Index Types ................................................................................................................................... 8-2 FULLTEXT Index....................................................................................................................................... 8-5 FULLTEXT Search Functions .................................................................................................................... 8-6 Simulating Function Based Indexes ............................................................................................................ 8-8 Searching for valid words............................................................................................................................ 8-8 Optimizing End of Field Searches..............................................................................................................8-10 Summary ....................................................................................................................................................8-14. 9 9.1 9.2 9.3 9.3.1 9.3.2 9.4 9.4.1 9.4.2 9.4.3 9.5 9.6. Locking Levels............................................................................................................................................ 9-1 Overview ..................................................................................................................................................... 9-1 Locks ........................................................................................................................................................... 9-2 Explicit Table Locks ................................................................................................................................... 9-4 LOCK TABLES statement.......................................................................................................................... 9-4 UNLOCK TABLE statements..................................................................................................................... 9-5 Storage Engine Locking Techniques........................................................................................................... 9-6 MyISAM Locking ....................................................................................................................................... 9-6 InnoDB Locking.......................................................................................................................................... 9-9 Locking with Other Storage Engines .........................................................................................................9-10 Locking Issues............................................................................................................................................9-11 Summary ....................................................................................................................................................9-17. s. an r t n. no a s a h n) ideฺ v ฺ om t Gu c ฺ 21 den s t p Stu 10. Creating Reports.........................................................................................................................................10-1 s @ 10.1. Overview ....................................................................................................................................................10-1 is n h a t r 10.2. Calculate Multiple Conditions....................................................................................................................10-2 ฺt use n 10.3. Create a Calculated Report.........................................................................................................................10-4 o o to 10.4. Quarterly Reports .......................................................................................................................................10-9 m ( e 10.4.1. Cross Tab n Reports ....................................................................................................................................10-10 ns aChart..........................................................................................................................................10-11 r e 10.5. SQLTBar c t Tablesli........................................................................................................................................10-13 10.6. yeDecision u Materialized Views ..................................................................................................................................10-16 10.7. g N hi 10.8. Producing Sequential or Missing Data .....................................................................................................10-17. T. 10.8.1. Using the integers table to fill in missing data .........................................................................................10-21 10.9. Summary ..................................................................................................................................................10-23 11 11.1 11.2 11.3 11.4 11.5. Conclusion..................................................................................................................................................11-1 Course Objectives ......................................................................................................................................11-1 Training and Certification Website ...........................................................................................................11-2 Course Evaluation ......................................................................................................................................11-4 THANK YOU!...........................................................................................................................................11-5 Q&A Session..............................................................................................................................................11-6. Appendix A Appendix B Appendix C Appendix D Appendix E. e. bl a r fe. Installation Procedures..................................................................................................................A-1 MyISAM Locking.........................................................................................................................B-1 Quiz Solutions...............................................................................................................................C-1 Further Practice Solutions .............................................................................................................D-1 Better Performance, Scalability, and Recovery.............................................................................E-1.

(11) Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. Thi. CHAPTER 1 INTRODUCTION. e. s. an r t n. o. an s a h ) n ideฺ v ฺ om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t e onฺ to us o (m nse n a r ce T i l t e. uy g N. bl a r fe.

(12) Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. Thi. e. s. o. uy g N an s a h ) n ideฺ v ฺ om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t e onฺ to us o (m nse n a r ce T i l t e an r t n bl a r fe.

(13) MySQL Developer Techniques. 1 1.1. Chapter 1: Introduction. INTRODUCTION Learning Objectives. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. This chapter introduces you to MySQL products and services. In this chapter, you will learn: 8. Thi. •. Explain the origin and status of the MySQL product. •. List the available MySQL products and professional services. •. Describe the MySQL Enterprise subscription. •. List the currently supported operating systems. •. Describe the MySQL Community web page. •. Describe the MySQL Certification program. •. List all the available MySQL courses. e. bl a r fe. s. an r t n. o. an s a h ) n ideฺ v ฺ om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t e onฺ to us o (m nse n a r ce T i l t e. uy g N. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-1.

(14) MySQL Developer Techniques. 1.2. The MySQL Overview MySQL is a Relational Database Management System (RDBMS) that was originally developed by ‘MySQL AB’. It was (and continues to be) developed and marketed as a family of high performance, affordable database servers and tools. Contributing to building the missioncritical, high-volume systems and products worldwide is what makes MySQL the world’s most popular open source database, as well as its reliability, excellent performance and ease of use.. 9. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. Chapter 1: Introduction. MySQL is not only the world’s most popular open source database. It is also the fastest growing database in the industry, with over 70,000 downloads per day, ranging from large corporations to specialized embedded applications.. MySQL is installed on every ble continent in the world fera s (Yes, even Antarctica!) tran. MySQL AB was founded in Sweden by two Swedes and a Finn: David Axmark, Allan Larsson and Michael "Monty" Widenius who have worked together since the 80's. MySQL AB (Swedish for “Inc.”) was the sole owner of the MySQL server source code, the MySQL trademark and the mysql.com domain worldwide.. n o n. 10. a s a h ฺ ) n ฺv uide m o Sun Acquisition: ฺc nt G 1 2 In early 2008, MySQL AB was acquired by Sun de Inc., giving the MySQL product line the tsMicrosystems, u p t s considerable resources of a major mainstream company.S Together, Sun and MySQL will now provide global @ s i enterprise-class support 24x7x365. Our enterprise-class customers worldwide can now take advantage of our n h t tra on their market-leading open source database choice of hardware, operating system and language with up to a e ฺ s n o to u 90% lower total cost of ownership than many traditional o m database solutions. ( nse n a r ce T i MySQL has always been, and will continue to be, a strong l t e supporter of the open source philosophy and the open source y gu community, and strives to work with partners who share the. Thi. N. same values and mindset. This will be no different within Sun. Sun is a world-leader in open source, with products and technologies such as Java, OpenSolaris, Open Office, NetBeans, OpenSparc and many more. The MySQL mission is still the same... Make superior database software available and affordable to all!. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-2.

(15) MySQL Developer Techniques. 1.2.1. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. 11. Chapter 1: Introduction. MySQL Partners MySQL has had the privilege of forming alliances with excellent partners and attracting some of the most impressive customers in the industry! When you join our ranks, you are joining a winning team with a wide variety of MySQL implementations. It never ceases to amaze us, the innovative and powerful ways in which our tools are being used. To name only a few;. Web / Web 2.0. e. OEM / ISV's. bl a r fe. s. an r t n. no a s a h n) ideฺ v ฺ om t Gu c ฺ On Demand, SaaS, Hosting Telecommunications Enterprise 2.0 21 den s t u p t s sS @ i n h a t r t e Open-source onฺ to usis powering the World! o (m nse n a r ce T i l t "We have We went from experimental to mission-critical in a couple of uyeused MySQL far more than anyone expected.months." g Jeremy Zawodny--MySQL Database Expert Yahoo! Finance hi N. T. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-3.

(16) MySQL Developer Techniques. 1.3. MySQL Products. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. 1.3.1. 12. Thi. Chapter 1: Introduction. MySQL Database Products. Sun provides MySQL database products to meet the needs of ISV/OEM, Enterprise, and Community Server users. MySQL database products are recognized for superior ease of use, performance, and reliability. • MySQL Enterprise Server o. The most reliable, secure and up-to-date version of the world's most popular open source database for cost-effectively delivering E-commerce, Online Transaction Processing (OLTP), and multiterabyte Data Warehousing applications. (Available only with the MySQL Enterprise subscription).. • MySQL Community Server o. The MySQL database server for open source developers and technology enthusiasts who want to get started with MySQL. Supported by the large MySQL open source community. Under the General Public License (GPL), benefits to the open source community include a commercialgrade framework that is free of charge.. e. bl a r fe. ns a r t - a reliable o The most popular choice for OEMs/ISVs who want to cost-effectively embed orn bundle o and high-performance relational database. an s MySQL Cluster a h ) o A fault tolerant database clustering architecture for deploying highly n ideฺavailable mission-critical v ฺ database applications. om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t e onฺ to us o (m nse n a lice t Tr. • MySQL Embedded Database. •. e. uy g N. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-4.

(17) MySQL Developer Techniques. 1.3.2 13. Chapter 1: Introduction. MySQL GUI Tools The MySQL GUI Tools form a comprehensive graphical user interface to your MySQL database. These easy to use graphical tools enable database Developers and Database Administrators (DBAs) to be more productive.. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. • MySQL Migration Toolkit o. Using a wizard-driven interface, the MySQL Migration Toolkit implements a proven methodology and walks you through the necessary steps to successfully complete a database migration project.. • MySQL Administrator o A powerful graphical administration console that enables you to easily administer your MySQL environment and gain significantly better visibility into how your databases are operating. • MySQL Query Browser. s. Bundled Tools. an r t n. e. bl a r fe. o An extremely user-friendly graphical tool for creating, executing, and optimizing SQL queries for your MySQL Database Server.. no a s a h n) ideฺ v 1.3.3 Other MySQL Tools ฺ m Gu o c ฺ t server: 14 MySQL has also developed additional tools to assist in the MySQL 1 use of the n 2 e s pt Stud • MySQL Workbench s @ database is design tool developed by MySQL. It is o MySQL Workbench a is n a visual h t r the highly anticipated of the DBDesigner4 project. MySQL ฺt successor seapplication n u o Workbench is currently available for Microsoft Windows in a GPL licensed open o o t m source edition as well as a low-priced standard edition which includes additional ( nse n time saving features for professionals. a r ce T i l t • MySQL Proxy uye o MySQL Proxy is a simple program that sits between your g N client and MySQL server(s) that can monitor, analyze or Thi transform their communication. Its flexibility allows for. The MySQL graphical user interface (GUI) tools discussed here come bundled together when downloaded from the MySQL website.. unlimited uses; common ones include: load balancing; failover; query analysis; query filtering and modification; and many more.. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-5.

(18) MySQL Developer Techniques. 1.3.4 15. Chapter 1: Introduction. MySQL Drivers MySQL Connectors are database drivers, providing database client connectivity for a wide range of programming languages. MySQL provides the following connectors:. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. • MySQL C API o Our native client library (libmysql), which can be wrapped by other languages. • MySQL Connector/ODBC o Connect to a MySQL database server using the Open Database Connectivity (ODBC) API on all Microsoft Windows and most Unix-like platforms. The ODBC driver builds on the client/server protocol implementation provided by libmysql. • MySQL Connector/J o A JDBC (Java Database Connectivity) 4.0 driver for Java 1.4 and higher. Provides a java native implementation of the MySQL client/server protocol. • MySQL Connector/Net. s. an r t n. o A fully managed ADO.NET provider for the .NET framework (version 1.1 and 2.0). Provides a .NET implementation of the MySQL client/server protocol.. no a sare two MySQL specific PHP a o Provides MySQL connectivity for PHP programs. Currently there h nand) mysqli extensions available that use libmysql: the mysql eฺextensions. There is also v ฺ d i MySQL support for the generic PHP Databaseo objects m (PDO) uextension. In addition there is the G creplace ฺ PHP native driver called mysqlnd which1can libmysql in the mysqli extension. t n 2 e s 1.3.5 Solutions for Embedding MySQL pt Stud s @clienttside isconnectivity, MySQL also provides libraries to embed a Apart from these Connectors that provide n h a r MySQL database server within ฺatprogram. Currently se the following solutions can be used to embed MySQL: n u o • libmysqldmo to 16 ( e n embedded nsedition of the mysqld server program wrapped in a shared library. Allows the oaThe r e c T MySQL li Server to be embedded in C programs. t e y gu • MySQL MX/J N o A jar wrapper around mysqld binaries. This allows java programs and J2EE environments to Thi • MySQL Connector/PHP. e. bl a r fe. instantiate (and install) a MySQL server.. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-6.

(19) MySQL Developer Techniques. 1.4. MySQL Services. 1.4.1. MySQL Training Sun Microsystems offers a comprehensive set of MySQL training courses that give you a competitive edge in building world-class database solutions.. 17. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. Chapter 1: Introduction. • Courses can be chosen individually, as part of a bundle, and/or following our suggested curriculum path for Developers and Database Administrators (DBAs).. 1.4.2. MySQL Certification MySQL Certification Program is a high quality certification program that provides Developers and DBAs with the credentials to prove they have the knowledge, experience and skills to use and manage MySQL Server. With MySQL personal certifications, you get to show that you are among the best-of-breed MySQL users and lay the foundation for becoming a trusted and valuable resource for your company and customers.. 1.4.3. bl We offer a full range of consulting services. Whether you are starting a new project, needing to optimize e anra sf existing MySQL application, or migrating from a proprietary database to MySQL, we have an affordable n a solution for you. -tr n o Using industry best practices and proven methodologies, your MySQL certified consultant nwill help you deliver a on-time and on-budget. s a h MySQL Support n) ideฺ v ฺ We also offer a full range of support options. MySQL Technical Support isu designed to save you time and to om G c ฺ ensure you achieve the highest levels of performance, reliability, and uptime. t 21 den s • Community support t sp s Stu o Mailing Lists @ i n h a t r o Forums (http://forums.mysql.com/) t e nฺ (http://dev.mysql.com/tech-resources/articles) us oArticles o Community o o t (m e o Bugs Databases (http://bugs.mysql.com/) n n a r e T o No direct lic access to support engineers t e o PlanetMySQL Blogs (http://www.planetmysql.org/) uy. 1.4.4. g. N Thi. e. MySQL Consulting. o MySQL Reference Manuals (http://dev.mysql.com/doc) o MySQLForge (http://forge.mysql.com/). • Purchased support o Enterprise subscription o Support for MySQL Cluster o Support for MySQL Embedded (OEM/ISV) o Online Knowledge Base. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-7.

(20) MySQL Developer Techniques. 1.5. The MySQL Enterprise Subscription A MySQL Enterprise subscription gives you access to the Enterprise Server as well as other premium products and services. It is a comprehensive set of enterprise-grade software, support and services to ensure the highest levels of reliability, security and uptime. As a proactive service that helps you eliminate problems before they occur, it gives you everything you need in a single, unified offering to successfully develop and deploy business critical applications using MySQL.. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. 18. 1.5.1 19. Chapter 1: Introduction. MySQL Enterprise Server The most reliable, secure and up-to-date version of the world's most popular open source database for costeffectively delivering E-commerce, Online Transaction Processing (OLTP), and multi-terabyte Data Warehousing applications. With an Enterprise subscription you also get the following in addition to the Enterprise Server: • Updates and Service Packs o. • Emergency Hot Fix Builds. s. an r t n. no a s a • Drivers h ฺ details. n) website efor o Many different drivers are supported. See MySQL Enterprise v ฺ d i om t Gu • MySQL Workbench c ฺ 1 n design and maintenance, automates 2simplifies e o A graphical user interface (GUI)tthat database s d p tasks,Sand tu improves communication among DBA and time-consuming and error-prone s @ s developer teams. i n h a t r t e ฺ • Platforms uares supported. See MySQL Enterprise website for details. onplatforms o o Many different o t m se (Support n 1.5.2 24x7 Enterprise n a r e c T i l et• Service Level y 20 u o MySQL Enterprise gives you the flexibility to choose a service level that matches your g N i requirements. Th o. Can request a special hot fix build that resolves a critical issue that is not addressed by a service pack.. . Basic, Silver, Gold, or Platinum (with incrementally increasing quantity and quality of support). • Problem Resolution Support o. Ensures you receive high priority service from the MySQL Support Team for quick resolution of technical problems as they occur. The services available to you are dependent on your chosen service level.. • Consultative Support o. e. bl a r fe. Automatically receive both monthly rapid updates and quarterly service packs with the latest bug-fixes and security updates.. Expert MySQL Consultants provide you with proactive advice on how to properly design and tune your MySQL servers, schema, queries and replication to ensure the highest possible reliability.. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-8.

(21) MySQL Developer Techniques. Chapter 1: Introduction. • Technical Account Manager (TAM). Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. o. You have the option of adding a Technical Account Manager (Platinum level only) to be your liaison within MySQL. Your TAM be your single point of contact, providing a custom review of your systems, regular phone calls and on-site visits, to guarantee that you get the most out of MySQL Support Services.. • Online Knowledge Base o. For quick self-help knowledge, you will have access to a comprehensive and easily searchable knowledge base library with hundreds of technical articles regarding difficult problems on popular database topics such as performance, replication, configuration, and security. Enterprise support. For more detailed information regarding Enterprise support, please refer to our Enterprise web page located at: http://www.mysql.com/products/enterprise/support.html .. 1.5.3 21. Thi. MySQL Enterprise Monitor. s. an r t n. The MySQL Enterprise Monitor is a web-based monitoring and advising system. The Enterprise Monitor helps MySQL DBAs manage more MySQL servers in a scale-out environment, tune their current MySQL servers and find and fix problems with their MySQL database applications before they can become serious problems or costly outages. Running completely within the corporate firewall, the Enterprise Monitor pro-actively monitors enterprise database environments and provides expert advice on how MySQL can tighten security, optimize performance and reduce downtime of their MySQL powered systems. EM accomplishes all this while reducing DBA time and effort. EM provides a rich GUI Enterprise Dashboard that contains “pages” which allow the DBA to have an immediate, graphic view of administrative tasks, server and database status, and advisory information. The principle features of Enterprise Monitor:. no a s a h n) ideฺ v ฺ om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t e • Enterprise Dashboard onฺ o usfrom a consolidated console o Manage o all MySQLtservers (m nse management • Server or Server-group n a ro Autolidetection, ce grouping and monitoring of replication and scale-out topologies T t e. uy g N. e. bl a r fe. • Monitoring page o "At a glance" global health check of key systems. • MySQL provided Advisors and Advisor Rules o Enforce MySQL Best Practices • Advisor Rule Scheduler o Schedule unattended operations • Customizable Thresholds and Alerts o Identify Advisor Rule violations • Custom Advisor Rule o User defined advisor rules • Events and Alert history o Lists all Advisor Rules executions • Specialized Scale-Out assistance ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-9.

(22) MySQL Developer Techniques. Chapter 1: Introduction. Enterprise Dashboard. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. 22. Graphs (custom). Page Tabs. ED Control /Help. e. bl a r fe. s. an r t n. o. an s a h ) Explorer n ideฺ v Navigation ฺ om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t e onฺ to us o (m nse n a r ce T i Critical Events l t e y gu N hi. Heat Chart. T. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-10.

(23) MySQL Developer Techniques. MySQL Enterprise Advisors The MySQL advisors are divided into the following categories (and specific functions):. 23. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. Chapter 1: Introduction. e. bl a r fe. s. an r t n. 24. no a s a Enterprise Monitor Subscription Level h n)features eareฺ only available with the A “Silver” or higher level is required to get Enterprise Monitor. ฺSome v d i u below: “Gold” and “Platinum” levels, respectively. A list of features per level is shown om G c ฺ t 1 Gold n e Silvers2 Platinum d t u p t s S Enterprise Dashboard @ s i n h tra se t ฺ Notifications andn Alerts oo to u m Custom ( Advisor n ense a r TUpgrade Advisor lic t e guy Administration Advisor. Thi. N. Security Advisor Replication Monitor Replication Advisor Query Analysis Advisor Memory Usage Advisor Schema Advisor Performance Advisor ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-11.

(24) MySQL Developer Techniques. 1.5.4. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. 25. Thi. Chapter 1: Introduction. Obtaining a MySQL Enterpise Subscription For volume discounts or to order by phone, the MySQL Enterprise subscription can be obtained by contacting Sun Microsystems/MySQL sales personnel:. e. bl a r fe. s. an r t n. o. an s a h ) n ideฺ v ฺ om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t e onฺ to us o (m nse n a r ce T i l t e. uy g N. A permanent MySQL Enterprise subscription can be purchased through the MySQL website located at : https://shop.mysql.com/enterprise/. A 30-day trial (with limited features) is also available: http://www.mysql.com/trials/ .. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-12.

(25) MySQL Developer Techniques. 1.6. Supported Operating Systems. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. 26. Thi. Chapter 1: Introduction. MySQL runs on more than 20 platforms, giving users the kind of flexibility that puts them in control. Windows, Linux and Solaris are the most popular operating systems for running MySQL. Versions of MySQL are currently available for the following operating systems: • FreeBSD • HP-UX • IBM AIX and i5 • Linux (multiple) • Mac OS/X • Microsoft Windows (multiple) • Novell netware. e. • Open BSD • QNX • SGI Irix. bl a r fe. s. an r t n. no a s • Source code a h • Special builds n) ideฺ v ฺ m Gu oinformation, c This list is continually being updated. For the most current ฺ t please check the MySQL website at: 1 n 2 e http://www.mysql.com . s pt Stud s @ this n a r ฺt use n o o to m ( e an icens r T l t e y gu • Solaris. N. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-13.

(26) MySQL Developer Techniques. 1.7. MySQL Certification Program The MySQL Certification Program is a high quality certification program that provides developers and DBAs with the credentials to prove they have the knowledge, experience and skills to use and manage MySQL Server. MySQL provides several certification types and levels:. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. 27. Thi. Chapter 1: Introduction. 1. Certified MySQL Associate (CMA) - an entry level certification. It is intended for those that are relatively new to using the MySQL database server and covers basic database management system concepts as well as basic SQL. We recommend the CMA certification for MySQL users that know the basics, but have not yet obtained the experience gained by professional MySQL DBAs or Developers. 2. Certified MySQL 5.0 Developer (CMDEV) - proves mastery of the fundamental skills of using MySQL including creating and using databases and tables, inserting, modifying, deleting, and retrieving data. 3. Certified MySQL 5.0 Database Administrator (CMDBA) - proves mastery of the ability to manage MySQL Server including such advanced areas of database management, installation, security, disaster prevention and optimization.. s. an r t n. e. bl a r fe. 4. Certified MySQL Cluster DBA (CMCDBA) - part of the DBA track which represents an advancement level exceeding CMDBA certification. In order to attain CMCDBA certification, you must attain CMDBA certification and pass one CMCDBA exam.. no a s a h Certification web page nthe) exams, eseeฺ our Certification web v ฺ d For more information on the certification program and the content of i om t Gu page; http://www.mysql.com/certification/ . c ฺ 21 den Exam administration s t tuPearson VUE testing centers available worldsp s 3,000 S All exams are administered through one@ of more than i proctor network. Visit the MySQL certification n h wide. And through the Linux r Professional Institute a t t e webpage, online forum or email for more information. s u onฺ[email protected] o o (m nse t n a ice r T l t e y gu. N. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-14.

(27) MySQL Developer Techniques. 1.8. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. 28. Thi. Chapter 1: Introduction. Training Curriculum Paths MySQL offers the most comprehensive set of MySQL training courses that enable the building of database solutions and competitiveness now and into the future. In addition to our open courses, we also offer in-house training. The MySQL training services staff has put together great courses designed for success, and an excellent training path for each individual to reach his/her training goals. There are two tiers to the curriculum paths: Developer path •. Introduction courses o. o. s. an r t n. e. bl a r fe. MySQL for Beginners – This course covers the fundamentals of SQL and relational databases, using MySQL as a teaching tool. Prerequisites: Basic computer literacy is required. Previous experience with any command-line program (such as MS-DOS or the MS Windows command prompt) is beneficial. 4 Days in length.. no a s a h • Intermediate courses n) ideฺ v ฺ m is designed u for students planning on developing o MySQL for Developers - This instructor-led o course G c ฺ t applications that make use of MySQL 5.0 (and higher). This course covers essential SQL statements 1 In addition, n 2 e for data design, querying, and programming. it will prepare students for the MySQL s d with Relational Databases u pt Some t Developer certification. Prerequisites: experience and SQL. 5 days s S @ s i in length. an e th r t ฺ s New Features – This instructor-led course will provide in-depth nUpgradinguand o MySQL 5.0 oneeded o o knowledge to become proficient using MySQL 5.0. This training course will provide quality t (m time both on s theetopic, hands-on labs and with the expert instructor. Prerequisites: Existing MySQL n n a usersiwho r e want to become proficient using MySQL 5.0. 3 Days in length. c T l t. e•. uy g N. MySQL and PHP : Developing Dynamic Web Application –This course will provide the tools needed for the development of dynamic web application. This course takes the student from the basics to the advanced features in four hands-on, heavy duty training days. Each student will have the opportunity to build a real-world application during the course. Prerequisites: Basic experience with designing HTML pages including HTML forms and experience with any programming language. Basic PHP skills. 4 days in length.. Advanced courses o. MySQL Stored Procedure Techniques – This instructor-led course with focus on labs is designed to teach you how to maximize the use of stored procedures along with the knowledge to discern when an application should contain stored procedures and when they should not. 2 Days in length.. o. MySQL Developer Techniques - This instructor-led course will provide database developers with additional skills in the design, development and maintenance of data and the queries to mine such data. This course places an emphasis on best practices for developers that improve response time of query executions. The database developer will also learn additional query writing techniques for creating reports, and creating trees and hierarchies, that can be used within MySQL to support the needs of the end users. Prerequisites: Having attended the MySQL for Developers course, or similar knowledge. 3 Days in length.. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-15.

(28) MySQL Developer Techniques. Chapter 1: Introduction. Database Administrator (DBA) Path •. Introduction courses. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. o. Thi. •. •. MySQL for Beginners – This course covers the fundamentals of SQL and relational databases, using MySQL as a teaching tool. Prerequisites: Basic computer literacy is required. Previous experience with any command-line program (such as MS-DOS) is beneficial. 4 Days in length.. Intermediate courses o. MySQL 5.0 Upgrading and New Features – This instructor-led course will provide in-depth knowledge needed to become proficient using MySQL 5.0. This training course will provide quality time both on the topic, hands-on labs and with the expert instructor. Prerequisites: Existing MySQL users who want to become proficient using MySQL 5.0. 3 Days in length.. o. MySQL for Database Administrators – This course covers essential DBA tasks such as, installation and upgrading, user management, disaster recovery, and optimization. In addition, it will prepare students for the MySQL Database Administrator certification. Prerequisites: Some experience with Relational Databases and SQL. 5 days in length.. Advanced courses. s. an r t n. no a s a h n) ideฺ v ฺ om t Gu c ฺ 1 n 2 e s d t o MySQL Cluster - Learn how to andtconfigure the cluster nodes to ensure high availability. u sp install S Also learn about all of the high availability features that are implemented in the new storage engine @ s i n— fail-over h for the MySQL Cluster between storage nodes, network partitioning protocol, two-phase a t r t e commit and much Prerequisites: Attendance to the MySQL for Database Administrators or an s nฺ more. u omastery o equivalent of database concepts, SQL and the MySQL server. 3 Days in length. o t m ( e nsis the sole course offering in the Cluster certification (CMCDBA) path. This an Note: r e c T li High Availability - This course is designed for experienced database administrators and et o MySQL o. uy g N. e. bl a r fe. MySQL Performance Tuning – The MySQL Performance Tuning course is designed for Database Administrators and others who wish to monitor and tune MySQL. This course will prepare each student with the skills needed to utilize tools for monitoring, evaluating and tuning. Students will evaluate the architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts. 4 Days in Length.. system architects that want to analyze and form a basis of understanding different high availability options, including clustering and replication solutions within MySQL. This course will provide the tools required to make the decision of what high availability solution is appropriate and how to implement a system with the correct design.. 3 days in length.. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-16.

(29) MySQL Developer Techniques. Chapter 1: Introduction. Introductory. MySQL and PHP. Thi. MySQL for Beginners. 4 days. Advanced/ Intermediate Special Topics. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. Curriculum Path Chart. Certification: CMA. 4 days. MySQL for Developers. MySQL for DBAs. Certification: CMDEV I-II. Certification: CMDBA I-II. s. o. an s a h ) n ideฺ v ฺ om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t Developer DBA e ฺ s n u o o to m ( e an icens r T l t. MySQL Stored Procedure Techniques 2 days. an r t n. MySQL Developer Techniques. 3 days. MySQL Performance Tuning. MySQL High Availability. 4 days. 3 days. MySQL Cluster 3 days Certification: CMCDBA. e. uy g N. e. bl a r fe. 5 days. 5 days. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-17.

(30) MySQL Developer Techniques. Chapter 1: Introduction. Virtual Classroom MySQL also offers virtual (online) courses covering various topics in relation to the MySQL suite of tools. These classes are instructor-led and delivered synchronously, via the web. Information regarding the available courses can be found on the MySQL training web page.. Introductory. PHP Elements. Thi. Coming Soon!. 4 hours. MySQL Enterprise Monitor 4 hours. e. Advanced/ Intermediate Special Topics. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. 29. MySQL Transactions. MySQL Storage Engines. o. an s a h ) n ideฺ v ฺ om t Gu c ฺ n 21ComingdSoon! e s t sp s Stu @ i n h a t r t e onฺ to us o (m nse n a r Developer DBA ce T i l t e 4 hours. Writing MySQL UDFs. 2x4 hours. 4 hours. 4 hours. s. an r t n. MySQL Partitioning. bl a r fe. MySQL Proxy. 4 hours. uy g N. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-18.

(31) MySQL Developer Techniques. 1.9. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. 30. Thi. Chapter 1: Introduction. MySQL Website Everything you ever wanted to know about MySQL and more can be found on our website: http://www.mysql.com. From the home page, you may navigate the web site with the tabs (pull-down menus) across the top, the menu along the left side, and/or the many links on the page.. e. bl a r fe. s. an r t n. o. an s a h ) n ideฺ v ฺ om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t e onฺ to us o (m nse n a r ce T i l t e. uy g N. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-19.

(32) MySQL Developer Techniques. 1.9.1. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. 31. Thi. Chapter 1: Introduction. MySQL Community Web Page The MySQL Community web page is located at http://dev.mysql.com and is maintained by Sun Microsystems, Inc. This is the main support tool for the MySQL open source community and can provide valuable insight for Enterprise users also. Information such as the following can be found:. e. bl a r fe. s. an r t n. o. an s a h ) n ideฺ v ฺ om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t e onฺ to us o (m nse n a r ce T i l t e. uy g N. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-20.

(33) MySQL Developer Techniques. Information such as the following can be found on the Developer Zone web page:. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. 32. Thi. Chapter 1: Introduction. • Current product and service promotions • Get Started with MySQL o Installation information page for MySQL beginners • Developing with: o Links to specific information on using MySQL with; PHP, Perl Python, Ruby, Java/JDBC and .Net/C#/Visual Basic • Quality Contribution Program o Structured program for software contributions and bug reports o Contributors acknowledged/rewarded • MySQL Server Community Edition o All current General Available (GA), Release Candidate (RC) and Alpha versions of the MySQL Server • New Releases o Latest code release for all MySQL products • Software Previews o New features available for preview by users. o. an What's New s a o Latest news about the company, products, services, etc. h ) n ideฺ v MySQL Training ฺ m Services u oTraining o List of upcoming courses provided by MySQL G c ฺ t MySQL Quickpoll 21 den s t tu issues o Give your opinions about current spMySQL-related S @ s i Stay Connected n h a t r t e o Blogs, Lists, Guilds, s Meetups and Quality Contributions nฺ MySQL u o o o Resources m ( nsArticles, e t Training, Webinars, and MySQL Newsletter o n White Papers, a more!ice r T And much l t. • • • • • •. s. an r t n. e. bl a r fe. e guy. N. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-21.

(34) MySQL Developer Techniques. 1.9.2. Unauthorized reproduction or distribution prohibitedฺ Copyright© 2016, Oracle and/or its affiliatesฺ. 33. Thi. Chapter 1: Introduction. MySQL Online Documentation Documentation for all MySQL products can be found from our website, on the “Documentation” page: http://dev.mysql.com/doc/ . The page includes links for downloading the following; • • • • • • • • • •. MySQL Reference Manual Excerpts from the Reference Manual MySQL GUI Tools Manuals Expert Guides MySQL Help Tables Example Databases Meta Documentation Community Contributed Documentation Printed Books Additional Resources. e. bl a r fe. s. an r t n. o. an s a h ) n ideฺ v ฺ om t Gu c ฺ 21 den s t sp s Stu @ i n h a t r t e onฺ to us o (m nse n a r ce T i l t e. uy g N. ______________________________________________________________________________________________ ______________________________________________________________________________________________ ______________________________________________________________________________________________. 1-22.

No results found