Call us: 977-14418800

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