Microsoft SQL Server 2000 Database Development
Price: $2495
Duration: 5 days | Microsoft SQL Server 2000 Database Development Course Schedule
Prerequisites: Familiarity with Windows desktop navigation and software installation procedures.
Description: Five days of intensive hands on training, this class will allow the student to understand relational database concepts and the Structured Query Language (Transact-SQL) in the Microsoft SQL Server environment as well as identify and configure all major aspects of a Microsoft SQL Server RDBMS. You will learn about tables and constraints; DTS packages and transformations; transact SQL queries; creating views; creating and tuning indexes; building transactions & triggers and creating stored procedures; relational database concepts; SQL vocabulary; a terminology guide; key features of SQL Server; a comprehensive guide to the SQL Server tools, including Enterprise Manager and Query Analyzer; and database implementation basics. The course also shows how to install and configure SQL Server, create and manage databases and database devices, backup and restore SQL Server databases, import and export data, implement automated tasks and optimize SQL server.
This course is intended for administrators new to database management and development, and includes all of the material in the SQL Programming and Relational Database Design courses. You should not register for either of those courses if you will be attending this course.
SQL Server Overview
- Client/Server Architecture
- A Brief History
- Review of New features
- Transact-SQL
- Users and Security
- Servers and Databases
- Networked Architecture
- SQL Server Installation
- Upgrading and Backwards Compatibility
- The RDBMS
- Structured Query Language - SQL
- Stored Queries
- Indexes
- Transactions and Log Files
- Client-Server and Middleware Architectures
- Replication
- Organizing Data
- Post-Installation Databases
- Database Files
- Planning a Database
- Creating Databases
- The Primary Filegroup
- Database Options
- Managing Databases
- Designing Tables with the Database Diagram
- Calculated Columns
- Constraints
- User-Defined Data Types
- Legacy Rules and Defaults
- Uses of Views
- Limitations of Views
- Calculated Columns
- Creating Views
- How Data is Changed in SQL Server 2000
- Inserting and Copying Records
- Changing Records
- Removing Records
- Transaction Processing Commands
- Locking Issues
- SQL Server 2000 Query Caching & Related Features
- Uses for Stored Procedures
- Creating Stored Procedures
- Passing Parameters
- Returning Values and Updating Parameters
- Compilation Problems And Methods
- Temporary Procedures and AutoStart Procedures
- Action Queries
- The INSERT Statement
- The DELETE Statement
- The UPDATE Statement
- Using Views
- Web Publishing from SQL Server
- Application Development Environment
- Planning Backups
- Backup Mechanisms
- Performing a Backup
- Backup Types
- Recovery Models
- Automating Backups
- Backup Strategies
- Standby Servers
- Pre-Installation Check-List
- Installing SQL Server
- Installed Components
- Compatibility Issues
- Upgrading to SQL Server 2000
- Failover Clustering
- SQL Server Enterprise Manager
- DTS - Data Transformation Services
- XML Support with Microsoft IIS
- Linking Servers
- Summary of Data Transfer Methods
- Modifying Packages with DTS Designer
- DTS Transformations
- Replication Overview
- Replication Topologies
- Microsoft SQL Server Replication
- Replication and Publishing
- Replication Mechanisms
- Monitoring and Troubleshooting
- Configuring Replication
What Is A Relational Database?
- What is a Database?
- Logical and Physical Design
- The Relational Database
- Primary Keys and Foreign Keys
- Relationships
- Design Normalization
- How is Data organized in SQL Server and NT/2000 ?
- Creating a Database
- Standard Data Types
- Tables and Columns in Enterprise Manager
- Tables and Columns in T-SQL
- Modifying Tables and Columns
- Computed Columns
- Database Diagrams Architecture
- Planning Fault Tolerance
- Using File Groups
- Shrinking Databases
- SQL Server Security
- Login Accounts
- Statement and Object Permissions
- Application Security
- Auditing
- Security Checklists
- Fixed Server Roles
- User-Defined Roles
- Database Permissions
- Application Roles
- Querying SQL Server 2000 Tables
- SQL and Transact SQL
- Using the SELECT Statement
- Transact SQL Built-In Functions
- Summary Queries
- Sub-Queries
- Overview of Indexes
- Clustered versus Non-Clustered Indexes
- Creating Indexes
- Using SHOWPLAN to See if the Index is Being Used
- Using Composite Indexes to Cover Queries
- Duplicate Keys and Rows and How to Solve Problems
- The Distribution Page and UPDATE STATISTICS
- The Index Tuning Wizard
- Index Maintenance Plans
- Transact SQL Batch and Script Rules
- Variables
- Flow Control Statements
- The EXEC( ) function
- Error Handling
- Cursors
- Basic Trigger Assumptions and Syntax
- Improving Trigger Performance
- Checking the Number of Rows Affected
- Nested Triggers
- Types of Data Integrity
- Constraints
- Ensuring Integrity with Triggers
- The SELECT Statement
- Manipulating Data
- Selecting Rows
- Sorting Data
- Aggregate Functions
- Joins - Querying Multiple Tables
- Auto Recovery
- Restoring User Databases
- Recovering System Databases
- Administration Environment
- Books Online
- System Environment Tools
- SQL Server Enterprise Manager
- Query Analyser
- Which Query Tool?
- The dtsrun Utility
- Connecting to External Data with Linked Servers
- BCP
- Using Backup & Restore to Move Data
- Automation Overview
- Setting Up SQLMail
- Setting Up Operators in SQL Server
- Jobs, Events & Alerts
- Types of Job
- Creating User-Defined Error Messages
- Setting Up Alerts
- Multi-Server Jobs
- Monitoring Log Space Usage
- Troubleshooting SQL Server
- Monitoring SQL Server
- Optimizing SQL Server
- Optimizing Hardware
- Optimizing Windows 2000
- SQL Server Configuration
- Optimal Database Design
- Client-Side Optimization
