[go: up one dir, main page]
Scribd
Upload
2 views4 pages

SQL For Data Analytics AdityaTyagi Final

This document is a comprehensive guide to SQL for data analytics, covering basics, intermediate, and advanced concepts. It includes examples of creating databases, using joins, aggregations, window functions, and subqueries. Additionally, it discusses practical analytics use cases such as customer segmentation and sales trend analysis.

Uploaded by

onlineloginwebsite
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views4 pages

SQL For Data Analytics AdityaTyagi Final

This document is a comprehensive guide to SQL for data analytics, covering basics, intermediate, and advanced concepts. It includes examples of creating databases, using joins, aggregations, window functions, and subqueries. Additionally, it discusses practical analytics use cases such as customer segmentation and sales trend analysis.

Uploaded by

onlineloginwebsite
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

SQL for Data Analytics

A Complete Guide with Examples

By Aditya Tyagi

Aditya Tyagi
Step 1: SQL Basics
This section introduces SQL fundamentals such as creating databases, tables,
inserting records, and selecting data.

Example:
CREATE DATABASE company;
CREATE TABLE employees (id INT, name VARCHAR(50), salary NUMERIC);
INSERT INTO employees VALUES (1,'Aditya',50000);
SELECT * FROM employees;

Aditya Tyagi
Step 2: Intermediate SQL – Joins, Aggregations,
Cleaning
This section explores relational operations across multiple tables using JOINs,
along with aggregation functions and cleaning data.

Example – INNER JOIN:


SELECT e.name, d.department_name
FROM employees e
INNER JOIN departments d ON e.dept_id = d.id;

Example – GROUP BY:


SELECT dept_id, AVG(salary)
FROM employees
GROUP BY dept_id;

Data Cleaning Example:


UPDATE employees SET city = 'Delhi' WHERE city IS NULL;

Aditya Tyagi
Step 3: Advanced SQL – Window Functions,
Subqueries, CTEs
Window Functions Example – Ranking:
SELECT name, salary,
RANK() OVER (ORDER BY salary DESC) AS rank
FROM employees;

Subquery Example:
SELECT name, salary FROM employees
WHERE salary > (SELECT AVG(salary) FROM employees);

CTE Example:
WITH HighEarners AS (
SELECT name, salary FROM employees WHERE salary > 60000)
SELECT * FROM HighEarners;

Analytics Use Cases include customer segmentation, sales trend analysis, fraud
detection, and building reporting dashboards.

[Visual ERD & Join Diagrams Placeholder – can be polished diagrams for LinkedIn
visuals]

Aditya Tyagi

You might also like