Types of Data Modeling in Relational Databases
The main types of data modelling in relational databases: conceptual, logical, physical, hierarchical, network, and star vs snowflake schemas.
PostgreSQL vs MySQL – Which One Should You Choose?
PostgreSQL vs MySQL compared: features, performance, scalability, JSON support and use cases, so you can choose the right database for your app.
Understanding PostgreSQL – The Most Trusted Open-Source Relational Database
Why PostgreSQL is the most trusted open-source relational database: key features, extensions, performance and where it shines in production.
Posted inAzure Big data Microsoft Fabric
Data Analytics Using SQL Analytics Endpoint in Banking
Use a SQL analytics endpoint for banking data analytics: track transactions, customer behaviour and risk with practical SQL query examples.
Posted inAzure Big data Microsoft Fabric
Unleashing the Power of Event Analytics for Real-Time and Time-Based Insights
Event analytics for real-time and historical insights: how to combine streaming and time-based analysis to monitor and act on business events.
Step-by-Step Guide to Transfer Data from Azure Blob to Google Cloud Storage
Step-by-step: transfer data from Azure Blob Storage to Google Cloud Storage with Storage Transfer Service, including bucket setup and permissions.
Posted inAzure Big data Microsoft Fabric
Unlocking Real-Time and Batch Processing with Lambda Architecture
Lambda architecture explained: combine batch and real-time processing layers to analyse data streams, with design tips and trade-offs.
Building a Data Warehouse with BigQuery and Leveraging AI with Vertex AI
Build a data warehouse in Google BigQuery and add generative AI with Vertex AI: architecture, setup and practical analytics examples.
Unleashing the Power of Google Cloud: A Comprehensive Guide for Data Engineers, Analysts, and Data Scientists
A guide to Google Cloud for data engineers, analysts and scientists: BigQuery, Dataflow, Dataproc, Pub/Sub, Vertex AI and how they fit together.
Building a Secure and Scalable Data Pipeline for Pharmaceutical Clinical Trials
Design a secure, scalable data pipeline for pharmaceutical clinical trials, covering compliance, privacy, encryption and cloud architecture.