Performance Tuning and Optimizing Microsoft SQL Server Databases
This two-day instructor-led course focuses on Performance Tuning and Optimizing Microsoft SQL Server databases. You will learn the way of making an optimized database, increasing the concurrency and performance of queries.
- Course Objectives
- Course Outline
- Course Materials
Instructor Profile
Dinesh Priyankara, MVP, MCT
Founder / Principal Architect at dinesQL
Dinesh is an experienced professional and database enthusiast with skills in database management systems and business intelligence, especially on the Microsoft SQL Server product suite. Possessing over 16 years of experience in data-related technologies, he does training, and consulting, and is a top contributor to the local SQL Server community.
Related Coursers
Inquire Now
Audience Profile
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
Participant Prerequisites
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
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 concurrency 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 design considerations
- Table design considerations
- Table structures
- Rowstore index
- Columnstore index
- Index maintenance
- Statistics
- Locks and blocks
- Isolation Levels
- Memory-optimized tables
Course Materials
The following materials are included as part of the course:
- Printed slides with hands-on instructions
- Sample datasources for hands-on
Frequently Asked Questions
Velit sociosqu purus enim pharetra sed sem at iaculis. Felis ridiculus adipiscing dignissim eros pellentesque mus vitae litora. Felis nullam tortor phasellus viverra ut arcu. Euismod magnis ante convallis vulputate odio augue sit pretium dapibus.
Velit sociosqu purus enim pharetra sed sem at iaculis. Felis ridiculus adipiscing dignissim eros pellentesque mus vitae litora. Felis nullam tortor phasellus viverra ut arcu. Euismod magnis ante convallis vulputate odio augue sit pretium dapibus.
Velit sociosqu purus enim pharetra sed sem at iaculis. Felis ridiculus adipiscing dignissim eros pellentesque mus vitae litora. Felis nullam tortor phasellus viverra ut arcu. Euismod magnis ante convallis vulputate odio augue sit pretium dapibus.
Velit sociosqu purus enim pharetra sed sem at iaculis. Felis ridiculus adipiscing dignissim eros pellentesque mus vitae litora. Felis nullam tortor phasellus viverra ut arcu. Euismod magnis ante convallis vulputate odio augue sit pretium dapibus.
Join Our Business Coaching Program And Start Seeing Results Now!
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Frequently Asked Questions
Velit sociosqu purus enim pharetra sed sem at iaculis. Felis ridiculus adipiscing dignissim eros pellentesque mus vitae litora. Felis nullam tortor phasellus viverra ut arcu. Euismod magnis ante convallis vulputate odio augue sit pretium dapibus.
Velit sociosqu purus enim pharetra sed sem at iaculis. Felis ridiculus adipiscing dignissim eros pellentesque mus vitae litora. Felis nullam tortor phasellus viverra ut arcu. Euismod magnis ante convallis vulputate odio augue sit pretium dapibus.
Velit sociosqu purus enim pharetra sed sem at iaculis. Felis ridiculus adipiscing dignissim eros pellentesque mus vitae litora. Felis nullam tortor phasellus viverra ut arcu. Euismod magnis ante convallis vulputate odio augue sit pretium dapibus.
Velit sociosqu purus enim pharetra sed sem at iaculis. Felis ridiculus adipiscing dignissim eros pellentesque mus vitae litora. Felis nullam tortor phasellus viverra ut arcu. Euismod magnis ante convallis vulputate odio augue sit pretium dapibus.
Testimonials
Our Students Reviews
Urna luctus nostra lacinia faucibus primis felis augue non leo tempor ullamcorper.
