This course shows you how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL (T-SQL), the programming language of SQL Server. You'll also learn how to take advantage of SQL Server's tools for maintaining, securing, and tuning your databases.
SQL Training Audience:
Developers who need to build database solutions with SQL Server
SQL Training Prerequisites
Introduction to Microsoft SQL Server 2000 – Level 1.
SQL Training Course duration
3 days
SQL Training Course outline
Using the Query Analyzer
- Query Analyzer Features
- The File Menu Items
- The Edit Menu
- Query Menu Items
- Tools Menu Items
- Window Menu Items
- Help Menu Items
Programming with Transact-SQL
- Overview of Transact-SQL
- Using Built-In Functions
- Control of Flow
- Error Handling
Transaction Processing
- Transactions
- Working with Locks
- Monitoring Processes and Locks
- Transaction Isolation
- Blocking and Deadlocks
Creating Views
- What is a View?
- Creating Views
- Updating Views
Backups and Maintenance
- Creating a Backup Strategy
- Implementing Backups
- Restoring from a Backup
- The Database Maintenance Plan Wizard
Stored Procedures and Triggers
- Building Stored Procedures
- Building Triggers
- Using INSTEAD OF Triggers
User-Defined Functions
- User-Defined Functions in SQL Server 2000
- Scalar Functions
- Inline Table-Valued Functions
- Multi-Statement Table-Valued Functions
- Functions, Views, and Stored Procedures
Advanced Queries and Linked Servers
- Dynamic SQL
- Transact-SQL Cursors
- Handling Large Data Sets
- Distributed Queries
Security
- Security Overview
- Authentication
- Understanding Roles
- Assigning Permissions
- Application Roles
Monitoring, Tuning and Configuration
- Evaluating Performance
- Monitoring with SQL Server Profiler
- Tuning Queries
- Working with Indexes
- Indexed Views
- Using the Index Tuning Wizard
- Data Caching
- The System Monitor
