14 SSRS courses

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE * Topic A: Explore Crystal Reports * Topic B: Use Crystal Reports Help * Topic C: Customize Report Settings 2 - WORKING WITH REPORTS * Topic A: Create a Report * Topic B: Modify a Report * Topic C: Display Specific Report Data * Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS * Topic A: Create a Formula * Topic B: Edit a Formula * Topic C: Filter Data by Using a Formula * Topic D: Work with Advanced Formulas and Functions * Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS * Topic A: Create a Parameter Field * Topic B: Use a Range Parameter in a Report * Topic C: Create a Prompt 5 - GROUPING REPORT DATA * Topic A: Group Report Data * Topic B: Modify a Group Report * Topic C: Group by Using Parameters * Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT * Topic A: Format a Report * Topic B: Insert Objects in a Report * Topic C: Suppress Report Sections * Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA * Topic A: Create a Report Based on Excel Data * Topic B: Modify a Report Generated from Excel Data * Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA * Topic A: Export Data * Topic B: Create Mailing Labels 9 - APPENDIX * Appendix A: Setting Up and Configuring Data Sources * Appendix B: Using Report Processing Techniques * Appendix C: Using Functions in Formulas

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. The secondary audience for this course are persons who are using Report Designer (SSRS). Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft© SQL Server© Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience. Overview After completing this course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data. 1 - PARAMETER REPORTS * Parameterized Reporting * Create Report Parameters * Modify Report Parameters * Provide Default Parameter Values * Provide Available Values for Parameters * Lab: Creating Parameterized Reports 2 - LIST DATA REGIONS * Introducing the List Data Region * Create Reports Using List Data Regions * Modify Reports Which Use List Data Regions * Lab: Creating List Reports 3 - ENHANCING REPORTS WITH COMPLEX EXPRESSIONS * Formatting Reports * Top N Reports * Running Values * Lab: Enhancing Reports with Complex Expressions 4 - ENHANCE REPORTS WITH IMAGES AND SUBREPORTS * Add Images to Reports * Retrieve Images from a Database * Introducing SSRS (SQL Server Reporting Services) Report Server * Add Subreports to Reports * Lab: Working With Images and Subreports 5 - DRILLDOWN AND DRILLTHROUGH REPORTS * Add and Configure Drilldown Reporting * Add and Configure Drillthrough Reporting * Lab: Add Drilldown and Drillthrough Functionality to Reports 6 - SPARKLINES, DATA BARS, AND INDICATORS * Sparklines * Data Bars * Indicators * Lab: Adding Sparklines, Data Bars, and Indicators to Reports ADDITIONAL COURSE DETAILS: Nexus Humans 55128 Writing Reports with Report Builder and SSRS Level 2 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55128 Writing Reports with Report Builder and SSRS Level 2 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. Overview Navigate the Report Builder Environment. - Create table reports. - Format reports. - Create basic and complex expressions. - Group report data. - Create matrix reports. - Sort and filter data. - Summarize data with charts. - Print and export reports. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. Prerequisites ?Familiarity with Windows. ?Creating and navigating folders. ?Opening programs. ?Manipulating windows. ?Copying and pasting objects. ?Formatting text. ?Saving files. 1 - EXPLORING THE REPORT BUILDER ENVIRONMENT * Introducing the Report Builder Environment * Working with Existing Reports * Lab 1: Exploring the Report Builder Application 2 - ADDING DATA TO TABLE REPORTS * Create Report Data Sources * Create Report Datasets * Work with the Tablix Data Region * Create a Table Report * Lab 1: Creating Table Reports 3 - FORMATTING DATA AND CREATING EXPRESSIONS IN REPORTS * Formatting Reports * Sorting and Filtering Report Data * Adding Data to a Dataset * Creating Simple Expressions * Creating Complex Expressions * Lab 1: Formatting Reports 4 - GROUPING REPORT DATA * Group Data in Reports * Group Data Using an Expression * Creating Subgroups and Group Aggregates * Lab 1: Creating Reports with Groups and Aggregates 5 - MATRIX REPORTS * Creating and Modifying Matrix Data Regions * Creating and Modifying Column Groups * Lab 1: Creating Matrix Reports 6 - CHARTS * Create and Modify Chart Wizard Reports * Add Charts to Existing Reports * Modify Charts in Reports * Lab 1: Creating Charts and Chart Reports 7 - PRINTING AND EXPORTING REPORTS * Print Features and Print Options * Export Reports * Lab 1: Printing and Exporting Reports

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Overview In this course, you will create complex reports using tools in Crystal Reports 2016. You will: Create automatic and manual running totals. Work with cross-tab reports. Add subreports. Create drill-downs in a report. Use SQL statements in report processing. Create complex formulas. Add charts to reports. Enhance report functionality. In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency. 1 - CREATING RUNNING TOTALS * Topic A: Create a Running Total Field * Topic B: Modify a Running Total Field * Topic C: Create a Manual Running Total 2 - WORKING WITH CROSS-TABS * Topic A: Create a Cross-Tab Report * Topic B: Format a Cross-Tab Report * Topic C: Create Groups in Cross-Tab Reports 3 - ADDING SUBREPORTS * Topic A: Insert a Subreport * Topic B: Edit a Subreport * Topic C: Share Variables 4 - CREATING DRILL-DOWNS IN A REPORT * Topic A: Create a Drill-Down * Topic B: Create Headings for Drill-Down Data 5 - USING SQL STATEMENTS IN REPORT PROCESSING * Topic A: Create a Report Using SQL Queries * Topic B: Summarize Report Data * Topic C: Create Joins Using SQL * Topic D: Create Subqueries * Topic E: Create an SQL Expression Field 6 - CREATING COMPLEX FORMULAS * Topic A: Work with Loops * Topic B: Work with Arrays 7 - ADDING CHARTS TO REPORTS * Topic A: Create Charts * Topic B: Create a Chart with Drill-Down * Topic C: Create a Top N Chart * Topic D: Create a Cross-Tab Chart * Topic E: Create Charts for Grouped Data * Topic F: Format a Chart * Topic G: Create a Chart Template 8 - ENHANCING REPORT FUNCTIONALITY * Topic A: Organize Data Based on a Hierarchy * Topic B: Create a Dynamic Image * Topic C: Create a Report Alert * Topic D: Create a Geographic Map 9 - APPENDIX * Appendix A: Managing Reports * Appendix B: Processing Data on the Server * Appendix C: Detecting and Fixing Problems

