Introduction to Microsoft SQL Server - ISM 4212 Database Administration

Introduction to
Microsoft SQL Server
Fundamental Concepts and Terminology

, Database Objects
A database contains many different types of
objects. Some of the SQL Server database
objects that we will explore include:
 The Database
 The Transaction Log
 Tables
• Indexes
• Constraints
 Database Diagrams
 Views
 Reports
2

, The Database Object
 The database is the highest-level object to which
you will typically refer.
 A database includes at least a set of tables, and
usually other objects such as views.
 SQL Server allows one physical server to support
more than one user database.
 In addition to any user-defined databases, an
installation of SQL Server includes four system
databases (see next four slides).

3