https://dokuwiki.jedich.it/ 2026-07-02T06:47:13+00:00 https://dokuwiki.jedich.it/ https://dokuwiki.jedich.it/lib/tpl/dokuwiki/images/favicon.ico text/html 2023-01-06T09:51:42+00:00 Anonymous (anonymous@undisclosed.example.com) https://dokuwiki.jedich.it/doku.php?id=databases:cheatsheet&rev=1672995102&do=diff Cheat Sheet Basic SELECT column_name(s) FROM table_name WHERE Clause SELECT column_name(s) FROM table_name WHERE column_name operator value AND/OR Operators SELECT column_name(s) FROM table_name WHERE column_name operator value AND/OR column_name operator value text/html 2022-12-29T17:12:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://dokuwiki.jedich.it/doku.php?id=databases:definitons&rev=1672330351&do=diff Definitions On this page you will get an overview of the used terms and phrases in this part of the dokuwiki. Redundancy In the context of databases, redundancy refers to the repetition of data within a database. This can occur at different levels, such as within a single field of a record, within multiple records in the same table, or even across multiple tables. text/html 2022-12-22T16:22:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://dokuwiki.jedich.it/doku.php?id=databases:normalization&rev=1671722550&do=diff Normalization Normalization is an important concept in database design, as it helps to organize the data in a database in a way that reduces redundancy, inconsistency and introduces dependency. The process is used to minimize this problems by organizing the data into smaller, more cohesive units. By following the principles of normalization, it is possible to design a database that is more efficient, accurate, and easier to maintain. text/html 2022-12-29T16:37:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://dokuwiki.jedich.it/doku.php?id=databases:overview&rev=1672328272&do=diff Databases Databases are an essential part of modern computing systems. A database is a collection of organized data, stored and accessed electronically. It allows us to store, retrieve, and manipulate large amounts of information efficiently and accurately. text/html 2022-12-21T19:04:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://dokuwiki.jedich.it/doku.php?id=databases:relational_databases&rev=1671645867&do=diff Relational Databases The main difference between relational databases and other types of databases is the way that data is organized and stored. Relational databases are organized using tables, rows, and columns, and they allow data to be stored in a structured and logical manner. text/html 2023-01-06T08:03:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dokuwiki.jedich.it/doku.php?id=databases:sidebar&rev=1672988596&do=diff Home Overview Relational Databases Definitions Normalization Cheat Sheet