Duration 5 Days 30 CPD hours This course is intended for This course is for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). These EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses, or intends to use, the latest release of Configuration Manager to manage and deploy PCs, devices, and applications.This course also is for individuals who are interested in taking Exam 70-703: Administering System Center Configuration Manager and Cloud Services Integration. Courses 20703-1A and 20703-2A, or equivalent knowledge and skills, are necessary to prepare for this exam. Overview After completing this course, students will be able to:Describe the features Configuration Manager and Intune include, and explain how you can use these features to manage PCs and mobile devices in an enterprise environment.Analyze data by using queries and reports.Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Microsoft Exchange Server.Deploy and manage the Configuration Manager client.Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering.Identify and configure the most appropriate method to distribute and manage content used for deployments.Distribute, deploy, and monitor applications for managed users and systems.Maintain software updates for PCs that Configuration Manager manages.Implement Endpoint Protection for managed PCs.Manage configuration items, baselines, and profiles to assess and configure compliance settings and data access for users and devices.Configure an operating-system deployment strategy by using Configuration Manager.Manage and maintain a Configuration Manager site. This course describes how to use Configuration Manager and its associated site systems to efficiently manage network resources. In this five-day course, you will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize System Center Endpoint Protection, manage compliance, and create management queries and reports. Additionally, this course, in conjunction with Microsoft Official Course 20703-2A, helps certification candidates prepare for Exam 70-703: Administering System Center Configuration Manager and Cloud Services Integration. MANAGING COMPUTERS AND MOBILE DEVICES IN THE ENTERPRISE * Overview of systems management by using enterprise management solutions * Overview of the Configuration Manager architecture * Overview of the Configuration Manager administrative tools * Tools for monitoring and troubleshooting a Configuration Manager site * Lab : Exploring the Configuration Manager tools * Searching in the Configuration Manager console * Using Windows PowerShell with Configuration Manager * Using Configuration Manager Service Manager to manage components * Monitoring site and component status * Reviewing log files by using the Configuration Manager Trace tool * Explain how to use Configuration Manager to address the challenges of managing systems and users in today?s enterprise. * Describe the Configuration Manager architecture. * Describe the management tools that you use to perform administrative functions for Configuration Manager. * Describe the tools that you use to monitor and troubleshoot a Configuration Manager site. ANALYZING DATA USING QUERIES AND REPORTS * Introduction to queries * Configuring Microsoft SQL Server Reporting Services (SSRS) * Lab : Creating and running queriesConfiguring boundaries and resource discovery * Creating data queries * Creating subselect queries * Creating status message queries * Lab : Configuring SSRS * Configuring a reporting services point * Creating a report by using Report Builder * Create and configure data and status message queries. * Configure and manage SSRS and the reporting services point. PREPARING THE MANAGEMENT INFRASTRUCTURE TO SUPPORT PCS AND MOBILE DEVICES * Configuring site boundaries and boundary groups * Configuring resource discovery * Configuring the Exchange Server Connector for mobile device management * Configuring user and device collections * Lab : Configuring boundaries and resource discovery * Configuring boundaries, boundary groups, and fallback relationships * Configuring Active Directory discovery methods * Lab : Configuring user and device collections * Creating a device collection * Creating a user collection * Configuring a maintenance window * Configure boundaries and boundary groups. * Configure resource discovery. * Configure the Exchange Server connector mobile device management. * Organize resources using device and user collections. DEPLOYING AND MANAGING CLIENTS * Overview of the Configuration Manager client * Deploying the Configuration Manager client * Configuring and monitoring client status * Managing client settings in Configuration Manager * Lab : Deploying the Microsoft System Center Configuration Manager client software * Preparing the site for client installation * Deploying the Configuration Manager client software by using client push installation * Lab : Configuring and monitoring client status * Configuring and monitoring client health status * Lab : Managing client settings * Configuring client settings * Describe the requirements and considerations for installing the Configuration Manager client software. * Deploy the Configuration Manager client software. * Configure and monitor client status. * Manage Configuration Manager client settings. MANAGING INVENTORY FOR PCS AND APPLICATIONS * Overview of inventory collection * Configuring hardware and software inventory * Managing inventory collection * Configuring software metering * Configuring and managing Asset Intelligence * Lab : Configuring and managing inventory collection * Configuring and managing hardware inventory * Lab : Configuring software metering * Configuring software metering * Lab : Configuring and managing Asset Intelligence * Preparing the site for Asset Intelligence * Configuring Asset Intelligence * Monitoring license agreements by using Asset Intelligence * Viewing Asset Intelligence reports * Describe inventory collection. * Configure and collect hardware and software inventory. * Manage inventory collection. * Configure software metering. * Configure Asset Intelligence. DISTRIBUTING AND MANAGING CONTENT USED FOR DEPLOYMENTS * Preparing the infrastructure for content management * Distributing and managing content on distribution points * Lab : Distributing and managing content for deployments * Installing a new distribution point * Managing content distribution * Prepare the infrastructure for content management. * Distribute and manage content on distribution points. DEPLOYING AND MANAGING APPLICATIONS * Overview of application management * Creating applications * Deploying applications * Managing applications * Deploying virtual applications by using System Center Configuration Manager (Optional) * Deploying and managing Windows Store apps * Lab : Creating and deploying applications * Installing and configuring the Application Catalog roles * Creating applications with requirements * Deploying applications * Lab : Managing application supersedence and removal * Managing application supersedence * Uninstalling the Excel Viewer application * Lab : Deploying virtual applications by using Configuration Manager (Optional) * Configuring support for App-V * Deploying virtual applications * Lab : Using Configuration Manager to deploy Windows Store apps * Configuring support for sideloading Windows Store apps * Configuring a Windows Store app * Deploying Windows 10 apps to users * Describe the application management features of Configuration Manager. * Create applications. * Deploy applications. * Manage applications. * Configure and deploy virtual applications. * Configure and deploy Windows Store apps. MAINTAINING SOFTWARE UPDATES FOR MANAGED PCS * The software updates process * Preparing a Configuration Manager site for software updates * Managing software updates * Configuring automatic deployment rules * Monitoring and troubleshooting software updates * Lab : Configuring the site for software updates * Configuring and synchronizing the software update point * Lab : Deploying and managing software updates * Determining software update compliance * Deploying software updates to clients * Configuring automatic deployment rules * Describe how the software updates feature integrates with Configuration Manager. * Prepare the Configuration Manager site for software updates. * Manage the evaluation and deployment of software updates. * Configure automatic deployment rules. * Monitor and troubleshoot software updates. IMPLEMENTING ENDPOINT PROTECTION FOR MANAGED PCS * Overview of Endpoint Protection in Configuration Manager * Configuring, deploying, and monitoring Endpoint Protection policies * Lab : Implementing Microsoft System Center Endpoint Protection * Configuring the System Center Endpoint Protection point and client settings * Configuring and deploying Endpoint Protection policies * Monitoring Endpoint Protection * Configure Endpoint Protection to detect and remediate malware and security vulnerabilities. * Configure, deploy, and manage Endpoint Protection policies. MANAGING COMPLIANCE AND SECURE DATA ACCESS * Overview of Compliance Settings * Configuring compliance sett

