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 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

6
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
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
Deploying .net core, angular and sql server to ubuntu

Deploying .net core, angular and sql server to ubuntu

6
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

24
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

15
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

9
Comments
2 min read
SQL Basics for Beginners

SQL Basics for Beginners

100
Comments 4
3 min read
The Important SQL Queries for Beginners

The Important SQL Queries for Beginners

12
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
SQL vs NoSQL

SQL vs NoSQL

5
Comments
1 min read
SQL - Sub Queries

SQL - Sub Queries

6
Comments
2 min read
Python and SQL

Python and SQL

7
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 5: Joining Tables

Learn SQL: Microsoft SQL Server - Episode 5: Joining Tables

7
Comments
3 min read
Hacktoberfest 2021 with QuestDB community

Hacktoberfest 2021 with QuestDB community

13
Comments 2
2 min read
How to Drop Multiple Databases in PostgreSQL

How to Drop Multiple Databases in PostgreSQL

6
Comments
5 min read
SQL for detecting contiguous and non-contiguous date spans

SQL for detecting contiguous and non-contiguous date spans

6
Comments
5 min read
SQL to derive subsequences

SQL to derive subsequences

2
Comments
4 min read
Learn SQL: Microsoft SQL Server - Episode 4: Sorting Results

Learn SQL: Microsoft SQL Server - Episode 4: Sorting Results

7
Comments
5 min read
SQL - Stored Procedure 📦

SQL - Stored Procedure 📦

34
Comments 1
1 min read
SQL: How to consult the database.

SQL: How to consult the database.

4
Comments
2 min read
DELETE on SQL

DELETE on SQL

2
Comments
1 min read
Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 2

Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 2

7
Comments
5 min read
Little known vulnerability with ORMs and query builders

Little known vulnerability with ORMs and query builders

5
Comments
3 min read
Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 1

Learn SQL: Microsoft SQL Server - Episode 3: Where Clause - Part 1

8
Comments 2
4 min read
Top 5 MySQL GUI tools in 2021

Top 5 MySQL GUI tools in 2021

9
Comments
10 min read
Improving Backend Performance, Part 3/3: Fast Analytics

Improving Backend Performance, Part 3/3: Fast Analytics

7
Comments
4 min read
Improving Backend Performance Part 2/3: Using Database Indexes

Improving Backend Performance Part 2/3: Using Database Indexes

4
Comments
4 min read
DBMS Employee and Department

DBMS Employee and Department

5
Comments
1 min read
DBMS Student table

DBMS Student table

9
Comments
2 min read
SQL vs NoSQL Databases

SQL vs NoSQL Databases

2
Comments
1 min read
What’s new with BigQuery ?

What’s new with BigQuery ?

6
Comments
5 min read
Learn SQL: Microsoft SQL Server - Episode 2: Selecting Records

Learn SQL: Microsoft SQL Server - Episode 2: Selecting Records

7
Comments
6 min read
SQL Constraints

SQL Constraints

3
Comments
4 min read
10 no-brainer best practices that boost API security

10 no-brainer best practices that boost API security

2
Comments
5 min read
Flatten Pandas dataframe MultiIndex

Flatten Pandas dataframe MultiIndex

4
Comments 1
2 min read
The Data Engineer Roadmap 🗺

The Data Engineer Roadmap 🗺

57
Comments 4
4 min read
Boost Secondary Index Queries with Index Only Scan

Boost Secondary Index Queries with Index Only Scan

6
Comments
11 min read
Implementing a Task Queue in SQL

Implementing a Task Queue in SQL

4
Comments 1
7 min read
Calculate Distance between 2 Geo Locations in PHP MySQL

Calculate Distance between 2 Geo Locations in PHP MySQL

34
Comments 3
2 min read
loading...