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.
7 modern and practical MySQL/MariaDB features you should know and use

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

4
Comments
5 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

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

6
Comments 2
1 min read
What is the N prefix in MSSQL all about?

What is the N prefix in MSSQL all about?

5
Comments
3 min read
Making Dapper and JSON friends

Making Dapper and JSON friends

25
Comments 3
6 min read
"Rows Removed by Index Recheck" on YugabyteDB Index Scan

"Rows Removed by Index Recheck" on YugabyteDB Index Scan

5
Comments
8 min read
De-identify SQL: Transforming Production Data

De-identify SQL: Transforming Production Data

7
Comments
3 min read
SQL Joins - Inner Join vs Outer Join

SQL Joins - Inner Join vs Outer Join

5
Comments 1
1 min read
What are database indexes?

What are database indexes?

56
Comments
5 min read
A Roadmap for Learning SQL

A Roadmap for Learning SQL

14
Comments 2
3 min read
🌎🌍🌏 Yugabyte cross-continent deployment 🚀

🌎🌍🌏 Yugabyte cross-continent deployment 🚀

1
Comments
11 min read
SQL Injection Nedir?

SQL Injection Nedir?

9
Comments
2 min read
Relational data models

Relational data models

5
Comments
2 min read
Text Search example with the OMDB sample database

Text Search example with the OMDB sample database

1
Comments
7 min read
MAQL: Powerful Analytical Querying Made Simple

MAQL: Powerful Analytical Querying Made Simple

3
Comments 1
3 min read
Connecting Django to PostgreSQL on Heroku and Perform SQL Command

Connecting Django to PostgreSQL on Heroku and Perform SQL Command

9
Comments
15 min read
Structured Query Language

Structured Query Language

7
Comments
2 min read
Aggregate Functions in SQL

Aggregate Functions in SQL

22
Comments
6 min read
Handling temporal data in SQL

Handling temporal data in SQL

2
Comments
6 min read
Introduction to Entity-Relationship model

Introduction to Entity-Relationship model

22
Comments
3 min read
Data modeling – Table Inheritance

Data modeling – Table Inheritance

4
Comments
5 min read
Query PostgreSQL, or any 🐘-compatible like Amazon Redshift, from YugabyteDB 🚀 thanks to Postgres FDW

Query PostgreSQL, or any 🐘-compatible like Amazon Redshift, from YugabyteDB 🚀 thanks to Postgres FDW

8
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

5
Comments
1 min read
Distributed SQL Essentials: Sharding and Partitioning in YugabyteDB

Distributed SQL Essentials: Sharding and Partitioning in YugabyteDB

3
Comments
8 min read
GOLANG- MSSQL CRUD OPERATIONS

GOLANG- MSSQL CRUD OPERATIONS

8
Comments
3 min read
A minimal Python Tkinter Parent-Children Data Form

A minimal Python Tkinter Parent-Children Data Form

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

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

16
Comments 2
2 min read
Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service

Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service

75
Comments 29
14 min read
What is dbo in SQL Server?

What is dbo in SQL Server?

8
Comments
2 min read
List of window functions

List of window functions

3
Comments
9 min read
Understanding SQL Dialects

Understanding SQL Dialects

6
Comments 1
8 min read
Environmental coder

Environmental coder

4
Comments
1 min read
ORDER BY is mandatory in SQL to get a sorted result

ORDER BY is mandatory in SQL to get a sorted result

33
Comments
10 min read
Window Functions in SQL: Part 1

Window Functions in SQL: Part 1

7
Comments
4 min read
Enable query tagging with Sqlcommenter to understand application impact on database performance

Enable query tagging with Sqlcommenter to understand application impact on database performance

5
Comments
4 min read
Data Access in F#

Data Access in F#

28
Comments 4
12 min read
Update WordPress URL easily using MySQL

Update WordPress URL easily using MySQL

7
Comments 3
3 min read
Learn Materialize by running streaming SQL on your nginx logs

Learn Materialize by running streaming SQL on your nginx logs

28
Comments 1
7 min read
Filtering SQL Left Outer Join Queries

Filtering SQL Left Outer Join Queries

4
Comments
3 min read
What is the difference between JOIN and INNER JOIN in SQL?

What is the difference between JOIN and INNER JOIN in SQL?

39
Comments 6
3 min read
Deploying .net core, angular and sql server to ubuntu

Deploying .net core, angular and sql server to ubuntu

8
Comments 1
6 min read
Can't unfollow sql tag.

Can't unfollow sql tag.

2
Comments 2
1 min read
Learn SQL: Microsoft SQL Server - Episode 11: Extracting data from Strings

Learn SQL: Microsoft SQL Server - Episode 11: Extracting data from Strings

13
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 10: Joining Multiple Columns and Strings

Learn SQL: Microsoft SQL Server - Episode 10: Joining Multiple Columns and Strings

10
Comments
2 min read
Fundamentals of SQL Window function

Fundamentals of SQL Window function

5
Comments
7 min read
Learn SQL: Microsoft SQL Server - Episode 9: Aggregation in Where Clause

Learn SQL: Microsoft SQL Server - Episode 9: Aggregation in Where Clause

8
Comments
3 min read
Clustered and Nonclustered Indexes

Clustered and Nonclustered Indexes

1
Comments
3 min read
Build a Chatbot with PHP, MySQL and AJAX in 10 minutes

Build a Chatbot with PHP, MySQL and AJAX in 10 minutes

28
Comments 1
6 min read
🚀 Think about Primary Key & Indexes before anything else 🐘

🚀 Think about Primary Key & Indexes before anything else 🐘

56
Comments
8 min read
How to Add a Default Value to an Existing Column in MySQL

How to Add a Default Value to an Existing Column in MySQL

16
Comments
2 min read
Learn SQL: Microsoft SQL Server - Episode 8: NULL values in Aggregation

Learn SQL: Microsoft SQL Server - Episode 8: NULL values in Aggregation

6
Comments
3 min read
🆕 SQL Server 2022 First Look - Top 5 New Features (Bonus 5 Features)

🆕 SQL Server 2022 First Look - Top 5 New Features (Bonus 5 Features)

5
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 7: Aggregate data with SUM and AVG

Learn SQL: Microsoft SQL Server - Episode 7: Aggregate data with SUM and AVG

8
Comments
3 min read
Learning The Structure Query Language (SQL)

Learning The Structure Query Language (SQL)

6
Comments
12 min read
Database Management Systems 1

Database Management Systems 1

10
Comments
2 min read
SQL Basics for Beginners

SQL Basics for Beginners

100
Comments 4
3 min read
HOW CAN I LIMIT THE MAXIMUM FILE UPLOAD LIMIT PER USER IN PHP.

HOW CAN I LIMIT THE MAXIMUM FILE UPLOAD LIMIT PER USER IN PHP.

3
Comments 5
1 min read
The Important SQL Queries for Beginners

The Important SQL Queries for Beginners

13
Comments
8 min read
A Complete Guide on How SQL Injection Attacks Work

A Complete Guide on How SQL Injection Attacks Work

40
Comments 2
8 min read
Learn SQL: Microsoft SQL Server - Episode 6: Alias and Aggregate Data

Learn SQL: Microsoft SQL Server - Episode 6: Alias and Aggregate Data

7
Comments
6 min read
loading...