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 1-
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 1 consists in 70 multiple choice questions, exam duration is 90 minutes and the passing mark is on 60%.

Exam Topics

Section 1: Client/Server Concepts (5%)
General MySQL Architecture
Invoking Client Programs
Server SQL Modes


Section 2: The mysql Client Program (10%)
Using mysql Interactively
Statement Terminators
The mysql Prompts
Editing Keys in mysql
Using Script Files with MySQL
mysql Output Formats
Client Commands and SQL Statements
Using Server-Side Help
Using the --safe-updates Option


Section 3: Connectors (5%)
MySQL Client Interfaces
Connector/ODBC
Connector/J
Connector/NET


Section 4: Data Types (15%)
Numeric Data Types
The BIT Data Type
String Data Types
Temporal Data Types
Column Attributes
Using the AUTO_INCREMENT Column Attribute
Handling Missing or Invalid Data Values


Section 5: Identifiers (5%)
Identifier Syntax
Case Sensitivity
Using Qualifed Names
Reserved Words as Identifiers


Section 6: Databases (5%)
Database Properties
Creating Databases
Altering Databases
Dropping Databases
Obtaining Database Metatdata


Section 7: Tables and Indexes (15%)
Table Properties
Creating Tables
Altering Tables
Emptying Tables
Dropping Tables
Indexes
Dropping Indexes
Obtaining Table and Index Metadata


Section 8: Querying for Data (15%)
Using SELECT to Retrieve Data
Specifying Which Columns to Retrieve
Specifying Which Rows to Retrieve
Aggregating Results
Grouping Results
Using UNION


Section 9: SQL Expressions (15%)
Components of SQL Expressions
Numeric Expressions
String Expressions
Temporal Expressions
NULL Values
Functions in SQL Expressions
Comments in SQL Statements


Section 10: Updating Data (10%)
Update Operations
The INSERT Statement
The REPLACE Statement
The UPDATE Statement
The DELETE and TRUNCATE TABLE Statements
Privileges Required for Update Statements
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