Forem

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.
Identity Inserts in Databases: The Debate Between Control and Flexibility (And What Benjamin Franklin Has to Do With It)
Cover image for 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
BULK COLLECT and FORALL in PLSQL
mrcaption49 profile

BULK COLLECT and FORALL in PLSQL

#sql #plsql #fullstack #devops
2
Comments
2 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
Unlocking Clean Data: Mastering Key EDA Operations Using SQL
Cover image for Unlocking Clean Data: Mastering Key EDA Operations Using SQL
edvichuki profile

Unlocking Clean Data: Mastering Key EDA Operations Using SQL

#sql #postgres #datascience #analytics
1
Comments
3 min read
MySQL Basics: Understanding DDL, DML, DQL, DCL, and TPL with Examples
Cover image for 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
PL/SQL Developer, interview questions
mrcaption49 profile

PL/SQL Developer, interview questions

#webdev #plsql #sql #fullstack
2
Comments
8 min read
Stored Procedure in PL/SQL
mrcaption49 profile

Stored Procedure in PL/SQL

#sql #oracle #fullstack #devops
2
Comments
2 min read
Open sourcing our new Text-to-SQL LLM app starter template
Cover image for 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
Cover image for Discover the Power of SQL: Mastering the 'Biology Course Alumni Search' Project
labby profile

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

#labex #sql #mysql #programming
1
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
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
14
Comments 1
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
5
Comments
6 min read
Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL
Cover image for 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
26
Comments
7 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
8
Comments
3 min read
Boosting PostgreSQL Performance: Optimising Queries with the != Operator
Cover image for Boosting PostgreSQL Performance: Optimising Queries with the != Operator
sasikumart profile

Boosting PostgreSQL Performance: Optimising Queries with the != Operator

#database #postgres #sql #performance
4
Comments
8 min read
How to create a table with SQL code?
Cover image for How to create a table with SQL code?
jing_li profile

How to create a table with SQL code?

#sql #database #ai #opensource
3
Comments
6 min read
Scenario 2: Mastering Backfilling for New dB Columns – Update Like a Pro!
Cover image for Scenario 2: Mastering Backfilling for New dB Columns – Update Like a Pro!
chidioguejiofor profile

Scenario 2: Mastering Backfilling for New dB Columns – Update Like a Pro!

#sql #typescript #backenddevelopment #performance
1
Comments
4 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!
Cover image for 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
13
Comments 3
3 min read
Turbocharge Your App: Slash DB Calls with Raw SQL Magic!
Cover image for 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
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
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
Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example
Cover image for 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
Logical Processing order of a SQL query
mrcaption49 profile

Logical Processing order of a SQL query

#sql #plsql #backend #database
9
Comments 2
4 min read
PL/SQL Cursors
mrcaption49 profile

PL/SQL Cursors

#sql #backend #database #fullstack
2
Comments 2
4 min read
loading...