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.

0
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.
Get Quote

Master new skills guided by experienced instructors from anywhere.

0
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.
Get Quote

You can participate in a Public Course with people from other organisations.

0

/per trainee

Number of Participants

1 Participant

Thanks for the numbers, they could be going to your emails. But they're going to mine... Thanks ;D
Oops! Something went wrong while submitting the form.
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
Fits ideally for individuals and small groups
Star Icon - Education X Webflow Template
Networking opportunities with fellow participants.
*Price can range depending on number of participants, change of outline, location etc.
Get Quote