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 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
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
SQL Course: Self Join

SQL Course: Self Join

Comments
1 min read
SQL Course: Many-to-many relationship and Nested Joins.

SQL Course: Many-to-many relationship and Nested Joins.

1
Comments
2 min read
SQL Course: One-to-many Relationships and Left Joins

SQL Course: One-to-many Relationships and Left Joins

Comments
1 min read
SQL Course: One-to-one Relationships and Inner Joins.

SQL Course: One-to-one Relationships and Inner Joins.

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
SQL Course: Get Started.

SQL Course: Get Started.

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

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

104
Comments 1
3 min read
Efficiently Reading Millions of Rows of SQL Data with Python

Efficiently Reading Millions of Rows of SQL Data with Python

2
Comments
2 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
Learn basic SQL concepts using visual low-code

Learn basic SQL concepts using visual low-code

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

4
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
Differences Between SQL and NoSQL Databases and Their Combined Use in Projects

Differences Between SQL and NoSQL Databases and Their Combined Use in Projects

4
Comments
6 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
How to Display All Databases in Various Ways

How to Display All Databases in Various Ways

Comments
1 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 Examples

SQL | Database Query Optimization with Examples

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

SQL | Database Query Optimization with Common Table Expressions

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
Mastering SQL Databases: In-Depth Guide

Mastering SQL Databases: In-Depth Guide

Comments
2 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
Interview questions for a java developer with 3 year of experience

Interview questions for a java developer with 3 year of experience

2
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

10
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

9
Comments 2
9 min read
How to export SQL Server data to XML

How to export SQL Server data to XML

Comments
1 min read
How I added a guestbook to my website with Clerk, Neon, and Netlify Functions

How I added a guestbook to my website with Clerk, Neon, and Netlify Functions

1
Comments
14 min read
Solving the SQL Murder Mystery: A Step-by-Step Guide

Solving the SQL Murder Mystery: A Step-by-Step Guide

1
Comments
4 min read
Programming Volunteer Opportunity!!!

Programming Volunteer Opportunity!!!

3
Comments
1 min read
Managing Resources with Using in C#

Managing Resources with Using in C#

11
Comments 2
3 min read
Quick Tip: Setup a local MySQL in a docker container

Quick Tip: Setup a local MySQL in a docker container

6
Comments
2 min read
Dynamic Datasets and Customizable Parameters for Data Analysis

Dynamic Datasets and Customizable Parameters for Data Analysis

5
Comments
4 min read
How SQL Enhances Your Data Science Skills

How SQL Enhances Your Data Science Skills

12
Comments 2
3 min read
Oracle Database Object List

Oracle Database Object List

14
Comments
2 min read
Understanding SQL Joins and Grouping using Set Theory

Understanding SQL Joins and Grouping using Set Theory

2
Comments
5 min read
loading...