Budapest University of Technology and Economics, Faculty of Electrical Engineering and Informatics

A kötelező előtanulmányi rend az adott szak honlapján és képzési programjában található.

Week	Lecture content
1	Introduction, data-driven systems architecture (three-tier architecture).
2	Transactions in data base management systems; the Microsoft SQL Server platform.
3	Advanced SQL language, data base server-side programming (Microsoft SQL Server platform, T-SQL language, stored procedures and triggers).
4	NoSQL data bases, document storage in NoSQL data bases; MongoDB platform, simple operations in MongoDB.
5	Queries and their efficiency in Microsoft SQL Server SQL Server. Execution plans and query optimization.
6	Data dictionaries. Semi-structured data (XML, JSON) storage and handling.
7	Data access layer, object-relational mapping, design patterns in the data access layer (repository).
8	Object relational mapping frameworksin .NET, Entity Framework and Linq to Entity Framework.
9	Object relation frameworks in Java: JPA and QueryDSL
10	Business logic in Java: JavaEE, Spring, SpringData
11	Communication solutions between backend systems and clients: SOAP, REST, graphQL
12	Business logic in .NET: ASP.NET Core platform, middleware services, Web API.
13	Implementing a modern web application: summary of the semester through an example.

During the seminars, held in computer laboratories, students will solve tasks in connection to the lectures:

During the seminars, held in computer laboratories, students will solve tasks in connection to the lectures:

During the semester

1.   One midterm exam

2.   The seminars provide the opportunity to put the gained knowledge into practice. Students must be present at the seminars and work with the instructor.

During the semester there are mandatory homework assignments.  

In order to receive signature for the course, students must:

o    must pass the midterm exam, and

o    the student must be present at the seminars as required by the Code of Study and Exams.

 In the exam period:

Written exam.

Final grade is calculated by summing the exam points, midterm points, and homework obtained during the semester.

The mid-term test can be repeated once during the semester.

There are no repeated seminars. However, absense from seminars is allowed with proof of a good reason, such as illness (with official record of it presented).

Homeworks cannot be repeated.

Exams may be repeated as the Code of Studies allows it.

Leonard Lobel and Andrew Brust: Programming Microsoft SQL Server 2012, Microsoft Press, ISBN: 978-0735658226

·         Grant Fritchey: SQL Server Execution Plans, Simple Talk Publishing, 2012. Ebook: https://www.red-gate.com/products/dba/sql-monitor/entrypage/execution-plans

·         Leonard Lobel and Andrew Brust: Programming Microsoft SQL Server 2012, Microsoft Press, ISBN: 978-0735658226

·         Kristina Chodorow: MongoDB: The Definitive Guide: Powerful and Scalable Data Storage, O'Reilly Media, Second Edition. ISBN 978-1449344689.

·         Mark J. Price: C# 7 and .NET Core: Modern Cross-Platform Development: Create powerful cross-platform applications using C# 7, .NET Core, and Visual Studio 2017 or Visual Studio Code. Packt Publishing, 2nd Edition. ISBN: 978-1787129559.

·         Dino Esposito: Programming ASP.NET Core, Microsoft Press. ISBN 978-1509304417.

·         Mark Pollack, Oliver Gierke, Thomas Risberg, Jon Brisbin, Michael Hunger: Spring Data: Modern Data Access for Enterprise Java. O'Reilly Media, 1st Edition. ISBN-13: 978-1449323950.

·         Subbu Allamaraju: RESTful Web Services Cookbook: Solutions for Improving Scalability and Simplicity. Yahoo Press, 1st Edition. ISBN: 978-0596801687.