This course also includes an introduction to using SQL Server Analysis Services (SSAS) to create and manage data warehouse and implement data mining, and discusses in detail the new security concepts available in SQL Server 2005. There are several new programmability features available in SQL Server 2005 including integration of the database engine and the .NET Common Language Runtime (CLR). This course focuses on administration issues and discusses the programmability features at a high level. Students who need a more thorough introduction to the Business Intelligence suite (SSRS, SSIS, SSAS) should attend either the SQL Server 2005 Business Intelligence Application Development course or the SQL Server 2005 Business Intelligence: Integration Services and Analysis Services course.
Students who are new to database concepts and fundamental SQL programming should attend the 3-day course SQL Programming/Relational Database Design prior to this course.
An Overview of SQL Server 2005
- New Features
- SQL Server Reporting Services (SSRS)
- SQL Server Analysis Services (SSAS)
- SQL Server Integration Services (SSIS)
- Database Roles
- Client Tools
|
|
Installing SQL Server 2005
- Preparing For Installation
- User Interface Setup
- Installing Express Edition
- Configuring an New Instance
|
SQL Server Database Engine
- Managing Services
- Managing Servers
- Database Projects
- Database Objects
|
|
SQL Server 2005 Tools
- Configuration Utilities
- SQL Server Management Studio
- Using the Query Editor
- Books Online
|
SQL Server Replication
- Types of Replication
- Replication Agents
- Security and Monitoring
- Backup and Restore Considerations
- Replication Wizards and Tools
|
|
SQL Server Service Broker
- Conversations
- Message Ordering and Coordination
- Transactional Asynchronous Programming
- Loosely Coupled Applications
- Components
- Administering
|
SQL Server Maintenance
- Setting Up Database Mail
- SQL Server Agent
- Creating Operators
- Creating Jobs
- Creating Alerts
- Proxies
- Working with Tasks
|
|
Creating Databases
- Creating Databases
- Creating and Modifying Tables
- Indexes, Constraints, Scripts
- Populating Databases
|
Controlling Security
- Overview
- Catalog Views
- Security Functions
- Cryptographic Functions
- CLR Integration
- Native XML Web Services
- Integration Services
- Analysis Services
- Replication
- Reports
- Notifications
- Service Broker
|
|
International Databases
- Database Internationalization Overview
- Unicode Data
- Date and Time Issues
- Collations
- International SQL
- Integration Services
- Analysis Services
- Reports
- Notifications
- Service Broker
|
Working with XML
- XML Data Type
- Indexes
- Schema Collections
- Generating XML with the “For XML” Clause
- OpenXML
- Native XML Web Services
|
|
Assuring Data Availability
- Disaster Recovery
- Recovery Models
- High Availability Techniques
- Backup
- Restore
- RAID Arrays
- Database Mirroring
|
Monitoring and Performance
- Windows Performance Monitor
- SQL Server Profiler
- Database Engine Tuning Advisor (DTA)
- Federated Database Servers
- Partitioned Tables
- Partitioned Indexes
- Query Performance Issues
- Transactions and Locks
- Best Practices for Native XML Web Services
|
|
Programming SQL Server 2005 Scripts
- Transact-SQL Capabilities
- CLR Integration Overview
- Creating and Modifying Stored Procedures
- User-Defined Functions
- User-Defined Types
- DML Triggers
- DDL Triggers
- Integration Services
- Replication Management Objects (RMO)
- Reports
- Notifications
|
SQL Management Objects (SMO) Overview
- Table-Related SMOs
- Index and ForeignKey SMOs
- Stored Procedure and View SMOs
|
|
Full-Text Search Architecture
- Full-Text Search Capabilities
- Creating a Full-Text Catalog
- Populating Full-Text Indexes
- Performing Full-Text Searches
- FREETEXT
- FREETEXTTABLE
- CONTAINS
- CONTAINSTABLE
|
