Implementing a Microsoft® SQL Server® 2008 R2 Database (MOC6232)
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to implementing a database.
| The course is included in the following categories: |
Microsoft Official Course Databáze → Microsoft SQL → MS SQL 2005/2008 Microsoft |
Difficulty of the course: Advanced
Course duration: 5 days
Contents of the course:
- Introduction to SQL Server 2008 R2 and its Toolset
- Working with Data Types
- Designing and Implementing Tables
- Designing and Implementing Views
- Planning for SQL Server 2008 R2 Indexing
- Implementing Table Structures in SQL Server 2008 R2
- Reading SQL Server 2008 R2 Execution Plans
- Improving Performance through Nonclustered Indexes
- Designing and Implementing Stored Procedures
- Merging Data and Passing Tables
- Creating Highly Concurrent SQL Server 2008 R2 Applications
- Handling Errors in T-SQL Code
Expected knowledge: Working knowledge of Transact-SQL (ability to write Transact-SQL queries) or Course 2778A: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL. Working knowledge of relational databases (database design skills). Core Windows Server skills. Basic programming language.
.Course dates:
This course is no longer in our offer. For more information or if you are interested in contact us at skoleni@pcdir.cz or phone +420 543 533 610.