SQLServer Tutorial

2 Data Storage Models OLTP Databases Data in an OLTP database is generally organized into relational tables to reduce redundant information and to increase the speed of updates. OLAP Databases OLAP technology organizes and summarizes large amounts of data so that an analyst can evaluate data quickly and in real time. Client Applications Transact-SQL the primary database query and programming language that SQL Server uses. XML This format returns data from queries and stored procedures by using URLs or templates over Hypertext Transfer Protocol (HTTP). You also can use XML to insert, delete, and update values in a database.