Introduction to SQL: Adaptive Server Enterprise 15.7 (ASE1)

This course introduces the fundamentals of writing database queries to retrieve, sort, update and calculate results on data stored in Sybase Adaptive Server Enterprise 15.7. Hands-on exercises cover building both simple and complex queries for real use.

The hands-on labs practice query construction using ANSI-89, ANSI-92 and Sybase Transact-SQL syntax, showing differences and best practices. The course is designed for beginners - no prior relational database experience required - and focuses on practical examples.

Location, current course term

Contact us

Custom Customized Training (date, location, content, duration)

The course:

Hide detail
  • Relational database concepts
  • Client/server architecture
  • Simple queries (queries to retrieve all data from a single table)
  • Conditional queries (queries to retrieve rows that meet criteria)
  • Aggregate functions (functions for simple calculations over data)
  • Joins (table joins - queries to retrieve data from multiple tables simultaneously)
  • Subqueries (queries nested within other queries)
Assumed knowledge:
No prior relational database experience required.
Schedule:
1 day (9:00 AM - 5:00 PM )
Education Partner:
MIBCON DIMA s.r.o.
Language: