A Tutorial on SQL Server 2005 CMPT 354 Fall 2007 .Road Map Create Database Objects Create a database Create a table Set a constraint Create a view Create a user Query Manage the Data Import data Export data Backup the database Restore the database 2 .Client-Server Architecture User runs a query 1 Query is sent to the server 2 3 4 Workstation 5 Results sent back to workstations Database Query is run Server on server Results are given to user 3 .Versions of SQL Server 2005 • • • Enterprise (only support Windows Server OS) – Includes all of the features of SQL Server 2005 and meets the high demands of enterprise online transaction processing and data warehousing applications Standard (mostly.
