|
Lecturer(s)
|
-
Šilhavý Petr, doc. Ing. Ph.D.
-
Prokopová Zdenka, doc. Ing. CSc.
|
|
Course content
|
- Introduction and basic terms - Database modeling - Relational data model - Normalization and DB design procedures - Basic knowledge of SQL language and table creation - Working with data - modification and selection - Querying multiple tables - Aggregation and system functions - Nested queries - Advanced features of Select - Programming objects using T-SQL - Triggers and transaction processing - Database security
|
|
Learning activities and teaching methods
|
|
Monologic (Exposition, lecture, briefing), Dialogic (Discussion, conversation, brainstorming), Methods for working with texts (Textbook, book), Demonstration, Exercises on PC, Practice exercises
|
| prerequisite |
|---|
| Knowledge |
|---|
| Basic knowledge from mathematics, informatics and programming. |
| Basic knowledge from mathematics, informatics and programming. |
| learning outcomes |
|---|
| define the principle of relational database systems |
| define the principle of relational database systems |
| list the types of links in relational databases |
| list the types of links in relational databases |
| explain the procedure of designing the structure of a simple relational database |
| explain the procedure of designing the structure of a simple relational database |
| describe the options for securing stored data |
| describe the options for securing stored data |
| characterize transactional data processing |
| characterize transactional data processing |
| Skills |
|---|
| design a conceptual, logical, and physical model of a simple relational database |
| design a conceptual, logical, and physical model of a simple relational database |
| apply SQL query language commands |
| apply SQL query language commands |
| implement inserting, updating, and deleting data |
| implement inserting, updating, and deleting data |
| retrieve, sort, and process the required information from stored data |
| retrieve, sort, and process the required information from stored data |
| create simple procedures and triggers |
| create simple procedures and triggers |
| teaching methods |
|---|
| Knowledge |
|---|
| Practice exercises |
| Demonstration |
| Dialogic (Discussion, conversation, brainstorming) |
| Dialogic (Discussion, conversation, brainstorming) |
| Monologic (Exposition, lecture, briefing) |
| Monologic (Exposition, lecture, briefing) |
| Exercises on PC |
| Exercises on PC |
| Demonstration |
| Practice exercises |
| Methods for working with texts (Textbook, book) |
| Methods for working with texts (Textbook, book) |
| assessment methods |
|---|
| Systematic observation of the student |
| Systematic observation of the student |
| Conversation |
| Conversation |
| Written examination |
| Grade (Using a grade system) |
| Analysis of the student's performance |
| Analysis of the student's performance |
| Written examination |
| Grade (Using a grade system) |
|
Recommended literature
|
-
BEN-GAN, Itzik. T-SQL fundamentals. Redmond, WA, 2016. ISBN 978-1509302000.
-
DAVIDSON, Louis a Jessica M. MOSS. Pro SQL server relational database design and implementation. New York, 2016. ISBN 9781484219720.
-
PETKOVIC, Dusan. Microsoft SQL Server 2016: a beginner's guide. New York, 2016. ISBN 978-1259641794.
|