Sybase online training courses
Total Courses: 7    Estimated Training Time: 23 Hour(s)

Summary

1 Year Unlimited access to all 7 courses listed below, includes over 23 hours of online courseware.

This series is designed to introduce database administrators to using and managing Sybase System 11. It covers an overview of Sybase SQL Server, the client/server system model, and the tools and components of Sybase System 11. It discusses using SQL Server to create, manage, and access database information, and the tasks and commands of a system administrator. Additional topics covered in this series include management of user accounts and groups, granting and revoking permissions, basic T-SQL programming commands and functions, and using T-SQL commands to create database queries, manipulate data, join queries, create subqueries, and insert and modify data.

Current Price: $59.95 | List Price: $119.99

This Sybase online training series provides 23 hours of self-paced courseware. This web-based training provides 1 year of unlimited access to all of the following lessons:

  1. Introduction to Sybase
  2. Using SQL Server
  3. System Administration
  4. User Administration
  5. Programming with T-SQL
  6. Querying Databases with T-SQL
  7. T-SQL Commands

Lesson Detail:

  • Sybase: Introduction to Sybase
    This course provides an overview to Sybase SQL Server, the client/server system model, and the tools and components of Sybase System 11.

    • Host versus Client/Server Systems
    • Sybase Introduction
    • SQL Server, Data Replication, and Open Architecture
    • System Management Tools and Servers

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

    • 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

  • Sybase: System Administration
    This course provides an overview of the tasks and commands of a system administrator.

    • The Role of a System Administrator
    • Using System Procedures
    • Creating and Dropping Database Devices
    • Creating and Altering Databases
    • Managing Segments

  • Sybase: User Administration
    This course shows users how to manage user accounts and groups in Sybase.

    • Managing Server Logins
    • Managing User Access and Aliases
    • Managing Groups
    • Assigning and Managing Roles
    • Granting Permissions
    • Revoking and Modifying Permissions

  • Sybase: Programming with T-SQL
    This course introduces users to basic T-SQL commands and functions through the isql interface.

    • Using T-SQL and isql
    • Managing Tables
    • Defining Integrity Constraints
    • Creating Integrity Defaults and Rules
    • Using Views
    • Managing Indexes

  • Sybase: Querying Databases with T-SQL
    This course shows users how to create database queries and to manipulate the data received through queries.

    • Introduction to Queries
    • Using Functions in Queries
    • Manipulating Query Data
    • Ordering and Grouping Query Results
    • Combining Queries and View Queries

  • Sybase: T-SQL Commands
    This course explains how to join queries, create subqueries, and how to insert and modify data in Sybase.

    • Join Queries
    • Subqueries
    • Other Subquery Types
    • Inserting Data
    • Deleting and Modifying Data

Certification

Sybase

Audience

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

Features

  • Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
  • Exercises allow learners to practice in the actual application being studied.
  • A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
  • Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
  • Search text enables learners to rapidly search all text within a course to easily retrieve information required.
  • Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
  • A skill assessment generates a customized learning path based on the results of a pre-test.
  • A glossary provides a reference for definitions of unfamiliar terms.
  • Bookmarking tracks the learner's progress in a course.
  • Exercises allow learners to practice in the actual application being studied.
  • A file containing the text of the exercises.
  • A glossary provides a reference for definitions of unfamiliar terms.
  • Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
  • A skill assessment generates a customized learning path based on the results of a pre-test.

Technical Requirements

  • Internet connection
  • Browser: Internet Explorer, FireFox, Chrome, Safari, Opera or any standards compliant browser.
  • Authorware and Macromedia Flash player recommended but not required.
  • JavaScript must be enabled.

What You Get

You will receive Unlimited Access to all of the Sybase training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 1 year unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.

StaffKit is an e-learning leader in providing computer training tutorials and online education. We have satisifed online learning customers in over 50 countries. We have been providing web based training for the past 9 years.

Web-Based Training Products

You might also be interested in our Technical Package which includes all of the Sybase training courses listed above plus over 749 hours related training courses

Technical

Study the latest technical topics from CompTIA to Oracle to Novell. Gain training on the latest programming languages and other technical computing subjects. Even prepare for various technical certification exams!

87 Series

Price: $129.95