Blog

Notes on databases, programming, and exam preparation.

Matura 2025 zadanie 3

Solution walkthrough for Matura 2025 task 3 in C++: vector geometry, GCD, and file I/O patterns for the exam.

C++MaturaAlgorithms

MySQL - Constraints

MySQL column constraints: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, DEFAULT, AUTO_INCREMENT, and CHECK with practical examples.

MySQLSQLConstraints

MySQL dane

Working with data in MySQL: INSERT INTO, SELECT, UPDATE, DELETE, WHERE, ORDER BY, LIMIT, and practical query patterns.

MySQLSQLQueries

MySQL - Data Types

Reference of MySQL data types: numeric (INT, DECIMAL, FLOAT), string (CHAR, VARCHAR, TEXT), date/time, boolean, and binary types with ranges and byte sizes.

MySQLSQLData Types

MySQL - Tabele

Working with tables in MySQL: quoting identifiers, comments, CREATE/ALTER/DROP statements, and table management.

MySQLSQL

MySQL Workbench instalacja

Step-by-step guide to installing MySQL Server, MySQL Workbench, and MySQL Shell on Windows as a complete development environment.

MySQLSetup

Ostatnia chwila na maturze: C++

Quick-reference C++ snippets for the matura exam: file I/O, vectors, sorting, and common algorithmic patterns.

C++MaturaReference

Ostatnia chwila na maturze: Python

Quick-reference Python snippets for the matura exam: file I/O, list operations, sorting, and common algorithmic patterns.

PythonMaturaReference

Ostatnia chwila na maturze: Teoria

Exam-prep theory notes: web protocols (HTTP/HTTPS/FTP), file formats, encoding, and computer science fundamentals.

MaturaTeoria

Wprowadzenie do baz danych

Overview of relational (SQL) vs non-relational (noSQL) databases, their core concepts, and the functional operations available in SQL.

SQLBaza danychTeoria