Kurs: MS SQL Server 2000 DB programmering ( kurs 2073)

Gateway AS

Form

Klasserom

Varighet

5 dag(er)

Deltid

Heltid

Nei

Nivå

Kurs

Pris

20500,-

Send meg gratis info

Les mer om Gateway AS

Se flere kurs fra Gateway AS (92 kurs)

Se 67 kurs i SQL programmering

Dette kurset har ikke oppført noen dato for studiestart. Bruk skjemaet under for å kontakte leverandør for nærmere informasjon.

Dokumentasjon
SQL Server 2000 programming by example eller MOC eller tilsvarende fra MS Press.

At Course Completion

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