Chapter Summary

This chapter was aimed at giving you an introduction to SQL Server. The tools and programs talked about in this chapter span the rest of this book and are examined at much greater depth. Use this chapter as a springboard to all the topics that you need to understand to be properly prepared for the 70-229 exam. This chapter has only outlined the basics of what is a large and diverse area of expertise.

KEY TERMS

• ADO

• Analysis Server

• BCP

• Books Online

• Cascading Referential Integrity

• Client Network utility

• collation

• constraints

• Data warehouse

• DELETE

• English Query

• Federated Database Server

• HTML

• IIS

• index

• INSERT

• Internet host name

• OSQL

• Master database

• Microsoft Management Console (MMC)

• Model database

• MSDB database

• NetBIOS computer name

• ODBC

• OLE-DB

• online analytical processing (OLAP)

• online transaction processing (OLTP)

• partitioned views

• Profiler

• Query Analyzer

• relational database

• replication

• roles

• SELECT

• server network

• utility

• Service Manager

• stored procedures

• Structured Query Language (SQL)

• table

• TCP/IP

• tempdb

• Transact -SQL

• trigger

• UPDATE

• user -defined functions

• view

• XML