Infotechnology

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

    • _________________________________________________________________

    PRAKTIKUMID:

  • Praktikum nr 1 -->

 

web tracker