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.
Build a simple blog with GraphQL, Node.js, SQLite and (VUE, Angular Or ReactJS)

Build a simple blog with GraphQL, Node.js, SQLite and (VUE, Angular Or ReactJS)

36
Comments 2
2 min read
Azure SQL Database: What We've Learned About Automatic Tuning and Performance Recommendations

Azure SQL Database: What We've Learned About Automatic Tuning and Performance Recommendations

8
Comments
8 min read
The R.A.G (Redshift Analyst Guide): What is Redshift?

The R.A.G (Redshift Analyst Guide): What is Redshift?

38
Comments 2
7 min read
Bulk Insert in Dapper into MS SQL

Bulk Insert in Dapper into MS SQL

7
Comments 8
1 min read
What is a SQL query you are proud of?

What is a SQL query you are proud of?

6
Comments 13
1 min read
My Journey

My Journey

5
Comments
1 min read
Master of Data Science... but I'm a graphic designer

Master of Data Science... but I'm a graphic designer

8
Comments 2
1 min read
How do I make paging with ordering by different columns ?

How do I make paging with ordering by different columns ?

6
Comments
1 min read
How to make APIs fast & secure, plus tips for REST APIs

How to make APIs fast & secure, plus tips for REST APIs

62
Comments
2 min read
Having trouble understanding wide column stores like Cassandra. Can someone explain?

Having trouble understanding wide column stores like Cassandra. Can someone explain?

3
Comments
1 min read
The Interview Study Guide For Software Engineers

The Interview Study Guide For Software Engineers

2418
Comments 92
12 min read
ASP.NET MVC 5 LinQ to SQL

ASP.NET MVC 5 LinQ to SQL

7
Comments 1
5 min read
KISS my blog! (part 1)

KISS my blog! (part 1)

6
Comments 1
3 min read
Azure Storage, conhece? [PARTE 1]

Azure Storage, conhece? [PARTE 1]

11
Comments 1
8 min read
A Critical Look on Relational Databases and SQL

A Critical Look on Relational Databases and SQL

20
Comments 2
7 min read
Using DataLoader to batch SQL queries

Using DataLoader to batch SQL queries

14
Comments
7 min read
We’re not all DBAs: Indexes For Developers

We’re not all DBAs: Indexes For Developers

30
Comments 1
5 min read
The True Guide to True and False in PostgreSQL

The True Guide to True and False in PostgreSQL

10
Comments
2 min read
SQLite, json et dénormalisation

SQLite, json et dénormalisation

5
Comments 7
7 min read
Working with BigQuery Analytic Functions

Working with BigQuery Analytic Functions

6
Comments
5 min read
Querying data using raw SQL & Stored Procedures in Entity Framework Core

Querying data using raw SQL & Stored Procedures in Entity Framework Core

3
Comments
4 min read
Finding the Top N per Group with SQL

Finding the Top N per Group with SQL

3
Comments
7 min read
How to ace coding interviews; and scaling tips from Netflix & Shopify

How to ace coding interviews; and scaling tips from Netflix & Shopify

123
Comments
2 min read
Data Science Interview Study Guide

Data Science Interview Study Guide

231
Comments 2
12 min read
Using Tableau with Kafka: How to Build a Real-Time SQL Dashboard on Streaming Data

Using Tableau with Kafka: How to Build a Real-Time SQL Dashboard on Streaming Data

9
Comments
6 min read
An Introduction to Oracle SQL

An Introduction to Oracle SQL

3
Comments
1 min read
When it comes to Data, the customer is always wrong - The Four Horsemen of the Assumption Apocalypse

When it comes to Data, the customer is always wrong - The Four Horsemen of the Assumption Apocalypse

25
Comments 3
2 min read
How i learned flask in one week by building

How i learned flask in one week by building

11
Comments 3
2 min read
pandas #1: Getting started with pandas

pandas #1: Getting started with pandas

46
Comments 2
4 min read
DynamoDB vs. Hadoop vs. MongoDB

DynamoDB vs. Hadoop vs. MongoDB

