Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
14 Hours
Testimonials (5)
Philip was very kind, his style of explaining SQL concepts is outstanding. I liked that he give us information and answered to questions which were not part of this course.
Stefan
Course - SQL in SQL Server
It allowed us to have an applied hands on sproc to our company database.
Corneliu Buculei - Standard Building Supplies Ltd
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Interactive exercises
Matthew Viner - Thames Water Utilites Ltd
Course - Transact SQL Basic
the in depth knowledge and customize approach
Julius Mapili - SYKES Asia, Inc.
Course - Administering in Microsoft SQL Server
The ability to ask questions at any time and the more informal / less structured style. This allowed us to pursue the areas of knowledge we were most interested in.