int 401

6

Click here to load reader

Upload: kislay-singh

Post on 16-Apr-2015

28 views

Category:

Documents


0 download

DESCRIPTION

IP

TRANSCRIPT

Page 1: int 401

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

Page 2: int 401

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

Page 3: int 401

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

Page 4: int 401

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

Page 5: int 401

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

Page 6: int 401

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

pdf

Lecture 41 R-1:pg 523 and onwards

RW-17 Whats New in Parallel Data Warehouse Appliance

basics of SQL Server Parallel Data Warehouse

pdf

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