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 Associate
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 Associate, MySQL 5 Certification is an entry-level certification. It is intended for those who are relatively new to using the MySQL database server and covers basic database management system concepts as well as basic SQL. We recommend this certification for MySQL users that know the basics, but have not yet obtained the experience gained by professional MySQL developers. The examination can be taken at any Pearson VUE testing center worldwide. The Certified Associate Exam consists in 50 multiple choice questions, exam duration is 90 minutes and the passing mark is on 60%.

Exam Topics

Section 1: Theory, Terminology and Concepts (10%)
Client/Server Concepts
Database and Database Objects


Section 2: Data Definition using SQL (25%)
Databases
Data Types
Tables
Constraints and Indexes
Views


Section 3: Basic Data Manipulation using SQL (25%)
Recurring SQL Constructs
Adding data
Modifying data
Removing data
Searching data


Section 4: Advanced Data Manipulation using SQL (20%)
Expressions
Grouping and Aggregate Functions
Joining Tables


Section 5: Transactions (10%)
Transaction Concepts
SQL for working with Transaction


Section 6: Import/Export (10%)
Tools for Import/Export
SQL for Import/Export
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