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.
Primary Key and Foreign Key in SQL | Part 1
mrcaption49 profile

Primary Key and Foreign Key in SQL | Part 1

#sql #backend #fullstack #devops
1
Comments
2 min read
The Ultimate Guide to Data Analytics
anna_m profile

The Ultimate Guide to Data Analytics

#dataanalytics #python #sql #datavisualization
Comments
2 min read
%TYPE and %ROWTYPE Attributes in PLSQL
mrcaption49 profile

%TYPE and %ROWTYPE Attributes in PLSQL

#sql #fullstack #backend #oracle
5
Comments
2 min read
BULK COLLECT in PL/SQL
mrcaption49 profile

BULK COLLECT in PL/SQL

#plsql #sql #database #devops
1
Comments
5 min read
Difference between UNION and UNION ALL in SQL
mrcaption49 profile

Difference between UNION and UNION ALL in SQL

#sql #oracle #fullstack #backend
Comments
2 min read
Cursor Types in PLSQL -Normal cursor and Reference cursor
mrcaption49 profile

Cursor Types in PLSQL -Normal cursor and Reference cursor

#sql #devops #fullstack #backend
6
Comments
4 min read
Spring Data JPA Method Naming Conventions: Build Queries Without Writing SQL
krishna-nayak profile

Spring Data JPA Method Naming Conventions: Build Queries Without Writing SQL

#sql #springboot #java #learning
1
Comments 1
2 min read
Cursor in PLSQL - Best Explanation
mrcaption49 profile

Cursor in PLSQL - Best Explanation

#sql #plsql #oracle #fullstack
Comments
2 min read
Masking in SQL | PART 1
mrcaption49 profile

Masking in SQL | PART 1

#sql #backend #fullst #backenddevelopment
1
Comments
2 min read
Common Table Expression (CTE) in PLSQL | Part 2
mrcaption49 profile

Common Table Expression (CTE) in PLSQL | Part 2

#webdev #sql #fullstack #devpride
5
Comments
2 min read
Trigger in PL/SQL with Example - Part 2 | AFTER Trigger
mrcaption49 profile

Trigger in PL/SQL with Example - Part 2 | AFTER Trigger

#sql #fullstack #backend #database
8
Comments
2 min read
Introduction to SQL
darkworldprogrammer profile

Introduction to SQL

#sql
Comments 2
3 min read
Trigger in PL/SQL with Example - Part 1 | BEFORE Trigger
mrcaption49 profile

Trigger in PL/SQL with Example - Part 1 | BEFORE Trigger

#sql #database #fullstack #backend
2
Comments
2 min read
SQL - Sub Queries
mrcaption49 profile

SQL - Sub Queries

#sql #plsql #fullstack #database
2
Comments
3 min read
Cursor in PLSQL
mrcaption49 profile

Cursor in PLSQL

#sql #oracle #database #fullstack
7
Comments
5 min read
Mastering SQL Queries: The 'Format Query for Teacher Salary' Project
labby profile
Labby for LabEx

Mastering SQL Queries: The 'Format Query for Teacher Salary' Project

#labex #sql #mysql #programming
1
Comments
3 min read
SQL 101: INTRODUCTION TO SQL FOR DATA ANALYTICS
john_analytics profile

SQL 101: INTRODUCTION TO SQL FOR DATA ANALYTICS

#sql #datascience #data #analytics
1
Comments
4 min read
MySQL Basics: Understanding Isolation Level and Transaction Anomalies
ronnychen profile

MySQL Basics: Understanding Isolation Level and Transaction Anomalies

#sql #mysql
1
Comments
4 min read
PL/SQL collections - Associative Arrays, Nested Tables & VARRAYs.
mrcaption49 profile

PL/SQL collections - Associative Arrays, Nested Tables & VARRAYs.

#sql #development #devops #fullstack
6
Comments
2 min read
BULK COLLECT and FORALL in PLSQL
mrcaption49 profile

BULK COLLECT and FORALL in PLSQL

