Client/Server Concepts MySQL architecture,
Command line options, Connection parameter options, Using
option files and Server SQL modes.
Client Programs Invoke the client programs and execute
the quries to get results.
Mysql Query browser Launching, execution and connection
management capabilities.
Mysql Connectors Different clients used connectors for
client connectivity.
Data Types Data types selection that suits data.
Database Creation, alter, drop and obtaining meta data.
Tables and Indexes Creation, Alter, emptying and
dropping of tables and index creation and obtaining table
and index Metadata.
Querying for Data Retrieve the specified columns, rows
and grouping the same.
Sql Expressions Numeric, String, Temporal, Null and
Function expressions.
Updating Data Insert, Replace, Update, Delete and
Truncate data.
Joins Overview of Inner & Outer
joins, Multiple table update and delete stmts.
Subqueries Types of subqueries, correlated subqueries,
sunqueries in FROM clause and Convertion of subqueries into
Joins.
Views Reasons for Views, Creation, Alter, Dropping and
checking views.
Importing and Exporting Data Data from command line and
using SQL.
Stored Procedures and Fuctions Definition, Creation,
Altering, Dropping and Invoking Stored routines.
Understanding the difference between stored routines and
functions.
Triggers Reasons for usage, Understanding the creation,
restrictions and Destroying the trigger.
Obtaining Database Metadata Overview of Metadata Access
methods and using SHOW and DESCRIBE to obtain Metadata.
Debugging MySQL Applications Interpreting Error
Messages, SHOW WARNINGS and ERROR statements and perros
utility.
Basic Optimizations Overview of Optimization
Principles, Using Indexes for Optimization, Choosing
Appropriate Storage Engines and Normalization.
|
