Sybase For Developers

5 Days course

Language: English

This course is only available on request!!

DESCRIPTION
This course enables students to create tables and manipulate data using the Sybase SQL Server.
They will create and execute stored procedures, implement business rules through triggers and maintain referential integrity through declarative referential integrity.
Laboratory exercises supplement the course.

WHAT YOU WILL LEARN
Understand the Client/Server model and speak the language of relational databases.
Demonstrate an in depth knowledge of a format query language.
Manipulate data through SQL.
Create and use stored procedures.
Understand referential integriy and implement it through triggers or by declarative means.
Implement business rules through the use of triggers
Handle concurrent data modification issues.
Understand the SQL Server transaction processing including names caches.
Translate a relational database design into a fully functional database.

WHO SHOULD ATTEND:
This course was designed for anyone wishing to move to the Client/Server architecture and relational model.

ASSUMED KNOWLEDGE
Students should have some programming knowledge or have taken the Relational Database Design course.

OUTLINES


CHAPTER 1: COURSE INTRODUCTION

1) Overview of database processing
2) History of database processing
3) The Client/Server model

CHAPTER 2: RELATIONAL DATABASES

1) Comceptual level modeling
2) Logical level modeling
3) Physical level modeling
4) Why Relational?

CHAPTER 3: ANSI SQL DATA MANIPULATION LANGUAGE (DML)

1) Formal query languages
2) The SELECT statement
3) The INSERT statement
4) The UPDATE statement
5) The DELETE statement

CHAPTER 4: ANSI SQL DML EXTENSIONS

1) Local variables
2) Global variables
3) Control of flow statements
4) Date and time functions
5) Convert functions
6) String functions
7) Stored procedures
8) Temporary tables

CHAPTER 5: TRANSACT SQL DATA DEFINITION LANGUAGE (DDL)

1) CREATE DATABASE (on one to several devices)
2) System defined datatypes
3) User defined datatypes
4) Identity columns
5) Schema informational commands
6) Defaults
7) Domain integrity
8) Declarative referential integrity
9) Triggers
10) User defined messages
11) Views
12) Indexes

CHAPTER 6: TRANSACTION MANAGEMENT

1) Commit/Rollback commands
2) The transaction log
3) Recovery
4) Locks

CHAPTER 7: TRANSACT SQL CURSORS

1) Server cursors
2) Language cursors
3) Multiple cascading primary key update
4) The Halloween problem

CHAPTER 8: DBA TOPICS

1) sp_configure
2) sp_dboption
3) Protections
4) Backup and recovery

CHAPTER 9: MISCELLANEOUS TOPICS

1) Bulk copy
2) Set showplan
3) Set statistics

[HOME] [dates] [reserve] [seminars]
FDDI Institute
De Regenboog 11 - 2800 Mechelen - Belgium - Europe
Tel 32 15 24 50 58 - Fax 32 15 25 10 50