MySQL for Developers (SQL-4501)

Course Content

Module 1 - Introduction

• MySQL Overview
• MySQL Products
• MySQL Services
• MySQL Enterprise Services
• Supported Operating Services
• MySQL Certification Program
• Training Curriculum Paths
• MySQL Website
• Installing MySQL
• Installing the world Database

Module 2 - MySQL Client/Server Concepts

• MySQL General Architecture
• How MySQL Uses Disk Space
• How MySQL Uses Memory

Module 3 - MySQL Clients

• Invoking Client Programs
• Using Option Files
• The MySQL Client
• MySQL Query Browser
• MySQL Connectors
• Third-Party APIs

Module 4 - Querying for Table Data

• The SELECT Statement
• Aggregating Query Results
• Using UNION

Module 5 - Handling Errors and Warnings

• SQL Modes
• Handling Missing or Invalid Data Values
• Interpreting Error Messages

Module 6 - SQL Expressions

• SQL Comparisons
• Functions in SQL Expressions
• Comments in SQL Statements

Module 7 - Data Types

• Data Type Overview
• Numeric Data Types
• Character String Data Types
• Binary String Data Types
• Temporal Data Types
• NULLs

Module 8 - Obtaining Metadata

• Metadata Access Methods
• The INFORMATION_SCHEMA Database/Schema
• Using SHOW and DESCRIBE
• The mysqlshow Command

Module 9 - Databases

• Database Properties
• Good Design Practices
• Identifiers
• Creating Databases
• Altering Databases
• Dropping Databases

Module 10 - Tables

• Creating Tables
• Table Properties
• Column Options
• Creating Tables Based on Existing Tables
• Altering Tables
• Dropping Tables
• Foreign Keys

Module 11 - 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

Module 12 - Transactions

• What is a Transaction?
• Transaction Commands
• Isolation Levels
• Locking

Module 13 - 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

Module 14 - Subqueries

• Types of Subqueries
• Table Subquery Operators
• Correlated and Non-Correlated Subqueries
• Converting Subqueries to Joins

Module 15 - Views

• What Are Views?
• Creating Views
• Updatable Views
• Managing Views
• Obtaining View Metadata

Module 16 - Prepared Statements

• Why Use Prepared Statements?
• Using Prepared Statements from the mysql Client
• Preparing a Statement
• Executing a Prepared Statement
• Deallocating a Prepared Statement

Module 17 - 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

Module 18 - Stored Routines

• What is a Stored Routine?
• Creating Stored Routines
• Compound Statements
• Assign Variables
• Parameter Declarations
• Execute Stored Routines
• Stored Routine Characteristics
• Examine Stored Routines
• Delete Stored Routines
• Flow Control Statements
• Declare and Use Handlers
• Cursors

Module 19 - Triggers

• What are Triggers?
• Delete Triggers
• Restrictions on Triggers

Module 20 - 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

Module 21 - 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

Module 22 - Conclusion

• Course Overview
• Training and Certification Website
• Course Evaluation
• Thank You!
• QA Session

For Details Contact Central Office Cochin:-
Ms. Angel / Ms. Harsha
Mobile: +91 9947422200/9744166610
Land phone: 91-484-4049001 / 03
Email id: mailto:enquiry@logicindia.net
Chat ids :- Yahoo : logicchat
                 Skype : logicenquiry
                  GTalk : enquiry@logicindia.net

Course Content

Module 1 - Introduction

• MySQL Overview
• MySQL Products
• MySQL Services
• MySQL Enterprise Services
• Supported Operating Services
• MySQL Certification Program
• Training Curriculum Paths
• MySQL Website
• Installing MySQL
• Installing the world Database

Module 2 - MySQL Client/Server Concepts

• MySQL General Architecture
• How MySQL Uses Disk Space
• How MySQL Uses Memory

Module 3 - MySQL Clients

• Invoking Client Programs
• Using Option Files
• The MySQL Client
• MySQL Query Browser
• MySQL Connectors
• Third-Party APIs

Module 4 - Querying for Table Data

• The SELECT Statement
• Aggregating Query Results
• Using UNION

Module 5 - Handling Errors and Warnings

• SQL Modes
• Handling Missing or Invalid Data Values
• Interpreting Error Messages

Module 6 - SQL Expressions

• SQL Comparisons
• Functions in SQL Expressions
• Comments in SQL Statements

Module 7 - Data Types

• Data Type Overview
• Numeric Data Types
• Character String Data Types
• Binary String Data Types
• Temporal Data Types
• NULLs

Module 8 - Obtaining Metadata

• Metadata Access Methods
• The INFORMATION_SCHEMA Database/Schema
• Using SHOW and DESCRIBE
• The mysqlshow Command

Module 9 - Databases

• Database Properties
• Good Design Practices
• Identifiers
• Creating Databases
• Altering Databases
• Dropping Databases

Module 10 - Tables

• Creating Tables
• Table Properties
• Column Options
• Creating Tables Based on Existing Tables
• Altering Tables
• Dropping Tables
• Foreign Keys

Module 11 - 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

Module 12 - Transactions

• What is a Transaction?
• Transaction Commands
• Isolation Levels
• Locking

Module 13 - 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

Module 14 - Subqueries

• Types of Subqueries
• Table Subquery Operators
• Correlated and Non-Correlated Subqueries
• Converting Subqueries to Joins

Module 15 - Views

• What Are Views?
• Creating Views
• Updatable Views
• Managing Views
• Obtaining View Metadata

Module 16 - Prepared Statements

• Why Use Prepared Statements?
• Using Prepared Statements from the mysql Client
• Preparing a Statement
• Executing a Prepared Statement
• Deallocating a Prepared Statement

Module 17 - 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

Module 18 - Stored Routines

• What is a Stored Routine?
• Creating Stored Routines
• Compound Statements
• Assign Variables
• Parameter Declarations
• Execute Stored Routines
• Stored Routine Characteristics
• Examine Stored Routines
• Delete Stored Routines
• Flow Control Statements
• Declare and Use Handlers
• Cursors

Module 19 - Triggers

• What are Triggers?
• Delete Triggers
• Restrictions on Triggers

Module 20 - 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

Module 21 - 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

Module 22 - Conclusion

• Course Overview
• Training and Certification Website
• Course Evaluation
• Thank You!
• QA Session