DESCRIPTION: The 70-246 - Monitoring and Operating a Private Cloud with System Center 2012 R2 (MCSE) course teaches you how to monitor and operate a private cloud with System Center 2012 R2. Throughout the course, you will learn the basics of the cloud, the ways of working with the business cloud, cloud services, monitoring and automating responses. The course will teach you how to handle problems in the Private Cloud, and the procedures of Service Management in the Private Cloud. You will also be introduced to cloud protection, recovery, compliance, the use of SLAs, Dashboards and Widgets. The course shows you the real-time state using Visio, system centre analytics, service level tracking, viewing SSRS and Excel to view data, PerformancePoint and configuring and deploying widgets and dashboards. Finally, you will learn cleaning up system centre databases systems. After completing the course, you will understand how Operations Manager handles monitoring, Service Manager and App Controller facilitate self-service, and Orchestrator glues everything together. ASSESSMENT: * At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. * Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. CERTIFICATION: * After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. * Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. WHO IS THIS COURSE FOR? 70-246 - Monitoring and Operating a Private Cloud with System Center 2012 R2 (MCSE) training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. REQUIREMENTS Our 70-246 - Monitoring and Operating a Private Cloud with System Center 2012 R2 (MCSE) course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. CAREER PATH After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. System Center 2012 What is System Center 2012 FREE 00:30:00 Introducing the Cloud Discussion of Cloud Computing 00:19:00 Important Requirements 00:07:00 Working with System Center and the Infrastructure 00:05:00 Maintaining the Cloud Health 00:05:00 How Components are Integrated 00:06:00 Are You in Compliance 00:05:00 Working with the Business Cloud Examining SC 2012 VMM 00:17:00 Working with VMs with the VMM 00:11:00 Creating Clouds for Business 00:16:00 Cloud Services Looking at Service Templates and VMM Profiles 00:22:00 Web Deploy Packages 00:08:00 Server App V Introduction 00:05:00 The Data of the N Tier Application 00:05:00 What's New with VMM R2 00:07:00 Importing and Deploying the Stock trader Application 00:10:00 Installing SQL Server 00:10:00 Monitoring Overview of Operations Manager 00:20:00 Customize the Monitoring Operations 00:09:00 Monitoring Application Performance 00:14:00 Advanced Monitoring 00:04:00 Using Operations Manager for Applications 00:04:00 Using Operations Manager for the Network 00:11:00 Using Operations Manager for Distributed Applications 00:07:00 What's New in Operations Manager 2012 R2 00:09:00 Deploying an Agent 00:09:00 Configuration for Custom Monitoring 00:11:00 Configuring Basic Monitoring and Application Perfomance 00:12:00 Installing Operations Manager 00:05:00 Automating Responses Looking at Orchestrator 2012 00:08:00 Putting Orchestrator, Operations Manager, and Service Manager Together 00:15:00 What's New with Orchestrator 2012 R2 00:04:00 Managing Problems in the Private Cloud What is Problem Management 00:07:00 Using Custom Rules 00:08:00 Service Management in the Private Cloud Service Manager Introduction 00:10:00 Security Settings 00:09:00 Work Items 00:08:00 Incident Queues and Service Offerings 00:03:00 What's New with Service Manager 2012 R2 00:01:00 Configuring the Incident Template 00:10:00 Cloud Protection, Recovery, and Compliance Protecting and Recovering Data for the Private Cloud 00:29:00 Data Recovery 00:15:00 Overview of the Process Pack for IT GRC 00:14:00 Installing the Process Pack for IT GRC 00:06:00 Implementing an IT GRC Control Management Program 00:06:00 How to Maintain Compliance Through VMM Security Baselines with System Center 00:06:00 What's New with DPM 2012 R2 Advisor 00:03:00 Configuring Manual Protection 00:06:00 SLAs, Dashboards and Widgets Configuring and Deploying Widgets and Dashboards 00:12:00 Real-Time State Using Visio 00:10:00 System Center Analytics 00:12:00 Service Level Tracking 00:05:00 Viewing SSRS and Excel to View Data 00:04:00 PerformancePoint 00:04:00 Cleaning Up System Center Databases Service Manager Groom Settings 00:08:00 View and Purge Orchestrator Runbook Logs 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Empower yourself with the essential knowledge and practical skills needed to intervene effectively in suicidal situations. Our Suicide Intervention Skills Training course covers the spectrum from understanding suicide and risk assessment to implementing evidence-based strategies. Ideal for professionals in healthcare, mental health, education, and community services, this course ensures you leave with the confidence to make a positive impact and contribute to suicide prevention. Join us and gain the tools to save lives.

