|
|
|
||
Last update: TAJ143 (03.12.2013)
|
|
||
Last update: TAJ143 (25.09.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 (02.07.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 (27.09.2013)
None |
|
||
Last update: ROZ143 (10.05.2011)
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: TAJ143 (02.07.2013)
none |
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 |