#sql #plsql #fullstack #devops
2
Comments
2 min read
Identity Inserts in Databases: The Debate Between Control and Flexibility (And What Benjamin Franklin Has to Do With It)
art_grig profile

Identity Inserts in Databases: The Debate Between Control and Flexibility (And What Benjamin Franklin Has to Do With It)

#database #sql #sqlserver #postgres
3
Comments
4 min read
The Difference between Each Value in a Certain Column and Its Previous One and Display Result
esproc_spl profile
Judy

The Difference between Each Value in a Certain Column and Its Previous One and Display Result

#sql #development #spl #esproc
6
Comments
2 min read
Unlocking Clean Data: Mastering Key EDA Operations Using SQL
edvichuki profile

Unlocking Clean Data: Mastering Key EDA Operations Using SQL

#sql #postgres #datascience #analytics
3
Comments
3 min read
PL/SQL Developer, interview questions
mrcaption49 profile

PL/SQL Developer, interview questions

#webdev #plsql #sql #fullstack
2
Comments
8 min read
Why should you upgrade your PostgreSQL today?
cezz profile

Why should you upgrade your PostgreSQL today?

#postgres #security #database #sql
1
Comments 1
3 min read
.NET8/EF8 - Exception: Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$
markpelf profile

.NET8/EF8 - Exception: Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '$

#ef8 #sqlserver #csharp #sql
1
Comments
4 min read
MySQL Basics: Understanding DDL, DML, DQL, DCL, and TPL with Examples
ronnychen profile

MySQL Basics: Understanding DDL, DML, DQL, DCL, and TPL with Examples

#mysql #sql
Comments
5 min read
Stored Procedure in PL/SQL
mrcaption49 profile

Stored Procedure in PL/SQL

#sql #oracle #fullstack #devops
2
Comments
2 min read
Best PostgreSQL Queries/Functions for Daily Operations
mdarifulhaque profile

Best PostgreSQL Queries/Functions for Daily Operations

#sql #postgressql #tutorial #backend
2
Comments 2
4 min read
Java, perform COUNT on each group of a large csv file #eg33
esproc_spl profile
Judy

Java, perform COUNT on each group of a large csv file #eg33

#sql #development #database #esproc
6
Comments
2 min read
Open sourcing our new Text-to-SQL LLM app starter template
natalie_inductor profile

Open sourcing our new Text-to-SQL LLM app starter template

#opensource #sql #ai #database
1
Comments
6 min read
Discover the Power of SQL: Mastering the 'Biology Course Alumni Search' Project
labby profile
Labby for LabEx

Discover the Power of SQL: Mastering the 'Biology Course Alumni Search' Project

#labex #sql #mysql #programming
Comments
3 min read
How to Delete Duplicate Data from a MySQL Database
javafullstackdev profile

How to Delete Duplicate Data from a MySQL Database

#database #sql #java #tutorial
Comments
4 min read
Group and Summarize data, and align to the specified sequence #eg31
esproc_spl profile
Judy

Group and Summarize data, and align to the specified sequence #eg31

#sql #development #programming #spl
6
Comments
1 min read
Common Table Expression (CTE) in PLSQL | Part 1
mrcaption49 profile

Common Table Expression (CTE) in PLSQL | Part 1

#sql #database #oracle #backend
4
Comments
6 min read
List of the best Google Dorks in 2024 for finding SQL injection vulnerabilities and other security issues:
trixsec profile

List of the best Google Dorks in 2024 for finding SQL injection vulnerabilities and other security issues:

#sql #security #google #cybersecurity
12
Comments
1 min read
Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL
leandro_nnz profile

Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL

#oracle #database #tutorial #sql
18
Comments
7 min read
Insert data into tables - SQL
mrcaption49 profile

Insert data into tables - SQL

#sql #database #backend #fullstack
5
Comments
2 min read
RANK,ROW_NUMBER and DENSE_RANK
mrcaption49 profile

RANK,ROW_NUMBER and DENSE_RANK

#sql #backend #fullstack #devops
2
Comments
2 min read
Aggregate Functions vs Window Functions in SQL
mrcaption49 profile

