| 
View
 

Lecture - Getting Started with SQL Server Management Studio

Page history last edited by Dr. Ron Eaglin 12 years, 1 month ago

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.