Course Content:
Introduction to Sybase
- 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
- 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
- Explain the role of a system administrator
- Use system procedures for database administration
- Manage databases
- Manage segments
Sybase User Administration
- Create and manage user accounts
- Control user access and aliases
- Create and manage roles
- Growth and High Availability
Sybase Programming with T-SQL
- 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 Indexes
Sybase Querying Databases with T-SQL
- 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
- Create join queries
- Use sub queries
- Insert data in databases
- Modify and delete data
- MYSQL - Delete
- PHP - ODBC
- XML - Introduction
- Simple XML
For more details:
Sakthi Software Solutions pvt ltd,
RVR Towers, 4th Floor, No.1, AA Block,
1st Street, 3rd Main Road,
Annanagar, Chennai 600 040.
Landmark: Annanagar Roundtana,
Behind Nalli Silks Showroom,
Phone: 044-43486300 / 45082474/75
