|
|
|
||
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 in order 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: SMIDOVAL (24.07.2012)
|
|
||
Studenti budou schopni:
Last update: HOKSZAD (19.11.2012)
|
|
||
Ramakrishnan R., Gehrke J.: Database Management Systems, McGraw-Hill Science, 2003 SQL Server Books Online, http://msdn.microsoft.com/en-us/library/ms130214.aspx Vieira, R.: Beginning SQL Server 2005 Programming, Wrox, 2006 Last update: SMIDOVAL (24.07.2012)
|
|
||
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: SMIDOVAL (24.07.2012)
|
|
||
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: SMIDOVAL (24.07.2012)
|