230 likes | 646 Views
1. SQL SERVER OVERVIEW. What Is SQL Server? Interfaces To Use SQL Server SQL Server Services Types Of Databases SQL Server Security. Introduction to SQL Server. Client. SQL Server. Results. OLTP. Query. OLAP. Client Application. Relational Database Management System.
E N D
1. SQL SERVER OVERVIEW • What Is SQL Server? • Interfaces To Use SQL Server • SQL Server Services • Types Of Databases • SQL Server Security
Introduction to SQL Server Client SQL Server Results OLTP Query OLAP Client Application Relational Database Management System
WHAT IS SQL SERVER? ________________________________________________________________________________________________________________________________________________________________________________________________________________
Interfaces To Use SQL Server • ENTERPRISE MANAGER • QUERY ANALYSER
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
Types of Databases System Databases master model tempdb msdb distribution pubs Northwind User1 User Databases
Applications and Components Browser Access Excel Custom client IIS DataConsumers ActiveX Data Objects (ADO) DataProviders OLE DB Data Providers (Services) Cursors QueryProcessors BusinessServices OLE DB Data Providers (Data) ODBC SQL Server Jet ActiveDirectory Exchange Excel Other OLE DBProviders Accessing Data
SQL Server Security • Login Authentication • Database User Accounts and Roles • Types of Roles • Permission Validation
AUTHENTICATION SQL ServerVerifies Trusted Connection Windows 2000 Group or User Windows 2000 SQL Server OR SQL Server Verifies Name and Password SQL ServerLogin Account Login Authentication
Database User Accounts and Roles SQL Server Verifies Trusted Connection SQL Server Assigns Logins to User Accounts and Roles Windows 2000 Group User Windows 2000 Database User SQL Server OR Database Role SQL Server Verifies Name and Password SQL Server Login Account
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
Permission Validation 2 3 1 Permissions OK; Performs Command Database UserExecutes Command SQL Server Checks Permissions SELECT * FROM Members Permissions not OK; Returns Error
Intelligent Server (2-Tier) Intelligent Client (2-Tier) N-Tier Internet Presentation Browser Client Presentation Presentation Presentation Business Business Business Business Data Data Data Data Selecting an Application Architecture for SQL Server
REVIEW • WHAT IS SQL SERVER? • INTERFACES TO USE SQL SERVER • SQL SERVER SERVICES • TYPES OF DATABASES • SQL SERVER SECURITY
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