About Pordalibreqs

Meet the author

Pordalibreqs is developed around the teaching approach of Janis Gailums, a database enthusiast and independent creator of written study materials. His interest in working with data grew from a practical question: how can information be organised so that another person can understand it, find what matters and make thoughtful changes without losing the bigger picture?

Janis began exploring this question through small personal projects, where spreadsheets and scattered notes gradually became too difficult to maintain. He started studying relational tables, keys and SQL queries as ways to keep information consistent. As his interest developed, he spent time experimenting with sample datasets, comparing database structures and turning technical observations into short, readable explanations.

What appealed to him most was not simply learning commands. It was understanding why a table needs a particular identifier, what makes two records related, and how a query can express an everyday question in a precise form. He wanted to turn those ideas into resources that make room for curiosity rather than assuming every learner arrives with a technical background.

Why Pordalibreqs exists

Pordalibreqs grew from the belief that database concepts become easier to study when they are introduced in a sensible order. New learners often meet unfamiliar terms all at once: primary keys, joins, normalisation, transactions and indexes. Here, each subject is given a clear purpose and a manageable collection of examples.

Janis aims to show the reasoning behind each decision. Why separate information into different tables? When should two tables be joined? How do constraints protect the quality of records? The guides encourage readers to examine each question, work through a small example and check whether they can explain the result in their own words.

What the guides cover

The collection contains ten digital, written study guides, beginning with a free introduction to tables, rows, columns and a simple SELECT query. Further guides explore filtering records, table relationships, data modelling, constraints, transactions, reporting queries, indexing, maintenance and applied database design.

Each guide is organised around a defined topic. The course pages describe the expected starting knowledge, the main modules, the learning format and the price. Materials are written for independent study, so readers can pause at a diagram, revisit a concept or practise with a small dataset before moving ahead. Examples focus on understandable situations rather than unnecessarily large systems.

A practical, considered approach

Janis encourages learners to focus on habits that remain useful across different database tools: naming things clearly, checking assumptions, recognising relationships and thinking about the consequences of changing data. He sees a database as more than a collection of commands; it is a way to describe how information fits together.

The guides are not live classes, professional certification or a promise of a particular career result. They are starting points and reference materials for anyone who enjoys understanding the structures behind digital information. Learners are encouraged to try examples in a safe practice environment and consult the documentation for their own database system when details differ.

The goal of Pordalibreqs is simple: give readers a calmer, more structured way to approach data. Whether you begin with your first table or return to refresh a more advanced concept, there is room to read carefully, ask better questions and develop your understanding one relationship at a time.

Explore the collection

Ready to begin? Read the Free Kit or browse all ten guides. For questions about the materials, contact us.