Lectures

Lectures are held every Monday from 16:00 to 17:30 in room IL.105.

  • Note: On Sep. 27 from 16:15 to 17:45 there will be a lecture in room IL105.

Instructor

Levente Erős, eros -AT- db.bme.hu

Evaluation of results

Midterm tests will be written on the following lectures:

  • Oct. 1
  • Oct. 15
  • Nov. 26

For each midterm test, you get a grade. These will be averaged (let’s call this average M). M must be greater than equal to 2 to get a signature. Then, on the exam, you get another grade on the exam (let’s call it E). Both E must be greater than or equal to 2. You also get grades for your lab assignments. Lab grades are given by your lab instructor, who takes into consideration:

  • the grade you got for your work from the evaluator,
  • and what you did during the lab class,

to create the final lab grade. You will get 5 lab grades, which will be averaged (let’s call this lab average L). Each of your lab grades must be greater than or equal to 2 to get a signature.

Your final mark will be 0.3M+0.3E+0.4L.

Practices

Practices are held according to the following schedule, in room IL.105, from 16:15 to 17:45 (some practices might later be exchanged with lectures, but the room is the same, so just make sure you’re in this room in the time slots below):

  • Sep. 24
  • Oct. 4
  • Oct. 18
  • Nov. 15
  • Nov. 29

Instructor

Tamás Bunth, tamas.bunth -AT- db.bme.hu

Laboratories

Instructors and contact

Ruba Mahasneh, ruba.mahasneh -AT- db.bme.hu Nicholas Makana Rodgers, nick.rodgers -AT- db.bme.hu Bence Böjti, bence.bojti -AT- db.bme.hu Gergő Ládi, gergo.ladi -AT- db.bme.hu

Lab groups

There will be 3 lab groups in total. Students in the same lab group will attend the lab classes of the same instructor, in the same room, and same time slot. Below are the NEPTUN IDs of students belonging to each group.

Group c16-a1 (instructor: Bence Böjti):

  • A8W3CY
  • ARW15Y
  • C0EZ13
  • G1XB6S
  • GINV1W
  • GX015K
  • I9LZOM
  • ICJ9KJ
  • LANB0Z
  • LXUQMT
  • NT3BPK
  • RD0N48
  • U5CMBS
  • URBT3S
  • W4FWIU
  • XUNTBX

Group c16-a2 (instructor: Nick Rodgers):

  • JI4DSE
  • BB3953
  • CWHIBN
  • D3D47S
  • EBD38C
  • FRPAX0
  • G8UBDU
  • HPLUHV
  • I14Y77
  • JOBHAZ
  • KOIES3
  • OTICTN
  • Q0PEZU
  • RMZ7HE

Group p12-a (instructors: Ruba Mahasneh and Gergő Ládi):

  • A1AMNZ
  • BE2YWG
  • E90X97
  • G6VEB8
  • GOQFDW
  • RFX4IX
  • WD769X
  • XRDCY2

Time and place of classes

For group c16-a1, each class is on a Thursday, from 16:15 to 17:45, in Room R4I (Room I, 4th floor of Building R), according to the following schedule:

  • Oracle: Oct. 11
  • SQL I: Oct. 25
  • SQL II: Nov. 8
  • SQL III: Nov. 22
  • Optimization: Dec. 6

For group c16-a2, each class is on a Thursday, from 16:15 to 17:45, in Room R4K (Room K, 4th floor of Building R), according to the following schedule:

  • Oracle: Oct. 11
  • SQL I: Oct. 25
  • SQL II: Nov. 8
  • SQL III: Nov. 22
  • Optimization: Dec. 6

For group p12-3, each class is on a Friday, from 12:15 to 13:45, in Room IL105 (where the lectures are), according to the following schedule:

  • Oracle: Oct. 5
  • SQL I: Oct. 26
  • SQL II: Nov. 9
  • SQL III: Nov. 23
  • Optimization: Dec. 7

General information

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. See the course material below for each topic, separately.

You will start solving the exercises during class. The amount of exercises that you get can be solved during class. Once finished, you can upload your solutions in a predefined format (see below) in the lab administration system, which is here. If you can’t finish the exercises during class, you can finish them at the Students’ Computer Center (HSZK, floor 4, building R), or at home, but 1 day from the beginning of the given class, your solution has to be uploaded.

Please, neither try to log in the administration system, nor ask for a new password until I give you your access codes.

The labs are equipped with the hardware and software needed for the classes. Using your own computers during labs is allowed however, we cannot give support for installing/configuring or troubleshooting the necessary tools on your laptops during lab time.

Software you will need

  • Oracle SQL Developer 4.2.0. To run it: Unpack it, and execute sqldeveloper\sqldeveloper.exe. If it does not work, then run sqldeveloper\sqldeveloper\bin\sqldeveloper.bat. This is for Win64. You’ll need JRE to run this.
  • For other platforms, you can download the same version of SQL Developer here. You’ll need to install the appropriate Java 8 JDK to run this. Attention! On Oracle’s website, SQL Developer 18.1 stable can be downloaded since April 5th 2018. However, in the lab we will use version 4.2. We are unaware of any significant issues caused by the differences between versions, but should there be any issue due to this, we might not know the solution. So please, use version 4.2

The work environment is provided and supported in the laboratory (IL.105), and in HSZK. Software you might need (for Windows)

Network settings for home

SQL Developer connection:

  • Hostname: rapid.eik.bme.hu
  • Port: 1521
  • SID: szglab

Useful material

Class 1, Oracle

You should upload a single PDF file to the lab portal, containing your report. The name of the file should be NEPTUN-1-TIME.pdf, where you should substitute NEPTUN with your actual NEPTUN code, and TIME with your group code, which can be:

  • c16a1
  • c16a2
  • p12a

The SQL code to be executed during the lab

Below is the SQL code that has to be executed after solving exercise 5.

-------------------------------------------------
-- BME VITMAB04 Adatbázisok. 1. mérés, 2017.
-------------------------------------------------
-- 5. feladathoz futtatandó SQL kód
-------------------------------------------------
column grantor format a8;
column grantee format a8;
column table_name format a20;
column privilege format a20;
select grantor
     , grantee
     , table_name
     , privilege
     , initcap(grantable) grant_opt
  from all_tab_privs
 where grantor = user
    or grantee = user
 order by grantor, grantee, table_name, privilege
;

Classes 2, 3, and 4: SQL1, SQL2, SQL3

The material for the SQL labs (SQL1, SQL2, and SQL3) can be found here.

  • For the first SQL lab, you should be prepared from table manipulation statements and from the ER modeling and ER->relational mapping chapters of the Databases course.
  • For the second SQL lab, you should be prepared from SQL queries.
  • For the third SQL lab, you should be prepared from the entire SQL guide.

For the requirements of completing this lab, and for some SQL tips, read this Students’ guide!

The skeleton of the script to be handed in is here, while here is a page that helps you create the XML file if you don’t do it manually. USING THE GENERATOR PAGE IS PREFERRED.

Class 5: Optimization

The material for the optimization lab is the lecture slideshow, which can be downloaded from here. Please, read the Students’ Guide here – TODO.