design

  		Find IT training and SDLC training by State
 
click the map, enter a zip,
or course keyword to find
our current public sessions
    About ASPE Technology  |   Get Credit  |   Contact Us  |   Testimonials  |   Client List

For real-time information or assistance with classes,
call us toll-free at 877-800-5221 or email us at customerservice@aspetech.com

For a limited time, all students will receive a free iPod Nano! ASPE Technology has been growing by leaps and bounds. We want to thank our hands-on training students by giving them this free gift when they register for one of our IT training classes at the regular individual price.
Course HomeCourse DatesCourse DetailsCourse OutlineCourse FacultyCourse pricing
 

COURSE 9050 | 5-DAY SESSION
Extreme Microsoft SQL Server 2005
Build on your SQL Server knowledge base with this challenging, lab-driven course.

This powerful hands-on course will take you through the basics and into the advanced topics of SQL Server 2005. Go from renaming a database to deploying SQL Server Integration Service package (SSIS) in just five days. Whether you’re migrating from SQL Server 2000 or looking to extend your abilities in SQL Server 2005, this class will help you firmly define and reach your goals. You’ll cover all the newest features of SQL Server 2005 — such as database mirroring, online restores, SSIS, and Reporting Services, Native data encryption, and many more — in this aggressive hands-on course.

You won’t find training anywhere on the market that has more hands-on, “real-world” labs. If you need to get up to speed fast on SQL Server 2005, you can’t afford to miss this class.


Learn how to:

  • Properly secure a SQL 2005 Server.
  • Manipulate data using constraints and triggers.
  • Tune the performance of your SQL 2005 Server.
  • Learn what database locking and blocking are and how they affect your database server.
  • Understand what an index is and how to implement them accordingly to increase database performance.
  • Use the SQL 2005 Server Database Tuning Advisor (DTA).
  • Implement a SQL clustering solution.
  • Set up a mirroring solution.
  • Set up and take advantage of SQL 2005 Server Reporting Services
  • Design a security platform for Reporting Services.
  • What’s new in SQL 2005 Server Integration Services (SSIS).
  • How to handle SSIS errors.
  • Optimize, scale and deploy SSIS packages using Business
  • Intelligence Development Studio (BIDS).

The Good, the Bad, and the Ugly

As an independent source of IT Training, ASPE Technology has the freedom and expertise to provide you with all the ins and outs of your IT hardware and software — including the issues, concerns, and sometimes even problems that manufacturers may not want customers to know about. Other training companies offer a “certified” curriculum that limits what instructors can discuss, provides a strict outline, and uses regimented content (sometimes for the sole purpose of passing an exam). These things can be important, but ASPE Technology offers more. We’re not cheerleaders for large software or hardware companies — instead, we are a savvy, unbiased training company that empowers you to use your IT products effectively and efficiently, ensuring that your IT solutions are successful


ASPE logo

Courses >> Home Page >> About ASPE >> Site Map >> Curriculum Areas >> Free Technical Offers >> Free Web Seminars >> Custom Training Development >> Business Analyst Training >> Requirements Training >> Project Management Training >> Agile Training>> Software Testing Training >> Microsoft Training >> Red Hat Training >> Application Development Training >> Business Intelligence Training >> Java Training >> Virtualization Training >> Enterprise Architecture Training >> Networking Training >> Security Training >>

Toll Free (877) 800-5221 • Fax: (919) 816-1710
ASPE • 114 Edinburgh South Dr. - Suite 104 • P.O. Box 5488 • Cary, NC 27511