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.
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
Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive

Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive

Comments
12 min read
Database Security Patterns for Web Applications

Database Security Patterns for Web Applications

Comments
2 min read
🚀 Database Optimization: Proven Techniques to Speed Up Your Queries

🚀 Database Optimization: Proven Techniques to Speed Up Your Queries

Comments
3 min read
Are SQL vs NoSQL Databases different? : Key Differences Every Developer Should Know

Are SQL vs NoSQL Databases different? : Key Differences Every Developer Should Know

Comments
1 min read
SQLite dot commands: Output mode separator command

SQLite dot commands: Output mode separator command

2
Comments
2 min read
The main tasks of a Database Administrator (DBA) by 2025

The main tasks of a Database Administrator (DBA) by 2025

5
Comments
27 min read
SQLite dot commands: Output mode

SQLite dot commands: Output mode

2
Comments
9 min read
How to Migrate Your On-Premise Database to Google Cloud SQL? A Detailed Guide

How to Migrate Your On-Premise Database to Google Cloud SQL? A Detailed Guide

6
Comments
5 min read
Associações polimórficas no Rails: como fazer, prós e contras

Associações polimórficas no Rails: como fazer, prós e contras

17
Comments 3
4 min read
COLLEGE STUDENT & COURSE MANAGEMENT SYSTEM

COLLEGE STUDENT & COURSE MANAGEMENT SYSTEM

1
Comments
2 min read
Day 2: Data Analytics Progress📈

Day 2: Data Analytics Progress📈

Comments
1 min read
Why I Built an "Awesome List" for Data Analysis (And How It Can Help You)

Why I Built an "Awesome List" for Data Analysis (And How It Can Help You)

5
Comments
2 min read
Building SW: Lessons from the Backend

Building SW: Lessons from the Backend

4
Comments
8 min read
Automating Old Partition Cleanup in Oracle with PL/SQL

Automating Old Partition Cleanup in Oracle with PL/SQL

6
Comments
3 min read
Enterprise Software Vendors: Drive Compliance & Customer Insights with MindsDB Knowledge Bases + Hybrid Search

Enterprise Software Vendors: Drive Compliance & Customer Insights with MindsDB Knowledge Bases + Hybrid Search

Comments
12 min read
👉 “Top 5 SQL Query Patterns Every Developer Should Know for Interviews”

👉 “Top 5 SQL Query Patterns Every Developer Should Know for Interviews”

Comments
1 min read
Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations

Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations

Comments
8 min read
👉 “SQL Joins Explained Like You’re 5 (Interview-Friendly Guide)”

👉 “SQL Joins Explained Like You’re 5 (Interview-Friendly Guide)”

Comments
1 min read
MySQL Labs: Change Defaults, Add Constraints, Encrypt Passwords & Optimize Indexes

MySQL Labs: Change Defaults, Add Constraints, Encrypt Passwords & Optimize Indexes

Comments
2 min read
Filtering and Retrieving in SQL

Filtering and Retrieving in SQL

1
Comments 2
3 min read
Converting CSV to PDF HTML JSON & SQL

Converting CSV to PDF HTML JSON & SQL

Comments
7 min read
Oracle SQL Plan Management - 23ai features backported to 19.22

Oracle SQL Plan Management - 23ai features backported to 19.22

Comments
4 min read
Simplifying SQL Date Data Types with Practical Tips

Simplifying SQL Date Data Types with Practical Tips

Comments
1 min read
loading...