Training Course:MCTS- SQL Server 2005 (Certificate)School/Trainer:Portland State University Portland, Oregon, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Microsoft Certified Technology Specialists course provides comprehensive understanding of implementation and maintenance of SQL Server 2005 databases. This course provides extensive knowledge of the product, understanding on how to use the tools and Transact-SQL language, and knowledge of how to explore the user interface. This course also prepare for highly recognized MCTS-SQL Server 2005 certification. After the training, individuals will be able to demonstrate the skills necessary to lead the successful implementation, and administration of SQL Server 2005 databases
Our top-notch information technology and computer training meets the growing demands of the Portland Metro area including Vancouver (WA), Southwestern Washington, and Salem, Oregon communities.
COURSE OUTLINE:
Install SQL Server 2005 Configure SQL Server 2005 instances and databases Configure SQL Server security Configure linked servers by using SQL Server Management Studio (SSMS) Implement database mirroring Implement log shipping Manage database snapshots Retrieve data to support ad hoc and recurring queries Manipulate relational data Import and export data from a file Manage replication Implement and maintain SQL Server Agent jobs Manage databases by using Transact-SQL Back up a database Restore a database Move a database between servers Gather performance and optimization data by using the SQL Server Profiler Gather performance and optimization data by using the Database Engine Tuning Advisor Monitor and resolve blocks and deadlocks Diagnose and resolve database server errors Monitor SQL Server Agent job history Implement a table Implement a view Implement triggers Implement functions Implement stored procedures Implement constraints Implement indexes Create user-defined types Implement partitions PREREQUISITES: Basic knowledge of Windows OS and RDBMS concepts.
...''
Please go to the school's official website for training price and schedule:
http://www.pdc.pdx.edu/
Phone:800-547-8887 ext. 4832
School Address:
Portland State University, Professional Development Center, 1633 SW Park Ave., Portland , OR 97201 USA
Jobs & Resumes: Portland Houses & Roommates: Portland Travel Agencies: Portland
Search other schools for MCTS- SQL Server 2005 training resources.
Other training courses offered by Portland State University:
MCP
Microsoft Certified Systems Administrator (MCSA)
MCSE 2003
Implementing and Managing Microsoft Exchange Server 2003
CWNA- Certified Wireless Network Administrator
Introduction to Oracle SQL 10g
OCA - Oracle 10g Certified Associate
OCP - Oracle 10g Certified Professional
Oracle 10g Database Administration
Microsoft Certified Database Administrator (MCDBA)
MCTS- Microsoft .NET Framework 2.0
Microsoft® .NET Framework 2.0 Web-Based Client Development
Web-Based Applications Using the Microsoft .NET Framework
Java Programming
MCAD.NET - Microsoft Certified Application Developer
MCPD.NET - Microsoft Certified Professional Developer
MCSD - Microsoft Certified Solution Developer
SECURITY+
CISSP - Certified Information Systems Security Professional
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting. |
|
|