Aggregate Functions vs Window Functions in SQL

#sql #backend #database #fullstack
5
Comments
2 min read
SQLMap Cheat Sheet: A Quick Guide for Automated SQL Injection
trixsec profile

SQLMap Cheat Sheet: A Quick Guide for Automated SQL Injection

#sql #python #cybersecurity #devops
7
Comments
3 min read
Boosting PostgreSQL Performance: Optimising Queries with the != Operator
sasikumart profile

Boosting PostgreSQL Performance: Optimising Queries with the != Operator

#database #postgres #sql #performance
3
Comments
8 min read
How to create a table with SQL code?
jing_li profile
Jing for Chat2DB

How to create a table with SQL code?

#sql #database #ai #opensource
3
Comments
6 min read
SQL, extract unique values of JSON format field from each group #eg42
esproc_spl profile
Judy

SQL, extract unique values of JSON format field from each group #eg42

#sql #json #programming #esproc
6
Comments
2 min read
How to Downsample Your Data Efficiently
dolphindb profile

How to Downsample Your Data Efficiently

#database #dolphindb #quant #sql
Comments
2 min read
Scenario 1: When You Need to Update Multiple Rows with Different Values – The Smart Way!
chidioguejiofor profile

Scenario 1: When You Need to Update Multiple Rows with Different Values – The Smart Way!

#sql #typescript #backenddevelopment #performance
3
Comments 3
3 min read
Transaction Control Language TCL - COMMIT, ROLLBACK, and SAVEPOINT
mrcaption49 profile

Transaction Control Language TCL - COMMIT, ROLLBACK, and SAVEPOINT

#sql #plsql #database #backend
4
Comments
3 min read
Unlocking the Power of Text-to-SQL with LangDB
berasayantan profile

Unlocking the Power of Text-to-SQL with LangDB

#datascience #sql #tutorial #langdb
2
Comments
3 min read
CASE | DECODE | IF ELSE - Conditional Logic in PLSQL
mrcaption49 profile

CASE | DECODE | IF ELSE - Conditional Logic in PLSQL

#sql #plsql #backend #database
1
Comments
2 min read
Turbocharge Your App: Slash DB Calls with Raw SQL Magic!
chidioguejiofor profile

Turbocharge Your App: Slash DB Calls with Raw SQL Magic!

#sql #typescript #performance #sequelize
4
Comments
2 min read
How to send a message to Slack workspace members using an SQL statement
sqlman profile

How to send a message to Slack workspace members using an SQL statement

#sql #sqlmessenger #slack
Comments
2 min read
Logical Processing order of a SQL query
mrcaption49 profile

Logical Processing order of a SQL query

#sql #plsql #backend #database
8
Comments 2
4 min read
Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example
dm8ry profile

Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example

#postgres #database #howto #sql
Comments
3 min read
PL/SQL Cursors
mrcaption49 profile

PL/SQL Cursors

#sql #backend #database #fullstack
4
Comments 2
4 min read
DbVisualizer 24.2: A Complete Review
antozanini profile

DbVisualizer 24.2: A Complete Review

#news #sql #database #productivity
10
Comments
11 min read
PL/SQL Triggers
mrcaption49 profile

PL/SQL Triggers

#sql #plsql #backend #database
1
Comments
3 min read
Deleting Duplicate Data from MySQL
nikhilxd profile

Deleting Duplicate Data from MySQL

#database #sql #programming #tutorial
1
Comments
3 min read
Different ways of working with SQL Databases in Go
der_gopher profile

Different ways of working with SQL Databases in Go

#go #sql #database
2
Comments
9 min read
PLSQL Top 10 Interview Questions
mrcaption49 profile

PLSQL Top 10 Interview Questions

#plsql #sql #backend #fullstack
1
Comments
4 min read
How I used ChatGPT o1 and Claude for generating a SQL RBAC report and was surprised by the results
juanstoppa profile

How I used ChatGPT o1 and Claude for generating a SQL RBAC report and was surprised by the results

#chatgpt #claude #rbac #sql
1
Comments
9 min read
loading...