Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-464): Advanced Indexing

When you execute a query in SQL Server, you expect SQL Server to return the results that match your criteria in the shortest possible time. Indexes can be used to point to the location of the required data and minimize the need they to scan through the entire set of records. SQL Server provides various types of indexes to speed up the queries. This course will be covering the remaining information on indexes at a higher level.

Description

When you execute a query in SQL Server, you expect SQL Server to return the results that match your criteria in the shortest possible time. Indexes can be used to point to the location of the required data and minimize the need they to scan through the entire set of records. SQL Server provides various types of indexes to speed up the queries. This "Advanced Indexing" LearnSmart course will be covering the remaining information on indexes at a higher level.


Topics Covered Include:
-Indexed Views
-Filtered and Full-Text Indexes
-Columnstore Indexes

Full details

Curriculum

  • Course Orientation
    Course Orientation
    1:54
    Advanced 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-464): Advanced Indexing"" Course."
    Course Introduction
    1:29
  • Indexed Views
    Indexing in SQL Server
    2:21
    Indexed Views
    1:20
    SHOW ME Demonstration: Create a Indexed View
    2:12
    Knowledge Check
    0:33
  • Filtered and Full-Text Indexes
    Filtered Indexes
    3:33
    SHOW ME Demonstration: Create a Filtered Index
    1:57
    Creating Full-Text Indexes
    1:31
    Full-Text Indexes
    1:57
    Knowledge Check
    0:32
  • Columnstore Indexes
    What are Columnstore Indexes?
    1:10
    Columnstore Index Scenarios
    2:51
    Limitations for Columnstore Indexes
    1:37
    Clustered Columnstore Indexes
    2:03
    Nonclustered Columnstore Indexes
    3:41
    SHOW ME Demonstration: Create a Columnstore Index
    4:09
    Knowledge Check
    0:42
    Conclusion
    0:51

Skills

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

Similar Courses

More Courses by this Instructor