Microsoft SQL:05 - Indexes and Views

"This wonderful online course is all about the Indexes and Views concepts in SQL. You will learn in detail concepts like Partitioned indexes, XML index and index statistics etc. This course also talks about Practical examples of Indexes and Views in the software. "

94

 2h 49m | 18 Videos | 89226 Views |   Intermediate

This training course on Indexes and Views will introduces you to database concepts of maintaining views, managing views etc. The Microsoft SQL Server Training course provides a brief overview of all major components of SQL Server product suite, but focuses on relational DBMS.

What is Microsoft SQL?

Each modern business needs to have a way of collecting and analyzing large amounts of data. There are many Relational Database Management Systems (RDBMS) you could choose from, but Microsoft’s SQL Server is the most popular one used by top enterprises as well as small to medium-sized businesses.

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users. Its primary query languages are T-SQL and ANSI SQL.

Throughout this course you will learn the following concepts:
Maintaining Indexes
Online Index Operations
Source an d Preexisting Indexes
Target
Temporary Mapping Index
Online Index Activities
Degree of Parallelism
Locking Options
Lock Escalation
Indexes with included columns
Partitioned Indexes
Performance of partitioned indexes
XML Indexes
Modifying an XML index
Removing and XML index
Disabling an index
Dropping and index
Index Statistics

Implementing Views
Partitioned Views
Distributed partitioned view
Updatable partitioned view
insert statement for the partitioned view
update statement for the partitioned view
creating a view using built in functions
Guidelines to create a view
Viewing defining information
sys sql_modules
object_definition

Additional Examples
If Else and Case Statement
Joins
Cursors
SubQueries

Managing Views
Schemabinding Option
Indexed Views
Disabling indexes on views
Query Optimizer
Using hints with Indexed Views
Modifying Views
INSERT
UPDATE
Examples

What are the requirements?

– SQL Server
– Passion to learn
– Basic knowledge of T-SQL Is helpful, but not required

What am I going to get from this course?

– Over 18 lectures and 2.5 hours of content!
– Understand all about Schemabinding, indexed, Query optimizer and using hints with indexed views
– Learn about Modifying Views, Options like Insert, Update along with Examples.

What is the target audience?

– IT Professionals who wish to gain Microsoft Certification.
– New database administrators
– Anyone who is trying to learn about Microsoft’s flagship database system.

Back to top ▴