Analytics Architectures on Microsoft Fabric
Explore diverse analytics architectures, their pros and cons, and how Microsoft Fabric supports their implementation for effective data analysis.
New Features in Power Query for Power BI, Fabric, and Excel
Discover the latest Power Query features in Power BI Desktop, Fabric Dataflows, and Excel, enhancing data transformation capabilities.
Understanding Jsonb Performance in PostgreSQL
Explore jsonb performance in PostgreSQL, learn optimization techniques, and discover ways to enhance efficiency for modern projects using this popular data type.
Call Me Back, Postgres - Using Triggers and Notifications in Rails
Explore Postgres triggers as an alternative to Active Record callbacks, leveraging listen and notify features for seamless data syncing in Rails applications.
Your Service Layer Needn't be Fancy, It Just Needs to Exist - RailsConf 2022
Learn to create a service layer in Rails for sustainable business logic, separating UI from database and enhancing app longevity without complex patterns or libraries.
The Very Hungry Transaction - Avoiding Dangerous Patterns in Database Transactions
Explore database transaction pitfalls and best practices to safeguard data integrity and application performance in Rails applications.
How to Implement Accessibility for Back-End Developers
Descubre cómo los desarrolladores backend pueden mejorar la accesibilidad para usuarios y colegas, más allá de las responsabilidades frontend tradicionales.
A Deep Dive into the dbt Manifest
Explore dbt's manifest.json file, its production, and applications in data pipelines. Learn about deployment configurations, quality enforcement, and streamlined development workflows using real-world examples.
Cubing and Metrics in SQL - Extending Apache Calcite for Advanced Analytics
Explore Apache Calcite's SQL extensions for metrics, measures, and analytic expressions. Learn to define data models, use them in queries, and perform cross-dimensional calculations for advanced analytics.
Building InfluxDB 3.0 with Apache Arrow, DataFusion, Flight and Parquet
Explore InfluxDB 3.0's innovative design using Apache Arrow, DataFusion, Flight, and Parquet. Discover how this deconstructed database system enables fast, high-quality data analysis and advanced interoperability.
Building a GraphQL API - Beyond the Basics
Explore advanced GraphQL API development in Drupal, covering schema design, operations implementation, and modular API construction for enhanced usability and functionality.
Introduction to Azure Cosmos DB
Explore Azure Cosmos DB's features, benefits, and comparisons with other databases. Learn access methods and evaluate pros and cons for informed database decisions.
Understanding System Design and Architecture - Blueprints of Efficiency
Explore fundamental principles of system design and architecture, mastering techniques for creating robust, scalable solutions that stand the test of time.
Quantum Mechanics: Particle in a 2D Box with 3D Plot
Explore quantum mechanics through a 2D particle in a box, from theory to Python visualization. Master concepts like time dependence, normalization, and degeneracy with step-by-step explanations.
Modelling Weak Entities and Design Choices
Learn to model weak entities and make effective design choices in database systems, enhancing your data modeling skills.
Normal Forms - Introduction
Explore the fundamental concepts of normal forms in database design, enhancing your understanding of data organization and efficiency.
Convert ER-Model to a Relational Model
Learn to transform ER-Models into Relational Models, enhancing your database design skills and understanding of data structure conversion techniques.
Introduction to Entity Relationship Model
Learn about the Entity Relationship Model, including entities, attributes, relationships, and diagrammatic notation for effective database design and modeling.
Entities and Relationships in Database Design
Explore entity relationships, cardinality ratios, participation constraints, and structural notations in database design. Master key concepts for effective data modeling.
How Data Platforms Affect Machine Learning and Artificial Intelligence - MLOps Podcast
Explore how data platforms impact AI and ML applications, covering foundations, design patterns, data quality, and team structures for effective ML implementation.
Mapping from Training Data to Predictions with Datamodels - Differential Privacy in Machine Learning
Explore datamodels in machine learning, from training data to predictions. Learn about model brittleness, data counterfactuals, and applications in ML pipelines.