| |
May 06, 2024
|
|
|
|
|
2022-2023 Catalog [ARCHIVED CATALOG]
|
DBMS 240 - Microsoft SQL Server Database Maintenance
PREREQUISITES: DBMS 130 - Data Management using Structured Query Language and DBMS 150 - Database Administration .
PROGRAM: Data Analytics
CREDIT HOURS MIN: 3
LECTURE HOURS MIN: 2
LAB HOURS MIN: 2
DATE OF LAST REVISION: Fall, 2020
Microsoft SQL Server Maintenance involves students installing, configuring and maintaining a Microsoft SQL Server. Students explore the automatic database management, monitoring and tuning facilities of Microsoft SQL Server. Discussion covers all aspects of running Microsoft SQL Server, including managing security, monitoring, troubleshooting, and optimizing performance. Additional topics will include controlling resource utilization; using database scheduler; handling database corruption; data backup and recovery; and troubleshooting database problems.
MAJOR COURSE LEARNING OBJECTIVES: Upon successful completion of this course the student will be expected to:
- Plan and implement a SQL Server installation.
- Describe system databases, physical structure of databases and the most common configuration options.
- Explain the transaction log and SQL Server recovery models.
- Implement different backup and recovery strategies available with SQL Server.
- Use the import/export wizards and explain how they relate to SQL Server Integration Services.
- Implement SQL Server security models in the creation of logins, users, and permissions.
- Employ fixed server roles, user-defined server roles, fixed database roles, and user-defined database roles.
- Utilize SQL Server services.
- Configure database mail, alerts, and notifications.
- Create database maintenance plans.
- Introduce Dynamic Management Views and the configuration of data collection.
- Discuss the use of Central Management Servers and Multi-Server queries.
- Explain the virtualization of SQL Server and Data-Tier Applications.
- Troubleshoot SQL Server databases.
COURSE CONTENT: Topical areas of study include -
- Server Installation and Configuration
- Collations
- Data Compression and Partitioning
- Replication
- Database Integrity
- Database Mirroring and Snapshots
- Indexes
- Log Shipping
- Resource Governor
- Server Services
- SQL Server Agent Alerts
- SQL Server Agent Operators
- SQL Server Profiler/Trace Data
- Surface Area
- Data Encryption
- Back Up Databases
- Backup and Recovery
- Concurrency Problems
- Database Engine Tuning Advisor
- Database Mail
- Database Roles
- Declarative Management Framework
- Dynamic Management Views Collection
- Full-text indexing
- Import and export data
- Logins and Server Roles
- Maintenance plans
- Performance Studio
- Server components and instances
- SQL Agent job execution
- SQL Server clustered instance
- SQL Server instance permissions
- System Monitor performance data
- SQL Server Audit
- Multi-Server queries
Course Addendum - Syllabus (Click to expand)
|
|
