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.
Database Views and How to Use Them in a Rails Based Application?

Database Views and How to Use Them in a Rails Based Application?

5
Comments
8 min read
Conhecendo o Azure Data Studio

Conhecendo o Azure Data Studio

2
Comments
2 min read
Ways to talk about code (to people who don't code) #01: CSS, SQL, JavaScript

Ways to talk about code (to people who don't code) #01: CSS, SQL, JavaScript

10
Comments
4 min read
Sumar y restar cantidades con SQL en WordPress

Sumar y restar cantidades con SQL en WordPress

7
Comments
3 min read
How to Get the First or Last Value in a Group Using Group By in SQL

How to Get the First or Last Value in a Group Using Group By in SQL

5
Comments
11 min read
Analyzing Meetup Data With SQL And Tableau - A Free Webinar

Analyzing Meetup Data With SQL And Tableau - A Free Webinar

9
Comments
1 min read
JOIN Semiotics and MassiveJS v6

JOIN Semiotics and MassiveJS v6

12
Comments
7 min read
Native Android Database

Native Android Database

4
Comments
1 min read
Using Python to Scrape the Meet-Up API

Using Python to Scrape the Meet-Up API

58
Comments
5 min read
Improving Community Support for Liquibase

Improving Community Support for Liquibase

12
Comments
1 min read
Tips for Writing an ETL Console Application in C# .NET Core

Tips for Writing an ETL Console Application in C# .NET Core

8
Comments
5 min read
SQL joins recall - a little bit too late

SQL joins recall - a little bit too late

14
Comments
3 min read
Intermittent RDS Errors When Triggering Lambda Functions

Intermittent RDS Errors When Triggering Lambda Functions

6
Comments
3 min read
Database management and use among multiple developers?

Database management and use among multiple developers?

4
Comments 1
1 min read
Geolocation with BigQuery: De-identify 76 million IP addresses in 20 seconds

Geolocation with BigQuery: De-identify 76 million IP addresses in 20 seconds

14
Comments
5 min read
SQL is neither dead nor a dinosaur. You should use it for your web app.

SQL is neither dead nor a dinosaur. You should use it for your web app.

15
Comments 1
8 min read
Practicality Beats Purity - Pure SQL vs ORMs

Practicality Beats Purity - Pure SQL vs ORMs

7
Comments
1 min read
SQL Injection??

SQL Injection??

6
Comments 1
1 min read
Vacuum after you tidy up

Vacuum after you tidy up

18
Comments
4 min read
Three tables every analyst needs

Three tables every analyst needs

7
Comments
6 min read
Testing data quality with SQL assertions

Testing data quality with SQL assertions

8
Comments
4 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 terrifying mongoDB sintaxe

The terrifying mongoDB sintaxe

5
Comments 2
1 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
Select query using an outer apply

Select query using an outer apply

4
Comments
1 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
What is SQL injection?

What is SQL injection?

12
Comments 5
2 min read
Pourquoi - et comment - apprendre PL/SQL (…T-SQL…PL/pgSQL…)

Pourquoi - et comment - apprendre PL/SQL (…T-SQL…PL/pgSQL…)

10
Comments 1
6 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
Implementing Soft-Delete in pure MySQL

Implementing Soft-Delete in pure MySQL

9
Comments
3 min read
More Secure and Productive Database and Code Development in Updated SQL Complete

More Secure and Productive Database and Code Development in Updated SQL Complete

8
Comments
1 min read
Nylas is Hiring a Senior Software Engineer

Nylas is Hiring a Senior Software Engineer

8
Comments
2 min read
SQL Server Set Operators: UNION, INTERSECT, and EXCEPT

SQL Server Set Operators: UNION, INTERSECT, and EXCEPT

13
Comments
1 min read
Nylas is Hiring a Senior Software Engineer

Nylas is Hiring a Senior Software Engineer

8
Comments
2 min read
Check if type exists in MSSQL

Check if type exists in MSSQL

5
Comments
1 min read
Find column from all tables

Find column from all tables

4
Comments
1 min read
Connecting to SQL over TCP/IP with Entity Framework

Connecting to SQL over TCP/IP with Entity Framework

7
Comments 1
1 min read
PostgreSQL: Efficient Queries - Indexing

PostgreSQL: Efficient Queries - Indexing

4
Comments 1
1 min read
MySQL Global Vars wait_timeout & max_connections

MySQL Global Vars wait_timeout & max_connections

2
Comments
1 min read
MySql Version "Correlated Sub-Queries and Group By Unions"

MySql Version "Correlated Sub-Queries and Group By Unions"

3
Comments
1 min read
loading...