पढ़ने योग्य कोड लिखें

वास्तविक समस्याओं पर SQL लागू करना

Dmitriy (Dima) Gorenshteyn

Lead Data Scientist, Memorial Sloan Kettering Cancer Center

SQL कमांड को कैपिटलाइज़ करें

मूल

select 
  title as film_title, 
  description as film_description
from rental as r
join inventory as i
  on r.inventory_id = i.inventory_id
join film as f
  on i.film_id = f.film_id
where f.length > 90
  and f.replacement_cost > 20;

बेहतर

SELECT 
  title AS film_title, 
  description AS film_description
FROM rental AS r
JOIN inventory AS i
  ON r.inventory_id = i.inventory_id
JOIN film AS f
  ON i.film_id = f.film_id
WHERE f.length > 90
  AND f.replacement_cost > 20;

नई लाइनों और इंडेंटेशन का उपयोग करें

मूल

SELECT title, description
FROM rental AS r
JOIN inventory AS i
ON r.inventory_id = i.inventory_id
JOIN film AS f ON i.film_id = f.film_id
WHERE f.length > 90 AND f.replacement_cost > 20;

बेहतर

SELECT title, 
       description 
FROM rental AS r
JOIN inventory AS i
  ON r.inventory_id = i.inventory_id
JOIN film AS f
  ON i.film_id = f.film_id
WHERE f.length > 90
  AND f.replacement_cost > 20;

snake_case अपनाएँ

मूल

SELECT 
  title expensivelongtitle, 
  description expensivelongdescription
FROM rental AS r
...

बेहतर

SELECT 
  title expensive_long_title, 
  description expensive_long_description
FROM rental AS r
...

कई OR की जगह IN का उपयोग करें

मूल

SELECT 
    address_id,  
    district 
FROM address
WHERE district = 'Texas'
  OR district = 'Bihar'
  OR district = 'Chiba'
  OR district = 'Chiayi'
  OR district = 'Gois';

बेहतर

SELECT 
    address_id,  
    district 
FROM address
WHERE district IN ('Texas', 'Bihar', 'Chiba', 
                   'Chiayi', 'Gois');

संभव हो तो BETWEEN का उपयोग करें

मूल

SELECT 
  title, 
  description
FROM film
WHERE replacement_cost > 15
  AND replacement_cost < 25;

बेहतर

SELECT 
  title, 
  description
FROM film
WHERE replacement_cost BETWEEN 15 AND 25;

अभ्यास करते हैं!

वास्तविक समस्याओं पर SQL लागू करना