MENU
Introduction
CoursesCourses
Implementing a Microsoft® SQL Server® 2008 R2 Database
Interest in course

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ázeMicrosoft SQLMS 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:

16.07. 20.07.2018 Praha
25 450 CZK (without VAT)
16.07. 20.07.2018 Bratislava
1 000 EUR (without VAT)
23.07. 27.07.2018 Brno
25 450 CZK (without VAT)
13.08. 17.08.2018 Praha 25 450 CZK (without VAT) Order
13.08. 17.08.2018 Bratislava 1 000 EUR (without VAT) Order
20.08. 24.08.2018 Brno 25 450 CZK (without VAT) Order
03.09. 07.09.2018 Bratislava 1 000 EUR (without VAT) Order
03.09. 07.09.2018 Praha 25 450 CZK (without VAT) Order
03.09. 07.09.2018 Košice 1 000 EUR (without VAT) Order
17.09. 21.09.2018 Brno 25 450 CZK (without VAT) Order
17.09. 21.09.2018 Ostrava 25 450 CZK (without VAT) Order
01.10. 05.10.2018 Praha 25 450 CZK (without VAT) Order
01.10. 05.10.2018 Bratislava 1 000 EUR (without VAT) Order
08.10. 12.10.2018 Brno 25 450 CZK (without VAT) Order
22.10. 26.10.2018 Praha 25 450 CZK (without VAT) Order
22.10. 26.10.2018 Bratislava 1 000 EUR (without VAT) Order