Does not apply.
A Datanase Management System (DBMS) is an indispensable tool for managing large amounts of data. Today, databases exist in just about every branch of science, technology and business. This course is oriented at introductory databases courses at leading US universities and it provides a comprehensive introduction to database design and application. The course provides practical experience in designing a database and working with a DBMS. Basic theoretical topics will also be discussed. Finally, the course provides a first overview of recent topics in the field of databases such as Data Warehousing, Data Mining and Internet database management. Recommended prior knowledge: basic programming skills.
Translate real-world data organization and constraints into a relational database design using Entity-Relationship models
Learn how to create, manipulate, and query databases using SQL
Understand the mathematical foundation of databases (relational algebra)
Understand how to tune databases for access efficiency, concurrent access and redundancy avoidance (normalformen)
Learn how data is stored and how to prevent data loss, and how indexes and file-organizations can be used to accelerate access to data
Get an overview of advanced techniques such as OLAP, data mining, and data warehousing
The most recent timetable can be found on the Student website:
[Schedules Informatica](https://www.student.universiteitleiden.nl/studie-en-studeren/studie/onderwijsinformatie/roosters/mathematics-en-natuurwetenschappen/informatica-bsc?cf=wiskunde-en-natuurwetenschappen&cd=computer- science-msc#tab-2)
[Schedules Computer Science & Economics](https://www.student.universiteitleiden.nl/studie-en-studeren/studie/onderwijsinformatie/roosters/wikunde-en-natuurwetenschappen/informatica-economie-bsc?cf=wiskunde-en- natural sciences&cd=computer science-economy-bsc#tab-2)
[Schedules Bioinformatics](https://www.student.universiteitleiden.nl/studie-en-studeren/studie/onderwijsinformatie/roosters/mathematics-en-natuurwetenschappen/bioinformatica-bsc?cf=wiskunde-en-natuurwetenschappen&cd=bioinformatica- bsc#tab-2)
[Schedules Artificial Intelligence](https://www.student.universiteitleiden.nl/studie-en-studeren/studie/onderwijsinformatie/roosters/mathematics-en-natural sciences/artificial-intelligentie-bsc?cf=wiskunde-en-natural sciences&cd =computer science-bsc#tab-2)
2 hours of lectures per week followed by 2 hours of practical/seminar led by an assistant(s) (including at least 5 lab sessions).
We will work with SQLlite, a database management system that works on all platforms and
A final exam will form 70% of the grade,
a group assignment and a mid-term test (with retake possibility) will form together 30% of final grade.. The teacher will inform the students about precise testing modalities during first lecture.
The test will take place during time scheduled for lecture and there will be a retake possibility for the test (not for the group assignment).
Ramakrishnan, R. & Gehrke, J. (2003). Database Management Systems (Vol. 3), McGraw-Hill.
Slides available on the webpage.
You can enroll via uSis . More information about signing up for classes and exams can be found [here ](https://www.student.universiteitleiden.nl/en/administrative-matters/registration--de-registration/course-and-exam-enrolment/course -and-exam-enrolment/science/computer-science-economics-bsc?cf=science&cd=computer-science-economics-bsc#tab-2).
In MyTimetable you can find all subject and training schedules, with which you can compose your personal schedule. Educational activities for which you are registered in uSis are automatically shown in your timetable. In addition, you can easily link My Timetable to a calendar app on your phone and schedule changes are automatically implemented in your calendar; moreover, if desired, you will receive a notification of the change by e-mail.
For more information about Brightspace, you can click on this link to view the university manuals.
For other questions or problems, please contact the coordinator BSc informatics Riet Derogee.