Implementing 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 skill of SQL Server, creating and implementing data storage objects such as databases, data types, and tables; constraints, indexes and programming objects such as UDFs, UDT, Triggers and stored procedures using Transact-SQL or through the CLR. These skills are used by a large population of IT Professionals which consists of developers, Generalists, and IT Professionals and are a core skill for anyone working with databases.

Audience:

Topics:
Creating a Database
Creating Data Types and Tables
Working with XML
Creating Indexes
Implementing Data Integrity
Implementing Views
Implementing Stored Procedures and Functions
Implementing Managed Code in the Database
Implementing Managed Code in the Database
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, user interfaces 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

Java Boot Camp
.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
Maintaining 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

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.