A Tutorial on SQL Server 2005 pptx

A Tutorial on A Tutorial on

SQL Server 2005 SQL Server 2005

CMPT 354 CMPT 354

Fall 2007 Fall 2007

2

Road Map Road Map

Create Database Objects Create Database Objects

Create a

database

Create a

table

Set a

constraint

Create a

view

Create a

user

Manage the Data Manage the Data

Import

data

Export

data

Backup the

database

Restore the

database

Query

3

Client-Server Architecture Server Architecture

Database

Server Workstation

1

User runs

a query

2

Query is sent to the server

Query is run

on server

3

4

Results sent back

to workstations

Results are

given to user

5

4

Versions of SQL Server 2005 Versions of SQL Server 2005

•Enterprise (only support Windows Server OS) Enterprise (only support Windows Server OS)

–Includes all of the features of Includes all of the features of SQL Server 2005 and meets the hi SQL Server 2005 and meets the high demands of gh demands of enterprise online transaction pr enterprise online transaction processing and data warehousing ap ocessing and data warehousing applications plications

•Standard (mostly support Windows Server OS) Standard (mostly support Windows Server OS)

–Includes the essential functionality needed for e Includes the essential functionality needed for e-commerce, data warehousing, commerce, data warehousing, and line and line-of-business solutions business solutions

•Workgroup Workgroup

–

– Includes the core database featur Includes the core database features of the SQL Server product li es of the SQL Server product line, and is the ne, and is the data management solution for small data management solution for small organizations that need a dat organizations that need a database with no abase with no limits on size or number of users limits on size or number of users

•Express (free) Express (free)

–A free, easy A free, easy-to-use, lightweight, and embeddable ve use, lightweight, and embeddable version of SQL Server 2005, rsion of SQL Server 2005, includes powerful features such as SQL Server 2005 Reporting Ser includes powerful features such as SQL Server 2005 Reporting Services and vices and

SQL Server 2005 Management Studio Express ent Studio Express

•Developer (can support Windows XP OS) Developer (can support Windows XP OS)

–Includes all of the functionality of Includes all of the functionality of Enterprise Edition, but is Enterprise Edition, but is licensed only for licensed only for development, test, and demo use development, test, and demo use

•Compact Compact

–A free, easy A free, easy-to-use embedded database engine that use embedded database engine that lets developers build robust lets developers build robust Windows Desktop and mobile applicat Windows Desktop and mobile applications that run on all Windows ions that run on all Windows platforms platforms

Reference: http://technet.microsoft.com/en-us/library/ms144275.aspx