 |
Please contact us
for GSA pricing.
Contract #
GS-35F-0307T
Recent Training Venues Accelebrate has recently trained for clients in the following cities:
- Huntsville, Alabama
- Montgomery / Birmingham, Alabama
- Anchorage, Alaska
- Edmonton & Calgary, Alberta
- Phoenix, Arizona
- Tucson, Arizona
- Fayetteville / Little Rock, Arkansas
- Amsterdam, The Netherlands / Brussels, Belgium
- Vancouver, British Columbia
- Oakland / San Jose / San Francisco, California
- Sacramento, California
- San Diego, California
- Orange County / Los Angeles, California
- Boulder / Colorado Springs / Denver, Colorado
- Washington, DC
- Wilmington, Delaware
- Manchester / London, England
- Orlando, Florida
- Fort Lauderdale / Miami, Florida
- Jacksonville, Florida
- Saint Petersburg / Tampa, Florida
- Alpharetta & Atlanta, Georgia
- Augusta & Savannah, Georgia
- Boise, Idaho
- Chicago, Illinois
- Indianapolis, Indiana
- Cedar Rapids / Des Moines, Iowa
- Dublin, Ireland
- Wichita, Kansas
- Lexington / Louisville, Kentucky
- Baton Rouge/New Orleans, Louisiana
- Portland, Maine
- Hagerstown & Frederick, Maryland
- Annapolis / Baltimore, Maryland
- Boston / Cambridge, Massachusetts
- Hartford, Connecticut / Springfield, Massachusetts
- Ann Arbor / Detroit, Michigan
- Grand Rapids, Michigan
- Saint Paul / Minneapolis, Minnesota
- Jackson, Mississippi
- St. Louis, Missouri
- Kansas City, Missouri
- Lincoln / Omaha, Nebraska
- Reno and Las Vegas, Nevada
- Fredericton / Moncton / Saint John, New Brunswick
- Albuquerque, New Mexico
- Princeton, New Jersey & Philadelphia, Pennsylvania
- Albany, New York
- Buffalo, New York
- White Plains / New York City, New York
- Charlotte, North Carolina
- Durham / Raleigh, North Carolina
- Canton / Akron, Ohio
- Cincinnati, Ohio
- Cleveland & Columbus, Ohio
- Dayton, Ohio
- Tulsa / Oklahoma City, Oklahoma
- Toronto, Ontario
- Portland, Oregon
- Pittsburgh, Pennsylvania
- San Juan, Puerto Rico
- Providence, Rhode Island
- Saskatoon / Regina, Saskatchewan
- Edinburgh / Glasgow, Scotland
- Columbia & Charleston, South Carolina
- Spartanburg & Greenville, South Carolina
- Knoxville, Tennessee
- Memphis / Nashville, Tennessee
- Houston, Texas
- El Paso, Texas
- San Antonio / Austin, Texas
- Dallas, Texas
- Salt Lake City, Utah
- Fairfax / Dulles / McLean / Herndon / Reston, Virginia
- Richmond / Alexandria / Arlington, Virginia
- Virginia Beach / Norfolk, Virginia
- Tacoma / Seattle, Washington
- Charleston, West Virginia
- Madison / Milwaukee, Wisconsin
|
|
|
SQL Server 2008 R2 Training: New Features for SQL Server 2008 R2 Developers
|
Course Number: SQL-202
Duration: 2 days
view class outline
SQL Server 2008 R2 Training Overview
Accelebrate's SQL Server 2008 R2 Training: New Features for SQL Server 2008 R2 Developers training course teaches experienced SQL Server 2008 developers the new features in SQL Server 2008 R2.
Location and Pricing
Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.
In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=category&page=mssql.
SQL Server 2008 R2 Training Prerequisites
All attendees should have prior development experience with the original release of SQL Server 2008.
Hands-on/Lecture Ratio
This class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 10 minutes.
SQL Server 2008 R2 Training Materials
All students will receive comprehensive courseware plus Sams Publishing's Microsoft SQL Server 2008 R2 Unleashed.
Software Needed on Each Student PC
This SQL Server 2008 R2 Training class requires:
Important Note: If you have purchased this class, please contact us for detailed setup instructions.
SQL Server 2008 R2 Training Objectives
All attendees will learn to:
- Understand the changes brought about with the release of SQL Server 2008 R2 and how these changes will affect the way you work with SQL Server
- Install and secure SQL Server 2008 R2
- Manage data-tier applications and a multi-server environment
- Work with PowerPivot which Microsoft calls "managed self-service business intelligence"
- Utilize StreamInsight, a new R2 feature, to query high volume data streams
- Work with the R2 Reporting Services enhancements such as the new expression language and data visualization features
- Utilize the new R2 features in Report Manager and Viewer
- Create reports using Report Builder 3.0
|
SQL Server 2008 R2 Training Outline
Important Note: We would be delighted to add or remove units from this course to meet your specific needs.
- 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
- PowerPivot for Excel and SharePoint
- Working with the PowerPivot 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
- Conclusion
|
| |
Java® and all Java-based marks are registered trademarks of the Oracle Corporation in the U.S. and other countries.
|
|
Accelebrate®
Focuses on You! |
|
Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.
Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.
For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.
|
|
|
|
