|
|
|
||
Within the lecture, the student gets introduced to the fundamental methodology of correct relational database design, efficient access to data and transactional processing. The SQL language will be introduced for the students to be able to build databases and query them. All the acquired knowledge will be practiced on a chosen database platform (Microsoft SQL Server).
Last update: TAJ143 (03.12.2013)
|
|
||
Students will be able to: Model database systems Create database using SQL Query database using SQL Create extended logic on top of database systems (T-SQL) Last update: TAJ143 (25.09.2013)
|
|
||
R: Ramakrishnan R., Gehrke J.: Database Management Systems, McGraw-Hill Science/Engineering/Math; 3 edition, 2002, 0072465638 R: SQL Server Books Online, http://msdn.microsoft.com/en-us/library/ms130214.aspx
A: Vieira, R.: Beginning Microsoft SQL Server 2008 Programming (Wrox Programmer to Programmer), Wrox, 2009, 0470257016 Last update: TAJ143 (02.07.2013)
|
|
||
None Last update: TAJ143 (27.09.2013)
|
|
||
V průběhu semestru se budou psát 3 zápočtové testy. Na konci semestru studenti skládají písemnou zkoužku. Last update: ROZ143 (10.05.2011)
|
|
||
1. Introduction, motivation, conceptual modeling. 2. Relations, correct relational database system design, normalization 3. SQL language – DDL + basics of DQL 4. SQL language – joins I. 5. SQL language – joins II. 6. SQL language – aggregation I. 7. SQL language – aggregation II. 8. Efficient data access – indexing. 9. Optimization in SQL. 10. T-SQL language – fundamentals. 11. T-SQL language – procedures I. 12. T-SQL language – procedures II. 13. T-SQL language – triggers. 14. Database-application interface. Last update: ROZ143 (10.05.2011)
|
|
||
none Last update: TAJ143 (02.07.2013)
|
Teaching methods | ||||
Activity | Credits | Hours | ||
Příprava na přednášky, semináře, laboratoře, exkurzi nebo praxi | 1.5 | 42 | ||
Příprava na zkoušku a její absolvování | 1 | 28 | ||
3 / 4 | 70 / 112 |
Coursework assessment | |
Form | Significance |
Examination test | 100 |