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.
Research for MySQL architecture and Optimize performance

Research for MySQL architecture and Optimize performance

1
Comments
4 min read
Boost Your Website Security for Free with SafeLine WAF

Boost Your Website Security for Free with SafeLine WAF

6
Comments
3 min read
SafeLine: Secure Your Web Applications Effortlessly

SafeLine: Secure Your Web Applications Effortlessly

6
Comments
2 min read
SQL, compute cumulative sums according to the termination condition #eg29

SQL, compute cumulative sums according to the termination condition #eg29

7
Comments 1
1 min read
Cast for type conversion in SQL

Cast for type conversion in SQL

1
Comments
2 min read
Calculating Fingerprints For SQL Queries

Calculating Fingerprints For SQL Queries

Comments
4 min read
One Minute: DuckDB

One Minute: DuckDB

Comments
1 min read
How to build a new Harlequin adapter with Poetry

How to build a new Harlequin adapter with Poetry

Comments
12 min read
SQL, parse json data #eg28

SQL, parse json data #eg28

11
Comments
1 min read
Declarative Multi-Engine Data Stack with Ibis

Declarative Multi-Engine Data Stack with Ibis

1
Comments
10 min read
Tips for Working with Complex Normalized Databases

Tips for Working with Complex Normalized Databases

Comments
15 min read
Understanding The ‘AND’ Keyword In SQL Server

Understanding The ‘AND’ Keyword In SQL Server

1
Comments
5 min read
SQL, concatenate multiple rows of strings and remove duplicates #eg27

SQL, concatenate multiple rows of strings and remove duplicates #eg27

6
Comments
1 min read
Understanding Data Normalization and Database Design Principles

Understanding Data Normalization and Database Design Principles

1
Comments
2 min read
SQL | Interview Questions and Answers

SQL | Interview Questions and Answers

1
Comments
5 min read
Understanding Lookup Tables in Excel and SQL

Understanding Lookup Tables in Excel and SQL

Comments
12 min read
🚀 Beginner's Guide to SQL and Databases

🚀 Beginner's Guide to SQL and Databases

10
Comments 2
4 min read
Top Programming Languages for Data Science in 2024

Top Programming Languages for Data Science in 2024

Comments
2 min read
🇩🇪 Grundlegende SQL-Befehle für Einsteiger

🇩🇪 Grundlegende SQL-Befehle für Einsteiger

Comments
8 min read
Recommended Project: Creating Stored Procedures for Course Data Retrieval

Recommended Project: Creating Stored Procedures for Course Data Retrieval

Comments
3 min read
[Resolved] Integrity constraint violation – Fast tips

[Resolved] Integrity constraint violation – Fast tips

Comments
4 min read
Você comete este erro no Left Join?

Você comete este erro no Left Join?

Comments
2 min read
Calculate the Average Interval of Projects for Each User #eg17

Calculate the Average Interval of Projects for Each User #eg17

6
Comments 1
1 min read
Understanding your data: The Essentials of Exploratory Data Analysis (EDA).

Understanding your data: The Essentials of Exploratory Data Analysis (EDA).

Comments
2 min read
SQL 50 FROM Leetcode

SQL 50 FROM Leetcode

3
Comments 1
1 min read
Maintainable SQL Query Building with Golang

Maintainable SQL Query Building with Golang

Comments
5 min read
IMPORTING DATA USING PYTHON TO MYSQL

IMPORTING DATA USING PYTHON TO MYSQL

1
Comments
2 min read
Merge multiple files, remove duplicates and sort the result #eg25

Merge multiple files, remove duplicates and sort the result #eg25

6
Comments 1
1 min read
Analyzing ELB Access Logs with Athena: Configuration and Query Examples

Analyzing ELB Access Logs with Athena: Configuration and Query Examples

3
Comments
3 min read
DbGate - a fast database client

DbGate - a fast database client

Comments
1 min read
Exploratory Data Analysis using SQL

Exploratory Data Analysis using SQL

10
Comments 2
3 min read
How to Display Dates Easily ? #eg9

How to Display Dates Easily ? #eg9

6
Comments 1
2 min read
ACID: O Pilar dos Bancos de Dados Relacionais

ACID: O Pilar dos Bancos de Dados Relacionais

