SwadhyAI Notes
SQL Notes
Explore SQL notes in Swadhyai's Computer Science collection, organized for structured learning and practical revision.
Lessons
- SQL introduction
- SQL syntax
- SQL keywords
- SQL data types
- SQL operators
- Database basics
- Tables, rows, and columns
- Schema
- SELECT queries
- SELECT DISTINCT
- SELECT TOP / LIMIT
- WHERE filtering
- AND, OR, NOT
- BETWEEN and IN
- LIKE patterns
- Wildcards
- ORDER BY
- NULL values
- NULL functions
- INSERT INTO
- INSERT INTO … SELECT
- UPDATE
- DELETE
- Aggregate functions
- MIN() and MAX()
- COUNT()
- SUM() and AVG()
- GROUP BY
- HAVING
- Joins overview
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
- SELF JOIN
- UNION
- UNION ALL
- Subqueries
- EXISTS
- ANY and ALL
- CASE expressions
- Derived tables
- SELECT INTO
- CREATE DATABASE
- DROP DATABASE
- Backup database
- CREATE TABLE
- DROP TABLE
- ALTER TABLE
- Constraints overview
- NOT NULL
- UNIQUE
- PRIMARY KEY
- FOREIGN KEY
- CHECK
- DEFAULT
- AUTO INCREMENT / IDENTITY
- Indexes basics
- Advanced indexing
- Clustered vs non-clustered
- Composite and covering indexes
- Index scan vs seek
- Views
- Materialized views
- Stored procedures
- User-defined functions
- Triggers
- BEGIN, COMMIT, ROLLBACK
- ACID properties
- Isolation levels
- Concurrency anomalies
- Query execution
- Execution plans
- Cost-based optimizer
- Join algorithms
- Partitioning overview
- Sharding and vertical split
- Range and hash partitioning
- Replication and read replicas
- Distributed SQL systems
- OLTP vs OLAP
- Star and snowflake schemas
- ETL pipelines
- JSON data type
- Querying JSON
- Indexing JSON
- Full-text indexing
- LIKE vs full-text search
- Point-in-time recovery
- SQL injection
- Parameters and prepared statements
- SQL hosting
- Connection pooling
- ORM vs raw SQL
- Schema design and relationships
- Read vs write optimization
- Scaling databases
- Slow queries
- Query optimization
- Index tuning
- Top SQL problem patterns
- Second highest salary
- Find duplicates
- Running totals
- Gaps and islands
- Query patterns and debugging
- Lock contention
- Deadlocks
- Query timeouts
- Quick reference
- Keywords summary
- Join comparison
- Aggregate functions summary
- SQL examples
- SQL editor
- SQL quiz
- SQL exercises