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.
Cost Explorer Isn't the Answer

Cost Explorer Isn't the Answer

Comments
6 min read
MariaDd Quick-tip #10 - Select table definition

MariaDd Quick-tip #10 - Select table definition

Comments 2
2 min read
O que é ORM - Mapeamento objeto-relacional

O que é ORM - Mapeamento objeto-relacional

4
Comments
2 min read
Calculate average delta change in KPIs over a period of time.

Calculate average delta change in KPIs over a period of time.

1
Comments
2 min read
Data Engineering 101:Introduction to Data Engineering

Data Engineering 101:Introduction to Data Engineering

4
Comments
3 min read
Online SQL Client for low code data management

Online SQL Client for low code data management

5
Comments 1
5 min read
SQL - Foundation of Databases

SQL - Foundation of Databases

1
Comments
5 min read
ActiveRecord (a Ruby gem): Common Methods

ActiveRecord (a Ruby gem): Common Methods

Comments
4 min read
Parallelizing aggregates in YugabyteDB

Parallelizing aggregates in YugabyteDB

2
Comments
4 min read
Introduction to data engineering

Introduction to data engineering

5
Comments
4 min read
New in Entity Framework 7: Bulk Operations with ExecuteDelete and ExecuteUpdate

New in Entity Framework 7: Bulk Operations with ExecuteDelete and ExecuteUpdate

8
Comments 2
5 min read
Fastest start of YugabyteDB for a small lab

Fastest start of YugabyteDB for a small lab

1
Comments
2 min read
Adding business days to a date using SQL

Adding business days to a date using SQL

3
Comments 3
1 min read
Databases: SQL vs NoSQL

Databases: SQL vs NoSQL

4
Comments
6 min read
How to configure Azure SQL Always Encrypted for Mac users

How to configure Azure SQL Always Encrypted for Mac users

Comments
9 min read
Using Rails Model or SQL query in Ruby On Rails

Using Rails Model or SQL query in Ruby On Rails

3
Comments
1 min read
Find the Retention Rates – Salesforce SQL Interview Question

Find the Retention Rates – Salesforce SQL Interview Question

2
Comments
7 min read
Write your first QueryBuilder with PDO and PHP

Write your first QueryBuilder with PDO and PHP

4
Comments 1
7 min read
The Mystery of RDS Costs

The Mystery of RDS Costs

9
Comments 1
5 min read
DistSQL Applications: Building a Dynamic Distributed Database

DistSQL Applications: Building a Dynamic Distributed Database

5
Comments
9 min read
Freelancing or Part time job in Data Analysis or Visualisation

Freelancing or Part time job in Data Analysis or Visualisation

6
Comments
1 min read
MySQL

MySQL

1
Comments
3 min read
Forget SQL, All My Homies Use LINQ

Forget SQL, All My Homies Use LINQ

22
Comments 1
2 min read
MongoDB $weeklyUpdate #82 (August 12, 2022): Community Cafe, Atlas Search, & International MUGs!

MongoDB $weeklyUpdate #82 (August 12, 2022): Community Cafe, Atlas Search, & International MUGs!

6
Comments
3 min read
3 Ways of Integrating Python With SQL Server Every Data Professional Should Know About

3 Ways of Integrating Python With SQL Server Every Data Professional Should Know About

10
Comments
4 min read
Finding mean, median, and mode using SQL.

Finding mean, median, and mode using SQL.

8
Comments
2 min read
Bookmarklet for YugabyteDB table's tablets

Bookmarklet for YugabyteDB table's tablets

4
Comments
2 min read
SQL DB Backup with PowerShell GUI - Tutorial

SQL DB Backup with PowerShell GUI - Tutorial

5
Comments
9 min read
Understanding INNER, OUTER, LEFT, and RIGHT Joins in SQL

Understanding INNER, OUTER, LEFT, and RIGHT Joins in SQL

6
Comments
11 min read
SQL Injections Explained

SQL Injections Explained

8
Comments 1
5 min read
Insert and query jsonb in rails and postgres

