SQL Saturday #642 and SQL Master Academy

Invite you on

SQL Staurday #642
Pre-Con sessions

Learn about Pre-Conn sessions

Session Title: R and Python in SQL Server 2017
Price: 120 Euro (VAT excl.)
Date: 13.10.2017 (Friday)
Duration: 9:00 till 17:00
Venue: SQL Master Academy training center

Dejan Sarka: R and Python in SQL Server 2017

Price: 120 Euro (VAT excl.)

Summary

R is the most popular environment and language for statistical analyses, data mining, and machine learning. Managed and scalable version of R runs in SQL Server 2016 and 2017 and in Azure ML. Although R is the most popular environment and language for data science, Python as a more general language might be even more widely spread. Lately, Python is more widely used for data science as well. SQL Server 2017 adds support for running Python code inside the Database Engine. Learn how to program in R and Python to squeeze the information from your data.

Read more

Session Title: SQL Server Full Stack Security
Price: 90 Euro (VAT excl.)
Date: 13.10.2017 (Friday)
Duration: 9:00 till 17:00
Venue: SQL Master Academy training center

André Melancia: SQL Server Full Stack Security

Price: 90 Euro (VAT excl.)

Summary

You’ve just installed SQL Server. Do you trust the default installation? Is it “secure” enough for you? How easy is it to hack your SQL Server?

Whether you’re a SysAdmin, a DBA or a Developer, you should have good working knowledge of full stack security for your environment.

In this workshop, we’ll cover many vulnerabilities and recommended security configurations for hardware and operating system (SysAdmin’s job), examine security model and features for SQL Server, including new 2016 and 20017 features (DBA’s job), and finally cover development vulnerabilities and best practices (Developer’s job).

Read more

Session Title: Designing and Implementing Data Warehouses in Agile Manner
Price: 90 Euro (VAT excl.)
Date: 13.10.2017 (Friday)
Duration: 9:00 till 17:00
Venue: SQL Master Academy training center

Marcin Szeliga: Designing and Implementing Data Warehouses in Agile Manner

Price: 90 Euro (VAT excl.)

Summary

Data warehouse is a crucial part of every Business Intelligence system — its design and implementation determine if stored data can be used to answer business questions quickly and efficiently. Because data warehouses serve a different purpose than operational databases (OLTP), their structure is also different, which means that to create a successful data warehouse a distinct set of skills is needed.

Read more