Page 16 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes SQL Server Authentication is provided for backward compatibility. For example, if you create a
single Windows 2000 group and add all necessary users to that group you will need to grant the
Windows 2000 group login rights to SQL Server and access to any necessary databases.

Notes You will study in detail about windows and SQL server authentication later in unit 6.

1.8 Summary

SQL is a tool for organizing, managing, and retrieving data stored by a computer database.
The acronym SQL is an abbreviation for Structured Query Language. SQL is thus a
comprehensive language for controlling and interacting with a database management
system.
Microsoft makes SQL Server available in multiple editions, with different feature sets and
targeting different users.

Microsoft SQL Server is a Structured Query Language (SQL) based, client/server relational
database.

A database typically has two components: the files holding the physical database and the
database management system (DBMS) software that applications use to access data.
There are several different languages that can be used with relational databases; the most
common is SQL. Standards for SQL have been defined by both the American National
Standards Institute (ANSI) and the International Standards Organization (ISO).
Microsoft SQL Server can operate in one of two security (authentication) modes: windows
authentication mode and Mixed mode.

1.9 Keywords

Database: A collection of information, tables, and other objects organized and presented to
serve a specific purpose, such as searching, sorting, and recombining data. Databases are stored
in files.
Microsoft SQL Server: Microsoft SQL Server is a Structured Query Language (SQL) based, client/
server relational database.
Relational Database: Relational database systems are an application of mathematical set theory
to the problem of effectively organizing data. In a relational database, data is collected into
tables.
SQL: It is a tool for organizing, managing, and retrieving data stored by a computer database.

1.10 Review Questions

1. Define SQL Server. Also explain its functions.
2. Discuss the various mainstream editions of SQL server.
3. Briefly describe the specialized editions of SQL server.
4. Describe SQL server architecture briefly.

5. Discuss the two security modes in SQL server.

10 LOVELY PROFESSIONAL UNIVERSITY