Lessons Operational Analytics In-memory OLTP Enhancements Query Store Live Query Statistics Native JSON Temporal Tables Lab: Implementing SQL Server 2016 Performance Improvements After completing this module, you will be able to: Describe the use of Columnstore indexes for operational analytics Describe the enhancements to in-memory OLTP Use the query data store Use Native JSON Describe and use temporal tables Module 3: What’s New in SQL Server Security?
Microsoft recommends that you have completed course 803, "Administering Microsoft Windows NT 4.0," and course 922, "Supporting Microsoft Windows NT 4.0 Core Technologies," or have equivalent skills and knowledge. Each module takes a look at a different topic with Windows 2000. For instance, a new installation is covered in Module 1, but upgrading is not covered until Module 6.
There are plenty of labs and sample questions, and you’ll get evaluation copies of Windows 2000 Professional and Windows 2000 Advanced Server.
Lessons Poly Base What’s new in Integration Services Working with SSIS and Azure Lab: Exploring the new features of SQL Server Integrated services (SSIS) After completing this module, you will be able to: Describe and install Poly Base Describe enhancements to SSIS Module 7: New and Enhanced Features in SQL Server OLAP This module describes enhancements in SQL Server OLAP.
Lessons New and Enhanced Features in SQL Server OLAP What’s New in SQL Server Analysis Services Lab: OLAP with SQL Server After completing this module, you will be able to: Describe new and enhanced features in SQL Server OLAP Describe new and enhanced features in SQL Server analysis services Module 8: What’s New for SQL Server in the Cloud?
The lab has four exercises, which require you and a partner to install and test DNS. It covers the concept of Active Directory in a multimedia presentation (included in your course CD).
The components of Active Directory (trees, forests, domains, organizational units (OUs), DNS naming conventions, and global catalog) are explained in detail.
Problematic installations could take days to complete.
Understanding this module is essential to becoming a Windows 2000 administrator.
Understanding Active Directory is key to proceeding in the course.