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.
The Good, the Bad, and the Ugly
As an independent source of IT Training, ASPE 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 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
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 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:
- Understand data verification in the database using constraints and triggers
- Create stored procedures and learn their pros and cons
- Store, access, modify and index XML data in its native format
- Work with and leverage the new schema object model
- Secure your data as well as your customers’ data
- Improve calculations and analysis of data using user defined functions built with Common Language Runtime
- Use Performance Monitor and SQL Profiler to optimize SQL server performance
- Write optimized TSQL queries to improve performance
- Use the Database Tuning Advisor for superior performance
- Use indexes to optimize access to data in the database
- Analyze SQL locks to determine and eliminate bottlenecks due to locking
- Design highly available database solutions
- Configure SQL Server for Microsoft Clustering
- Understand differences and benefits of log shipping and database mirroring
- How to use database replication to your advantage
- Leverage the power of SQL Server Integration Services (SSIS) in your environment
- Design the topology for your high-availability solution
- Manage SQL keys and certificates in your security solution
