Row Level Security Explained - Performance and Application in PostgreSQL
Explore PostgreSQL's Row-Level Security: functionality, use cases, and implementation. Learn about leakproof functions and performance optimization techniques.
Advanced Int-Bigint Conversions in PostgreSQL - Preventing Integer Overflow
Explore advanced techniques for handling integer overflow in databases, including prevention strategies and solutions for pending int overflow issues.
Do It in SQL: pgbouncer_wrapper - Controlling pgbouncer with SQL Commands
Learn to control pgbouncer with SQL commands using pgbouncer_wrapper. Explore its capabilities, get inspired, and contribute to its improvement.
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.
PowerShell with SQL Statement Data Gathering - PowerShell Summit 2023
Explore SQL data gathering techniques in PowerShell to enhance your scripting capabilities and streamline database interactions.
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.
Data Warehouses are Gilded Cages - What Comes Next
Explore DuckDB's potential to revolutionize data analytics, shifting from centralized warehouses to powerful local processing. Learn how this approach can enhance efficiency and user control in data management.
CDC Stream Processing with Apache Flink
Explore Apache Flink's capabilities as a data integration hub, focusing on its SQL engine for changelog processing, CDC data handling, and materialized view maintenance. Learn about data source semantics and system integrations.
How to Build a Streaming Database in Three Challenging Steps
Explore the foundational choices and trade-offs in building a streaming database with Frank McSherry, Chief Scientist at Materialize. Learn manageable approaches to this complex task.
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 an Open Data Service Layer with Arrow, DuckDB and Semantic Layer
Explore FlexQuery, an open-source solution revolutionizing data services with Arrow, DuckDB, and semantic layers. Learn to create high-performance, scalable analytics environments using Python and cutting-edge technologies.
Building a Unified Feature Platform with DuckDB and Arrow
Explore ML feature platform development using DuckDB and Arrow. Learn scaling strategies, DuckDB extension implementation, DeltaLake interoperability, and performance comparison with Spark.
Flappybird Game and Real-Time Data Pipeline Workshop - Tinybird
Build a real-time data pipeline for Flappybird's leaderboard. Capture in-game events, stream data, and create REST APIs while enhancing SQL skills in this hands-on workshop.
Basics of SQL Queries and Query Optimization
Master SQL fundamentals and query optimization techniques for efficient database management and manipulation across various relational database management systems.
Introduction to Liquibase
Learn the basics of Liquibase, an open-source tool for managing database schema changes. Explore its usage, advantages, and how it tracks and applies updates across different database systems.
Azure SQL: Creating and Migrating to SQL Managed Instance
Explore Azure SQL, create a SQL Managed Instance, and migrate on-premises MySQL schemas to the cloud platform for enhanced database management.
Monitoring Azure SQL with Azure Monitor and Managed Grafana
Learn to monitor Azure SQL using Azure Monitor and visualize metrics with Managed Grafana for effective database performance tracking and management.
Messing with MySQL - A Quick Tutorial on SQL Basics
Explore MySQL basics: DDL, DML commands, constraints, joins, aggregate functions, and clauses. Master essential SQL skills for effective database management.
PHP-MySQL Database Connection Using MySQLi Extension - INSERT, UPDATE, DELETE, SELECT Demo
Learn to connect PHP with MySQL using mysqli, perform CRUD operations, and see practical demonstrations of database interactions.
PL/SQL Introduction - Anonymous Blocks, Procedures, and Control Statements - Session 1
Learn PL/SQL fundamentals: blocks, procedures, conditional statements, and case expressions. Master essential concepts for Oracle database programming and development.
Uses of Renaming, Join and Division in Relation Algebra
Explore advanced relational algebra operations: renaming, join, and division. Master their applications for efficient database manipulation and querying.