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

3
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
封装 Sqlc 的 Queries 实现更方便的事务操作

封装 Sqlc 的 Queries 实现更方便的事务操作

Comments 1
2 min read
Education Connect: Revolutionizing Parent-School Communication

Education Connect: Revolutionizing Parent-School Communication

1
Comments 1
2 min read
SQL vs NoSQL: Choosing the Right Database for Your Project

SQL vs NoSQL: Choosing the Right Database for Your Project

3
Comments
2 min read
Introduction to Application Scenarios of PostgreSQL JSON and Optimization of Shared Detoast

Introduction to Application Scenarios of PostgreSQL JSON and Optimization of Shared Detoast

Comments
3 min read
5-Week Data Career Boot Camp: Orientation and Foundations.

5-Week Data Career Boot Camp: Orientation and Foundations.

106
Comments 1
3 min read
Calculate the Total Price According to the Cumulative Price Table #eg13

Calculate the Total Price According to the Cumulative Price Table #eg13

6
Comments 1
1 min read
Getting Started with LINQ (2/3)

Getting Started with LINQ (2/3)

3
Comments 5
5 min read
Understanding Database Views: Usage, Benefits, and Considerations

Understanding Database Views: Usage, Benefits, and Considerations

1
Comments
3 min read
Learn basic SQL concepts using visual low-code

Learn basic SQL concepts using visual low-code

1
Comments 1
9 min read
Data Calculation Problems Based on Object-Event Schema

Data Calculation Problems Based on Object-Event Schema

6
Comments 1
9 min read
How to Parse Key-value Pairs from a Base64-encoded String in SQL?#eg12

How to Parse Key-value Pairs from a Base64-encoded String in SQL?#eg12

5
Comments 1
1 min read
Enterprise Management System with Real-time Notifications and WebSocket Chat

Enterprise Management System with Real-time Notifications and WebSocket Chat

2
Comments
1 min read
20 Livros sobre Linguagem SQL que você deveria ler

20 Livros sobre Linguagem SQL que você deveria ler

4
Comments
16 min read
🎓 HackerRank Skill Certificate: Software Engineer

🎓 HackerRank Skill Certificate: Software Engineer

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

Getting Started with LINQ (1/3)

Comments
5 min read
Create an Inventory Database In 3 Steps

Create an Inventory Database In 3 Steps

2
Comments
19 min read
Python & SQL DJ Database

Python & SQL DJ Database

2
Comments
3 min read
Mastering SQL: Understanding Group By and Order By

Mastering SQL: Understanding Group By and Order By

Comments
4 min read
Introduction to Sequelize: Simplifying Database Operations in Node.js

Introduction to Sequelize: Simplifying Database Operations in Node.js

2
Comments
5 min read
How to Parse Key-value Pairs from a Base64-encoded String#eg11

How to Parse Key-value Pairs from a Base64-encoded String#eg11

7
Comments 1
1 min read
Master SQL Querying: A Comprehensive Guide.

Master SQL Querying: A Comprehensive Guide.

Comments
9 min read
Diagnosing and Optimizing Running Slow SQL in GBase 8s Database

Diagnosing and Optimizing Running Slow SQL in GBase 8s Database

Comments
3 min read
How the Shift-Left movement affects developers and their databases

How the Shift-Left movement affects developers and their databases

1
Comments 1
3 min read
Displaying Table Columns and NULL Constraints in SQL

Displaying Table Columns and NULL Constraints in SQL

Comments
2 min read
From Messy Data to Super Mario Pipeline: My First Adventure in Data Engineering

From Messy Data to Super Mario Pipeline: My First Adventure in Data Engineering

Comments
12 min read
Enhanced Password Management: Edit Passwords Seamlessly

Enhanced Password Management: Edit Passwords Seamlessly

2
Comments
2 min read
Day1-100 series - Learning System Design for Interviews.

Day1-100 series - Learning System Design for Interviews.

Comments
3 min read
SQL Fun: Tackle 10M Records!

SQL Fun: Tackle 10M Records!

Comments
3 min read
Forget your database exists! Leave it to Metis

Forget your database exists! Leave it to Metis

Comments
4 min read
Raw SQL or ORM. Which one is better?

Raw SQL or ORM. Which one is better?

1
Comments
6 min read
SQL | Database Query Optimization with Common Table Expressions

SQL | Database Query Optimization with Common Table Expressions

Comments
2 min read
SQL | Database Query Optimization with Examples

SQL | Database Query Optimization with Examples

Comments
2 min read
Introducing Vitorm: The Perfect Balance of Simplicity and Power in ORM for NetCore

Introducing Vitorm: The Perfect Balance of Simplicity and Power in ORM for NetCore

Comments 1
5 min read
How to Easily Import Large SQL Database Files into MySQL Using PowerShell

How to Easily Import Large SQL Database Files into MySQL Using PowerShell

1
Comments
1 min read
Tell me, like I'm 5, why SQLynx is better than Data Grip?

Tell me, like I'm 5, why SQLynx is better than Data Grip?

1
Comments
1 min read
Window Functions in SQL

Window Functions in SQL

6
Comments 1
1 min read
How to Optimize SQL Queries by Understanding the SQL Execution Order

How to Optimize SQL Queries by Understanding the SQL Execution Order

14
Comments 3
3 min read
How to Efficiently Copy or Update Tables Across Schemas in PostgreSQL on RDS Without Downtime?

How to Efficiently Copy or Update Tables Across Schemas in PostgreSQL on RDS Without Downtime?

1
Comments
1 min read
Interview questions for a java developer with 3 year of experience

Interview questions for a java developer with 3 year of experience

5
Comments
2 min read
Database1

Database1

Comments
4 min read
Exceptions and Commit in PostgreSQL PL/pgSQL vs. Oracle PL/SQL

Exceptions and Commit in PostgreSQL PL/pgSQL vs. Oracle PL/SQL

13
Comments 3
3 min read
PostgreSQL. How to move old historical records from your main table to a separate table?

PostgreSQL. How to move old historical records from your main table to a separate table?

5
Comments
4 min read
SQL- Commands intro

SQL- Commands intro

4
Comments 1
2 min read
Choosing the Right Database for Your Project

Choosing the Right Database for Your Project

13
Comments 2
9 min read
loading...