Maintaining a Microsoft SQL Server 2005 Database

ProTech Professional Technical Services, Inc.
Richmond, Virginia, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course covers a universal core set of skills associated with SQL Server such as installing and configuring SQL Server, creating and maintaining database backups, user accounts, permissions, tasks, and bulk data operations. These skills are used by a large population of IT Professionals, which consists of developers, generalists, and administrators and are a core skill set for anyone working with databases.

Audience: This course is designed for IT Professionals, which consists of developers, generalists, and administrators.

Topics:
Installing SQL Server 2005
Creating and Managing Databases
Securing SQL Server 2005
Implementing a Disaster Recovery Strategy
Monitoring SQL Server 2005
Transferring Data with SQL Server Integration Services
Automating Database Administration
Configuring Database Mirroring
Implementing Replication
Prerequisites: This course requires that participants meet the following prerequisites:-Must have basic knowledge of the Microsoft Windows® operating system and its core functionality. For example, users interface navigation, configuration, and monitoring.-Must have working knowledge of Transact-SQL. For example, SELECT, INSERT, UPDATE, and DELETE statements. -Must have working knowledge of relational databases. For example, relational theory, Set theory, and the difference between a database and a spreadsheet.-Must have some experience with database design. Specifically, they must fully understand Third Normal Form (3NF), be able to design a database to 3NF (fully normalized), and know the trade-offs when backing out of the fully normalized design (denormalization; that is, designing for performance and or business requirements).
...''

Phone:800-373-9188

School Address:

610 Beatty Road
Monroeville, PA 15146
USA

Jobs & Resumes: Richmond
Houses & Roommates: Richmond

.NET Programming with C#
ASP.NET 2.0 Workshop
Data Modeling
ITSM/ITIL v3
Open Applications Group’s Integration Specification (OAGIS)
SAS Report Writing
UNIX and Linux System
XML Programming using Java
ADO.NET
Implementing a Microsoft SQL Server 2005 Database
SQL
Business Analysis for IT Professionals
Project Management Principles and Tec
Collaborative Relationships
Advanced Project Management
XML
Microsoft Project 2003
CICS Command Level Programming
Oracle Reports

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.