Course outline: Database Fundamentals for Sybase SQL Server


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:

  1. Introduction
  2. Relational Modelling
  3. Select statements
  4. Data types
  5. Functions
  6. Aggregates
  7. Joining Tables
  8. Building Tables
  9. Database Integrity
  10. Views, Indexes & Rules
  11. Transactions
  12. Batches & Stored Procedures
  13. Unix & Sybase
  14. Users & Permissions
  15. Database Administration