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.
Tutorial: Schedule SQL Queries on your Database

Tutorial: Schedule SQL Queries on your Database

6
Comments 3
2 min read
The most complete bad word dataset on the internet, and using it in my Python application

The most complete bad word dataset on the internet, and using it in my Python application

20
Comments
1 min read
Supernova introduction

Supernova introduction

4
Comments
2 min read
Working with SQL Relations in Go - Part 5

Working with SQL Relations in Go - Part 5

4
Comments
5 min read
Tutorial: Automate Daily SQL Queries in 4 minutes

Tutorial: Automate Daily SQL Queries in 4 minutes

9
Comments
3 min read
Tutorial: Creating Slack Bots to Track Product Inventory

Tutorial: Creating Slack Bots to Track Product Inventory

6
Comments
3 min read
The 500-foot Cab Ride: Using BigQuery to find out how dirty (sinister?) NYC's cab ride data is

The 500-foot Cab Ride: Using BigQuery to find out how dirty (sinister?) NYC's cab ride data is

9
Comments 1
3 min read
Working with SQL Relations in Go - Part 4

Working with SQL Relations in Go - Part 4

3
Comments
7 min read
SQL Vs NoSQL, Lequel Peut Gérer Facilement Une Base De Données Web Médicale?

SQL Vs NoSQL, Lequel Peut Gérer Facilement Une Base De Données Web Médicale?

4
Comments
12 min read
Tutorial: How to Connect a SQL Database to Google Sheets

Tutorial: How to Connect a SQL Database to Google Sheets

4
Comments
2 min read
Subqueries and Correlated Subqueries

Subqueries and Correlated Subqueries

3
Comments
2 min read
AyeSQL: Writing Raw SQL

AyeSQL: Writing Raw SQL

12
Comments 2
9 min read
Connect to SQLite DB in windows

Connect to SQLite DB in windows

4
Comments
1 min read
MySQLでサブクエリを使ってUPDATE

MySQLでサブクエリを使ってUPDATE

7
Comments
1 min read
Building an end to end Machine Learning Pipeline in Bigquery

Building an end to end Machine Learning Pipeline in Bigquery

7
Comments
5 min read
Introduction to MySQL queries

Introduction to MySQL queries

7
Comments 1
3 min read
ROW_NUMBER, PARTITION, & other reasons SQL is beautiful

ROW_NUMBER, PARTITION, & other reasons SQL is beautiful

14
Comments
2 min read
Analyze one year of radio station songs aired with SQL, Spark, Spotify, and Databricks

Analyze one year of radio station songs aired with SQL, Spark, Spotify, and Databricks

6
Comments
16 min read
Manipulando Datas no Postgres

Manipulando Datas no Postgres

5
Comments
2 min read
Devart Introduced The New Version of Its Flagman Solution — dbForge SQL Complete v.6.4

Devart Introduced The New Version of Its Flagman Solution — dbForge SQL Complete v.6.4

4
Comments
2 min read
SQL: Select Statements

SQL: Select Statements

7
Comments
3 min read
A (not so) small rant on techniques to copy MySQL database structures

A (not so) small rant on techniques to copy MySQL database structures

6
Comments
4 min read
Visually Creating MySQL Queries With dbForge Studio for MySQL

Visually Creating MySQL Queries With dbForge Studio for MySQL

6
Comments
4 min read
SQL: Table Creation and Basic Queries

SQL: Table Creation and Basic Queries

6
Comments
3 min read
A 'Nike Foamposites' mobile app I developed was finally accepted by Apple

A 'Nike Foamposites' mobile app I developed was finally accepted by Apple

4
Comments
2 min read
loading...