iCSC2005  Exercises

Several lecturers have prepared exercises to complement their ex-cathedra lectures.

 

Theme

Author

Companion Lecture

Links

 

Data Bases

Miguel Anjo

SQL: basics and recent advances
+
Advanced Database Features

Zip File

These exercises are on SQL basics as well as on some advanced features. The tables used on the exercises as well as answers are included.

The exercise material is bundled as a zip file. Inside the file, you will find a text file with specific explanations for each exercise plus an SQL file containing the schema and  sample data.

You should be able to do the exercises on your own. It will take you about two hours to complete all the exercises. If you have any problems, please contact Miguel.Anjo@cern.ch.

 

Data Bases

Michal Kwiatek

Performance Optimization and Tuning

Zip file

There are five exercises to go with the lecture.

Ex. 1. Checking execution plans
Ex. 2. Managing statistics
Ex. 3. Using indexes
Ex. 4. Bind variables
Ex. 5. Autotrace and tuning problems

The exercise material is bundled as a zip file. Inside, there is a text file with explanations for each exercise as well as an export file containing sample data. You should be able to do the exercises on your own. It will take you about two hours to complete all five exercises. If you have any problems, please contact Michal.Kwiatek@cern.ch.

 

Advanced Software Engineering

Brice Copy

Integrated Build Demonstration

HTML Demo

This series of exercises will be done by the author as a demonstration session to the audience. Attendees will be able to follow the demo step by step  in parallel on their own laptop during the session, or replay it -as exercises- after the school.

If you wish to follow the demonstration step by step on your own PC, please follow these instructions.
 

The demonstration will be split into five stages :
 

—

Exercise 1 : Compiling the project

—

Exercise 2 : Testing the project

—

Exercise 3 : Generating reports

—

Exercise 4 : Deploying the project

—

Exercise 5 : Setting up a continuous build for the project
 

You do not have to follow all the steps - exercise 4 especially needs you to be at ease with web application servers (Apache Tomcat).

Instructions to follow the demonstration

For Exercises 1 To 3 :

 

—

Install a Sun J2SE SDK 1.4.2 on your machine (freely available at http://java.sun.com) - make sure the SDK binaries are on your PATH and that the environment variable JAVA_HOME is defined.
 

—

Download and install Apache Maven 1.0 :

 

 

—

For Windows, download and run maven-1.0.exe

 

 

—

For UNIX and other platforms, download and expand maven-1.0.zip
 

—

Set the environment variable MAVEN_HOME to where you installed Maven.

 

 

—

On Windows, the default value is "C:/Program Files/Apache Software Foundation/Maven 1.0"

 

 

—

On other platforms, the value will point to the directory where you expanded the zip file.

For Exercise 4 :

 

—

Install Apache Tomcat 4.1.x on your machine. If you already have a running instance available on your network for development purposes, you should be able to use it too. Tomcat is available at http://jakarta.apache.org/tomcat/

For Exercise 5 :

 

—

Ensure that you have a CVS client available on your path.

To Follow The Demonstration :

 

Finally, download and expand exercise.zip anywhere on your computer.
 

The demonstration is available at :

http://event-icsc2005-collaboration.web.cern.ch/event-icsc2005-collaboration/BuildDemo/demo.html

or

http://event-icsc2005-collaboration.web.cern.ch/event-icsc2005-collaboration/BuildDemo/demo1024.html

(If you have a screen resolution superior to 1024 x 760 pixels)
 

Simply follow it step by step. Remember that you can stop and rewind at any time thanks to the media toolbar at the bottom of the movie frame.