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
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.

This powerful hands-on course will take you past the basics and into the advanced topics of SQL Server 2005. Go from renaming a database to implementing a SQL Cluster in only three days. This SQL Server 2005 class will help you surpass the basic knowledge of databases and delve into hot topics like SSIS, database mirroring and performance tuning.

You won’t find training anywhere on the market that has more hands-on, real-world labs. Build on your knowledge base of SQL Server 2005 and become an expert.


In-Class Workshops and Group Exercises:

ASPE Technology is now introducing “Extreme” courses in the IT Training marketplace. Our goal is to challenge students with basic knowledge of a software tool and create experts. With over 40 Hands-On labs, this 3-day SQL Server 2005 course is more lab-driven than any course on the market. The labs are also part of a three-day project in which you will build a database for a fictional organization utilizing the advanced tools of SQL Server 2005.


Specifically you will:

Section 1

  • Implement UNIQUE Constraints
  • Implement CHECK Constraints
  • Create a DDL Trigger
  • Create a DML Trigger
  • Create a Stored Procedure
  • Create Parameterized Stored Procedures
  • Create Aggregate and Scalar Functions
  • Use the TRY…CATCH Construct
  • Using the EXECUTE AS Clause
  • Using XML Schemas
  • Create and Implement CLR Assemblies
  • Create Database Using T-SQL and SQL Server Tools
  • Manage Database Size
  • Manage Tables & Views
  • Create Logins and User accounts
  • Using Server and Database Roles
  • Implement Database encryption
  • Secure the Server & Database Scope
  • Measure System Performance Using System Monitor
  • Measure System Performance Using the SQL Server 2005 Profiler
  • Identify Locking and Blocking
  • Query database records and metadata using T-SQL
  • Using a Clustered Index
  • Using a Non-Clustered Index
  • How to Use the Database Tuning Advisor
  • Implement Strategies to Reduce Locking and Blocking

Section 2

  • Implement a SQL Cluster
  • Implement a Log Shipping Solution
  • Implement a SQL Mirroring Solution
  • Install a SQL Server 2005 Instance for the Witness Server
  • Implement a Replication Solution
  • Configure Peer-to-Peer Replication

Section 3

  • Install SQL Server 2005 Integration Services (SSIS)
  • Working With Business Intelligence Development Studio (BIDS)
  • How to Use the SSIS Import and Export Wizard
  • Build an SQL Server 2005 Integration Services Package
  • How to Execute and SSIS Package From the Command Line
  • How to Log ETL Operations
  • How to Handle Errors in SQL Server 2005 Integration Services
  • Monitor, Optimize, and Scale SQL 2005 Server Packages
  • Deploying a SQL Server 2005 Integration Service Package

There is an art and a science to managing project scope. The BA owns the art: eliciting and defining the need. The PM owns the science: cost and schedule estimates of meeting the need. Achieving success requires effective planning and working together. This class will teach you how to do both — successfully AND efficiently.


Immediate Benefits of Taking This Class:

  1. Understand data verification in the database using constraints and triggers
  2. Create stored procedures and learn their pros and cons
  3. Store, access, modify and index XML data in its native format
  4. Work with and leverage the new schema object model
  5. Secure your data as well as your customers’ data
  6. Improve calculations and analysis of data using user defined functions built with Common Language Runtime
  7. Use Performance Monitor and SQL Profiler to optimize SQL server performance
  8. Write optimized TSQL queries to improve performance
  9. Use the Database Tuning Advisor for superior performance
  10. Use indexes to optimize access to data in the database
  11. Analyze SQL locks to determine and eliminate bottlenecks due to locking
  12. Design highly available database solutions
  13. Configure SQL Server for Microsoft Clustering
  14. Understand differences and benefits of log shipping and database mirroring
  15. How to use database replication to your advantage
  16. Leverage the power of SQL Server Integration Services (SSIS) in your environment
  17. Design the topology for your high-availability solution
  18. Manage SQL keys and certificates in your security solution


Who Should Attend:

This class provides definitive instruction on how to harness the latest features of Microsoft’s SQL Server 2005. Anyone involved in the use or management of a database using SQL 2005 will find this class valuable, including:

  • Database Designers
  • Database Administrators
  • Database Developers
  • Data managers in multiple database environments
  • Senior Network Administrator
  • Senior database managers and administrators
  • SQL Server 2000 DBA’s moving to SQL Server 2005


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