Forem

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.
Understanding Databases: SQL, NoSQL, Schemas,DDL, and DML
Cover image for Understanding Databases: SQL, NoSQL, Schemas,DDL, and DML

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

Comments
2 min read
MySQL Lab: Building a University Information Query System with Database Views
Cover image for 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
Cover image for 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
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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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)
Cover image for 🎓 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
Cover image for 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
Cover image for The Equality Delete Problem in Apache Iceberg

The Equality Delete Problem in Apache Iceberg

Comments
9 min read
Why Your SQL Queries Are Slower Than a Sloth: Deep Dive Into Indexes You’re Probably Misusing
Cover image for 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
Data Integrity First: Mastering Transactions in Supabase SQL for Reliable Applications
Cover image for Data Integrity First: Mastering Transactions in Supabase SQL for Reliable Applications

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

8
Comments 1
19 min read
Why I Ditched SSMS for VS Code's MSSQL Extension (And Never Looked Back)
Cover image for 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
Cover image for 🦆 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
College Student & Course Management System
Cover image for College Student & Course Management System

College Student & Course Management System

Comments
3 min read
Day 4 Data Analytics Progress 📈

Day 4 Data Analytics Progress 📈

Comments
1 min read
loading...