FREE SEMINAR on SQL Server 2008 Database Developer & AdministratorTrack

Discussion in 'MCSE' started by EVS, Jun 13, 2010.

  1. EVS

    EVS Guest

    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
    • MCITP:Database Developer SQL Server 2008
    • MCITP:Database 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
    EVS, Jun 13, 2010
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    0
    Views:
    1,431
  2. inquisitive

    70-432 SQL Server 2008 Database Implementation exam

    inquisitive, Jul 28, 2010, in forum: Microsoft Certification
    Replies:
    0
    Views:
    1,811
    inquisitive
    Jul 28, 2010
  3. EVS
    Replies:
    0
    Views:
    1,827
  4. DataBase DataBase DataBase DataBase

    , Sep 26, 2012, in forum: Computer Information
    Replies:
    0
    Views:
    1,010
  5. Database Database Database Database

    , Sep 27, 2012, in forum: Computer Information
    Replies:
    0
    Views:
    868
Loading...

Share This Page