STARGTH: [VU-IT-Section] [itfsd] Free Seminar on SQL Server 2008 Database developer & Administrator

Saturday, June 9, 2012

[VU-IT-Section] [itfsd] Free Seminar on SQL Server 2008 Database developer & Administrator

EVS Professional Training Institute
offers
Certified SQL Server 2008 Specialist Program

Free Seminar

on June 10, 2012 at 06:00 PM

in Lahore

Introduction
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.

Schedule & Duration


Lahore Campus
36^th batch Starting from June 16, 2012
Free Orientation on June 10, 2012 at 06:00 PM
Class Schedule
Saturday	04:00 PM to 06:00 PM
Sunday	10:00 AM to 12:00 PM
Sunday	12:00 PM to 02:00 PM

For detail schedule visit http://www.evslearning.com/schedule.aspx

Objectives

After this course student will be able to

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

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

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
Applying additional query techniques
Creating UDTs, Functions & Triggers
Implementing Indices & Full-Text search
Managing XML data in SQL Server
Implementing HTTP Endpoints
Implementing Service Broker Components
Configuring & Manage 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
Planning & Implementing Replication of Data
Monitoring & troubleshooting SQL Serer
Optimizing SQL Server Performance
SQL Server Reporting Services

Audience

Database Designers, database administrators, Programmers, analysts, Project Managers etc
IT/Computer Science graduates
Any other person having good basic understanding of databases

Final Project

Participants will develop a commercial level distributed database with the help of their trainer. they will also plan and implement its replication of the data on multiple servers as well as backup and restoration of database.

Certificate