Information Systems and Databases

From ER model to advanced SQL, indexes, ACID transactions, and NoSQL. Revised by the UniTO Systems Informatics course (145h audio).

ArticlesPublished 6
Main Tag#database

Prerequisites

  • Discrete Algebra

What you'll learn

  • Model complex ER schemas
  • Write advanced SQL queries (CTE, window)
  • Understand Normalization 3NF/BCNF
  • Choose SQL or NoSQL

Notify articles from Federico Calo's blog on GitHub with Angular and Spring Boot integrationInformation Systems and Databases

Receive an alert when a new article in this series is published.

🤖

Fundamentals of Money Management

Foundations of Machine Learning reworked from university Jupyter notebooks: from basic math to supervised and unsupervised models, with scikit-learn and PyTorch code.

📊

Probability and Statistics

Transcription and summary of the 50 video lessons from the Probability and Statistics course at UniBa. Random variables, distributions, estimation, hypothesis testing, regression.

🏗️

Design Patterns in Production

Six structural and behavioral patterns extracted from LabSAS 2021-22 (UniBa Software Application Development), explained with Java multi-module examples and unit tests.

Go to UniNotesUniversity SectionSuggest correction