We may earn an affiliate commission when you visit our partners.
Pinal Dave
and
Vinod Kumar
This course teaches you how to master the art of performance tuning SQL Server by better understanding indexes.
Indexes are the most crucial objects of the database. They are the first stop for any DBA and Developer when it is about performance tuning. There is good side as well evil side of the indexes. To master the art of performance tuning one has to understand the fundamentals of the indexes and the best practices associated with the same. This course is for every DBA and Developer who deals with performance tuning and wants to use indexes to improve the performance of server.
Register for this course and see more details by visiting:
OpenCourser.com/course/er2xis/sql
What's inside
Syllabus
Introduction
Fundamentals of Indexing
Practical Indexing Implementation Techniques
Index Maintenance
Read more
Syllabus
Introduction
Fundamentals of Indexing
Practical Indexing Implementation Techniques
Index Maintenance
Read more
Introduction to Columnstore Index
Indexing Practical Performance Tips and Tricks
Checklist: Index and Performance
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Taught by Pinal Dave and Vinod Kumar, who are recognized for their work in SQL Server and performance tuning
Explores the fundamentals of indexing, which is standard in database management systems
Provides practical indexing implementation techniques for better performance tuning
Covers index maintenance, a crucial aspect for efficient database management
Addresses the practical implementation of columnstore indexes for improved performance
Offers indexing practical performance tips and tricks, providing valuable insights for optimization
Save this course
Save SQL Server Performance: Indexing Basics to your list so you can find it easily later:
Save
Save
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in SQL Server Performance: Indexing Basics with these
activities:
Review SQL Fundamentals
Show steps
Sharpen your SQL skills prior to taking this course by reviewing core concepts like data types, operators, and query syntax.
Browse courses on
SQL Queries
Show steps
-
Go through an online tutorial on SQL basics.
-
Take practice quizzes on SQL syntax.
-
Review your notes or a SQL textbook.
SQL Query Practice
Show steps
Solidify your understanding of SQL by working through practice problems and exercises.
Browse courses on
SQL Queries
Show steps
-
Find practice problems online or in textbooks.
-
Solve the problems and verify your answers.
-
Review incorrect answers to identify areas for improvement.
SQL Server Indexing Discussion Group
Show steps
Engage with peers to discuss indexing techniques, share knowledge, and troubleshoot performance issues.
Browse courses on
Database Performance
Show steps
-
Join an online discussion forum or study group dedicated to SQL Server indexing.
-
Participate in discussions and ask questions.
-
Share your own experiences and insights.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Index Best Practices Guide
Show steps
Consolidate your knowledge and create a comprehensive guide to index best practices for reference and future use.
Browse courses on
Database Optimization
Show steps
-
Collect resources, articles, and documentation on index best practices.
-
Organize and summarize the information into a coherent guide.
-
Include examples, case studies, and practical tips.
-
Review and refine your guide.
Index Performance Analysis Project
Show steps
Apply your knowledge of indexes to a real-world scenario by conducting an analysis and proposing optimizations for a given dataset.
Browse courses on
SQL Server Optimization
Show steps
-
Select a dataset and identify relevant queries.
-
Create and implement different indexes.
-
Measure and compare query performance.
-
Document your findings and recommendations.
Advanced Indexing Techniques Tutorial
Show steps
Supplement your learning by exploring advanced indexing concepts such as covering indexes, filtered indexes, and spatial indexes.
Show steps
-
Find reputable online tutorials or courses on advanced indexing.
-
Go through the tutorial materials and complete any exercises.
-
Apply the techniques you learn to your own projects or datasets.
Contribute to SQL Server Open Source Projects
Show steps
Gain hands-on experience and contribute to the SQL Server community by participating in open source projects related to indexing and optimization.
Browse courses on
Database Optimization
Show steps
-
Identify open source projects related to SQL Server indexing.
-
Review the project code and documentation.
-
Contribute code or documentation improvements.
Review SQL Fundamentals
Show steps
Sharpen your SQL skills prior to taking this course by reviewing core concepts like data types, operators, and query syntax.
Browse courses on
SQL Queries
Show steps
Show steps
Show steps
- Go through an online tutorial on SQL basics.
- Take practice quizzes on SQL syntax.
- Review your notes or a SQL textbook.
SQL Query Practice
Show steps
Solidify your understanding of SQL by working through practice problems and exercises.
Browse courses on
SQL Queries
Show steps
Show steps
Show steps
- Find practice problems online or in textbooks.
- Solve the problems and verify your answers.
- Review incorrect answers to identify areas for improvement.
SQL Server Indexing Discussion Group
Show steps
Engage with peers to discuss indexing techniques, share knowledge, and troubleshoot performance issues.
Browse courses on
Database Performance
Show steps
Show steps
Show steps
- Join an online discussion forum or study group dedicated to SQL Server indexing.
- Participate in discussions and ask questions.
- Share your own experiences and insights.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Index Best Practices Guide
Show steps
Consolidate your knowledge and create a comprehensive guide to index best practices for reference and future use.
Browse courses on
Database Optimization
Show steps
Show steps
Show steps
- Collect resources, articles, and documentation on index best practices.
- Organize and summarize the information into a coherent guide.
- Include examples, case studies, and practical tips.
- Review and refine your guide.
Index Performance Analysis Project
Show steps
Apply your knowledge of indexes to a real-world scenario by conducting an analysis and proposing optimizations for a given dataset.
Browse courses on
SQL Server Optimization
Show steps
Show steps
Show steps
- Select a dataset and identify relevant queries.
- Create and implement different indexes.
- Measure and compare query performance.
- Document your findings and recommendations.
Advanced Indexing Techniques Tutorial
Show steps
Supplement your learning by exploring advanced indexing concepts such as covering indexes, filtered indexes, and spatial indexes.
Show steps
Show steps
Show steps
- Find reputable online tutorials or courses on advanced indexing.
- Go through the tutorial materials and complete any exercises.
- Apply the techniques you learn to your own projects or datasets.
Contribute to SQL Server Open Source Projects
Show steps
Gain hands-on experience and contribute to the SQL Server community by participating in open source projects related to indexing and optimization.
Browse courses on
Database Optimization
Show steps
Show steps
Show steps
- Identify open source projects related to SQL Server indexing.
- Review the project code and documentation.
- Contribute code or documentation improvements.
Career center
Learners who complete SQL Server Performance: Indexing Basics will develop knowledge and skills
that may be useful to these careers:
Data Analyst
Data Analyst
Data Analysts are responsible for extracting meaningful insights from data to help organizations make better decisions, understand trends, and gain a competitive advantage. To do their jobs effectively, Data Analysts must master techniques that enable them to efficiently retrieve data from databases. This course on SQL Server Performance: Indexing Basics is a valuable tool for Data Analysts seeking to gain a deeper understanding of the fundamentals of indexing, as well as practical implementation techniques that will allow them to quickly and effectively retrieve data from SQL Server databases, a key skill set for Data Analysts who wish to succeed within their roles.
Database Administrator
Database Administrator
Database Administrators are guardians of data within an organization, ensuring its security, availability, and integrity, which makes them vital to many organizations. Increasingly, they are responsible for large-scale data systems and are required to have a deep knowledge of relational databases. As such, a deep understanding of indexing, one of the core concepts of relational databases, is needed to efficiently manage and maintain data. With its focus on the fundamentals of indexing and practical implementation techniques, this course is a valuable opportunity to enhance the essential skills required of Database Administrators.
Data Engineer
Data Engineer
Data Engineers serve as the bridge between data and business intelligence, building and maintaining the infrastructure necessary for data storage, processing, and analysis. They are increasingly required to work with relational databases, making a profound understanding of indexing techniques crucial for efficiently managing and maintaining large datasets to support data analysts and other stakeholders. This course provides a deep dive into the world of indexing, covering topics such as: Introduction, Fundamentals of Indexing, Practical Indexing Implementation Techniques, Index Maintenance, Columnstore Index, Practical Performance Tips and Tricks, and a Checklist: Index and Performance, which are crucial for Data Engineers to master in order to succeed within their roles.
Database Developer
Database Developer
Database Developers specialize in designing, developing, and maintaining databases, ensuring the efficient storage, retrieval, and management of data within organizations. Indexing plays a critical role in database operations, influencing factors such as data retrieval speed, scalability, and performance. This course, by providing a thorough understanding of SQL Server indexing, equips Database Developers with the knowledge and skills necessary to create and manage efficient database systems. It covers essential topics such as: Introduction, Fundamentals of Indexing, Practical Indexing Implementation Techniques, and Index Maintenance, which are foundational to the success of Database Developers.
Software Engineer
Software Engineer
Software Engineers design, develop, and maintain software applications, playing a vital role in organizations across all industries. Mastery of indexing techniques enables Software Engineers to develop efficient and scalable database applications. This course, with its focus on the fundamentals of indexing in SQL Server, provides a solid foundation for Software Engineers, enabling them to store, retrieve, and manipulate data in databases more effectively. By understanding how to design and implement effective indexes, Software Engineers can contribute to the performance, reliability, and scalability of the software applications they develop.
Systems Analyst
Systems Analyst
Systems Analysts analyze, design, and implement computer systems to meet the needs of businesses and organizations. They often work with relational databases, making a strong understanding of indexing techniques essential for efficiently managing and maintaining data. This course, by providing a thorough understanding of SQL Server indexing, equips Systems Analysts with the knowledge and skills necessary to design and implement efficient database systems. It covers essential topics such as Introduction, Fundamentals of Indexing, Practical Indexing Implementation Techniques, and Index Maintenance, which are foundational to the success of Systems Analysts.
Business Intelligence Analyst
Business Intelligence Analyst
Business Intelligence Analysts bridge the gap between data and decision-making, transforming raw data into actionable insights for businesses. A strong understanding of indexing techniques is essential for Business Intelligence Analysts to efficiently access and analyze large volumes of data stored in relational databases, such as SQL Server. This course, with its focus on SQL Server Performance: Indexing Basics, provides a solid foundation for Business Intelligence Analysts, enabling them to quickly and effectively retrieve data, perform analysis, and generate insights that drive better business decisions.
Data Scientist
Data Scientist
Data Scientists are responsible for extracting knowledge and insights from data, helping businesses understand trends, patterns, and opportunities, and make data-driven decisions. As they often work with large datasets stored in relational databases, a deep understanding of indexing techniques is crucial to efficiently retrieve and analyze data. This course provides a comprehensive overview of SQL Server indexing, covering topics such as: Introduction, Fundamentals of Indexing, Practical Indexing Implementation Techniques, and Index Maintenance, which are fundamental to the success of Data Scientists.
IT Architect
IT Architect
IT Architects design, build, and maintain the technology infrastructure of organizations, ensuring alignment with business goals and objectives. Indexing techniques are fundamental to the design and implementation of efficient and scalable database systems, which are critical components of any IT infrastructure. This course on SQL Server Performance: Indexing Basics, provides IT Architects with a deep understanding of indexing fundamentals, practical implementation techniques, and performance optimization strategies. Mastery of these concepts will enable IT Architects to design and build robust and performant database systems that meet the evolving needs of organizations.
Information Technology Manager
Information Technology Manager
Information Technology Managers oversee the planning, implementation, and maintenance of technology systems within organizations. Mastery of indexing techniques is crucial for managing and maintaining efficient and scalable database systems. This course on SQL Server Performance: Indexing Basics provides IT Managers with a deep understanding of indexing fundamentals, practical implementation techniques, and performance optimization strategies. With this knowledge, IT Managers can effectively manage their teams and ensure the smooth operation of database systems, contributing to the overall success of their organizations.
Data Integration Architect
Data Integration Architect
Data Integration Architects design and implement data integration solutions, enabling organizations to combine data from multiple sources into a unified and consistent view. Indexing techniques are crucial to ensure efficient and scalable data integration. This course on SQL Server Performance: Indexing Basics provides Data Integration Architects with a deep understanding of indexing fundamentals, practical implementation techniques, and performance optimization strategies. With this knowledge, Data Integration Architects can design and build robust and performant data integration solutions that meet the evolving needs of organizations.
Software Developer
Software Developer
Software Developers create and maintain software applications, often working with databases to store and manage data. Indexing techniques play a critical role in database performance, directly impacting the efficiency of data retrieval and manipulation. This course on SQL Server Performance: Indexing Basics provides Software Developers with a solid foundation in indexing fundamentals, practical implementation techniques, and performance optimization strategies. By understanding how to design and implement effective indexes, Software Developers can build efficient and scalable software applications.
Database Architect
Database Architect
Database Architects design and build the structure and architecture of databases, ensuring efficient data storage, retrieval, and management. Indexing techniques are foundational to the design and implementation of efficient and scalable database systems. This course on SQL Server Performance: Indexing Basics provides Database Architects with a deep understanding of indexing fundamentals, practical implementation techniques, and performance optimization strategies. Mastery of these concepts will enable Database Architects to design and build robust and performant database systems that meet the evolving needs of organizations.
Database Administrator Trainee
Database Administrator Trainee
Database Administrator Trainees work under the supervision of experienced Database Administrators, gaining hands-on experience in managing and maintaining databases. Indexing techniques are foundational to the efficient operation of databases, influencing factors such as data retrieval speed, scalability, and performance. This course on SQL Server Performance: Indexing Basics provides Database Administrator Trainees with a solid grounding in indexing fundamentals and practical implementation techniques. By understanding how to design and implement effective indexes, Database Administrator Trainees can contribute to the efficient management and maintenance of database systems.
Systems Administrator
Systems Administrator
Systems Administrators manage and maintain computer systems, ensuring their reliability, performance, and security. They often work with databases, making a solid understanding of indexing techniques important. This course on SQL Server Performance: Indexing Basics provides Systems Administrators with a foundation in indexing fundamentals, practical implementation techniques, and performance optimization strategies. By understanding how to design and implement effective indexes, Systems Administrators can contribute to the efficient operation and maintenance of database systems within their organizations.
For more career information including salaries, visit:
OpenCourser.com/course/er2xis/sql
Reading list
We've selected seven books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
SQL Server Performance: Indexing Basics.
A comprehensive guide to SQL Server performance tuning, with a focus on indexing. provides a deep dive into the different types of indexes, how to create and manage them, and how to use them to improve performance.
Great reference for anyone who wants to learn more about SQL Server performance tuning.
A practical guide to SQL Server performance tuning, with a focus on real-world examples. provides step-by-step instructions on how to identify and resolve performance problems.
Great resource for anyone who wants to learn more about troubleshooting SQL Server.
A Chinese translation of the book "SQL Server Indexing Internals". provides a deep dive into the internals of SQL Server indexing.
Provides a comprehensive overview of SQL and great resource for anyone who wants to learn more about the basics of SQL.
A collection of best practices for SQL Server performance tuning. provides practical advice on how to improve the performance of SQL Server databases.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/er2xis/sql
Share
Similar courses
Here are nine courses similar to
SQL Server Performance: Indexing Basics.
MySQL Indexing for Performance
OpenCourser.com/course/475gvd/mysql
MySQL Indexing for Performance
Most relevant
Oracle SQL Performance Tuning
OpenCourser.com/course/pc1xx2/oracle
Oracle SQL Performance Tuning
Most relevant
PostgreSQL: Index Tuning and Performance Optimization
OpenCourser.com/course/ja7czb/postgresql
PostgreSQL: Index Tuning and Performance Optimization
Most relevant
What Every Developer Should Know About SQL Server Performance
OpenCourser.com/course/k3q8w4/what
What Every Developer Should Know About SQL Server...
Most relevant
Optimize Data Manipulation Performance in SQL Server
OpenCourser.com/course/h3iqdc/optimize
Optimize Data Manipulation Performance in SQL Server
Most relevant
Real-world Scenarios: SQL Server Query Tuning in Action
OpenCourser.com/course/1w9vm7/real
Real-world Scenarios: SQL Server Query Tuning in Action
Most relevant
Oracle Performance Tuning for Developers
OpenCourser.com/course/ocon7v/oracle
Oracle Performance Tuning for Developers
Most relevant
How To Begin Your Career As a SQL Server DBA
OpenCourser.com/course/2p1p03/how
How To Begin Your Career As a SQL Server DBA
Most relevant
Optimizing Query Performance with Columnstore Indexes
OpenCourser.com/course/vssusv/optimizing
Optimizing Query Performance with Columnstore Indexes
Time
119 hours
Level
Intermediate
Via
Pluralsight
Instructors
Pinal Dave
Vinod Kumar
Language
English
Good to know
Taught by Pinal Dave and Vinod Kumar, who are recognized for their work in SQL Server and performance tuning
Explores the fundamentals of indexing, which is standard in database management systems
Provides practical indexing implementation techniques for better performance tuning
Covers index maintenance, a crucial aspect for efficient database management
Addresses the practical implementation of columnstore indexes for improved performance
Offers indexing practical performance tips and tricks, providing valuable insights for optimization
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser