This MySQL test, based on MySQL 5.1, covers the overall knowledge of the test taker on MySQL, specifically focusing on SQL syntax, designing and querying, administration, performance optimization, security, back-up and recovery, controlling and managing MySQL servers, as well as database concepts like normalization, functions and operators, stored procedures, and triggers. This test is appropriate to administer to MySQL users with a year or more experience. Total Questions 39 Question Types Multiple Choice Competencies Tested Designing and QueryingFunctions and OperatorsAdministrationDMLCreating and Modifying TablesControlling and Managing MySQL Server Tasks Tested Commit and RollbackOptimizationFunctionsGROUP BYTriggersSymbols in Regular ExpressionsNormalizationReturning Employee Tour InformationVertical OutputIdentifier QualifiersUtility CommandsString FunctionsBuilt-in MySQL FunctionsDATE/TIMESubqueryStorage EnginesMySQL AdminFederated TableSafe Updates ModeMySQL CommandsUsing Different PlatformsStorage EngineDatabase Administration StatementsCursor TypesStored ProcedureJOIN with Row ReturnINSERT StatementLoad a Table from a Text FileCreating a ViewData Type3NFValue RangeSequenceView and Table with Added ColumnMySQL Enterprise MonitorPartitioningDESCRIBE CommandManaging Account ResourceBackup and Recovery