Insert and query jsonb in rails and postgres

14
Comments 2
8 min read
Predicting Supermarket Future Sales Using Machine Learning with MindsDB.

Predicting Supermarket Future Sales Using Machine Learning with MindsDB.

3
Comments
6 min read
Exploratory Data Analysis Using SQL.

Exploratory Data Analysis Using SQL.

9
Comments 2
3 min read
Codewars Challenge Day 5: JS, Python + SQL and PHP

Codewars Challenge Day 5: JS, Python + SQL and PHP

5
Comments
2 min read
Update & delete JSONB in rails and postgres

Update & delete JSONB in rails and postgres

12
Comments
8 min read
Oracle TO_DATE Function - Complete Guide

Oracle TO_DATE Function - Complete Guide

3
Comments
3 min read
Joins In SQL Server mesameergaikwad

Joins In SQL Server mesameergaikwad

6
Comments
1 min read
Cybersecurity Programming: SQL Injection Scanner with Python

Cybersecurity Programming: SQL Injection Scanner with Python

18
Comments
1 min read
TypeORM unique indices with multiple fields

TypeORM unique indices with multiple fields

4
Comments 3
2 min read
Rails: Self Referential Tables

Rails: Self Referential Tables

6
Comments 1
3 min read
Data Analyst Roadmap: more than just the tools

Data Analyst Roadmap: more than just the tools

41
Comments 8
6 min read
JSON Primitive Types and Corresponding PostgreSQL Types

JSON Primitive Types and Corresponding PostgreSQL Types

7
Comments
5 min read
Top 5 MariaDB GUI tools in 2022

Top 5 MariaDB GUI tools in 2022

13
Comments
7 min read
Your Old Laptop Is Your New Database Server

Your Old Laptop Is Your New Database Server

165
Comments 12
8 min read
Embedded FerretDB with YugabyteDB: MongoDB API on distributed SQL 🚀☁

Embedded FerretDB with YugabyteDB: MongoDB API on distributed SQL 🚀☁

4
Comments 2
4 min read
Should I Learn PostgreSQL?

Should I Learn PostgreSQL?

9
Comments
3 min read
Understanding a Data Model

Understanding a Data Model

3
Comments 1
2 min read
Azure SQL Database Tools Part 4: Other Platform Tools

Azure SQL Database Tools Part 4: Other Platform Tools

4
Comments
3 min read
Deriving Ideal Indexes For Your SQL Database: A Guide

Deriving Ideal Indexes For Your SQL Database: A Guide

1
Comments
6 min read
Recursive CTEs in CockroachDB

Recursive CTEs in CockroachDB

Comments
4 min read
Essential SQL commands for database management

Essential SQL commands for database management

21
Comments 1
13 min read
SQL JOINS

SQL JOINS

10
Comments 1
2 min read
MariaDb Quick-tip #6 - Find table or column

MariaDb Quick-tip #6 - Find table or column

3
Comments
2 min read
Will NoSQL Databases Replace SQL Databases in the future

Will NoSQL Databases Replace SQL Databases in the future

6
Comments 1
4 min read
🟩🚀 Draxlr SQL query/dashboard builder on YugabyteDB managed

🟩🚀 Draxlr SQL query/dashboard builder on YugabyteDB managed

12
Comments
3 min read
Build error SQL46005: Expected FILESTREAM_ON but encountered object instead

Build error SQL46005: Expected FILESTREAM_ON but encountered object instead

Comments
1 min read
Why ORMs Aren't Always a Great Idea

Why ORMs Aren't Always a Great Idea

138
Comments 48
9 min read
The Darker Side of ALTER TABLE: A Guide

The Darker Side of ALTER TABLE: A Guide

2
Comments
5 min read
Default tablet splitting in YugabyteDB 🚀

Default tablet splitting in YugabyteDB 🚀

7
Comments
6 min read
Universe will collapse before you need BIGINT for milliseconds in JavaScript

Universe will collapse before you need BIGINT for milliseconds in JavaScript

7
Comments
2 min read
loading...