1' SQL SERVER OVERVIEW

1
1. SQL SERVER OVERVIEW

• What Is SQL Server?
• Interfaces To Use SQL Server
• SQL Server Services
• Types Of Databases
• SQL Server Security

2
Introduction to SQL Server
SQL Server
Client
Results
OLTP
Query
OLAP
Relational Database Management System
Client Application
3
WHAT IS SQL SERVER?
__________________________________________________
________________________________________________
________________________________________________
________________________________________________
______________
4
Interfaces To Use SQL Server

• ENTERPRISE MANAGER
• QUERY ANALYSER

5
ENTERPRISE MANAGER
6
QUERY ANALYSER
7
SQL Server Services
MSSQLServer Service

• Data Management
• Transaction and Query Processing
• Data Integrity

SQLServerAgent Service

• Jobs
• Alerts
• Operators

Microsoft Distributed Transaction Coordinator

• Distributed Transaction Management

Server
Microsoft Search

• Full-Text Catalogs
• Full-Text Indexes

8
Types of Databases
System Databases
master
model
tempdb
msdb
distribution
pubs
Northwind
User1
User Databases
9
Accessing Data
10
SQL Server Security

• Login Authentication
• Database User Accounts and Roles
• Types of Roles
• Permission Validation

11
Login Authentication
12
Database User Accounts and Roles
SQL Server Assigns Logins to User Accounts and
Roles
SQL Server Verifies Trusted Connection
Windows 2000 Group User
Windows 2000
Database User
SQL Server
OR
Database Role
SQL Server Verifies Name and Password
SQL Server Login Account
13
Types of Roles

• Fixed Server Roles
• Group administrative privileges at the server
  level
• Fixed Database Roles
• Group administrative privileges at the database
  level
• User-defined Database Roles
• Represent work defined by a group of employees
  within an organization

14
Permission Validation
2
3

1
Permissions OK Performs Command
Database UserExecutes Command
SQL Server Checks Permissions
SELECT FROM Members
Permissions not OK Returns Error
15
Selecting an Application Architecture for SQL
Server
16
REVIEW

• WHAT IS SQL SERVER?
• INTERFACES TO USE SQL SERVER
• SQL SERVER SERVICES
• TYPES OF DATABASES
• SQL SERVER SECURITY

17
CHAPTER CONTENTS

• SQL SERVER OVERVIEW
• LANGUAGE FEATURES
• DESIGN A DATABASE
• IMPLEMENT TABLES
• ACCESS AND MODIFY DATA
• IMPLEMENT VIEWS
• IMPLEMENT FUNCTIONS
• IMPLEMENT TRIGGERS
• IMPLEMENT STORED PROCEDURES
• INDEXING TABLES
• ACCESSING LINKED SERVERS
• TRANSACTIONS AND LOCKS