2
Comments
2 min read
You can do anything. But if you try to do everything, you'll end up doing nothing.

You can do anything. But if you try to do everything, you'll end up doing nothing.

17
Comments 7
2 min read
A Comprehensive Guide to Materialized Views in MySQL

A Comprehensive Guide to Materialized Views in MySQL

1
Comments
33 min read
3 SQL Approaches to Bulk Update Records with Knex.js

3 SQL Approaches to Bulk Update Records with Knex.js

6
Comments
8 min read
Introducing the Hrida T2SQL 128k Model

Introducing the Hrida T2SQL 128k Model

1
Comments
3 min read
How to Combine Every Five Values into One Record #eg14

How to Combine Every Five Values into One Record #eg14

7
Comments 3
2 min read
NoSQL vs. SQL: Choosing the Right Database for Your Application

NoSQL vs. SQL: Choosing the Right Database for Your Application

3
Comments
4 min read
Modern Software Architecture is a Joke

Modern Software Architecture is a Joke

Comments
2 min read
Top 7 Websites to Learn SQL for Free 2024

Top 7 Websites to Learn SQL for Free 2024

1
Comments
3 min read
想要不花一分钱就能像专家一样管理和查询数据库吗?探索最佳的免费SQL学习网站,掌握这门重要的数据库语言所需的技能和知识。

想要不花一分钱就能像专家一样管理和查询数据库吗?探索最佳的免费SQL学习网站,掌握这门重要的数据库语言所需的技能和知识。

Comments 1
1 min read
How to Define a Counter in MySQL

How to Define a Counter in MySQL

1
Comments
6 min read
🇩🇪 Grundlagen von Datenbanksystemen

🇩🇪 Grundlagen von Datenbanksystemen

Comments
4 min read
Understanding Your Data: The Essentials of Exploratory Data Analysis (EDA)

Understanding Your Data: The Essentials of Exploratory Data Analysis (EDA)

1
Comments
3 min read
Clustered vs Non-Clustered: Understanding Database Indexes

Clustered vs Non-Clustered: Understanding Database Indexes

3
Comments
3 min read
From Excel to Database: A Guide to Table Creation and Data Import with MySQL and SQLynx (Free SQL IDE)

From Excel to Database: A Guide to Table Creation and Data Import with MySQL and SQLynx (Free SQL IDE)

1
Comments
2 min read
The Ultimate Guide to Data Analytics: Techniques and Tools

The Ultimate Guide to Data Analytics: Techniques and Tools

Comments
2 min read
Efficient Report Management: Save and Load Reports in Vue Pivot Table with SQL Server and Node.js Express Server

Efficient Report Management: Save and Load Reports in Vue Pivot Table with SQL Server and Node.js Express Server

Comments
16 min read
Getting Started with LINQ (3/3)

Getting Started with LINQ (3/3)

Comments 1
9 min read
Performance of range queries in B-Tree and LSM indexes

Performance of range queries in B-Tree and LSM indexes

20
Comments
9 min read
Performance Pitfalls: Using Hints in Oracle Database

Performance Pitfalls: Using Hints in Oracle Database

7
Comments 1
2 min read
Configurando o Spring com JPA e Microsoft SQL Server

Configurando o Spring com JPA e Microsoft SQL Server

Comments
2 min read
Data Analysis. The Ultimate Guide to Data Analytics: Techniques and Tools

Data Analysis. The Ultimate Guide to Data Analytics: Techniques and Tools

Comments
1 min read
Aggregation in GROUP BY vs. Window Functions Using OVER()

Aggregation in GROUP BY vs. Window Functions Using OVER()

2
Comments
3 min read
Count(*) vs Count(1) in SQL

Count(*) vs Count(1) in SQL

399
Comments 18
3 min read
No-Code REST API for Databases adds Table Joins

No-Code REST API for Databases adds Table Joins

2
Comments 1
4 min read
Understanding the Role of a SQL Server Database Administrator

Understanding the Role of a SQL Server Database Administrator

2
Comments 2
2 min read
Essential MySQL 50 Selected Practice Questions with Answers

Essential MySQL 50 Selected Practice Questions with Answers

Comments
13 min read
Essential Oracle 50 Selected Practice Questions with Answers

Essential Oracle 50 Selected Practice Questions with Answers

Comments
4 min read
loading...