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.
Comparing IF, IIF, and CASE
ranggakd profile

Comparing IF, IIF, and CASE

#mssql #programming #learning #sql
Comments
3 min read
Advance SQL tricks.
brianmk profile

Advance SQL tricks.

#sql #datascience #database
10
Comments 1
1 min read
Exploring PostgreSQL's EXCLUDE Operator: Advanced Data Constraints
rozhnev profile

Exploring PostgreSQL's EXCLUDE Operator: Advanced Data Constraints

#sql #postgressql #tutorial
1
Comments 1
3 min read
Using Triggers to Map Database Relationships in Custom Claims
mansueli profile

Using Triggers to Map Database Relationships in Custom Claims

#postgres #sql #supabase #triggers
3
Comments
6 min read
DROP TABLE while being read: wait or wound?
franckpachot profile

DROP TABLE while being read: wait or wound?

#distributed #sql #postgres #yugabytedb
1
Comments
8 min read
Interpreting Low-Code from the perspective of open-source SPL
jbx1279 profile

Interpreting Low-Code from the perspective of open-source SPL

#programming #lowcode #sql #datascience
Comments
8 min read
Don't miss out on the new features in SQL Server 16.x
notte profile

Don't miss out on the new features in SQL Server 16.x

#sql #database #datascience #sqlserver
5
Comments 2
2 min read
How to connect multiple databases to Django project
karthiknarayan profile

How to connect multiple databases to Django project

#django #sql #python #backend
9
Comments 1
2 min read
Routable computing engine implements front-end database
jbx1279 profile

Routable computing engine implements front-end database

#database #sql #bigdata #programming
Comments
5 min read
The Trade-offs Between Database Normalization and Denormalization
er_dward profile

The Trade-offs Between Database Normalization and Denormalization

#database #sql #mysql #postgres
12
Comments 1
4 min read
Sequelize Migration
bhavinvirani profile

Sequelize Migration

#sequelize #node #sql #database
Comments
2 min read
Analyzing Uber and Uber Eats Expenses Using DBT, Postgres, Gmail, Python, SQL And PowerBI
stefentaime profile

Analyzing Uber and Uber Eats Expenses Using DBT, Postgres, Gmail, Python, SQL And PowerBI

#powerbi #dbt #sql #python
Comments
9 min read
Creating a Node.js web app service and SQL Database in Azure
lomosa profile

Creating a Node.js web app service and SQL Database in Azure

#webapp #node #azure #sql
2
Comments
4 min read
Approximate Count for hash sharded YugabyteDB tables
franckpachot profile

Approximate Count for hash sharded YugabyteDB tables

#yugabytedb #postgres #distributed #sql
Comments
4 min read
SQL Case Study - Tiny Shop Sales
shahbazpycread profile

SQL Case Study - Tiny Shop Sales

#sql #join #subquery
2
Comments 2
6 min read
How to write SQL query in Ruby On Rails
ka8725 profile

How to write SQL query in Ruby On Rails

#sql #postgres #rails #railsdevelopment
Comments
4 min read
Parallel Scan in YugabyteDB (ysql_select_parallelism=-1)
franckpachot profile

Parallel Scan in YugabyteDB (ysql_select_parallelism=-1)

#yugabytedb #distributed #sql #database
Comments
3 min read
Seamlessly Save and Load Reports from SQL Server Database to Blazor Pivot Table
jollenmoyani profile

Seamlessly Save and Load Reports from SQL Server Database to Blazor Pivot Table

#blazor #webdev #sql #productivity
Comments
16 min read
Subqueries Unraveled: Exploring SQL’s Hidden Power
john-maina profile

Subqueries Unraveled: Exploring SQL’s Hidden Power

#sql #datascience #data
1
Comments 6
3 min read
25 SQL tricks for beginners.
brianmk profile

25 SQL tricks for beginners.

