SQL Server 2000 Programming and Maintaining Databases Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	RT 126
Course Abstract:	This course assumes that participants already know how to create a well-designed database and how to write simple SQL queries for retrieving and manipulating data. The course shows participants how to build effective views, stored procedures, triggers, and user-defined functions, using Transact-SQL (T-SQL), the programming language of SQL Server. Participants also learn how to take advantage of SQL Server's tools for maintaining, securing, and tuning your databases.
Audience:	This course is designed for developers.
Duration:	3 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: > Use the programming environment in the Query Analyzer and learn the Transact-SQL language > Recognize the differences between views, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each > Use transaction processing and error handling in Transact-SQL to ensure the integrity of your data > Link to and work with diverse data formats stored outside of SQL Server > Design and implement reliable backup and maintenance plans > Identify the SQL Server security model; and create logins, users and permissions to protect your data > Configure and tune SQL Server, and monitor database activity
Course Topics:	Using the Query Analyzer Query Analyzer Features The File Menu The Edit Menu Query Menu Tools Menu Window Menu Help Menu Programming With Transact-SQL Overview of Transact-SQL Using Built-in Functions Control of Flow Error Handling Transaction Processing Defining Transactions Working with Locks Monitoring Processes and Locks Transaction Isolation Blocking and Deadlocks Creating Views Definition of a View Building Views Indexed Views Updating Views Partitioned Views Backups and Maintenance Backup and Restore Creating a Backup Strategy Implementing Backups Restoring from a Backup Database Maintenance Plan Wizard Stored Procedures and Triggers Building Stored Procedures Building Triggers Using INSTEAD OF Triggers User-Defined Functions Scalar functions Inline Table-Valued Functions Multistatement Table-Valued Functions The TABLE Data Type Functions, Views and Stored Procedures Advanced Queries and Linked Servers Handling Large Data Sets Setting Up a Linked Server Transact-SQL Functions for Distributed Queries Distributed Partitioned Views Security Security Overview Authentication Understanding Roles Assigning Permissions Application Roles Monitoring, Tuning and Configuration Factors for a Well-Tuned Application Optimize Indexes The Index Tuning Wizard Understanding Caching Using the Performance Monitor Using Profiler
Prerequisites:	SQL Server 2000 Introduction (RT 125)

SQL Server 2000 Programming and Maintaining Databases Course

Hot Courses

Top Skills

Testimonials

Agile
AJAX and Web 2.0
Business Analysis
Business Practices
Cisco
Communications
Customer Service/Communications
Data Warehousing
Database Developer
End User
Enterprise Architecture
Internet Application Developer
Lotus
Mainframe
Messaging Infrastructure
Networking
Operating Systems
Programming Languages
Programming Methodologies
Project Management
Project Management
Quality Assurance
Relational Databases
Reporting Tools
SAP
Scrum Master
Security
Server Applications
SQL & PL/SQL Programming
Testing
Testing and Quality Assurance
Virtualization
Web Technologies
Wireless Technology