|
Appextech Introduction to SQL Server 2005 training teaches attendees the skills they need to successfully build, administer, and query Microsoft SQL Server 2005 databases.
Microsoft SQL Server 2005 Training Objectives
All attendees will learn to :-
- Use the programming environment in the Query Analyzer and learn the Transact-SQL language
- Understand the differences between view, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each
- Design and implement reliable backup and maintenance plans
- Understand the SQL Server 2005 security model; and create logins, users and permissions to protect your data
- Utilize the fundamentals of Reporting Services, Notification Services, and the Service Broker.
- Configure and tune SQL Server 2005, and monitor database activity
Microsoft SQL Server 2005 Training Outline
1. Introducing SQL Server
- Major features
- Limits
- Editions
- Installing SQL Server
2. Basics of Database Design
- Normalization
- Denormalization
- Tools for Normalization in SQL Server
3. Building a Database
- Introducing SQL Server Management Studio
- Databases
- Tables
- Indexes
- Relations
- Using T-SQL to build and alter objects
4. T-SQL Basics
- What is SQL?
- Reading syntax diagrams
- Identifiers
- Datatypes
- Operators
- Wild cards
- Variables
- Functions
- Using sqlcmd
5. SELECT Queries
- The SELECT clause
- The FROM clause
- The WHERE clause
- Using Joins
- ORDER BY
- GROUP BY and HAVING
- TOP N and TOP N%
- OVER
- Full-text search
6. Action Queries
- DELETE
- TRUNCATE TABLE
- UPDATE
- INSERT
- SELECT INTO
7. Locking and ShowPlan
- What is Locking?
- Monitoring and tuning Locking
- Deadlocks
- Application Locks
- Tuning Queries with ShowPlan
8. Views, Stored Procedures, and Functions
- Partitioning and Joining Tables with Views
- Updateable views
- Indexed Views
- Information Schema Views
- Catalog Views
- Stored Procedures
- Functions
9. Advanced Transact-SQL
- Transactions
- Distributed Transactions
- Rowset Functions
- Ranking Functions
- Cursors
- Structured Error Handling
10. XML and SQL Server
- Using FOR XML
- Using XQuery
- HTTP SOAP access to data
11. Triggers
- INSERT triggers
- DELETE triggers
- UPDATE triggers
- INSTEAD OF triggers
- Recursive triggers
- DDL triggers
12. Replication
- Replication Models
- Setting up Replication
- Snapshot publishing
- Transaction publishing
- Merge publications
- Monitoring replication
- Heterogeneous replication
13. .NET inside of SQL Server
- Understanding .NET and the CLR
- Using CLR objects in SQL Server
- Using the Sql namespace
14. SMO and RMO Programming
- What is SMO?
- The SMO Object Model
- Sample SMO tasks
- Sample RMO tasks
15. Analysis Services
- Understanding Analysis Services
- Introducing BIDS
- Creating a Data Cube
- Exploring a Data Cube
16. SQL Server Integration Services
- SSIS Architecture
- SSIS Tasks
- SSIS in action
17 .Notification Services
- The Notification Services Architecture
- Using Notification Services
18. Reporting Services
- The Reporting Services Architecture
- Building Reports
- Managing Reporting Services
19. Service Broker
- The Service Broker Architecture
- Using Service Broker
20. Security and SQL Server
- Security modes and authentication
- Fixed server roles
- Database user accounts
- Permissions
- Database roles
- Ownership chains
| 