Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-464): Introduction to Indexing

As a developer, you will be anxious to know how your query performs and how to optimize it further. SQL Server has the mechanism and tools to help you with this. In this course, you will be learn indexing concepts and how you can enhance the performance of the queries. This course will also cover fragmentation of indexes and how to rebuild them, as well as the differentiation between clustered and nonclustered indexes. Last but not least this course will touch on the INCLUDE clause and lookups.

Description

As a developer, you will be anxious to know how your query performs and how to optimize it further. SQL Server has the mechanism and tools to help you with this. In this "Introduction to Indexing" LearnSmart course you will be learning indexing concepts and how you can enhance the performance of the queries. This course will also cover fragmentation of indexes and how to rebuild them, as well as the differentiation between clustered and nonclustered indexes. Last but not least this course will touch on the INCLUDE clause and lookups. This course will be paired with several demos that will introduce you to the tools that will be covered in this course.

Topics Covered Include:
-Indexing in SQL Server
-Index Structures and Fragmentation
-Data Types and Indexes
-Index Statistics
-Clustered Index 6
-Non-Clustered Index

Full details

Curriculum

  • Course Orientation
    Course Orientation
    1:54
    Introduction to Indexing: Supplemental Materials
    Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for this ""SQL Server 2012 (70-465): Designing a Database Server Infrastructure"" Course.
  • Indexing in SQL Server
    Introduction
    0:56
    Indexing in SQL Server
    2:03
    Core Indexing Concepts
    1:46
    The Need for Indexes
    0:51
    Knowledge Check
    0:53
  • Index Structures and Fragmentation
    Index Structures
    2:40
    Index Fragmentation
    1:30
    SHOW ME Demonstration: Viewing Index Fragmentation
    5:03
    Knowledge Check
    0:37
  • Data Types and Indexes
    Data Types and Indexes: Numbers
    1:41
    Data Types and Indexes: Characters
    0:54
    Data Types
    0:37
    Data Types and Indexes: GUIDs, Bit Types, Computed Columns
    2:42
    Data Types and Indexes: Single Column and Composite Indexs
    1:42
    Knowledge Check
    0:50
  • Index Statistics
    Index Statistics
    0:54
    SHOW ME Demonstration: Viewing Index Statistics
    2:58
    Table Structures in SQL Server
    2:08
    Forwarding Pointers
    1:10
    Knowledge Check
    0:42
  • Clustered Index
    Clustered Index
    3:03
    Unique vs. Non-Unique Clustered Indexes
    1:52
    Working with Clustered Indexes
    4:38
    Incorporating Free Space in Indexes
    2:07
    Knowledge Check
    0:29
  • Non-Clustered Index
    Working with Non-Clustered Indexes
    1:41
    INCLUDE Clause, Lookups, Indexes on Views
    1:27
    SHOW ME Demonstration: Create Clustered/Non-clustered Indexes
    3:26
    SHOW ME Demonstration: Modify, Delete Clustered Indexes
    1:28
    Knowledge Check
    0:40
    Conclusion
    1:53

Skills

  • Database Management
  • Database Management System (DBMS)
  • SQL Server

Similar Courses

More Courses by this Instructor