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.
Creating a user registration System Using PHP and Mysql.

Creating a user registration System Using PHP and Mysql.

9
Comments 2
1 min read
The Cloud Resume Challenge

The Cloud Resume Challenge

19
Comments 3
3 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

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

Intro to SQL for Election Results Analysis

3
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
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

11
Comments 1
2 min read
Hacker-rank SQL Median calculation

Hacker-rank SQL Median calculation

8
Comments
1 min read
Learn SQL Injection by hacking a bank app

Learn SQL Injection by hacking a bank app

95
Comments 4
7 min read
loading...