This course is designed for developers and administrators who need product-specific knowledge of designing and implementing databases using Microsoft's SQL Server. It will teach the fundamentals of programming in Transact-SQL and basic database administration options, as well as providing special tips needed to implement efficient databases.
Prerequisites: Previous experience with another programming language or basics of SQL. Experience with Windows 2000/XP operating environment.
Who Should Attend: This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing in Transcript-SQL
Duration: 3 days
Price: $1125
Overview of SQL-Server
- Architecture
- Design and Development
- Management of Tables
- Advanced Features
|
Designing with SQL-Server
- Space Optimization
- Database Creation
- Database Management
- Table Management
- Data Integrity
- Index for Efficiency
|
Designing and Managing Databases
- Space and Optimization
- Multiple Data Files and Filegroups
- Admin Tools
- Transaction Logs
|
Components of SQL-Server
- Services
- Using Enterprise Manager
- Using Query Analyzer
- Administrative Utilities
|
Transact-SQL Statements
- DDL and DML
- Using SELECT
- WHERE Clauses
- Using UPDATE
- Using DELETE
|
Data Integrity and Joins
- Constraints
- Index and Performance
- Outer Joins
- Advanced Joins
- Using Subqueries
|
Database Structures
- Default Databases
- System Tables
- Database Creation
- Diagram Creation
- Indexes and Options
|
Transact-SQL
- Using Command Line Tools
- Data Control
- Control of Flow
- Scripting
- Programming in Transact-SQL
|
Advanced Implementation Features
- Stored Procedures
- Parameter Usage
- Managing
- Aggregate Functions
- Trigger Design
- Managing Triggers
|
Register Now
This page is printer friendly.
