تفاصيل الدورة
Course Objectives
After completing this course, you will be able to:
- Describe design considerations of Microsoft SQL Server databases.
- Describe design considerations of Microsoft SQL Server tables.
- Describe table structures such as heap and cluster.
- Describe indexing types: Rowstore and Columnstore.
- Describe how to use and maintain indexes.
- Describe statistics and why they are important.
- Describe how to handle locks and blocks.
- Describe concurreny issues and how to handle them.
- Describe how to use memory-optimized tables and natively compiled procedures.
Course Outline
The following items describe the outline of the course:
- Database deisgn considerations
- Table design considerations
- Table strcutures
- Rowstore index
- Columnstore index
- Index maintenance
- Statistics
- Locks and blocks
- Isolation Levels
- Memory-optimized tables
المتطلبات
This course requires that you meet the following prerequisites:
- Working knowledge of data related solutions
- Working knowledge on Microsoft SQL Server database
- Working knowledge on T-SQL
الموقع
SQL Server أسئلة ذات صلة
استفسر عن هذه الدورة
يمكنك إضافة المزيد من الدورات التدريبية هنا.
سيتم حفظ القائمة.