#database #sql
26
Comments 2
2 min read
How to pivot data using Dynamic SQL in SQL Server
notte profile

How to pivot data using Dynamic SQL in SQL Server

#sql #database #dataengineering #mssql
5
Comments 4
3 min read
Exploring Advanced and Modern Concepts in SQL with Practical Examples.
grayhat profile

Exploring Advanced and Modern Concepts in SQL with Practical Examples.

#datascience #data #sql #mysql
40
Comments 13
4 min read
Postgres Concurrency : What could go wrong (part 2)
yet_anotherdev profile

Postgres Concurrency : What could go wrong (part 2)

#postgres #sql
6
Comments 2
3 min read
Generate SQL Script in PostgreSQL
franckpachot profile

Generate SQL Script in PostgreSQL

#postgres #tips #sql #database
1
Comments
1 min read
SQL vs. NoSQL - cutting through the Tech Twitter noise
jmikrut profile

SQL vs. NoSQL - cutting through the Tech Twitter noise

#database #sql #nosql #mongodb
1
Comments
9 min read
How does the in-memory database bring memory’s advantage into play?
jbx1279 profile

How does the in-memory database bring memory’s advantage into play?

#database #sql #bigdata
Comments
12 min read
A Worthy Sequel: An Overview of Next-Gen NoSQL Databases
ndewald profile

A Worthy Sequel: An Overview of Next-Gen NoSQL Databases

#prove #sql #database #learning
2
Comments
4 min read
Deploying an App Service in Azure and Connecting to SQL Database
arbythecoder profile

Deploying an App Service in Azure and Connecting to SQL Database

#appservice #azure #database #sql
3
Comments
3 min read
My Favorite Free Courses to Learn Data Science in Depth
javinpaul profile

My Favorite Free Courses to Learn Data Science in Depth

#datascience #machinelearning #sql #python
51
Comments 3
15 min read
Open-source SPL Eliminates Tens of Thousands of Intermediate Tables from Databases
jbx1279 profile

Open-source SPL Eliminates Tens of Thousands of Intermediate Tables from Databases

#database #programming #sql
5
Comments
8 min read
Building a Node.js Server with Microsoft SQL Database Integration
unlikelycreator profile

Building a Node.js Server with Microsoft SQL Database Integration

#node #sql #mssql #react
Comments
2 min read
How to Query 1st, 2nd, or Nth Largest attribute in SQL Table
muneebkhan4 profile

How to Query 1st, 2nd, or Nth Largest attribute in SQL Table

#sql #postgres #backend #webdev
Comments
3 min read
7 Bad Practices to Avoid When Writing SQL Queries for Better Performance 🚀
abdelrahmanallam profile

7 Bad Practices to Avoid When Writing SQL Queries for Better Performance 🚀

#sql #performance #database
10
Comments 2
4 min read
How to Survive Phase III of Flatiron School
caseyconlan profile

How to Survive Phase III of Flatiron School

#pyth #flatironschool #coding #sql
1
Comments
4 min read
Postgres Concurrency : What could go wrong (part 1)
yet_anotherdev profile

Postgres Concurrency : What could go wrong (part 1)

#postgres #sql
8
Comments
4 min read
How to access the ERD (Entity-Relationship Diagram) of your database schema in MySQL Workbench
alumassy profile

How to access the ERD (Entity-Relationship Diagram) of your database schema in MySQL Workbench

#mysql #database #dataanalysis #sql
2
Comments 1
2 min read
SAS Function setDateByNumberBDays
vanhurter profile

SAS Function setDateByNumberBDays

#sas #sql #proc
2
Comments
1 min read
SAS Function isBrHolidayworkingDaysBetweenDates
vanhurter profile

SAS Function isBrHolidayworkingDaysBetweenDates

#sas #sql #proc
2
Comments
1 min read
SAS Functions previous and next BusinessDay
vanhurter profile

SAS Functions previous and next BusinessDay

