Sybase: Using SQL Server
Product Code: SYBC02 Time: 5 Hour(s) CEUs: .50

Summary:

This course introduces users to SQL Server and how to use it to create, manage, and access database information.

Objectives:

After completing this course, students will be able to:
  • Explain the basic features of SQL Server
  • Describe the major functions of SQL and T-SQL
  • Describe the security features and roles of SQL Server
  • Perform database queries with isql
  • Manage database tables
  • Update and maintain databases

Outline:

  • SQL Server Overview
  • SQL Server Functions
  • SQL Server Features
  • T-SQL and Database Integrity
  • Triggers, Partitions, and Security
  • Using isql and Performing Queries
  • Viewing, Managing, and Creating Tables
  • Maintaining Databases

Features:

  • Exercises that allow users to practice the application
  • A file containing the text of the exercises
  • Simulations that allow users to practice course skills, even if they don't have access to the application
  • A glossary
  • A Skill Assessment

Applicability:

This course is for database administrators who want to learn about using and managing Sybase System 11.

Prerequisites:

Sybase: Introduction to Sybase

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

  • Sybase is a trademark of Sybase, Inc.

Terms of Use:

None

Copyright © 2004 eLearningDepot.com. All rights reserved.