timofte andrei
Homepage timofte andrei About PHP timofte andrei About Java timofte andrei About MySQL timofte andrei About C timofte andrei About C++ timofte andrei About Linux timofte andrei Contact Us
Oracle MySQL Developer
-Exam 2-
timofte andrei
MySQL is not a new name nowadays in information technology as it is the only easy way to handle with databases. It is an efficient way of managing websites by using less energy and time. It has proper support system for new and professional users and they can run it with training and practice. It can help in many ways and in many fields including business, social networking websites containing bulk of data, and marketing large amounts of storage data in finance. For those candidates without prior experience, certifications will help prove to their employers that have the understanding and skills required for job roles that demand knowledge of MySQL products. The certification is not a guarantee that you will get the job, the certification will only improve your chances of getting the job. For those candidates with experience, the certification will boost their resume and chances are, there will be something new that you will learn. The Oracle Certified Professional, MySQL 5 Developer Certification is targeted toward candidates who will be able to develop applications that use MySQL as back-end storage. A certificate graduate is capable of creating and using databases and tables and maintaining data stored in a MySQL database. This candidate will be able to maintain data in company databases and perform data analysis. The examination can be taken at any Pearson VUE testing center worldwide. The MySQL Developer - Exam 2 consists in 70 multiple choice questions, exam duration is 90 minutes and the passing mark is on 60%.

Exam Topics

Section 1: Joins (10%)
Overview
Writing Inner Joins
Writing Outer Joins
Resolving Name Clashes Using Qualifiers and Aliases
Multiple-Table UPDATE and DELETE Statements


Section 2: Subqueries (10%)
Types of Subqueries
Subqueries as Scalar Expressions
Correlated Subqueries
Comparing Subquery Results to Outer Query Columns
Comparison Using Row Subqueries
Using Subqueries in the FROM Clause
Converting Subqueries to Joins
Using Subqueries in Updates


Section 3: Views (15%)
Reasons to Use Views
Creating Views
Altering Views
Dropping Views
Checking Views
Displaying Information About Views
Privileges for Views


Section 4: Importing and Exporting Data (5%)
Import and Export Operations
Importing and Exporting Using SQL
Importing and Exporting Data from the Command Line


Section 5: User Variables (5%)
User Variable Syntax
User Variable Properties


Section 6: Prepared Statements (5%)
Benefits of Prepared Statements
Using Prepared Statements from the mysql Client
Preparing a Statement
Executing a Prepared Statement
Deallocating a Prepared Statement


Section 7: Stored Routines (20%)
Benefits of Stored Routines
Differences Between Stored Procedures and Functions
The Namespace for Stored Routines
Defining Stored Routines
Creating Stored Routines
Altering Stored Routines
Dropping Stored Routines
Invoking Stored Routines
Obtaining Stored Routine Metadata
Stored Routine Privileges and Execution Security


Section 8: Triggers (5%)
Reasons to Use Triggers
Trigger Concepts
Creating a Trigger
Restrictions on Triggers
Referring to Old and New Column Values
Destroying a Trigger
Privileges Required for Triggers


Section 9: Obtaining Database Metadata (10%)
Overview of Metadata Access Methods
Using INFORMATION_SCHEMA to Obtain Metadata
Using SHOW and DESCRIBE to Obtain Metadata
Using mysqlshow to Obtain Metadata


Section 10: Debugging MySQL Applications (5%)
Interpreting Error Messages
The SHOW WARNINGS Statement
The SHOW ERRORS Statement
The perror Utility


Section 11: Basic Optimizations (10%)
Overview of Optimization Principles
Using Indexes for Optimization
General Query Enhancement
Choosing Appropriate Storage Engines
Normalization
HTML/CSS Courses
timofte andrei
HTML is the basic language of web programmming domain. This course presents the principles of HTML and CSS and the way it can be combined this two languages. With HTML and CSS we can create profesional webpages with a simple text editor and a common Internet browser.
Read More
Javascript/JQuery Courses
timofte andrei
This course presents the basics of Javascript programming language and also the JQuery technology. Javascript is a very popular web programming language and it's very useful for creating interactive web pages. DHTML is a combination of HTML, CSS and Javascript.
Read More