Designing and Implementing SQL Server Database Indexes

This course is an introduction to SQL Server indexes. In this course, you will be covering common index types and discussing how to index to support your workloads.

4|Reviews (146)
Security+Learn the skills to keep up with tomorrow’s cybersecurity threats.
₹1,467/mo
Security+Learn the skills to keep up with tomorrow’s cybersecurity threats.
₹1,027

Why choose Core Tech?

check
Access to 7,000+ top courses and specializations
check
Unlimited certificates for every completed course
check
Learn offline by downloading course videos
check
Content from top institutions like Yale & Google
check
14-day money-back guarantee included
✓ Compare courses before making a decision
Check Latest Price →
Price may vary. Check latest price on provider site.

Course Insight

Suitable for intermediate learners. Works well as a continuation after mastering Software Development fundamentals. It bridges the gap toward advanced, production-level engineering.

Intermediate FriendlySelf-Paced Learning

SKILLS TO
MASTER

Software Development Basics
Fundamental principles and concepts
Practical ApplicationTrending
Real-world project implementation
Best Practices
Industry standard workflows and guidelines
Problem Solving
Core Concepts
Implementation
Workflow Integration
Optimization
Careers:Relevant for professionals pursuing roles within Software Development.

Quick Facts

Below sections are verified from last major sync. For real-time updates and today's latest lectures, Check official page here.

What You’ll Learn

Poor database performance is a problem for applications and annoys users. Poor performance often comes down to poor indexing of critical tables. In this course, Designing and Implementing SQL Server Database Indexes, you'll gain knowledge on how to avoid these issues through the effective use of SQL Server database indexes. First, you'll discover the main index types that SQL Server has. Next, you'll explore considerations for their use. Finally, you'll learn how to choose indexes and index keys to best support your applications. When you've finished this course, you'll be in a good position to optimize all of your SQL Server databases and improve your applications' speed and throughput.

See how this course curriculum compares with alternatives

Outcomes

  • Course Overview : 1min.
  • General Indexing Guidelines : 6mins.
  • Understanding Basic Index Architecture and Index Usage : 11mins.
  • Designing Indexes to Organize Tables : 18mins.
  • Designing Indexes to Improve Query Performance: Part 1 : 33mins.
  • Designing Indexes to Improve Query Performance: Part 2 : 18mins.
  • Designing Indexed Views : 12mins.
  • Designing Columnstore Indexes for Analytic Queries : 23mins.
  • Summary and Further Reading : 7mins.
See side-by-side differences in learning outcomes

FAQs

Top Alternatives

Highly-rated courses worth your attention

Optimizing SQL Server Statistics and Indexes
4.0· 1 Hrs 49 minutes
Advanced
CORE TECH
₹880/mo
What Every Developer Should Know About SQL Server Performance
5.0· 3 Hrs 22 minutes
Beginner
CORE TECH
₹880/mo
Practical SQL Server In-Memory OLTP Tables and Objects
4.0· 2 - Hrs 50 minutes
Intermediate
CORE TECH
₹880/mo
Programming SQL Server Database Triggers and Functions
4.0· 3 Hrs 21 minutes
Intermediate
CORE TECH
₹880/mo
Troubleshooting SQL Server Performance with sp_WhoIsActive
4.0· 43 minutes
Intermediate
CORE TECH
₹880/mo
JavaScript Promises and Async Programming
5.0· 1 Hrs 21 minutes
Intermediate
CORE TECH
₹880/mo
Designing and Implementing SQL Server Database Indexes
4(146+ learners)