We may earn an affiliate commission when you visit our partners.
Gail Shaw
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.
Read more
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.
Read more
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.
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.
Register for this course and see more details by visiting:
OpenCourser.com/course/k9rkqz/designing
Here's a deal for you
We found an offer that may be relevant to this course.
Save money when you learn.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
What's inside
Syllabus
Course Overview
General Indexing Guidelines
Understanding Basic Index Architecture and Index Usage
Designing Indexes to Organize Tables
Read more
Syllabus
Course Overview
General Indexing Guidelines
Understanding Basic Index Architecture and Index Usage
Designing Indexes to Organize Tables
Read more
Designing Indexes to Improve Query Performance: Part 1
Designing Indexes to Improve Query Performance: Part 2
Designing Indexed Views
Designing Columnstore Indexes for Analytic Queries
Summary and Further Reading
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
Builds a strong foundation for beginners
Taught by Gail Shaw, who are recognized for their work in SQL Server
If you take this course, you'll gain knowledge to improve all aspects of database indexing
Examines SQL Server indexes, which is highly relevant to database performance
This course is strongly industry relevant because poorly indexed databases impact the speed and performance of databases
Teaches methods that are highly aligned with improving the speed and performance of SQL Server databases
Save this course
Save Designing and Implementing SQL Server Database Indexes 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 Designing and Implementing SQL Server Database Indexes with these
activities:
Course Material Review
Show steps
Organize notes, assignments, and reference materials to enhance knowledge retention.
Show steps
-
Review lecture notes and slides
-
Summarize key concepts and ideas
-
Create a study guide or flashcards
SQL Server Indexing Core Concepts
Show steps
Review foundation of SQL Server indexing to fill in knowledge gaps and ensure course preparedness.
Show steps
-
Review documentation on SQL Server Indexes
-
Complete tutorials on basic index types
-
Practice creating and using indexes in a test environment
Review Index Structures and Concepts
Show steps
Refresh your understanding of index structures and concepts to strengthen your foundation for this course.
Show steps
-
Review notes or online resources on index structures and their benefits.
-
Practice identifying different types of indexes and their usage.
15 other activities
Expand to see all activities and additional details
Show all 18 activities
Review Data Structures and Algorithms
Show steps
Review the basic data structures and algorithms before starting the course to strengthen your problem-solving abilities and understanding of database fundamentals.
Browse courses on
Data Structures
Show steps
-
Revisit the concepts of arrays, linked lists, stacks and queues.
-
Work through practice problems and examples to enhance your understanding of basic algorithms.
Follow Microsoft Docs Tutorials on SQL Server
Show steps
Gain a solid foundation in SQL Server by following official Microsoft tutorials, ensuring you have a comprehensive understanding of the platform's features and capabilities.
Browse courses on
SQL Server
Show steps
-
Visit the Microsoft Docs website dedicated to SQL Server.
-
Choose a topic or area of interest and follow the step-by-step tutorials.
-
Complete the exercises and examples provided in the tutorials to reinforce your understanding.
Visit SQL Server documentation
Show steps
Explore the official documentation to gain a better understanding of SQL Server indexes and their usage.
Show steps
-
Visit the SQL Server documentation for indexes.
-
Review the types of indexes available.
-
Understand the benefits and limitations of each index type.
-
Learn how to choose the right index for your queries.
Index Design Discussion Group
Show steps
Engage in peer discussions and knowledge sharing to deepen understanding of index design principles and best practices.
Browse courses on
Database Performance Tuning
Show steps
-
Join or create a discussion group focused on SQL Server indexing
-
Participate in discussions, share experiences, and ask questions
-
Collaborate on index design solutions and learn from others
Index Design Exercises
Show steps
Engage in guided exercises to improve understanding of index design principles and apply them to practical scenarios.
Browse courses on
Index Design
Show steps
-
Analyze tables and identify potential indexing opportunities
-
Design and implement indexes based on specific performance requirements
-
Monitor index usage and performance to refine index design
Follow SQL Server Tutorials
Show steps
Supplement your learning by following guided tutorials and demonstrations on SQL Server to gain hands-on experience and clarify concepts.
Browse courses on
SQL Server
Show steps
-
Search for comprehensive tutorials on SQL Server basics and advanced concepts.
-
Step through the tutorials, practicing the commands and techniques demonstrated.
Create and implement indexes on a sample database
Show steps
Apply your knowledge by creating and implementing indexes on a sample database to improve query performance.
Show steps
-
Design an indexing strategy for a sample database.
-
Create the necessary indexes on the database.
-
Measure the performance improvement after implementing the indexes.
Follow Tutorials on SQL Server Index Optimization
Show steps
Follow guided tutorials to enhance your knowledge on how to optimize SQL Server indexes for better performance.
Browse courses on
Database Performance Tuning
Show steps
-
Find reputable online tutorials or courses on SQL Server index optimization.
-
Go through the tutorials, taking notes and practicing the techniques.
-
Apply the learned techniques to optimize indexes in your own SQL Server databases.
Read 'Designing Data-Intensive Applications' by Martin Kleppmann
Show steps
Gain a deeper understanding of data-intensive application design by reading this comprehensive book, which covers concepts and techniques relevant to SQL Server.
View
Secret Colors
on Amazon
Show steps
-
Read the book thoroughly, focusing on chapters related to database design, indexing, and query optimization.
-
Take notes and highlight important concepts for future reference.
SQL Server Index Design Project
Show steps
Apply knowledge gained in the course to design and implement an indexing solution for a real-world database.
Browse courses on
Index Design
Show steps
-
Identify a database or application with performance issues
-
Analyze data and identify indexing opportunities
-
Design and implement indexes to optimize performance
-
Monitor and evaluate the effectiveness of the index design
Solve SQL Server Query Optimization Problems
Show steps
Enhance your ability to optimize SQL queries and improve database performance by practicing on real-world problems.
Browse courses on
SQL Server
Show steps
-
Find online platforms or resources that provide SQL Server query optimization problems.
-
Analyze the provided queries and identify potential performance bottlenecks.
-
Apply optimization techniques such as indexing, query rewriting, and parameterization.
-
Test the optimized queries and compare their performance with the original queries.
Practice Designing and Implementing Indexes
Show steps
Engage in practice exercises to solidify your ability to design and implement effective SQL Server indexes.
Browse courses on
Database Optimization
Show steps
-
Set up a practice database or use sample datasets.
-
Design and implement indexes based on real-world scenarios.
-
Test the performance of indexed queries and compare them to non-indexed ones.
-
Analyze the results and iterate on your index designs.
Advanced SQL Server Indexing Techniques
Show steps
Explore advanced indexing techniques to further enhance database performance and optimize query execution.
Show steps
-
Learn about clustered and non-clustered indexes
-
Understand index fragmentation and its impact on performance
-
Master techniques for index maintenance and optimization
Design and Implement an SQL Server Database
Show steps
Apply your knowledge by designing and implementing your own SQL Server database. This hands-on project will solidify your understanding and enhance your practical skills.
Browse courses on
SQL Server
Show steps
-
Define the purpose and scope of your database.
-
Design the database schema, including tables, columns, and relationships.
-
Implement the database using SQL Server Management Studio or other tools.
-
Populate the database with sample data and test its functionality.
Contribute to Open-Source SQL Server Projects
Show steps
Enhance your skills and contribute to the SQL Server community by working on open-source projects. This allows you to collaborate with others and gain valuable real-world experience.
Browse courses on
SQL Server
Show steps
-
Identify open-source SQL Server projects on platforms like GitHub.
-
Review the project documentation and identify areas where you can contribute.
-
Submit pull requests with your contributions, ensuring they meet the project's standards.
-
Engage with the community by providing support and feedback.
Course Material Review
Show steps
Organize notes, assignments, and reference materials to enhance knowledge retention.
Show steps
Show steps
Show steps
- Review lecture notes and slides
- Summarize key concepts and ideas
- Create a study guide or flashcards
SQL Server Indexing Core Concepts
Show steps
Review foundation of SQL Server indexing to fill in knowledge gaps and ensure course preparedness.
Show steps
Show steps
Show steps
- Review documentation on SQL Server Indexes
- Complete tutorials on basic index types
- Practice creating and using indexes in a test environment
Review Index Structures and Concepts
Show steps
Refresh your understanding of index structures and concepts to strengthen your foundation for this course.
Show steps
Show steps
Show steps
- Review notes or online resources on index structures and their benefits.
- Practice identifying different types of indexes and their usage.
15 other activities
Expand to see all activities and additional details
Show all 18 activities
Review Data Structures and Algorithms
Show steps
Review the basic data structures and algorithms before starting the course to strengthen your problem-solving abilities and understanding of database fundamentals.
Browse courses on
Data Structures
Show steps
Show steps
Show steps
- Revisit the concepts of arrays, linked lists, stacks and queues.
- Work through practice problems and examples to enhance your understanding of basic algorithms.
Follow Microsoft Docs Tutorials on SQL Server
Show steps
Gain a solid foundation in SQL Server by following official Microsoft tutorials, ensuring you have a comprehensive understanding of the platform's features and capabilities.
Browse courses on
SQL Server
Show steps
Show steps
Show steps
- Visit the Microsoft Docs website dedicated to SQL Server.
- Choose a topic or area of interest and follow the step-by-step tutorials.
- Complete the exercises and examples provided in the tutorials to reinforce your understanding.
Visit SQL Server documentation
Show steps
Explore the official documentation to gain a better understanding of SQL Server indexes and their usage.
Show steps
Show steps
Show steps
- Visit the SQL Server documentation for indexes.
- Review the types of indexes available.
- Understand the benefits and limitations of each index type.
- Learn how to choose the right index for your queries.
Index Design Discussion Group
Show steps
Engage in peer discussions and knowledge sharing to deepen understanding of index design principles and best practices.
Browse courses on
Database Performance Tuning
Show steps
Show steps
Show steps
- Join or create a discussion group focused on SQL Server indexing
- Participate in discussions, share experiences, and ask questions
- Collaborate on index design solutions and learn from others
Index Design Exercises
Show steps
Engage in guided exercises to improve understanding of index design principles and apply them to practical scenarios.
Browse courses on
Index Design
Show steps
Show steps
Show steps
- Analyze tables and identify potential indexing opportunities
- Design and implement indexes based on specific performance requirements
- Monitor index usage and performance to refine index design
Follow SQL Server Tutorials
Show steps
Supplement your learning by following guided tutorials and demonstrations on SQL Server to gain hands-on experience and clarify concepts.
Browse courses on
SQL Server
Show steps
Show steps
Show steps
- Search for comprehensive tutorials on SQL Server basics and advanced concepts.
- Step through the tutorials, practicing the commands and techniques demonstrated.
Create and implement indexes on a sample database
Show steps
Apply your knowledge by creating and implementing indexes on a sample database to improve query performance.
Show steps
Show steps
Show steps
- Design an indexing strategy for a sample database.
- Create the necessary indexes on the database.
- Measure the performance improvement after implementing the indexes.
Follow Tutorials on SQL Server Index Optimization
Show steps
Follow guided tutorials to enhance your knowledge on how to optimize SQL Server indexes for better performance.
Browse courses on
Database Performance Tuning
Show steps
Show steps
Show steps
- Find reputable online tutorials or courses on SQL Server index optimization.
- Go through the tutorials, taking notes and practicing the techniques.
- Apply the learned techniques to optimize indexes in your own SQL Server databases.
Read 'Designing Data-Intensive Applications' by Martin Kleppmann
Show steps
Gain a deeper understanding of data-intensive application design by reading this comprehensive book, which covers concepts and techniques relevant to SQL Server.
View
Secret Colors
on Amazon
Show steps
Show steps
Show steps
- Read the book thoroughly, focusing on chapters related to database design, indexing, and query optimization.
- Take notes and highlight important concepts for future reference.
SQL Server Index Design Project
Show steps
Apply knowledge gained in the course to design and implement an indexing solution for a real-world database.
Browse courses on
Index Design
Show steps
Show steps
Show steps
- Identify a database or application with performance issues
- Analyze data and identify indexing opportunities
- Design and implement indexes to optimize performance
- Monitor and evaluate the effectiveness of the index design
Solve SQL Server Query Optimization Problems
Show steps
Enhance your ability to optimize SQL queries and improve database performance by practicing on real-world problems.
Browse courses on
SQL Server
Show steps
Show steps
Show steps
- Find online platforms or resources that provide SQL Server query optimization problems.
- Analyze the provided queries and identify potential performance bottlenecks.
- Apply optimization techniques such as indexing, query rewriting, and parameterization.
- Test the optimized queries and compare their performance with the original queries.
Practice Designing and Implementing Indexes
Show steps
Engage in practice exercises to solidify your ability to design and implement effective SQL Server indexes.
Browse courses on
Database Optimization
Show steps
Show steps
Show steps
- Set up a practice database or use sample datasets.
- Design and implement indexes based on real-world scenarios.
- Test the performance of indexed queries and compare them to non-indexed ones.
- Analyze the results and iterate on your index designs.
Advanced SQL Server Indexing Techniques
Show steps
Explore advanced indexing techniques to further enhance database performance and optimize query execution.
Show steps
Show steps
Show steps
- Learn about clustered and non-clustered indexes
- Understand index fragmentation and its impact on performance
- Master techniques for index maintenance and optimization
Design and Implement an SQL Server Database
Show steps
Apply your knowledge by designing and implementing your own SQL Server database. This hands-on project will solidify your understanding and enhance your practical skills.
Browse courses on
SQL Server
Show steps
Show steps
Show steps
- Define the purpose and scope of your database.
- Design the database schema, including tables, columns, and relationships.
- Implement the database using SQL Server Management Studio or other tools.
- Populate the database with sample data and test its functionality.
Contribute to Open-Source SQL Server Projects
Show steps
Enhance your skills and contribute to the SQL Server community by working on open-source projects. This allows you to collaborate with others and gain valuable real-world experience.
Browse courses on
SQL Server
Show steps
Show steps
Show steps
- Identify open-source SQL Server projects on platforms like GitHub.
- Review the project documentation and identify areas where you can contribute.
- Submit pull requests with your contributions, ensuring they meet the project's standards.
- Engage with the community by providing support and feedback.
Career center
Learners who complete Designing and Implementing SQL Server Database Indexes will develop knowledge and skills
that may be useful to these careers:
Database Developer
Database Developer
A Database Developer designs, develops, and maintains databases. They work to ensure that databases are efficient, reliable, and secure. This course may be useful to a Database Developer because it teaches how to set up data in a way that will allow for faster and more efficient queries. This knowledge can help a Database Developer improve the performance of their databases and ensure that they are running smoothly.
Systems Analyst
Systems Analyst
A Systems Analyst designs, develops, and maintains computer systems. They work to ensure that systems are efficient, reliable, and secure. This course may be useful to a Systems Analyst because it teaches how to set up data in a way that will allow for faster and more efficient queries. This knowledge can help a Systems Analyst improve the performance of their systems and ensure that they are running smoothly.
Data Engineer
Data Engineer
A Data Engineer designs, builds, and maintains data pipelines. They work to ensure that data is clean, consistent, and accessible to the people who need it. This course may be useful to a Data Engineer because it teaches how to set up data in a way that will allow for faster and more efficient processing. This knowledge can help a Data Engineer improve the performance of their data pipelines and ensure that they are running smoothly.
Data Analyst
Data Analyst
A Data Analyst collects, analyzes, interprets, and presents data. They play an important role in helping businesses understand their data and make better decisions. Designing and Implementing SQL Server Database Indexes may be useful to a Data Analyst because it teaches how to organize data in a way that will allow for faster and more efficient analysis. This knowledge can help a Data Analyst improve the quality and speed of their work.
Information Architect
Information Architect
An Information Architect designs and develops the structure of information systems. They work to ensure that systems are efficient, effective, and user-friendly. This course may be useful to an Information Architect because it teaches how to set up data in a database in a way that will allow for faster and more efficient queries. This knowledge can help an Information Architect improve the performance of their systems and ensure that they are running smoothly.
Technical Architect
Technical Architect
A Technical Architect designs and develops the architecture of computer systems. They work to ensure that systems are efficient, reliable, and secure. This course Designing and Implementing SQL Server Database Indexes may be useful to a Technical Architect because it teaches how to set up data in a database in a way that will allow for faster and more efficient queries. This knowledge can help a Technical Architect improve the performance of their systems and ensure that they are running smoothly.
Software Engineer
Software Engineer
A Software Engineer designs, develops, and maintains software applications. They work to ensure that software is efficient, reliable, and secure. Designing and Implementing SQL Server Database Indexes may be useful to a Software Engineer because it teaches how to set up data in a way that will allow for faster and more efficient queries. This knowledge can help a Software Engineer improve the performance of their software applications and ensure that they are running smoothly.
Data Scientist
Data Scientist
A Data Scientist uses data to build models and make predictions. They work to help businesses understand their data and make better decisions. Designing and Implementing SQL Server Database Indexes may be useful to a Data Scientist because it teaches how to organize data in a way that will allow for faster and more efficient analysis. This knowledge can help a Data Scientist improve the quality and speed of their work.
Data Warehouse Architect
Data Warehouse Architect
A Data Warehouse Architect designs, develops, and maintains data warehouses. They work to ensure that data warehouses are efficient, reliable, and secure. Designing and Implementing SQL Server Database Indexes may be useful to a Data Warehouse Architect because it teaches how to set up data in a database in a way that will allow for faster and more efficient queries. This knowledge can help a Data Warehouse Architect improve the performance of their data warehouses and ensure that they are running smoothly.
Database Administrator
Database Administrator
A Database Administrator, also known as a DBA, is a database expert who works to maintain and optimize databases. Whether this is done through management, design, or implementation, a DBA keeps databases running smoothly. This course, Designing and Implementing SQL Server Database Indexes, may be useful to a DBA because it teaches how to set up data in a way that will allow for faster queries. This knowledge can help a DBA improve the performance of their databases and ensure that they are running efficiently.
Data Warehouse Engineer
Data Warehouse Engineer
A Data Warehouse Engineer designs, develops, and maintains data warehouses. They work to ensure that data warehouses are efficient, reliable, and secure. Designing and Implementing SQL Server Database Indexes may be useful to a Data Warehouse Engineer because it teaches how to set up data in a database in a way that will allow for faster and more efficient queries. This knowledge can help a Data Warehouse Engineer improve the performance of their data warehouses and ensure that they are running smoothly.
Business Analyst
Business Analyst
A Business Analyst gathers and analyzes business requirements. They work to help businesses understand their needs and develop solutions to meet those needs. Designing and Implementing SQL Server Database Indexes may be useful to a Business Analyst because it teaches how to set up data in a database in a way that will allow for faster and more efficient queries. This knowledge can help a Business Analyst improve the quality and speed of their work.
Database Security Specialist
Database Security Specialist
A Database Security Specialist protects databases from unauthorized access, use, disclosure, disruption, modification, or destruction. Designing and Implementing SQL Server Database Indexes may be useful to a Database Security Specialist because it teaches how to set up data in a database in a way that will allow for faster and more efficient queries. This knowledge can help a Database Security Specialist improve the security of their databases.
Data Governance Specialist
Data Governance Specialist
A Data Governance Specialist develops and implements data governance policies and procedures. They work to ensure that data is managed in a consistent and reliable manner. Designing and Implementing SQL Server Database Indexes may be useful to a Data Governance Specialist because it teaches how to set up data in a database in a way that will allow for faster and more efficient queries. This knowledge can help a Data Governance Specialist improve the quality and consistency of their data.
Project Manager
Project Manager
A Project Manager plans and executes projects. They work to ensure that projects are completed on time, within budget, and to the required quality. Designing and Implementing SQL Server Database Indexes may be useful to a Project Manager because it teaches how to set up data in a database in a way that will allow for faster and more efficient queries. This knowledge can help a Project Manager improve the efficiency of their projects and ensure that they are completed on time and within budget.
For more career information including salaries, visit:
OpenCourser.com/course/k9rkqz/designing
Reading list
We've selected 12 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
Designing and Implementing SQL Server Database Indexes.
Provides deep coverage of execution plans, a fundamental skill for SQL Server DBAs.
Save
Provides a practical guide to SQL tuning. It covers topics such as index design, query optimization, and hardware tuning. It valuable resource for anyone who wants to learn more about how to improve SQL Server performance.
Provides a comprehensive overview of MySQL, a popular open source database. It covers topics such as data modeling, query optimization, and performance tuning. It valuable resource for anyone who wants to learn more about how to use MySQL.
Save
Provides advanced techniques for identifying and resolving performance bottlenecks in SQL Server databases.
Save
Provides a comprehensive overview of MongoDB, a popular NoSQL database. It covers topics such as data modeling, query optimization, and performance tuning. It valuable resource for anyone who wants to learn more about how to use MongoDB.
Provides a comprehensive overview of Elasticsearch, a popular search engine and analytics platform. It covers topics such as data modeling, query optimization, and performance tuning. It valuable resource for anyone who wants to learn more about how to use Elasticsearch.
Provides a comprehensive overview of Cassandra, a popular distributed NoSQL database. It covers topics such as data modeling, query optimization, and performance tuning. It valuable resource for anyone who wants to learn more about how to use Cassandra.
Provides a comprehensive overview of HBase, a popular distributed NoSQL database. It covers topics such as data modeling, query optimization, and performance tuning. It valuable resource for anyone who wants to learn more about how to use HBase.
Provides a comprehensive overview of CouchDB, a popular NoSQL database. It covers topics such as data modeling, query optimization, and performance tuning. It valuable resource for anyone who wants to learn more about how to use CouchDB.
Save
Provides a comprehensive overview of Neo4j, a popular graph database. It covers topics such as data modeling, query optimization, and performance tuning. It valuable resource for anyone who wants to learn more about how to use Neo4j.
Provides a comprehensive overview of database systems, including indexing and query optimization.
Focuses on advanced performance tuning techniques for SQL Server, including index optimization.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/k9rkqz/designing
Share
Similar courses
Here are nine courses similar to
Designing and Implementing SQL Server Database Indexes.
What Every Developer Should Know About SQL Server Performance
OpenCourser.com/course/k3q8w4/what
What Every Developer Should Know About SQL Server...
Most relevant
Optimizing SQL Server Statistics and Indexes
OpenCourser.com/course/ngnwjv/optimizing
Optimizing SQL Server Statistics and Indexes
Most relevant
Managing SQL Server Database Maintenance
OpenCourser.com/course/b8mtra/managing
Managing SQL Server Database Maintenance
Most relevant
SQL Server Data Manipulation Essentials
OpenCourser.com/course/qqyvvp/sql
SQL Server Data Manipulation Essentials
Most relevant
Optimizing a Data Warehouse on the Microsoft SQL Server Platform
OpenCourser.com/course/ur4qhy/optimizing
Optimizing a Data Warehouse on the Microsoft SQL Server...
Most relevant
Database Architecture, Scale, and NoSQL with Elasticsearch
OpenCourser.com/course/1qh2q5/database
Database Architecture, Scale, and NoSQL with Elasticsearch
Most relevant
PostgreSQL: Index Tuning and Performance Optimization
OpenCourser.com/course/ja7czb/postgresql
PostgreSQL: Index Tuning and Performance Optimization
Most relevant
Advanced Query Optimization Techniques in SQL Server
OpenCourser.com/course/ycxpwt/advanced
Advanced Query Optimization Techniques in SQL Server
Most relevant
Solving Real World Problems with SQL Server 2016 Query Store
OpenCourser.com/course/5jqq0l/solving
Solving Real World Problems with SQL Server 2016 Query...
Most relevant
Time
131 hours
Level
Intermediate
Via
Pluralsight
Instructor
Gail Shaw
Language
English
This course belongs to a
collection
called
Developing SQL Server Databases. It's comprised of ten courses:
- Designing and Implementing SQL Server Tables and Views
- Designing and Implementing SQL Server Database Indexes (viewing)
- Programming SQL Server Database Stored Procedures
- Programming SQL Server Database Triggers and Functions
- Managing SQL Server Database Concurrency
- Using Memory-optimized Tables and Native Stored Procedures
- Optimizing SQL Server Statistics and Indexes
- Analyzing SQL Server Query Plans
- Managing SQL Server Database Performance
- Managing Azure SQL Server Database Performance
Good to know
Builds a strong foundation for beginners
Taught by Gail Shaw, who are recognized for their work in SQL Server
If you take this course, you'll gain knowledge to improve all aspects of database indexing
Examines SQL Server indexes, which is highly relevant to database performance
This course is strongly industry relevant because poorly indexed databases impact the speed and performance of databases
Teaches methods that are highly aligned with improving the speed and performance of SQL Server databases
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