Scribd
Upload
92 views2 pages

SQL Syllabus

The document outlines a comprehensive syllabus for mastering SQL and database concepts, including recommended books, courses, and practice resources. It covers topics from fundamentals of databases to advanced SQL queries, performance optimization, and NoSQL concepts. Additionally, it provides links to interview questions and project resources to enhance learning and preparation.

Uploaded by

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

SQL Syllabus

The document outlines a comprehensive syllabus for mastering SQL and database concepts, including recommended books, courses, and practice resources. It covers topics from fundamentals of databases to advanced SQL queries, performance optimization, and NoSQL concepts. Additionally, it provides links to interview questions and project resources to enhance learning and preparation.

Uploaded by

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

CLASSES

[Link]
[Link]
[Link]

NOTES
[Link]
[Link]

PROBLEMS
[Link]
INTERVIEW QUESTIONS
[Link]
[Link]

PROJECTS
[Link]

Syllabus

Refer page

1. Fundamentals of Databases
 📘 Book: Database System Concepts – Silberschatz, Korth, Sudarshan (Covers
RDBMS, ER models, and Normalization)
 🎥 Course: Introduction to Databases by Stanford University (FREE)
 📝 Docs: PostgreSQL Documentation (Covers relational databases in depth)

2. SQL Basics
 📘 Book: SQL for Data Scientists – Renee M. P. Teate
 🎥 Course: Mode SQL Tutorial (Interactive) (Great for SQL hands-on practice)
 📝 Docs: W3Schools SQL Guide (Best for quick references)

3. Querying and Data Retrieval


 🎥 Course: Khan Academy: SQL Queries
 🔧 Practice: SQLZoo (Hands-on SQL exercises)

4. Advanced SQL Queries


 🎥 Course: Advanced SQL by Mode Analytics
 🔧 Practice: LeetCode SQL Questions (Essential for MAANG-level SQL problems)
 📘 Book: Joe Celko’s SQL for Smarties (Advanced SQL concepts)

5. Window Functions (Analytical SQL)


 🎥 Video: SQL Window Functions Explained (DataCamp)
 📝 Docs: PostgreSQL Window Functions
 🔧 Practice: Mode Window Functions Tutorial

6. Performance Optimization in SQL


 🎥 Course: Indexing and Query Optimization (DataCamp)
 🔧 Practice: Use EXPLAIN ANALYZE for Optimization (PostgreSQL)
 📘 Book: High-Performance MySQL (For advanced optimization)

7. Transactions and Concurrency Control


 🎥 Course: ACID Transactions (Udacity)
 📝 Docs: MySQL Transactions Guide

8. NoSQL Concepts
 🎥 Course: MongoDB University Free Course
 📘 Book: Designing Data-Intensive Applications – Martin Kleppmann (Best book for
SQL vs NoSQL)

9. Data Science-Specific SQL Case Studies


 🎥 Video: SQL for Data Science (Coursera)
 🔧 Practice: StrataScratch SQL Problems (Real-world SQL problems for Data
Science)

10. System Design Basics for Data Scientists


 📘 Book: The Data Warehouse Toolkit – Ralph Kimball (Covers OLAP vs OLTP)
 🎥 Video: ETL for Data Science (YouTube)

📌 SQL Practice Websites (Highly Recommended)


1. LeetCode SQL Problems – Covers MAANG-level SQL challenges
2. Mode Analytics SQL Playground – Interactive SQL tutorials
3. StrataScratch – SQL questions from real-world companies
4. HackerRank SQL Challenges – Beginner to advanced SQL practice
5. SQLZoo – Hands-on SQL exercises
Would you like a structured study plan with a timeline to master these topics before an
interview? 🚀

You might also like