1) Security- Understand SQL injection and parameterized queries.
2) Restoring a database
3) Query load monitoring. How to identify which queries account for the greatest share of your database load?
4) Query optimization.

• -Creating indexes

Rewriting query logic

• Partitioning or sharding
• Denormalization
• Using caches or message queues in our application

5) DBMS tuning.
6) SQL types. Understand the characteristics of different SQL types as they pertain to logic, performance, and storage.
7) Transactions. Understand the importance of grouping changes and committing them as an atomic unit of work. Understand isolation levels.
8) Set-based data operations.
9) High availability.
10) SQL Types
11) Power BI