| SQL Server Administration |
ID: DBADM3 | Course Length:5 | Company Name:Choquette Technology Associates Inc.
|
|
Module 0: Rdbms Essentials |
- About the Relational Database Management System
- SQL Server Terminology: Databases, Tables, Columns, Rows, Keys, Etc
- Application Development and SQL Server
- Oltp: The Transactional Server
- Olap: The Analysis Server
- XML Integration
- Core SQL Server Services
- Other SQL Server Services
- The Role of ADO .NET
|
|
Module 1: Installing SQL Server |
- Overview
- The Server's Hardware
- Preparing for An Installation
- Installing SQL Server
- Configuring SQL Server
- Checking the Installation
|
|
Module 2: Creating the Database |
- Planning the Installation
- SQL Server Installation
- Data Storage Architecture
- Creating Database Files
- Using File Groups
- Optimizing Data Storage
- Importing Data
|
|
Module 3: Tsql For Administrators |
- SQL Data Types
- Using Variables
- Type Conversion
- Conditional Constructs
- Looping Constructs
- Useful Functions
- Error Handling
- System Tables
- Stored Procedures and Metadata Views
|
|
Module 4: Implementing Security |
- SQL Security Overview
- Other Security Considerations
- Planning Security
- Configuring the Server
- Creating Logins
- Creating Users
- Granting Permissions: Grant, Deny and Revoke
- Using Server Roles
- Using Database Roles
- Application Roles
|
|
Module 5: SQL Server Automation |
- The Need for Automation
- Jobs
- Alerts
- Operators
- Sqlmail Integration
|
|
Module 6: Optimizing Performance |
- Index Overview
- Deadlocks and Livelocks
- Optimization Overview
- Using Query Analyzer
- Gathering Performance Data
- Optimizing for Select
- Optimizing for Insert, Update and Delete
- Query Hints
- Join Strategies
- SQL Server Transactions and Locks
|
|
Module 7: Backup and Recovery |
- Fault Tolerance Vs Backup
- Fault Tolerance: Clustering, Mirroring, Fail-over.
- Planning a Backup Strategy
- Implementing a Backup Strategy
- Automating Backups
- Recovering From Failure
- Recovering the Master Database
|
|
Module 8: Monitoring SQL Server |
- Overview of Monitoring Tools
- Planning To Monitor SQL Server
- Implementing Alerts
- Using Performance Counters
- Query Analyzer
- SQL Server Profiler
|
|
Module 9: Replication |
- Replication Architecture
- The Replication Topology
- The Publisher
- The Distributor
- The Subscriber
- Monitoring Replication
|
|
Module 10: SQL Server Enterprise Services |
- SQL Reporting Services
- Portal Server
- BizTalk Server 2004
- HTTP Integration
- Msdtc
|