SQL Server

Sharepoint

Learn

C, C++, .NET, Linq, WCF, AJAX, Sharepoint, Sql Server, MOSS 2007 from the industry expert.

Visit: http://softwaretraining.webs.com

Microsoft SQL Server 2008 is a complete business intelligence (BI) platform that provides the features, tools, and functionality to build both classic and innovative kinds of analytical applications.

Microsoft SQL Server 2008 Business Intelligence components supports the development and use of business intelligence in enterprises of all sizes. It can be used by employees and external parties, not just management and analysts. To this end, SQL Server 2008 is complete, integrated, easy to use, publishes data as web services, delivers excellent performance on commodity hardware and contains many new features that can be used to develop innovative analytical applications.

Course Outline

This course has a particular emphasis on real world applications and skills.
The major topics covered are:

SQL Server Management Studio

SQL Server Business Intelligence Development Studio

Other BI tools such as DTS, Analysis Services OLAP, Analysis Services Data Mining and Reporting Services

SQL Server 2008 relational database.

Course Objectives

On completion of this course, students should have the skills to:

Use the Business Intelligence Development Studio to develop BI database objects

Use SQL Server Management Studio to operate and maintain BI database objects

Use Business Intelligence Development Studio for designing and debugging BI applications

Understand that SQL Server 2008 provides many options to deviate from generic database design, by eliminating or virtualizing different components

This is a practical course for the ICT Industry utilizing the latest SQL Server 2008 (Katmai) developed by Microsoft. SQL Server 2008 provides much anticipated improvements to the management studio with Intellisense support, as well as new geospatial data types and a wealth of programming enhancements. This course provides attendees with the knowledge necessary to take advantage of new features provided by SQL Server 2008. It provides a comprehensive overview of technologies, security and design best practices with particular emphasis on hands-on skills.

Course Outline

This course has a particular emphasis on real world applications and skills.
The major topics covered are:

SQL Server 2008 Architecture and Components

Programming SQL Server 2008 with .NET

Enhancements to Transact-SQL

The XML Data Type and XQuery

Security Improvements

ADO.NET 2.0

SQL Server Service Broker

Developing client applications

Security features

Geospatial data

Course Objectives

On completion of this course, students should have the skills to:

Decide whether to migrate to SQL Server 2008

Develop and write code for SQL Server 2008

Use SQL Server 2008 reporting services

Design a Service Oriented Architecture (SOA)

Design distributed applications using the Distributed Application Designer

Courses designed to provide the tools necessary to begin to SQL Server2005developer and report technologies that are available and in wide-stream use today.

Course Outline
Introducing SQL Server 2005

Major features

Editions

Installing SQL Server

Building a Database

Introducing SQL Server Management Studio

Databases

Tables

Indexes

Relations

Administrative Tools

SQL Server Management Studio

Registered Servers

Object Explorer

Review Database Objects

Modify Database Properties

The Maintenance Plans

Query Editor

SQL Agent Jobs

Dynamic Help

Programming with TSQL �the Basics

Using Variables

Control of Flow Statements

Create Views, Stored Procedures, User Defined Functions

Creating Views

Updating Through Views

Indexed Views

Creating Procedures

Passing Parameters

Scalar, Inline Table and Multi-Statement

Data manipulation in UDFs

Profiling UDFs

Create Triggers

Trigger Syntax

Trigger Events

Enabling/Disabling Triggers

Advance Transact �SQL

Transactions

Distributed Transactions

Ranking Functions

Cursors

Structured Error Handling

Using SQL Server 2005 Integration Services (SSIS)

Work Flow and Data Flow

Package Design

Deployment

Using SQL 2005 Reporting Services (SSRS)

Report Manager

Report Server

Creating Reports

Deploying Reports

Viewing Reports

Using SQL Server 2005 Analysis Services (SSIS)

1. Data Sources and views

2. Creating cubes

3. Refining Dimensions and Measures

Pages:- 1 2 3 4 5 6 7 8
[ Online / Live ] [ Corporate Training ] [ Locations ] [ Schools ] [ Job Seekers ]

Dear Visitor: You are strongly recommended to bookmark this page and come back later, since new course may be available anytime. Click to Proceed>>