MySQL Release 5.0+ Developer, Part 1
Course: MYSQLD1
Duration: 2 Days
Level: I
Course Summary
This course is designed to give you hands-on practice working with a MySQL database. Although the focus is to enable students to meet the standards of MySQL 5.0 OCA Certification. The enhancements in versions 5.1, 5.5 and 5.6 will also be discussed and the class will be conducted using a MySQL Version 5.5 database.
« Hide The Details
Topics Covered In This Course
Architecture
- Client Server Basics
- Using MySQL Client Programs
- Option Syntax
- Option Files
- Default Database Selection
- GUI Client Connections
- MySQL SQL Modes
MySQL Command Line
- Interactive Use
- Statement Terminators
- Understanding Prompts
- Using Editing Keys
- Using Script Files
- Output Formatting
- Commands / SQL Statements
- Options : --safe_updates
MySQL Graphical Interface
- Capabilities
- Using the GUI Tools
- Entering Queries
- Viewing Results
- Editing Scripts
- Working With Stored Routines
- Browsers
- The Table Editor
- Managing Connections
- Connection Profiles
MySQL Connectors
- Interfaces
- ODBC
- Java
- Net
- Other Connectors
MySQL Datatypes
- Numeric Types
- The BIT Datatype
- String Datatypes
- Temporal Datatypes
- Column Attributes
- AUTO_INCREMENT
- Handling Data Issues
Using Strict Mode
MySQL Identifiers
- Syntax
- Case Sensitivity
- Qualified Naming
- Reserved Word Use
Databases / Schemas
- Database Properties
- Database Creation
- Database Alteration
- Dropping Databases
- Getting Metadata
Tables / Indexes
- Table Properties
- Table Creation
- Storage Engines
- Tables From Existing Tables
Table Modification
- Adding / Dropping Columns
- Column Modification
- Renaming Tables
- Multiple Alterations
- Dropping Tables
- Deleting From Tables
- Index Algorithms
- Creating Indexes
- Dropping Indexes
- Table & Index Metadata
The SELECT Statement
- Column Specification
- Column Aliases
- USE Database Command
- The WHERE Clause
- The ORDER BY Clause
- Sort Order / Collation
- The LIMIT Clause
- DISTINCT / ALL
- Aggregating Data
- The GROUP BY Clause
- The HAVING Clause
- ROLLUP
- Set Operators
SQL Expressions
- Components
- Numerical Expressions
- Character String Expressions
- Pattern Matching: LIKE
- Date / Time Expressions
- Functions For Comparisons
- Functions For Control Flow
- Aggregations
- Math Functions
- String Functions
- Date Functions
- Dealing With NULL
- Commenting
Data Manipulation Language
- The UPDATE Statement
- The INSERT Statement
- INSERT / ON DUPLICATE KEY UPDATE
- The REPLACE Statement
- UPDATE With LIMIT / ORDER BY
- UPDATE Safety
- Multi-Table Updates
- The DELETE Statement
- The TRUNCATE Statement
- Privileges For DML
Who Should Take This Course
Application Developers, Database Administrators, Support Staff, Management and anyone seeking an OCA or OCP Certification.
Recommended Prerequisites
Participants should be well familiar with IT terminology and computer use. They should also be familiar with relational database concepts.
Training Style
Short lecture sessions (60%) along with hands-on lab sessions (40%).
« Hide The Details
Related Courses
| Code |
Course Title |
Duration |
Level |
|
MYSQLD |
MySQL Release 5.0+ Developer |
4 Days |
I |
Details |
MYSQLA |
MySQL Release 5.0+ Database Administrator |
4 Days |
I |
Details |
MYSQLD2 |
MySQL Release 5.0+ Developer, Part 2 |
2 Days |
II |
Details |
Every student attending a Verhoef Training class will receive
a certificate good for $100 toward their next public class taken
within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a
single student in any of our public or web-based classes.
Contact your account manager or our sales office for details.
|
