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.
๐Ÿš€ My Python Practice โ€“ Day 1
ashok_kumar_564581944e3ef profile

๐Ÿš€ My Python Practice โ€“ Day 1

#python #sql #100daysofcode #dataanalytics
1
Comments 1
1 min read
๐Ÿš€ Learning Update
ashok_kumar_564581944e3ef profile

๐Ÿš€ Learning Update

#learning #programming #sql #python
1
Comments
1 min read
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
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
8
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
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
Data Integrity First: Mastering Transactions in Supabase SQL for Reliable Applications
damasosanoja profile

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

#supabase #postgressql #database #sql
9
Comments 1
19 min read
Why I Ditched SSMS for VS Code's MSSQL Extension (And Never Looked Back)
shiva_shanker_k profile

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

#vscode #sqlserver #sql #database
31
Comments
4 min read
Beyond Functional: Writing Professional and Performant SQL Queries
gregory42266270 profile

Beyond Functional: Writing Professional and Performant SQL Queries

#database #performance #sql
3
Comments
2 min read
Database Security Patterns for Web Applications
vanessamadison profile

Database Security Patterns for Web Applications

#database #security #sql #backend
Comments
2 min read
๐Ÿ‘‹ Sign in for the ability to sort posts by relevant, latest, or top.