Sybase Series: Using SQL Server
Product Code: SYBC02 Time: 5.0 hour(s) CEUs: Available

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

Topics:

  • 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

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 98, NT, 2000, or XP. Internet Explorer 5.0 or higher required. (5.5 or higher for MindLeaders Central) Minimum Connection Speed: 28.8k. Sound card, with speaker or headphones is recommended, but not required to play the courses. Macromedia Flash Player 7.0 (Note: We do not recommend or support installation of the Yahoo toolbar.) JavaScript must be enabled. Netscape and AOL browsers not supported.


Copyright © 2005 MindLeaders. All rights reserved.