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.
The Real Costs of ETL and How MindsDB Eliminates Them
mindsdbteam profile

The Real Costs of ETL and How MindsDB Eliminates Them

#ai #sql #datascience
1
Comments
8 min read
SQLite Scalar function: 3 valued iif and if scalar function
mr_destructive profile

SQLite Scalar function: 3 valued iif and if scalar function

#sql #sqlite #database #programming
Comments
3 min read
Working with Cursors and Triggers in Oracle Live SQL
lohita_blue_d6409977eec4c profile

Working with Cursors and Triggers in Oracle Live SQL

#sql #database #tutorial
2
Comments
2 min read
From SQL to Python: Uniting Stored Power with Functional Flexibility
loi2008 profile

From SQL to Python: Uniting Stored Power with Functional Flexibility

#database #backend #sql #python
Comments
5 min read
SQLite functions: unistr and unistr quote
mr_destructive profile

SQLite functions: unistr and unistr quote

#sqlite #sql #database #backend
Comments
2 min read
SQLite dot commands: run system shell commands
mr_destructive profile

SQLite dot commands: run system shell commands

#sql #sqlite #database #programming
1
Comments
1 min read
Building InnerJoin: A SQL Practice Platform in 3 Months
nick_lisauskas_658b6bfd3a profile

Building InnerJoin: A SQL Practice Platform in 3 Months

#showdev #startup #sql #webdev
1
Comments
6 min read
Is SPL more difficult or easier than SQL?
esproc_spl profile

Is SPL more difficult or easier than SQL?

#discuss #programming #opensource #sql
5
Comments
15 min read
Understanding Database Normalization (1NF, 2NF, 3NF) with SQL Examples
boopathys_8ff57c77ea5a5e profile

Understanding Database Normalization (1NF, 2NF, 3NF) with SQL Examples

#database #design #tutorial #sql
Comments
2 min read
Introducing MindsDB’s Integration with Gong: AI Analytics on Call Data
mindsdbteam profile

Introducing MindsDB’s Integration with Gong: AI Analytics on Call Data

#ai #sql
5
Comments
7 min read
Battling Laravel's Sneaky DELETEs: How I Got ORDER BY and LIMIT to Play Nice with Joins
tegos profile

Battling Laravel's Sneaky DELETEs: How I Got ORDER BY and LIMIT to Play Nice with Joins

#laravel #mysql #database #sql
10
Comments 2
3 min read
SQLite dot commands: read command is recursive?
mr_destructive profile

SQLite dot commands: read command is recursive?

#sql #sqlite #database #programming
1
Comments
2 min read
SQL LIKE Operator: What It Is, How It Works, and Best Practices
dbvismarketing profile

SQL LIKE Operator: What It Is, How It Works, and Best Practices

#sql #mysql #postgressql
Comments
2 min read
Indexing, Hashing & Query Optimization in SQL
naveens_k_403279738dbcab6 profile

Indexing, Hashing & Query Optimization in SQL

#database #performance #algorithms #sql
2
Comments
2 min read
Transactions, Deadlocks & Log Based Recovery in SQL
naveens_k_403279738dbcab6 profile

Transactions, Deadlocks & Log Based Recovery in SQL

#acid #deadlock #logging #sql
2
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.