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.
Relational vs Non-Relational Database | Simple Explanation 🚀

Relational vs Non-Relational Database | Simple Explanation 🚀

3
Comments 1
4 min read
SQLAlchemy Core in Python: Getting Started

SQLAlchemy Core in Python: Getting Started

5
Comments
2 min read
4 Free AWS courses on PostgreSQL

4 Free AWS courses on PostgreSQL

4
Comments 1
1 min read
Sequelize's "Super Many-to-Many" Associations

Sequelize's "Super Many-to-Many" Associations

7
Comments 1
4 min read
How Database Load Balancing Completes the 3-Tiered Architecture

How Database Load Balancing Completes the 3-Tiered Architecture

6
Comments
5 min read
Should SQL Query through REST API be a GET or a POST?

Should SQL Query through REST API be a GET or a POST?

7
Comments 8
1 min read
Daily Share Price Notifications using Python, SQL and Africas Talking - Part One

Daily Share Price Notifications using Python, SQL and Africas Talking - Part One

24
Comments 6
12 min read
I want to manually delete rows, so tell me about all referenced tables

I want to manually delete rows, so tell me about all referenced tables

6
Comments
1 min read
PIVOT-UNPIVOT

PIVOT-UNPIVOT

7
Comments
1 min read
Flask app with postgreSQL

Flask app with postgreSQL

6
Comments
1 min read
Creating PostgreSQL Test Data with SQL, PL/pgSQL, and Python

Creating PostgreSQL Test Data with SQL, PL/pgSQL, and Python

11
Comments 1
15 min read
Oracle Cheat Sheet

Oracle Cheat Sheet

42
Comments 2
5 min read
What is Stored Procedure in SQL

What is Stored Procedure in SQL

6
Comments
1 min read
How Database Load Balancing Completes the 3-Tiered Architecture

How Database Load Balancing Completes the 3-Tiered Architecture

5
Comments
5 min read
Loading Test Data into PostgreSQL

Loading Test Data into PostgreSQL

6
Comments 1
9 min read
Custom traits in Apache Calcite

Custom traits in Apache Calcite

4
Comments
7 min read
Combining SQL outer joins with inner joins

Combining SQL outer joins with inner joins

5
Comments
2 min read
Getting started with PostgreSQL Set Operators

Getting started with PostgreSQL Set Operators

7
Comments
4 min read
Quick-start SQL Server 2019 in Docker

Quick-start SQL Server 2019 in Docker

4
Comments
1 min read
Popular string functions in MySQL - Replace and Reverse

Popular string functions in MySQL - Replace and Reverse

4
Comments
1 min read
Using SQL or NoSQL

Using SQL or NoSQL

7
Comments 3
1 min read
Avoid SQL Server scalar-valued functions in WHERE statements at all cost!

Avoid SQL Server scalar-valued functions in WHERE statements at all cost!

4
Comments
4 min read
Popular string functions in MySQL - CONCAT and SUBSTRING

Popular string functions in MySQL - CONCAT and SUBSTRING

5
Comments
2 min read
Programming with SQLite

Programming with SQLite

5
Comments
2 min read
TypeORM - Multiple DB Calls vs Single DB Call

TypeORM - Multiple DB Calls vs Single DB Call

16
Comments
6 min read
loading...