Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
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
Requirements
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.
21 Hours
Testimonials (5)
Being human and talking to us as understandable possible
Sorin
Course - Database Administration Fundamentals for MS SQL Server
It allowed us to have an applied hands on sproc to our company database.
Corneliu Buculei - Standard Building Supplies Ltd
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
the in depth knowledge and customize approach
Julius Mapili - SYKES Asia, Inc.
Course - Administering in Microsoft SQL Server
I appreciated Folio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).
Raphael - Markit Valuations Limited
Course - Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012
The thorough / hands-on knowledge the trainer has.
