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

Pluralsight

SQL Server Data Manipulation Essentials

via Pluralsight

Overview

This course will teach you to optimize SQL
Server performance and manage workloads effectively.

Address the key need for enhancing SQL Server database efficiency and handling larger workloads. In this course, SQL Server Data Manipulation Essentials, you will learn to fine-tune your SQL Server's operations. First, you'll understand how to effectively fetch data. This includes learning to write straightforward SELECT statements, using WHERE clauses to filter your data, and mastering JOIN operations to merge tables effectively. Next, you'll dive into inserting, updating, and deleting records. This knowledge is crucial for keeping your database up-to-date and maintaining its accuracy. Finally, you'll tackle making your database queries run quicker and more smoothly. You'll learn about creating indexes and other optimization techniques that are essential for a database that can grow without slowing down. When you’re finished with this course, you'll be equipped with the necessary skills to manage SQL Server databases efficiently, ready to address the common performance challenges you'll encounter in the professional world.

Syllabus

  • Course Overview 1min
  • Understanding and Retrieving Data in SQL Server 12mins
  • Manipulating and Optimizing Data in SQL Server 12mins

Taught by

Pinal Dave

Reviews

4.5 rating at Pluralsight based on 11 ratings

Start your review of SQL Server Data Manipulation Essentials

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.