PROGRAMMING A MICROSOFT SQL SERVER DATABASE (Duration: 5 days)
Course 2073 – Instructor-led

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.

 

A division of Infinities Inc Computer Training, Columbia, SC
| Home | Courses & Schedule | Registration | Contact Us |