|
Prerequisites:
Prior Knowledge of SQL, Basic Knowledge, Relational
Database Theory |
Key
Benefits:
-
Learn Database Administration Procedures
-
Know The Features Of Microsoft SQL Server
-
Ready To Install And Monitor a Microsoft
SQL Server
-
Get Ready to Become a Certified Microsoft
Systems Administrator
|
| Course
Description:
Learn the basics of installing, monitoring, and
maintaining a Microsoft SQL Server. At the conclusion of
this course, you will be able to perform any systems
administration task. You will also be prepared to take
the Microsoft Systems Administration certification
exam.
Our instructors are hands-on Database Administrators.
They will share their experiences while teaching the
course material.
|
Topics
Covered:
- Introduction To
SQL Server Administration
Microsoft SQL Server Overview, SQL Server System
Administration, Administrative Challenges,
Distributed Management Framework,
SQL Server Administration Tools
Restoring
Databases
Methods of Recovery, Recovering User Databases After
a Media Failure, Restoring a Database and its Log,
Restoring the Master Database,
Restoring the msdb Database
- Installation
Installing SQL Server, Installation Requirements,
Installing Server Software, Starting and Stopping
SQL Server, Logging into SQL Server, Verifying the
Installation, System databases, Post-installation
Configuration, Testing the Installation, Upgrading,
Upgrade Wizard, SQL Server Agent, Alerts Operators
and Jobs
Importing,
Exporting, and Distributing Data
Using the Transfer Management Interface,
Using the Bulk Copy Program,
Moving Data Using the Backup and Restore Commands,
Distributing Data on Removable Media
Databases and
Devices
Creating Devices, Creating Databases, Expanding
Devices, Resizing Databases, Expanding the
Transaction Log, Dropping Devices and Databases,
Estimating Storage Requirements
Scheduling
Tasks and Setting Alerts
Task Scheduling and Alerts Overview,
SQL Executive, Managing Task Scheduling,
Implementing SQLmail, Managing Alerts,
Using an Alerts Management Server
- Managing
User Accounts
Introduction to Database Access, Planning for
Database Access, Managing Database Groups, Managing
Login IDs and Database Users,
Displaying User Information
Monitoring and
Tuning
Goals of Monitoring and Tuning, Factors that Impact
Performance, SQL Performance Monitor Overview,
Monitoring and Tuning Memory,
Creating tempdb in Memory, Monitoring Locks
Permissions
Introduction to User Permissions, Permission
Hierarchy, Granting and Revoking Permissions,
Ownership Chains, Permissions on Views,
Permission on Stored Procedures,
Displaying Information on Permissions
Replication
Distributed Data Overview, Benefits of Replication,
SQL Server 6.5 Replication Overview, Types of
Replication Scenarios, Replication Server Event
Processing, Setting Up Replication,
Using SQL Enterprise Manager
Backup
Implementing Backups,
Using SQL Enterprise Manager,
Obtaining Information on Dump Devices
Preparation for
Microsoft Systems Administration Test
Testing Secrets, Sample Test
- Remote Data
Access
Executing Remote Procedure Calls, Configuring for
RPCs, Accessing remote data, Configuring SQL Server
for Distributed Queries,
- Transferring
Data
Insert statement, Select into, bcp Program, Bulk
Insert Statement, Data Transformation Service
- Security
Security Authentication, SQL Server Authentication,
Adding/Dropping Logins, NT Authentication, Dropping
NT User Groups, Passwords, Default Databases, Roles,
Aliases, Permissions, Viewing Logins
- Disaster
Recovery
Types, Loss of Hardware, Loss of SQL Server, Loss of
Power, Loss of Data, Remedies, Disaster/Remedy Grid
- Preventive
Maintenance
What, When, Where and Why, Server Level. Database
level
- Wizards
Defining, Show/Hide, Create, Complete, Manage
|
|
|
|
