DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
NORMALIZATION
santhosh_m_7dcc3d605279c5 profile

NORMALIZATION

#database #sql #beginners #tutorial
1
Comments
3 min read
From Kafka to Clean Tables: Building a Confluent Snowflake Pipeline with Streams & Tasks
kepha_mwandiki profile

From Kafka to Clean Tables: Building a Confluent Snowflake Pipeline with Streams & Tasks

#dataengineering #automation #tutorial #sql
3
Comments 1
10 min read
SQL Server Performance Optimization: Window Functions to Double Your Query Efficiency!
sqlflash1024 profile

SQL Server Performance Optimization: Window Functions to Double Your Query Efficiency!

#sql #sqlserver #ai
Comments
4 min read
SQLStorm & CogniSQL: An AI-Augmented SQL Dataset(202508)
sqlflash1024 profile

SQLStorm & CogniSQL: An AI-Augmented SQL Dataset(202508)

#sql #database #ai
Comments
4 min read
SQLite functions: Generate Series Examples
mr_destructive profile

SQLite functions: Generate Series Examples

#sql #sqlite #database #programming
Comments
2 min read
Beyond Functional: Writing Professional and Performant SQL Queries
gregory42266270 profile

Beyond Functional: Writing Professional and Performant SQL Queries

#database #performance #sql
3
Comments
2 min read
The Ultimate Guide to SQL Joins and Subqueries Explained
datalane profile

The Ultimate Guide to SQL Joins and Subqueries Explained

#sql #programming #tutorial #database
11
Comments
7 min read
🚀 SQL Stored Procedures vs. Python Functions: Two Worlds, Same Idea
mercy_musyoka_ profile

🚀 SQL Stored Procedures vs. Python Functions: Two Worlds, Same Idea

#sql #python #datascience #devcommunity
Comments 1
2 min read
SQLite functions: generate series
mr_destructive profile

SQLite functions: generate series

#sql #sqlite #database
Comments
4 min read
Three (3) Tips for efficient SQL Queries
tkouleris profile

Three (3) Tips for efficient SQL Queries

#sql #programming
Comments
1 min read
SQLite dot commands: html tables with output and once
mr_destructive profile

SQLite dot commands: html tables with output and once

#sql #sqlite #database
1
Comments
2 min read
Auto-Generate Snowflake Semantic Views with AI - A Developer's Fast-Track to Cortex Analyst
tsubasa_tech profile

Auto-Generate Snowflake Semantic Views with AI - A Developer's Fast-Track to Cortex Analyst

#snowflake #llm #semanticlayer #sql
3
Comments
11 min read
Understanding Databases: SQL, NoSQL, Schemas,DDL, and DML
de_clerke profile

Understanding Databases: SQL, NoSQL, Schemas,DDL, and DML

#database #backend #beginners #sql
Comments
2 min read
Database System Internals — Transactions, Deadlocks, Recovery & Indexing Explained with SQL Examples
mukesh_b_9758c3ceb936cdf1 profile

Database System Internals — Transactions, Deadlocks, Recovery & Indexing Explained with SQL Examples

#computerscience #database #sql
1
Comments 1
3 min read
Mastering DBMS: A Practical Guide to Indexing, Hashing, and Query Optimization
haresh_511 profile

Mastering DBMS: A Practical Guide to Indexing, Hashing, and Query Optimization

#sql #oracle #data #beginners
Comments
3 min read
Indexing, Hashing & Query Optimization
lohita_blue_d6409977eec4c profile

Indexing, Hashing & Query Optimization

#sql #database #performance
1
Comments
2 min read
SQLite Scalar Function: Random
mr_destructive profile

SQLite Scalar Function: Random

#sql #sqlite #database
1
Comments
1 min read
The Philosophical Choice Between SQLite and DuckDB for Flutter Developers
sayed_ali_alkamel profile

The Philosophical Choice Between SQLite and DuckDB for Flutter Developers

#flutter #sql #duckdb #mobile
5
Comments
3 min read
Stop Juggling SQL Scripts: Introducing Zync, the Database Package Manager
mirshahreza profile

Stop Juggling SQL Scripts: Introducing Zync, the Database Package Manager

#database #sql #tooling #devops
3
Comments 3
4 min read
SQL vs NoSQL: The Data War That Never Really Ended
shaq_attack profile

SQL vs NoSQL: The Data War That Never Really Ended

#database #sql #mongodb #tutorial
Comments
7 min read
(III) Full Analysis of ODS to DWS Layer Design Standards, Covering Data Sync/Storage/Quality Essentials
seatunnel profile

(III) Full Analysis of ODS to DWS Layer Design Standards, Covering Data Sync/Storage/Quality Essentials

#apacheseatunnel #mysql #sql #datascience
1
Comments
3 min read
HAVING Condition Pushdown: Optimizing Query Performance
sqlflash1024 profile

HAVING Condition Pushdown: Optimizing Query Performance

#mysql #sql
Comments
3 min read
SQL Mini project :WC24 T20 Data Analytics
ashok_kumar_564581944e3ef profile

SQL Mini project :WC24 T20 Data Analytics

#mysql #sql #database #datascience
Comments
1 min read
ACID Properties with SQL Transactions in DBMS
reshma_devi_ba32b2f54397d profile

ACID Properties with SQL Transactions in DBMS

#programming #database #sql #learning
4
Comments
3 min read
SQLite Dot command: Once
mr_destructive profile

SQLite Dot command: Once

#sqlite #sql #shell
1
Comments
2 min read
loading...