MYSQL FOR DEVELOPERS ED 3 Duration: 5 Days; Instructor-led ...
CENTER OF KNOWLEDGE, PATH TO SUCCESS
Website: www.info-trek.com
MYSQL FOR DEVELOPERS ED 3 Duration: 5 Days; Instructor-led WHAT YOU WILL LEARN 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. 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.
AUDIENCE This course is specially design for Web Administrator, Developer and Database Administrators
PREREQUISITES Required Prerequisites: • Basic knowledge of SQL • Experience of creating tables and queries in a relational database • Experience of Java, PHP or anothe programming or scripting language • MySQL for Beginners Ed 3 Dynamic
• MySQL for Database Administrators Ed 3.1 This MySQL for Database Administrators course is designed for DBAs and other database professionals. Learn to configure the MySQL Server, set up replication and security, perform database backups and performance tuning and protect MySQL databases. • MySQL for Database Administrators Ed 2 This MySQL for Database Administrators training is for DBAs and other database professionals who want to install the MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL databases.
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.
Suggested Prerequisites: • MySQL and PHP - Developing Applications
• MySQL Advanced Stored Procedures This MySQL Advanced Stored Procedures training takes a hands-on approach. Focused labs will teach you how to maximize the use of stored procedures; you'll also learn how to discern when an application should contain stored procedures and when it should not.
Web
Recommended Related Training Courses: • MySQL Performance Tuning This MySQL Performance Tuning training will teach you practical, safe and highly efficient ways to optimize performance for the MySQL Server. You'll evaluate the architecture, learn to use the tools, configure the database for performance and more.
• MySQL Developer Techniques This MySQL Developer Techniques training is designed for MySQL[tm] developers. You'll learn to create complex queries and efficient structures while improving the performance of your database applications and more. • MySQL High Availability This MySQL High Availability training teaches database administrators & system architects to analyze high availability options, including clustering & replication solutions within MySQL. Learn how to decide which high availability solution is appropriate.
METHODOLOGY This program will be conducted with interactive lectures, PowerPoint presentations, discussions and practical exercises
COURSE OBJECTIVES Upon completion of this program, participants should be able to : • 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 • Use SQL statements to modify table data • Maintain database integrity with transactions • Write multiple table queries • Create “virtual tables” containing specific data
MySQL for Developers ED 3 | Page 1 of 3 050214
• • • •
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
Module 1 - Introduction MySQL Overview, Products, Services MySQL Services and Support Supported Operating Services MySQL Certification Program Training Curriculum Paths MySQL Documentation Resources The MySQL client/server model Communication protocols Storage engines How MySQL uses memory and disk space The mysql command line client Using SQL scripts How MySQL uses databases Installing and populating the class database
• • •
• • • • •
Invoking client programs Features of the mysql client Modifying client behavior with options Configuring client behaviour with option files MySQL Workbench MySQL Utilities
MySQL connectors Oracle and community connectors Why write custom programs? Connecting to MySQL server by using Java and PHP Embedding a MySQL database in a program MySQL and NoSQL InnoDB integration with memcached
The major categories of data types Character sets and collation Choosing the correct data type NULL and NOT NULL The spatial data type extensions
• • • • •
Inserting data into a table Deleting data from a table Updating data in a table Replacing data in a table Truncating table data
• • • • • • • • • • •
Using transactions for concurrent updates The ACID transaction rules Isolating transactions Joining Tables Table join concepts The different join methods Cartesian joins Outer and inner joins Joining a table to itself Column references and table aliases Multi-table UPDATE and DELETE statements
Module 12 - Subqueries • • • • •
Nesting queries Correct positioning of subqueries Using the appropriate type of subquery Using the correct SQL syntax to create subqueries Quantifiers for subquery comparisons
Module 13 - Views
Module 6 - SQL Expressions • •
Table properties Column options Creating a table Modifying a table Displaying table information Renaming a table Removing a table Foreign Keys
Module 11 - Transactions
Module 5 - Data Types • • • • •
The MySQL data directory Database design best practices Normalization Choosing identifiers for database entities Creating a database Modifying a database Removing a database
Module 10 - Manipulating Table Data
Module 4 - MySQL Connectors And APIs • • • •
Module 8 - Databases
• • • • • • • •
Module 3 - MySQL Clients • • • • • •
Metadata access methods The INFORMATION_SCHEMA database Metadata commands SHOW statements
Module 9 - Tables
Module 2 - Client And Server Concepts • • • • • • • •
• • • • • • • • • • •
COURSE OUTLINE • • • • • •
Module 7 - Obtaining Metadata
Components of expressions Applying numeric, string, spatial, and temporal values in expressions Pattern matching for string expressions The properties of NULL values Functions in expressions Combining result sets from multiple queries Comments in SQL statements
• • • • • •
What are views? Reasons for using views Creating a view Checking a view Changing and removing a view Setting view privileges
www.info-trek.com
MySQL for Developers ED 3 | Page 2 of 3 050214
Module 14 - Prepared Statements • • • •
Reasons for using prepared statements Using prepared statements from the mysql command-line client Preparing, executing, and deallocating prepared statements Using prepared statements in code, with Connectors
Module 15 - Stored Routines • • • • • • • •
Stored procedures and stored functions Creating and executing stored routines Examining an existing stored routine Deleting an existing stored routine Assigning variables in stored routines Flow control statements Cursor usage and limitations Limitations of stored routines and stored functions
Module 16 - Triggers • • • • •
What are triggers? When to use triggers Creating triggers Deleting triggers Scheduling events
Module 17 - Handling Errors And Warnings • • • • • • •
The effect of SQL modes on error output Dealing with missing or invalid data values Interpreting error messages Using the SHOW WARNINGS and SHOW ERRORS statements MySQL diagnostic information The perror utility program Handling errors when coding with Connectors
Module 18 - Optimization • • • • •
The role of the query optimizer Strategies available for optimizing queries Using the EXPLAIN statement to predict query performance Using indexes for optimization Describing the role of MySQL Enterprise Monitor in query optimization
Module 19 - Conclusion • • • • •
Course Overview MySQL Curriculum Course Evaluation Thank You! Q&A Session
www.info-trek.com
MySQL for Developers ED 3 | Page 3 of 3 050214
Website: www.info-trek.com
MYSQL FOR DEVELOPERS ED 3 Duration: 5 Days; Instructor-led WHAT YOU WILL LEARN 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. 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.
AUDIENCE This course is specially design for Web Administrator, Developer and Database Administrators
PREREQUISITES Required Prerequisites: • Basic knowledge of SQL • Experience of creating tables and queries in a relational database • Experience of Java, PHP or anothe programming or scripting language • MySQL for Beginners Ed 3 Dynamic
• MySQL for Database Administrators Ed 3.1 This MySQL for Database Administrators course is designed for DBAs and other database professionals. Learn to configure the MySQL Server, set up replication and security, perform database backups and performance tuning and protect MySQL databases. • MySQL for Database Administrators Ed 2 This MySQL for Database Administrators training is for DBAs and other database professionals who want to install the MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL databases.
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.
Suggested Prerequisites: • MySQL and PHP - Developing Applications
• MySQL Advanced Stored Procedures This MySQL Advanced Stored Procedures training takes a hands-on approach. Focused labs will teach you how to maximize the use of stored procedures; you'll also learn how to discern when an application should contain stored procedures and when it should not.
Web
Recommended Related Training Courses: • MySQL Performance Tuning This MySQL Performance Tuning training will teach you practical, safe and highly efficient ways to optimize performance for the MySQL Server. You'll evaluate the architecture, learn to use the tools, configure the database for performance and more.
• MySQL Developer Techniques This MySQL Developer Techniques training is designed for MySQL[tm] developers. You'll learn to create complex queries and efficient structures while improving the performance of your database applications and more. • MySQL High Availability This MySQL High Availability training teaches database administrators & system architects to analyze high availability options, including clustering & replication solutions within MySQL. Learn how to decide which high availability solution is appropriate.
METHODOLOGY This program will be conducted with interactive lectures, PowerPoint presentations, discussions and practical exercises
COURSE OBJECTIVES Upon completion of this program, participants should be able to : • 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 • Use SQL statements to modify table data • Maintain database integrity with transactions • Write multiple table queries • Create “virtual tables” containing specific data
MySQL for Developers ED 3 | Page 1 of 3 050214
• • • •
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
Module 1 - Introduction MySQL Overview, Products, Services MySQL Services and Support Supported Operating Services MySQL Certification Program Training Curriculum Paths MySQL Documentation Resources The MySQL client/server model Communication protocols Storage engines How MySQL uses memory and disk space The mysql command line client Using SQL scripts How MySQL uses databases Installing and populating the class database
• • •
• • • • •
Invoking client programs Features of the mysql client Modifying client behavior with options Configuring client behaviour with option files MySQL Workbench MySQL Utilities
MySQL connectors Oracle and community connectors Why write custom programs? Connecting to MySQL server by using Java and PHP Embedding a MySQL database in a program MySQL and NoSQL InnoDB integration with memcached
The major categories of data types Character sets and collation Choosing the correct data type NULL and NOT NULL The spatial data type extensions
• • • • •
Inserting data into a table Deleting data from a table Updating data in a table Replacing data in a table Truncating table data
• • • • • • • • • • •
Using transactions for concurrent updates The ACID transaction rules Isolating transactions Joining Tables Table join concepts The different join methods Cartesian joins Outer and inner joins Joining a table to itself Column references and table aliases Multi-table UPDATE and DELETE statements
Module 12 - Subqueries • • • • •
Nesting queries Correct positioning of subqueries Using the appropriate type of subquery Using the correct SQL syntax to create subqueries Quantifiers for subquery comparisons
Module 13 - Views
Module 6 - SQL Expressions • •
Table properties Column options Creating a table Modifying a table Displaying table information Renaming a table Removing a table Foreign Keys
Module 11 - Transactions
Module 5 - Data Types • • • • •
The MySQL data directory Database design best practices Normalization Choosing identifiers for database entities Creating a database Modifying a database Removing a database
Module 10 - Manipulating Table Data
Module 4 - MySQL Connectors And APIs • • • •
Module 8 - Databases
• • • • • • • •
Module 3 - MySQL Clients • • • • • •
Metadata access methods The INFORMATION_SCHEMA database Metadata commands SHOW statements
Module 9 - Tables
Module 2 - Client And Server Concepts • • • • • • • •
• • • • • • • • • • •
COURSE OUTLINE • • • • • •
Module 7 - Obtaining Metadata
Components of expressions Applying numeric, string, spatial, and temporal values in expressions Pattern matching for string expressions The properties of NULL values Functions in expressions Combining result sets from multiple queries Comments in SQL statements
• • • • • •
What are views? Reasons for using views Creating a view Checking a view Changing and removing a view Setting view privileges
www.info-trek.com
MySQL for Developers ED 3 | Page 2 of 3 050214
Module 14 - Prepared Statements • • • •
Reasons for using prepared statements Using prepared statements from the mysql command-line client Preparing, executing, and deallocating prepared statements Using prepared statements in code, with Connectors
Module 15 - Stored Routines • • • • • • • •
Stored procedures and stored functions Creating and executing stored routines Examining an existing stored routine Deleting an existing stored routine Assigning variables in stored routines Flow control statements Cursor usage and limitations Limitations of stored routines and stored functions
Module 16 - Triggers • • • • •
What are triggers? When to use triggers Creating triggers Deleting triggers Scheduling events
Module 17 - Handling Errors And Warnings • • • • • • •
The effect of SQL modes on error output Dealing with missing or invalid data values Interpreting error messages Using the SHOW WARNINGS and SHOW ERRORS statements MySQL diagnostic information The perror utility program Handling errors when coding with Connectors
Module 18 - Optimization • • • • •
The role of the query optimizer Strategies available for optimizing queries Using the EXPLAIN statement to predict query performance Using indexes for optimization Describing the role of MySQL Enterprise Monitor in query optimization
Module 19 - Conclusion • • • • •
Course Overview MySQL Curriculum Course Evaluation Thank You! Q&A Session
www.info-trek.com
MySQL for Developers ED 3 | Page 3 of 3 050214
