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.
Where 1 = 1 in SQL
bdavidxyz profile

Where 1 = 1 in SQL

#sql
Comments 2
1 min read
Doris: Breaking Down the Barriers of SQL Dialects and Building a Unified Data Query Ecosystem
darren_xu profile

Doris: Breaking Down the Barriers of SQL Dialects and Building a Unified Data Query Ecosystem

#sql #doris #programming #opensource
2
Comments
4 min read
SQL Optimization Techniques for Better Performance
jing_li profile

SQL Optimization Techniques for Better Performance

#database #sql #programming #beginners
Comments
13 min read
🚀 Seamless Data Magic: From Notion to Database with MCP Server & AI Agents
toshiya_matsumoto_ac94abe profile

🚀 Seamless Data Magic: From Notion to Database with MCP Server & AI Agents

#mcp #cursor #notion #sql
1
Comments 1
3 min read
SQL Made Easy: A Tutorial for Beginners
rishabhtpt profile

SQL Made Easy: A Tutorial for Beginners

#sql #beginners #tutorial #programming
1
Comments
4 min read
5 SQL Queries Everyone Should Know
ironside43 profile

5 SQL Queries Everyone Should Know

#sql #database #beginners #tutorial
6
Comments 1
2 min read
Getting Started with SQL: The Language of Data
doreen_jerotich_0c02c93c8 profile

Getting Started with SQL: The Language of Data

#programming #data #sql
1
Comments
3 min read
SQL For Data Analytics in a Nutshell
emmanuel_kiriinya profile

SQL For Data Analytics in a Nutshell

#datascience #sql #beginners
4
Comments 1
5 min read
Number Non-Null Values in Order within the Group — From SQL to SPL #17
judith677 profile

Number Non-Null Values in Order within the Group — From SQL to SPL #17

#programming #sql #esprocspl #dataengineering
6
Comments 1
2 min read
Hashing in Presto/Athena
dendihandian profile

Hashing in Presto/Athena

#sql #athena #presto
1
Comments
1 min read
Oracle AI Database 26ai (23.7) — Materialized Expression Columns
vahidusefzadeh profile

Oracle AI Database 26ai (23.7) — Materialized Expression Columns

#oracle #sql #linux #database
1
Comments
1 min read
How to Use SQL in Go
coding-with-patrik profile

How to Use SQL in Go

#sql #go #tutorial #programming
Comments
6 min read
Features I Wish MySQL Had but Postgres 🐘 Already Has 😻
op3ratordec profile

Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

#postgres #mysql #sql #database
5
Comments 2
5 min read
How to Create a New MySQL User and Grant All Permissions
msnmongare profile

How to Create a New MySQL User and Grant All Permissions

#mysql #sql #database #programming
Comments
2 min read
10 SQL Anti-Patterns You Must Avoid in Production
cristiansifuentes profile

10 SQL Anti-Patterns You Must Avoid in Production

#sql #database #performance #advancedsql
2
Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.