Home | Career Tracks | Boot Camps | Course Search | Student Log In | Request Info | 1-800-482-3172 | Contact Us

About Us
Corporate IT Training
Vocational IT Training
CareerSource Solutions
Government/VA Solutions
Financing Options
Other Training Information
Student Resources
Career Services
Promotions
Press Releases
Course Catalog
Course Search
Forms
Real Estate Classes
Store
Connect With Us

MySQL for Developers (Ed 1) Boot Camp

 

 

Click Here to View Schedules & Pricing and to Enroll Online

 

 

Duration: 5 Days

  

 

Description:

 

The MySQL for Developers course is the foundation course for developers planning on designing and implementing applications that make use of MySQL. This course covers essential SQL statements for data design, querying, and programming. In addition, it will prepare students for the MySQL Developer certification.Students who can benefit from this course:Developers who want to create applications using MySQL. Students wishing to prepare for the MySQL Developer Certification Exams

 

 

Prerequisites:

 

Having attended the MySQL for Beginners course or some experience with Relational Databases and SQL

 

 

 

What's Included:

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers  & Onsite Certification Testing
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

 

 

Course Outline:

 

Introduction
•MySQL Overview, Products and Services
•MySQL Enterprise Services
•Supported Operating Services
•MySQL Certification Program
•Training Curriculum Paths
•MySQL Website
•Installing MySQL and the World Database
MySQL Client/Server Concepts
•MySQL General Architecture
•How MySQL Uses Disk Space
•How MySQL Uses Memory
MySQL Clients
•Invoking Client Programs
•Using Option Files
•The MySQL Client
•MySQL Query Browser
•MySQL Connectors
•Third-Party APIs
Querying for Table Data
•The SELECT Statement
•Aggregating Query Results
•Using UNION
Handling Errors and Warnings
•SQL Modes
•Handling Missing or Invalid Data Values
•Interpreting Error Messages
SQL Expressions
•SQL Comparisons
•Functions in SQL Expressions
•Comments in SQL Statements
Data Types
•Data Type Overview
•Numeric Data Types
•Character String Data Types
•Binary String Data Types
•Temporal Data Types
•NULLs
Obtaining Metadata
•Metadata Access Methods
•The INFORMATION_SCHEMA Database/Schema
•Using SHOW and DESCRIBE
•The mysqlshow Command
Databases
•Database Properties
•Good Design Practices
•Identifiers
•Creating Databases
•Altering Databases
•Dropping Databases
Tables
•Creating Tables
•Table Properties
•Column Options
•Creating Tables Based on Existing Tables
•Altering Tables
•Dropping Tables
•Foreign Keys
Manipulating Table Data
•The INSERT Statement
•The DELETE Statement
•The UPDATE Statement
•The REPLACE Statement
•INSERT with ON DUPLICATE KEY UPDATE
•The TRUNCATE TABLE Statement
Transactions
•What is a Transaction?
•Transaction Commands
•Isolation Levels
•Locking
Joins
•What is a Join?
•Joining Tables in SQL
•Basic Join Syntax
•Inner Joins
•Outer Joins
•Other Types of Joins
•Joins in UPDATE and DELETE statements
Subqueries
•Types of Subqueries
•Table Subquery Operators
•Correlated and Non-Correlated Subqueries
•Converting Subqueries to Joins
Views
•What Are Views?
•Creating Views
•Updatable Views
•Managing Views
•Obtaining View Metadata
Prepared Statements
•Why Use Prepared Statements?
•Using Prepared Statements from the mysql Client
•Preparing a Statement
•Executing a Prepared Statement
•Deallocating a Prepared Statement
Exporting and Importing Data
•Exporting and Importing Data
•Exporting and Importing Data Using SQL
•Exporting and Importing Data Using MySQL Client Programs
•Import Data with the SOURCE Command
Stored Routines
•What is a Stored Routine?
•Creating, Executing and Deleting Stored Routines
•Compound Statements
•Assign Variables
•Parameter Declarations
•Flow Control Statements
•Declare and Use Handlers
•Cursors
Triggers
•What are Triggers?
•Delete Triggers
•Restrictions on Triggers
Storage Engines
•SQL Parser and Storage Engine Tiers
•Storage Engines and MySQL
•The MyISAM Storage Engine
•The InnoDB Storage Engine
•The MEMORY Storage Engine
•Other Storage Engines
Optimization
•Overview of Optimization Principles
•Using Indexes for Optimization
•Using EXPLAIN to Analyze Queries
•Query Rewriting Techniques
•Optimizing Queries by Limiting Output
•Using Summary Tables
•Optimizing Updates
•Choosing Appropriate Storage Engines TOPIC22 Conclusion

 

Academy Code of Honor:  
The Academy guarantees that students shall pass all vendor examinations during the training program or may re-attend within one year of the program completion date. Students will only be responsible for accommodations and vendor exam fees.  

Student Login | Request Info | Course Search | Contact Us