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.
Using IRIS and Presto for high-performance and scalable SQL queries
intersystemsdev profile

Using IRIS and Presto for high-performance and scalable SQL queries

#performance #sql #analytics #webdev
Comments
10 min read
Choice of Table Column Types and Order When Migrating to PostgreSQL
shiviyer profile

Choice of Table Column Types and Order When Migrating to PostgreSQL

#postgressql #dba #sql #opensource
2
Comments
2 min read
SQL Advanced Functions - CASE, COALESCE, and NULLIF Explained
luca1iu profile

SQL Advanced Functions - CASE, COALESCE, and NULLIF Explained

#sql #database #tutorial
Comments
3 min read
Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3
judith677 profile

Complement a certain average value to ensure that the total sum remains unchanged — From SQL to SPL #3

#programming #opensource #sql #dataengineering
7
Comments 1
2 min read
SQL Data Comparison: What It Is and Why It Matters
samantha_brauer profile

SQL Data Comparison: What It Is and Why It Matters

#sqlserver #database #sql
1
Comments
1 min read
Postpone and Prosper: Make your life easier with deferring SQL constraints
aloisseckar profile

Postpone and Prosper: Make your life easier with deferring SQL constraints

#sql #database #programming #learning
1
Comments
3 min read
Track Production Operations Outcome Progression with Conditional NULLs - From SQL to SPL #2
judith677 profile

Track Production Operations Outcome Progression with Conditional NULLs - From SQL to SPL #2

#programming #database #opensource #sql
5
Comments 1
2 min read
PostgreSql Tasks
guru_prasanna_01 profile

PostgreSql Tasks

#postgres #sql #database #payilagam
Comments
4 min read
PostgreSql Tasks - Interview Questions
guru_prasanna_01 profile

PostgreSql Tasks - Interview Questions

#payilagam #postgres #sql #database
Comments 1
5 min read
Convert cross cell to row header, row header to column：From SQL to SPL
esproc_spl profile

Convert cross cell to row header, row header to column：From SQL to SPL

#sql #programming #opensource #devops
6
Comments
2 min read
Complete Guide to MySQL Joins
harshm03 profile

Complete Guide to MySQL Joins

#mysql #sql #database #beginners
1
Comments
5 min read
Neo4j vs. SQL: Unlocking the Power of Graph-Based Data Modeling 🚀
ali_dz profile

Neo4j vs. SQL: Unlocking the Power of Graph-Based Data Modeling 🚀

#sql #neo4j #data #comparison
5
Comments
4 min read
Introducing StackQL - Manage Your Cloud Services & Interact with APIs using SQL 🧑‍💻🔥
madza profile

Introducing StackQL - Manage Your Cloud Services & Interact with APIs using SQL 🧑‍💻🔥

#devops #cloud #sql #api
42
Comments 3
10 min read
SQL PATTERNS : Pivot and Unpivot in SQL - Transforming Data Effectively
anwaar profile

SQL PATTERNS : Pivot and Unpivot in SQL - Transforming Data Effectively

#sql #database #softwareengineering #datascience
6
Comments 2
2 min read
SQL OPERATORS
john_analytics profile

SQL OPERATORS

#sql #datascience #dataengineering #analyst
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.