ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

MySQL for Database Administrators NEW

Format: Formation en classe avec formateur
Autres formats:
 
 

The MySQL for Database Administrators course is the cornerstone curriculum for MySQL Database Administrators and Developers who want to use this powerful relational database.

In this course students will benefit from learning how to secure users privileges, set resource limitations, access controls and describe backup and recovery basics. Students will also learn how to create and use stored procedures, triggers and views.
 
This Course is Certified By MySQL   Flex Training Savings
 

Compétences acquises
 

  • Describe the MySQL Architecture

  • Install and Upgrade MySQL

  • Use the INFORMATION_SCHEMA database to access metadata

  • Perform the MySQL start and shutdown operations

  • Configure MySQL server options at runtime

  • Evaluate data types and character sets for performance issues

  • Understand data locking in MySQL

 

  • Understand the use of the InnoDB storage engine with MySQL

  • Maintain integrity of a MySQL installation

  • Use triggers for administration tasks

  • Understand views

  • Describe introductory performance tuning techniques

  • Perform backup and restore operations

Qui peut en profiter
 

  • Database Administrators

 

  • Developer

Préalables
 

  • Have some experience with relational databases and SQL

 
     
    Enroll For This Class
    Enroll For This Class
    MySQL Database Training Class Ce cours est donné par des formateurs certifiés Oracle.

    MySQL a nommé ExitCertified partenaire en formation et SEUL partenaire pour la prestation de la formation au Canada

    Il y a une différence. Découvrez-la
    Training Class Enrollment Ask A Question About This Training
    Code: MySQL5-DBA
    Format: Formation en classe avec formateur
    Durée: 5 days
    Certifié par: Oracle
    Frais d’inscription (CAD): 2,995$
    Oracle University Awards ExitCertified the North American Partner of the Year Award for 2011

    Recherchez des cours semblables
    Cours connexes
    Related training classes
    Instructor Training Classes
    Formation en classe avec formateur
    MySQL for Database Administrators

    Trier l'horaire par: 
         
    Edmonton, AB  Sep.10 - Sep.14.2012 course register
    Vancouver, BC  Sep.10 - Sep.14.2012 course register
    New York, NY  Jun.4 - Jun.8.2012 course register
    Ottawa, ON  Oct.22 - Oct.26.2012 course register
    Toronto, ON  Oct.22 - Oct.26.2012 course register
    Montreal, QC  Oct.22 - Oct.26.2012 course register
    6 Dates Offered      
       
    demander une autre date/un autre emplacement demander de la formation sur place
     

    MySQL for Database Administrators NEW Contenu détaillé
     
     
    Introduction
    • MySQL Overview, Products, Services
    • MySQL Services and Support
    • Supported Operating Services
    • MySQL Certification Program
    • Training Curriculum Paths
    • MySQL Documentation Resources
    MySQL Architecture
    • Describe the client/server model
    • Understand communication protocols
    • Understand how the server supports storage engines
    • Explain the basics of how MySQL uses memory and disk space
    System Administration
    • Choose between types of MySQL distributions
    • Install the MySQL Server
    • Describe the MySQL Server installation file structure
    • Start and stop the MySQL server
    • Upgrade MySQL
    • Run multiple MySQL servers on a single host
    Server Configuration
    • Set up MySQL server configuration files
    • Explain the purpose of dynamic server variables
    • Review the server status variables available
    • Configure operational characteristics of the MySQL server
    • Describe the available log files
    • Explain binary logging
    Clients and Tools
    • Describe the available clients for administrative tasks
    • Use MySQL administrative clients
    • Use the mysql command line clients
    • Use the mysqladmin for administrative tasks
    • Describe available MySQL tools
    • List the available APIs (drivers and connectors)
    Data Types
    • Describe the major categories of data types
    • Explain the meaning of NULL
    • Describe column attributes
    • Explain character set usage with data types
    • Choose an appropriate data type
    Obtaining Metadata
    • List the various metadata access methods available
    • Recognize the structure of the INFORMATION_SCHEMA database schema
    • Use the available commands to view metadata
    • Describe differences between SHOW statements and INFORMATION_SCHEMA tables
    • Use the mysqlshow client program
    • Use INFORMATION_SCHEMA to create shell commands and SQL statements
    Transaction and Locking
    • Use transaction control statement to run multiple SQL statements concurrently
    • Explain the ACID properties
    • Describe the transaction isolation levels
    • Use locking to protect transactions
    InnoDB Storage Engine
    • Describe the InnoDB storage engine
    • Set the storage engine to InnoDB
    • Illustrate the InnoDB tablespace storage system
    • Efficiently configure the tablespace
    • Use foreign keys to attain referential integrity
    • Explain InnoDB locking
    Other Storage Engines
    • Explain the general purpose of storage engines in MySQL
    • List the storage engines available for MySQL
    • Describe the key features of the MyISAM storage engine
    • Describe the key features of the MEMORY storage engine
    • Give an overview of other storage engines: FEDERATED, ARCHIVE, BLACKHOLE, NDBCLUSTER
    • Choose an appropriate storage engine
    		 
    Partitioning
    • Define partitioning and its particular use in MySQL
    • Determine server partitioning support
    • List the reasons for using partitioning
    • Explain the types of partitioning
    • Create partitioned tables
    • Describe subpartitioning
    • Obtain partitioning metadata
    • Use partitioning to improve performance
    User Management
    • Depict the user connection and query process
    • List requirements for user authentication
    • Use SHOW PROCESSLIST to show which threads are running
    • Create, modify and drop user accounts
    • List requirements for user authorization
    • Describe the levels of access privileges for users
    • List the types of privileges
    • Grant, modify and revoke user privileges
    Security
    • Recognize common security risks
    • Describe security risks specific to the MySQL installation
    • List security problems and counter-measures for network, operating system, filesystem and users
    • Protect your data
    • Use SSL for secure MySQL server connections
    • Explain how SSH enables a secure remote connection to the MySQL server
    • Find additional information for common security issues
    Table Maintenance
    • Recognize types of table maintenance operations
    • Execute SQL statements for table maintenance
    • Client and utility programs for table maintenance
    • Maintain tables according to specific storage engines
    Exporting and Importing Data
    • Exporting Data using SQL
    • Importing Data using SQL
    Programming Inside MySQL
    • Creating and executing Stored Routines
    • Describing stored routine execution security
    • Creating and executing triggers
    • Creating, altering and dropping events
    • Explaining even execution scheduling
    Views
    • Defining views
    • Reasons to use views
    • Altering, checking and removing a view
    • Setting privileges for views
    MySQL Backup and Recovery
    • Describing backup basics
    • Types of backups
    • Backup tools and utilities
    • Making binary and text backups
    • Role of log and status files in backups
    • Data Recovery
    Introduction to Replication
    • Describing MySQL Replication
    • Managing the MySQL Binary Log
    • Explaining MySQL replication threads and files
    • Setting up a MySQL Replication Environment
    • Monitoring MySQL Replication
    • Troubleshooting MySQL Replication
    Introduction to Performance Tuning
    • Using EXPLAIN to Analyze Queries
    • General Table Optimizations
    • Monitoring status variables that affect performance
    • Setting and Interpreting MySQL server Variables
    Conclusion
    • Course Overview
    • MySQL Curriculum
    • Course Evaluation
    • Thank You!
    • QA Session


      ExitCertified is your Authorized IT Training Partner  
      Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

    Il y a une différence. Apprenez directement de la source.    		  
    Training Contacts  
       
    Canada United States

    Formation à Montréal :: 514.876.1666
    Formation à Ville de Québec :: 514.876.1666
    Formation à Ottawa :: 613.232.3948
    Formation à Toronto :: 416.487.3948

    Formation à Vancouver :: 604.633.3948
    Formation à Victoria :: 1.866.328.3948
    Formation à Calgary :: 403.291.2855
    Formation à Edmonton :: 780.441.3948
    Formation à Regina :: 1.866.328.3948

    		 Formation à Sacramento :: 916.669.3970
    Formation à San Francisco :: 415.975.3948
    Formation à San Jose :: 408.288.3948
    Formation à Las Vegas :: 1.800.803.3948
    Formation à Phoenix :: 602.889.9350
    À travers le monde - 613.232.3948 Des questions?
    Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
       



    (c) 2012 ExitCertified Corp. Tous droits réservés.


    ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
     
    Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
    Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
             
    Formation MySQL Formation Apple Formation en gestion de projet    
    Base de données MySQL Cours Apple, Formation Leopard Formation du PMI