Duration 5 Days 30 CPD hours This course is intended for This course is for experienced information technology (IT) professionals, typically described as Enterprise Desktop Administrators (EDAs). These EDAs deploy, manage, and maintain PCs, devices, and applications across medium, large, and enterprise organizations. A significant portion of this audience uses, or intends to use, the latest release of Configuration Manager to manage and deploy PCs, devices, and applications. Overview After completing this course, students will be able to: •Analyze data by using queries and reports. •Prepare a management infrastructure, including configuring boundaries, boundary groups, and resource discovery, and integrating mobile-device management with Microsoft Exchange Server. •Deploy and manage the Configuration Manager client. •Configure, manage, and monitor hardware and software inventory, and use Asset Intelligence and software metering. •Identify and configure the most appropriate method to distribute and manage content used for deployments. •Distribute, deploy, and monitor applications for managed users and systems. •Maintain software updates for PCs that Configuration Manager manages. •Implement Endpoint Protection for managed PCs. •Manage configuration items, baselines, and profiles to assess and configure compliance settings and data access for users and devices. •Configure an operating-system deployment strategy by using Configuration Manager. •Manage and maintain a Configuration Manager site. In this course, students will learn day-to-day management tasks, including how to manage applications, client health, hardware and software inventory, operating system deployment, and software updates by using Configuration Manager. You also will learn how to optimize System Center Endpoint Protection, manage compliance, and create management queries and reports. MANAGING COMPUTERS AND MOBILE DEVICES IN THE ENTERPRISE * Overview of systems management by using enterprise management solutions * Overview of the Configuration Manager architecture * Overview of the Configuration Manager administrative tools * Tools for monitoring and troubleshooting a Configuration Manager site * Lab : Exploring the Configuration Manager tools ANALYZING DATA USING QUERIES, REPORTS, AND CMPIVOT * Introduction to queries * Configuring SQL Server Reporting Services * Analyzing the real-time state of a device by using CMPivot * Lab : Creating and running queries * Lab : Configuring SSRS * Lab : Analyzing the real-time state of a device by using CMPivot PREPARING THE CONFIGURATION MANAGER MANAGEMENT INFRASTRUCTURE * Configuring site boundaries and boundary groups * Configuring resource discovery * Organizing resources using device and user collections * Lab : Configuring boundaries and resource discovery * Lab: Configuring user and device collections DEPLOYING AND MANAGING THE CONFIGURATION MANAGER CLIENT * Overview of the Configuration Manager client * Deploying the Configuration Manager client * Configuring and monitoring client status * Managing client settings and performing management operations * Lab : Deploying the Microsoft System Center Configuration Manager client software * Lab: Configuring and monitoring client status * Lab : Managing client settings MANAGING INVENTORY FOR PCS AND APPLICATIONS * Overview of inventory collection * Configuring hardware and software inventory * Managing inventory collection * Configuring software metering * Configuring and managing Asset Intelligence * Lab : Configuring and managing inventory collection * Lab : Configuring software metering * Lab : Configuring and managing Asset Intelligence DISTRIBUTING AND MANAGING CONTENT USED FOR DEPLOYMENTS * Preparing the infrastructure for content management * Distributing and managing content on distribution points * Lab : Distributing and managing content for deployments DEPLOYING AND MANAGING APPLICATIONS * Overview of application management * Creating applications * Deploying applications * Managing applications * Deploying virtual applications by using System Center Configuration Manager (Optional) * Deploying and managing Windows Store apps * Lab : Creating and deploying applications * Lab : Managing application supersedence and removal * Lab : Deploying virtual applications by using Configuration Manager (Optional) * Lab : Using Configuration Manager to deploy Windows Store apps MAINTAINING SOFTWARE UPDATES FOR MANAGED PCS * The software updates process * Preparing a Configuration Manager site for software updates * Managing software updates * Configuring automatic deployment rules * Monitoring and troubleshooting software updates * Enabling third-party updates * Lab : Configuring the site for software updates * Lab : Deploying and managing software updates IMPLEMENTING ENDPOINT PROTECTION FOR MANAGED PCS * Overview of Endpoint Protection in Configuration Manager * Configuring, deploying, and monitoring Endpoint Protection policies * Configuring and deploying advanced threat policies * Lab : Implementing Microsoft System Center Endpoint Protection * Lab : Implementing advanced threat policies MANAGING COMPLIANCE AND SECURE DATA ACCESS * Overview of Compliance Settings * Configuring compliance settings * Viewing compliance results * Managing resource and data access * Lab : Managing compliance settings MANAGING OPERATING SYSTEM DEPLOYMENT * An overview of operating system deployment * Preparing a site for operating system deployment * Deploying an operating system * Managing Windows as a service * Lab : Preparing the site for operating -system deployment * Lab : Deploying operating -system images for bare-metal installations MANAGING AND MAINTAINING A CONFIGURATION MANAGER SITE * Configuring role-based administration * Configuring Remote Tools * Overview of Configuration Manager site maintenance * Backing up and recovering a Configuration Manager site * Lab : Configuring role-based administration * Lab : Configuring Remote Tools * Lab : Maintaining a Configuration Manager site ADDITIONAL COURSE DETAILS: Nexus Humans 20703-1 Administering System Center Configuration Manager training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 20703-1 Administering System Center Configuration Manager course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

