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.
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
Modern data practice and the SQL tradition

Modern data practice and the SQL tradition

17
Comments
2 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
Psycopg2: PostgreSQL & Python (the Old Fashioned Way)

Psycopg2: PostgreSQL & Python (the Old Fashioned Way)

16
Comments
6 min read
Temporal tables or JSON storage

Temporal tables or JSON storage

6
Comments
3 min read
Rewrite this SQL for NoSQL, graph-db (e.g. Neo4j)

Rewrite this SQL for NoSQL, graph-db (e.g. Neo4j)

7
Comments
1 min read
Why you must add relational database development to your toolkit

Why you must add relational database development to your toolkit

5
Comments
5 min read
Answer: Does the join order matter in SQL?

Answer: Does the join order matter in SQL?

2
Comments
1 min read
Automate SQL Queries in the cloud

Automate SQL Queries in the cloud

6
Comments
1 min read
Basic DB Using SQL Server (Part 1) - Basic commands!

Basic DB Using SQL Server (Part 1) - Basic commands!

9
Comments
3 min read
Makers - Week 4

Makers - Week 4

4
Comments
1 min read
i doing SQL tuning in Company databases but i don't know where to start

i doing SQL tuning in Company databases but i don't know where to start

3
Comments 3
1 min read
Joining Data in DynamoDB and S3 for Live Ad Hoc Analysis

Joining Data in DynamoDB and S3 for Live Ad Hoc Analysis

5
Comments
8 min read
Answer: SQL Server - How to lock a table until a stored procedure finishes

Answer: SQL Server - How to lock a table until a stored procedure finishes

6
Comments
1 min read
Importing geo-partitioned data… the easy way

Importing geo-partitioned data… the easy way

3
Comments 1
1 min read
Avoiding Hard Coding and Magic Strings in code and databases

Avoiding Hard Coding and Magic Strings in code and databases

38
Comments 1
3 min read
Popular SQL interview question met in practice

Popular SQL interview question met in practice

10
Comments
3 min read
λ➕ Sum Types in relational databases: Yet another (IMO pretty neat) way to model them in SQL

λ➕ Sum Types in relational databases: Yet another (IMO pretty neat) way to model them in SQL

8
Comments
3 min read
How to deploy project local to production server using gulp?

How to deploy project local to production server using gulp?

6
Comments 1
1 min read
What is an execution plan?

What is an execution plan?

5
Comments
1 min read
MySQL reserved words checker for Laravel migrations on PhpStorm

MySQL reserved words checker for Laravel migrations on PhpStorm

4
Comments
1 min read
Loose Typings in GraphQL for Dynamic Grouping and Aggregation Queries

Loose Typings in GraphQL for Dynamic Grouping and Aggregation Queries

10
Comments
6 min read
Query optimization: from a few weeks to 24 hours

Query optimization: from a few weeks to 24 hours

16
Comments
4 min read
Use Sequelize to Manipulate Databases

Use Sequelize to Manipulate Databases

12
Comments
3 min read
Introduction to Relational Database and SQL

Introduction to Relational Database and SQL

7
Comments
1 min read
14 SQL Query Performance Tuning Tips

14 SQL Query Performance Tuning Tips

10
Comments
9 min read
nodejs feat Seqeuelize Course

nodejs feat Seqeuelize Course

6
Comments
1 min read
Transform SQL Query into MongoDB Query

Transform SQL Query into MongoDB Query

7
Comments
1 min read
New Formatting Profiles in SQL Complete v6.3

New Formatting Profiles in SQL Complete v6.3

7
Comments
2 min read
Sequelize, your favorite database library

Sequelize, your favorite database library

7
Comments
3 min read
MySql? What is it?

MySql? What is it?

8
Comments
3 min read
Angular 8 Button disable?

Angular 8 Button disable?

4
Comments 2
1 min read
How to Group in C# Like in SQL

How to Group in C# Like in SQL

5
Comments
1 min read
SQL is Insecure

SQL is Insecure

6
Comments 31
2 min read
Makers Week 4: Databased on a True Story

Makers Week 4: Databased on a True Story

6
Comments
2 min read
What do you need to know to get into Data Science as a Beginner?

What do you need to know to get into Data Science as a Beginner?

71
Comments 8
1 min read
Display records from Database one at a time

Display records from Database one at a time

5
Comments 1
2 min read
How did I reduce the load time of my application?

How did I reduce the load time of my application?

16
Comments 2
1 min read
SQL: Union Operator

SQL: Union Operator

22
Comments
2 min read
Error-logging Patterns and Practices

Error-logging Patterns and Practices

66
Comments
6 min read
SQL, NoSQL and modern data practices

SQL, NoSQL and modern data practices

53
Comments
2 min read
Query PDFs with SQL

Query PDFs with SQL

9
Comments
1 min read
SQL: Inner Join

SQL: Inner Join

23
Comments 4
2 min read
Getting Started with Microsoft SQL Server on Mac and Windows in 2020

Getting Started with Microsoft SQL Server on Mac and Windows in 2020

13
Comments
1 min read
SQL vs NoSQL

SQL vs NoSQL

8
Comments
2 min read
Jumpstarting Applications with ActiveRecord

Jumpstarting Applications with ActiveRecord

12
Comments 1
7 min read
Vectorized SQL in CockroachDB

Vectorized SQL in CockroachDB

9
Comments
1 min read
View and Read SQL Server Transaction Log Data

View and Read SQL Server Transaction Log Data

5
Comments 1
1 min read
loading...