int 401
DESCRIPTION
IPTRANSCRIPT
Lovely Professional University, Punjab
Course Code Course Title Course Planner Lectures Tutorials Practicals Credits
INT401 DATABASE ADMINISTRATION 15857::Nitin Umesh 3.0 0.0 0.0 3.0
Course Category Courses with Placement focus
TextBooks
Sr No Title Author Edition Year Publisher Name
T-1 Beginning SQL Server 2008 Administration
Wood, Leiter, Wrox 1st Wiley Pub
Reference Books
Sr No Title Author Edition Year Publisher Name
R-1 Professional SQL Server 2008 Administration
Wood, Leiter 1st Wrox Programmer to Programmer 2010 series, Wrox Publications
R-2 SQL Server 2008 Unleashed microsoft developers 1st SAMS
Relevant Websites
Sr No (Web address) (only if relevant to the course) Salient Features
RW-1 http://sqlcommunity.com/HOME.aspx Database Architecture with SQL Server 2008
RW-2 http://en.wikipedia.org/wiki/Microsoft_SQL_Server#SQL_Server_2008 Microsoft SQL Server
RW-3 http://blog.sqlauthority.com/2007/12/08/sql-server-generic-architecture-image/ Generic Architecture
RW-4 http://msdn.microsoft.com/en-us/library/cc280361%28v=sql.105%29.aspx Planning and Architecture (Database Engine)
RW-5 http://www.sqlserverclub.com/essentialguides/how-to-install-sql-server-2008-step-by-step-guide.aspx
Install SQL Server 2008
RW-6 http://technet.microsoft.com/en-us/library/dd206996%28v=sql.100%29.aspx Log File Viewer
RW-7 http://msdn.microsoft.com/en-us/library/ms165730%28v=sql.105%29.aspx Database Tasks
RW-8 http://msdn.microsoft.com/en-us/library/ms144284.aspx Configuring the Authentication Mode
RW-9 http://msdn.microsoft.com/en-us/library/cc278098%28v=sql.100%29.aspx Database Encryption in SQL Server 2008 Enterprise Edition
RW-10 http://technet.microsoft.com/en-us/library/ms181591.aspx Endpoints
RW-11 http://msdn.microsoft.com/en-us/library/ms189453.aspx CREATE EVENT NOTIFICATION (Transact-SQL)
RW-12 http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/
Configure Database Mail – Send Email From SQL Database
RW-13 http://msdn.microsoft.com/en-us/library/ms175987%28v=sql.105%29.aspx Recovery Model Overview
RW-14 http://www.c-sharpcorner.com/uploadfile/nipuntomar/sql-server-2008-recovery-models/ Recovery Model Overview
RW-15 http://blog.sqlauthority.com/2010/04/05/sql-server-2008-introduction-to-snapshot-database-restore-from-snapshot/
Database Snapshot
RW-16 http://msdn.microsoft.com/en-us/library/ms140052.aspx Run the SQL Server Import and Export Wizard
RW-17 https://www.microsoft.com/sqlserver/en/us/solutions-technologies/data-warehousing/pdw.aspx
What's New in Parallel Data Warehouse Appliance
RW-18 SQL Server 2012 Data Warehousing http://download.microsoft.com/download/8/2/6/82637A52-6C06-4F8A-842C-3E630C0D5D80/SQL_Server_2012_Data_Warehousing_Datasheet.pdf
Week Number
Lecture Number
Broad Topic(Sub Topic) Chapters/Sections of Text/reference books
Other Readings,Relevant Websites, Audio Visual Aids, software and Virtual Labs
Lecture Description Learning Outcomes Pedagogical ToolDemonstration/ Case Study / Images / animation / ppt etc. Planned
Week 1 Lecture 1 SQL Server 2008 RDBMS(Different Editions of SQL Server 2008)
T-1:ch2 page 9-16 Difference bthe major differences between all but the Developer and EvaluationEditionsetween Editions of SQL Server 2008
Difference between Editions of SQL Server 2008
ppt and video
Lecture 2 SQL Server 2008 RDBMS(Different Editions of SQL Server 2008)
T-1:ch2 page 9-16 Difference bthe major differences between all but the Developer and EvaluationEditionsetween Editions of SQL Server 2008
Difference between Editions of SQL Server 2008
ppt and video
Lecture 3 SQL Server 2008 RDBMS(Different Editions of SQL Server 2008)
T-1:ch2 page 9-16 Difference bthe major differences between all but the Developer and EvaluationEditionsetween Editions of SQL Server 2008
Difference between Editions of SQL Server 2008
ppt and video
Week 2 Lecture 4 SQL Server 2008 RDBMS(Architecture and Database Objects)
T-1:ch2 RW-3 SQL Server 2008 Architecture, Internals and Tuning
to better understand the Database Engine in Microsoft SQL Server 2008
ppt and websites
Detailed Plan For Lectures
LTP week distribution: (LTP Weeks)
Weeks before MTE 7
Weeks After MTE 6
Spill Over 2
Week 2 Lecture 5 SQL Server 2008 RDBMS(Architecture and Database Objects)
T-1:ch2 RW-3 SQL Server 2008 Architecture, Internals and Tuning
to better understand the Database Engine in Microsoft SQL Server 2008
ppt and websites
Lecture 6 SQL Server 2008 RDBMS(Architecture and Database Objects)
T-1:ch2 RW-3 SQL Server 2008 Architecture, Internals and Tuning
to better understand the Database Engine in Microsoft SQL Server 2008
ppt and websites
Week 3 Lecture 7 Installing SQL Server 2008(Windows and Mixed Mode Installation. sa user and its usage. Installation Planning)
T-1:ch 2 RW-4RW-5
Planning and Architecture Database Engine
to plan how to implement your data storage systems
ppt and websites
Lecture 8 Installing SQL Server 2008(Windows and Mixed Mode Installation. sa user and its usage. Installation Planning)
T-1:ch 2 RW-4RW-5
Planning and Architecture Database Engine
to plan how to implement your data storage systems
ppt and websites
Lecture 9 Installing SQL Server 2008(Windows and Mixed Mode Installation. sa user and its usage. Installation Planning)
T-1:ch 2 RW-4RW-5
Planning and Architecture Database Engine
to plan how to implement your data storage systems
ppt and websites
Week 4 Lecture 10 SQL Server Management(SQL Server Management Studio and Meaning. What is Log File Viewer?)
T-1:ch 3 pg 41 RW-6 configuring, managing, and administering concepts through studio
basics of Log File Viewer and studio
ppt and websites
Lecture 11 SQL Server Management(SQL Server Management Studio and Meaning. What is Log File Viewer?)
T-1:ch 3 pg 41 RW-6 configuring, managing, and administering concepts through studio
basics of Log File Viewer and studio
ppt and websites
Lecture 12 SQL Server Management(SQL Server Management Studio and Meaning. What is Log File Viewer?)
T-1:ch 3 pg 41 RW-6 configuring, managing, and administering concepts through studio
basics of Log File Viewer and studio
ppt and websites
Week 5 Lecture 13 SQL Server Management(SQL Server Management Studio and Meaning. What is Log File Viewer?)
T-1:ch 3 pg 41 RW-6 configuring, managing, and administering concepts through studio
basics of Log File Viewer and studio
ppt and websites
Lecture 14 SQL Server Management(SQL Server 2008 Databases. System Databases. User Databases. Database Planning)
T-1:ch2 pg 9-41 RW-7 tasks associated with working with a database are planning, designing, implementing, optimizing and maintaining
to understand and perform various tasks, giving novice users a conceptual grounding in how databases work
ppt and websites
Lecture 15 SQL Server Management(SQL Server 2008 Databases. System Databases. User Databases. Database Planning)
T-1:ch2 pg 9-41 RW-7 tasks associated with working with a database are planning, designing, implementing, optimizing and maintaining
to understand and perform various tasks, giving novice users a conceptual grounding in how databases work
ppt and websites
Week 6 Lecture 16 Managing Databases(SQL Server Authentication Modes: Principals. Permissions. SQL Server Encryption)
T-1:Ch 14 page 327 RW-8RW-9
Configuring the Authentication Mode and Encryption algos
basics of Database Encryption and Authentication modes
ppt, websites and videos
Lecture 17 Managing Databases(SQL Server Authentication Modes: Principals. Permissions. SQL Server Encryption)
T-1:Ch 14 page 327 RW-8RW-9
Configuring the Authentication Mode and Encryption algos
basics of Database Encryption and Authentication modes
ppt, websites and videos
Lecture 18 Test 1
Week 7 Lecture 19 Configuring SQL Server Network Communication(SQL Server Endpoints)
T-1:ch 14 page 335 RW-10 Interactions with the network via endpoints
concept of configuring SQL Server Network Communication
ppt, websites and videos
Lecture 20 Configuring SQL Server Network Communication(SQL Server Endpoints)
T-1:ch 14 page 335 RW-10 Interactions with the network via endpoints
concept of configuring SQL Server Network Communication
ppt, websites and videos
Lecture 21 Configuring SQL Server Network Communication(SQL Server Endpoints)
T-1:ch 14 page 335 RW-10 Interactions with the network via endpoints
concept of configuring SQL Server Network Communication
ppt, websites and videos
MID-TERMWeek 8 Lecture 22 Automating Administrative Tasks
(Database Mail. Event Notifications)
T-1:ch 11 pg 239 RW-11RW-12
Introduction of PowerShell and SQLCMD, CREATE EVENT NOTIFICATION TransactSQL,Configure Database Mail – Send Email From SQL Database,Overview of Triggers
Creating required Profiles and Accounts as well as Configuring Emails
ppt and demonstration through required interface
Lecture 23 Automating Administrative Tasks(Database Mail. Event Notifications)
T-1:ch 11 pg 239 RW-11RW-12
Introduction of PowerShell and SQLCMD, CREATE EVENT NOTIFICATION TransactSQL,Configure Database Mail – Send Email From SQL Database,Overview of Triggers
Creating required Profiles and Accounts as well as Configuring Emails
ppt and demonstration through required interface
Lecture 24 Automating Administrative Tasks(Database Mail. Event Notifications)
T-1:ch 11 pg 239 RW-11RW-12
Introduction of PowerShell and SQLCMD, CREATE EVENT NOTIFICATION TransactSQL,Configure Database Mail – Send Email From SQL Database,Overview of Triggers
Creating required Profiles and Accounts as well as Configuring Emails
ppt and demonstration through required interface
Week 9 Lecture 25 Automating Administrative Tasks(Database Mail. Event Notifications)
T-1:ch 11 pg 239 RW-11RW-12
Introduction of PowerShell and SQLCMD, CREATE EVENT NOTIFICATION TransactSQL,Configure Database Mail – Send Email From SQL Database,Overview of Triggers
Creating required Profiles and Accounts as well as Configuring Emails
ppt and demonstration through required interface
Lecture 26 Automating Administrative Tasks(SQL Server Agent. Maintenance Plans)
T-1:ch 10 (pg 225-227) ch 12 (pg 263)
Database Maintenance Plan and agents
Automating Administrative Tasks through SQL Server Agent
ppt
Lecture 27 Test 2
Week 10 Lecture 28 Disaster Prevention and Recovery(Database Recovery Models)
T-1:Ch8 pg 151 RW-13RW-14
introduction of Database Recovery Models
know which recovery model is more important for the database
ppt
Lecture 29 Disaster Prevention and Recovery(Database Recovery Models)
T-1:Ch8 pg 151 RW-13RW-14
introduction of Database Recovery Models
know which recovery model is more important for the database
ppt
Lecture 30 Database Backup(Back Types and options, Backup Strategies. s)
T-1:Ch8 pg 151 RW-13 how to take backups for the required database files on regular basis
know which recovery model is more important for the database
ppt
Week 11 Lecture 31 Database Backup(Back Types and options, Backup Strategies. s)
T-1:Ch8 pg 151 RW-13 how to take backups for the required database files on regular basis
know which recovery model is more important for the database
ppt
Lecture 32 Database Backup(Back Types and options, Backup Strategies. s)
T-1:Ch8 pg 151 RW-13 how to take backups for the required database files on regular basis
know which recovery model is more important for the database
ppt
Lecture 33 Database Backup(Restoring Databases. Database Snapshot)
T-1: ch9 (pg 183) RW-15 use of static view of a database
how Snapshot database work
ppt and demonstration through required interface
Week 12 Lecture 34 Database Backup(Restoring Databases. Database Snapshot)
T-1: ch9 (pg 183) RW-15 use of static view of a database
how Snapshot database work
ppt and demonstration through required interface
Lecture 35 Database Backup(Restoring Databases. Database Snapshot)
T-1: ch9 (pg 183) RW-15 use of static view of a database
how Snapshot database work
ppt and demonstration through required interface
Lecture 36 Quiz 1
Week 13 Lecture 37 Monitoring SQL Server for Performance(Overview. Tools and Techniques for Monitoring Performance.)
T-1:Ch13 pg 287 tools and techniques that can be used to monitor Microsoft SQL Server
Monitor to get a quick overview of an SQL Server 2008 system performance
ppt
Lecture 38 Monitoring Database Modifications.(SQL Server Integration Services: How to import and export data into and from sql server.)
R-1:ch 10 RW-16 Import and Export method
the simplest method of copying data between data sources and of constructing basic packages
ppt and video
Lecture 39 Monitoring Database Modifications.(SQL Server Integration Services: How to import and export data into and from sql server.)
R-1:ch 10 RW-16 Import and Export method
the simplest method of copying data between data sources and of constructing basic packages
ppt and video
SPILL OVERWeek 14 Lecture 40 R-1:pg 523 and
onwardsRW-18 SQL Server 2012 and
Data WarehousingNextGeneration Performance with InMemory Technologies
Lecture 41 R-1:pg 523 and onwards
RW-17 Whats New in Parallel Data Warehouse Appliance
basics of SQL Server Parallel Data Warehouse
Scheme for CA:Component Frequency Out Of Each Marks Total Marks
Quiz 1 10 10
Test 1 2 10 10
Total :- 20 20
Details of Academic Task(s)
AT No. Objective Topic of the Academic Task Nature of Academic Task(group/individuals/field
work
Evaluation Mode Allottment / submission Week
Test 1 to check student's knowledge
upto 13 lect. Individual accuracy 4 / 6
Test 2 to check student's knowledge
upto 18 lect. Individual accuracy 7 / 9
Quiz 1 to check the presence of mind and speed of solving questions
upto 24 lect Individual number of right attempt
10 / 12