SQL Server 2008 Tutorial

• Interview Questions
• Practice Test
• Pragnyameter Exam
• All Tutorials
• Job Search

What is SQL Server 2008 tutorial?

SQL Server 2008 is a relational database management system developed by Microsoft to store, manipulate and retrieve the data in databases. This tutorial provides an in-depth approach on SQL Server 2008.This course also covers various features like SQL Server's database engine, including SQL Server Reporting Services and Integration Services.

Audience

This tutorial is mainly useful for those readers who wish to seek fundamentals of SQL Server.

Prerequisites

To learn SQL server 2008 tutorial one must be familiar with database concepts. It is also an added advantage if they have installed SQL Server on your computer to execute various examples.

SQL Server 2008 Tutorial: List of Topics

• Sql Server 2008 Overview
  • The Vision Of Sql Server 2008
  • Sql Server 2008 Editions
  • A Word On Server Consolidation
  • Summary Of Sql Server 2008
• Sql Server Installation And Configuration
  • Sql Server Requirements
  • Upgrading To Sql Server 2008
• Policy Management
  • Needs Addressed By Policy Management
  • Policy Management Components
  • Sample Policies
  • Policy Management Administration
  • Pm Security
• High Availability
  • High Availability Defined
  • Database Mirroring
  • Database Snapshots And Mirroring
  • Windows Clustering In Sql Server
  • Sql Server Replication
  • Reducing Planned Downtime
• Performance
  • Managing And Monitoring Resources
  • Optimizing Storage
  • Improving Query Performance
• Security
  • Disabled Database Engine Features
  • Principals And Securables
  • Permissions
  • Code Access Security
  • Auditing In Sql Server 2008
• Sql Server Encryption
  • Encryption Keys
  • Transparent Data Encryption
• Automation And Monitoring
  • Sql Server Agent
  • Maintenance Plans
  • Sqlcmd
  • Powershell For Sql Server
  • Database Mail
  • Sql Profiler
  • Extended Events
• Service Broker
  • What Is Service Broker?
  • Creating Service Broker Applications
  • Service Broker Routing And Security
  • Message Priorities
  • Troubleshooting Service Broker Using Ssbdiagnose
• Integrated Full-text Search
  • Creating Full-text Catalogs And Indexes
  • Querying With Ifts
  • Managing Thesaurus Files
  • Using Stoplists
  • Searching Documents
  • Managing Ifts
• New Datatypes In Sql Server 2008
  • Spatial Support In Sql Server 2008
  • How Time Has Changed In Sql Server
  • A New Hierarchical Datatype
  • Filestream Support
• T-sql Enhancements For Developers
  • Notable Dml Features
  • General Development
• T-sql Enhancements For Dbas
  • Locking Enhancements
  • Metadata Views
  • Notable Sql Server Performance Monitor Counters
  • Ddl Triggers
  • Indexing And Performance Enhancements
  • Snapshot Isolation Level
  • Data-integrity Enhancements
• .net Integration
  • Introduction To Sql Server .net Integration
  • Sql Server .net Programming Model
  • Programming A Clr Stored Procedure
  • Deploying Clr Routines
• Programming Assemblies
  • Clr User-defined Types
  • Clr User-defined Functions
  • Clr User-defined Aggregates
  • Clr User-defined Triggers
  • Managing Assemblies
• Sql Server And Xml
  • What Is Xml?
  • What Are Xpath And The Xmldom?
  • Getting Xml Into The Database
  • Getting Xml Out Of The Database
  • Working With Xml Data
  • Programming Sqlxml From .net And Com
• Sql Server Xml And Xquery Support
  • Using The Xml Datatype
  • Inserting Data Into Xml Columns
  • Querying Xml Data
  • Modifying Xml Data
  • Indexing Xml For Performance
  • Full-text Search And The Xml Datatype
  • Catalog Views And Xml
  • Applications And Xml
  • Xml Web Services Support
• Linq To Sql
  • Object/relational Mapping
  • Entity-generation Tools
  • Running Linq Queries
• Reporting Services
  • Reporting Services Components
  • Building A Basic Report
  • Report Design Advanced Features
  • Visual Studio Integration And Reportviewer Controls
  • Sharepoint Integration
  • End-user Ad Hoc Query And Reporting
  • Report Rendering
  • Data Regions
• Analysis Services
  • New Analysis Services Features In Sql Server 2008
  • Analysis Services Fundamentals
  • Olap, Oltp, And Data Warehouses
  • Analysis Services Projects
  • Working With Cubes
  • Using Analysis Services Scripting Language
• Integration Services
  • An Overview Of Ssis Features
  • The Ssis Integrated Development Environment
  • Ssis Fundamentals
  • Control Flow And Data Flow Designer Tasks
  • Change Data Capture
  • Logging
  • Dynamic Package Configuration
  • Ssis Variables
  • Precedence Constraints
  • Enterprise Integration Scenarios
  • Transactions Of Sql Server 2008
  • Ssis Debugging
  • Ssis Package Handling