Nowa Era — Tworzenie baz danych i administrowanie bazami danych. E.14.2. Podręcznik is an educational textbook that covers fundamentals and applied topics in database design, implementation and administration. The manual explains core concepts of relational databases, data modelling, SQL usage, user and permission management, backup and recovery strategies, and routine administrative tasks. It is structured to guide learners from theory to practical exercises, supporting classroom study and self-paced learning for students and IT practitioners.
Advantages
The textbook presents database concepts and administrative procedures in a structured and sequential manner, balancing theoretical explanations with practical examples and exercises. Content is focused on real-world tasks such as schema design, query construction, user access control and maintenance routines, which helps readers develop applicable skills. The manual's clear language and step-by-step approach make it suitable for classroom use, laboratory practice and individual study.
Suitable for
- Students studying database systems or information technology courses
- IT practitioners learning or refreshing database administration skills
- Teachers and laboratory instructors preparing coursework and exercises
- Self-learners preparing for practical tasks in database design and management
Key specifications
- Subject focus: database creation, administration and practical SQL usage
- Topics covered: data modelling, relational schema design, SQL queries, user and permission management, backup and recovery
- Educational level: secondary and higher education / vocational training support
- Format: textbook with explanatory chapters and practical exercises
How to use
Use the textbook as a course companion or self-study guide by progressing through chapters in order: start with conceptual foundations and data modelling, continue with SQL query construction and schema implementation, and then study administration topics such as user management and backup procedures. Follow the practical exercises after reading theoretical sections to reinforce understanding and apply procedures in a database environment. Instructors can adopt exercises for classroom labs and assess practical assignments based on the tasks provided.
Usage recommendations
For effective learning, pair the textbook with a relational database system (e.g., a widely used open-source or commercial DBMS) to practice SQL statements, schema creation and administrative routines. Work through exercises in a controlled environment, back up practice databases before performing destructive operations, and consult instructor notes or supplementary materials where available.
