743 SQL courses

Get to grips with real-time stream processing using PySpark as well as Spark structured streaming and apply that knowledge to build stream processing solutions. This course is example-driven and follows a working session-like approach.

Prepare for the AWS Certified Solutions Architect - Associate (SAA-C03) exam. Learn about the AWS Management Console, S3 buckets, instances, database services, cloud security, costs associated with AWS, Amazon Elastic Compute Cloud (EC2), Amazon Virtual Private Cloud (VPC), Amazon Simple Storage Service (S3), and Amazon Elastic Block Store (EBS).

This comprehensive course unlocks the boundless potential of LangChain, Pinecone, OpenAI, and LLAMA 2 LLM, guiding you from AI novice to expert. Dive into 15 different practical projects, from dynamic chatbots to data analysis tools, and cultivate a profound understanding of AI, empowering your journey into the future of language-based applications.

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Flutter & Dart Development Course Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Flutter & Dart Development Course Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Flutter & Dart Development Course Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Flutter & Dart Development Course Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Flutter & Dart Development Course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Flutter & Dart Development Course there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Flutter & Dart Development Course course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Flutter & Dart Development Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Flutter & Dart Development Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Flutter & Dart Development Course is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Introduction 00:02:00 Setup On Windows 00:16:00 Setup On Linux 00:14:00 Setup On Mac iOS 00:14:00 Setup On Mac Android 00:12:00 App Base Code 00:03:00 Section 02: Widgets Text 00:04:00 Container 00:04:00 Row 00:05:00 Column 00:02:00 Stack 00:02:00 Image 00:06:00 Center 00:02:00 Padding 00:03:00 Align 00:02:00 Constrained Box 00:03:00 Baseline Class 00:03:00 Aspect Ratio 00:03:00 Sized Box 00:02:00 Transform 00:03:00 Section 03: Gestures Pointers 00:06:00 Tap 00:02:00 Double Tap 00:02:00 Long Press 00:03:00 Vertical Drag 00:04:00 Horizontal Drag 00:04:00 Pan 00:04:00 Section 04: Navigation Components Scaffold 00:06:00 App bar 00:05:00 Bottom Navigation Bar 00:08:00 TabBar View 00:07:00 Drawer 00:05:00 SliverApp Bar 00:07:00 Section 05: Input/Selection Components FlatButton 00:04:00 RaisedButton 00:03:00 DropdownButton 00:09:00 TextField 00:04:00 CheckBox 00:06:00 Radio Button 00:04:00 PopupMenuButton 00:07:00 IconButton 00:04:00 ButtonBar 00:03:00 Floating Action Button 00:04:00 Switch 00:04:00 Slider 00:05:00 Date Picker 00:05:00 Time Picker 00:07:00 SimpleDialog 00:08:00 AlertDialog 00:06:00 BottomSheet 00:06:00 Expansion Panel List and Expansion Panel 00:07:00 SnackBar 00:07:00 Cupertino Setup 00:02:00 Cupertino Action Sheet 00:06:00 Cupertino Activity Indicator 00:01:00 Cupertino Alert Dialog 00:04:00 Cupertino Button 00:03:00 CupertinoPageScaffold 00:04:00 CupertinoPicker 00:04:00 CupertinoPopupSurface 00:04:00 CupertinoSegmentedControl 00:04:00 CupertinoSlider 00:04:00 CupertinoSwitch 00:03:00 CupertinoNavigationBar 00:04:00 CupertinoTabBar 00:05:00 CupertinoTabScaffold 00:04:00 CupertinoTextField 00:04:00 Section 06: Information Displays Icons 00:04:00 Chip 00:03:00 Tooltip 00:02:00 DataTable 00:09:00 Card 00:06:00 Linear Progress Indicator 00:03:00 Circular Progress Indicator 00:04:00 Section 07: Layout GridView 00:03:00 ListView & ListTile 00:04:00 Stepper & Step 00:07:00 Divider & divideTiles 00:05:00 Aligning Widgets 00:03:00 Sizing Widgets 00:03:00 Sizing Widgets 00:03:00 Add, Update and Delete Widgets 00:06:00 Section 08: Navigation & Routing Navigate To A New Screen and Back 00:06:00 Multiple Files For Each Screen 00:03:00 Send Data To A New Screen 00:05:00 Return Data From A Screen 00:05:00 Navigate With Named Routes 00:03:00 Animating A Widget Across Screens 00:02:00 Stateless vs Stateful Widgets 00:08:00 Section 09: Animation Tween Animation 00:07:00 Staggered Animation 00:04:00 Reverse and Stop Animations 00:02:00 Section 10: Platform Specific Code Call Android Java Code 00:08:00 Send Parameters To Android Java Code 00:07:00 Call Android Kotlin Code 00:08:00 Send Parameters To Android Kotlin Code 00:05:00 Call iOS Objective-C Code 00:10:00 Send Parameters To iOS Objective-C Code 00:05:00 Call iOS Swift Code 00:08:00 Send Parameters To iOS Swift Code 00:05:00 Section 11: Building & Releasing Remove Debug Badge 00:01:00 Build & Release For Android 00:04:00 Build & Release For iOS 00:06:00 Section 12: Networking Fetch Data From The Internet 00:13:00 Making authenticated requests using HTTP Headers 00:03:00 Parsing JSON In The Background 00:17:00 Working With WebSockets 00:10:00 Section 13: Data Persistence Reading & Writing Files On The Server Using SQL Injection Vulnerability 00:06:00 Storing Key-Value Data On Disk 00:03:00 Data Persistence Using SQLite 00:04:00 Section 14: Creating An App Calculator Part 1 - TabBar Creation 00:12:00 Calculator Part 2 - Implementing The Tabs 00:05:00 Calculator Part 3 - Tab Persistence 00:03:00 Changing Android App Icon 00:05:00 Changing iOS App Icon 00:01:00 Change App Display Name 00:05:00 Assignment Assignment - Flutter & Dart Development Course 00:00:00

