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

C# and SQL knowledge is required

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

The goal of this course if to teach students the most commonly used techniques in developing data-driven and backend systems. Students will learn various methods for implementing systems built on data bases, typical solutions and techniques in the data access and business logic layers. The course presents the usage of various data base management systems in complex software development scenarios, and details the processes and solutions used by modern data managing (backend) applications.

Obtainable knowledge:
By completing the course, students are familiarized with the most commonly used data base engines (Microsoft SQL Server and MongoDB), their structure and operation, writing efficient SQL queries, optimizing them, handling transactions, locks, the proper usage of isolation levels, and server side programming techniques (stored procedures, triggers). Various data access libraries are presented (including ADO.NET), as well as commonly used ORM frameworks (such as Entity Framework and JPA).   The course presents serialization techniques of server-side objects (XML, JSON), and protocols for accessing such objects remotely (Web Service, REST), including the software environments (like ASP.NET Core Web API).

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

Lectures and seminars. The lectures may build upon material to process and learn at home.

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 opportunities to complete optional homework assignments.  By completing these optional homeworks extra points can be earned, that are added to the exam results.

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 and the extra points obtained during the semester. The final grade is: 0-40p fail, 41-55p pass, 56-70p satisfactory, 71-85p good, 86-100p very good.

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.

Arranged on demand by the lecturer or instructor.

·         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.