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 9050a | 3-DAY SESSION
Microsoft Extreme SQL Server 2005

Go beyond basic training and build on your SQL Server knowledge with this accelerated, lab-driven course

SQL Server 2005 has grown from the SMB database of choice to an Enterprise database solution. Microsoft has added many important pieces to the 2005 offering to help make that “enterprise” claim. And with the release of SQL Server 2008 being pushed back by Microsoft, there has never been a better time to enhance your skills on SQL Server 2005.


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 Server 2005 Database Tuning Advisor (DTA)
  • Implement a SQL clustering solution
  • Set up a database mirroring solution
  • What’s new in SQL 2005 Server Integration Services (SSIS)
  • Optimize, scale and deploy SSIS packages using Business Intelligence Development Studio (BIDS)
  • Build a SQL Server 2005 enterprise project in class

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