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.
How to Create Custom Data Types in DbSchema

How to Create Custom Data Types in DbSchema

7
Comments
3 min read
SQL Query optimization techniques

SQL Query optimization techniques

Comments
3 min read
MySQL Lab: Building a University Information Query System with Database Views

MySQL Lab: Building a University Information Query System with Database Views

Comments
2 min read
mysqld Crashes with Signal 11 and Page Corrupt Error

mysqld Crashes with Signal 11 and Page Corrupt Error

Comments
4 min read
🚀 My Python Practice – Day 1

🚀 My Python Practice – Day 1

1
Comments 1
1 min read
🚀 Learning Update

🚀 Learning Update

1
Comments
1 min read
Understanding Databases: SQL, NoSQL, Schemas,DDL, and DML

Understanding Databases: SQL, NoSQL, Schemas,DDL, and DML

Comments
2 min read
College Student & Course Management System

College Student & Course Management System

Comments
3 min read
Stop Juggling SQL Scripts: Introducing Zync, the Database Package Manager

Stop Juggling SQL Scripts: Introducing Zync, the Database Package Manager

3
Comments 3
4 min read
How AI Helped a Developer Master SQL Server Performance Optimization Without DBA Training

How AI Helped a Developer Master SQL Server Performance Optimization Without DBA Training

Comments
4 min read
The Power of Postgres Arrays in Your Supabase Projects

The Power of Postgres Arrays in Your Supabase Projects

7
Comments
12 min read
Primary Key vs. Foreign Key in SQL: Explained with Examples

Primary Key vs. Foreign Key in SQL: Explained with Examples

Comments
2 min read
Finally, a Database That Actually Listens to You

Finally, a Database That Actually Listens to You

1
Comments
3 min read
Useful MYSQL functions

Useful MYSQL functions

Comments
2 min read
Finding All Child Tables Referencing a Parent Table in Oracle

Finding All Child Tables Referencing a Parent Table in Oracle

5
Comments
1 min read
Mastering Postgres Window Functions for Data Analysis in Supabase

Mastering Postgres Window Functions for Data Analysis in Supabase

8
Comments
16 min read
SQL GROUP BY Explained with Examples

SQL GROUP BY Explained with Examples

6
Comments
4 min read
🎓 College Student & Course Management System with SQL (Step by Step)

🎓 College Student & Course Management System with SQL (Step by Step)

Comments
3 min read
How to Back Up and Restore MySQL Using mysqldump

How to Back Up and Restore MySQL Using mysqldump

Comments
2 min read
The Equality Delete Problem in Apache Iceberg

The Equality Delete Problem in Apache Iceberg

Comments
9 min read
Data Integrity First: Mastering Transactions in Supabase SQL for Reliable Applications

Data Integrity First: Mastering Transactions in Supabase SQL for Reliable Applications

9
Comments 1
19 min read
Why Your SQL Queries Are Slower Than a Sloth: Deep Dive Into Indexes You’re Probably Misusing

Why Your SQL Queries Are Slower Than a Sloth: Deep Dive Into Indexes You’re Probably Misusing

Comments
4 min read
Why I Ditched SSMS for VS Code's MSSQL Extension (And Never Looked Back)

Why I Ditched SSMS for VS Code's MSSQL Extension (And Never Looked Back)

30
Comments
4 min read
SQL,PostgreSQL, Database RDBMS, Sql NoSql farqi

SQL,PostgreSQL, Database RDBMS, Sql NoSql farqi

Comments
4 min read
🦆 DuckDB: The SQLite of Analytics You Didn’t Know You Needed

🦆 DuckDB: The SQLite of Analytics You Didn’t Know You Needed

Comments
3 min read
loading...