Lecture - Getting Started with SQL Server Management Studio
Summary of Video
This is a very simple video of creating a database inside of SQL Server Management Studio. It demonstrates creating a database, creating tables using both SQL and the wizards, setting up simple relationships, and the tools available in Management Studio.
Prerequisites
This is a first lecture in COP4709, students should have had a previous course in databases (COP4708 or COP2700)
Video Link
http://online1.daytonastate.edu/player2.php?id=a92c274b8be496fb05d95033552eeddd
Support Materials
SQL Script to create tables as shown in Video
CREATE TABLE [dbo].[Artists](
[id] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
[name] [nvarchar](200) NULL)
CREATE TABLE [dbo].[Albums](
[id] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
[artistID] [int] FOREIGN KEY REFERENCES Artists(id) NULL,
[name] [nvarchar](200) NULL,
[year] [nvarchar](4) NULL)
CREATE TABLE [dbo].[Songs](
[id] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
[name] [nvarchar](200) NULL,
[albumID] [int] FOREIGN KEY REFERENCES Albums(id) NULL,
[TrackNumber] [int] NULL)
|
All Materials Copyright 2012 Dr. Ron Eaglin
Comments (0)
You don't have permission to comment on this page.