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.
Templating Columns in dbt: Helpful path to forward
chaets profile

Templating Columns in dbt: Helpful path to forward

#dbt #datatransformation #datamodelling #sql
1
Comments
6 min read
DataPump : Disabling the Use of Symbolic Links When Creating a Directory
vahidusefzadeh profile

DataPump : Disabling the Use of Symbolic Links When Creating a Directory

#oracle #database #sql #linux
Comments
2 min read
From SQL to AI: A Fun Look at Conflict Detection Methods in MariaDB and PostgreSQL
igornosatov_15 profile

From SQL to AI: A Fun Look at Conflict Detection Methods in MariaDB and PostgreSQL

#database #postgres #sql #ai
Comments
4 min read
Handle Large PostgreSQL Schemas with a GUI Tool
roxana_haidiner profile

Handle Large PostgreSQL Schemas with a GUI Tool

#postgres #postgressql #database #sql
6
Comments
3 min read
concat() vs Group_concat()
ashok_kumar_564581944e3ef profile

concat() vs Group_concat()

#datascience #sql #mysql #dataanalytics
1
Comments
1 min read
SQLite dot commands: change directory command
mr_destructive profile

SQLite dot commands: change directory command

#sql #sqlite #database #programming
1
Comments
1 min read
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.