The Wayback Machine - https://web.archive.org/web/20210227140857/https://dev.to/t/sql

DEV Community

loading...

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability sort posts by top and latest.
Cracking the PostgreSQL Interview

Cracking the PostgreSQL Interview

9
6 min read
Fix Your dbt Concurrent Transaction Database Error

Fix Your dbt Concurrent Transaction Database Error

1
1 min read
How to Complete a Udemy Course

How to Complete a Udemy Course

2
2 min read
SQL & database monthly wrap up - February 2021

SQL & database monthly wrap up - February 2021

10
2 min read
Building an event information portal with ASP.NET 5 & DotVVM

Building an event information portal with ASP.NET 5 & DotVVM

5
10 min read
Try CrateDB Cloud for free �??

Try CrateDB Cloud for free �??

5
4 min read
What is CrateDB? 🤔 FAQ

What is CrateDB? 🤔 FAQ

3 2
3 min read
SQL: Calculate Bussiness Days

SQL: Calculate Bussiness Days

2 2
1 min read
What is Amazon RDS? Explained through Comics

What is Amazon RDS? Explained through Comics

2
1 min read
How to monitor backup and restore progress in SQL Server

How to monitor backup and restore progress in SQL Server

3
2 min read
Obtendo dados de CNPJ's com a API Minha Receita

Obtendo dados de CNPJ's com a API Minha Receita

13 1
7 min read
Reacty Loops : fully web-based music production

Reacty Loops : fully web-based music production

7
1 min read
Using a PlSql cursor in a FOR loop example

Using a PlSql cursor in a FOR loop example

6
3 min read
How to ace the Facebook data scientist interview

How to ace the Facebook data scientist interview

6
8 min read
One-To-Many Database Relationships Complete How To

One-To-Many Database Relationships Complete How To

6
6 min read
Create and drop oracle table example

Create and drop oracle table example

6
2 min read
How to write a SQL Inner Join

How to write a SQL Inner Join

5
2 min read
How to create an SQLite database in node.js

How to create an SQLite database in node.js

6
2 min read
Criando uma API SQL para Twitter com Typescript - Parte 0

Criando uma API SQL para Twitter com Typescript - Parte 0

4
2 min read
Effective SQL - Indexing and denormalizing JSONB

Effective SQL - Indexing and denormalizing JSONB

33
4 min read
Five classic SQL & database posts - February 2021

Five classic SQL & database posts - February 2021

37
2 min read
The “insert if not exists�? challenge: a solution

The “insert if not exists�? challenge: a solution

7
6 min read
How do I add an item to a database without reloading the page?

How do I add an item to a database without reloading the page?

9 8
1 min read
CRUD with C#/SQL in .NET Core

CRUD with C#/SQL in .NET Core

6 2
2 min read
Get your SQL functions in DQL

Get your SQL functions in DQL

5
2 min read
Console.bLog(studyNotes)

Console.bLog(studyNotes)

4
5 min read
The difference between regular views and materialized views in PostgreSQL

The difference between regular views and materialized views in PostgreSQL

7
1 min read
SQL 101: How Databases and Tables Are Structured

SQL 101: How Databases and Tables Are Structured

2
5 min read
Forget SQL vs NoSQL - Get the Best of Both Worlds with JSON in PostgreSQL

Forget SQL vs NoSQL - Get the Best of Both Worlds with JSON in PostgreSQL

15
8 min read
10 Things I Hate About SQL

10 Things I Hate About SQL

11 14
8 min read
SQL query from the view: considered hazardous!

SQL query from the view: considered hazardous!

7 4
5 min read
SQL & database wrap up - January 2021

SQL & database wrap up - January 2021

12 2
2 min read
SQL Server 2019 for Data Professionals

SQL Server 2019 for Data Professionals

2
2 min read
SQL Review

SQL Review

2
2 min read
Introducing SAYN: A Simple Yet Powerful Data Processing Framework.

Introducing SAYN: A Simple Yet Powerful Data Processing Framework.

3 1
5 min read
Slow Queries? 10X Query Performance with a Database Index

Slow Queries? 10X Query Performance with a Database Index

5
5 min read
The Town Analogy for database architecture

The Town Analogy for database architecture

1
3 min read
Sort by timestamps (month and year) in PostgreSQL

Sort by timestamps (month and year) in PostgreSQL

5
1 min read
Get the current unix timestamp in oracle

Get the current unix timestamp in oracle

6
1 min read
WishList Feature for eCommerce App using Java and Spring Boot

WishList Feature for eCommerce App using Java and Spring Boot

8
7 min read
Implementing months_between() function in BigQuery

Implementing months_between() function in BigQuery

10
6 min read
UUIDs vs Auto-Incrementing Primary Keys in SQL

UUIDs vs Auto-Incrementing Primary Keys in SQL

21 1
7 min read
SQL is 50 Years Old. What Can We Learn From Its Success?

SQL is 50 Years Old. What Can We Learn From Its Success?

2
11 min read
For relational algebra, there will be better alternatives to SQL (the language)?

For relational algebra, there will be better alternatives to SQL (the language)?

9 2
1 min read
Reporting in Power BI - Quick Steps

Reporting in Power BI - Quick Steps

2
1 min read
Taking Ownership of Our Data Pipelines: Analytics Engineering Using dbt

Taking Ownership of Our Data Pipelines: Analytics Engineering Using dbt

2
14 min read
SQL for Beginners

SQL for Beginners

4 min read
Hacking Ecto: Constructing Ecto Query from Raw SQL

Hacking Ecto: Constructing Ecto Query from Raw SQL

6
3 min read
Trigger Warning! A Complete Guide to SQL Triggers - Setting up DB Tracking in Postgres

Trigger Warning! A Complete Guide to SQL Triggers - Setting up DB Tracking in Postgres

2
10 min read
Case sensitivity in SQL

Case sensitivity in SQL

3
1 min read
SQLite findings (on JSON and others)

SQLite findings (on JSON and others)

6
3 min read
How to insert date in MySQL using PHP

How to insert date in MySQL using PHP

3 1
3 min read
Step by step guide on how to create an Asp.Net Core MVC CRUD, Ef Core code first approach

Step by step guide on how to create an Asp.Net Core MVC CRUD, Ef Core code first approach

6
8 min read
Three differences between TRUNCATE and DELETE

Three differences between TRUNCATE and DELETE

6
4 min read
Bulk Update: Active Record Vs. raw SQL

Bulk Update: Active Record Vs. raw SQL

5
5 min read
Different Types of SQL JOINs

Different Types of SQL JOINs

4 2
2 min read
Faster SQL Bulk Inserts With C#

Faster SQL Bulk Inserts With C#

15 2
8 min read
Backup Postgres to S3

Backup Postgres to S3

7 1
1 min read
Assembling a query optimizer with Apache Calcite

Assembling a query optimizer with Apache Calcite

6
9 min read
How to parse Time in GOLANG work with SQL.

How to parse Time in GOLANG work with SQL.

10 4
2 min read
loading...