Performance Tuning and Optimizing
السعر: 32,000 LKR
  • الموقع: Colombo
  • مدة الدورة التدريبية: 2 يوم
  • تاريخ البدء: استفسر

تفاصيل الدورة

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

تحديث بتاريخ 29 April, 2019

المتطلبات

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

وظائف مناسبة لهذه الدورة

Database Administrator , Database Engineer , Software Engineer

استفسر عن هذه الدورة

يمكنك إضافة المزيد من الدورات التدريبية هنا.
سيتم حفظ القائمة.

قيِم هذه الصفحة