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.
Building an AI-Powered Natural Language SQL Interface: An MVP Journey
sufian-abu profile

Building an AI-Powered Natural Language SQL Interface: An MVP Journey

#ai #nextjs #llm #sql
Comments
6 min read
SQL Interviews in the Age of LLMs: Patterns Over Queries
olgabraginskaya profile

SQL Interviews in the Age of LLMs: Patterns Over Queries

#sql #interview #career
10
Comments 3
25 min read
FlexibleSearch Queries in SAP Commerce: The Complete Developer's Guide
aliaksandr_tsviatkou profile

FlexibleSearch Queries in SAP Commerce: The Complete Developer's Guide

#sap #java #sql #sapcommerce
1
Comments
13 min read
Databricks SQL Essentials - Array Data Type
rueedlinger profile

Databricks SQL Essentials - Array Data Type

#database #dataengineering #sql #tutorial
Comments
6 min read
Filter Assignments
abirami_prabhakar profile

Filter Assignments

#sql #dbms #beginners
Comments
3 min read
Select Queries from DVD Rental database
abirami_prabhakar profile

Select Queries from DVD Rental database

#sql #beginners #dbms
Comments
3 min read
Basic Select SQL Queries
abirami_prabhakar profile

Basic Select SQL Queries

#sql #beginners
Comments
2 min read
SQL Fundamentals: Solving Real Database Queries Step by Step
tanishka_v_b7e4add4c1c1a4 profile

SQL Fundamentals: Solving Real Database Queries Step by Step

#beginners #database #sql #tutorial
Comments
2 min read
SQL Queries You'll Use Every Day (But Nobody Teaches in Tutorials)
0012303 profile

SQL Queries You'll Use Every Day (But Nobody Teaches in Tutorials)

#database #sql #tutorial #beginners
Comments
3 min read
🚀 SQL Joins and Window Functions Explained (With Real Examples for Data Analysts)
githinji_victormaina_627 profile

🚀 SQL Joins and Window Functions Explained (With Real Examples for Data Analysts)

#sql #database #datascience #beginners
2
Comments 1
3 min read
SQL Joins Explained: INNER, LEFT, RIGHT, FULL, and More
_d7eb1c1703182e3ce1782 profile

SQL Joins Explained: INNER, LEFT, RIGHT, FULL, and More

#sql #database #programming #tools
2
Comments
6 min read
Stop Tuning Blind: Query Observability as the Foundation for Database Optimization
damasosanoja profile

Stop Tuning Blind: Query Observability as the Foundation for Database Optimization

#database #monitoring #performance #sql
5
Comments
18 min read
The Ultimate Guide to Databricks Data Engineer Associate Exam: Everything You Need to Know
datatechbridge profile

The Ultimate Guide to Databricks Data Engineer Associate Exam: Everything You Need to Know

#dataengineering #learning #sql #tutorial
1
Comments
40 min read
COALESCE in SQL: the “Don’t Let NULL Win” Function You’ll Use Everywhere
baldwin_apps profile

COALESCE in SQL: the “Don’t Let NULL Win” Function You’ll Use Everywhere

#sql #database #programming #dataengineering
Comments
2 min read
Real world considerations: MS-SQL vs PostgreSQL vs MySQL
marko_mgi_b8a9b2bc90838b profile

Real world considerations: MS-SQL vs PostgreSQL vs MySQL

#sql #mysql #postgres
2
Comments
12 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.