Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    
Loading

Courses
ADA
Adobe
AJAX
Android
Apache
AutoCAD
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
Corel
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Legato
Lotus
Macintosh
Mainframe programming
Microsoft technologies
MS Access
MultiMedia and design
.NET
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Quality Center/Quick Test
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software Engineering
Software quality and testing
SQL Server
Sybase
Telecommunications
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Microsoft SQL 2008 R2: What's New
Entire course includes...
  • 500 pages of courseware
  • 16 hours of hands-on content
  • Step-by-step hands-on labs
  • Sample Files
  • PowerPoint slides for instructors
 
Course Outline(Outlines are subject to change.)

Microsoft SQL Server 2008 R2: What's New

Pages of Courseware Hours of hands-on Content Days of hands-on Content
500 pages 16 hours 2 days

SQL Server 2008 brought many changes to the SQL platform and the R2 release added many more. This course will help to bring you up to speed on these changes and how they will affect how you work with SQL Server. You will see what is new with installation and security, see its support for managing data-tier applications and a multi-server environment, and learn about PowerPivot, which Microsoft calls “managed self-service business intelligence” that gets BI data in the hands of users who need it. Next you will learn about the new StreamInsight feature that lets you query high-volume data streams for useful nuggets of information and emerging trends. Reporting Services probably received by far the most enhancements in R2 and you will learn about the new expression language and data visualization features. Report Manager and Viewer received major overhauls, and you’ll see how to put them to good use, as well as exploring how to put Report Builder to use creating great reports.
Introduction to SQL Server 2008 R2

  • What is the R2 Release?
  • Installation Enhancements
  • Security Enhancements
  • Feature Only a DBZ Could Love

Multi-Server and Application Management

  • Multi-Server Management
  • Data-Tier Applications (DAC)
  • Working with DAC's

Business Intelligence for the Power User

  • PowerPoint for Excel and SharePoint
  • Working with the PowerPoint Excel Add-In

Querying Real Time Data Streams

  • Introduction to StreamInsight
  • Working with StreamInsight Data
  • Querying a Data Stream

Reporting Services in R2

  • Reporting Services Enhancements
  • Lookup Functions to Join Datasets
  • Aggregates of Aggregates
  • Control Output Formatting with RenderFormat
  • Report as a Data Source

New Data Visualization Features in R2

  • Shared Datasets
  • Data Bars and Sparklines
  • Indicators
  • Map-Based Data

Report Manager and Viewer in R2

  • Making Reporting Services More Widely Usable
  • Report Manager
  • Report Viewer

Report Builder 3.0

  • Creating and Using Report Models
  • Creating Reports
  • Saving and Deploying Reports

back to top


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy