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 sort posts by top and latest.
Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String

Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String

Reactions 2 Comments
3 min read
Fun times with MySQL upgrade

Fun times with MySQL upgrade

Reactions 2 Comments
5 min read
How Covid changed the way we work with SQL

How Covid changed the way we work with SQL

Reactions 2 Comments
4 min read
Learn how to write SQL recursive CTE in 5 steps

Learn how to write SQL recursive CTE in 5 steps

Reactions 2 Comments
6 min read
How To Swap 2 Unique Primary Keys In The Same Table With MySQL

How To Swap 2 Unique Primary Keys In The Same Table With MySQL

Reactions 2 Comments
1 min read
SQL Basics Tutorial for Beginners (Practice SQL Queries)

SQL Basics Tutorial for Beginners (Practice SQL Queries)

Reactions 2 Comments
1 min read
7 modern and practical MySQL/MariaDB features you should know and use

7 modern and practical MySQL/MariaDB features you should know and use

Reactions 2 Comments
5 min read
Getting started with Redshift

Getting started with Redshift

Reactions 8 Comments
5 min read
SQL Joins - Inner Join vs Outer Join

SQL Joins - Inner Join vs Outer Join

Reactions 5 Comments
1 min read
Please How can I convert the following object oriented PDO fetch_assoc to MYsqli Format below.

Please How can I convert the following object oriented PDO fetch_assoc to MYsqli Format below.

Reactions 2 Comments
1 min read
How To Delete First Or Last n Rows In MySQL

How To Delete First Or Last n Rows In MySQL

Reactions 3 Comments
1 min read
Quick 📸 on 🐘 active SQL from pg_stat_statements

Quick 📸 on 🐘 active SQL from pg_stat_statements

Reactions 7 Comments
3 min read
De-identify SQL: Transforming Production Data

De-identify SQL: Transforming Production Data

Reactions 6 Comments
3 min read
String Operations On Phone Numbers In SQL

String Operations On Phone Numbers In SQL

Reactions 11 Comments
7 min read
A Guide to Data Analytics with DuckDB

A Guide to Data Analytics with DuckDB

Reactions 5 Comments
1 min read
Using Constants in PostgreSQL queries

Using Constants in PostgreSQL queries

Reactions 2 Comments
2 min read
SQL Server Interview Questions

SQL Server Interview Questions

Reactions 7 Comments 3
2 min read
What is the N prefix in MSSQL all about?

What is the N prefix in MSSQL all about?

Reactions 5 Comments
3 min read
"Rows Removed by Index Recheck" on YugabyteDB Index Scan

"Rows Removed by Index Recheck" on YugabyteDB Index Scan

Reactions 5 Comments
8 min read
Creating Tables and Associations using Ruby/Active Record/Rake

Creating Tables and Associations using Ruby/Active Record/Rake

Reactions 6 Comments
5 min read
My week three experience as an intern at TaskForce4.0

My week three experience as an intern at TaskForce4.0

Reactions 4 Comments
2 min read
Seven URL Shortener

Seven URL Shortener

Reactions 7 Comments
10 min read
MAQL: Powerful Analytical Querying Made Simple

MAQL: Powerful Analytical Querying Made Simple

Reactions 3 Comments 1
3 min read
What Is Trino And Why Is It Great At Processing Big Data

What Is Trino And Why Is It Great At Processing Big Data

Reactions 11 Comments
7 min read
⏱ Read from the nearest peer in a multi-region database 🚀 with followers read

⏱ Read from the nearest peer in a multi-region database 🚀 with followers read

Reactions 6 Comments
12 min read
How to count newest entries created in an oracle database

How to count newest entries created in an oracle database

Reactions 6 Comments 2
1 min read
A Roadmap for Learning SQL

A Roadmap for Learning SQL

Reactions 4 Comments
3 min read
Making Dapper and JSON friends

Making Dapper and JSON friends

Reactions 5 Comments 1
6 min read
Data modeling – Table Inheritance

Data modeling – Table Inheritance

Reactions 3 Comments
5 min read
What are database indexes?

What are database indexes?

Reactions 54 Comments
5 min read
Monster Code: An application made with React, Ruby, SQLite, Sinatra and Active Record

Monster Code: An application made with React, Ruby, SQLite, Sinatra and Active Record

Reactions 4 Comments
1 min read
What is the difference between UNION and UNION ALL in SQL?

What is the difference between UNION and UNION ALL in SQL?

Reactions 16 Comments 2
2 min read
SQL Injection Nedir?

SQL Injection Nedir?

Reactions 8 Comments