SQL Server 2005 Training:

 

This course is also an elective for the MCSE as well as MCDBA

 

This course may also available as an online course. Click here to see our online courses.


 

 

SQL Admin 2005 Training Course

For SQL Admin Exam 70-228

 

 


SQL Admin Course Objective

 

·          Recognize the differences among the three primary database backup types

·          Plan database backup scheduling based on backup type and recovery model selection

·          Determine when each of the three recovery methods should be used

·          Identify the types of integrity found in database implementations

·          Use SQL Server 2000 and Windows 2000 tools to troubleshoot transactions and perform integrity checks

·          Perform system monitoring using the SQL Profiler, Enterprise Manager, and Transact-SQL command-line actions

 

 

NB:  This course is also an elective for the MCSE as well as the MCSD and MCDBA


Who should do this course?

  • Individuals who have basic mathematical, logical, and analytical problem-solving skills and who want to begin learning the Java programming language. These students include technical writers, web developers, technical managers, and individuals with a technical, non-programming background, such as system administrators.
  • Novice programmers and for those programmers who prefer to start learning the programming language at an introductory level.
  • Students wishing to get an International certification

 

 

 

Microsoft SQL Server 2005 Administration Course Overview:

 

An Overview of SQL Server 2005

        New Features

        Database Roles

        Client Tools           

 

Installing SQL Server 2005

        Preparing For Installation

        Setup User Interface

        Installing Express Edition

        Configuring an New Instance    
 

SQL Server Database Engine

        Managing Services

        Managing Servers

        Database Projects

        Database Objects          

     

SQL Server Integration Services (SSIS)

        What Happened To DTS?

        What is ETL?

        Integration Services Projects

        SSIS Objects

        Expressions    

 

SQL Server Analysis Services (SSAS)

        OLAP vs. OLTP

        Data Warehousing

        Data Mining

        Architecture

        Analysis Services Projects

        Analysis Services Scripting Language (ASSL)

        XML for Analysis (XMLA)

        Predictive Mining Model Language (PMML)

        Data Mining Extensions (DMX)

        Multidimensional Expression Language (MDX)     

       

 SQL Server Replication

        Overview

        Replication Types

        Agents

        Implementing

        Administering

        Enhancements   

SQL Server Reporting Services (SSRS)

        Overview

       Creating, Managing, and Delivering

        Administering          

 

SQL Server Full-Text Search (SSFTS)

        Overview

        Architecture

        Writing Queries

        Administering  
 

SQL Server Notification Services (SSNS)

        Overview

        Subscription Management

        Event Collection

        Subscription Processing

        Formatting and Delivery      

          

SQL Server Service Broker

        Overview

       Conversations

        Message Ordering and Coordination

        Transactional Asynchronous Programming

        Loosely Coupled Applications

        Components

        Administering  
 

Security

        Overview

        Catalog Views

        Security Functions

        Cryptographic Functions

        CLR Integration

        Native XML Web Services

        Integration Services

        Analysis Services

        Replication

        Reports

        Notifications

        Service Broker         

 

International Databases

        Unicode Data

        Date and Time Issues

        Collations

        International SQL

        Integration Services

        Analysis Services

        Reports

        Notifications

        Service Broker

        Full-Text Searches     

Working with XML

        Data Type

        Indexes

        Schema Collections

        For XML

        OpenXML

        Native XML Web Services       

         

Data Availability

        Disaster Recovery

       High Availability

        Backup

        Restore        

Monitoring and Performance

        Windows Performance Monitor

       SQL Server Profiler

        Database Engine Tuning Advisor (DTA)

        Federated Database Servers

        Partitioned Tables

        Partitioned Indexes

        Query Performance Issues

        Transactions and Locks

        Best Practices for Native XML Web Services         

    

Programming SQL Server 2005

        Transact-SQL

       CLR Integration Overview

        Stored Procedures

        User-Defined Functions

        User-Defined Types

        DML Triggers

        DDL Triggers

        SQL Management Objects (SMO)

        Integration Services

        Replication Management Objects (RMO)

        Reports

        Notifications  

 

Frequently Asked Questions

 

Where do you train the SQL Admin course?
We train the SQL Admin course at our Greenpoint training centre in Cape Town, South Africa.

 

What other branches do you have in SA or in the world?
We only train in Cape Town.


What books do I get with this course?

You will receive a course text book which you can take away with you to keep after the course.

How long will it take me to get certified?
We recommend that students take at least one to two weeks for exam preparation for every module they do. It is unusual for students to be able to take the exam in the same week they do the course.

What are the dates for the course?
See our schedule page: http://www.i2ko.com/Schedule_All.html

Does the price include the official exam?
No, the exam is not included in the price. Exam prices vary from centre to centre.

 

 

 

How to enrol for the SQL Admin course

  • Before enrolling for a SQL Admin course you should have the following information ready:

     
    • Date you wish to attend the course
    • Payment method – how you will be paying
    • An understanding of the costs of the total package

       
  • You can call us on our office number (see our web site contact page on www.i2ko.com) and request a booking telephonically
  • You can book by email – simply send us an email with your name, the date and how you would like to pay. We will send you an invoice and upon payment your place is secure
  • Request a credit card payment. We do accept credit card payments.

 

Course Pre-requisites:


Experience with Windows NT/2000/XP and/or Unix OS.

 

 

 

About the SQL Admin Exam

 

The SQL Admin exams are done at any authorised testing centre such as 2KO. You can find a list of exam centres close to you by going to www.vue.com

 

The exam is a multiple test, on computer at an authorised testy centre. The results are made known immediately. If you fail the test, you must book it again at a future date and will pay again.

 

How much does the SQL Admin course cost?

 

The SQL Admin course fee is quoted in the currency of your country. Please contact us for the latest prices and special offers. The exam fees are not included in the course fee unless specifically stated.

 

If you are from out of town, we can arrange accommodation close to our centre. Accommodation rates vary depending on the time of year.

 

 

 

Applicability

·         
This course is for anyone preparing for the Microsoft SQL 2000 Administration 70-228 certification exam

·          Anyone who wants to learn more about databases.

Included in your course fees:

  • Tuition for five days
  • Breakfast daily at the training centre (where applicable)
  • Teas and coffees
  • Lunches daily
  • Attendance certificate



 

Course Enquiry form

Your Name
Your Email Address
Telephone (code)+number
Where do you live?
Which course are you interested in
Delivery Method
When would you like to attend?
Enquiry from which site
How did you hear about us
Comments
Image Verification
Please enter the text from the image
[ Refresh Image ] [ What's This? ]

  

©1999 - 2007 2KO International    SEO by 1st Place