SQL Server Administration

SQL Server Database is a very popular database engines in today’s business world. There is a great need of SQL Server Database Administrators in the IT world.  Join iRed Systems to get yourself ready for a DBA career.
Don’t know much of SQL Server, don’t worry we will teach you to enough to become a SQL Server DBA.  We will help you boost your confidence to handle an enterprise level database and build your career.

In this course you will learn the basic concepts of database, install sql server, how to create database objects, how to implement database objects, build sqls, tune sqls, perform day to day dba activities and so on. This course is designed to make a novice users to a skilled SQL Server DBA.

Skill Level : Novice to Intermediate

Duration :  3 weeks

Pre Requisites:

  •  Basic knowledge of how to use windows operating systems.
  •  Windows operating system based computer.
  •  Basic SQL knowledge.
  • Able to spend 2-3 hrs per day.
  • Positive attitude.

Course Content:

  • SQL Server 2012 R2 Overview and Installation
  • Creating and Managing Databases
  • Creating and Managing Tables and Implementing Data Integrity
  • Data Manipulation and Data Correlation
  • SQL Server Built-in Functions
  • Creating and Managing Views
  • Introduction to T-SQL Programming
  • Creating and Modifying Procedures and Cursors
  • Creating and Modifying user defined Functions
  • Creating and Modifying Triggers
  • Working with Distributed Data
  • SQL Server Security
  • Creating and Managing Indexes
  • Backup/Recovery
  • Database Mail
  • SQL Server Scheduling and Notification
  • Monitoring and Troubleshooting SQL Server Performance
  • Database Mirroring
  • Replication
  • SQL Server Integration Services (SSIS)

For detailed syllabus please contact us 

Quick Call

Training Specials !

  • SQL Basics - 5 % off
  • DB2 UDB Administration - 10% off