SQL Server Server-Side Programming with .NET and XML
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You Will Learn How To
Develop server-side database programs for SQL Server databases
Retrieve XML data with XQuery
Build scalable message-based applications with Service Broker
Access data using LINQ
Create functions and stored procedures in .NET CLR
Persist objects in the database with ADO.NET Entity Framework
Course Benefits
SQL Server 2005 and 2008 offer development features that fully support the requirements of small- and large-scale organizations. ...
Full archival course description>>
|
SQL Server Analysis Services
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You Will Learn How To
Leverage SQL Server Analysis Services to produce Business Intelligence solutions
Create and deploy multidimensional data cubes
Extend hierarchies and exploit advanced dimension relationships
Build custom solutions with MDX
Implement Key Performance Indicators (KPIs) to monitor business objectives
Make smarter business decisions with data mining techniques
Course Benefits
With the current explosion of data in today’s enterprise ...
Full archival course description>>
|
SQL Server Integration Services
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You Will Learn How To
Migrate and transform data using SQL Server Integration Services (SSIS)
Upgrade DTS packages and perform imports and exports
Assemble tasks to perform complex data migrations
Enhance package functionality with scripting
Extract, Transform and Load (ETL) data
Integrate Business Intelligence components
Course Benefits
In order to improve business intelligence capabilities, organizations must effectively and securely manage data migrat...
Full archival course description>>
|
SQL Server 2008 Reporting Services
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You Will Learn How To
Leverage SQL Server 2008 Reporting Services to extract business intelligence from your data
Design reports and display your data graphically with enhanced visualization features
Integrate parameters, filters and interactive components into report design
Deploy and deliver relevant reports across the entire enterprise through Report Server and SharePoint
Safeguard reports with Windows Authentication
Easily create reports on demand with Model Design...
Full archival course description>>
|
High-Performance SQL Server Databases
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You Will Learn How To
Design and implement high-performance databases for SQL Server
Create indexes that optimize different types of queries
Design transactions that maximize concurrency and minimize contention
Interpret the data access plans produced by the query optimizer
Minimize I/O by designing efficient physical data structures
Analyze and cure performance problems using SQL Server’s tools
Course Benefits
High-availability database systems off...
Full archival course description>>
|
