Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Computer Certification > MCSE > FREE SEMINAR on SQL Server 2008 Database Developer & AdministratorTrack

Reply
Thread Tools

FREE SEMINAR on SQL Server 2008 Database Developer & AdministratorTrack

 
 
EVS
Guest
Posts: n/a
 
      06-13-2010
EVS Professional Training Institute
offers
Certified SQL Server 2008 Specialist


Free Seminar on Saturday June 19, 2010 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.


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

Course Schedule & Duration
29th Batch in Lahore
Duration 10 weeks
Frequency 3 Sessions a week
Start Date June 26 , 2010

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 Server
• Optimizing SQL Server Performance
• SQL Server Reporting Services
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

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.

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

Certifications
• EVS Certified SQL Server Professional
• MCITPatabase Developer SQL Server 2008
• MCITPatabase Administrator SQL Server 2008

For further details contact

Lahore Branch

Call: 042-111-685-822 or 300-4102039
Walk: 349 Ferozepure Road, M-Block Gulberg, Lahore
Visit: http://www.evslearning.com
Rawalpindi Branch

Call: 051-111-685-822 or 300-4102039
Walk: 92, 6th Road Block A, Satellite Town, Rawalpindi
Visit: http://www.evslearning.com

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
FREE SEMINAR on SQL Server 2008 Database Developer & Administrator Track EVS MCSE 0 09-23-2010 03:35 PM
Copy SQL SERVER 2008 database to sql Express 2008 AAaron123 ASP .Net 6 10-28-2008 03:39 PM
MCITP SQL Server 2005 or SQL Server 2008 Darrilgibson@gmail.com MCITP 0 12-19-2007 01:56 PM



Advertisments