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.
Essential MySQL 50 Selected Practice Questions with Answers

Essential MySQL 50 Selected Practice Questions with Answers

1
Comments
13 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
封装 Sqlc 的 Queries 实现更方便的事务操作
Cover image for 封装 Sqlc 的 Queries 实现更方便的事务操作

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

Comments 1
2 min read
Transpose Multiple Columns into One Row in Each Group #eg15

Transpose Multiple Columns into One Row in Each Group #eg15

6
Comments 1
1 min read
Postgres major version upgrades with minimal downtime
Cover image for Postgres major version upgrades with minimal downtime

Postgres major version upgrades with minimal downtime

Comments
4 min read
SQL vs NoSQL: Choosing the Right Database for Your Project
Cover image for 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
How to Combine Every Five Values into One Record #eg14

How to Combine Every Five Values into One Record #eg14

6
Comments 3
2 min read
Introduction to Application Scenarios of PostgreSQL JSON and Optimization of Shared Detoast
Cover image for 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)
Cover image for 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
Cover image for Understanding Database Views: Usage, Benefits, and Considerations

Understanding Database Views: Usage, Benefits, and Considerations

2
Comments
3 min read
Learn basic SQL concepts using visual low-code
Cover image for Learn basic SQL concepts using visual low-code

Learn basic SQL concepts using visual low-code

1
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
Cover image for 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
Cover image for 20 Livros sobre Linguagem SQL que você deveria ler

20 Livros sobre Linguagem SQL que você deveria ler

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

🎓 HackerRank Skill Certificate: Software Engineer

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

Getting Started with LINQ (1/3)

Comments
5 min read
Create an Inventory Database In 3 Steps
Cover image for Create an Inventory Database In 3 Steps

Create an Inventory Database In 3 Steps

Comments
19 min read
Mastering SQL: Understanding Group By and Order By
Cover image for 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
Cover image for Introduction to Sequelize: Simplifying Database Operations in Node.js

Introduction to Sequelize: Simplifying Database Operations in Node.js

2
Comments
5 min read
Master SQL Querying: A Comprehensive Guide.
Cover image for Master SQL Querying: A Comprehensive Guide.

Master SQL Querying: A Comprehensive Guide.

Comments
9 min read
How the Shift-Left movement affects developers and their databases
Cover image for 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
Enhanced Password Management: Edit Passwords Seamlessly

Enhanced Password Management: Edit Passwords Seamlessly

2
Comments
2 min read
loading...