Course Syllabus & Description

                   

SQL Server 2005 Implementation and Maintenance

Spring 2008

(074-ITC-C12)

UC Riverside Extension

                   

Instructor : Jianre (Jack) Hsiung

Phone: 909-568-9492

Email:  beggerking@yahoo.com

                   

Course Description (from College Catalogue)

                   

This course provides an in-depth overview enabling participants to professionally install, maintain, troubleshoot and optimize the performance of a Microsoft SQL Server database. Topics include: database administration best practices, management of studio features and updates from previous versions, back-up and recovery procedures, T-SQL features and enhancements, utilities, security and operations. Participants gain practical experience supporting a lab environment SQL Server database. Microsoft Certification Exam 70-431.

                   

Text & Materials

                   

"MCTS: MS SQL Server 2005 Implementation and Maintenance Study Guide: Exam 70-431," Sybex ISBN: 0470025654

                   

                   

Class Website (under construction)

                   

http://jackbear.com/teaching/mst244.aspx

Class slides will be added after each class.

                   

Grading Scale

                   

Categories

Percentage

Attendance

18%

Labs

48%

Homework

10%

Test 1

12%

Test 2

12%

                   

Grade

Percentage

A

85%-100%

B

75%-84%

C

65%-74%

D

50%-64%

F

<50%

                   

                   

                   

Attendance and Class Participation

               

Being a lab focused class, attendance and participation is essential and is a direct part of your grade.   Course work is expected to be completed in a proper and timely order.

                If you are unable to attend a class, please notify me ASAP via email or phone listed above.  Extra credit assignments/ make-up tests will be given depend on circumstances. 

                   

Assignments and Tests

                   

                There will be 2 in-class tests consist of definition and some lab work. 

                Assignments will be announced in class.

               

Weekly Topics & Assignments

                   

Date

Topics & Assignments

4/23/2008

-Introduction

-Ch 1 .Installing and configuring SQL Server 2005 Ch 1 Slide

-Assignment #1

  Sign up, Download, and install free educational software from Microsoft Dreamsparks:

  https://downloads.channel8.msdn.com/

 

4/30/2008

-Ch 2. Creating and Configuring Databases               Ch 2 Slide      

-Ch 3 .Work with table and views Ch 3 slide

  Create tables

  Create views

                   

5/7/2008

-Ch 5. Introduce More Database Objects Ch 4 slide  Ch 5 slide

  Stored procedures

  Functions 

  Triggers

-Assignment #2 Assignment2

5/14/2008

      class canceled                  

5/21/2008

Test 1   canceled

                   

 

    -Ch 7. Working with relational data ch 7 slide

-import file airportfile.txt

  Transactions

  Import/Export

  Error Handling

               

5/28/2008

 

 

 

-Ch 6. Security and permission ch 6 slide

-Ch 10. Maintaining and Automating SQL Server ch 10 slide

                   

6/4/2008

-Ch 11. Performing backups and restores ch 11 slide

-Assignment#3 - assignment3

assignment2 database file

6/11/2008

-Ch 4. Performing Indexing and Full-Text Searching

or

-Ch 12. Achieving High Availability through Replication ch 12 slide

assignment3 database file -Final Assignment Final Assignment

or

-Ch 14. Monitoring and Optimizing SQL Server 2005 ch 14 slide

Final Assignment database file

                   

6/18/2008

Go through final assignment 2

ch 14

                   

-Additional Topics, Q&A  (Optional)