• IT Institute & Software House

                         

SQL Server Specialist

Responsive image

SQL Server offers a robust architecture for enterprise data management, developer productivity and business intelligence. This course provides the knowledge and practical skills needed to maximize the benefits of SQL Server. Participants gain a solid ground on which to build essential SQL Server development and administrative skills, including creating databases, generating Transact-SQL statements, implementing security and reporting through reporting services..

Brief Contents

Overview of SQL Server & Tools

•         Installing & Configuring SQL Server

•         Database Concepts & Theory

•         Understanding Data Warehousing & Data Mining

•         Designing & Implementing Databases

•         Retrieving & Manipulating Data using T-SQL

•         Creating UDTs, Functions & Triggers

•         Implementing Indices & Full-Text search

•         Managing XML data in SQL Server

•         Implementing HTTP Endpoints

•         Implementing Service Broker Components

•         Configuring SQL Server Security

•         Configuring Linked Servers

•         Implementing Database Mirroring & Log Shipping

•         Managing Database Snapshots Implementing & Maintaining SQL Server Agent Jobs

•         Managing Backup & Restoration of Databases.

Training Methodology

Lectures & Demos by industry experts • Project Driven Hands-On approach • Focus on latest tools, technologies & industry practices • Projects, assignments & quizzes for student`s evaluation

Course Project

Install & Configure SQL Server 2008 • Understand Database Concepts & Normalization • Create and Manage Databases, Transaction Logs & Database Snapshots • Create Tables, Views, Stored Procedure & Functions • Implement Constraints, Triggers, Indexes & User Defined Data Types • Write Transact-SQL Statements for Retrieving and Manipulating Data • Implement login and database security and manage permissions • Manage Complex Multi-Step Jobs with SQL Server Agent • Design Transactions that Maximize Concurrency and Minimize Contention • Manage XML Data & Implement HTTP End-Point • Implementing High Availability and Disaster Recovery • Maintain Databases (Backup, Restore & Replication) • Analyze and Cure Performance Problems using SQL Server`s Tools Audience • Database Designers, Database Administrators, Programmers, Analysts, • Project Managers etc • IT / Computer Science Graduates • Any other person having good basic understanding of databases

Certificate

Duration

36 Lectures (5 hour a week)

   Enroll Now

will soon be available !!

Online registeration will soon be available !!