This diagram provides a high-level roadmap of the core ***SQL*** concepts and how they fit together. ... Use this visual overview to guide your learning journey and grasp how the different pieces of ***SQL*** work

***SQL*** Learning Roadmap

devs

This diagram provides a high-level roadmap of the core SQL concepts and how they fit together.

It covers key elements like databases, tables, data types, functions, and essential statements to query and modify data.

Use this visual overview to guide your learning journey and grasp how the different pieces of SQL work together.

![IMG_20240419_133715.jpg](https://m.stacker.news/27339)

SQL Learning Roadmap

Azik

I really like this guy's idea for a ***SQL*** project. ... He wants to create a ***SQL*** database that connects buyers and sellers of cars. ... What I wanted was a ***SQL*** database that provided car specs (length, width, mpg, seats, etc.) and an average

***SQL*** Project: Used Car Marketplace Database

opensource

I really like this guy's idea for a SQL project. He's taking one (giant) step further the project that I was researching when I found his.

He wants to create a SQL database that connects buyers and sellers of cars. He would use a bidding system.

What I wanted was a SQL database that provided car specs (length, width, mpg, seats, etc.) and an average price range based on mileage on the car. Does anywhere know where I can get the raw data for something like this?

SQL Project: Used Car Marketplace Database

ablunderfilledlife

DWN ***SQL*** Stores: ***SQL*** backed implementations

bitcoin

DWN SQL Stores: SQL backed implementations

Rsync25

***SQL*** Tips and Tricks

tech

This link was posted by [regexman1](https://news.ycombinator.com/user?id=regexman1) 2 hours ago on [HN](https://news.ycombinator.com/item?id=41643651). It received 110 points and 49 comments.

SQL Tips and Tricks

***SQL*** as API

SQL as API

A newly identified hacker group, designated as STAC6451, has been actively targeting Microsoft ***SQL*** (MSSQL

STAC6451 Hackers Attacking Microsoft ***SQL*** Servers to Compromise Organizations

news

A newly identified hacker group, designated as STAC6451, has been actively targeting Microsoft SQL (MSSQL) servers to compromise organizations, primarily in India. This group leverages exposed MSSQL servers to deploy ransomware and other malicious activities, posing a significant threat to various sectors.

STAC6451 Hackers Attacking Microsoft SQL Servers to Compromise Organizations

ch0k1

Upsert in ***SQL***

Upsert in SQL

kristapsk

***Sqlx***: 🧰 The Rust ***SQL*** Toolkit. An async, pure Rust ***SQL***

rust

Sqlx: 🧰 The Rust SQL Toolkit. An async, pure Rust SQL

Show HN: Natural-***SQL***-7B, a strong text-to-***SQL*** model

Show HN: Natural-SQL-7B, a strong text-to-SQL model

The government doesn't use ***SQL*** (or Elon has never used ***SQL***)

![](https://pbs.twimg.com/media/GjfMiC6bIAA2k28?format=jpg&name=large)

Please read this exchange about "deduplicated SSN Numbers". Which of the two do you think is the truth?

The government doesn't use SQL (or Elon has never used SQL)

zuspotirko

***SQL*** style guide by Simon Holywell

SQL style guide by Simon Holywell

What if an ***SQL*** Statement Returned a Database?

What if an SQL Statement Returned a Database?

***SQL*** for data scientists in 100 queries

SQL for data scientists in 100 queries

I Went to ***SQL*** Injection Court

This link was posted by [mrkurt](https://news.ycombinator.com/user?id=mrkurt) 1 hour ago on [HN](https://news.ycombinator.com/item?id=43175628). It received 226 points and 71 comments.

I Went to SQL Injection Court

Knowing ***SQL*** opens doors. Invest in your odds.

Consider a scenario where you have a product catalog in a database.

Each product might have multiple fields storing the potential price:

- ListPrice
- DiscountedPrice
- SpecialOfferPrice

These prices might be NULL if they're not applicable.

The Problem

Determine the actual selling price of a product by checking these price sources in a specific order.

The first thing you might think of is a CASE. But there is a more elegant way to solve this problem: COALESCE.

COALESCE is useful when you have multiple potential sources for a value and want to use the first available non-null one.

This is how it works:

1. This function evaluates the columns or expressions listed in its arguments from left to right.

2. It starts with SpecialOfferPrice, then moves to DiscountedPrice, and finally, if both are null, it uses ListPrice.

3. COALESCE returns the first non-null value among its arguments. Be careful, MSSQL will throw an error if all arguments are null.

4. For clarity in the output, use the alias SellingPrice as the result of the COALESCE function.

COALESCE simplifies the logic compared to using a series of CASE statements.

It's straightforward and easy to read.

Have you ever used it?

![GK4l1zpXwAAlHP1.jpg](https://m.stacker.news/29304)

Knowing SQL opens doors. Invest in your odds.

RaulJunco

Advent of Code 2024 in pure ***SQL***

This link was posted by [greghn](https://news.ycombinator.com/user?id=greghn) 1 hour ago on [HN](https://news.ycombinator.com/item?id=42577736). It received 118 points and 20 comments.

Advent of Code 2024 in pure SQL

Why ***SQL*** is THE Language to Learn for Data Science - KDnuggets

Why SQL is THE Language to Learn for Data Science - KDnuggets

JReeCoin

How to Work with ***SQL*** Databases in Go – Different Approaches and Examples

How to Work with SQL Databases in Go – Different Approaches and Examples

Show HN: IMDb ***SQL*** Best Movie Finder

This link was posted by [afiodorov](https://news.ycombinator.com/user?id=afiodorov) 2 hours ago on [HN](https://news.ycombinator.com/item?id=42049936). It received 75 points and 34 comments.