The 7 Deadly PostgreSQL Mistakes and New Features in PostgreSQL 14
Explore common PostgreSQL mistakes and discover new features in version 14, enhancing database management skills and optimizing performance.
Learn SQL - From Absolute Scratch to Advanced Queries
Master SQL fundamentals in 47 minutes: create databases, tables, perform queries, use joins, and format results. Ideal for beginners seeking a quick, comprehensive introduction to SQL.
The Very Hungry Transaction - Managing Growing Database Operations
Explore how database transactions can grow into liabilities, uncovering problematic patterns that risk data integrity and offering strategies to fix and prevent these issues.
Implementing Native Composite Primary Key Support in Rails 7.1
Discover how to leverage composite primary keys in Rails 7.1 to enhance database performance and optimize your applications, with insights on implementation and practical use cases.
Leveraging Computational Storage for Simulation Science Storage System Design
Explore how computational storage innovations at Los Alamos National Laboratory overcome bottlenecks in simulation science, featuring implementations with ZFS offloads, flash key-value storage, and SQL-like processing.
Row-level Modifications at Petabyte-scale via Impala on Iceberg
Discover how to perform efficient row-level modifications on massive datasets using Impala with Apache Iceberg, enabling petabyte-scale data management and manipulation.
Integrating AI with Real-time Data and RAG - Part 2
Dive into practical methods for integrating fine-tuned AI systems with external data sources, focusing on Retrieval Augmented Generation (RAG) and real-time data connectivity for enhanced AI applications.
Evaluating LLMs as AI Reasoning Agents - A Performance Comparison Study
Explore how different LLMs perform as AI agents in real-world tasks, comparing their effectiveness in database interactions, web bookings, and online product comparisons.
LangChain - Integrating External Documents and SQL with GPT-4
Dive into LangChain's capabilities for integrating external documents and SQL with GPT-4, learning to chain multiple data sources and leverage advanced language models effectively.
Analyzing and Visualizing OpenTelemetry Traces with SQL
Hands-on workshop exploring OpenTelemetry trace analysis using SQL and Grafana. Learn to ingest, query, and visualize distributed system data for powerful insights and proactive issue detection.
Getting AI to Do Things I Can't - Automatically Searching and Explaining Patterns in Text
Explore techniques for leveraging AI in complex NLP tasks, including pattern searching and SQL labeling, while enabling effective human oversight and uncovering unexpected insights.
Hugging Face Workshops - Pretraining Language Models & CodeParrot
Explore pretraining language models and CodeParrot, a code-writing AI. Learn data transformation, batching, evaluation, and tackle coding challenges in this hands-on workshop.
LangChain and OpenAI for Querying Databases and CSV Files with Natural Language
Learn to query databases and CSV files using natural language with LangChain and OpenAI, converting English to SQL or pandas commands for efficient data retrieval and analysis.
Vulcanize DB - Storing Ethereum State in Postgres with IPFS/IPLD
Explore innovative blockchain data storage using IPFS/IPLD and Postgres, enabling efficient querying and proof construction for Ethereum and other networks.
Additional Relational Algebra Operations
Explore advanced relational algebra operations including aggregate functions, recursive closure, outer joins, and outer unions. Enhance your database management skills with practical examples.
Database Fundamentals for Beginners - Database Tutorial
Comprehensive introduction to database concepts, covering normalization, relational databases, SQL, and administration fundamentals. Ideal for beginners preparing for Microsoft certification.
Arduino WiFi IoT Tutorial - Full Communication From Anywhere in the World - Part 3
Learn to create a global IoT project using ESP8266, SQL database, and PHP. Covers two-way communication, web interface setup, and sending text messages from your Arduino-based devices.
Scaling Climate Data for FinTech with an Open Source Data Mesh
Explore how OS-Climate builds an open data platform for climate impact analysis using open-source tools. Learn about data mesh architecture, scalability challenges, and community-driven development.
Continuous Integration: Database Selection and Model Creation - Day 2
Learn database selecting techniques, including creating models, using Active Records, query bindings, and testing, to enhance your database management skills.
A Race to the Bottom: Database Transactions Undermining Your AppSec
Explore how database transactions can compromise application security, with insights on identifying and mitigating potential vulnerabilities in your software systems.
How to Learn and Master Web Development - A Comprehensive Roadmap
Comprehensive guide to web development, covering essential technologies, frameworks, and tools for building modern websites and applications. Ideal for beginners and experienced developers alike.