48
Comments
8 min read
#SQL30 Day 12: Greatest Discount

#SQL30 Day 12: Greatest Discount

6
Comments
3 min read
#SQL30 Day 11: Soft Deletes

#SQL30 Day 11: Soft Deletes

8
Comments
3 min read
Manipulating arrays with PostgreSQL

Manipulating arrays with PostgreSQL

13
Comments 2
3 min read
#SQL30 Day 10: Random Sampling

#SQL30 Day 10: Random Sampling

7
Comments 1
3 min read
Generate dummy data with Postgres

Generate dummy data with Postgres

6
Comments 2
2 min read
Le comportement particulier des autoincrement dans les tables MySQL InnoDB

Le comportement particulier des autoincrement dans les tables MySQL InnoDB

5
Comments
3 min read
Using GraphDbs to Visualize Code/SQL dependencies

Using GraphDbs to Visualize Code/SQL dependencies

7
Comments
4 min read
How to use Query Objects to refactor Rails SQL-queries

How to use Query Objects to refactor Rails SQL-queries

11
Comments
6 min read
Import data from S3 to Redshift in minutes using Dataform

Import data from S3 to Redshift in minutes using Dataform

7
Comments
4 min read
#SQL30 Day 8: Deleting Duplicates

#SQL30 Day 8: Deleting Duplicates

9
Comments
3 min read
Advanced PHP Interview Questions 2020

Advanced PHP Interview Questions 2020

9
Comments 1
2 min read
#SQL30 Day 6: Supermarket Sales

#SQL30 Day 6: Supermarket Sales

6
Comments 1
3 min read
PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types in Enterprise

PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types in Enterprise

7
Comments
11 min read
#SQL30 Day 5: Hierarchies

#SQL30 Day 5: Hierarchies

6
Comments 1
3 min read
Our 25 Favorite Data Science Courses From Harvard To Udemy

Our 25 Favorite Data Science Courses From Harvard To Udemy

63
Comments
15 min read
10 Amazing Articles On Python Programming And Machine Learning

10 Amazing Articles On Python Programming And Machine Learning

60
Comments
4 min read
SQL Server’s identity column misconceptions

SQL Server’s identity column misconceptions

8
Comments
3 min read
#SQL30 Day 3: Weather Data

#SQL30 Day 3: Weather Data

20
Comments 4
5 min read
How to get the list of all the affected columns in a SQL query

How to get the list of all the affected columns in a SQL query

7
Comments 1
1 min read
#SQL30 Day 1: Wildfires

#SQL30 Day 1: Wildfires

46
Comments 8
2 min read
#SQL30 Day 2: Stock Price Variance

#SQL30 Day 2: Stock Price Variance

8
Comments 5
3 min read
Use the right tool to get identity values back after an insert

Use the right tool to get identity values back after an insert

14
Comments 2
3 min read
Hadoop Vs Relational Databases

Hadoop Vs Relational Databases

73
Comments 1
7 min read
LDAP Directory & SQL Database - Syncing the Unsyncable?

LDAP Directory & SQL Database - Syncing the Unsyncable?

13
Comments
11 min read
Configuring Entity Framework Core into Asp.Net Core

Configuring Entity Framework Core into Asp.Net Core

9
Comments 1
3 min read
SQLAlchemy Cascading Deletes

SQLAlchemy Cascading Deletes

19
Comments 3
4 min read
PostgreSQL Foreign Data Wrappers

PostgreSQL Foreign Data Wrappers

19
Comments
5 min read
Choosing a Database Manager. SQL or Nah?

Choosing a Database Manager. SQL or Nah?

9
Comments 5
3 min read
Building a SQL Development Environment for Messy, Semi-Structured Data

Building a SQL Development Environment for Messy, Semi-Structured Data

7
Comments
5 min read
Kentico 12: Design Patterns Part 14 - DocumentQuery and ObjectQuery Tips

Kentico 12: Design Patterns Part 14 - DocumentQuery and ObjectQuery Tips

9
Comments
9 min read
loading...