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.
HackerRank SQL Preparation: Japanese Cities' Names(MySQL)

HackerRank SQL Preparation: Japanese Cities' Names(MySQL)

1
Comments
1 min read
HackerRank SQL Preparation: Weather Observation Station 1(MySQL)

HackerRank SQL Preparation: Weather Observation Station 1(MySQL)

1
Comments
1 min read
Understanding Primary Keys and Foreign Keys in SQL: A Simple and Detailed Guide

Understanding Primary Keys and Foreign Keys in SQL: A Simple and Detailed Guide

Comments
3 min read
Resolving the "Length of LOB Data (78862) to be Replicated Exceeds Configured Maximum 65536" Error

Resolving the "Length of LOB Data (78862) to be Replicated Exceeds Configured Maximum 65536" Error

Comments
2 min read
Now connect SQL with no-code as a data source

Now connect SQL with no-code as a data source

Comments
1 min read
Basic Operations and Integration in Python & SQLite

Basic Operations and Integration in Python & SQLite

Comments
3 min read
Implementing UI Automation Testing for Desktop Applications Dealing With Different DBMS

Implementing UI Automation Testing for Desktop Applications Dealing With Different DBMS

Comments
10 min read
INTRODUCTION TO WEBSITE HACKING

INTRODUCTION TO WEBSITE HACKING

1
Comments
3 min read
SQL Mastery: Unleashing the Power of Queries

SQL Mastery: Unleashing the Power of Queries

Comments
4 min read
NULL Handling in SQL

NULL Handling in SQL

Comments
3 min read
Understanding the SQL ORDER BY Clause

Understanding the SQL ORDER BY Clause

Comments
3 min read
Pedaling Through Data: A Wheelie Fun Bike Rental Analysis with Python and PostgreSQL

Pedaling Through Data: A Wheelie Fun Bike Rental Analysis with Python and PostgreSQL

1
Comments
4 min read
SQL generation: Golang's builder pattern vs Clojure's persistent map

SQL generation: Golang's builder pattern vs Clojure's persistent map

Comments
4 min read
Effortlessly Migrate Your Databases to Azure SQL With Expert Guide

Effortlessly Migrate Your Databases to Azure SQL With Expert Guide

5
Comments 4
4 min read
Criei um banco de dados baseado no Universo de One Piece

Criei um banco de dados baseado no Universo de One Piece

1
Comments
4 min read
Partitions, Merge Append, Pagination, and Limit pushdown in YugabyteDB

Partitions, Merge Append, Pagination, and Limit pushdown in YugabyteDB

Comments
6 min read
Changing SQL Dialect From Teradata To SQLite

Changing SQL Dialect From Teradata To SQLite

Comments
14 min read
Key Factors to Consider for Effective Database Design (Constraints, Indexes)

Key Factors to Consider for Effective Database Design (Constraints, Indexes)

Comments
5 min read
LibSQL Driver for Laravel

LibSQL Driver for Laravel

Comments
2 min read
HackerRank SQL Preparation: Japanese Cities' Attributes(MySQL)

HackerRank SQL Preparation: Japanese Cities' Attributes(MySQL)

1
Comments
1 min read
HackerRank SQL Preparation: Select All(MySQL)

HackerRank SQL Preparation: Select All(MySQL)

1
Comments
1 min read
HackerRank SQL Preparation: Select by ID(MySQL)

HackerRank SQL Preparation: Select by ID(MySQL)

1
Comments
1 min read
Data for World Map Panel Plugin in Grafana from MySQL

Data for World Map Panel Plugin in Grafana from MySQL

Comments
4 min read
What kind of OLAP do we need?

What kind of OLAP do we need?

5
Comments 1
5 min read
Row Level Security In SQL Server

Row Level Security In SQL Server

1
Comments
3 min read
YB-Master, the YugabyteDB Universe control plane

YB-Master, the YugabyteDB Universe control plane

Comments
5 min read
Constraints in SQL: Enforcing Data Integrity

Constraints in SQL: Enforcing Data Integrity

Comments
3 min read
Introducing OpenMLDB’s New Feature: Feature Signatures — Enabling Complete Feature Engineering with SQL

Introducing OpenMLDB’s New Feature: Feature Signatures — Enabling Complete Feature Engineering with SQL

5
Comments
4 min read
Array Expansion in Flink SQL

Array Expansion in Flink SQL

2
Comments
6 min read
Enhancing PHP Projects With SQL Server

