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