SQL Admin 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

  SQL Admin Course Contents

 Frequently Asked Questions

SQL Server Overview
 • What Is SQL Server
• SQL Server Integration
• SQL Server Databases
• SQL Server Security
• Working with SQL Server
 

Planning to Install SQL Server
 • Hardware Installation Considerations
• SQL Server 2000 Editions
• Software Installation Considerations
• Methods of Installing SQL Server
• Verifying the Installation
• Configuring SQL Server Enterprise Manager
• Troubleshooting
 

Managing Database Files
 • Introduction to Data Structures
• Creating Databases
• Managing Databases
• Placing Database Files and Logs
• Optimizing the Database Using Hardware-based RAID
• Optimizing the Database Using Filegroups
• Optimizing the Database Using Filegroups with Hardware-based RAID
• Capacity Planning
• Performance Considerations
 

Managing Security
 • Implementing an Authentication Mode
• Assigning Logins to Users and Roles
• Assigning Permissions to Users and Roles
• Managing Security Within SQL Server
• Managing Application Security
• Managing SQL Server Security in the Enterprise
 

Performing Administrative Tasks
 • Configuration Tasks Routine SQL Server Administrative Tasks Automating Routine Maintenance Tasks Creating Alerts Troubleshooting SQL Server Automation Automating Multiserver Jobs
 

Backing Up Databases
 • Preventing Data Loss
• Setting and Changing a Database Recovery Model
• SQL Server Backup
• When to Back Up Databases
• Performing Backups
• Types of Backup Methods
• Planning a Backup Strategy
• Performance Considerations
 

Restoring Databases
• SQL Server Recovery Process
• Preparing to Restore a Database
• Restoring Backups
• Restoring Databases from Different Backup Types
• Restoring Damaged System Databases
 

Monitoring SQL Server for Performance

• Why to Monitor SQL Server
• Performance Monitoring and Tuning
• Tools for Monitoring SQL Server
• Common Monitoring and Tuning Tasks
 

Transferring Data

• Introduction to Transferring Data
• Tools for Importing and Exporting Data in SQL Server
• Introduction to DTS
• Transforming Data with DTS
 

Maintaining High Availability

• Introduction to Availability
• Increasing Availability Using Failover Clustering
• Standby Servers and Log Shipping
 

Introducing Replication

• Introduction to Distributed Data
• Introduction to SQL Server Replication
• SQL Server Replication Agents
• SQL Server Replication Types
• Physical Replication Models

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

 Course Pre-requisites:

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

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

  About the SQL Admin Exam

 How much does the SQL Admin course cost?

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.

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

 Included in your course fees:

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

·          Anyone who wants to learn more about databases.

• Tuition for five days

• Breakfast daily at the training centre (where applicable)

• Teas and coffees

• Lunches daily

• Attendance certificate