/Database Design & Development - Advanced

Course Curriculum

Section 1 · Module 1: Advanced SQL & Stored Procedures

○ Writing advanced SQL queries ▶ Subqueries and Common Table Expressions (CTEs) ○ Creating Views, Triggers, and Stored Procedures ○ Using functions and operators for complex calculations

Section 2 · Module 2: NoSQL Databases & When to Use Them

○ Differences between SQL & NoSQL databases ○ Introduction to MongoDB, Firebase, and Cassandra ○ Working with JSON and BSON data formats ○ CRUD operations in NoSQL databases

Section 3 · Module 3: Database Security & Access Control

○ User roles and permissions (GRANT, REVOKE) ○ Securing databases against SQL Injection and XSS attacks ○ Encryption techniques for sensitive data ○ Backup & recovery strategies

Section 4 · Module 4: Cloud Databases & Distributed Systems

○ Introduction to cloud-based databases (AWS RDS, Google Cloud SQL, Azure Cosmos DB) ○ Horizontal vs. Vertical scaling ○ Database replication and sharding ○ High availability and failover strategies

Section 5 · Module 5: Performance Tuning & Optimization

○ Query tuning techniques ○ Partitioning and caching strategies ○ Using tools like Redis, Memcached for caching ○ Analyzing performance metrics and logs

Module 1: Advanced SQL & Stored Procedures

Subqueries and Common Table Expressions (CTEs)

← Previous Continue →