Understanding SQL Server Indexes, Views, Stored Procedures and other Objects

Register Login

Wednesday, June 19, 2013

MICROSOFT SQL SERVER COMMUNITY WORLDWIDE

Videos SQL Server Objects

Understanding SQL Server 2008 Objects

In this module, you will learn the following:

Tables are the main objects that store data
Indexes, views, stored programs and other objects are the support structures
Various table types compared based on data organization
Various index types compared
Native and non-native data type support
Block-level storage architecture

SQL Server Educational Videos

1 Databases and Instances
1 Database Architecture
1  Advanced Architecture
1  SQL Server Objects
1  Managing SQL Server Data
1 Database Security
1 Basic DBA Duties
1 Concurrency Control
1 Managing SQL Objects
1 Securing and Auditing
1 Data Transfer Mechanism
1 Backups and Restores
1 Performance Tuning
1 Scalability & High Availability
1 Monitoring SQL Server

Working with Indexes in SQL Server 2008

In this demonstration you will see how to:

Create a query to view allocation units
Determine why multiple results for a single index might be provided

Working with Tables and Filegroups

In this demonstration you will see how to:

Create a table taking advantage of filegroups for different types data structures
Review the results using SSMS

Understanding SQL Server 2008 Indexes, Views, Stored Procedures and other Objects

In this tutorial you will learn about: tables are the main objects that store data; indexes, views, stored programs and other objects are the support structure; various table types compared based on data organization; various index types compared; native and non-native data type support; and block-level storage architecture.

Working wtih Geometrical Data in SQL Server

In this demonstration you will see how to:

Define geometric shapes
Define an organizational structure for a company

Privacy Statement

Terms Of Use