Database Administration Topics for Presentations
1. Database Sharding ()تجزئة قواعد البيانات
2. Horizontal vs Vertical Partitioning
3. Data Warehousing Concepts
4. Star Schema vs Snowflake Schema
5. Slowly Changing Dimensions in Data Warehouses
6. Query Optimization Techniques
7. Execution Plans and How to Read Them
8. Indexing Strategies for Large Databases
9. Covering Indexes and Filtered Indexes
10. Database Caching Mechanisms
11. Data Masking Techniques
12. Transparent Data Encryption (TDE)
13. Always Encrypted in SQL Server
14. Dynamic Data Masking vs Static Masking
15. Auditing Database Activities
16. Advanced Stored Procedures with Dynamic SQL
17. Common Table Expressions (CTE) Recursive Queries
18. Window Functions (OVER, PARTITION BY)
19. Table-Valued Parameters in Stored Procedures
20. CROSS APPLY and OUTER APPLY in SQL Server
21. Backup Compression in SQL Server
22. Filegroup Backups and Restores
23. Tail-Log Backup and Disaster Recovery
24. Piecemeal Restore in SQL Server
25. Log Shipping Implementation
26. Database Replication Types (Snapshot, Transactional, Merge)
27. Peer-to-Peer Replication
28. Distributed Queries and Linked Servers
29. PolyBase in SQL Server
30. Change Data Capture (CDC)
31. Introduction to Big Data and SQL Server Integration
32. SQL Server and Hadoop Integration (PolyBase)
33. Using SQL Server with Power BI
34. Predictive Analytics with SQL Server
35. Data Mining Concepts in SQL Server
36. Temporal Tables for Data Versioning
37. Hierarchical Data Storage (Adjacency List & Nested Sets)
38. JSON and XML Data Handling in SQL Server
39. Full-Text Search in Databases
40. Graph Databases in SQL Server
T.Alanowd Fawaz