Duration 3 Days 18 CPD hours This course is intended for This introductory-level course is for experienced DBAs who will be working with MongoDB. In order to gain the most from this course you should have: Prior practical experience in Database Administration Experience working with Linux and be comfortable working with command line Overview This skills-focused course is approximately 50% hands-on. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will explore: The MongoDB Basic Architecture and Installation MongoDB administration User Management MongoDB security Indexes Backup & Recovery High Availability / Replication Diagnostics & Troubleshooting MongoDB is fast becoming the database of choice for big data applications, being one of the most popular and widely implemented NoSQL databases. Its scalability, robustness, and flexibility have made it extremely popular among business enterprises who use it to implement a variety of activities including social communications, analytics, content management, archiving and other activities. This has led to an increased demand for MongoDB administrators who have the skills to handle cross functional duties. Geared for experienced DBAs, MongoDB for DBAs is a three-day hands-on course that explores the concepts, architecture and pitfalls of managing a MongoDB installation. This course is targeted to the DBA who is familiar with the concepts and tasks of working with a Relational database and is not responsible for a NoSQL MongoDB database. You will learn the critical aspects of MongoDB and use it to solve data management challenges. You will learn to manage MongoDB effectively by gaining expertise in MongoDB administration tools, syntax, MongoDB installations, configurations, security, troubleshooting, backup, scaling and many other features. The focus of this course is on practical skills and applying the DBA existing database knowledge to a MongoDB installation. Introduction to MongoDB Basic Architecture and Installation Differentiate database categories Learn MongoDB design goals List MongoDB tools Describe JSON and BSON Understanding the basic concepts of a Database Database categories: What is NoSQL? Why NoSQL? Benefit over RDBMS Types of NoSQL Database, and NoSQL vs. SQL Comparison, ACID & Base Property CAP Theorem, implementing NoSQL and what is MongoDB? Graph Database Overview of MongoDB, Design Goals for MongoDB Server and Database, MongoDB tools Understanding the following: Collection, Documents and Key/Values, etc., Introduction to JSON and BSON documents Environment setup (live Handson) and using various MongoDB tools available in the MongoDB Package MongoDB Administration Take database backup and restore MongoDB© Export and import data from/ to a MongoDB© instance Check server status and DB status Monitor various resource utilization of a mongod instance Understand various optimization strategies Administration concepts in MongoDB Monitoring issues related to Database Monitoring at Server, Database, Collection level, and various Monitoring tools related to MongoDB Database Profiling, Locks, Memory Usage, No of connections, page fault etc., Backup and Recovery Methods for MongoDB Export and Import of Data to and from MongoDB Run time configuration of MongoDB Production notes/ best practices Data Managements in MongoDB (Capped Collections/ Expired data from TTL), TTL Collection Features GridFS Memory-Mapped Files Journaling Mechanics Storage Engines Power of 2-Sized Allocations No Padding Allocation Strategy Diagnosing Performance Issues Optimization Strategies for MongoDB Configure Tag Sets for Replica Set. Optimize Query Performance Monitoring Strategies for MongoDB . MongoDB Utilities MongoDB Commands MongoDB Management Service (MMS) Data Backup Strategies in MongoDB Copying Underlying Data Files Backup with MongoDump Fsync and Lock MongoDB Ops Manager Backup Software Security Strategies in MongoDB Authentication Implementation in MongoDB . Authentication in a Replica set Authentication on Sharded Clusters Authorization End-to-End Auditing for Compliance User Management Create a User Administrator. Add a User to a Database. Create/Assign User a Role. Verify/Modify a User Access/Privileges. Change a User?s Password MongoDB Security Knowing security concepts in MongoDB Understand how Authentication and Authorisation works Security Introduction Security Concepts Indexes Index Introduction, Index Concepts, Index Types Index Properties Index Creation and Indexing Reference Introduction to Aggregation Aggregation Approach to Aggregation sort Order Pipeline Operators and Indexes Text Indexes Aggregate Pipeline Stages Text Search MapReduce Index Creation Aggregation Operations Index Creation on Replica Set Remove, Modify, and Rebuild Indexes Listing Indexes Measure Index Use Control Index Use Index Use Reporting Geospatial Indexes MongoDB?s Geospatial Query Operators GeoWith Operator Backup & Recovery Import and Export MongoDB Data Restore and recovery of MongoDB(Including point in time Recovery) Restore a Replica Set from MongoDB Backups Recover Data after an Unexpected Shutdown Backup and Restore with Filesystem Snapshots Back Up and Restore with MongoDB Tools Backup and Restore Sharded Clusters High Availability (Replication ) Understand the concept of Replication in MongoDB© ? Create a production like Replica Set Introduction to Replication (High Availability), Concepts around Replication What is Replica Set and Master Slave Replication? Type of Replication in MongoDB How to setup a replicated cluster & managing replica sets etc., Master-Slave Replication Replica Set in MongoDB Automatic Failover Replica Set Members Write Concern Write Concern Levels Write Concern for a Replica Set Modify Default Write Concern Read Preference Read Preference Modes Blocking for Replication Tag Set Configure Tag Sets for Replica set. Replica Set Deployment Strategies . Replica Set Deployment Patterns Oplog File Replication State and Local Database, Replication Administration Diagnostics & Troubleshooting Troubleshoot slow queries Diagnose connectivity problems Understand diagnostic tools Learn common production issues Learn fixes and solutions. Additional course details: Nexus Humans Introduction to MongoDB for DBAs (TTDB4680) 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 Introduction to MongoDB for DBAs (TTDB4680) 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.

