Relational databases

Databases and basic concepts
Real world. Entity (object, individual). Entity properties (attribute, attribute value). Relation (connection). Value domain. Mappings. Unstructured and structured data sets. File. Database. Database management software systems. Database creation process. Database exploitation. Data models and database modeling. Client-server architecture of modern databases.
Theoretical foundations of the relational data model
Characteristics of the relational data model. Relational database management systems. Basic concepts of the relational data model (entity, entity type, attribute, value domain, relational schema, relation (table), n-tuple, primary key, foreign key, relational integrity, etc.). Graphical and tabular interpretation of relations. Representation of the relational database model. Indexes. Views. Codd's rules.
Data and data value domains in the relational data model for business purposes:
Information. Information. Knowledge Wisdom. Meta data. Data types in a relational database (value domains). Derivation of individuals, attributes and value domains from business documentation. Common attribute value domains in business documentation.
Relational design and modeling of the business segment of the real world:
Concept of relational database modeling. Methods of modeling relational databases (abstraction, classification, generalization, specialization, aggregation, combination). Principles of relational database modeling (definition of attributes and domains of attribute values, selection of primary key (simple and complex key, candidate keys, super key), recognition of dependencies between key and non-key attributes, definition of relational schema, recognition of transitive, ambiguous and conjunctive dependencies between attributes, connection of relations into a complete model, etc.). Relational integrity. Modeling of business documentation and business processes (business structure models, business event log models). Introduction of codes. Normalization of relational databases (horizontal and vertical normalization). Decomposition of the relational schema by vertical normalization (1NF, 2NF, 3NF, BCNF, 4NF, 5NF). Tricks for simpler and more successful modeling of business databases.
Structured language for working with relational databases (SQL):
Structure of SQL. Use of instructions for creating tables in a relational database (CREATE, DROP, ALTER). Advanced use of instructions for manipulating data in a relational database (INSERT, UPDATE, DELETE). Advanced use of the instruction to retrieve data from the database (SELECT). Instructions for granting and revoking rights to users. Transaction control instructions. Functions. Triggers.
Relational algebra and the relationship between relational algebra and SQL:
The concept of relational algebra. Compound. Classic algebraic operations (union, intersection, difference, Cartesian product). Special operations of relational algebra (selection, projection, joining, division)
Relational data model in business practice:
Connecting the relational model with software solutions. Production databases. Analytical databases. Choosing the optimal relational database management system. Life cycle of a relational database.
Introduction to a specific relational database management system:
Connecting to a relational database management system. Databases in a relational database management system. Using SQL in a relational database management system.

1. To analyze a segment of the real (business) world by differentiating the concepts within that segment that are in the function of relational database modeling.
2. Model a segment of the real world from the business domain in the form of a relational schema in pseudo code
3. Create a usable relational database using SQL in a database management system
4. Retrieve data from the relational database in the function of business decision-making
5. Create a piece of program code that functions to access, write, correct, delete, retrieve, metadata, and data.
6. Evaluate the business usability of the available database.