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