|
Provided by: Online Training Directory Administering Microsoft ® SQL Server 2000 (SQL)Access |
 |
This course will provide student with the knowledge and skills required to install, manage and administer Microsoft SQL Server 2000 (SQL) databases.
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.
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.
|
|
||||||||||||||
Training
Provided by Online Training Directory
- E asked: Enquiry Cost? Course material covered? Correspondence Training / Class?
- V asked: Send me more detail
- asked: I would like to know the course fees.
- A asked: want to take the above training online from home. can you suggest a site ?
- L asked: I will be traveling to England in a month or two and want to take a course in Microsoft Access. Please provide me with possible site locations in England and the schedule of classes and if there is a possibility of living accomadations.
Administering Microsoft ® SQL Server 2000 (SQL)
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 Week 2 Week 3 Week 4
- 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
- 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
- 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
- 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
About The Training Provider: Online Training Directory
Online Training Directory - JER Online (JER Group, Inc.) lists over 1000 , cost affordable, non-credit Courses and Certificates in its own proprietary online catalog. We are always adding "more courses...all the time " to a growing inventory.
The courses and certificates that comprise JER Online s course catalog are developed by (1) JER Online, (2) a growing number of accredited .edu partners and by (3) corporate...
