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.
List of SQL Commands Glossary of commonly used SQL commands.

List of SQL Commands Glossary of commonly used SQL commands.

15
Comments
4 min read
Recognization Facial Expression and recommending Movies and Songs

Recognization Facial Expression and recommending Movies and Songs

5
Comments
1 min read
Complete Data Engineer's Vocabulary

Complete Data Engineer's Vocabulary

2
Comments
1 min read
How we made our SQL database QuestDB even faster and more accurate

How we made our SQL database QuestDB even faster and more accurate

16
Comments 3
1 min read
French Amortization Method (PRICE) with T-SQL.

French Amortization Method (PRICE) with T-SQL.

5
Comments
1 min read
Discussion: How to find top n users with five recent posts

Discussion: How to find top n users with five recent posts

13
Comments 4
1 min read
Search Text in stored procedure in SQL Server

Search Text in stored procedure in SQL Server

2
Comments
1 min read
Aerospike JDBC driver: SQL DDL compliance

Aerospike JDBC driver: SQL DDL compliance

7
Comments 3
1 min read
SQL vs NoSQL vs both options for Web projects?

SQL vs NoSQL vs both options for Web projects?

3
Comments
1 min read
Flatfile + DBeaver + SQL = Productivity

Flatfile + DBeaver + SQL = Productivity

5
Comments
2 min read
Tech Stack to Build Marketplaces like Airbnb

Tech Stack to Build Marketplaces like Airbnb

4
Comments 1
3 min read
Journey To Full Stack: The Schema Of Things

Journey To Full Stack: The Schema Of Things

25
Comments
4 min read
Database Design Tutorial

Database Design Tutorial

158
Comments 2
9 min read
Customizable database-based reporting

Customizable database-based reporting

6
Comments
2 min read
Learn SQL Injection by hacking a bank app

Learn SQL Injection by hacking a bank app

95
Comments 4
7 min read
Identity Graph and Identity Resolution in SQL

Identity Graph and Identity Resolution in SQL

6
Comments
7 min read
PyMySQL connector

PyMySQL connector

4
Comments
1 min read
The Cloud Resume Challenge

The Cloud Resume Challenge

19
Comments 3
3 min read
Creating a user registration System Using PHP and Mysql.

Creating a user registration System Using PHP and Mysql.

9
Comments 2
1 min read
Managing resources

Managing resources

2
Comments
1 min read
Faculty Dashboard

Faculty Dashboard

9
Comments
4 min read
SQL: Intro to Wild Cards

SQL: Intro to Wild Cards

6
Comments 2
2 min read
How to change a foreign key constraint in MySQL

How to change a foreign key constraint in MySQL

25
Comments 1
3 min read
Intro to SQL for Election Results Analysis

Intro to SQL for Election Results Analysis

8
Comments
5 min read
Combining SQL and Astronomy

Combining SQL and Astronomy

4
Comments 5
1 min read
Business logic in Stored Procedures?

Business logic in Stored Procedures?

6
Comments 1
2 min read
Insert multiple parents with multiple children in a single stored procedure (SQL Server)

Insert multiple parents with multiple children in a single stored procedure (SQL Server)

9
Comments 1
3 min read
How to Inspect the SQL Generated by Entity Framework Core using .NET Core's built in Logging

How to Inspect the SQL Generated by Entity Framework Core using .NET Core's built in Logging

31
Comments 17
2 min read
Want to Learn SQL? Here's everything you need to know

Want to Learn SQL? Here's everything you need to know

9
Comments
8 min read
Azure Functions (Serverless) + Entity Framework Core y SQL Azure

Azure Functions (Serverless) + Entity Framework Core y SQL Azure

5
Comments 2
8 min read
entity2sql

entity2sql

7
Comments
2 min read
Embedded database vs Client-Server database (on the same host) performance?

Embedded database vs Client-Server database (on the same host) performance?

3
Comments
1 min read
Fuzzy Searching with PostgreSQL

