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.
Writing JOINS in SQL

Writing JOINS in SQL

9
Comments 1
3 min read
SQL pronunciation

SQL pronunciation

5
Comments 6
1 min read
How to make your Database FAST with little effort!

How to make your Database FAST with little effort!

34
Comments 2
4 min read
How to get data from an MySQL database in React Native

How to get data from an MySQL database in React Native

48
Comments 55
4 min read
Ploi.io - Server Management Tool

Ploi.io - Server Management Tool

11
Comments 3
2 min read
Build a CRUD App with ASP.NET Core 2.2 and SQL Server

Build a CRUD App with ASP.NET Core 2.2 and SQL Server

14
Comments
12 min read
How I do solve this impossible SQL query?

How I do solve this impossible SQL query?

14
Comments 15
2 min read
Updating a Table with the Values of a Different One

Updating a Table with the Values of a Different One

3
Comments 1
2 min read
MySQL High Availability Framework Explained – Part III: Failover Scenarios

MySQL High Availability Framework Explained – Part III: Failover Scenarios

11
Comments
5 min read
Pitfalls of the MINUS-comparison

Pitfalls of the MINUS-comparison

6
Comments
3 min read
Non-profit projects: how to work with little to no finance?

Non-profit projects: how to work with little to no finance?

6
Comments 4
1 min read
SQL vs Elastic Search for storing CRM Data

SQL vs Elastic Search for storing CRM Data

5
Comments 3
1 min read
DBMS For Application Development: Relational Model & Relational Database

DBMS For Application Development: Relational Model & Relational Database

9
Comments
2 min read
SQL: Copy Tables and Massive Update

SQL: Copy Tables and Massive Update

9
Comments 2
2 min read
Differences Between SQL And NoSQL Databases

Differences Between SQL And NoSQL Databases

90
Comments 2
4 min read
How to debug SQL Databases

How to debug SQL Databases

5
Comments
3 min read
How to write this SQL select the best way?

How to write this SQL select the best way?

10
Comments 7
1 min read
How To Merge Multiple SQL Tables Into One MongoDB Collection

How To Merge Multiple SQL Tables Into One MongoDB Collection

7
Comments
9 min read
2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used

8
Comments
11 min read
Determining the worth of one-off Reporting.

Determining the worth of one-off Reporting.

13
Comments 3
4 min read
How to organize SQL legacy Databases

How to organize SQL legacy Databases

6
Comments
4 min read
That’s not very Data Warehouse - an argument against elegant SQL code

That’s not very Data Warehouse - an argument against elegant SQL code

24
Comments 5
4 min read
SQL: Como adicionar uma quebra de linha em uma query

SQL: Como adicionar uma quebra de linha em uma query

8
Comments
1 min read
How to Generate Contents of a New CSV Column Using JavaScript

How to Generate Contents of a New CSV Column Using JavaScript

6
Comments
2 min read
What is Object-Relational Mapping? How to Roll-Your-Own JavaScript ORM

What is Object-Relational Mapping? How to Roll-Your-Own JavaScript ORM

61
Comments 1
14 min read
loading...