Prior to attending the course's orientation meeting (see below), each one participant must follow the three steps below:
1. Watch the DBTech EXT video on using the Adobe Connect (AC) environment. The URL addresses appearing in the video do not apply as they relate to an older DBTechNet project. Other than that, the AC environment is presented sufficiently well, giving the course participant an idea of its basic communication tools and functionality. To view the video one can use any one of the video players that are freely available in the Internet, e.g. VLC from VideoLAN.
Orientation meeting (Thursday 16 May 2013, 19.00 - 20.00 EEST):
the Adobe Connect (AC) web conferencing environment, a few words about DBTechNet and DBTech VET, “SQL Transactions” course overview, course documentation and other materials, meet the trainers, meet the trainees
AC meeting address: http://meetings.businesscollege.fi/dbtechvet_gr Select "Enter as Guest" Under "Type your name", type in your full name, first name first, for example: John Smith Wait until the host/instructor grants you access to the virtual classroom Admittance to the virtual classroom will start at 18.50 EEST
All the videos included in this course, can be viewed by using any of the video players that are freely available in the Internet, e.g. VLC from VideoLAN.
Lecture 1 (Monday 20 May 2013, 19.00 - 20.00 EEST):
Tutorial/lecture1 (Prof. D.A. Dervos): basic concepts, the conceptual level of the DB architecture, manipulating DB data: get, modify, and put operations, risking inconsistency: at the attribute, row, able and at the multistatement level, system failures, ensuring DBMS durability to system crashes, transaction defined
Lecture 2 (Thursday 23 May 2013, 19.00 - 20.00 EEST):
Tutorial/lecture2 (Prof. C. Skourlas): transaction perspectives of: user, and clientserver, well designed transaction, COMMIT and ROLLBACK, the DBTechNet virtual machine (Debian Linux), SQL error diagnostics in the MySQL/InnoDB environment and in Oracle
Lecture 6 (Thursday 6 June 2013, 19.00 - 20.00 EEST):
Tutorial/lecture6 (Prof. D.A. Dervos): implementing isolation: isolation levels, multi-granular locking (MGL or LSCC), multi-versioning (MVCC), optimistic concurrency control (OCC), snapshot isolation, ghosts and phantoms, bringing it all together: transactions support in ANSI SQL and in various DBMS’s
Have you participated in the May-June 2013 pilot course offering in Greece? If YES, please do provide invaluable feedback information by filling-in the ANONYMOUS online questionnaire form.
* The DBTech VET project has been funded with support from the European Commission. This publication reflects the views only of the author(s), and the Commission cannot be held responsible for any use which may be made of the information contained therein
