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.
New in Entity Framework 7: Bulk Operations with ExecuteDelete and ExecuteUpdate

New in Entity Framework 7: Bulk Operations with ExecuteDelete and ExecuteUpdate

8
Comments 2
5 min read
Adding business days to a date using SQL

Adding business days to a date using SQL

9
Comments 3
1 min read
Databases: SQL vs NoSQL

Databases: SQL vs NoSQL

4
Comments
6 min read
How to configure Azure SQL Always Encrypted for Mac users

How to configure Azure SQL Always Encrypted for Mac users

1
Comments
9 min read
Using Rails Model or SQL query in Ruby On Rails

Using Rails Model or SQL query in Ruby On Rails

3
Comments
1 min read
Find the Retention Rates – Salesforce SQL Interview Question

Find the Retention Rates – Salesforce SQL Interview Question

2
Comments
7 min read
Write your first QueryBuilder with PDO and PHP

Write your first QueryBuilder with PDO and PHP

10
Comments 1
7 min read
Data Tokenization in Snowflake

Data Tokenization in Snowflake

2
Comments
9 min read
The Mystery of RDS Costs

The Mystery of RDS Costs

9
Comments 1
5 min read
DistSQL Applications: Building a Dynamic Distributed Database

DistSQL Applications: Building a Dynamic Distributed Database

5
Comments
9 min read
Freelancing or Part time job in Data Analysis or Visualisation

Freelancing or Part time job in Data Analysis or Visualisation

6
Comments
1 min read
MySQL

MySQL

1
Comments
3 min read
Forget SQL, All My Homies Use LINQ

Forget SQL, All My Homies Use LINQ

22
Comments 1
2 min read
MongoDB $weeklyUpdate #82 (August 12, 2022): Community Cafe, Atlas Search, & International MUGs!

MongoDB $weeklyUpdate #82 (August 12, 2022): Community Cafe, Atlas Search, & International MUGs!

6
Comments
3 min read
3 Ways of Integrating Python With SQL Server Every Data Professional Should Know About

3 Ways of Integrating Python With SQL Server Every Data Professional Should Know About

10
Comments
4 min read
Finding mean, median, and mode using SQL.

Finding mean, median, and mode using SQL.

9
Comments
2 min read
Bookmarklet for YugabyteDB table's tablets

Bookmarklet for YugabyteDB table's tablets

4
Comments
2 min read
SQL DB Backup with PowerShell GUI - Tutorial

SQL DB Backup with PowerShell GUI - Tutorial

6
Comments
9 min read
Understanding INNER, OUTER, LEFT, and RIGHT Joins in SQL

Understanding INNER, OUTER, LEFT, and RIGHT Joins in SQL

6
Comments
11 min read
Visual Studio Database Project and Always Encrypted

Visual Studio Database Project and Always Encrypted

7
Comments
4 min read
SQL Injections Explained

SQL Injections Explained

8
Comments 1
5 min read
Insert and query jsonb in rails and postgres

Insert and query jsonb in rails and postgres

19
Comments 2
8 min read
Predicting Supermarket Future Sales Using Machine Learning with MindsDB.

Predicting Supermarket Future Sales Using Machine Learning with MindsDB.

3
Comments
6 min read
Exploratory Data Analysis Using SQL.

Exploratory Data Analysis Using SQL.

75
Comments 2
3 min read
Codewars Challenge Day 5: JS, Python + SQL and PHP

Codewars Challenge Day 5: JS, Python + SQL and PHP

5
Comments
2 min read
loading...