Page 7 - DCAP508_DATABASE_ADMINISTRATION

Sartaj Singh, Lovely Professional University
Unit 1: SQL Server RDBMS

Unit 1: SQL Server RDBMS Notes

CONTENTS
Objectives
Introduction
1.1 What is SQL?
1.2 What is SQL SERVER?
1.3 Different Editions of SQL Server
1.4 Architecture and Database Objects

1.4.1 Database
1.4.2 Relational Database
1.4.3 Client/Server
1.4.4 Structured Query Language (SQL)
1.5 SQL Server Databases
1.6 Database Storage
1.7 Security: Windows and SQL Server Authentication
1.8 Summary
1.9 Keywords
1.10 Review Questions
1.11 Further Readings

Objectives

After studying this unit, you will be able to:
Understand the concept of SQL and SQL Server
Know about different editions of SQL Server
Describe the basic architecture of SQL server
Learn about the security features of SQL Server
Introduction

The SQL language and relational database systems based on it are one of the most important
foundation technologies in the computer industry. Over the last two decades, SQL has grown
from its first commercial use into a computer product and services market segment worth tens
of billions of dollars per year, and SQL stands today as the standard computer database language.
Literally hundreds of database products now support SQL, running on computer systems from
mainframes to personal computers and even handheld devices. Virtually every major enterprise
software product relies on SQL for its data management, and SQL is at the core of the database
products from Microsoft, Oracle, and IBM, the three largest software companies in the world.
SQL is also at the heart of open-source database products that are helping to fuel the popularity
of Linux and the open-source movement. From its obscure beginnings as an IBM research
project, SQL has leaped to prominence as both an important computer technology and a powerful
market force.

LOVELY PROFESSIONAL UNIVERSITY 1