Databases & SQL

Relational Databases

SELECT Queries

Filtering & Joining

Database Design

Data Manipulation (DML): INSERT, UPDATE, DELETE

Schema Management: DDL Commands

Data Integrity with Constraints

Advanced Querying: Subqueries & CTEs

Database Security: User Management, Roles, and Permissions

Database Administration: Backup, Recovery, and Disaster Planning

Analytical SQL: Window Functions

Reusable SQL: Views, Stored Procedures, & Functions

Transactions and Concurrency

Database Performance: Indexing & Optimization

Handling Complex Data: JSON, XML, and Spatial Data Types

Triggers and Event-Driven Database Automation

Recursive Queries and Hierarchical Data with CTEs

Scaling Databases: Replication, Sharding, and High Availability

Data Integration with SQL: ETL/ELT and External Data Sources

Advanced Performance Tuning: Execution Plans, Profiling, and Query Rewriting