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.
Understanding Databases: SQL, NoSQL, Schemas,DDL, and DML
de_clerke profile

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

#database #backend #beginners #sql
Comments
2 min read
College Student & Course Management System
krithikraja_fcc802ca9bb16 profile

College Student & Course Management System

#sql #oracle #learning #database
Comments
3 min read
Stop Juggling SQL Scripts: Introducing Zync, the Database Package Manager
mirshahreza profile

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

#database #sql #tooling #devops
3
Comments 3
4 min read
How AI Helped a Developer Master SQL Server Performance Optimization Without DBA Training
evgenii-vaniukov profile

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

#sql #sqlserver #mcp #database
Comments
4 min read
The Power of Postgres Arrays in Your Supabase Projects
ziga_petek_c2bfdf4d05a5cb profile

The Power of Postgres Arrays in Your Supabase Projects

#database #sql #postgres #tutorial
7
Comments
12 min read
Primary Key vs. Foreign Key in SQL: Explained with Examples
dbvismarketing profile

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

#sql #mysql #sqlserver
Comments
2 min read
Finally, a Database That Actually Listens to You
arseniydev profile

Finally, a Database That Actually Listens to You

#database #sql #ai #startup
1
Comments
3 min read
Useful MYSQL functions
sadiul_hakim profile

Useful MYSQL functions

#sql #mysql
Comments
2 min read
Finding All Child Tables Referencing a Parent Table in Oracle
mrcaption49 profile

Finding All Child Tables Referencing a Parent Table in Oracle

#database #sql #tutorial
5
Comments
1 min read
Mastering Postgres Window Functions for Data Analysis in Supabase
timothy_malche_56945869fc profile

Mastering Postgres Window Functions for Data Analysis in Supabase

#webdev #database #sql #backend
8
Comments
16 min read
SQL GROUP BY Explained with Examples
roxana_haidiner profile

SQL GROUP BY Explained with Examples

#sql #database #mysql #postgres
6
Comments
4 min read
🎓 College Student & Course Management System with SQL (Step by Step)
rohith_95 profile

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

#webdev #sql #learning
Comments
3 min read
How to Back Up and Restore MySQL Using mysqldump
dbvismarketing profile

How to Back Up and Restore MySQL Using mysqldump

#sql #mysql #backup
Comments
2 min read
5 Steps to Optimize MySQL Deep Pagination
rebooter_s profile

5 Steps to Optimize MySQL Deep Pagination

#mysql #sql
Comments
4 min read
The Equality Delete Problem in Apache Iceberg
__354f265b41dafa0d901b profile

The Equality Delete Problem in Apache Iceberg

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