The test verifies the knowledge and skills of the My SQL Server (My SQL). Our test is dedicated for developers and database administrators.

MySQL is the world's most popular open source database software. Because of its superior speed, reliability, and ease of use, MySQL has become the preferred choice for Web, Telecom companies and corporate IT Managers. It eliminates the major problems associated with downtime, maintenance and administration for modern, online applications.

MySQL is a key part of LAMP (Linux, Apache, MySQL, PHP / Perl / Python), the fast-growing open source enterprise software stack. More and more companies are using LAMP as an alternative to expensive proprietary software stacks because of its lower cost and freedom from platform lock-in.

The following example may arise in the test:

You are planning to optimize a query. Want to see how it is carried out and on this basis to optimize. With what should I use?
a) Use Include Estimate Execution Plan
b) Use the Include Actual Execution Plan
c) Use the EXPLAIN
d) Use SET STATISTICS TIME ON

Questions concern the skills of the Integrated Development Environment - MySQL Developer.

Authors:

Krzysztof Stachyra

Authorized Microsoft and MySQL trainer. He conducts authorized trainings and workshops on databases. Has many years of experience in implementation, administration and optimization of the Microsoft SQL Server and MySQL. Active participant of the IT community, leader of the Polish SQL Server User Group in Warsaw. Key speaker at the community's meetings and conferences. He combines his didactic work with implementation projects and ongoing administration.
Author of articles and webcasts available via the Microsoft Technet and Microsoft Technet Edge portals. graduated from the IT Department at the IT University in Katowice. He has been granted numerous certificates in MSSQL (MCT,MCITP:DBA, DEV, BI, MCTS, MCP,MCSA) and MySQL (DEV, DBA).