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.
Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16
judith677 profile

Getting Values from Multiple Format Strings to Multiple Records — From SQL to SPL #16

#programming #dataengineering #sql #esprocspl
6
Comments 1
2 min read
SQL vs NoSQL for Large Tables: Choosing the Right Database for Big Data Applications
adityabhuyan profile

SQL vs NoSQL for Large Tables: Choosing the Right Database for Big Data Applications

#bigdata #largetables #sql #nosql
1
Comments
6 min read
What’s a database anyway?? A blog post for kids
dave_macleod_c21bf713723a profile

What’s a database anyway?? A blog post for kids

#database #children #sql #programming
10
Comments
14 min read
SQL Query Optimization for Data Engineers
uendi_hoxha profile

SQL Query Optimization for Data Engineers

#data #dataengineering #sql #tutorial
11
Comments
3 min read
Understanding Data Anomalies and the Power of Database Normalization
joseowino profile

Understanding Data Anomalies and the Power of Database Normalization

#database #sql #programming
1
Comments 2
2 min read
What is SQL? A Simple Guide to Databases and Queries
khushii_34ceada974a6bfcc2 profile

What is SQL? A Simple Guide to Databases and Queries

#sql #learning #database #developers
1
Comments
1 min read
SQL and I Had Beef 😂So I Built a Trigger
jmwendwa profile

SQL and I Had Beef 😂So I Built a Trigger

#programming #beginners #datascience #sql
3
Comments 2
2 min read
Why uber ditched postgres for mysql: What every developer can learn from it
dev_tips profile

Why uber ditched postgres for mysql: What every developer can learn from it

#webdev #programming #postgres #sql
2
Comments
46 min read
The Five Levels Of SQL
mendy_kevin_94ec1db73e1df profile

The Five Levels Of SQL

#sql #data #database #postgres
2
Comments 3
3 min read
Oracle AI Database 26ai — Read-Only User Feature
vahidusefzadeh profile

Oracle AI Database 26ai — Read-Only User Feature

#oracle #sql #linux #database
Comments
2 min read
Calculate all the year/months included in the year/month interval — From SQL to SPL #15
judith677 profile

Calculate all the year/months included in the year/month interval — From SQL to SPL #15

#programming #datascience #sql #esprocspl
5
Comments 1
2 min read
Querying embedded arrays in JSON (PostgreSQL JSONB and MongoDB documents)
franckpachot profile

Querying embedded arrays in JSON (PostgreSQL JSONB and MongoDB documents)

#postgres #json #sql #mongodb
3
Comments
5 min read
SQL: The Secret Weapon Behind Data Analytics and Data Science
joseph_hinga_mwangi profile

SQL: The Secret Weapon Behind Data Analytics and Data Science

#datascience #database #sql
4
Comments 3
4 min read
Connect Any Postgres to Real-Time Analytics
tigerdata_dev profile

Connect Any Postgres to Real-Time Analytics

#postgres #datascience #performance #sql
1
Comments
7 min read
What's New in MySQL 9 🧐 - a DBA's Perspective 🥸
op3ratordec profile

What's New in MySQL 9 🧐 - a DBA's Perspective 🥸

#mysql #database #sql #tooling
8
Comments
9 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.