Conference ulysse::rdb_vms_competition

1286.0. "Multivendor SQL course (pilot) - Munich sep 20/24" by HERON::GODFRIND (It's not the heat, it's the humidity) Fri Aug 27 1993 12:02

                  I N T E R O F F I C E   M E M O R A N D U M

                                   Date:         23-Aug-1993 09:06
                                   From:         ANNOUNCEMENTS ANNOUNCEMENTS @G
                                                 ANNOUNCEMENTS AT A1_LEMAN @EHQMTS @GEO
                                   Dept:         LS Operations CH
                                   Tel No:       DTN 821-5092

TO: See Below

Subject: EY-Q041E - MULTIVENDOR SQL PROGRAMMING TRAINING ANNOUNCEMENT

COURSE SUMMARY & CHARACTERISTICS
Date : September 20/24, 1993          			Duration : 5 days
Location : Munich, GERMANY				Course Type : Lec/Lab 
Target functions : MCS, DS  				-  PILOT  -
Deadline for enrolment : One week prior to course   

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


      				    THIS IS A PILOT
				    ***************


        This pilot course delivery will 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 experience of training and 
	consulting in databases and programming.



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 Database Administrators who
        administer databases of different vendors.


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.


COURSE CONTENT

          - 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  : September 20/24, 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            : September 20/24, 1993
        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


2 - ENROLMENT PROCEDURE FOR COUNTRY ENROLMENT DESKS

    ALL enrolment request MUST BE SENT TO : ENROLMENT @UFH 


The agenda, the final logistical and accommodation details will be sent to 
the CONFIRMED participants in due time.


DEADLINE FOR REGISTRATION : 

                            One week prior to course

	Will this be offered in the U.S. ?

	Regards,
	rcs

 I had the same question as in .-1 and this is the answer I got from Peter
Klein in Munich:

....
         We will offer the MV SQL course in late fall in the US as well.
         The person to set it up there is CAROL MONACO.
         Please give her a mail, ring and support her to get enough 
         audience to the BEST DB COURSE on the market !!!!!
         ( in and outside DEC ! )
         She would like some encouragement from the field...as the work to 
         set up a course like this is not trivial....
         
         P.S. Carol Monaco's address is @PKO
         You could copy  Dolores Cordeiro (STOWOA::CORDEIRO) on any note
         like this ( as she financed the course development...and she would
         like to know if there is US interest around it )