Installing MySQL

• General Installation Steps
• Installing MySQL on Windows
• Configuring MySQL on Windows
• Installing MySQL on Macintosh
• Installing MySQL on Linux
• Basic Configuration Options
• Upgrading MySQL

Database Design

• Normalization
• Understanding Keys
• Understanding Relationships
• First Normal Form
• Second Normal Form
• Third Normal Form

Creating a MySQL Database

• MySQL Data Types
• Extra Column Characteristics
• Introduction to Indexes
• Finalizing a Table's Design
• Choosing a Storage Engine
• Character Sets and Collations
• Creating Databases
• Creating Tables
• Modifying Tables

Basic SQL

• Using Values in Queries
• Inserting Data
• Selecting Data
• Using Conditionals
• Using LIKE and NOT LIKE
• Performing Joins
• Sorting Query Results
• Limiting Query Results
• Updating Data
• Deleting Data

MySQL 5 Features

• Stored Routines
• Using OUT Parameters
• Triggers
• Views

MySQL Administration

• The MySQL Administrator
• Backing Up Databases
• Importing Data
• MySQL Logging
• Database Maintenance
• Improving Performance

MYSQL Training Duration

• Course Duration: 20days
• Class shifts: Morning/Evening

Installing and Configuring SQL Server 2008

• Install SQL Server 2008.
• Configure SQL Server 2008 instances and databases.
• Configure SQL Server security
• Configure linked servers by using SQL Server Management Studio (SSMS).

Implementing High Availability and Disaster Recovery

• Implement database mirroring
• Implement log shipping
• Manage database snapshots.

Supporting Data Consumers

• Retrieve data to support ad hoc and recurring queries
• Manipulate relational data
• Manage XML data
• Implement an HTTP endpoint
• Implement Service Broker components
• Import and export data from a file
• Manage replication.

Maintaining Databases

• Implement and maintain SQL Server Agent jobs
• Manage databases by using Transact-SQL
• Back up a database
• Restore a database
• Move a database between servers

Creating and Implementing Database Objects

• Implement a table
• Implement a view
• Implement triggers
• Implement functions
• Implement stored procedures
• Implement constraints
• Implement indexes
• Create user-defined types
• Implement a full-text search.

Monitoring and Troubleshooting-SQL Server Performance

• Gather performance and optimisation data by using the SQL Server Profiler
• Performance and optimisation of data by using the Database Engine Tuning Advisor
• Monitor and resolve blocks and deadlocks
• Diagnose and resolve database server errors
• Monitor SQL Server Agent job history
• Gather performance and optimisation data by using DMVs.

SQL SERVER 2008 Duration

• Course Duration: 1 Month
• Class shifts: Morning/Evening