03-11-2012, 06:12 PM
Programming a Microsoft SQL Server 2000 Database
Programming a Microsoft.ppt (Size: 1.35 MB / Downloads: 33)
Overview of Programming.ppt (Size: 919 KB / Downloads: 23)
Databases.ppt (Size: 928 KB / Downloads: 26)
Data Types.ppt (Size: 858.5 KB / Downloads: 26)
Data Integrity.ppt (Size: 870.5 KB / Downloads: 27)
Data.ppt (Size: 970.5 KB / Downloads: 20)
Implementing.ppt (Size: 906.5 KB / Downloads: 21)
SQL Server Overview
SQL Server Integration
Integrating SQL Server with Operating Systems
Integrating SQL Server with Windows 2000
Integrating SQL Server with Other Microsoft Server Applications
Integrating SQL Server with Windows 2000
Active Directory
Security
Multiprocessor Support
Microsoft Event Viewer
Windows 2000 Component Services
Windows 2000 System Monitor
Microsoft Internet Information Services
Windows Clustering
SQL Server Databases
Types of Databases
Database Objects
Referring to SQL Server Objects
System Tables
Metadata Retrieval
Referring to SQL Server Objects
Fully Qualified Names
server.database.owner.object
Partially Specified Names
Server defaults to the current instance on the local server
Database defaults to current database
Owner defaults to the user name in the database
System Tables
System Tables Store Information (Metadata) About the System and Database Objects
Database Catalog Stores Metadata About a Specific Database
System Catalog Stores Metadata About the Entire System and All Other Databases
SQL Server Security
Login Authentication
Database User Accounts and Roles
Types of Roles
Permission Validation
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
Working with SQL Server
Administering a SQL Server Database
Implementing a SQL Server Database
Selecting an Application Architecture for SQL Server
Designing Applications Using Database APIs
Administering a SQL Server Database
Common Administrative Tasks
SQL Server Enterprise Manager
SQL Server Administration Tools and Wizards
SQL Server Command Prompt Management Tools
SQL Server Help and SQL Server Books Online