Oracle MySQL for Developers Ed 3

1
Oracle MySQL for Developers Ed 3
2

• This MySQL for Developers training teaches
  developers how to plan, design and implement
  applications using MySQL. Expert Oracle
  University instructors will teach you through
  realistic examples, interactive instruction and
  hands-on exercises using Java and PHP languages.

3
Learn To

• Use client programs and options.
• Access the database from program code.
• Build "NoSQL" applications.
• Write effective queries and stored routines.
• Inspect database metadata.
• Respond to database events with triggers.
• Handle errors and exceptions.
• Optimize SQL statements.

4
Course Objectives

• Describe the MySQL client/server architecture
• Use MySQL client programs and common options
• Program MySQL applications with Java and PHP
  connectors
• Use a NoSQL approach to store and retrieve data
• Design efficient tables
• Create and delete database objects
• Use expressions in SQL statements
• Examine database metadata

5
Course Objectives

• Use SQL statements to modify table data
• Maintain database integrity with transactions
• Write multiple table queries
• Create virtual tables containing specific data
• Create user-defined variables, prepared
  statements, and stored routines
• Create and manage triggers
• Identify and deal with errors and exceptions in
  client programs
• Write queries that are fast and effective, even
  under heavy loads

6
Benefits to You

• Many of the Internet's most popular websites rely
  on MySQL. With Hadoop integration, it is a key
  component of many big data platforms. In
  addition, MySQL brings you the best of both
  worlds with SQL and NoSQL. After taking this
  course, you will be able to write programs that
  take advantage of the power and flexibility of
  MySQL. You will have developed the skills to
  build a database that's optimal for your
  application, while creating fast and effective
  queries.

7
ThankYou

• Kalvi Training Institute and Research Centre
• 134, A R Hospital Road,
• KK Nagar,
• Madurai 625020
• Email ID helpdesk_at_kalvigroup.com
• Website https//kalvigroup.com
• Ph no 91-9500710004