|
Provided by: Ahana Systems and Solutions (P) Ltd Sybase -Mastering Advance T-SQL Online |
 |
Training
Provided by Ahana Systems and Solutions (P) Ltd
Our Sybase database training develops and delivers excellent learning solutions to support your personal and organizational learning goals. We developed our courses to provide real solutions for the challenges you face every day, these task-based courses get to the heart of Sybase technology and provide you with the technical know-how that you can apply to achieve effective results, the ability to address specific real-world issues that pertain to your company's unique environment.
When it comes to delivering Sybase database administration and technology training, there is no one better equipped than real-world production Sybase DBA's. Our access to production DBA, technical support and database architects ensures that our programs incorporate the most recent tips, tools and best practices to bring you up to speed and help you get the most out of your Sybase training.
|
|
||||||||||
Sybase -Mastering Advance T-SQL Online
Sybase Database Administration
Mastering Advanced T-SQL
Course Description :
It covers a discussion of the underlying nature of relational databases and SQL Fundamental concepts like locking and query optimization that will impact your applications, Set-oriented and sequential processing of data, Methods of manipulating data and formatting output, Best programming practices
Course Objectives :
Upon completion of this course, you will be able to: I
Write queries that will use the query optimizer to access indexes
Understand the many different types of joins and subqueries
Use the case expression to write more powerful queries
Understand how locking works in Adaptive Server
Use cursors effectively
Manipulate numeric and temporal data to solve everyday problems
Course Topics:
Module 1: SQL and Transact-SQL
Module 2: Understanding SQL Basics
Module 3: Indexes and Search Arguments
Module 4: Joins and Subqueries
Module 5: Using Case Logic
Module 6: Transactions and Locking
Module 7: Writing Effective Transactions
Module 8: Using Cursors
Module 9: Manipulating Data
Module 10: Formatting Output Data
Module 11: Writing Effective Transact-SQL
Module 12: Writing Effective Stored Procedures
Module 13: Assigning Key Values
Module 14: Creating Hierarchies with SQL
Mastering Advanced T-SQL
Course Description :
It covers a discussion of the underlying nature of relational databases and SQL Fundamental concepts like locking and query optimization that will impact your applications, Set-oriented and sequential processing of data, Methods of manipulating data and formatting output, Best programming practices
Course Objectives :
Upon completion of this course, you will be able to: I
Write queries that will use the query optimizer to access indexes
Understand the many different types of joins and subqueries
Use the case expression to write more powerful queries
Understand how locking works in Adaptive Server
Use cursors effectively
Manipulate numeric and temporal data to solve everyday problems
Course Topics:
Module 1: SQL and Transact-SQL
Module 2: Understanding SQL Basics
Module 3: Indexes and Search Arguments
Module 4: Joins and Subqueries
Module 5: Using Case Logic
Module 6: Transactions and Locking
Module 7: Writing Effective Transactions
Module 8: Using Cursors
Module 9: Manipulating Data
Module 10: Formatting Output Data
Module 11: Writing Effective Transact-SQL
Module 12: Writing Effective Stored Procedures
Module 13: Assigning Key Values
Module 14: Creating Hierarchies with SQL
About The Training Provider: Ahana Systems and Solutions (P) Ltd
Ahana Systems and Solutions (P) Ltd - Oracle9i DBA
Oracle 10g DBA
Oracle 10g RAC
Sybase DBA
ASE DBA
Sybase Replication DBA
Oracle DBA
MSSQL DBA
MySQL DBA
Perl scripting
Shell scripting
Clearcase Administration
Linux Administration
VMWare
Windows Administration
Our In-house training is aimed at individuals who want to build their career in IT infrastructure field. Its mainly aimed at studends who are in the verge of...
