You use SOL Server to manage two types of databases-online transaction processing (OLTP) databases, and online analytical processing (OLA.P) databases. Typically, separate clients access the databases by comm~nicating over a network.

You can scale SOL Server up to terabyte-size databases and down to small business servers and portable computers. You can scale SOL Server out to multiple servers by using Windows Clustering in Windows 2000.

Introduction to SQL Server

You can use SOL Server to perform transaction processing, store and analyze data, and build new applications. SOL Server is a family of products and technologies that meets the data storage requirements of OLTP and OLAP environments. SOL Server is a relational database management system (RDBMS) that:

Name: SQL Server.jpg Views: 33 Size: 30.9 KB

Manages data storage for transactions and analysis.

Responds to requests from client applications.

Uses 'Transact-SOL, Extensible Markup Language (XML), multidimensional expressions (MDX), or SOL Distributed Management Objects (SOL-DMO) to send requests between a client and SOL Server.

This course focuses on activities associated with OLTP databases and Transact-SOL.