Title of course: Database management, practice
Code: TTGML7009_EN
ECTS Credit points: 2
Type of teaching, contact hours
- lecture: -
- practice: -
- laboratory: 2 hours/week
Evaluation: mid-semester grade
Workload (estimated), divided into contact hours:
- lecture: -
- practice: -
- laboratory: 28 hours
- home assignment: 32 hours
- preparation for the exam: -
Total: 60 hours
Year, semester: 1st year, 2nd semester
Its prerequisite(s): -
Further courses built on it: -
Topics of course
The aim of the course is to provide students the understanding of the architecture and applicability of database management systems in the Earth science work environment. They will gain an insight into the operation of the SQL structured query language used in the management of widely used relational data models and database systems. Students will review their previous database management skills and build on them to perform complex data query operations. The course will provide students with the basic practical skills to perform effective data queries independently. The following topics will be covered: overview of the main theoretical basics of database management, setting up and testing the SQL Developer software environment, DDL statements: creating data tables, adding constraints, modifying, deleting, renaming columns in data tables; DML statements: inserting columns and values, batch data loading; DQL statements: simple and single-table queries; DQL statements: using functions; DQL statements: displaying grouped data using row set functions; DQL statements: concatenating data tables, DQL statements: nested queries; DQL sta-tements: logical tests; DCL statements: privilege management.
Literature
- Ulmann, J. D. - Widom, J. 2009. Database systems: a primer. Panem, Budapest
- Coronel, C., Morris, S. 2019: Database Systems: Design, Implementation, and Management. Cengage.
- Beaulieu, A. 2020: Learning SQL: Generate, Manipulate, and Retrieve Data. O'Reilly Media
Requirements:
Participation at classes is compulsory. A student must attend the courses and may not miss more than three times during the semester. In case a student does so, the subject will not be signed and the student must repeat the course. During the semester there is one practical test. It can be completed in the 13th or 14th week. The minimum score is 50%.
Based on the score of the test, the grade for the test is given according to the following table:
| Score | Grade |
| 0-49 fail | (1) |
| 50-64 pass | (2) |
| 65-74 satisfactory | (3) |
| 75-85 good | (4) |
| 86-100 excellent | (5) |
-an offered grade:
it may be offered for students if the test written in the 13th week is at least satisfactory (3). - in case an offered grade cannot be given, or it is not convenient for the student there is a possibility to repeat in the last week
Person responsible for course: Dr. Boglárka Bertalanné Balázs, PhD, Assistant Professor
Lecturer: Dr. László Bertalan, PhD, Assistant Professor