Catalogue
/
Databases
/
MongoDB for Developers

MongoDB for Developers

Dive into the core functionalities of Microsoft SQL Server 2016 with this comprehensive training. In just 14 hours, acquaint yourself with the latest features that enhance database management, performance, security, business intelligence, and more.

What will you learn?

Master the realm of SQL Server 2016, a leading database management system at the heart of the Microsoft data platform. This training covers:

• Key performance enhancements and database management techniques.

• Development updates, including temporal databases and native JSON support.

• Advanced security features like Always Encrypted and Row-level Security.

• Business intelligence and reporting services, including the new Report Server and mobile reporting tools.

• Insights into cloud and hybrid functionalities, including enhanced Azure integration. Achieve a holistic understanding and elevate your database management skills to the next level!

Requirements:

• Basic understanding of database concepts.

• Familiarity with previous versions of SQL Server is advantageous but not mandatory.

Course Outline*:

*We know each team has their own needs and specifications. That is why we can modify the training outline per need.

Performance and Management:

  • Enhanced Database Caching
  • In-Memory OLTP in SQL Server 2016
  • Query Data Store

Development:

  • Temporal Database
  • Temporary Table and Variable Table in-memory
  • Native JSON support

High Availability and Security:

  • Enhanced AlwaysOn features
  • Always Encrypted
  • Dynamic Data Masking
  • Row-level Security

Data Insight and Business Intelligence:

  • Operational Analytics
  • Enhanced SSIS and MDS
  • New functionality Columnstore Index
  • Direct Query in SSAS Tabular
  • R Integration (utilizing language R in SQL Server)

Reporting Services:

  • Introduction to the New Report Server
  • Mobile Reports and SQL Server Mobile Report Publisher

Cloud and Hybrid:

  • Stretch Database features
  • Enhanced backup to Azure
  • Migration strategies from SQL Server to Azure
  • Integration of SSIS and Azure Data Factory

Hands-on learning with expert instructors at your location for organizations.

3.072€*
Graph Icon - Education X Webflow Template
Level:
intermediate
Clock Icon - Education X Webflow Template
Duration:
14
Hours (days:
2
)
Camera Icon - Education X Webflow Template
Training customized to your needs
Star Icon - Education X Webflow Template
Immersive hands-on experience in a dedicated setting
*Price can range depending on number of participants, change of outline, location etc.

Master new skills guided by experienced instructors from anywhere.

2.037€*
Graph Icon - Education X Webflow Template
Level:
intermediate
Clock Icon - Education X Webflow Template
Duration:
14
Hours (days:
2
)
Camera Icon - Education X Webflow Template
Training customized to your needs
Star Icon - Education X Webflow Template
Reduced training costs
*Price can range depending on number of participants, change of outline, location etc.