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 and Using Table Hints in SQL Server

Understanding and Using Table Hints in SQL Server

3
Comments 2
3 min read
Enhancing Text-to-SQL With Synthetic Summaries: A Few-Shot Learning Approach

Enhancing Text-to-SQL With Synthetic Summaries: A Few-Shot Learning Approach

1
Comments
16 min read
Unlocking the Power of AWS Databases: A Complete Guide for Developers

Unlocking the Power of AWS Databases: A Complete Guide for Developers

Comments
2 min read
Calculate based on the records within the group and fill the result into the first record:From SQL to SPL #4

Calculate based on the records within the group and fill the result into the first record:From SQL to SPL #4

5
Comments
3 min read
SQL Performance Tuning: Best Practices for Faster Queries

SQL Performance Tuning: Best Practices for Faster Queries

1
Comments 1
3 min read
Simple SQL Generator using AWS Bedrock

Simple SQL Generator using AWS Bedrock

2
Comments
3 min read
Drizzle ORM Crash Course

Drizzle ORM Crash Course

12
Comments 3
4 min read
Why Successful Companies Don't Have DBAs

Why Successful Companies Don't Have DBAs

Comments
4 min read
Uses of Snowflake Schema

Uses of Snowflake Schema

1
Comments
3 min read
Explaining DELETE vs DROP vs TRUNCATE in SQL

Explaining DELETE vs DROP vs TRUNCATE in SQL

Comments
1 min read
🚀 Mastering JDBC: Bridging Java and Databases Seamlessly 📊

🚀 Mastering JDBC: Bridging Java and Databases Seamlessly 📊

2
Comments
2 min read
RAG - Creating the SQLite database and config file

RAG - Creating the SQLite database and config file

4
Comments
8 min read
PostgreSQL plan_cache_mode

PostgreSQL plan_cache_mode

2
Comments
6 min read
Building an Intelligent SQL Query Assistant with Neon, .NET, Azure Functions, and Azure OpenAI service

Building an Intelligent SQL Query Assistant with Neon, .NET, Azure Functions, and Azure OpenAI service

5
Comments
11 min read
Mastering SQL Joins - Inner, Outer, Cross, and Self-Joins with Examples

Mastering SQL Joins - Inner, Outer, Cross, and Self-Joins with Examples

3
Comments
4 min read
What is a Relational Database?

What is a Relational Database?

7
Comments 3
9 min read
Building a PHP CRUD Application with OOP and MySQL: A Best Practice Guide

Building a PHP CRUD Application with OOP and MySQL: A Best Practice Guide

36
Comments
4 min read
Explaining Relation and Data Independence in SQL

Explaining Relation and Data Independence in SQL

Comments
2 min read
Is SPL more difficult or easier than SQL?

Is SPL more difficult or easier than SQL?

6
Comments
15 min read
Primeiros Passos no PostgreSQL: Um Guia Completo para Iniciantes

Primeiros Passos no PostgreSQL: Um Guia Completo para Iniciantes

1
Comments
4 min read
Explaining (the need for) SQL's Common Table Expressions (CTE)

Explaining (the need for) SQL's Common Table Expressions (CTE)

1
Comments
2 min read
Search for the closest matching record within the group:From SQL to SPL

Search for the closest matching record within the group:From SQL to SPL

7
Comments
2 min read
How to Build Personal Curicullum Locally in Python

How to Build Personal Curicullum Locally in Python

1
Comments
2 min read
Learn Django through Inventory management system

Learn Django through Inventory management system

3
Comments
2 min read
Common Data Loss Scenarios & Solutions in Prisma Schema Changes

Common Data Loss Scenarios & Solutions in Prisma Schema Changes

2
Comments
3 min read
loading...