|
�'� `--� 'DescriheA e- ocesses fog lanniri �"andzusin "a=Windows `0"troublesHi3otm�'inettiodolo �T 5'= p 9 "" g g gy Troutileshoot startup' -
<br />issues and operating system services on a Windows 10 device., Resolve issues that pertain to hardware devices
<br />and device drivers., Troubleshoot Windows 10 devices remotely., Troubleshoot issues that pertain to network
<br />connectivity., Troubleshoot client -configuration failures and issues with application of Group Policy Objects
<br />(GPOs)., Troubleshoot issues related to user settings. , Troubleshoot remote -connectivity issues., Resolve issues
<br />that pertain to accessing resources from devices that are domain -joined., Resolve issues that pertain to accessing
<br />resources from devices that are not domain -joined., Troubleshoot issues that pertain to application installation and
<br />operation., Maintain a device that is running Windows 10., Recover a device that is running Windows 10.
<br />10985 Introduction to SQL Databases
<br />Description
<br />Course is aimed at people looking to move into a database professional role or whose job role is expanding to
<br />encompass database elements. The course describes fundamental database concepts including database types,
<br />database languages, and database design
<br />Acquired Skills
<br />Describe key database concepts in the context of SQL Server 2016, Describe database languages used in SQL
<br />Server 2016, Describe data modelling techniques, Describe normalization and de -normalization techniques,
<br />Describe relationship types and effects in database design, Describe the effects of database design on
<br />performance, Describe commonly used database objects
<br />10987 Performance Tuning and Optimizing SQL Databases
<br />Description
<br />provides students who manage and maintain SQL Server databases with the knowledge and skills to performance
<br />tune and optimize their databases.
<br />Acquired Skills
<br />Describe the high level architectural overview of SQL Server and its various components., Describe the SQL Server
<br />execution model, waits and queues., Describe core 1/0 concepts, Storage Area Networks and performance testing.,
<br />Describe architectural concepts and best practices related to data files for user databases and TempDB., Describe
<br />architectural concepts and best practices related to Concurrency, Transactions, Isolation Levels and Locking.,
<br />Describe architectural concepts of the Optimizer and how to identify and fix query plan issues. ,Describe
<br />architectural concepts, troubleshooting scenarios and best practices related to Plan Cache., Describe architectural
<br />concepts, troubleshooting strategy and usage scenarios for Extended Events., Explain data collection strategy and
<br />techniques to analyze collected data., Understand techniques to identify and diagnose bottlenecks to improve
<br />overall performance.
<br />10990 Analyzing Data with SQL Server Reporting Services
<br />Description
<br />This course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in
<br />an organization. The course discusses how to use the Reporting Services development tools to create and manage
<br />reports and implement self-service BI solutions.
<br />Acquired Skills
<br />Describe reporting services and it's components, Describe reporting services data sources, Implement paginated
<br />reports, Work with reporting services data, Visualize data with reporting services, Aggregate report data, Share
<br />reporting services reports, Administer reporting services, Expand and integrate reporting services, Describe mobile
<br />reports, Develop mobile reports.
<br />10994 Data Analysis Fundamentals using Excel
<br />Description
<br />The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and
<br />to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.
<br />Acquired Skills
<br />Create an Excel report, Create an Excel table, Create a pivot table and pivot chart, Create a dashboard and
<br />analyze data, Create Hierarchies, Data Analysis Fundamentals using Excel
<br />10997 Office 365 Administration
<br />Description
<br />
|