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.
PostgreSQL: Changing an Integer Column to Boolean - In Place or a New Column, and the Four Errors on the Way

PostgreSQL: Changing an Integer Column to Boolean - In Place or a New Column, and the Four Errors on the Way

Comments
10 min read
PostgreSQL: Cannot Alter Type of a Column Used by a View - How to Change It, and How to Find Every View in the Way

PostgreSQL: Cannot Alter Type of a Column Used by a View - How to Change It, and How to Find Every View in the Way

Comments
9 min read
SQL Window Functions, Joins, CTEs and Subqueries: A Hospital Data Guide

SQL Window Functions, Joins, CTEs and Subqueries: A Hospital Data Guide

Comments
25 min read
SQL for Health care Analytics

SQL for Health care Analytics

Comments
7 min read
SQL Advanced Concepts Explained with Hospital Data

SQL Advanced Concepts Explained with Hospital Data

Comments
14 min read
How to get correct SQL from AI: give it the schema, the dialect, and EXPLAIN

How to get correct SQL from AI: give it the schema, the dialect, and EXPLAIN

Comments
5 min read
Provisioning an Oracle Autonomous AI Database and Connecting Securely with a Cloud Wallet

Provisioning an Oracle Autonomous AI Database and Connecting Securely with a Cloud Wallet

Comments
3 min read
Schema-Only or Row Samples: A Debate Over What an Agent Sees Before Writing SQL

Schema-Only or Row Samples: A Debate Over What an Agent Sees Before Writing SQL

Comments
6 min read
PostgreSQL Constraint Naming Convention: Which Pattern to Use, and How to Find the Names That Drifted

PostgreSQL Constraint Naming Convention: Which Pattern to Use, and How to Find the Names That Drifted

Comments
8 min read
Find Departments with an Average Salary Above the Company Average

Find Departments with an Average Salary Above the Company Average

Comments
2 min read
SQL Injection: When User Input Becomes a Database Command

SQL Injection: When User Input Becomes a Database Command

1
Comments
3 min read
Advanced SQL in Healthcare Analytics: A Comprehensive Technical Guide Using Our Hospital Dataset

Advanced SQL in Healthcare Analytics: A Comprehensive Technical Guide Using Our Hospital Dataset

Comments
6 min read
PostgreSQL: UUIDv4 vs UUIDv7

PostgreSQL: UUIDv4 vs UUIDv7

Comments
3 min read
SQL FUNCTIONS, CTEs AND SUB-QUERIES EXPLAINED

SQL FUNCTIONS, CTEs AND SUB-QUERIES EXPLAINED

Comments
5 min read
Design Pastebin: the beginner-friendly system design interview walkthrough

Design Pastebin: the beginner-friendly system design interview walkthrough

Comments
17 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.