1 / 17

1. SQL SERVER OVERVIEW

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.

reeves
Download Presentation

1. SQL SERVER OVERVIEW

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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 Client SQL Server Results OLTP Query OLAP Client Application Relational Database Management System

  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. 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

  10. SQL Server Security • Login Authentication • Database User Accounts and Roles • Types of Roles • Permission Validation

  11. 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

  12. 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

  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. 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

  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

More Related