◊ SYBASE ONLINE TRAINING SERIES
Online Sybase Training
Database » SQL Server
Check out these great money-saving course packages:
Only $42.95
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
Resources for Sybase