This advanced course created by data analysts who use Alteryx daily while working with their clients teaches data cleansing and manipulation, working in databases, apps, and macros, and breaks down Alteryx's latest product, Alteryx Intelligence Suite, which includes ML tools that introduce individuals to the world of AI

This course will show you why Hadoop is one of the best tools to work with big data. With the help of some real-world data sets, you will learn how to use Hadoop and its distributed technologies, such as Spark, Flink, Pig, and Flume, to store, analyze, and scale big data.

We are in such an era where cyber security plays an important part. With systems getting smarter, we are seeing machine learning interrupting computer security. With the adoption of machine learning in upcoming security products, it is important for pentesters and security researchers to understand the working of these systems and how to breach them.

The world is comprised of many different people, with many different cultures, who speak many different languages. Even though English is considered the staple international language, not everyone understands or speaks in English. That is why there is a huge need for people in the world to help others learn this language in order to eliminate the language barrier we have. You could be one of these people with the help of this Teaching English as Foreign Language (TEFL) course. This is a very elaborate course but helps you to become the perfect English teacher to those who don't know it so well. It starts with helping you to teach in different situations - as per needs and constraints - and work with many different approaches for different students. Following that there are specific chapters dedicated to help you teach speaking, listening, reading, writing and grammar in English. You will also learn about creating lesson plans and testing as well. The course is filled with exercises and examples to help you in your way to become a great English as a foreign language teacher. Course Highlights Ultimate PHP & MySQL Web Development & OOP Coding is an award winning and the best selling course that has been given the CPD Qualification Standards & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Ultimate PHP & MySQL Web Development & OOP Coding into 133 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 10 hours, 6 minutes hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Ultimate PHP & MySQL Web Development & OOP Coding Lifetime access to the course No hidden fees or exam charges CPD Qualification Standards certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Ultimate PHP & MySQL Web Development & OOP Coding is CPD Qualification Standards and IAO accredited. 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 backgrounds. Requirements Our Ultimate PHP & MySQL Web Development & OOP Coding 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD Qualification Standards and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Section 01: Introduction & Setup Introduction 00:02:00 Setup On Windows 00:15:00 Setup On Mac 00:11:00 Setup On Linux 00:12:00 Online Code Editor 00:03:00 Section 02: Basics Basic File Syntax 00:05:00 Printing (echo) 00:06:00 Comments 00:05:00 Variables 00:06:00 Variable Data Types 00:07:00 Variable Naming 00:03:00 Constants 00:02:00 Arrays 00:05:00 Associative Arrays 00:06:00 Multidimensional Arrays 00:04:00 Section 03: Control Structures if Statement 00:06:00 if...else Statement 00:02:00 if...elseif...else Statement 00:05:00 Switch Statement 00:06:00 while Loop 00:06:00 do...While Loop 00:03:00 for Loop 00:03:00 foreach Loop 00:05:00 Break Statement 00:02:00 Continue Statement 00:02:00 Section 04: Functions Basic Function 00:03:00 Passing Function Arguments 00:03:00 Passing Function Arguments By Reference 00:04:00 Default Argument Value 00:02:00 Function Returning Values 00:05:00 Dynamic Function Calls 00:03:00 Variable Scope 00:04:00 Section 05: Forms Simple HTML Form 00:07:00 GET vs POST 00:05:00 $_SERVER ['PHP_SELF'] 00:07:00 Validating Form Data With PHP 00:07:00 Required Fields 00:05:00 Display Error Messages 00:05:00 Validate Name 00:03:00 Validate Email 00:03:00 Validate URL 00:07:00 Keep The Values In The Form 00:04:00 Section 06: File Handling Read File (readfile()) 00:02:00 Open, Read & Close A File (fopen(), fread(), fclose()) 00:04:00 Read Single Line (fgets()) 00:03:00 Check End-Of-File (feof()) 00:02:00 Read Single Character (fgetc()) 00:02:00 Write To File (fwrite()) 00:03:00 Configure php.ini File For File Uploading 00:02:00 Front End HTML Upload Form 00:04:00 PHP Upload Script 00:15:00 Check If File Exists 00:03:00 Limit File Size 00:05:00 Limit File Type 00:04:00 Section 07: MySQL MySQL vs MySQLi vs PDO 00:05:00 Creating A Database & Table (phpMyAdmin) 00:06:00 Connecting To A Database 00:06:00 Get Data Using SELECT Query 00:10:00 WHERE Property For Filtering 00:03:00 LIKE Property For Pattern Search 00:02:00 Sorting Results Using ORDER BY Property 00:01:00 Using JOINS 00:08:00 Insert Data Using INSERT Query 00:04:00 Get ID Of The Last Inserted Row 00:02:00 Insert Multiple Rows 00:05:00 Update Data Using UPDATE Query 00:03:00 Delete Data Using DELETE Query 00:02:00 Delete All Rows In A Table Using TRUNCATE Query 00:02:00 Delete Table Using DROP Query 00:02:00 Limit Data Selections Using LIMIT, ROWNUM 00:04:00 Create Table Using CREATE Query 00:03:00 Clone/Duplicate Table 00:03:00 Alter Table 00:05:00 Create Database 00:02:00 Drop Database 00:02:00 SQL Injection & Prepared Statements 00:09:00 Section 08: XML What Is XML? 00:02:00 What Is SimpleXML? 00:02:00 Parse XML String 00:08:00 Parse XML File 00:02:00 Get Node Values 00:02:00 Get Node Values of Specific Elements 00:03:00 Get Node Values - Loop 00:03:00 Get Attribute Values 00:02:00 What Is The XML Expat Parser? 00:02:00 Initializing The XML Expat Parser 00:10:00 Load and Output XML Using DOM Parser 00:02:00 Looping Through XML Using DOM Parser 00:03:00 Section 09: AJAX What Is AJAX? 00:02:00 Load Simple Data Using AJAX Front End 00:08:00 Load Simple Data Using AJAX Back End 00:05:00 Load Data From A Database Using AJAX 00:08:00 Section 10: Emails Send A Plain Text Email 00:04:00 Send A HTML Email 00:06:00 Email Attachments 00:17:00 PHPMailer Setup 00:03:00 Send Email Using PHPMailer 00:04:00 Send HTML Email Using PHPMailer 00:04:00 Email Attachments Using PHPMailer 00:02:00 Section 11: Object Oriented Programming What Is Object Oriented Programming (OOP)? 00:03:00 Basic Class With Variables 00:04:00 Functions 00:05:00 Constructor 00:04:00 Destructor 00:02:00 Inheritance 00:06:00 Multi Class Inheritance 00:03:00 Function Overriding 00:03:00 Public vs Private vs Protected 00:05:00 Interfaces 00:04:00 Constants 00:03:00 Abstract Class 00:06:00 Static Keyword 00:03:00 Final Keyword 00:02:00 Initiating Parent Constructor 00:02:00 Section 12: Error Handling die() Function 00:02:00 Custom Error Handler 00:04:00 Triggering An Exception 00:03:00 Exception Handling 00:05:00 Create Database & Table 00:04:00 User Class & Database Connection 00:15:00 Register User Form 00:09:00 Inserting User Data Into Database 00:10:00 Registration Form Field Validation 00:12:00 Securing User Password 00:03:00 Check If Username or Email Already Exists 00:11:00 Retain Data After Failed Registration 00:03:00 Section 13: Advanced Validate an Integer Within a Range 00:04:00 Validate IPv6 Address 00:03:00 Validate URL - Must Contain QueryString 00:03:00 Remove Characters With ASCII Value > 127 00:04:00 Including & Requiring External PHP Files 00:05:00 Section 14 : Resource Resource 00:00:00 Assignment Assignment - Ultimate PHP & MySQL Web Development & OOP Coding 00:00:00

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