Module 3 – SLP

DATABASE APPLICATIONS

Recall that for the SLP assignment for this course, we are conducting assessments of database programs and demonstrations available online.

For this module you’ll be checking into a very extensive and useful online tutorial set from Microsoft:

Learning Resources

Video Series: SQL Server 2005 Express Edition for Beginners

Getting Started with SQL Server Express

This video series is designed specifically for SQL Server beginnersindividuals who are interested in learning the basics of how to create, manage, and connect to SQL Server Express databases. Whether youre just a beginner or somewhat familiar with databases, these video lessons will help you get better acquainted with SQL Server 2005 Express.

Getting Started

The series includes almost 9 hours of video-based instruction that walks SQL Server beginners through the steps of learning about SQL Server databases to actually connecting a SQL Server database to a Web application. Select your starting point below based on your skill set.

There are 13 Learning Videos in the set. Obviously, we don’t expect you to get through the entire set, even spread across two modules. However, for this Module you should be able to get through at least the first two parts (4 videos):

Introduction

Learning Video 1: What is a database?

Designing Tables

Learning Video 2: Understanding Database Tables and Records

Learning Video 3: More about Column Data Types and Other Properties

Learning Video 4: Designing Relational Database Tables

The more of the tutorial you can work through, the better; however, your grade is primarily dependent on how you approach the task and how much learning energy you put into it rather than specific output from the tutorial. If you get through these parts easily and want to push on, fine’ you’ll be getting a leg up on next Module.

Once you have completed your exploration of the tutorial, to finish the project for this module you are to prepare a short report covering the following topics:

• a comprehensive review of what the tutorial teaches
• a thorough report on what you learn specifically from the tutorial
       (note: the first two topics should be at least 75% of your write-up)
• how good a job the tutorial does, who might find the tutorial useful, and any other aspect of the tutorial that you think a reader might find useful.  
•  Your paper should be three to four pages in length and ,reflect your personal experiences