Andmebaasisüsteemid (Database Processing)

    Homework nr 1:-->
    	Homework nr 2:-->
    		Homework nr 3:-->
    Databases in general.Designing relational databases. SQL querying. NoSQL databases. Securing SQL. Database versioning and migrations. Indexes
  • Lecture nr 1 (slides)-->

  • Virtual disk for virtual machine-->

  • PhpMyAdmin Tutorial-->

  • _________________________________________________________________

  • Lecture nr 2 (slides). Tables and Normal Forms: 1NF, 2NF, 3NF. "Database normalization, or simply normalization, is the process of organizing the columns (attributes) and tables (relations) of a relational database to reduce data redundancy and improve data integrity. Normalization is also the process of simplifying the design of a database so that it achieves the optimal structure. It was first proposed by Edgar F. Codd, as an integral part of a relational model" (ref wikipedia). -->

  • Lecture nr 2 (slides). Functional Dependency and Normalization-->

  • Praktikum-->

  • _________________________________________________________________

  • pgAdmin. "Leading Open Source management tool for Postgres, the world’s most advanced Open Source database. pgAdmin 4 is designed to meet the needs of both novice and experienced Postgres users alike, providing a powerful graphical interface that simplifies the creation, maintenance and use of database objects.". -->

  • Lesson 3 -->

  • EDB Postgres "By offering Postgres, a tested and proven database with the enterprise capabilities necessary to manage multi-model data, connect with existing systems and deploy rapidly across multiple environments, EnterpriseDB provides everything you need to succeed as a digital business. For enterprises of all sizes, EnterpriseDB is the most complete open source based data platform for Digital Business.". -->

  • MongoDB Docs-->

  • JSON or JavaScript Object Notation -->

  • PostgreSQL Tutorial-->

  • SQL Tutorial-->

  • _________________________________________________________________


  • Praktikum nr 1 -->