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.
Week 9: Audit 15 Code Snippets for SQL Injection
fosres profile

Week 9: Audit 15 Code Snippets for SQL Injection

#security #python #appsec #sql
1
Comments
20 min read
Run Oracle SQL on Any PC Without the Nightmare (Docker + Linux Way)
md8_habibullah profile

Run Oracle SQL on Any PC Without the Nightmare (Docker + Linux Way)

#database #oracle #sql #docker
8
Comments
9 min read
Joins In Sql
mary_kariuki_944435052aa9 profile

Joins In Sql

#beginners #database #sql #tutorial
2
Comments
3 min read
Your ML Model Is Training on the Future
gauthierpiarrette profile

Your ML Model Is Training on the Future

#machinelearning #dataengineering #datascience #sql
Comments
7 min read
Data Engineer Career Progression: A Practical Roadmap (SQL Modern Analytics Engineering)
borisgigovic profile

Data Engineer Career Progression: A Practical Roadmap (SQL Modern Analytics Engineering)

#dataengineering #sql #cloud #analytics
Comments
5 min read
Connecting Power BI to SQL Databases: A Practical Guide for Data Analysts
lawrence_murithi profile

Connecting Power BI to SQL Databases: A Practical Guide for Data Analysts

#luxdev #dataengineering #sql #database
1
Comments
8 min read
Tools for data science and analytics installation process.
nyamatari_brian_c41e0c389 profile

Tools for data science and analytics installation process.

#database #datascience #sql #tutorial
4
Comments
3 min read
Stop Using .any? the Wrong Way in Rails
pavelmyslik profile

Stop Using .any? the Wrong Way in Rails

#rails #ruby #performance #sql
Comments
3 min read
SQL Normalization vs Denormalization Explained with 1NF, 2NF, and 3NF
davinceleecode profile

SQL Normalization vs Denormalization Explained with 1NF, 2NF, and 3NF

#database #sql #backend #beginners
Comments
2 min read
Why Native APEX_DATA_EXPORT Fails for Professional Branding (And How to Fix It)
shanemccoy37 profile

Why Native APEX_DATA_EXPORT Fails for Professional Branding (And How to Fix It)

#oracleapex #lowcode #webdev #sql
2
Comments
2 min read
From Messy JSON to Health Insights: Building a Modern ETL Pipeline with DBT and BigQuery
beck_moulton profile

From Messy JSON to Health Insights: Building a Modern ETL Pipeline with DBT and BigQuery

#sql #dataengineering #bigquery #healthtech
1
Comments
3 min read
Generating AWR Reports in an Active Data Guard using RMF(12.2)
vahidusefzadeh profile

Generating AWR Reports in an Active Data Guard using RMF(12.2)

#oracle #database #linux #sql
Comments
4 min read
SQL Joins and Window Functions: The Tools That Changed How I Query Data
guyo_mohammed profile
Guyo

SQL Joins and Window Functions: The Tools That Changed How I Query Data

#beginners #data #database #sql
2
Comments
7 min read
Automatic Flashback (or PITR) Standby
vahidusefzadeh profile

Automatic Flashback (or PITR) Standby

#oracle #database #linux #sql
Comments
12 min read
A Brief Review of Interval Partitioning
vahidusefzadeh profile

A Brief Review of Interval Partitioning

#oracle #linux #database #sql
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.