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

Yakusheva: /* Important deadlines */

2026-04-30T15:26:21Z

Important deadlines

← Предыдущая версия		Версия от 15:26, 30 апреля 2026
Строка 15:		Строка 15:
	12 May - final test and oral exam		12 May - final test and oral exam

	== Exam program ==:		== Exam program ==

	*1) Definitions: data, database, DBMS. 3 data models.		*1) Definitions: data, database, DBMS. 3 data models.

Yakusheva: /* Important deadlines */

2026-04-30T15:26:09Z

Important deadlines

@@ Строка 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 ==

Yakusheva: /* Important deadlines */

2026-04-14T10:06:11Z

Important deadlines

Yakusheva: /* Important deadlines */

2026-04-14T10:03:29Z

Important deadlines

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

	Exam program:		Exam program:
	1) Definitions: data, database, DBMS. 3 data models.		*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.
	3) SQL. DDL operations: CREATE, ALTER, DROP, DELETE.		3) SQL. DDL operations: CREATE, ALTER, DROP, DELETE.
	4) SQL. DML operations: INSERT, UPDATE, DELETE, SELECT.		4) SQL. DML operations: INSERT, UPDATE, DELETE, SELECT.

Yakusheva: /* Major rules */

2026-04-14T10:03:16Z

Major rules

← Предыдущая версия		Версия от 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 ==

Yakusheva: /* Grading */

2026-04-01T09:15:09Z

Grading

← Предыдущая версия		Версия от 09:15, 1 апреля 2026
Строка 4:		Строка 4:
	* project - 3 points		* project - 3 points
	* final oral exam - from -2 to +5 points		* final oral exam - from -2 to +5 points

			== Course materials ==

			'''[https://drive.google.com/drive/folders/1tg829BHNW2MXByl8K5_F4doVRRLIv9YT?usp=sharing Materials]'''

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

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!

← Предыдущая версия		Версия от 10:06, 14 апреля 2026
Строка 17:		Строка 17:
	Exam program:		Exam program:
	*1) Definitions: data, database, DBMS. 3 data models.		*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.
	3) SQL. DDL operations: CREATE, ALTER, DROP, DELETE.		*3) SQL. DDL operations: CREATE, ALTER, DROP, DELETE.
	4) SQL. DML operations: INSERT, UPDATE, DELETE, SELECT.		*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.		*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.		*6) SQL. JOIN operations. INNER, LEFT, RIGHT, FULL, CROSS. Using JOINs in SELECT.
	7) Ternary logic. NULL values, calculations with NULLs.		*7) Ternary logic. NULL values, calculations with NULLs.
	8) 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.
	9) 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.
	9) Stages of database design. Crow's foot notation.		*10) Stages of database design. Crow's foot notation.
	10) Normalization. 1st, 2nd and 3rd normal forms.		*11) Normalization. 1st, 2nd and 3rd normal forms. Heath's theorem.
	11) Versioning. SCD0-4.		*12) Versioning. SCD0-4. Advantages and disadvantages.
	12) SQL. Views. Definition, syntax, usage.		*13) SQL. Views. Definition, syntax, usage.
	13) 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.
	14) SQL. Query parsing and execution. Query plan.		*15) SQL. Query parsing and execution. Query plan.
	15) 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 ==		== Major rules ==