Page 5 - DCAP508_DATABASE_ADMINISTRATION

CONTENT

Unit 1: SQL Server RDBMS 1
Sartaj Singh, Lovely Professional University

Unit 2: Installing SQL Server 12
Sartaj Singh, Lovely Professional University

Unit 3: SQL Server Tools 38
Sartaj Singh, Lovely Professional University

Unit 4: SQL Server Storage Architecture 44
Sartaj Singh, Lovely Professional University

Unit 5: SQL Server Databases 55
Sartaj Singh, Lovely Professional University

Unit 6: SQL Server Authentication 84
Sartaj Singh, Lovely Professional University

Unit 7: Automating Administrating Tasks 98
Deepak Mehta, Lovely Professional University

Unit 8; Configuring SQL Server Network Communication 114
Deepak Mehta, Lovely Professional University

Unit 9: Database Recovery Models 122
Deepak Mehta, Lovely Professional University

Unit 10: Database Backup and Restore 131
Deepak Mehta, Lovely Professional University

Unit 11: Monitoring SQL Server for Performance 155
Sartaj Singh, Lovely Professional University

Unit 12: Tools and Techniques for Monitoring Performance 163
Sartaj Singh, Lovely Professional University

Unit 13: Monitoring Database Modifications 179
Deepak Mehta, Lovely Professional University

Unit 14: SQL Server Integration Services 188
Deepak Mehta, Lovely Professional University