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.
Three tables every analyst needs

Three tables every analyst needs

7
Comments
6 min read
Embrace the Base

Embrace the Base

6
Comments
1 min read
Creating My First Sinatra App

Creating My First Sinatra App

9
Comments
4 min read
AMA with Julia Silge, Stack Overflow's Data Scientist

AMA with Julia Silge, Stack Overflow's Data Scientist

5
Comments
1 min read
Simplified Surrogate Keys in Oracle 12c and later

Simplified Surrogate Keys in Oracle 12c and later

6
Comments
5 min read
Boxball: Prebuilt baseball stats databases using Docker

Boxball: Prebuilt baseball stats databases using Docker

7
Comments
4 min read
Setting up your Heroku site with JawsDB using Sequel Pro

Setting up your Heroku site with JawsDB using Sequel Pro

6
Comments
3 min read
The Magic Of A Single Integer Number To Contain Huge Information

The Magic Of A Single Integer Number To Contain Huge Information

8
Comments
1 min read
Does Coding in CMS makes you unprofessional?

Does Coding in CMS makes you unprofessional?

8
Comments 2
1 min read
Bug: SQL Stored Procedure Returning -1 in Entity Framework

Bug: SQL Stored Procedure Returning -1 in Entity Framework

5
Comments
2 min read
Managing Data in the Cloud ☁

Managing Data in the Cloud ☁

10
Comments
2 min read
Tracking the Trackers

Tracking the Trackers

5
Comments 2
4 min read
Write a Postgresql proxy. The Beginning.

Write a Postgresql proxy. The Beginning.

5
Comments
2 min read
Superglue for Gaps in Your AWS Infrastructure — automation scripts using SQL and Javascript

Superglue for Gaps in Your AWS Infrastructure — automation scripts using SQL and Javascript

3
Comments
4 min read
How to store ‘last seen’ for users in Phoenix

How to store ‘last seen’ for users in Phoenix

6
Comments
2 min read
DBMS For Application Development: SQL (Structured Query Language)

DBMS For Application Development: SQL (Structured Query Language)

7
Comments
4 min read
Fewer Dashboards, More Analysis

Fewer Dashboards, More Analysis

10
Comments 2
5 min read
The Life Changing Magic of Migrating Github repositories with Transposit

The Life Changing Magic of Migrating Github repositories with Transposit

4
Comments
4 min read
SQL order from API chaos

SQL order from API chaos

6
Comments
3 min read
Q&A with Helen Anderson, BI Data Analyst and Technical Consultant

Q&A with Helen Anderson, BI Data Analyst and Technical Consultant

17
Comments 4
6 min read
When query db should I check if data exists first then select it ?

When query db should I check if data exists first then select it ?

5
Comments 2
1 min read
Oracle and SQLite compiler are now available in SqlKata

Oracle and SQLite compiler are now available in SqlKata

5
Comments
1 min read
Dynamic SQL cheatsheet

Dynamic SQL cheatsheet

13
Comments
2 min read
Check if temp table exists in SQL

Check if temp table exists in SQL

3
Comments
1 min read
SQL Server 2016’s STRING_SPLIT

SQL Server 2016’s STRING_SPLIT

7
Comments
1 min read
loading...