SQL
28 moments from 20 videos · 1:14:31 total
Improve your database querying skills with curated moments from industry experts explaining query optimization, indexing strategies, and advanced relational database concepts.
Comparing native SQL clustering to NoSQL distribution layers
Layering relational SQL queries over baseline NoSQL frameworks creates unavoidable application performance bottlenecks.
Evaluating criteria for distributed SQL system adoption
Examining standard SQL completeness and flexible deployment topologies ensures productive modern architecture adoption.
Evolution from key-value stores to distributed SQL
Why organizations move away from basic key-value engines to structured distributed relational systems for complex processing.
Testing sentiment inference behavior via SQL select statements
Verifying the WebAssembly function behavior on text patterns like capitalization and exclamation points directly inside standard SQL queries.
Processing queries with a stateless SQL layer
The processing layer routes reads and writes without storing data locally while maintaining syntax compatibility with MySQL.
Consolidating workloads through a smart database optimizer
An intelligent sql optimizer automatically routes various query fragments to row, columnar, or vector engines without manual manual intervention.
Distributed SQL properties for agentic AI applications
The fundamental features of distributed databases completely align with what agentic AI backbones need regarding consistency and elastic scale.
Moving away from unstructured SQL strings
How executing raw commands through scripting prevents pipelines from acting predictably.
Building transformation models with SQL and Jinja macros
How compiling modular jinja templates abstracts away repetitive querying workflows.
Identifying SQL injection vulnerabilities in internal stored procedures
Automating security checks reveals common flaws in complex internal queries where user input is unsafely concatenated.
Validating SQL injection risks with a PowerShell module
A programmatic demonstration parses statements to pinpoint unsafe dynamic command concatenations and risks stemming from implicit data type conversions.
Evolution of distributed SQL database architectures
The transition from simple key-value systems to scalable databases providing strong consistency and standard SQL capabilities.
Engineering scale-out architectures specifically for relational queries
Avoiding typical degradation by constructing full relational processing directly over the core rather than mapping abstractions onto object stores.
Validating end-to-end functionality using direct SQL insertions
Confirming immediate remote prediction delivery upon raw query executions against the initialized database container.
Modeling semantic database layers for reliable SQL queries
Structuring complex relational database schemas into graph models enables accurate SQL translations beyond standard context window restrictions.
Preventing SQL injection originating from natural language queries
Returning structured data instead of direct queries protects databases from prompt-driven data exfiltration attacks.
Core capabilities of SingleStore distributed relational SQL database
Scale-out clustering and universal storage mechanisms streamline analytics workflows by centralizing transactional and historical processing.
Adapting relational querying principles for modern JSON documents
How the SQL++ standard ports traditional select statements directly to object-oriented document architectures.
Analyzing valid structural query code lacking domain meaning
Perfectly executable database queries generated by an agent fall short without explicit situational metric instructions.
Why data workflows require raw SQL over REST APIs
Providing direct database access prevents customers from self-hosting by allowing custom joins and aggregations directly in standard tooling.
Validating and publishing with SQL package executables
Generating standalone deployment scripts before execution provides safer validation of target database updates against existing states.
Resolving deployment issues across hundreds of databases
Automating SQL Server database changes replaces manual scripting across highly distributed custom environments.
Comparing prompt injection to traditional SQL injection attacks
The fundamental lack of separation between developer code and user input in language models mirrors the mechanics of SQL injection.
Evaluating limitations of legacy sql-based recommenders
Statistical formulas calculated continuously in sql struggle to provide accurate recommendations for newly listed or unpopular items.
Demonstrating and preventing SQL injection in .NET
Modifying inline SQL statements to use parameterized queries prevents malicious database manipulation by untrusted user input.
Leveraging BigQuery ML for scalable SQL-based segmentation experiments
Using enterprise data warehouses empowers analytics teams to train machine learning models directly via standard database queries.
Applying hard constraints with SQL filters
Combining relational filters for exact bounds alongside vector distance queries limits errors and improves overall relevance.
Benchmarking text-to-SQL tasks with custom datasets
Custom training and evaluation datasets for manufacturing and hospital domains help benchmark agentic performance effectively.
Your mix. Instantly.
More mixes
AI & Machine Learning
AI coding agents
AI & Machine Learning
MCP (Model Context Protocol)
AI & Machine Learning
RAG
Languages & Frameworks
TypeScript
Languages & Frameworks
React
Languages & Frameworks
Java
Cloud, Platform & Data
Platform engineering
Cloud, Platform & Data
Observability
Cloud, Platform & Data
Infrastructure as code
Architecture, Quality & Security
System architecture
Architecture, Quality & Security
Code review
Architecture, Quality & Security
Software supply chain security
Leadership, Career & Community
Engineering strategy
Leadership, Career & Community
Developer experience
Leadership, Career & Community