Informatics 2

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

Laboratories:

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