#sas #sql #datefunctions #proc
Comments
1 min read
Create Stored Procedures using Embedded Python
intersystemsdev profile

Create Stored Procedures using Embedded Python

#python #sql #beginners #tutorial
2
Comments
5 min read
MySQL Basic Select challenges
sn0wf1re profile

MySQL Basic Select challenges

#sql #mysql
Comments
2 min read
Managing Calendar Availability in Supabase
ivaaan profile

Managing Calendar Availability in Supabase

#tutorial #postgres #sql #react
2
Comments
3 min read
SQL Constraints 101: Ensuring Data Accuracy and Integrity
aviatorifeanyi profile

SQL Constraints 101: Ensuring Data Accuracy and Integrity

#sql #database #data #datascience
1
Comments 4
6 min read
SAS Function isBrHoliday
vanhurter profile

SAS Function isBrHoliday

#sas #sql #datefunctions #procfcmp
2
Comments
1 min read
SAS Function isBusinessDay
vanhurter profile

SAS Function isBusinessDay

#sas #sql #datefunctions #proc
2
Comments
1 min read
pg_hint_plan in views? No. But in UDFs, Yes
franckpachot profile

pg_hint_plan in views? No. But in UDFs, Yes

#postgres #yugabytedb #distributed #sql
3
Comments
10 min read
MySQL 8.0: Invisible Columns
rozhnev profile

MySQL 8.0: Invisible Columns

#mysql #tutorial #sql
3
Comments
2 min read
Introduction to SQL set operators
aviatorifeanyi profile

Introduction to SQL set operators

#sql #database #datascience #analytics
11
Comments 1
5 min read
How to build a music player part 2: Introduction MySQL database
themba_sishuba profile

How to build a music player part 2: Introduction MySQL database

#database #webdev #beginners #sql
Comments
3 min read
Generate Random Text Strings in PostgreSQL
franckpachot profile

Generate Random Text Strings in PostgreSQL

#postgres #tips #sql #database
2
Comments
1 min read
How to rotate data using Pivot & Unpivot operators
notte profile

How to rotate data using Pivot & Unpivot operators

#sql #database #dataengineering #mssql
3
Comments 2
3 min read
Why ETL Becomes ELT or Even LET?
jbx1279 profile

Why ETL Becomes ELT or Even LET?

#database #bigdata #sql #programming
Comments
8 min read
SQL Recipe: Ranking Records
nalgeon profile

SQL Recipe: Ranking Records

#sql #analytics
5
Comments
2 min read
A Quick Guide to AI-Powered Data Visualization: Create a Smart Dashboard with LogicLoop.
bellatrick profile

A Quick Guide to AI-Powered Data Visualization: Create a Smart Dashboard with LogicLoop.

#beginners #tutorial #sql #analytics
11
Comments
6 min read
Description of important clauses in SQL and Apache age query format part 2
talhahahae profile

Description of important clauses in SQL and Apache age query format part 2

#apache #apacheage #postgressql #sql
Comments
2 min read
DBMS Concepts
sd704 profile

DBMS Concepts

#sql #database
Comments
10 min read
Description of important clauses in SQL and Apache age query format part 1
talhahahae profile

Description of important clauses in SQL and Apache age query format part 1

#sql #postgres #database
Comments
2 min read
How to close a MySQL connection in Node js?
nikhilxd profile

How to close a MySQL connection in Node js?

#node #sql #webdev #programming
Comments 1
1 min read
Efficient Data Management with "PostgreSQL"
huzaiifaaaa profile

Efficient Data Management with "PostgreSQL"

#apache #postgesql #sql #database
1
Comments
2 min read
CRUD - 4 SQL Commands, their Javascript equivalents and MORE
rickdelpo1 profile

CRUD - 4 SQL Commands, their Javascript equivalents and MORE

#sql #javascript #beginners #tutorial
1
Comments
5 min read
loading...