Display & Accessibility Options

Skip to navigation

Skip to main content

Contact Us

Accessibility Statement

Text Only Version

Site map

A- A A+
You are here: Home > IT Training > SQL Server Upgrade Database Development

SQL Server Upgrade Database Development

Microsoft SQL Server

Course Aims: 

This course consists of three days of training that focuses on the new features available in SQL Server. You will learn how to install SQL Server; use the SQL Server client tools to administer databases and create database applications; use SQL Server Integration Services (SSIS) to import, export, and transform data; use SQL Server Reporting Services (SSRS) to create dynamic database reports; perform intelligent and complex queries using SQL Server Full-Text Search (SSFTS). You will also learn how to create international database applications; integrate XML with a database; monitor and improve database and server performance; and optimize data availability for an environment.

 

This course also includes an introduction to using SQL Server Analysis Services (SSAS) to create and manage data warehouse and implement data mining and discusses in detail the new security concepts available in SQL Server. A multitude of new programmability features are covered including integration of the .NET Common Language Runtime (CLR).

Versions:

Microsoft SQL Server 2005 or 2008

Profile Outline:

An Overview of SQL Server

  • New Features
  • Database Roles
  • Client Tools

Installing SQL Server

  • Preparing For Installation
  • Setup User Interface
  • Installing Express Edition
  • Configuring an New Instance

SQL Server Database Engine

  • Managing Services
  • Managing Servers
  • Database Projects
  • Database Objects

SQL Server Full-Text Search (SSFTS)

  • Overview
  • Architecture
  • Writing Queries
  • Administering

SQL Server Analysis Services (SSAS)

  • OLAP vs. OLTP
  • Data Warehousing
  • Data Mining
  • Architecture
  • Analysis Services Projects
  • Analysis Services Scripting Language (ASSL)
  • XML for Analysis (XMLA)
  • Predictive Mining Model Language (PMML)
  • Data Mining Extensions (DMX)
  • Multidimensional Expression Language (MDX)

SQL Server Integration Services (SSIS)

  • What Happened To DTS?
  • What is ETL?
  • Integration Services Projects
  • SSIS Objects
  • Expressions

Working with XML

  • Data Type
  • Indexes
  • Schema Collections
  • For XML
  • OpenXML
  • Native XML Web Services

Programming SQL Server

  • Transact-SQL
  • CLR Integration Overview
  • Stored Procedures
  • User-Defined Functions
  • User-Defined Types
  • DML Triggers
  • DDL Triggers
  • SQL Management Objects (SMO)
  • Integration Services
  • Replication Management Objects (RMO)
  • Reports

SQL Server Reporting Services (SSRS)

  • Overview
  • Creating, Managing, and Delivering
  • Administering

DO NOT DELETE THIS TEXT
Profile Details:
Course Dates:

Please call for dates

Training Options
People who attended this course, also booked:
Information & print: