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.
MySQL - Constraints
MySQL column constraints: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, DEFAULT, AUTO_INCREMENT, and CHECK with practical examples.
MySQL dane
Working with data in MySQL: INSERT INTO, SELECT, UPDATE, DELETE, WHERE, ORDER BY, LIMIT, and practical query patterns.
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.
MySQL - Tabele
Working with tables in MySQL: quoting identifiers, comments, CREATE/ALTER/DROP statements, and table management.
MySQL Workbench instalacja
Step-by-step guide to installing MySQL Server, MySQL Workbench, and MySQL Shell on Windows as a complete development environment.
Ostatnia chwila na maturze: C++
Quick-reference C++ snippets for the matura exam: file I/O, vectors, sorting, and common algorithmic patterns.
Ostatnia chwila na maturze: Python
Quick-reference Python snippets for the matura exam: file I/O, list operations, sorting, and common algorithmic patterns.
Ostatnia chwila na maturze: Teoria
Exam-prep theory notes: web protocols (HTTP/HTTPS/FTP), file formats, encoding, and computer science fundamentals.
Wprowadzenie do baz danych
Overview of relational (SQL) vs non-relational (noSQL) databases, their core concepts, and the functional operations available in SQL.
Blue Void