| Course Unit Code | 638-3004/03 |
|---|
| Number of ECTS Credits Allocated | 5 ECTS credits |
|---|
| Type of Course Unit * | Optional |
|---|
| Level of Course Unit * | Second Cycle |
|---|
| Year of Study * | Second Year |
|---|
| Semester when the Course Unit is delivered | Winter Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| OVC37 | Ing. Romana Garzinová, Ph.D. |
| Summary |
|---|
| A subject is focused to create T-SQL queries in database server MS SQL Server 2012 and basic database applications design using ADO. NET. Students will be familiar with data presentation in term of APS.NET, WPF and further will be described a distributed application (SOA) with help of WCF. |
| Learning Outcomes of the Course Unit |
|---|
Student will be able to create basic database query in T-SQL.
Student will understand database application design in MS.NET Framework environment.
Student will be able to effectively design and use database models in MS SQL Server.
Student will be able to process data in various application environments. |
| Course Contents |
|---|
1. A subject introduction – methods of data collection, general 3-layer architecture and modern technological trend of software development.
2. Acquaint with MS SQL 2012 architecture and basic structure of T-SQL query.
3. Data acquisition from one or more data sources (SELECT, JOIN).
4. Sorting and data filtering. Working with data types. Application of system functions in query. Grouping and data aggregation.
5. Application of procedures for activation, using and working with saved procedures in SQL Server.
6. Query optimization, exceptions treatment, errors detection and transact data processing.
7. Introduction to MS .NET Framework, Object-Oriented Programming.
8. Core C# Programming.
9. Database applications design of in ADO .NET.
10. EDM (Entity Data Model) – working with entity data models in MS .NET environmnet.
11. SOA – Service Oriented Architecture.
12. WCF – distribute systems design in .NET.
13. ASP .NET- web technology for data presentation.
14. WPF, WinForm – data presentation in MS Windows. |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
TROELSEN, Andrew W. Pro C# 5.0 and the .NET 4.5 Framework. 6th ed. New York: Apress, c2012. ISBN 978-1-4302-4234-5.
SHARP, J. Microsoft Windows Communication Foundation step-by-step [CD-ROM]. Redmond: Microsoft Press, c2007. ISBN 978-0-7356-2336-1.
|
GARZINOVÁ, R. Tvorba databázových aplikací [CD-ROM]. Ostrava: Vysoká škola báňská - Technická univerzita Ostrava, 2015. ISBN 978-80-248-3712-3.
TROELSEN, Andrew W. Pro C# 5.0 and the .NET 4.5 Framework. 6th ed. New York: Apress, c2012. ISBN 978-1-4302-4234-5.
LACKO, Ľ. Mistrovství v SQL Server 2012: [kompletní průvodce databázového experta]. Brno: Computer Press, 2013. ISBN 978-80-251-3773-4.
SHARP, J. Microsoft Windows Communication Foundation step-by-step [CD-ROM]. Redmond: Microsoft Press, c2007. ISBN 978-0-7356-2336-1.
|
| Recommended Reading: |
|---|
ERL, T. SOA: principles of service design. Upper Saddle River: Prentice Hall, c2008. ISBN 978-0-13-234482-1.
|
ERL, T. SOA: servisně orientovaná architektura. Přeložil O. BAŠE, přeložil L. KREJČÍ. Brno: Computer Press, 2009. ISBN 978-80-251-1886-3.
KROENKE, D. a D. J. AUER. Databáze. Brno: Computer Press, 2015. ISBN 978-80-251-4352-0.
|
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials, Project work |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Credit and Examination | Credit and Examination | 100 (100) | 51 |
| Credit | Credit | 35 | 25 |
| Examination | Examination | 65 | 26 |