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

    címtáras azonosítással

    vissza a tantárgylistához   nyomtatható verzió    

    Informatics 2

    A tantárgy neve magyarul / Name of the subject in Hungarian: Informatika 2

    Last updated: 2022. augusztus 26.

    Budapest University of Technology and Economics
    Faculty of Electrical Engineering and Informatics
    BSc, electrical engineer
    Course ID Semester Assessment Credit Tantárgyfélév
    VIAUAC10 5 3/0/1/f 5  
    3. Course coordinator and department Dr. Csorba Kristóf,
    Web page of the course
    4. Instructors Dr. Csorba Kristóf (associate professor, AUT)
    5. Required knowledge Basic programming skills.
    6. Pre-requisites
    Basics of programming 2. (mandatory)
    7. Objectives, learning outcomes and obtained knowledge

    A student successfully finishing the course will have the theoretical knowledge to create a system consisting of multiple clients, server services, database server and embedded IoT devices using cloud based services. They will be able to implement the system in one specific framework.

    Due to time limitations, beside PHP, the course covers only a fraction of the JavaScript and node.js based development. 

    8. Synopsis

    Introduction (1 week)

     - 1. week: introduction, demo, technology overview, using git version control (to be used during the laboratories)

    Database topic (5 weeks)

    - 2. week: database properties, expectations. Relational databases, schema and SQL basics

    - 3. week: advanced SQL

    - 4. week: database design, ER diagrams, schema

    - 5. week: normal forms, indexes, ORM, transactions

    - 6. week: further topics, object-relational mapping, noSQL databases

    The Internet and its application layer (2 weeks)

    - 7. week: Socket and applications above it: network layers, services of the Internet

    - 8. week: application layer protocols: DNS, SMTP, POP3/IMAP, BitTorrent, FTP

    Web applications (5 weeks)

    - 9. week: The HTTP protocol and the basics of the web, HTML and CSS

    - 10. week: simple server for dynamic web pages. Basics of PHP: generating HTML, database connection

    - 11. week: querystring and POST parameters, HTML FORM, session handling

    - 12. week: furher topics, JavaScript and TypeScript based client and server side technologies

    - 13. week:  further topics, server in the cloud. Basics of cloud technologies, service levels (IaaS, PaaS, BaaS, SaaS), hosting and virtualization, Docker and Kubernetes basics, microservice architectures



    - Design and creation of simple databases, insering data, query, SQL basics

    - Advanced SQL queries, joining, grouping, aggregation, transactions

    - Creating HTML pages and using CSS. Basic HTML tags and styles.

    - Creating a PHP server service, dynamic web page with database connection

    - JavaScript based client and server side development. 

    9. Method of instruction

    Alternating 4 and 2 hour lectures per week, 2 hour laboratory every second week.

    The course takes advantage of the available written and video based materials. The full course material is not mentioned during the lectures, students are expected to learn the online materials as preparation for the lectures.

    The homework is not mandatory, but it can give bonus points either to improve the grades or to receive iMSc points. If the final grade would not be 5, bonus points are used to reach the minimum points for a 5 and the remaining bonus points can be converted to iMSc points. 

    10. Assessment Mid-term exam and at least 4 completed laboratory out of 6.
    11. Recaps

    Failed mid-term exam can be repeated during the term and repeated again during the re-take week.

    Failed laboratories can be re-taken by coordinating it with the teacher and if there is free capacity in other laboratory time slots. After the term labs cannot be retaken.

    As the homework is not mandatory and provides bonus points, its re-take is not possible. 

    12. Consultations A significant time ratio of the lectures can be used as consultations. Furthermore, questions asked on the online platform (Teams) are answered regularly.
    13. References, textbooks and resources
    - Vajk I, Asztalos M, Mészáros T: Informatika 2. Egyetemi jegyzet
    - Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom: Database Systems – The Complete Book, Prentice Hall, 2008
    - Jim Kurose, Keith Ross: Computer Networking: A Top-Down Approach, Addison-Wesley, 2012
    - Andrew S. Tanenbaum, David J. Wetherall: Számítógép-hálózatok. 3. kiadás. Panem Kiadó, Budapest, 2012.
    - Bach Iván: Formális nyelvek. Typotex.
    14. Required learning hours and assignment
    Kontakt óra56
    Félévközi készülés órákra0
    Felkészülés zárthelyire34
    Házi feladat elkészítése(not mandatory)
    Kijelölt írásos tananyag elsajátítása60
    15. Syllabus prepared by

    Dr. Kristóf Csorba, associate professor, AUT


    - Dr. Márk Asztalos, associate professor, AUT

    - Dr. István Vajk, full professor, AUT 

    IMSc program Students in the iMSc program have dedicated laboratories which cover the same basic course material but extend that with more complex tasks which require deeper engineering skills.
    IMSc score iMSc score can be aquired via the homework if the student achieves a grade 5. The maximal number of iMSc score is 25.