Here are the key points covered in the demonstration:
- How to configure Hyper-V to use Windows key combinations in the VM
- How to sign in and sign out of Windows
- How to access applications like Server Manager, Hyper-V Manager, etc.
- How to access Control Panel to manage settings
- Examples of useful shortcut keys like Windows key + X for power options
The demonstration covered basic navigation and common tasks in Windows Server to help students get familiar with the interface before beginning hands-on labs.
Here are the key points covered in the demonstration:
- How to configure Hyper-V to use Windows key combinations in the VM
- How to sign in and sign out of Windows
- How to access applications like Server Manager, Hyper-V Manager, etc.
- How to access Control Panel to manage settings
- Examples of useful shortcut keys like Windows key + X for power options
The demonstration covered basic navigation and common tasks in Windows Server to help students get familiar with the interface before beginning hands-on labs.
Here are the key points covered in the demonstration:
- How to configure Hyper-V to use Windows key combinations in the VM
- How to sign in and sign out of Windows
- How to access applications like Server Manager, Hyper-V Manager, etc.
- How to access Control Panel to manage settings
- Examples of useful shortcut keys like Windows key + X for power options
The demonstration covered basic navigation and common tasks in Windows Server to help students get familiar with the interface before beginning hands-on labs.
Here are the key points covered in the demonstration:
- How to configure Hyper-V to use Windows key combinations in the VM
- How to sign in and sign out of Windows
- How to access applications like Server Manager, Hyper-V Manager, etc.
- How to access Control Panel to manage settings
- Examples of useful shortcut keys like Windows key + X for power options
The demonstration covered basic navigation and common tasks in Windows Server to help students get familiar with the interface before beginning hands-on labs.
Download as PPTX, PDF, TXT or read online from Scribd
Download as pptx, pdf, or txt
You are on page 1/ 22
Microsoft Official Course
20762C Developing SQL Databases Welcome Thank you for joining us today.
We’ve worked together with the At the end of class, please complete Microsoft Partner Network and an evaluation of today’s experience. Microsoft IT Academies to bring you We value your feedback! a world-class learning experience. Certification Exam Benefits. After Microsoft Certified Trainers + training, consider pursuing a Instructors. Your instructor is a Microsoft Certification to help premier technical and instructional distinguish your technical expertise expert who meets ongoing and experience. Ask your instructor certification requirements. about available exam promotions and discounts. Customer Satisfaction Guarantee. Our partners offer a satisfaction We wish you a great learning guarantee and we hold them experience and ongoing career accountable for it. success! Hello! Instructor introduction
• Instructor: <Name> • <Title or other credentials, e.g. Microsoft Certified Trainer> • <Affiliation/Company> • <A few words about my technical and professional experience> Hello! Student introductions
Let’s get acquainted:
• Your name • Company affiliation • Title/function • Windows Server 2012 experience • Product experience • Your expectations for the course Facilities
• Class hours • Building hours • Parking • Restrooms • Meals • Phones • Messages • Smoking • Internet access • Recycling • Emergency procedures About this course: Audience
• The primary audience for this course is IT
Professionals who want to become skilled on SQL Server 2016 product features and technologies for implementing a database. • The secondary audiences for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 database. About this course: Prerequisites
Before attending this course, students must have:
• Basic knowledge of the Microsoft Windows
operating system and its core functionality. • Working knowledge of relational databases • Working knowledge of Transact-SQL. About this course: Objectives
After completing this course, students will be able to:
• Design and Implement Tables.
• Describe advanced table designs • Ensure Data Integrity through Constraints. • Describe indexes, including Optimized and Columnstore indexes • Design and Implement Views. • Design and Implement Stored Procedures. • Design and Implement User Defined Functions. About this course: Objectives cont.
After completing this course, students will be able to:
• Respond to data manipulation using triggers.
• Design and Implement In-Memory Tables. • Implement Managed Code in SQL Server. • Store and Query XML Data. • Work with Spatial Data. • Store and Query Blobs and Text Documents. Your course materials (OPTIONAL)
Designed to optimize your classroom learning experience
and support you back on the job
Microsoft Official Course handbook
• Organized by modules • Includes Labs and Lab Answer Keys • Module Reviews and Takeaways make great on-the-job references
NOTE This is an early-to-market edition of the course. Upon release of the next edition, you will be able to access the digital companion content from Microsoft Learning at: microsoft.com/learning/companionmoc Your course materials (OPTIONAL)
Microsoft Official Course Handbook (Digital)
• Access online using the Skillpipe reader by arvato, at http://skillpipe.com • Register/sign in and redeem your digital courseware • Easily add notes and comments, and highlight content • Organized by module • Includes Labs and Lab Answer Keys • Module Reviews and Takeaways make great on-the- job references
Module 4 Ensuring data integrity through constraints
Module 5 Introduction to indexes
Module 6 Designing optimized index strategies Course outline, continued
Module 7 Columnstore indexes
Module 8 Designing and implementing views
Module 9 Designing and implementing stored procedures
Module 10 Designing and implementing user-defined functions
Module 11 Responding to data manipulation via triggers
Module 12 Using in-memory tables Course outline, continued
Module 13 Implementing managed code in SQL server
Module 14 Storing and querying XML data in SQL server
Module 15 Working with SQL server spatial data
Module 16 Storing and querying blobs and test documents in SQL server
Module 17 SQL server concurrency
Module 18 Performance and Monitoring Microsoft Certification Program
Get trained. Get certified.
Get ahead. Microsoft Certifications demonstrate that Microsoft Certified you have the skills to design, deploy, and Solutions Expert optimize the latest technology solutions. (MCSE) Ask your Microsoft Learning Partner how you can prepare for certification.
For more information about Microsoft Microsoft Certified
Certifications, go to: Solutions Associate http://www.microsoft.com/learning/ certification (MCSA) Preparing for the Labs
Your lab activities will be centered around a fictitious company that we will call A. Datum Corporation, through which you will learn how to:
• Implement Storage Spaces and Data Deduplication
• Plan and configure high availability storage • Plan and configure disaster recovery solutions • Create and manage failover clusters • Manage highly available applications and services • Plan and configure storage with System Center 2012 R2 Virtual Machine Manager • Plan and configure cloud-based storage • Implement a network load balancing cluster
You will work in a VM environment to complete the labs.
VM environment
VM name Use as
20762C-MIA-DC1 Windows Server 2016 domain
20762C-MIA-SQL SQL Server 2017
MSL-TMG1 TMG server for accessing the internet
Microsoft Learning Azure Pass
• You will use the Microsoft Learning Azure Pass to provide access to Microsoft Azure for demonstrations and labs
• Microsoft Learning Azure Pass access and configuration
• Best Practices for Microsoft Learning Azure Pass Usage:
• Check the dollar balance of you Azure Pass within Microsoft Azure once you have set up your subscription, and be aware of how much you are consuming as you proceed through the labs. • Do not allow Microsoft Azure components to run overnight or for extended periods unless you need to do so. • Remove any Microsoft Azure–created components or services such as storage, virtual machines, or cloud services, after you finish your lab to help minimize cost usage and extend the life of your Microsoft Learning Azure Pass. WARNING – You May Experience UI Discrepancies (OPTIONAL) Given the dynamic nature of Microsoft cloud tools, you may experience Microsoft Office 365 and/or Azure user interface (UI) changes that were made following courseware development and that do not match up with lab instructions.
The Microsoft Learning team will document these
changes for instructors as they are brought to our attention. However, given the dynamic nature of cloud updates, you may run into changes before we become aware of them.
If this occurs, you will have to adapt to the changes and
work through them in the labs as necessary. Demonstration: Using Microsoft Labs Online (OPTIONAL)
In this demonstration, you will learn how to:
• Access the MLO lab environment • Switch between VMs
Read the online Lab Notes carefully, because some procedures
related to on-premises lab versus online labs may have slightly different steps. Any differences will be called out in the Lab Notes. Demonstration: Using Hyper-V Manager (OPTIONAL)
In this demonstration, you will learn how to:
• Open Hyper-V Manager • Navigate the various sections/panes within Hyper-V Manager: • VMs, snapshots, and actions (server-specific and VM-specific) • Identify the VMs you will use in the labs for this course • Take a snapshot and apply a snapshot • Connect to a VM • Start and sign in to a VM • Switch between full screen and window modes • Revert to the previous snapshot • Shut down a VM • Know when to shut down versus turn off a VM • Close Hyper-V Manager Demonstration: Navigation in Windows Server 2012 (OPTIONAL)
In this demonstration, you will learn how to:
• Configure Hyper-V to use Windows key combinations in the VM • Sign in and sign out • Access applications • Access Control Panel • Use shortcut keys
