Databases весна 2026 - История изменений

Yakusheva: /* Important deadlines */

2026-04-30T15:26:21Z

‎Important deadlines

Yakusheva: /* Important deadlines */

2026-04-30T15:26:09Z

‎Important deadlines

Yakusheva: /* Important deadlines */

2026-04-14T10:06:11Z

‎Important deadlines

Yakusheva: /* Important deadlines */

2026-04-14T10:03:29Z

‎Important deadlines

Yakusheva: /* Major rules */

2026-04-14T10:03:16Z

‎Major rules

Yakusheva: /* Grading */

2026-04-01T09:15:09Z

‎Grading

Yakusheva: Новая страница: «== Grading == * practical tasks and quizes - 2 points * project - 3 points * final oral exam - from -2 to +5 points == Major rules == * The project defense is o…»

2026-02-03T13:21:00Z

Новая страница: «== Grading == * practical tasks and quizes - 2 points * project - 3 points * final oral exam - from -2 to +5 points == Major rules == * The project defense is o…»

Новая страница

== Grading ==

* practical tasks and quizes - 2 points
* project - 3 points
* final oral exam - from -2 to +5 points

== Major rules ==
* The project defense is oral and staged.
* DON’T use LLM for your rating tasks! The only exception is generating illustrative images and synthetic data.
* DON’T copy other people’s projects!

@@ Строка 15: / Строка 15: @@
 May - final test and oral exam
-== Exam program ==:
+== Exam program ==
 *1) Definitions: data, database, DBMS. 3 data models.

@@ Строка 15: / Строка 15: @@
 May - final test and oral exam
-Exam program:
+== Exam program ==:
 *1) Definitions: data, database, DBMS. 3 data models.
 *2) Relational data model. Definitions: relation, Cartesian product, attribute, domain, tuple. Relational algebra, operations. Potential, primary, alternative, natural, surrogate, complex keys.
@@ Строка 32: / Строка 33: @@
 *15) SQL. Query parsing and execution. Query plan.
 *16) SQL vs NoSQL databases. Comparison. Key-value stores, graph databases, document stores, column-oriented databases.
 == Major rules ==

@@ Строка 17: / Строка 17: @@
 Exam program:
 *1) Definitions: data, database, DBMS. 3 data models.
-*2) Relational data model. Definitions: relation, Cartesian product, attribute, domain, tuple. Relational algebra, operations.
+*2) Relational data model. Definitions: relation, Cartesian product, attribute, domain, tuple. Relational algebra, operations. Potential, primary, alternative, natural, surrogate, complex keys.
-) SQL. DDL operations: CREATE, ALTER, DROP, DELETE.
+*3) SQL. DDL operations: CREATE, ALTER, DROP, DELETE.
-) SQL. DML operations: INSERT, UPDATE, DELETE, SELECT.
+*4) SQL. DML operations: INSERT, UPDATE, DELETE, SELECT.
-) SQL. SELECT: base syntax. FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT. Rules for using ORDER BY. Execution order.
+*5) SQL. SELECT: base syntax. FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT. Rules for using ORDER BY. Execution order.
-) SQL. JOIN operations. INNER, LEFT, RIGHT, FULL, CROSS. Using JOINs in SELECT.
+*6) SQL. JOIN operations. INNER, LEFT, RIGHT, FULL, CROSS. Using JOINs in SELECT.
-) Ternary logic. NULL values, calculations with NULLs.
+*7) Ternary logic. NULL values, calculations with NULLs.
-) SQL. SELECT with subqueries and CTEs. Difference between a subquery and a CTE. Syntax.
+*8) SQL. SELECT with subqueries and CTEs. Difference between a subquery and a CTE. Syntax: WITH, AS.
-) SQL. Window functions. Difference between aggregating and window functions. Syntax: OVER, PARTITION BY, ORDER BY. 3 groups of window functions, examples.
+*9) SQL. Window functions. Difference between aggregating and window functions. Syntax: OVER, PARTITION BY, ORDER BY. 3 groups of window functions, examples.
-) Stages of database design. Crow's foot notation.
+*10) Stages of database design. Crow's foot notation.
-) Normalization. 1st, 2nd and 3rd normal forms.
+*11) Normalization. 1st, 2nd and 3rd normal forms. Heath's theorem.
-) Versioning. SCD0-4.
+*12) Versioning. SCD0-4. Advantages and disadvantages.
-) SQL. Views. Definition, syntax, usage.
+*13) SQL. Views. Definition, syntax, usage.
-) SQL. Indexes. B-tree and Hash indexes. Complex, partial indexes. Conditions for applying indexes.
+*14) SQL. Indexes. B-tree and Hash indexes. Complex, partial indexes. Conditions for applying indexes.
-) SQL. Query parsing and execution. Query plan.
+*15) SQL. Query parsing and execution. Query plan.
-) SQL vs NoSQL databases. Comparison. Key-value stores, graph databases, document stores, column-oriented databases.
+*16) SQL vs NoSQL databases. Comparison. Key-value stores, graph databases, document stores, column-oriented databases.
 == Major rules ==

