Ms SQL Server - Database Structures

The training is designed for all those who want to learn how to work with advanced data types using complex database structures.
Trainees are required to have both knowledge of the Windows environment and how relational databases work.

This training is designed to introduce participants to various advanced solutions for data types and database structures. Participants will learn to use spatial type data, hierarchical type data, XML type data, and process data from/to JSON format.
Upon completion of the training, the participant:
▪ will be able to use various advanced solutions for data types and database structures
▪ will be able to process data from/to JSON format.

01. SPATIAL TYPE DATA
   ➡ GEOGRAPHY
   ➡ GEOMETRY
   ➡ SRID
   ➡ Spatial indexes: SPATIAL INDEX

02. HIERARCHICAL TYPE DATA
   ➡ HIERARCHYID structure elements.
   ➡ Indexing of hierarchical data type.
   ➡ Available methods

03. XML TYPE DATA
   ➡ OPENXML format
   ➡ FOR XML clause
   ➡ WITH XMLNAMESPACE clause
   ➡ XQUERY language
   ➡ XPATH language
   ➡ FLWOR expressions
   ➡ DML operations on data of type XML
   ➡ Methods available on XML data type
   ➡ Indexing of XML documents

04. JSON DATA FORMAT
   ➡ Loading data into a database from JSON format.
   ➡ Generating data from a database to JSON format