Software Laboratory 5

 

General information

 

Contact information of the instructor

 

Name: Levente Erős, PhD

Room: IB228

E-mail: eros (at) db.bme.hu

 

Time and place of the classes

 

The classes take place in Room B, Building R (4th floor), according to the following schedule:

 

Oracle

02/03/2016, 14:15-15:45

SQL

09/03/2016, 14:15-15:45

JDBC

23/03/2016, 14:15-15:45

PHP

06/04/2016, 14:15-15:45

XSQL

04/05/2016, 14:15-15:45

 

Software you will need

 

            Oracle SQL Developer 4.1.3

 

o   You can connect the database with the following settings:

o   Hostname: rapid.eik.bme.hu

o   Port: 1521

o   SID: szglab

 

Useful material/information

 

            Preface of the course material

            UNIX summary

Oracle SQL reference

Oracle SQL quick reference

 

            At the beginning of each class, an entry test will be written which is necessary for completing the given class. The course material includes everything needed for the entry test.

 

Class 1, Oracle

 

            Course material

            Report template and exercises

 

            You should hand in the following material to the instructor via e-mail within 4 days after the beginning of the class:

 

    NEPTUN-1-S14A.zip

    |-NEPTUN-1-S14A\

      |-NEPTUN-1-S14A.pdf

 

            You should substitute NEPTUN with your NEPTUN code. The ZIP file you hand in should include a directory with the same name as the ZIP file, and your report inside the directory, in PDF format.

 

Class 2, SQL

 

            Course material

 

Class 3, JDBC

 

            Course material

            .java.policy file

 

Class 4, PHP

 

            Course material

 

Class 5, XSQL

 

            Course material