SQL
Server 7.0 Database Administration Part II
This course prepares the learner for Microsoft exams #70-028 - Administering
Microsoft SQL Server 7.0, and #70-029 - Designing and Implementing
Databases with Microsoft SQL Server 7.0.
Database Administration Part II training covers such topics as:
Managing Users
Assigning User Permissions
Data Backup and Recovery
Database administrators, Database analysts, and Database developers who are
working toward the Microsoft Certified Database Administrator (MCDBA) credential
will benefit from this course. The series is designed to help the student pass
the Microsoft Exam 70-028: Administering Microsoft SQL Server 7.0 and Exam
70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0.
This series is also appropriate for individuals who derive physical database
designs, develop logical data models, create physical databases, create data
services by using Transact-SQL, manage and maintain databases, configure and
manage security, monitor and optimize databases, and install and configure
Microsoft SQL Server
Description
Microsoft exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029
Designing and
Implementing Databases with Microsoft SQL Server 7.0.
Audience
Database administrators, Database analysts, and Database developers who
are working toward
the Microsoft Certified Database Administrator (MCDBA) credential. The
series is designed to help
the student pass the Microsoft Exam 70-028: Administering Microsoft SQL
Server 7.0 and Exam 70-029:
Designing and Implementing Databases with Microsoft SQL Server 7.0. This
series is also appropriate
for individuals who derive physical database designs, develop logical data
models, create physical
databases, create data services by using Transact-SQL, manage and maintain
databases,
configure and manage security, monitor and optimize databases, and install
and configure
Microsoft SQL Server.
Prerequisites
Students understand computer system fundamentals, and have user knowledge
of Windows 95,
Microsoft Office, Internet browsing, and HTML, and e-mail systems.
Course Duration
» 5 hours
Topics Include
Unit 1: Managing Users
» Authentication Through Security Modes
» SQL Server Accounts
» SQL Server Roles
Unit 2: Assigning User Permissions
» Granting Access to a Database
» Implied Permissions
» Permission Precedence
» Managing Permissions
» Troubleshooting Security
Everything Courseware
SQL Server 7.0 Database Administration. Part II
Unit 3: Data Backup and Recovery
» Data Loss Causes and Prevention
» Establishing Backup Strategies
» Implementing SQL Server Backups
» Restoring Databases
» How to Recover Data
System Requirements CD-Based » Pentium class computer
» 200 MHz processor (266 MHz recommended)
» 32 MB RAM (64 MB recommended)
» CD-ROM drive
» Any one of Windows 95, Windows 98, Windows Me, Windows NT 4.0, Windows 2000
or Windows XP (both Windows NT 4.0 and Windows 2000 require at least 64 MB RAM)
» SVGA monitor capable of 16-bit color and 800 x 600 screen resolution
» Sound card with speakers or headphones (optional)
Featured
Computer Training Products
|
Application Training: Flash
MX Software Training, Dreamweaver
MX Software Training, Fireworks
MX Software Training
Computer Skills Development: Computer
Basics Training, Everything
Desktop (Microsoft Training), Everything
Handheld
Business Skills Development Training: Everything
Quick Business, Everything
OSHA, Everything
HR/Legal, Everything
Management Skills, Everything
Sales Skills, Everything
Basic Finance
Certification Training Everything
MCSE, Everything
MCSD, Everything
O/S 390, Everything
Programming, Everything
Cisco, Everything
UNIX, Everything
Oracle, Computer
Technician Training, Network
Technician Training
|
