The instructor was very knowlegeable and very effective in communicating that knowledge. The class was well-paced... More Testimonials »

Sybase eLearning Course

  1. Overview
  2.  | 
  3. Catalog
  4.  | 
  5. Packages
  6.  | 
  7. Benefits
  8.  | 
  9. FAQs
  10.  | 
  11. Try Free
  12.  | 
  13. Cancellation
  14.  | 
  15. Login
  16.  | 
  17. Support
Click here for Microsoft Official Curriculum eLearning courses

Sybase eLearning Course Series (23 hours)

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.

Self-Paced Sybase eLearning Course Benefits

Only $42.95

12-month subscription!

Register Now

  • Learn Sybase online with these interactive online Sybase courses.
  • Affordable Pricing (Only $42.95 for the complete series)
  • A full year to complete the Sybase courses
  • Retake the Sybase courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test

1. Sybase:1 Introduction to Sybase (Time: 3 hours)

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

Course Objectives

  • Compare characteristics of host and client/server systems
  • Identify features and advantages of the Sybase client/server system architecture
  • Explain the function of key Sybase components, tools, and utilities
  • Describe how Sybase System 11 accommodates non-Sybase applications

Course Topics

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

2. Sybase:2 Using SQL Server (Time: 5 hours)

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

Course Objectives

  • 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

Course 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

3. Sybase:3 System Administration (Time: 4 hours)

This eLearning course provides an overview of the tasks and commands of a system administrator.

Course Objectives

  • Explain the role of a system administrator
  • Use system procedures for database administration
  • Manage databases
  • Manage segments

Course Topics

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

4. Sybase:4 User Administration (Time: 2 hours)

This eLearning course shows users how to manage user accounts and groups in Sybase.

Course Objectives

  • Create and manage user accounts
  • Control user access and aliases
  • Create and manage groups
  • Create and manage roles
  • Grant and revoke permissions

Course Topics

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

5. Sybase:5 Programming with T-SQL (Time: 3 hours)

This eLearning course introduces users to basic T-SQL commands and functions through the isql interface.

Course Objectives

  • Identify the basic features of T-SQL and isql
  • Create, alter, and drop tables
  • Specify integrity constraints to protect databases
  • Create integrity rules and defaults
  • Create and manage views
  • Create and manage indexes

Course Topics

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

6. Sybase:6 Querying Databases with T-SQL (Time: 3 hours)

This eLearning course shows users how to create database queries and to manipulate the data received through queries.

Course Objectives

  • Create queries
  • Use functions in queries
  • Modify query results
  • Order and group query results
  • Use queries through views
  • Combine query results

Course Topics

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

7. Sybase:7 T-SQL Commands (Time: 3 hours)

This eLearning course explains how to join queries, create subqueries, and how to insert and modify data in Sybase.

Course Objectives

  • Create join queries
  • Use subqueries
  • Insert data in databases
  • Modify and delete data

Course Topics

  • Join Queries
  • Subqueries
  • Other Subquery Types
  • Inserting Data
  • Deleting and Modifying Data
Quick Links
  1. Watch Presentation
  2. Free Demo
  3. Purchase Vouchers
  4. Partners
  5. Remote Courses
  6. Contact Us
  7. Sitemap
  8. Privacy Policy
Courseware
  1. Purchase Courseware
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
  1. Where We've Trained
  2. We have trainers all over North America.
Training Options
  1. Live eLearning Public Classes
  2. Private Training
  3. Self-Paced eLearning
Microsoft Partner
  1. Microsoft Certifications
  2. Certified Microsoft Courses
  3. Software Assurance Training Vouchers
Watch 3-minute Demo Video
of Live Online Training: Learn the benefits of online training with Webucator

Free Webinars

A Crash Course in CSS

Wed, 3/21 1:00 PM EST

Compare Webucator to leading Competitors
Microsoft Certified Learning Solutions

» Microsoft Certifications

» Certified Microsoft Courses

» Software Assurance Training Vouchers

Project Management Institute Partner

Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.

© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723