Get Real!
  

RealSchedule  »  Course Outline

To schedule, contact us at 972-865-2290, or email us at sales@realsolutionstraining.com



Course Number:   RS-MySQL
Course Title:  
MySQL: Administering MySQL
Scheduled DatesRegister
   November 1 - 3, 2010  This class is guaranteed to run!
Know someone who  
needs this course?
  
Length:   3 Day(s)

Compare To:

Description:
MySQL is the world's most popular open source client-server database. In this three-day, hands-on course, attendees learn the fundamentals of writing MySQL queries, administering the MySQL database, and writing applications that automate tasks within MySQL.


What you will learn:
  • MySQL Training Objectives
  • • To learn how to properly set up and configure MySQL
  • • To master creating and querying databases in MySQL
  • • To learn how to administer and secure a MySQL database
  • • To discover how to write applications that integrate with MySQL databases
Audience:



Prerequisites:
  • There are no formal prerequisites for this class.

Outline:
  1. MYSQL BASICS
  2. • Installing MySQL
  3. o Installing on Linux
  4. o Configuring Your System
  5. o Checking Your System Works
  6. o Setting the Root Password
  7. o Deleting Anonymous Accounts
  8. o Creating an Account for Basic Use
  9. • Quick Tour
  10. o MySQL Directory Structure
  11. o Overview of Executables
  12. o Overview of User Interfaces
  13. o Quick Introduction to the MySQL Monitor
  14. DESIGNING AND CREATING DATABASES WITH MYSQL
  15. • Database Design Crash Course
  16. o Database Concepts and Terminology
  17. o Database Design Principles
  18. o Normalization
  19. • Creating Databases, Tables, and Indexes
  20. o Case Sensitivity
  21. o Identifiers in MySQL
  22. o Creating a Database
  23. o Selecting a Database
  24. o Creating Tables
  25. o Column and Data Types in MySQL
  26. o Creating Indexes
  27. o Deleting Databases, Tables, and Indexes
  28. o Altering Existing Table Structures
  29. WRITING SQL QUERIES
  30. • Simple SELECTs
  31. o Introduction to the Northwind Database
  32. o Some Basics
  33. o SELECTing All Columns in All Rows
  34. o SELECTing Specific Columns
  35. o Sorting Records
  36. o The WHERE Clause and Operator Symbols
  37. o The WHERE Clause and Operator Words
  38. o Checking Multiple Conditions
  39. • Advanced SELECTs
  40. o Calculated Fields
  41. o Aggregate Functions and Grouping
  42. o Built-in Data Manipulation Functions
  43. • Subqueries, Joins, and Unions
  44. o Subqueries
  45. o Joins
  46. o Unions
  47. • Inserting, Updating and Deleting Records
  48. o Using INSERT
  49. o Using UPDATE
  50. o Using DELETE
  51. • Using MySQL Built-In Functions with SELECT
  52. o Operators
  53. o Control Flow Functions
  54. o String Functions
  55. o Numeric Functions
  56. o Date and Time Functions
  57. o Cast Functions
  58. o Other Functions
  59. o Functions for Use with GROUP BY Clauses
  60. MYSQL TABLE TYPES AND TRANSACTIONS
  61. • Understanding MySQL's Table Types
  62. o ISAM Tables
  63. o MyISAM Tables
  64. o InnoDB Tables
  65. o BerkeleyDB (BDB) Tables
  66. o MERGE Tables
  67. o HEAP Tables
  68. • Using Transactions with InnoDB Tables
  69. o What Are Transactions? Using Transactions in MySQL
  70. o The InnoDB Transaction Model
  71. ADMINISTERING MYSQL
  72. • Managing User Privileges
  73. o Creating User Accounts with GRANT and REVOKE
  74. o Privilege Levels
  75. o Evaluating Privileges
  76. o Using the REVOKE Statement
  77. o Understanding the Privilege Tables
  78. • Configuring MySQL
  79. o Setting MySQL Configuration Options
  80. o Setting InnoDB Configuration Options
  81. o Multi-Install Configuration Options
  82. o Configuring for Internationalization
  83. • Administering Your Database
  84. o Starting Up and Shutting Down the MySQL Server
  85. o Getting Information about the Server and Databases
  86. o Setting Variables
  87. o Killing Threads
  88. o Clearing Caches
  89. o Understanding the Log Files
  90. o mysqladmin Option
  91. • Backup and Disaster Recovery
  92. o Backing Up and Restoring Your Database
  93. o Testing Your Backup
  94. o Checking and Repairing Tables
  95. • Securing Your MySQL Installation
  96. o How the Privilege System Works in Practice
  97. o Securing Accounts
  98. o Securing Your Installation Files
  99. o Filtering User Data
  100. o Other Tips
  101. • Replicating Your Database
  102. o Replication Principles
  103. o Setting Up and Configuring for Replication
  104. o Advanced Topologies
  105. o The Future of MySQL Replication
  106. OPTIMIZING MySQL
  107. • Optimizing Your MySQL Server Configuration
  108. o Compiling and Linking for Speed
  109. o Tuning Server Parameters
  110. o Tuning Other Factors
  111. • Optimizing Your Database
  112. o What's Slow in MySQL Databases? Making the Right Design Choices
  113. o Indexing for Optimization
  114. o ANALYZE TABLE
  115. o Using OPTIMIZE TABLE
  116. • Optimizing Your Queries
  117. o Finding Slow Queries
  118. o Benchmarking Your Queries
  119. o Using the Slow Query Log
  120. o Using EXPLAIN to See How Queries Are Executed
  121. o Understanding MySQL's Built-In Query Optimization
  122. o Optimization Tips
  123. INTEGRATING APPLICATIONS WITH MYSQL
  124. • Integrating MySQL with Applications [Note: This section can be taught in Perl, PHP, Java, Python, C#, VB.NET, Visual Basic, or ColdFusion]
  125. o Loading the MySQL database driver
  126. o Connecting to the database [and handling connection errors]
  127. o Preparing a SQL statement
  128. o Executing a SQL statement [and handling SQL or database errors]
  129. o Displaying results
  130. o Obtaining and using database metadata
  131. o Using prepared statements to accelerate queries and defend against SQL injection attacks
  132. o Executing queries inside transactions [including how to subsequently commit or rollback each transaction]
  133. o If MySQL 5.0 is being used, we can also show how to invoke stored procedures (presuming the appropriate driver for the programming language being used supports stored procedure calls
 
  

Code development by the instructors of RealSolutions Training
Site design by Image Fusion