Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Optimize Data Manipulation Performance in SQL Server

via Pluralsight

Overview

Boost your SQL Server efficiency. This course will teach you advanced
indexing, query tuning, and concurrency control.

Understanding the importance of fast and reliable data handling in SQL Server, this course is set up to boost your ability to manage databases better. In this course, Optimize Data Manipulation Performance in SQL Server, you will be taken through a detailed journey to fine-tune your skills in SQL Server operations. First, you'll explore deep into the world of indexing, understanding its fundamental role in amplifying your database's performance. Next, through hands-on demos, you'll master the art of enhancing data retrieval and update operations. Finally, the course zooms into the vital aspects of transaction management and concurrency control. When you’re finished with this course, you'll be armed with a robust set of skills essential for managing SQL Server databases efficiently.

Syllabus

  • Course Overview 1min
  • Implementing Indexing and Enhancing Data Operations 11mins
  • Managing Transactions and Establishing Best Practices 14mins

Taught by

Pinal Dave

Reviews

Start your review of Optimize Data Manipulation Performance in SQL Server

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.