Enhancing PHP Projects With SQL Server

Comments
1 min read
Then let’s talk about discreteness, and what are the advantages of Java over SQL?

Then let’s talk about discreteness, and what are the advantages of Java over SQL?

6
Comments 1
5 min read
Banco de dados: Modelo conceitual

Banco de dados: Modelo conceitual

1
Comments
9 min read
Understanding Data Manipulation Language(DML) statements in SQL

Understanding Data Manipulation Language(DML) statements in SQL

Comments
5 min read
Database indexing and selectivity

Database indexing and selectivity

Comments
1 min read
PostgreSQL on steroids - how to ace your database configuration

PostgreSQL on steroids - how to ace your database configuration

Comments
8 min read
Understanding set orientation from the comparison between SQL and Java, and what are the advantages of SQL over Java?

Understanding set orientation from the comparison between SQL and Java, and what are the advantages of SQL over Java?

6
Comments 1
5 min read
Unlock your career in data analytics 2024

Unlock your career in data analytics 2024

Comments 1
1 min read
Server-side cache for YugabyteDB sequences to workaround the Nspgl `DISCARD SEQUENCES`

Server-side cache for YugabyteDB sequences to workaround the Nspgl `DISCARD SEQUENCES`

Comments
4 min read
Dapper mappings, which is best?

Dapper mappings, which is best?

Comments
2 min read
How to setup MySql on MacOS using Brew.

How to setup MySql on MacOS using Brew.

Comments
1 min read
From GUI to CLI: Transforming my query workflow with usql and jq

From GUI to CLI: Transforming my query workflow with usql and jq

1
Comments
3 min read
The ARRAY_TO_STRING() function in PostgreSQL

The ARRAY_TO_STRING() function in PostgreSQL

Comments
2 min read
Populating a table in PostgreSQL with one million records of random data.

Populating a table in PostgreSQL with one million records of random data.

Comments
1 min read
The main methods of joining tables in PostgreSQL.

The main methods of joining tables in PostgreSQL.

Comments
3 min read
Understanding SQL Joins: A Comprehensive Guide

Understanding SQL Joins: A Comprehensive Guide

5
Comments 1
9 min read
Writing complex SQL queries with AND and OR operators

Writing complex SQL queries with AND and OR operators

Comments
1 min read
How do SQL interprets nulls?

How do SQL interprets nulls?

Comments
2 min read
Order-based Merge Join

Order-based Merge Join

5
Comments
6 min read
Magia e MĂşsculos: ETL com Mage e DuckDB com dados do meu treino de powerlifting

Magia e MĂşsculos: ETL com Mage e DuckDB com dados do meu treino de powerlifting

3
Comments
3 min read
How to Build a Custom Client Portal In Five Steps

How to Build a Custom Client Portal In Five Steps

3
Comments
12 min read
Crash on clock skew: performance vs availability

Crash on clock skew: performance vs availability

Comments
7 min read
HackTheBox - Writeup Monitored [Retired]

HackTheBox - Writeup Monitored [Retired]

4
Comments
21 min read
Comprehensive Guide to SQL Operators

Comprehensive Guide to SQL Operators

2
Comments
4 min read
Streamlining Node Property Data Retrieval in Umbraco: A Quick Guide

Streamlining Node Property Data Retrieval in Umbraco: A Quick Guide

Comments
2 min read
OLAP: CUBE, ROLLUP, AND GROUPING SETS

OLAP: CUBE, ROLLUP, AND GROUPING SETS

Comments
4 min read
How to use Kimball Helper Table(PostgreSQL) in Modern Banking for Performance Analysis and Monetisation?

How to use Kimball Helper Table(PostgreSQL) in Modern Banking for Performance Analysis and Monetisation?

Comments
3 min read
Advanced SQL: Mastering Query Optimization and Complex Joins

Advanced SQL: Mastering Query Optimization and Complex Joins

235
Comments 15
7 min read
Mastering Data Management: Designing a Database for an FMCG Alcoholic Beverages Company

Mastering Data Management: Designing a Database for an FMCG Alcoholic Beverages Company

3
Comments
4 min read
A Comprehensive Guide to Extracting Data from MySQL Using Singer ETL

A Comprehensive Guide to Extracting Data from MySQL Using Singer ETL

Comments
2 min read
A programming language coding in a grid

A programming language coding in a grid

8
Comments 1
17 min read
loading...