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.
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 versioning SQL databases architecture using GitHub and Visual Studio

How to versioning SQL databases architecture using GitHub and Visual Studio

3
Comments 2
4 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
7 reasons why learning SQL is still important for Rails developers

7 reasons why learning SQL is still important for Rails developers

18
Comments 1
5 min read
Experimenting Flyway with SQL Server

Experimenting Flyway with SQL Server

7
Comments
2 min read
Welcome to SQL 3: Building Relationships and Combining Data Sets

Welcome to SQL 3: Building Relationships and Combining Data Sets

11
Comments 1
10 min read
Managing High Availability in PostgreSQL – Part II

Managing High Availability in PostgreSQL – Part II

11
Comments
11 min read
Build a Secure Node.js App with SQL Server

Build a Secure Node.js App with SQL Server

38
Comments 1
23 min read
Database Management Systems For Application Development: Introduction

Database Management Systems For Application Development: Introduction

10
Comments
2 min read
Simple Tips for PostgreSQL Query Optimization

Simple Tips for PostgreSQL Query Optimization

20
Comments
5 min read
#100CodeExamples – Constants in PL/SQL and SQL

#100CodeExamples – Constants in PL/SQL and SQL

8
Comments
3 min read
How much difference does adding an index to a database table make?

How much difference does adding an index to a database table make?

11
Comments
3 min read
loading...