SQL
Full SQL course — 52 topics from the basics to advanced use.
Lessons
- Stored Procedures
- User-Defined Functions
- Triggers
- Temporary Tables
- Sequences and Auto-Generated IDs
- SQL Security
- SQL Injection
- Database Backup and Recovery
- Database Design
- ER Modeling
- SQL Fundamentals
- SQL Command Categories
- Database and Table Creation
- SQL Data Types
- Constraints
- Inserting and Modifying Data
- SELECT Fundamentals
- Filtering Data
- Sorting and Limiting
- SQL Functions
- Aggregate Functions
- Grouping Data
- SQL with Real-World Databases
- Automotive SQL Examples
- SQL for Data Analysis
- SQL Date and Time Analysis
- Duplicate Data
- NULL Handling
- Advanced SQL Patterns
- SQL Interview Preparation
- SQL Practice Problems
- SQL Projects
- SQL Debugging and Troubleshooting
- SQL Best Practices
- Database-Specific SQL
- SQL Learning Roadmap
- SQL Cheat Sheet
- SQL Quizzes (Final Assessment)
- What to Learn Next & Final Checklist
- Joins
- Subqueries
- Set Operations
- Common Table Expressions (CTEs)
- Window Functions
- Views
- Indexes
- Query Performance
- Transactions
- Transaction Isolation
- Database Normalization
- Relationships
- Course Overview & Sample Database