Module Breakdown
Live Module 1: Advanced Query Techniques
- Subqueries and nested SELECT statements
- Correlated subqueries and anti-joins
- Common Table Expressions (CTEs) and recursive queries
Live Module 2: Stored Procedures & Functions
- Creating and invoking stored procedures
- User-defined functions (scalar and table-valued)
- Use cases for automation and reporting
- Basic error handling in procedures
Live Module 3: Performance Optimization
- Indexing: clustered vs non-clustered indexes
- Query execution plans and interpretation
- SQL tuning tips: minimizing scans, optimizing joins
- Using EXPLAIN and ANALYZE
Live Module 4: Data Integrity & Constraints
- Advanced constraint management: CHECK, DEFAULT, custom logic
- Views: updatable vs read-only views
- Triggers for audit trails and business rules
Live Module 5: Transactions & Security
- Transaction isolation levels: READ COMMITTED, SERIALIZABLE, etc.
- Locking mechanisms and deadlocks
- Role-based access control and permissions
- Auditing and secure query practices
Live Module 6: Real-World Project & Evaluation
- Project: Design and optimize a database for a job portal or e-commerce dashboard
- Submit: Stored procedures, queries, and ERD (Entity Relationship Diagram)
- Final quiz + peer-reviewed project presentation
Reviews
There are no reviews yet.