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 beginners-individuals who are interested in learning the basics of how to create, manage, and connect to SQL Server Express databases. Whether you're 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?
https://www.asp.net/web-forms/videos/sql-2005/what-is-a-database
Designing Tables
Learning Video 2: Understanding Database Tables and Records
https://www.asp.net/web-forms/videos/sql-2005/understanding-database-tables-and-records
Learning Video 3: More about Column Data Types and Other Properties
https://www.asp.net/web-forms/videos/sql-2005/more-about-column-data-types-and-other-properties
Learning Video 4: Designing Relational Database Tables
https://www.asp.net/web-forms/videos/sql-2005/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 with this issue. The important part of all these project assignments is to carefully assess your own experiences with the topic, and then reflect critically on what you might have learned about yourself and about situations through this assessment process.
The more that you can use the exercise to develop personal implications for your growth as a potential business person as well as a moral individual, the more value you'll get out of the exercise.
SLP Assignment Expectations
Length: Follow the number of pages required in the assignment excluding cover page and references. Each page should have about 300 words.
Your assignment will be graded according to the MSITM SLP Grading Rubric. (To see the rubric, go to Assessments>Rubrics. Click the arrow next to the rubric name and choose Preview.)
References and cite is a must all references must be cited in paper