1-877-WEBUCATE
(1-877-932-8228)
info@webucator.com
 

"The J2EE for Managers class enabled me to make sense of all the Java/J2EE specs I've been given by d" More quotes

Microsoft Training
Java Training
XML Training
Database & SQL Training
PHP, Perl, ASP, Groovy, Grails, Ruby on Rails Training
HTML, JavaScript, Ajax & CSS Training
Adobe CS3 Training
◊ ONLINE SYBASE TRAINING

Overview | Catalog | Benefits | FAQs | Try Free Course | Buy | Log in | Support

Online Sybase Training

Only $42.95
12-month subscription

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.

Sybase Series (23 hours)

ONLINE Sybase TRAINING FEATURES

  • 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. Introduction to Sybase

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

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

Topics

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

2. Using SQL Server

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

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

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. System Administration

Time: 4 hours
This course provides an overview of the tasks and commands of a system administrator.

Objectives

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

Topics

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

4. User Administration

Time: 2 hours
This course shows users how to manage user accounts and groups in Sybase.

Objectives

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

Topics

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

5. Programming with T-SQL

Time: 3 hours
This course introduces users to basic T-SQL commands and functions through the isql interface.

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

Topics

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

6. Querying Databases with T-SQL

Time: 3 hours
This course shows users how to create database queries and to manipulate the data received through queries.

Objectives

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

Topics

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

7. T-SQL Commands

Time: 3 hours
This course explains how to join queries, create subqueries, and how to insert and modify data in Sybase.

Objectives

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

Topics

  • Join Queries
  • Subqueries
  • Other Subquery Types
  • Inserting Data
  • Deleting and Modifying Data
home - onsite classes - instructor-led online courses - self-paced online courses - why webucator - partners - contact - sitemap
© 2008 Webucator. All rights reserved. info@webucator.com | Toll Free: 877-WEBUCATE (877-932-8228) | From Outside the USA: 315-849-2724 | Fax: 315-410-5320
Phoenix, AZ | Santa Clara, CA | Santa Clara, CA | Los Angeles, CA | Sacramento, CA | Washington, DC | Atlanta, GA | Chicago, IL | Indianapolis, IN | Muncie, IN
New Orleans, LA Boston, MA | Cambridge, MA | Charlestown, MA | Framingham, MA | Ipswich, MA | Lincoln, MA | Wellesley, MA | Worcester, MA | Bangor, ME | Detroit, MI
Raleigh, NC Winston-Salem, NC | Lincoln, NE | East Hanover, NJ | Eatontown, NJ | Madison, NJ | Parsippany, NJ | Trenton, NJ | Albany, NY | Buffalo, NY | Rochester, NY
New York City, NY | Syracuse, NY | West Babylon, NY | Dayton, OH | Bethlehem, PA | Philadelphia, PA | Pittsburgh, PA | Pittsburgh, PA | State College, PA
Middletown, RI | Rapid City, SD | Austin, TX | Dallas, TX | Houston, TX | Arlington, VA | McLean, VA | Seattle, WA | Toronto, Canada | Ottawa, Canada | Calgary, CA