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.
Number Guessing Game
santhoshi_mary_88917c3fd9 profile

Number Guessing Game

#database #python #sql #tutorial
1
Comments
2 min read
BigQuery Global Queries: Join Data Across Regions Without ETL
toyama0919 profile

BigQuery Global Queries: Join Data Across Regions Without ETL

#bigquery #gcp #dataengineering #sql
1
Comments
6 min read
Advanced SQL for Data Analytics: Advanced Techniques Every Data Analyst Should Know
beverline_otiende_6d3045c profile

Advanced SQL for Data Analytics: Advanced Techniques Every Data Analyst Should Know

#sql #database #datascience
1
Comments
14 min read
30 DAYS OF SQL - DAY1
msaud profile

30 DAYS OF SQL - DAY1

#sql #coding #30daysofsql #mysql
Comments
3 min read
Log 02: The Sample Data Struggle & The "Wildcard" Trap
codebasejournal profile

Log 02: The Sample Data Struggle & The "Wildcard" Trap

#sql #learning
1
Comments
2 min read
Fetch and Sort Leaderboard by Difficulty and Attempts
tharunya_kr_c17e81c2a49a profile

Fetch and Sort Leaderboard by Difficulty and Attempts

#database #python #sql #tutorial
1
Comments
1 min read
When to Use SQL vs NoSQL Databases: A Comprehensive 2026 Guide
akshaykurve profile

When to Use SQL vs NoSQL Databases: A Comprehensive 2026 Guide

#database #sql #nosql #postgres
1
Comments
19 min read
The Slow Query Hidden Inside Your PL/pgSQL Function
philip_mcclarence_2ef9475 profile

The Slow Query Hidden Inside Your PL/pgSQL Function

#database #performance #postgres #sql
Comments
5 min read
PostgreSQL Performance: 10 Queries You're Writing Wrong (2026 Edition)
young_gao profile

PostgreSQL Performance: 10 Queries You're Writing Wrong (2026 Edition)

#database #postgres #performance #sql
Comments
5 min read
Connecting Power BI to an SQL database
njokijoan003commits profile

Connecting Power BI to an SQL database

#database #analytics #sql #tutorial
Comments
5 min read
Snowflake vs Redshift vs BigQuery: Which One Should You Use?
neha_christina_1ac8651819 profile

Snowflake vs Redshift vs BigQuery: Which One Should You Use?

#sql #beginners #snowflake #dataengineering
1
Comments
4 min read
Beyond CRUD: How easy-query Brings OLAP Superpowers to Your Java ORM
dev-jack profile
Li

Beyond CRUD: How easy-query Brings OLAP Superpowers to Your Java ORM

#showdev #database #java #sql
2
Comments
7 min read
I curated 1,863 Data Engineering interview questions from 97+ companies --- here's what I learned. Website :: dataengprep.tech
codeshukla profile

I curated 1,863 Data Engineering interview questions from 97+ companies --- here's what I learned. Website :: dataengprep.tech

#ai #dataengineering #interview #sql
Comments
3 min read
From 68% to ~100%: How We Built a Text-to-SQL System That Gets Smarter Every Day
alexchen31337 profile

From 68% to ~100%: How We Built a Text-to-SQL System That Gets Smarter Every Day

#sql #machinelearning #webdev #programming
1
Comments
11 min read
Connecting power BI to a SQL database
tonny-o profile

Connecting power BI to a SQL database

#analytics #database #sql #tutorial
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.