@@ Строка 16: / Строка 16: @@
 Exam program:
-) Definitions: data, database, DBMS. 3 data models.
+*1) Definitions: data, database, DBMS. 3 data models.
-) Relational data model. Definitions: relation, Cartesian product, attribute, domain, tuple. Relational algebra, operations.
+*2) Relational data model. Definitions: relation, Cartesian product, attribute, domain, tuple. Relational algebra, operations.
 ) SQL. DDL operations: CREATE, ALTER, DROP, DELETE.
 ) SQL. DML operations: INSERT, UPDATE, DELETE, SELECT.

← Предыдущая		Версия 10:03, 14 апреля 2026
Строка 8:		Строка 8:

	'''[https://drive.google.com/drive/folders/1tg829BHNW2MXByl8K5_F4doVRRLIv9YT?usp=sharing Materials]'''		'''[https://drive.google.com/drive/folders/1tg829BHNW2MXByl8K5_F4doVRRLIv9YT?usp=sharing Materials]'''
		+
		+	== Important deadlines ==
		+
		+	05 May - final project deadline
		+
		+	12 May - final test and oral exam
		+
		+	Exam program:
		+	1) Definitions: data, database, DBMS. 3 data models.
		+	2) Relational data model. Definitions: relation, Cartesian product, attribute, domain, tuple. Relational algebra, operations.
		+	3) SQL. DDL operations: CREATE, ALTER, DROP, DELETE.
		+	4) SQL. DML operations: INSERT, UPDATE, DELETE, SELECT.
		+	5) SQL. SELECT: base syntax. FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT. Rules for using ORDER BY. Execution order.
		+	6) SQL. JOIN operations. INNER, LEFT, RIGHT, FULL, CROSS. Using JOINs in SELECT.
		+	7) Ternary logic. NULL values, calculations with NULLs.
		+	8) SQL. SELECT with subqueries and CTEs. Difference between a subquery and a CTE. Syntax.
		+	9) SQL. Window functions. Difference between aggregating and window functions. Syntax: OVER, PARTITION BY, ORDER BY. 3 groups of window functions, examples.
		+	9) Stages of database design. Crow's foot notation.
		+	10) Normalization. 1st, 2nd and 3rd normal forms.
		+	11) Versioning. SCD0-4.
		+	12) SQL. Views. Definition, syntax, usage.
		+	13) SQL. Indexes. B-tree and Hash indexes. Complex, partial indexes. Conditions for applying indexes.
		+	14) SQL. Query parsing and execution. Query plan.
		+	15) SQL vs NoSQL databases. Comparison. Key-value stores, graph databases, document stores, column-oriented databases.

	== Major rules ==		== Major rules ==

@@ Строка 4: / Строка 4: @@
 * project - 3 points
 * final oral exam - from -2 to +5 points
 == Major rules ==