Database Training
MYSQL
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
SQL Server 2008 Professional Training
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