Database Management System 2700-L-IN-Z4PROJBD
1. Introduction to relational databases; database management system, client-server architecture.
2. Language defining questions
3. Manipulating Data
4. Database design: a conceptual model and logical
5. Implementation of the database: create tables, links, tables, data import.
6. Advanced data processing
7. Manage Permissions: create users and groups of users.
8. Normalization
Type of course
Mode
Course coordinators
Learning outcomes
Knowledge
Knows the basic concepts and the concepts of relational databases
Familiar with the basic relational data model
Knows the basic constructs of SQL.
Knows the basic principles of database design.
Skills
She/he can operate the camera conceptual databases.
Can use language in terms of basic SQL.
test
Able to design and implement a simple database.
test
Social competence
Is aware of the role and importance of database systems in the enterprise, the economy and society.
Assessment criteria
Evaluation of the project
Practical placement
lack-of
Bibliography
Bowman J. S. , Darnovsky M., Emerson S. L. : Podręcznik języka SQL. Warszawa 2001.
Celko J.: SQL zaawansowane techniki programowania. Warszawa, 2008
Connolly T., Begg C.: Systemy baz danych. Warszawa, 2004
Date J.C.: Relacyjne bazy danych dla praktyków. Gliwice, 2006
Dudek W.: Bazy danych SQL. Teoria i praktyka. Wydawnictwo Helion 2006.
Jeffrey D. Ullman, Jennifer Widom: Podstawowy kurs systemów baz danych. Gliwice, 2011
Meloni J. C. : PHP, MySQL i Apache dla każdego. Wydanie III. Wydawnictwo Helion 2007
Additional information
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: