Dejan Sarka

Dejan Sarka

Workshop description:

Many times, you wish you could have some more powerful tool than the Transact-SQL (T-SQL) language for working with data. You might need to enable your users to use word search in your string columns or in Office documents to give them similar experience like they get when they search the web. You might need to implement constraints and do the data analysis with functions that are simply not implemented in T-SQL. Or you might need to maintain multiple versions of data over the time and be able to query the state of the data from the past.
All these features mentioned are sometimes referred as “beyond relational”. However, data type and language support in a specific database management product has nothing to do with the relational model, which is purely logical model. For many years, we used to associate a RDBMS with the SQL language and simple data types; but there are no limitations for both in the relational model. Therefore, I prefer to use the term “beyond classical RDBMS”.
Modules
1. Advanced search with Full-Text Search
2. CLR integration
3. Temporal support
4. Leveraging external engines: R, Python, Java
5. XML Support in SQL Server
6. Using JSON
7. CLR and Spatial data
8. Graph data

Length of the workshop:

Half day (4 hours)

Workshop form:

Lecture (slides + demos)

Level:

400

Additional information:

Speaker available online only.

If you decide to help Ukraine and make a donation here:

https://ukrainewar.carrd.co/?fbclid=IwAR0YeLyGjf2NGCHb8Pk141aBr2Ysf9S-eV8ZLsLLMupUThl7oA8ZnClX6CQ

please send a confirmation to us (sqlday@datacommunity.pl ) and you will receive a $50 conference discount

Workshop cost:

Standard: 550 PLN (online 275 PLN) + VAT

Last minute: 750 PLN (online 375 PLN) + VAT