Structured Query Language for Sybase Adaptive Server

PT2782
Summary
SQL is the standard language in use by all major relational database vendors. This course provides an introduction to the version of SQL, Transaction SQL, used by Adaptive Server. The course provides an introduction to querying relational databases, focusing primarily on the SELECT statement, its syntax, and the use of joins.
Prerequisites
There are no prerequisites for this class
Duration
1 Day/Lecture & Lab
Audience
This course is intended for programmers, system administrators and database administrators. It is also a good overview for managers.
Topics
  • Structured Query Language
  • Joins
  • The Select statement
  • Modifying data with SQL
  • Subqueries
  • Union
  • Selecting rows with where
  • Aggregates functions

Related Scheduled Courses