Susisiekite su mumis:
+370 5 2105044
info@protraining.lt

MOC 20464 Developing Microsoft SQL Server Databases

MOC 20464
Klausytojų vertinimas

Trukmė: 5 dienos
Kaina:
1 950 € (+ PVM 21%)

Apie mokymus:

Šie penkių dienų trukmės mokymai supažindina dalyvius su Microsoft SQL Server 2012 ir duomenų bazių kūrimu.

Dėstytojas: Gintaras Graževičius


Mokymų temos:

1. Introduction to SQL Server 2012 and its Toolset.
2. Working with Data Types.
3. Designing and Implementing Tables.
4. Ensuring Data Integrity through Constraints.
5. Planning for SQL Server 2012 Indexing.
6. Implementing Table Structures in SQL Server 2012.
7. Reading SQL Server 2012 Execution Plans.
8. Improving Performance through Nonclustered Indexes.
9. Designing and Implementing Views.
10. Designing and Implementing Stored Procedures.
11. Merging Data and Passing Tables.
12. Designing and Implementing User-Defined Functions.
13. Creating Highly Concurrent SQL Server 2012 Applications.
14. Handling Errors in T-SQL Code.
15. Responding to Data Manipulation via Triggers.
16. Implementing Managed Code in SQL Server 2012.
17. Storing XML Data in SQL Server 2012.
18. Querying XML Data in SQL Server.
19. Working with SQL Server 2012 Spatial Data.
20. Working with Full-Text Indexes and Queries.