This course is design to help students master the concept of administering Microsoft® SQL Server 2000 (SQL) databases effectively. When a student completes this course he/she will be able to plan and complete a successful installation or upgrade, configure and tune SQL Server 2000 databases, manage users and security, automate basic database tasks, import and export data, use transact SQL queries, replicate databases for multiple and remote users, design a backup strategy, backup and restore databases, export query results as XML, use stored procedures, access SQL Server through Query Analyzer and register SQL Server databases remotely.
Outcomes:
Upon the completion of this course student will be able to design databases and perform several tasks such as backup, replication, recovery, DTS, data warehousing, perform tasks manually or automatically.
Assessment:
There will be several quizzes for each module. After the completion of each module, the student will have to take and pass the quizzes before he/she can procede to the next module. The number of quizzes depends on the module.
After a student completes the final module, he/she will take a final exam consisting of 10 multiple choice questions.
Week 1
Introduction
Role of a Database Administrator
Operating systems
Database Server
Who does what?
Who are DBA''''s
SQL Server overview
Architecture
Integration
Tools of trade
Common Objects
Installing or Upgrading SQL Server
Determing System and User requirements
Selecting the right platform
Different Editions of SQL Server
Developing an Upgrading Strategy and Plan
Different editions of SQL Server
Installing SQL Server
Upgrading SQL Server
Starting and Stopping SQL Server
Troubleshooting Installations
Uninstalling or removing SQL Server
Week 2
SQL Server Management and Configuration
Registering a Server
Connecting to a Server
Disconnecting from a Server
Starting and Stopping Sql Server Agent
Using Enterprise Manager to Perform tasks
Configuring and Tuning SQL Server
Configuration Parameters
Advance Configuration Parameters
Managing Databases
Overview of Data Structures
What is a Database
What is Transaction Log
Creating a Database
Expanding or Shrinking a Database and Log Size
Viewing Information about a Database
Renaming, Deleting, Moving Databases
Implementing a FileGroup
Week 3
SQL Server Security Model
SQL Server login
Database Users
Permissions
Roles
Managing Logins
Managing Server Roles
Viewing and Modifying Database Roles
Deleting Logins
Changing Passwords
Granting and Revoking statement and object Permissions
Backup and Recovery
Recovery Models
Backup Devices
Performing Database, Differential and Transaction Log Backup
Backup Wizard
Performing a Database Restore
Developing a Maintenance plan
Automating Database Administration Tasks
Creating Jobs and Operators
Creating Alerts
Database Maintenance Plan Wizard
Week 4
Data Transformation Service (DTS)
Using DTS Designer and Wizard
Using DTS Packages
Making use of BCP and Bulk Insert
Troubleshooting SQL Server
Error Messages
Deciphering Error Messages
Using the Event Viewer
Managing Processes
Using DBCC and Trace statements
Monitoring SQL Server
Performance tuning
Principle of Indexes
Creating Indexes
Clustered and Non Clustered Indexes
Query Optimization
Introduction to Transact SQL (T-SQL)
Overview of Basic SQL Statements
SELECT, INSERT, UPDATE and DELETE Statements
Aggregate functions, GROUP, ORDER, HAVING statements
Using T-SQL to create tables
Examples
Using Stored Procedures and Cursors
Overview
Creating and Modifying Stored Procedures
Stored Procedures and Parameters
What is a Cursor
Creating a Cursor
Contact Hours: 24
About Online Training Directory - Training Provider
Online Training Directory - Workforce and Continuing Ed online courses are offered at basic, intermediate and advanced levels. Going beyond basic training provides a deeper and more educationally rewarding learning experience, especially for students who wish to advance careers or initiate new ones. For the general lifelong learner we continue to offer "fun to learn" single, stand-alone courses.
We look forward to...