Fuzzy Searching with PostgreSQL

80
Comments 4
6 min read
Tips and tricks for SQL Server database (table) design?

Tips and tricks for SQL Server database (table) design?

4
Comments 1
3 min read
Data Engineering 101: Automating Your First Data Extract

Data Engineering 101: Automating Your First Data Extract

101
Comments
7 min read
Making GraphQL Magic with Sqlmancer 🧙🔮✨

Making GraphQL Magic with Sqlmancer 🧙🔮✨

9
Comments
6 min read
Basic DB Using SQL Server (Part 7) - Set Operations in SQL

Basic DB Using SQL Server (Part 7) - Set Operations in SQL

6
Comments
6 min read
Basic DB Using SQL Server (Part 6)

Basic DB Using SQL Server (Part 6)

6
Comments
5 min read
Introducing the Full Stack Typing Boilerplate: Once You ORM, You Can't Go Back!

Introducing the Full Stack Typing Boilerplate: Once You ORM, You Can't Go Back!

8
Comments 3
13 min read
We used CosmosDB instead of a relational database, here's what we went through and learned.

We used CosmosDB instead of a relational database, here's what we went through and learned.

9
Comments 2
4 min read
Dark theme in SQL Server Management Studio

Dark theme in SQL Server Management Studio

9
Comments
2 min read
Hacker-rank SQL Median calculation

Hacker-rank SQL Median calculation

7
Comments
1 min read
My Back-end Adventures - Setting up a local database (Postgres)

My Back-end Adventures - Setting up a local database (Postgres)

9
Comments
4 min read
SQL for dummies

SQL for dummies

10
Comments
5 min read
My Back-end Adventures - Intro

My Back-end Adventures - Intro

37
Comments 5
2 min read
Dapper .NET: Custom Type Handling (aka: solve the Impedance Mismatch)

Dapper .NET: Custom Type Handling (aka: solve the Impedance Mismatch)

9
Comments 2
4 min read
SQL injection for developers

SQL injection for developers

128
Comments 5
12 min read
What is the best way store column metadata in SQLite (like, is JSON or is Date)

What is the best way store column metadata in SQLite (like, is JSON or is Date)

7
Comments 6
1 min read
Jupyter Notebooks + IBMi

Jupyter Notebooks + IBMi

14
Comments 2
4 min read
Live Annotated Coding Interviews: SQL, Python and Javascript 1:36:36

Live Annotated Coding Interviews: SQL, Python and Javascript

37
Comments 2
3 min read
Understand SQL JOIN with this simple tutorial and don't fail as I did

Understand SQL JOIN with this simple tutorial and don't fail as I did

58
Comments
5 min read
Azure SQL and Site Reliability

Azure SQL and Site Reliability

13
Comments
8 min read
What SQLite CAN actually do

What SQLite CAN actually do

33
Comments 1
3 min read
Avoid This Mistake When Restoring a TDE Protected Database to a New Server

Avoid This Mistake When Restoring a TDE Protected Database to a New Server

6
Comments
3 min read
Quick and Easy, Exactly-Once, Distributed Work Queues Using Serializable Transactions

Quick and Easy, Exactly-Once, Distributed Work Queues Using Serializable Transactions

20
Comments 4
5 min read
Getting query performance stats with PostgreSQL

Getting query performance stats with PostgreSQL

23
Comments 1
6 min read
Exploring Column Families in CockroachDB

Exploring Column Families in CockroachDB

8
Comments
2 min read
A Primer on Relational Databases for Beginners by a Beginner

A Primer on Relational Databases for Beginners by a Beginner

6
Comments
8 min read
Hierarchical Queries in SQL with C# and Entity Framework Core

Hierarchical Queries in SQL with C# and Entity Framework Core

8
Comments
1 min read
A workout routine with Oracle DEV GYM

A workout routine with Oracle DEV GYM

3
Comments 3
1 min read
loading...