Purpose: to enable the student to perform queries,
updates on a standard Sybase database. As is the case for all our programming courses, the 4 days consist of
approximately 50% lectures and 50% hands-on practical work.
All our lecturers have considerable experience of both software development and course delivery.
Course contents:
- Introduction
- Sybase Perspective
- Client Server Architecture
- Sybase Architecture
- SQL Server
- SQL & T-SQL
- Relational Modelling
- Tables & Relations
- Components of ER Diagrams
- Cardinality
- Linking Tables
- pubs2 Relational Model
- Select statements
- Sybase T-SQL Select Syntax
- Selecting Columns from Tables
- Computing Columns
- Aliasing Columns and Result Columns
- Sorting Results with order by
- Filtering Results with the where clause
- Equality and Boolean Operators
- between and not between
- in and not in
- like, not like and wildcards
- Subqueries
- distinct
- Data types
- Introduction
- Column Data Types
- NULL Values
- Selecting NULL Values
- Data Type Conversions
- Format Conversions
- datetime Conversions
- User-Defined Data Types