|
|
 |
|
|
|
|
|
Printable Version |
|
|
|
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
|
— |
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 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. |
|
|
— |
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/ |
|
|
— |
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 :
|
(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.
|
|
|
|
|
|
|
|
|
|
