Course Outline
Performanace and Management
- Enhanced Database Caching
- Query data store
- In-Memory OLTP in SQL Server 2016
Development
- Temporal Database
- Temporary Table and Variable Table in-memory
- Native JSON
High Availability and Security
- Enhanced AlwaysOn
- Always Enrypted
- Row-level Security
- Dynamic Data Masking
Data Insight and Business Intelligence
- Operational Analytics
- New functionality Columnstore Index
- Direct Query in SSAS Tabular
- R Integration (language R in SQL Server)
- Enhanced SSIS
- Enhanced MDS
Reporting Services
- New Report Server
- Mobil Reports
- SQL Server Mobile Report Publisher
Cloud and Hybrid
- Stretch Database
- Enhanced backup to Azure
- Migration SQL Server to Azure
- SSIS and Data Factory
Testimonials (7)
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)
database optimization, dedicated approach, ability to ask questions, insight/assessment of our database
Aleksandra Czyndacka - Mikrobit
Course - Administering in Microsoft SQL Server
Machine Translated
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
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).
Raphael - Markit Valuations Limited
Course - Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012
Being human and talking to us as understandable possible
Sorin
Course - Database Administration Fundamentals for MS SQL Server
All the various ways Darius explained concepts and then put them into our database tables.
James Rodi - Medtech Limited
Course - T-SQL Fundamentals with SQL Server Training Course
Transfer of knowledge using simple and understandable examples.
Katsiaryna
Course - SQL language in MSSQL
Machine Translated