Introduction to SQL Server 2000

Document Sample
Introduction to SQL Server 2000 Powered By Docstoc
					Introduction to SQL Server 2000 & Relational Databases
Palak Patel

What is SQL Server 2000?
SQL Server is a client/server based relational database management system  Runs on Windows 2000 Professional, Server, Advanced Server, NT 4, Windows 9x/ME or Windows CE  Included in BackOffice product family  Include in .Net Servers family


Client/Server
Server Side  Database Engine  Security  Fault-tolerance  Performance  Concurrency  Reliable backup Client Side  User Interface  Forms  Reports  Queries

Desktop Databases
1 4
Query is run Workstation User Runs the Query

2 3

Requests database from Server

Database

Entire Database is copied to the workstation

Server

5

Results are presented to the user

Client/Server Database
1
User Runs the Query Query is sent to the server

2 4

Database

3
Workstation Results are sent back to the Workstation Server Query is run on the server

5

Results are presented to the user

Types of Databases
Relational  Flat-File  Hierarchical  Relational Vs. Flat-file


Database Objects
COLUMN COLUMN ROW DEFAULT CA ALL CAPS

TABLE

• • • • • • • • • •

Calculate Salary

RULE

STORED PROCEDURE

VIEW

Table Row Column Data Type Stored Procedure Trigger Rule Default View Index

Data-Warehousing Vs. Transaction Processing
Data-Warehousing  Decision Support Systems (DSS)  Online Analytical Processing (OLAP)  Relatively fixed data  Long running queries Online Transaction Processing (OLTP)  Continuously changing data  Updates relatively small transactions

SQL Server works well with either applications

Background on SQL Server & SQL
History  Position in the Market  History of SQL – IBM 1970  SQL and SEQUEL  ANSI-SQL, T-SQL / PL-SQL SQL Language  DDL Data Definition Language  DML Data Manipulation Language Brief History of Windows and Versions of Windows 2000


Versions of SQL Server 2000


SQL Server CE
 

Runs on Windows CE Replicate data from Standard and Enterprise Edition Runs on Windows 9x/ME/2000 Pro No license required if you have Standard or Enterprise Edition Designed for Developers to be used on Single Machine Runs on Windows NT/2000 Comes with most of the features for workgroups and departments Lacks dome enterprise level features Runs on Windows NT/2000 Server



Personal
 



Developer
 



Standard
  



Enterprise:


All features including clustering support, log shipping, parallel computing support, enhanced read-aheads, partitioning support, HTTP support, Very Large Database (VLDB) Support  Runs on Windows NT/2000 Server

SQL Server 2000 Clients


Directly Supported:
 Windows

9x/ME  Windows 2000  Windows NT
 

Does not ship with 16-bit drivers, however you can use drivers from old version of SQL Server When correctly configured with Web Server, any client can access it

Differences on Windows 9x
Windows 9x
SQL Engine Integrated Security Automated Alerts Maximum Users (Recommended) Performance Monitor Runs as an application No No Five No

Windows 2000 AS
Runs as a Service Yes Yes Unlimited (Limited by Hardware resources) Yes

Tasks of SQL Sever Developer
        

Analyze the business situation and design a solution Design database and objects Design security of SQL Server databases Design data replication scenarios Programming using T-SQL Design user interface, queries, reports Testing Populating Hand the project documentation over to administrator

Tasks of a SQL Server DBA
 


  


  

Install and configure SQL Server Plan and create databases Backup the databases Restore databases when required Setup and manage users for SQL Servers Manage Security for SQL Server users Setup / Manage task, alerts, operators Setup / Manage replication environment Performance Tune SQL Server Troubleshoot SQL Server related problems