Netbackup Course

by Vibrant Technologies & Computers

Module

Title

Contents

Module 1:

INTRODUCTION TO SQL SERVER AND ITS TOOLSET

Introduction to SQL Server Platform
Working with SQL Server Tools
Configuring SQL Server Services

Module 2:

WORKING WITH DATA TYPES

Using Data Types
Working with Character Data
Converting Data Types
Working with Specialized Data Types

Module 3:

DESIGNING AND IMPLEMENTING TABLES

Designing Tables
Working with Schemas
Creating and Altering Tables

Module 4:

DESIGNING AND IMPLEMENTING VIEWS

Introduction to Views
Creating and Managing Views
Performance Considerations for Views

Module 5:

PLANNING FOR SQL SERVER INDEXING

Core Indexing Concepts
Data Types and Indexes
Single Column and Composite Indexes

Module 6:

IMPLEMENTING TABLE STRUCTURES IN SQL SERVER

SQL Server Table Structures
Working with Clustered Indexes
Designing Effective Clustered Indexes

Module 7:

READING SQL SERVER EXECUTION PLANS

Execution Plan Core Concepts
Common Execution Plan Elements
Working with Execution Plans

Module 8:

Improving Performance Through Nonclustered Indexes

Designing Effective Nonclustered Indexes
Implementing Nonclustered Indexes
Using the Database Engine Tuning Advisor

Module 9:

DESIGNING AND IMPLEMENTING STORED PROCEDURES

Introduction to Stored Procedures
Working With Stored Procedures
Implementing Parameterized Stored Procedures
Controlling Execution Context

Module 10:

MERGING DATA AND PASSING TABLES

Using the MERGE Statement
Implementing Table Types
Using Table Types as Parameters

Module 11:

CREATING HIGHLY CONCURRENT SQL SERVER APPLICATIONS

Introduction to Transactions
Introduction to Locks
Management of Locking
Transaction Isolation Levels

Module 12:

HANDLING ERRORS IN T-SQL CODE

Designing T-SQL Error Handling
Implementing T-SQL Error Handling
Implementing Structured Exception Handling

Module 13:

DESIGNING AND IMPLEMENTING USER-DEFINED FUNCTIONS

Designing and Implementing Scalar Functions
Designing and Implementing Table-valued Functions
Implementation Considerations for Functions
Alternatives To Functions

Module 14:

ENSURING DATA INTEGRITY THROUGH CONSTRAINTS

Enforcing Data Integrity
Implementing Domain Integrity
Implementing Entity and Referential Integrity

Module 15:

RESPONDING TO DATA MANIPULATION VIA TRIGGERS

Designing DML Triggers
Implementing DML Triggers
Advanced Trigger Concepts

Module 16:

IMPLEMENTING MANAGED CODE IN SQL SERVER

Introduction to SQL CLR Integration
Importing and Configuring Assemblies
Implementing SQL CLR Integration

Module 17:

STORING XML DATA IN SQL SERVER

Introduction to XML and XML Schemas
Storing XML Data and Schemas in SQL Server
Implementing the XML Data Type

Module 18:

QUERYING XML DATA IN SQL SERVER

Using the T-SQL FOR XML Statement
Getting Started with XQuery
Shredding XML

Module 19:

WORKING WITH SQL SERVER SPATIAL DATA

Introduction to Spatial Data
Working with SQL Server Spatial Data Types
Using Spatial Data in Applications

Module 20:

WORKING WITH FULL-TEXT INDEXES AND QUERIES

Introduction to Full-Text Indexing
Implementing Full-Text Indexes in SQL Server
Working with Full-Text Queries