Conference ulysse::rdb_vms_competition

1304.0. "Multivendor SQL Programming - second delivery" by HERON::GODFRIND (Usage interne seulement) Fri Oct 22 1993 15:59

                        Multivendor SQL Programming
                     (Rdb, INGRES, Oracle, Informix)

This is the second delivery of this course worldwide and will again be held by 
the developers : Richard Graf, Martin Hoffmann and Ronald Jeninga. Between
them, 
the trainers have almost thirty years experience across the various database 
systems covered by the course, and many years experienceof training and 
consulting in databases and programming.

Following are a few comments from participants on the first course :

"I have really profited from this course. It will save me a lot of time".

"I understand a lot more about the issues in porting. I had been led to believe 
they were trivial : now I know that they are not".

"This course can help Digital to generate follow-on business, for example, in 
consulting".


TARGET AUDIENCE


This course is designed for :

	* Software Engineers who :

			-  develop portable SQL-based applications
			-  port SQL-based applications from one database
			   management system to another

        * System Consultants & RDBMS Trainers who :
	
			- advise their customers in the SQL implementations
			  of different vendors
			- have customers with multi-vendor database
			  environments


The course will also be useful for project managers and decision-makers who
need 
to understand the issues in creating portable SQL-based applications, or in 
porting existing SQL-based applications.

The course may also be useful for support staff who need to advise customers 
using ported databases.


PREREQUISITES

In order to successfully complete this course, the student should have :


         1. Considerable practical experience with at least one SQL
            implementation (Informix, INGRES, Oracle, Rdb/VMS)

         2. Understanding of database management system terminology

         3. Experience with developing, compiling, linking, and running
            a high-level programming language image



COURSE OBJECTIVES

         Upon successful completion of this course, the student should be
         able to :

	 1. Understand the main features of each vendor's SQL
	    implementation (Rdb, INGRES, Oracle, Informix)

         2. Create tables using the different datatypes

         3. Manipulate (retrieve, insert, update, delete) data and use
            the main specific features of each vendor

         4. Manage transactions and understand the vendor specific
            locking strategies

	 5. Manage missing information (NULL values)

	 6. Create and manipulate views

         7. Create and run 3GL applications against multivendor
            databases

         8. Differentiate between Standard and Multivendor SQL Features

         9. Recognize the major porting problems and their solutions


COURSE OVERVIEW

This course is designed to teach software engineers, consultants and porting 
specialists how to work efficiently with SQL in an environment where more than 
one database system is present.

The course supports a rapid learning curve and efficient use of techniques for 
each database management system and for a combination of them.

Understanding of the different SQL implementations and practice in using them 
can help you :

        * design portable applications from day one, minimising later
          porting costs.

        * budget and plan the porting of already existing applications.

        * port with maximum efficiency: there is no need to re-invent the
          wheel.

	* plan your company's SQL-based applications or advise your
	  customers on theirs.

	The major topics covered include all the most important SQL features. 
        The topics are organised in a task-oriented way to ensure that students 
        are able to relate these directly to their own work.

        The course is designed in the following format to encourage
        intensive and active learning :

        �  Lecture : theoretical overview and comparison of the
	             implementation from each vendor

        �  Laboratory : structured hands-on labs allow students to put
	             techniques into practice

        �  Round Table Discussion : this is an important opportunity for
                     students to consolidate their knowledge, and to learn from 
                     each other as well as from the trainers.


CONTENTS

          - Review of SQL, standards and the relational model

            Each of the following topics then covers the differences and
            similarities in the implementations of SQL for Rdb, INGRES, Oracle
            and Informix

          - Data Definition Language
	  
            Character string, numeric and abstract data types; row identifiers; 
            domains; tables

          - Retrieving Data

            Simple and complex queries; Subqueries

          - Data Manipulation: Basic Operations

            Single vs multiple row statements; inserting, updating and
            deleting table rows

          - Transaction Management

            Basic and concurrent transactions; locking

          - Missing Information: NULL values

            NULL values in expressions, predicates and functions; NULLs
            in boolean operations; data manipulation on NULL-able columns

          - Concept of views

            Creating and destroying; derived data support; updatable
            views; WITH-CHECK-option; access control; materialization

          - Integration of SQL in a programming language

            Preprocessor options with the four databases; connection
            control; declaring and using variables; exception and error
            management; cursors.

	  - Product-specific SQL functions

            Procedures, triggers, events, rules



Date  : December 13/17, 1993          			
        	
LOCATION : Munich, Germany (UFH)

ENROLMENT PROCEDURES :

1 - ENROLMENT INFORMATION FOR STUDENTS
    ----------------------------------
    Students should send the below requested enrolment details to their 
    OWN COUNTRIES ENROLMENT DESKS :


        Course Corporate Nbr    : EY-Q041E
        Course Title            : Multivendor SQL Programming
        Course Dates            : December 13/17
        Course Location         : Munich, Germany (UFH)

        Complete Student name   : <>
        NATIONALITY             : ......... (i.e. Export Controls Purposes)
	COURSE PREREQUISITE 	: YES or NO
 	Function		: <>
        Exact Job title         : <>
 	Badge number		: <>
 	Cost centre		: <>
 	EMail address           : <>
 	Manager's Name          : <>
 	City & Country		: <>
 	Arrival date		: <>
 	Departure date		: <>
 	Accommodation required	: YES or NO

    
    will this be taught in the US, preferably close to majro skir areas,
    oooh, perhaps Colorado Springs?
    
    Also is it available to customers?
    
    Simon

�           <<< Note 1304.1 by CSC32::S_MAUFE "this space for rent" >>>

�    will this be taught in the US, preferably close to majro skir areas,
�    oooh, perhaps Colorado Springs?

Simon,

I don't believe that this course is scheduled in the US at this time.