|
Provided by: Affinity IT Training, LLC Introduction To Sybase Transact-SQL |
 |
Training
Provided by Affinity IT Training, LLC
Introduces Sybase Transact-SQL, the language used to interact with Sybase Adaptive Server.
Audience:Application developers wishing to integrate Sybase Adaptive Server into their IT solutions.
|
|
||||||||||
Introduction To Sybase Transact-SQL
Objectives
- Create queries and reports using Transact-SQL
- Achieve mastery of the Data Manipulation Language (DML) constructs
Outline
Introduction
What is Structured Query Language ?
ANSI SQL
Transact-SQL
The Relational Model and Relational Databases
The SELECT Statement
Specifying Tables and Columns
The DISTINCT Clause
Controlling Column Headings
Formatting SQL Statements
The WHERE Clause
Specifying Where Conditions
Equality Operators
Other Comparison Operators
BETWEEN and NOT BETWEEN
IN and NOT IN
LIKE Clause
Wildcard Characters
ESCAPE Clause
Understanding NULL Values
Sorting Results
Aggregate Functions
SUM
MIN, MAX
AVG
Count, Count(*)
Defining Stored Procedures
Executing Stored Procedures
Displaying Stored Procedures
Modifying Stored Procedures
Returning Values with Output Parameters
Return Status
Optimization
Coding Guidelines
Remote Stored Procedures
Extended Stored Procedures
Using Joins
Understanding the Join
Recipe for Joining Tables
Using Table Aliases
Outer Joins
Using Subqueries
Statements Requiring Subqueries
Using Subqueries in WHERE and HAVING
Select List
Union
Combining Result Sets
UNION
UNION ALL
Modifying Data
SELECT INTO
INSERT
UPDATE
DELETE
Updates and Deletes Using Joins
Transact-SQL Features
String
Date
Conversion
System
Aggregate
Mathematical
Isnull
Date Conversions
Transact-SQL Programming Constructs
Batches
Local and Global Variables
Comments
Print
Raiserror
Waitfor
Return
Flow Of Control Statements
Statement Blocks
Cursor Programming
Declaring
Opening Cursors
Fetching and Modifying Cursor Rows
Closing and Deallocating Cursors
Modifying Rows
Setup
- Access to Sybase Adaptive Server
- Database accounts for all students and Instructor
Training Materials
- Course Workbook
X.X
About The Training Provider: Affinity IT Training, LLC
Affinity IT Training, LLC - .
We are a provider of hands-on, instructor-led IT training for the global business community including website development, databases, programming languages and more. Training includes: ASP, .NET, C#, C , DB2, AJAX, JavaScript, HTML/XHTML/XML, Unix, Linux, Perl, Python, Ruby On Rails, Oracle, Sybase, SQL Server, Project Management Training and customized Integrated Case Study.
