| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Lecture - Getting Started with SQL Server Management Studio

Page history last edited by Dr. Ron Eaglin 11 years, 2 months 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.