Training

You are here

Get MySQL 5 for Developer Training From OSSCube

  • Do you want to learn how to develop database applications on MySQL?
  • Do you need to use MySQL Stored Procedures, Triggers, Views, and Information Schema?
  • Do you want to create complex reports, use complex queries to retrieve data and aggregate results?
  • Do you want to transfer your data from one server to another?

Then MySQL 5.0 for Developers is for you! With an Authorized MySQL instructor and hands-on exercises you will learn how to develop applications with all the new features of MySQL 5.0 This instructor-led course is designed for students planning on developing applications that make use of MySQL 5.0. This course covers essential SQL statements for data design, querying, and programming. In addition, it will prepare students for the MySQL Developer certification.

At the completion of this course, you should be able to

  • Describe the MySQL client/server architecture
  • Understand the steps necessary to invoke MySQL client programs
  • Utilize the general-purpose MySQL client program to run queries and retrieve results
  • Perform queries and analysis of data utilizing the MySQL Query Browser graphical user interface (GUI)
  • Explain the MySQL connectors that provide connectivity for client programs
  • Select the best data type for representing information in MySQL
  • Manage the structural characteristics of your databases
  • Manage the structural characteristics of the tables within your databases
  • Utilize the SELECT statement to retrieve information from database tables
  • Utilize expressions in SQL statements to retrieve more detailed information
  • Utilize SQL statements to modify the contents of database tables
  • Write join expressions in your SQL statements to obtain information from multiple tables
  • Utilize sub queries in your SQL statements
  • Create views utilizing SELECT statements to produce "virtual tables" of specific data
  • Perform bulk data import and export operations
  • Create user defined variables, prepared statements and stored routines
  • Create and manage triggers
  • Use the INFORMATION_SCHEMA database to access metadata
  • Debug MySQL applications
  • Configure and Optimize MySQL

Certification

  • Combined with sufficient practical experience, this course prepares for the MySQL 5.0 Developer Certification Exams
  • Exam vouchers will be distributed to course attendees, until such time when in-class exams are ready to be administered on the last day of the course
  • To attain the Certified MySQL Developer title, you must pass two exams:
  • 003-002: Certified MySQL 5.0 Developer Part I
  • 004-002: Certified MySQL 5.0 Developer Part II
  • Examination is conducted at an authorized PearsonVue Center. You can contact any PearsonVue Center and take appointment for giving exam.

Who should attend

Developers who want to learn MySQL 5.0

Pre-requisites

Having attended the MySQL 5.0 for beginners course or some experience with Relational Databases and SQL.

Format

Instructor led, with hands-on lab exercises
Each student will be provided with their own computer

Duration

5 Days

Fees

INR 30,000 + 12.36% Service Tax

    client testimonials

    We’ve reduced our costs by 60% and were able to improve our data quality by moving from SalesForce.com to SugarCRM.
    Our service provider, OSSCube exceeded our expectations! Delivery was very fast and they were extremely responsive to any issues uncovered during UAT. We're looking forward to reaping the benefits of SugarCRM long into the future.

    Phillip Getto, CTO
    Orametrix, US

    Thank you all. I am very fortunate to be working with such a skilled, dedicated and gracious team. I only wish I could be there in person to express my gratitude.

    Client Representative
    Building and Construction Network, US

    The requests that OSSCube has been working on are making our jobs better so I wanted to pass the kudos along to your team!

    Project Leader of Web and Data Services
    CU Solutions Group, US

    We wanted to express our appreciation for the work your team performed on the SmartStart application. The team was always professional, following up consistently and appropriately, and followed through on every deliverable in a detailed manner. And we appreciate the professional workforce you are building at OSSCube.

    Ben and Sue, Client Representatives
    SmartStart application, US

    Well done for the successful BSS migration! I'm really conscious that there has been a huge amount of work that has gone into planning and managing this event, and it's a credit to everyone involved that it has gone as smoothly as it has done. It's been particularly encouraging to see the level of dedication and the feeling of working as 'one team' which has ensured that issues have been cleared down in a speedy fashion.

    Client Representative
    Virgin Media, US