Page 4 - DCAP508_DATABASE_ADMINISTRATION

SYLLABUS
Database Administration

Objectives: To Impart the skills needed to administer database of an organization using SQL Server. Student will learn: how to
create and manage data of an organization, providing authorization and authentication, network communication models,
automatic administrative tasks, backup and recovery models, SQL server performance issues and integration services.

Sr. No. Description

1. SQL Server RDBMS: What is SQL server, Different Editions of SQL Server, Architecture and Database
Objects, SQL server databases, Database storage, Security: Windows and SQL Server Authentication

2. Installing SQL Server: Installation Planning, requirements
SQL Server Tools: Overview of Management Studio , Log File Viewer

3. SQL Server Storage Architecture: Resource database, Database physical structure, Database Files, Transaction
Log
4. SQL Server Databases: System Databases. User Databases. Database Planning, Creating Databases, Tables,
Constraints, Database Diagrams, Views, Synonyms, Programming Objects – Functions, Procedures, Triggers
5. SQL Server Authentication Modes: Principals, Permissions, SQL Server Encryption Overview

6. Configuring SQL Server Network Communication: Network Protocols, Native Client Configuration
7. Automating Administrative Tasks: Database Mail, Event Notifications, SQL Server Agent, Maintenance
Plans.
8. Disaster Prevention and Recovery: Database Recovery Models. Database Backup: Back Types and options,
Backup Strategies. Restoring Databases. Database Snapshots
9. Monitoring SQL Server for Performance: Overview, Tools and Techniques for Monitoring Performance,
Monitoring Database Modifications

10. SQL Server Integration Services: How to import and export data into and from SQL server.