DESCRIPTION A private cloud involves a distinct and secure cloud-based environment where only the specified client can operate the system. With the knowledge of Private Cloud, you can able to work efficiently to deploy, use, and manage VMs, applications, and other IT resources on hardware to your organization. If you want to gain mastery over cloud computing, the course is for you. The course is divided into two parts that deals with the two certifications of MCSE: Exam 70-246 and Exam 70- 247. In the Exam 70-246, you will know the basics of the cloud, cloud services, monitoring and automating responses while in the Exam 70-247 part, you will learn how to work with the cloud. In short, at first, you will learn the basic cloud concept, then you will know how to use the cloud system. ASSESSMENT: * At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. * Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. CERTIFICATION: * After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. * Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. WHO IS THIS COURSE FOR? Private Cloud with System Center 2012 R2 - Complete Video Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. REQUIREMENTS Our Private Cloud with System Center 2012 R2 - Complete Video Training is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. CAREER PATH After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. System Center 2012 What is System Center 2012 FREE 00:30:00 Introducing the Cloud Discussion of Cloud Computing 00:19:00 Important Requirements 00:07:00 Working with System Center and the Infrastructure 00:05:00 Maintaining the Cloud Health 00:05:00 How Components are Integrated 00:06:00 Are You in Compliance 00:05:00 Working with the Business Cloud Examining SC 2012 VMM 00:17:00 Working with VMs with the VMM 00:11:00 Creating Clouds for Business 00:16:00 Cloud Services Looking at Service Templates and VMM Profiles 00:22:00 Web Deploy Packages 00:08:00 Server App V Introduction 00:05:00 The Data of the N Tier Application 00:05:00 What's New with VMM R2 00:07:00 Monitoring Overview of Operations Manager 00:20:00 Customize the Monitoring Operations 00:09:00 Monitoring Application Performance 00:14:00 Advanced Monitoring 00:04:00 Using Operations Manager for Applications 00:04:00 Using Operations Manager for the Network 00:11:00 Using Operations Manager for Distributed Applications 00:07:00 What's New in Operations Manager 2012 R2 00:09:00 Automating Responses Looking at Orchestrator 2012 00:08:00 Putting Orchestrator, Operations Manager, and Service Manager Together 00:15:00 What's New with Orchestrator 2012 R2 00:04:00 Managing Problems in the Private Cloud What is Problem Management 00:07:00 Using Custom Rules 00:08:00 Service Management in the Private Cloud Service Manager Introduction 00:10:00 Security Settings 00:09:00 Work Items 00:08:00 Incident Queues and Service Offerings 00:03:00 What's New with Service Manager 2012 R2 00:01:00 Cloud Protection, Recovery, and Compliance Protecting and Recovering Data for the Private Cloud 00:29:00 Overview of the Process Pack for IT GRC 00:14:00 Installing the Process Pack for IT GRC 00:06:00 Implementing an IT GRC Control Management Program 00:06:00 How to Maintain Compliance Through VMM Security Baselines with System Center 00:06:00 What's New with DPM 2012 R2 Advisor 00:03:00 SLAs, Dashboards and Widgets Configuring and Deploying Widgets and Dashboards 00:12:00 Real-Time State Using Visio 00:10:00 System Center Analytics 00:12:00 Service Level Tracking 00:05:00 Viewing SSRS and Excel to View Data 00:04:00 PerformancePoint 00:04:00 Cleaning Up System Center Databases Service Manager Groom Settings 00:08:00 View and Purge Orchestrator Runbook Logs 00:08:00 Understanding the Private Cloud Understanding the Private Cloud FREE 00:09:00 Preparing to Deploy the Cloud 00:06:00 Components of the Private Cloud 00:13:00 System Center 2012 Components 00:13:00 Using Hyper-V with VMM 00:07:00 Using VMM to Deploy the Cloud VMM Architecture 00:16:00 Install and_or Upgrade VMM 00:08:00 Host Groups 00:13:00 Understanding Security 00:06:00 Whats New with VMM R2 00:10:00 Working With the Private Cloud Infrastructure PXE and Update Servers 00:08:00 Bare Metal Hyper-V Host Servers 00:06:00 Configuring the Update Server Role 00:08:00 The Update Baseline 00:10:00 Virtual Applications Dynamic Application Deployment 00:10:00 Server Application Virtualization Overview 00:16:00 Configuring Server App-V Components 00:05:00 Sequencing and Deploying Virtual Apps 00:08:00 Components of the Private Cloud SQL Server Profiles 00:08:00 OS Profiles 00:05:00 Application Profiles 00:04:00 Hardware Profiles 00:07:00 VM Templates 00:05:00 Self-Service User Role 00:10:00 A First Business Unit Cloud What is Private Cloud Computing 00:08:00 Installing and Configuring App Controller 00:05:00 Creating and Managing Services and Service Templates 00:11:00 Changes with App Controller 2012 R2 00:01:00 Private Cloud Infrastructure Operations Manager Components 00:25:00 Upgrading 00:10:00 Notifications 00:07:00 Management Packs 00:15:00 Putting It All Together 00:06:00 What's New in Operations Manager 2012 R2 00:09:00 Monitoring the Private Cloud Using SharePoint 00:04:00 Templates for Monitoring 00:23:00 Watching a Distributed App 00:07:00 Service Management for the Cloud What is Service Manager 00:15:00 Understanding Work Items 00:19:00 Connectors 00:08:00 Notifications 00:03:00 Private Cloud Service Catalog Private Cloud Service Catalog 00:10:00 Service Level Management 00:03:00 Automation in the Private Cloud Planning DPM Deployment 00:11:00 DPM Technologies 00:07:00 Upgrading DPM 00:03:00 Configuring DPM for the Private Cloud 00:13:00 Configuring Application Protection for the Private Cloud 00:11:00 What's New with DPM 2012 R2 00:03:00 Security for the Cloud Orchestrator Architecture 00:08:00 Deployment and Configuration of Orchestrator 00:07:00 Using Runbooks 00:07:00 Using Integration Packs 00:17:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 2 Days 12 CPD hours This course is intended for This SQL training course is designed for students new to writing SQL queries. Overview Upon successful completion of this course, students will be able to: - Understand how relational databases work - Use SQL to output reports - Write queries to obtain data from multiple tables. Students will learn SQL to build applications or to generate business reports.The SQL learned in the course is applicable to all major databases. RELATIONAL DATABASE BASICS * Brief History of SQL * Relational Databases * Popular Databases * SQL Statements SIMPLE SELECTS * Introduction to the Northwind Database * Some Basics * SELECTing All Columns in All Rows * Exploring the Tables * SELECTing Specific Columns * Sorting Records * The WHERE Clause and Operator Symbols * Using the WHERE clause to check for equality or inequality * Using the WHERE clause to check for greater or less than * Checking for NULL * Using WHERE and ORDER BY Together * The WHERE Clause and Operator Words * More SELECTs with WHERE * Checking Multiple Conditions * Writing SELECTs with Multiple Conditions ADVANCED SELECTS * Calculated Fields * Calculating Fields * Aggregate Functions and Grouping * Working with Aggregate Functions * Built-in Data Manipulation Functions * Data Manipulation Functions SUBQUERIES, JOINS AND UNIONS * Subqueries * Joins * Using Joins * Outer Joins * Unions * Working with Unions IF TIME ALLOWS, ONE OR MORE OF THE FOLLOWING MAY BE COVERED: * Conditional Processing with CASE * INSERT, UPDATE, DELETE * Student Challenges - Design your own reports