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