Skip to content

DEV Community

select * from SQL

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

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Apr 1 '24

HackerRank SQL Preparation: Revising the Select Query I(MySQL)

#sql #writeups #hackerrank

1 min read

Apr 1 '24

An Introduction to SQL Server Query Store

#sql

3 min read

Judy

Apr 1 '24

How to Split Attributes of Same Type in One Row and Convert Them into Multiple Rows

#development #sql #coding #devops

2 min read

Coder Girl 👩🏼‍💻🇨🇴🇲🇽🏳️‍🌈

Mar 31 '24

Las 15 Consultas SQL Desde Lo Más Básico Hasta Lo No Tan Básico

#sql #spanish #python #data

3 min read

Wiliam V. Joaquim

Mar 26 '24

Preventing SQL Injection with Golang

#go #sql #security #tutorial

8 min read

Nathalia Friederichs

Mar 19 '24

Manipulating Dates with SQL Server

#database #sql #programming #learning

5 min read

Mar 30 '24

Optimizing PostgreSQL Trigger Execution: Balancing Precision with Control

#postgres #database #sql #performance

3 min read

Guilherme Martins

Mar 30 '24

HackTheBox - Writeup Analytics

#sql #security #linux #cybersecurity

9 min read

kihuni

Mar 30 '24

Learn SQL with PostgreSQL: Building a Budget Tracking Application

#sql #postgres #webdev #beginners

5 min read

Hafiz Muhammad Attaullah

Mar 29 '24

Deletion of Data = Integrity Impact, Deletion of Data Availability Impact

#cybersecurity #integrity #availability #sql

2 min read

hexfloor

Mar 28 '24

SQL Pro Tips : industrial Oracle SQL using WITH

#sql #oracle #bigdata #database

4 min read

Judy

Mar 28 '24

How to Convert Dates in One Group into An Interval

#sql #database #dataengineering #development

2 min read

Franck Pachot for AWS Heroes

Mar 25 '24

PostgreSQL index Correlation with UPDATE

#postgres #sql #database #index

17 min read

Feb 24 '24

Building a project in DBT

#dbt #dataengineering #bigquery #sql

5 min read

Coder Girl 👩🏼‍💻🇨🇴🇲🇽🏳️‍🌈

Mar 27 '24

Primeros Pasos en SQL: La Piedra Angular de la Ingeniería de Datos

#sql #python

2 min read

jbx1279

Mar 23 '24

How come there are tens of thousands of tables in a database

#database #bigdata #sql

5 min read

Coder Girl 👩🏼‍💻🇨🇴🇲🇽🏳️‍🌈

Mar 26 '24

Desentrañando el Proceso ETL: La Columna Vertebral de la Ciencia de Datos

#database #python #sql #dataengineering

2 min read

Mohammad Alhraki

Mar 15 '24

Understanding Database Normalization and the Importance of 1NF

#webdev #programming #tutorial #sql

3 min read

Nguyen Dinh Nghia

Mar 25 '24

Bulk Insert, Bulk Delete, Bulk Update with Dapper by Bulk.Dapper

#csharp #dapper #sql #dotnet

2 min read

Shiv Iyer

Mar 25 '24

Mastering Performance Troubleshooting with sys.dm_exec_requests in Azure SQL

#azure #sql #sqlserver

2 min read

Christopher Garzon

Mar 25 '24

SQL subqueries: [Step-By-Step] Guide

#sql #sqlsubquerie #sqlcourses #dataengineeracademy

4 min read

Mar 25 '24

SQL vs. Sequel: Navigating the Pronunciation Landscape

#sql

1 min read

Loïc

Mar 25 '24

🤩 Free Oracle Database: Download, Install, Tutorial… My Getting Started Guide 🚀🦭🐳

#learning #sql #quickinstall #oracle

3 min read

Mar 25 '24

Streamlining SQL Queries with the WINDOW Keyword

#sql #beginners

2 min read

Mar 24 '24

Integrating Predictive Analytics Models into SQL Queries

#sql #machinelearning #ai #database

14 min read

loading...