цена: 13000 руб.
Для юридических лиц: 13000 руб.

Чтобы забронировать место авторизуйтесь на сайте или пройдите регистрацию.

MySQL 5.6 Developer



Oracle
Код: 1Z0-882
продолжительность: 150 минут
Язык обучения: English
Тестовая система: Pearson VUE
Филиал: Москва

Содержание

Exam Topics:

MySQL Architecture

  • Use MySQL client programs to interface with the MySQL Server interactively and in batch
  • Describe SQL Modes and their impact on behavior of MySQL
  • Identify characteristics which have session scope

General MySQL Syntax

  • Explain MySQL implementation of identifiers including case sensitivity, qualified names, aliases and use of reserved words
  • Identify MySQL data type properties and appropriate usage
  • Recognize and use common functions and expressions for all MySQL data types
  • Identify and use comment syntax
  • Describe and utilize prepared statements
  • Describe transactions and transaction isolation levels and the impact they have on database behavior

Creation and Design of MySQL Schema Objects

  • Design and create normalized databases
  • Create and modify tables using appropriate data types and indexing
  • Describe and create table constraints enforcing data integrity
  • Creating and modifying views
  • Identify and use various methods to obtain metadata for MySQL database objects

Creation, Design and Use of MySQL Stored Programs

  • Describe and use triggers
  • Create and execute stored procedures
  • Create and use stored functions
  • Implement error handling within stored procedures

Querying for Data

  • Execute a basic SELECT statement
  • Limit rows returned by a SELECT statement
  • Limit columns returned by a SELECT statement
  • Apply sorting to SELECT statement results
  • Execute SELECT statements which aggregate and group data

Modifying Data

  • Describe and execute INSERT statements
  • Describe and execute REPLACE statements
  • Describe and execute UPDATE statements
  • Describe and execute TRUNCATE statements
  • Describe and execute LOAD DATA statements
  • Describe and execute DELETE statements

Joins, subqueries and UNION

  • Identify, describe and use JOINs in MySQL commands
  • Describe and utilize subqueries in MySQL commands
  • Perform operations using UNION clause

MySQL Application Development

  • Identify key characteristics, features and options for PHP, Java and .NET development using MySQL standard drivers
  • Write a basic Java application that uses MySQL
  • Write a basic PHP application that uses MySQL
  • Write a basic .NET application that uses MySQL
  • Interpret MySQL error messages
  • Collect available diagnostic information
  • Describe and use NoSQL and memcached API

Basic Optimizations

  • Identify statements requiring optimization
  • Recognize and create optimal indexes for query optimization
  • Recognize and fix sub-optimal SQL commands
  • Identify appropriate optimization strategies for InnoDB usage
  • Optimize performance through data normalization

По вашему запросу ничего не найдено. Попробуйте изменить условия поиска.

Оставить отзыв
Об этом экзамене отзывов пока нет. Будьте первым.