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.
Testimonials (9)
Interakcja z prowadzącym, możliwość zadawania pytań na gorąco
Grzegorz Ziegert
Course - Administration with Powershell
database optimization, dedicated approach, ability to ask questions, insight/assessment of our database
Aleksandra Czyndacka - Mikrobit
Course - Administering in Microsoft SQL Server
Machine Translated
Transfer of knowledge using simple and understandable examples.
Katsiaryna
Course - SQL language in MSSQL
Machine Translated
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
Angelito Aguilar - Metrobank
Course - Introduction to SQL Server 2012 Integration Services (SSIS)
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
i really liked the pace of the training, and the exercises given inbetween the explanations
Trana
Course - SQL in SQL Server
I enjoyed the balance of lectures and exercises. When I was stuck Luke was very good at helping me to understand the problem and work towards solutions which made a really positive impact on my understanding.
Tom - Welsh Revenue Authority
Course - Transact SQL Basic
Really enjoyed compression data components
James - Medtech Limited
Course - Transact SQL Advanced
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).