SQL Essentials – SQLite Queries (Portfolio)

Job-focused SQLite SQL portfolio demonstrating core skills used in data analyst and analytics internship roles.

Skills Demonstrated

• Data filtering and date handling (WHERE, BETWEEN, IN, LIKE)
• Aggregations and reporting (GROUP BY, HAVING)
• JOINs across multiple tables (INNER, LEFT)
• Subqueries (IN, NOT IN, EXISTS, NOT EXISTS)
• CASE statements for business logic
• VIEW creation for reusable analysis
• Basic DML operations (INSERT, UPDATE, DELETE)

Repository Structure

All queries are organized by topic under the queries/ directory for quick review.

Dataset

Queries are written for a Chinook-style SQLite database schema
(Customer, Invoice, InvoiceLine, Track, Genre, Employee, Artist).

Notes

• SQLite-compatible syntax (no RIGHT JOIN)
• Emphasis on readability and real-world analytics use cases

Training Reference

Based on hands-on exercises from LinkedIn Learning – SQL Essential Training.

Author: Elif Ozdemir