computer training image
Online Training Classes Purchased Securely
Shopping cart  Shopping cart
0 Product(s) in cart
Total $0.00
> Checkout
Online Payments

Benefits of Computer Coach's online computer training classes

  • Accessible 24 hours a day 7 days a week, so you can learn when you have time.
  • Cost-effective solutions, so you don’t go broke learning the skills you need.
  • Available Anytime, anywhere with an Internet connection, so you can study at your house, office, or where you feel comfortable.
  • Interactive & fun courses allow for greater retention of course topics.
  • Easy to use so you can start learning right away.
  • Full of hands-on labs so you can get the practice you need
  • HTML Based so you don’t need any additional downloads
  • Live Mentor Available to ask questions and get clarification

online computer training questions answered

Sybase Online Course

12 Month Subscription - $70
Live Mentor +$30

Summary:
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.

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

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

Topics included in this course:
Sybase : Introduction to Sybase
Sybase : Using SQL Server
Sybase : System Administration
Sybase : User Administration
Sybase : Programming with T-SQL
Sybase : Querying Databases with T-SQL
Sybase : T-SQL Commands

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

Objectives:
After completing this course, students will be able to:
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
top

Sybase : Using SQL Server
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
top

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

Objectives:
After completing this course, students will be able to:
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
top

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

Objectives:
After completing this course, students will be able to:
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
top

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

Objectives:
After completing this course, students will be able to:
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
top

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

Objectives:
After completing this course, students will be able to:
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
top

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

Objectives:
After completing this course, students will be able to:
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
top

12 Month Subscription - $70
Live Mentor +$30