IT Training Online Course: Sybase
 |
Sybase is the largest enterprise software and services company exclusively focused on managing and mobilising information. With our global solutions, enterprises can extend their information securely and make it useful for people anywhere using any device.
|
|
| |
Product Duration: 12 Months Unlimited Access |
Price |
Add to Cart |
| |
Sybase Training
This Sybase training 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.
|
£199.99
|
|
|
| Sybase Course Lessons: |
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. 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
|
|
Sybase: Using SQL Server
This course introduces users to SQL Server and how to use it to create, manage, and access database information. 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
|
|
Sybase: System Administration
This course provides an overview of the tasks and commands of a system administrator. Explain the role of a system administrator
Use system procedures for database administration
Manage databases
Manage segments
|
|
Sybase: User Administration
This course shows users how to manage user accounts and groups in Sybase. Create and manage user accounts
Control user access and aliases
Create and manage groups
Create and manage roles
Grant and revoke permissions
|
|
Sybase: Programming with T-SQL
This course introduces users to basic T-SQL commands and functions through the isql interface. 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
|
|
Sybase: Querying Databases with T-SQL
This course shows users how to create database queries and to manipulate the data received through queries. Create queries
Use functions in queries
Modify query results
Order and group query results
Use queries through views
Combine query results
|
|
Sybase: T-SQL Commands
This course explains how to join queries, create subqueries, and how to insert and modify data in Sybase. Create join queries
Use subqueries
Insert data in databases
Modify and delete data
|
|
|
If you just have a question about our Sybase training or any other careers or training course just telephone us on 0871 222 8790 or fill in the simple form below and an advisor will contact you shortly.
|
Telephone: 0871 222 8790
Alternate Number: 01279 814 876
Fax: 01279 816 093
E-Mail: info@e-careers.co.uk
Address:
10 Riverside Business Park,
Stony Common Road,
Stansted Mountfitchet,
Essex,
CM24 8PL

|
What do I get?
Within 30 minutes of placing your order you will receive a username and password and a link to access all of the following:
Interactive simulations
Feel like you are actually using the software you are being trained about in the added security of our learning environment.
Skills Assessments
Test yourself and receive a certificate online. Multiple choice or fill in the blanks style questioning helps you remember and learn
Printable reference guides and exercises
Every chapter has its own hands on exercises for you to carry out to help you gain essential experience. You also have automatic glossary and search features to help you use the course as a 'quick reference' guide
Full telephone and email support with no premium rate charges
Our friendly support team is here on hand 8am-8pm to help you out if you get stuck
Free upgrades for 12 months
For the duration of your 12 months license you will receive any updates we make to your course free of charge. Sign up for our complete package and you will be able to receive all the new courses we add free of charge.
Best price in UK guaranteed
We are so confident that you will not find another online training service of the same quality and price that we will beat any legitimate quote on a like for like basis by 10%.