 |
|
Want to take this class from the comfort and convenience of your own office? We can offer a customized version of most courses right at your office, when you need it. Read more about our on-site learning or contact us to get specific information. |
Upcoming Classes
Don't see dates for this class? Please contact us or request that we add it to our schedule. Methods of DeliveryThis course can be delivered via the following learning methods:OverviewThis course provides students with the technical skills required to program a database solution by using Microsoft SQLServer 2000.At Course CompletionAfter completing this course, students will be able to: - Describe the elements of SQL Server 2000. - Describe the conceptual basis of programming in Transact-SQL. - Create and manage databases and their related components. - Implement data integrity by using the IDENTITY column property, constraints, defaults, rules, and unique identifiers. - Plan for the use of indexes. - Create and maintain indexes. - Create, use, and maintain data views. - Design, create, and use stored procedures. - Implement user-defined functions. - Create and implement triggers. - Program across multiple servers by using distributed queries, distributed transactions, and partitioned views. - Optimize query performance. - Analyze queries. - Manage transactions and locks to ensure data concurrency and recoverability.Pre-Requisites2274 Managing a Microsoft Windows Server 2003 Environment2275 Maintaining a Microsoft Windows Server 2003 Environment. 2071A Querying Microsoft SQL Server 2000 with Transact-SQL |
| Home Search Courses Site Map Privacy/Terms of Use Contact Careers |
New Horizons of Syracuse, NY |
New Horizons of Rochester, NY |
Copyright ©
2010
New Horizons Computer Learning Center of Syracuse and Rochester. All rights reserved.
Links to the New Horizons Corporate website are denoted with an arrow (→)