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.
A Beginner DBA's Guide to SSRS Reports
michael-gokey profile

A Beginner DBA's Guide to SSRS Reports

#dba #sql #ssrs #analytics
Comments
3 min read
Understanding SUBSTRING_INDEX in SQL: Real Use Cases
dbvismarketing profile

Understanding SUBSTRING_INDEX in SQL: Real Use Cases

#sql #mysql
Comments
2 min read
SQL IQ – Advanced SQL Interview Queries Search and Prep System
meenakshi052003 profile

SQL IQ – Advanced SQL Interview Queries Search and Prep System

#programming #webdev #mysql #sql
1
Comments 1
4 min read
Enterprise SQL Server Index Maintenance: Multi-Database Automation with Email Reporting
georgpiwonka profile

Enterprise SQL Server Index Maintenance: Multi-Database Automation with Email Reporting

#sqlserver #sql #database
Comments
3 min read
Supercharging Entity Framework Core: Efficient Bulk Inserts Without Loops or Raw SQL
davinceleecode profile

Supercharging Entity Framework Core: Efficient Bulk Inserts Without Loops or Raw SQL

#sql #csharp #database #dotnet
2
Comments
2 min read
EXSQL: An open-source SQL language extension for customizable querying
greem profile

EXSQL: An open-source SQL language extension for customizable querying

#showdev #programming #sql #opensource
Comments
1 min read
Hackerrank - SQL - Weather Observation Station 5
mrpunkdasilva profile

Hackerrank - SQL - Weather Observation Station 5

#sql #hackerrank #beginners #learning
Comments
2 min read
Hackerrank - SQL - Weather Observation Station 6
mrpunkdasilva profile

Hackerrank - SQL - Weather Observation Station 6

#sql #beginners #learning #hackerrank
Comments
2 min read
Hackerrank - SQL - Weather Observation Station 7
mrpunkdasilva profile

Hackerrank - SQL - Weather Observation Station 7

#sql #beginners #hackerrank #learning
Comments
2 min read
How To Build An API With Node, Without Additional Framework (SQL Included)
dmnchzl profile

How To Build An API With Node, Without Additional Framework (SQL Included)

#programming #node #sql #javascript
Comments
15 min read
6 Timeless SQL Books for Software Engineers and Developers
somadevtoo profile

6 Timeless SQL Books for Software Engineers and Developers

#sql #database #books #softwareengineering
17
Comments
8 min read
Supercharging Your Database: A Look into Indexing
farlamo profile

Supercharging Your Database: A Look into Indexing

#programming #database #sql #postgressql
1
Comments 1
3 min read
How to Create ER Diagrams for SQLite with a Free Tool
roxana_haidiner profile

How to Create ER Diagrams for SQLite with a Free Tool

#sql #database #sqlite #datastructures
11
Comments 1
4 min read
⚡ 3 ClickHouse Query Optimization Lessons I Learned the Hard Way
mohhddhassan profile

⚡ 3 ClickHouse Query Optimization Lessons I Learned the Hard Way

#clickhouse #dataengineering #performance #sql
6
Comments
3 min read
# The Ultimate SQL Cheatsheet and Guide for 2025
koolkamalkishor profile

# The Ultimate SQL Cheatsheet and Guide for 2025

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