Name: Ethical Hacking Complete Course
Price: 25 GBP
Availability: InStock

<p>The Web Applications for Specialisation on Development is all you need to advance your career in the relevant fields.</p><p>Enrol now to discover everything you need to know about The Web Applications for Specialisation on Development and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!</p><p><strong>Expert Support</strong></p><p>Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.</p><p><strong>Key Benefits</strong></p><ul><li>Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.</li><li>Get 24/7 access to all content for a full year.</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li></ul><p><strong>Course Curriculum:</strong></p><p><strong>Section 01: CSS Introduction</strong></p><ul><li>Introduction</li><li>How to ask a great questions</li><li>Introduction CSS</li><li>Choosing Code Editor</li><li>Installing Code Editor (Sublime Text)</li><li>CSS Syntax</li><li>Creating a first page with CSS Style</li></ul><p><strong>Section 02: CSS Basic</strong></p><ul><li>Inline CSS</li><li>Internal CSS</li><li>External CSS</li><li>CSS Classes</li><li>CSS IDs</li><li>Colors</li><li>Backgrounds</li><li>Floating</li><li>Positioning</li><li>Margins</li><li>Padding</li><li>Borders</li></ul><p><strong>Section 03: CSS Intermediate</strong></p><ul><li>Styling Text</li><li>Aligning Text</li><li>Styling Links</li><li>Font Family</li><li>Font Styles</li><li>Applying Google Fonts</li><li>Box Model</li><li>Icons</li><li>Tables</li><li>Navigation-Menu</li><li>Dropdowns</li></ul><p><strong>Section 04: CSS Advanced</strong></p><ul><li>Advanced Selectors</li><li>Forms</li><li>Website Layout</li><li>Rounded Corners</li><li>Color Keywords</li><li>Animations</li><li>Pseudo Classes</li><li>Gradients</li><li>Shadows</li><li>Calculations</li><li>Creating Responsive Page</li></ul><p><strong>Section 05: CSS Expert</strong></p><ul><li>Button Styles</li><li>Pagination</li><li>Multiple Columns</li><li>Image Reflection</li><li>UI - UX Design</li><li>Social Media Icons</li><li>External CSS Style adding</li></ul><p><strong>Section 06: PHP Introduction</strong></p><ul><li>What is PHP</li><li>Installing XAMPP for PHP, MySQL and Apache</li><li>Installing Code Editor(Visual Studio Code)</li><li>Creating PHP Project on XAMPP</li><li>Hello World Program</li></ul><p><strong>Section 07: PHP Basic</strong></p><ul><li>Variables</li><li>Echo and Print</li><li>Data Types</li><li>Numbers</li><li>Boolean</li><li>Arrays</li><li>Multi-Dimensional Array</li><li>Sorting Arrays</li><li>Constants</li></ul><p><strong>Section 08: PHP Strings</strong></p><ul><li>Strings</li><li>String Formatting</li><li>String Methods</li><li>Coding Exercise</li><li>Solution for Coding Exercise</li></ul><p><strong>Section 09: PHP Operators</strong></p><ul><li>Arithmetic operators</li><li>Assignment operators</li><li>Comparison operators</li><li>Increment - decrement operators</li><li>Logical operators</li><li>Ternary operator</li></ul><p><strong>Section 10: PHP Decision making system</strong></p><ul><li>If statement</li><li>If-else statement</li><li>If-elseif-else statement</li><li>Switch-case statement</li></ul><p><strong>Section 11: PHP Control flow statements</strong></p><ul><li>Flow Chart</li><li>While loop</li><li>Do-while loop</li><li>For loop</li><li>For each loop</li><li>Coding Exercise</li><li>Solution for Coding Exercise</li></ul><p><strong>Section 12: PHP Functions</strong></p><ul><li>Creating a Function</li><li>Function with Arguments</li><li>Default Argument</li><li>Function return values</li><li>Call-by-value</li><li>Call-by-reference</li></ul><p><strong>Section 13: PHP Super globals</strong></p><ul><li>$_POST Method</li><li>$_GET Method</li></ul><p><strong>Section 14: PHP Advanced </strong></p><ul><li>Form Handling</li><li>Date and Time</li><li>Include</li><li>Require</li><li>Sessions</li><li>File Reading</li><li>File Upload</li></ul><p><strong>Section 15: PHP Object oriented programming[OOPs]</strong></p><ul><li>What is OOP</li><li>Class and Objects</li><li>Constructor</li><li>Destructor</li><li>Access Modifiers</li><li>Inheritance</li><li>Method overriding</li><li>Abstract Class</li><li>Interface</li></ul><p><strong>Section 16: PHP - MySQL Application [CRUD]</strong></p><ul><li>MySQL Basic PhpMyAdmin</li><li>Creating Database and Table</li><li>Database Connection</li><li>PHP Form Create records</li><li>PHP Form Reading records</li><li>PHP Form Update Data</li><li>PHP Form Delete records</li></ul><p><strong>Section 17: PHP Real world code forms</strong></p><ul><li>Registration Form</li><li>MD5 Algorithm for Encrypting</li><li>Sha Algorithm</li><li>Login Form</li></ul><p><strong>Section 18: PHP Validations</strong></p><ul><li>On Submit Validation</li><li>Input Numeric Validation</li><li>Login Form Validation</li><li>Form Server-side all Data Validation</li><li>Form Server-side Validation</li></ul><p><strong>Section 19: PHP Error handling</strong></p><ul><li>Try-throw-catch</li><li>Try-throw-catch-finally</li></ul><p><strong>Section 20: MYSQL introduction </strong></p><ul><li>Overview of Databases</li><li>MySQL Installation</li><li>MySQL Workbench Installation</li><li>Connecting to MySQL using Console</li></ul><p><strong>Section 21: MySQL basic</strong></p><ul><li>Overview of Challenges</li><li>SQL Statement Basic</li><li>SELECT Statement</li><li>SELECT DISTINCT</li><li>Column AS Statement</li><li>COUNT function</li></ul><p><strong>Section 22: MySQL filtering data</strong></p><ul><li>SELECT WHERE Clause - One</li><li>SELECT WHERE Clause - Two</li><li>ORDER BY</li><li>LIMIT</li><li>BETWEEN</li><li>IN Operator</li><li>LIKE and ILIKE</li></ul><p><strong>Section 23: MySQL functions</strong></p><ul><li>Overview of GROUP BY</li><li>Aggregation function SUM()</li><li>Aggregation MIN() and MAX()</li><li>GROUP BY - One</li><li>GROUP BY - Two</li><li>HAVING Clause</li></ul><p><strong>Section 24: MySQL joins</strong></p><ul><li>Overview Assessment</li><li>Overview of JOINS</li><li>Introduction to JOINS</li><li>AS Statement table</li><li>INNER JOIN</li><li>FULL Outer Join</li><li>LEFT Outer JOIN</li><li>RIGHT JOIN</li><li>Union</li></ul><p><strong>Section 25: MySQL advanced commands </strong></p><ul><li>Advanced SQL Commands</li><li>Timestamps</li><li>EXTRACT from timestamp</li><li>Mathematical Functions</li><li>String Functions</li><li>SUBQUERY</li></ul><p><strong>Section 26: MySQL structure creation</strong></p><ul><li>Database and Tables</li><li>Data Types</li><li>Primary key and Foreign key</li><li>Create Table in SQL Script</li></ul><p><strong>Section 27: MySQL data queries</strong></p><ul><li>Insert</li><li>Update</li><li>Delete</li></ul><p><strong>Section 28: MySQL structure queries</strong></p><ul><li>Alter Table</li><li>Drop Table</li></ul><p><strong>Section 29: MySQL constraints</strong></p><ul><li>NOT NULL Constraint</li><li>UNIQUE Constraint</li></ul><p><strong>Section 30: MySQL backup and restore</strong></p><ul><li>Overview of Databases and Tables</li><li>Backup database using phpMyAdmin</li><li>Restoring a Database</li></ul><p><strong>Course Assessment </strong></p><p>To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.</p><p>When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.</p><p><strong>Exam &amp; Retakes:</strong><br />It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.</p><p><strong>Certification</strong><br />Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).</p><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This Web Applications for Specialisation on Development course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Web Applications for Specialisation on Development course is open to all, with no formal entry requirements.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon successful completion of The Web Applications for Specialisation on Development Course, learners will be equipped with many indispensable skills and have the opportunity to grab.</p>
                        </div>

One Education

Web Applications for Specialisation on Development Course

General Admission

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>This class is intended for experienced developers who are responsible for managing big data transformations including:<br />Extracting, loading, transforming, cleaning, and validating data.<br />Designing pipelines and architectures for data processing.<br />Creating and maintaining machine learning and statistical models.<br />Querying datasets, visualizing query results and creating reports</p>Overview<p>Design and build data processing systems on Google Cloud Platform.<br />Leverage unstructured data using Spark and ML APIs on Cloud Dataproc.<br />Process batch and streaming data by implementing autoscaling data pipelines on Cloud Dataflow.<br />Derive business insights from extremely large datasets using Google BigQuery.<br />Train, evaluate and predict using machine learning models using TensorFlow and Cloud ML.<br />Enable instant insights from streaming data</p><p>Get hands-on experience with designing and building data processing systems on Google Cloud. This course uses lectures, demos, and hand-on labs to show you how to design data processing systems, build end-to-end data pipelines, analyze data, and implement machine learning. This course covers structured, unstructured, and streaming data.</p></div><div id="course-pills-2"><h4>Introduction to Data Engineering</h4><ul><li>Explore the role of a data engineer.</li><li>Analyze data engineering challenges.</li><li>Intro to BigQuery.</li><li>Data Lakes and Data Warehouses.</li><li>Demo: Federated Queries with BigQuery.</li><li>Transactional Databases vs Data Warehouses.</li><li>Website Demo: Finding PII in your dataset with DLP API.</li><li>Partner effectively with other data teams.</li><li>Manage data access and governance.</li><li>Build production-ready pipelines.</li><li>Review GCP customer case study.</li><li>Lab: Analyzing Data with BigQuery.</li></ul><h4>Building a Data Lake</h4><ul><li>Introduction to Data Lakes.</li><li>Data Storage and ETL options on GCP.</li><li>Building a Data Lake using Cloud Storage.</li><li>Optional Demo: Optimizing cost with Google Cloud Storage classes and Cloud Functions.</li><li>Securing Cloud Storage.</li><li>Storing All Sorts of Data Types.</li><li>Video Demo: Running federated queries on Parquet and ORC files in BigQuery.</li><li>Cloud SQL as a relational Data Lake.</li><li>Lab: Loading Taxi Data into Cloud SQL.</li></ul><h4>Building a Data Warehouse</h4><ul><li>The modern data warehouse.</li><li>Intro to BigQuery.</li><li>Demo: Query TB+ of data in seconds.</li><li>Getting Started.</li><li>Loading Data.</li><li>Video Demo: Querying Cloud SQL from BigQuery.</li><li>Lab: Loading Data into BigQuery.</li><li>Exploring Schemas.</li><li>Demo: Exploring BigQuery Public Datasets with SQL using INFORMATION_SCHEMA.</li><li>Schema Design.</li><li>Nested and Repeated Fields.</li><li>Demo: Nested and repeated fields in BigQuery.</li><li>Lab: Working with JSON and Array data in BigQuery.</li><li>Optimizing with Partitioning and Clustering.</li><li>Demo: Partitioned and Clustered Tables in BigQuery.</li><li>Preview: Transforming Batch and Streaming Data.</li></ul><h4>Introduction to Building Batch Data Pipelines</h4><ul><li>EL, ELT, ETL.</li><li>Quality considerations.</li><li>How to carry out operations in BigQuery.</li><li>Demo: ELT to improve data quality in BigQuery.</li><li>Shortcomings.</li><li>ETL to solve data quality issues.</li></ul><h4>Executing Spark on Cloud Dataproc</h4><ul><li>The Hadoop ecosystem.</li><li>Running Hadoop on Cloud Dataproc.</li><li>GCS instead of HDFS.</li><li>Optimizing Dataproc.</li><li>Lab: Running Apache Spark jobs on Cloud Dataproc.</li></ul><h4>Serverless Data Processing with Cloud Dataflow</h4><ul><li>Cloud Dataflow.</li><li>Why customers value Dataflow.</li><li>Dataflow Pipelines.</li><li>Lab: A Simple Dataflow Pipeline (Python/Java).</li><li>Lab: MapReduce in Dataflow (Python/Java).</li><li>Lab: Side Inputs (Python/Java).</li><li>Dataflow Templates.</li><li>Dataflow SQL.</li></ul><h4>Manage Data Pipelines with Cloud Data Fusion and Cloud Composer</h4><ul><li>Building Batch Data Pipelines visually with Cloud Data Fusion.</li><li>Components.</li><li>UI Overview.</li><li>Building a Pipeline.</li><li>Exploring Data using Wrangler.</li><li>Lab: Building and executing a pipeline graph in Cloud Data Fusion.</li><li>Orchestrating work between GCP services with Cloud Composer.</li><li>Apache Airflow Environment.</li><li>DAGs and Operators.</li><li>Workflow Scheduling.</li><li>Optional Long Demo: Event-triggered Loading of data with Cloud Composer, Cloud Functions, Cloud Storage, and BigQuery.</li><li>Monitoring and Logging.</li><li>Lab: An Introduction to Cloud Composer.</li></ul><h4>Introduction to Processing Streaming Data</h4><ul><li>Processing Streaming Data.</li></ul><h4>Serverless Messaging with Cloud Pub/Sub</h4><ul><li>Cloud Pub/Sub.</li><li>Lab: Publish Streaming Data into Pub/Sub.</li></ul><h4>Cloud Dataflow Streaming Features</h4><ul><li>Cloud Dataflow Streaming Features.</li><li>Lab: Streaming Data Pipelines.</li></ul><h4>High-Throughput BigQuery and Bigtable Streaming Features</h4><ul><li>BigQuery Streaming Features.</li><li>Lab: Streaming Analytics and Dashboards.</li><li>Cloud Bigtable.</li><li>Lab: Streaming Data Pipelines into Bigtable.</li></ul><h4>Advanced BigQuery Functionality and Performance</h4><ul><li>Analytic Window Functions.</li><li>Using With Clauses.</li><li>GIS Functions.</li><li>Demo: Mapping Fastest Growing Zip Codes with BigQuery GeoViz.</li><li>Performance Considerations.</li><li>Lab: Optimizing your BigQuery Queries for Performance.</li><li>Optional Lab: Creating Date-Partitioned Tables in BigQuery.</li></ul><h4>Introduction to Analytics and AI</h4><ul><li>What is AI?.</li><li>From Ad-hoc Data Analysis to Data Driven Decisions.</li><li>Options for ML models on GCP.</li></ul><h4>Prebuilt ML model APIs for Unstructured Data</h4><ul><li>Unstructured Data is Hard.</li><li>ML APIs for Enriching Data.</li><li>Lab: Using the Natural Language API to Classify Unstructured Text.</li></ul><h4>Big Data Analytics with Cloud AI Platform Notebooks</h4><ul><li>What's a Notebook.</li><li>BigQuery Magic and Ties to Pandas.</li><li>Lab: BigQuery in Jupyter Labs on AI Platform.</li></ul><h4>Production ML Pipelines with Kubeflow</h4><ul><li>Ways to do ML on GCP.</li><li>Kubeflow.</li><li>AI Hub.</li><li>Lab: Running AI models on Kubeflow.</li></ul><h4>Custom Model building with SQL in BigQuery ML</h4><ul><li>BigQuery ML for Quick Model Building.</li><li>Demo: Train a model with BigQuery ML to predict NYC taxi fares.</li><li>Supported Models.</li><li>Lab Option 1: Predict Bike Trip Duration with a Regression Model in BQML.</li><li>Lab Option 2: Movie Recommendations in BigQuery ML.</li></ul><h4>Custom Model building with Cloud AutoML</h4><ul><li>Why Auto ML?</li><li>Auto ML Vision.</li><li>Auto ML NLP.</li><li>Auto ML Tables.</li></ul></div>

Nexus Human

Google Data Analytics

Data Engineering

Big Data Analytics

Data Science

Google Cloud

Data Skills

Data Engineering on Google Cloud

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Linux system administrators, site reliability engineers, and other IT professionals with some Ansible experience who are interested in learning how to manage and automate the deployment, configuration, and operation of key network services included with Red Hat Enterprise Linux 8.</p>Overview<p>Provide key network services using software included with Red Hat Enterprise Linux 8, including DNS with Unbound and BIND9, DHCP and DHCPv6, client e-mail transmission, printing service, NFS and SMB protocol file sharing, SQL database service with MariaDB, and web services using Apache HTTPD, nginx, Varnish, and HAProxy.     Configure advanced networking for server use cases, including device teaming.     Use Red Hat Ansible Engine to automate the manual deployment and configuration tasks covered in this course.</p><p>Learn how to configure, manage, and scale key services used in the data center  Red Hat Services Management and Automation (RH358) is designed for IT professionals with some experience managing LinuxÂ© systems and want to learn more about how to manage and deploy network services included with Red HatÂ© Enterprise Linux which are particularly important in the modern IT data center. You will learn how to install, configure, and manage basic configurations of these services manually, and then use Red Hat AnsibleÂ© Engine to automate your work in a scalable, repeatable manner.  This course is based on Red Hat Ansible Engine 2.9 and Red Hat Enterprise Linux 8.1.</p></div><div id="course-pills-2"><h3>1 - Manage network services</h3> <ul> <li>Discuss and review key tools and skills needed to manage network services.</li> </ul> <h3>2 - Configure link aggregation</h3> <ul> <li>Improve the redundancy or throughput of network connections of servers by configuring Linux network teaming between multiple network interfaces.</li> </ul> <h3>3 - Manage DNS and DNS servers</h3> <ul> <li>Explain the operation of DNS service, troubleshoot DNS issues, and configure servers to act as a DNS caching nameserver or as an authoritative name server.</li> </ul> <h3>4 - Manage DHCP and IP address assignment</h3> <ul> <li>Explain and configure services used for IPv4 and IPv6 address assignment including DHCP, DHCPv6, and SLAAC.</li> </ul> <h3>5 - Manage printers and printing files</h3> <ul> <li>Configure systems to print to a network printer that supports IPP Everywhere, as well as manage existing printer queues.</li> </ul> <h3>6 - Configure email transmission</h3> <ul> <li>Discuss how mail servers operate, then configure a server to use system tools and Postfix to send email messages through an outbound mail relay.</li> </ul> <h3>7 - Configure MariaDB SQL databases</h3> <ul> <li>Discuss the basic operation of SQL-based relational databases, perform basic SQL queries for troubleshooting, and be able to set up a simple MariaDB database service.</li> </ul> <h3>8 - Configure web servers</h3> <ul> <li>Provide web content from Apache HTTPD or Nginx web servers, then configure them with virtual hosts and TLS-based encryption.</li> </ul> <h3>9 - Optimize web server traffic</h3> <ul> <li>Improve performance of your web servers by using Varnish to cache static content being served and HAProxy to terminate TLS connections and balance load between servers.</li> </ul> <h3>10 - Provide file-based network storage</h3> <ul> <li>Deliver simple file-based network shares to clients using the NFS and SMB protocols.</li> </ul> <h3>11 - Access block-based network storage</h3> <ul> <li>Configure iSCSI initiators on your servers to access block-based storage devices provided by network storage arrays or Ceph storage clusters.</li> </ul></div>

RHCE

Linux Administration

LPIC-1:Linux Administrator

Operating Systems & Services

IT Networking Fundamentals

Ansible

Red Hat Services Management and Automation (RH358)

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>Data Modelers</p>Overview<p>Please refer to course overview</p><p>This offering provides participants with introductory to advanced knowledge of metadata modeling concepts, and how to model metadata for predictable reporting and analysis results using IBM Cognos Framework Manager. Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing of metadata to the web, enabling end users to easily author reports and analyze data.</p></div><div id="course-pills-2"><h4>Introduction to IBM Cognos Framework Manager</h4><ul><li>Model data and identifying related data</li><li>Define requirements and modeling strategies</li><li>Overview of IBM Cognos Framework Manager</li><li>Create a baseline project</li><li>Extend a model</li><li>Prepare reusable metadata</li></ul><h4>Model for predictable results in IBM Cognos Framework Manager</h4><ul><li>Identify query issues</li><li>Identify reporting traps</li><li>Model virtual star schemas</li><li>Use query subjects, modify relationships, and consolidate metadata using virtual objects</li><li>Create calculations, filter data, and customize metadata for runtime</li><li>Implement a time dimension and specify determinants</li></ul><h4>Model for presentation in IBM Cognos Framework Manager</h4><ul><li>Create a presentation view</li><li>Examine data source query subject types and stored procedure query subject types</li><li>Specify data security and package security</li><li>Specify object security and dynamic data security</li><li>Create analysis objects</li><li>Manage OLAP data sources</li></ul><h4>Advanced capabilities in IBM Cognos Framework Manager</h4><ul><li>Explore SQL generation and the use of governors</li><li>Examine the use of IBM Cognos SQL and generated SQL for DMR data</li><li>Other query considerations</li><li>Use session parameters, prompt macros, and security macro functions</li><li>Use materialized views, minimize SQL, and enable Dynamic Query Mode (DQM)</li><li>DQM, CQM, caching metadata, query processing, aggregate calculation, and other ways to improve performance</li></ul><h4>Extended capabilities in IBM Cognos Framework Manager</h4><ul><li>Perform basic maintenance and management on a model</li><li>Remap metadata to another source and import and link additional data sources</li><li>Run scripts to automate or update a model and report on a model</li><li>Segment a project, link a project, and branch a model</li><li>Nest packages and specify package languages and functions</li><li>Explore additional modeling techniques and customize metadata for a multilingual audience</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans B6252 IBM Cognos Framework Manager: Design Metadata Models v11.1.x training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the B6252 IBM Cognos Framework Manager: Design Metadata Models v11.1.x 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.  <p></p>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.<p></p></div>

Cognos

Construction Design & Management (CDM)

Commercial & Contract Management Certification Program (CCM)

Manager Training

Trainers Course

Data Modeling

B6252 IBM Cognos Framework Manager: Design Metadata Models v11.1.x

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p>Data Modelers</p>Overview<p>Please refer to course overview</p><p>This offering provides participants with introductory to advanced knowledge of metadata modeling concepts, and how to model metadata for predictable reporting and analysis results using Framework Manager. Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing of metadata to the web, enabling end users to easily author reports and analyze data.</p></div><div id="course-pills-2"><h4>Introduction to IBM Cognos Framework Manager</h4><ul><li>Model data and identifying related data</li><li>Define requirements and modeling strategies</li><li>Overview of IBM Cognos Framework Manager</li><li>Create a baseline project</li><li>Extend a model</li><li>Prepare reusable metadata</li></ul><h4>Model for predictable results in IBM Cognos Framework Manager</h4><ul><li>Identify query issues</li><li>Identify reporting traps</li><li>Model virtual star schemas</li><li>Use query subjects, modify relationships, and consolidate metadata using virtual objects</li><li>Create calculations, filter data, and customize metadata for runtime</li><li>Implement a time dimension and specify determinants</li></ul><h4>Model for presentation in IBM Cognos Framework Manager</h4><ul><li>Create a presentation view</li><li>Examine data source query subject types and stored procedure query subject types</li><li>Specify data security and package security</li><li>Specify object security and dynamic data security</li><li>Create analysis objects</li><li>Manage OLAP data sources</li></ul><h4>Advanced capabilities in IBM Cognos Framework Manager</h4><ul><li>Explore SQL generation and the use of governors</li><li>Examine the use of IBM Cognos SQL and generated SQL for DMR data</li><li>Other query considerations</li><li>Use session parameters, prompt macros, and security macro functions</li><li>Use materialized views, minimize SQL, and enable Dynamic Query Mode (DQM)</li><li>DQM, CQM, caching metadata, query processing, aggregate calculation, and other ways to improve performance</li></ul><h4>Extended capabilities in IBM Cognos Framework Manager (Optional)</h4><ul><li>Perform basic maintenance and management on a model</li><li>Remap metadata to another source and import and link additional data sources</li><li>Run scripts to automate or update a model and report on a model</li><li>Segment a project, link a project, and branch a model</li><li>Nest packages and specify package languages and functions</li><li>Explore additional modeling techniques and customize metadata for a multilingual audience</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans B6152 IBM Cognos Framework Manager - Design Metadata Models v11.0.x training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the B6152 IBM Cognos Framework Manager - Design Metadata Models v11.0.x 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.  <p></p>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.<p></p></div>

Service Design Courses (SDC)

B6152 IBM Cognos Framework Manager - Design Metadata Models v11.0.x

<div>
						<div>
							<div>
							<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>Overview
</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>This comprehensive course on </span><b><span>Ethical Hacking with Kali Linux </span></b>will deepen your understanding on this topic.</p><p><span><span>After successful completion of this course you can acquire the required skills in this sector. This </span><b>Ethical Hacking with Kali Linux </b>comes with accredited certification, which will enhance your CV and make you worthy in the job market.</span></p><p><span><span>So enrol in this course today to fast track your career ladder.</span></span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
								</div>
					</div>
		</div>
								</div>
					</div>
		</section>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2>How will I get my certificate?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p>You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Who is This course for?</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>There is no experience or previous qualifications required for enrolment on this </span><b><span>Ethical Hacking with Kali Linux</span></b>. It is available to all students, of all academic backgrounds.</p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Requirements</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Our </span><b><span>Ethical Hacking with Kali Linux </span></b>is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.</p><p><span><span>There is no time limit for completing this course, it can be studied in your own time at your own pace.</span></span></p>					</div>
						</div>
				</div>
				<div>
				<div>
			<h2>Career Path</h2>		</div>
				</div>
				<div>
				<div>
								<div>
					<p><span>Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business &amp; Management, Admin, Accountancy &amp; Finance, Secretarial &amp; PA, Teaching &amp; Mentoring etc.</span></p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>16 sections • 150 lectures • 05:54:00 total length</p></div><div><div><div><div><div><div><div><p>•Introduction to the course: 00:05:00</p></div><div><div><p>•Virtual box installation: 00:16:00</p></div><div><div><p>•Kali linux installation: 00:14:00</p></div><div><div><p>•Enabling full screen: 00:18:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Basic commands part 1: 00:10:00</p></div><div><div><p>•Basic commands part 2: 00:21:00</p></div><div><div><p>•Basic commands part 3: 00:13:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Changing ip address and wireless adapter setup: 00:05:00</p></div><div><div><p>•Creating a bootable Kali USB drive: 00:05:00</p></div><div><div><p>•Essential networking terms: 00:10:00</p></div><div><div><p>•Essential hacking terms: 00:18:00</p></div><div><div><p>•Additional kali tools to install: 00:09:00</p></div><div><div><p>•Changing our MAC address with mac changer: 00:06:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Google hacking: 00:13:00</p></div><div><div><p>•Nikto basics: 00:11:00</p></div><div><div><p>•Whois tools: 00:07:00</p></div><div><div><p>•Email harvesting: 00:06:00</p></div><div><div><p>•Shodan: 00:10:00</p></div><div><div><p>•Zone transfer with Dig: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Installing Metasploitable: 00:07:00</p></div><div><div><p>•Nmap part 1: 00:16:00</p></div><div><div><p>•Nmap part 2: 00:12:00</p></div><div><div><p>•Nmap part 3: 00:12:00</p></div><div><div><p>•Zen map: 00:08:00</p></div><div><div><p>•TCP scans: 00:16:00</p></div><div><div><p>•Nmap by passing defenses: 00:17:00</p></div><div><div><p>•Nmap scripts part 1: 00:09:00</p></div><div><div><p>•Nmap scripts part 2: 00:14:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Installing OWASP: 00:08:00</p></div><div><div><p>•HTTP request: 00:10:00</p></div><div><div><p>•HTTP response: 00:10:00</p></div><div><div><p>•Burpsuite configuration: 00:13:00</p></div><div><div><p>•Editing packets in Burpsuite: 00:12:00</p></div><div><div><p>•Whatweb and Dirb: 00:10:00</p></div><div><div><p>•Password recovery attack: 00:16:00</p></div><div><div><p>•Burpsuite login bruteforce: 00:11:00</p></div><div><div><p>•Hydra login bruteforce: 00:09:00</p></div><div><div><p>•Session fixation: 00:14:00</p></div><div><div><p>•Injection attacks: 00:06:00</p></div><div><div><p>•Simple command injection: 00:11:00</p></div><div><div><p>•Exploiting command injection vulnerability: 00:08:00</p></div><div><div><p>•Finding blind command injection: 00:14:00</p></div><div><div><p>•SQL basics: 00:10:00</p></div><div><div><p>•Manual SQL injection part 1: 00:13:00</p></div><div><div><p>•Manual SQL injection part 2: 00:21:00</p></div><div><div><p>•SQL map basics: 00:17:00</p></div><div><div><p>•XML injection: 00:16:00</p></div><div><div><p>•Installing XCAT and preventing injection attacks: 00:06:00</p></div><div><div><p>•Reflected XSS: 00:11:00</p></div><div><div><p>•Stored XSS: 00:13:00</p></div><div><div><p>•Changing HTML code with XSS: 00:07:00</p></div><div><div><p>•XSSer and XSS sniper: 00:14:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Wireless attacking theory: 00:11:00</p></div><div><div><p>•Enabling monitor mode: 00:05:00</p></div><div><div><p>•Capturing handshake with airodump: 00:15:00</p></div><div><div><p>•Rockyou.txt: 00:14:00</p></div><div><div><p>•Cracking with aircrack: 00:16:00</p></div><div><div><p>•Cracking with hashcat: 00:15:00</p></div><div><div><p>•Creating password lists with crunch: 00:18:00</p></div><div><div><p>•Creating password lists with cup: 00:07:00</p></div><div><div><p>•Rainbow tables part 1: 00:17:00</p></div><div><div><p>•Rainbow tables part 2: 00:06:00</p></div><div><div><p>•Installing fluxion: 00:06:00</p></div><div><div><p>•Finding and cracking hidden networks: 00:08:00</p></div><div><div><p>•Preventing wireless attacks: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•ARP protocol basics: 00:10:00</p></div><div><div><p>•Man in the middle attack theory: 00:07:00</p></div><div><div><p>•Installing MITMf: 00:07:00</p></div><div><div><p>•Manual ARP spoofing: 00:13:00</p></div><div><div><p>•Problems while installing MITMf: 00:06:00</p></div><div><div><p>•HTTP traffic sniffing: 00:08:00</p></div><div><div><p>•DNS spoofing and HTTPS password sniffing: 00:24:00</p></div><div><div><p>•Hooking browser with BEEF: 00:16:00</p></div><div><div><p>•Screenshotting targets browser: 00:11:00</p></div><div><div><p>•Cloning any webpage: 00:09:00</p></div><div><div><p>•Ettercap basics: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•MFS console environment: 00:16:00</p></div><div><div><p>•Metasploit modules explained: 00:12:00</p></div><div><div><p>•Bruteforcing SSH with Metasploit: 00:15:00</p></div><div><div><p>•Attacking tomcat with metasploit: 00:09:00</p></div><div><div><p>•Getting meterpreter with command injection: 00:25:00</p></div><div><div><p>•PHP code injection: 00:06:00</p></div><div><div><p>•Metasploitable exploits: 00:07:00</p></div><div><div><p>•Wine installation: 00:12:00</p></div><div><div><p>•Creating windows payloads with Msfvenom: 00:10:00</p></div><div><div><p>•Encoders and Hex editors: 00:19:00</p></div><div><div><p>•Windows 10 meterpreter shell: 00:12:00</p></div><div><div><p>•Meterpreter environment: 00:11:00</p></div><div><div><p>•Windows 10 privilege escalation: 00:11:00</p></div><div><div><p>•Preventing privilege escalation: 00:06:00</p></div><div><div><p>•Post exploitation modules: 00:14:00</p></div><div><div><p>•Getting Meterpreter over Internet with port forwarding: 00:11:00</p></div><div><div><p>•Eternalblue exploit: 00:20:00</p></div><div><div><p>•Persistence module: 00:13:00</p></div><div><div><p>•Hacking over the internet with Ngrok: 00:10:00</p></div><div><div><p>•Android device hacking with venom: 00:10:00</p></div><div><div><p>•The real hacking begins now!: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Variables: 00:14:00</p></div><div><div><p>•Raw input: 00:11:00</p></div><div><div><p>•If else statements: 00:10:00</p></div><div><div><p>•For loops: 00:07:00</p></div><div><div><p>•While loops: 00:08:00</p></div><div><div><p>•Python lists: 00:08:00</p></div><div><div><p>•Functions: 00:15:00</p></div><div><div><p>•Classes: 00:10:00</p></div><div><div><p>•Importing libraries: 00:07:00</p></div><div><div><p>•Files in python: 00:12:00</p></div><div><div><p>•Try and except the rule: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Theory behind reverse shells: 00:07:00</p></div><div><div><p>•Simple server code: 00:13:00</p></div><div><div><p>•Connection with reverse shell: 00:07:00</p></div><div><div><p>•Sending and receiving messages: 00:11:00</p></div><div><div><p>•Sending messages with while true loop: 00:08:00</p></div><div><div><p>•Executing commands on target system: 00:10:00</p></div><div><div><p>•Fixing backdoor bugs and adding functions: 00:20:00</p></div><div><div><p>•First test using our backdoor: 00:18:00</p></div><div><div><p>•Trying to connect every 20 seconds: 00:12:00</p></div><div><div><p>•Creating persistence part 1: 00:06:00</p></div><div><div><p>•Creating persistence part 2: 00:17:00</p></div><div><div><p>•Changing directory: 00:12:00</p></div><div><div><p>•Uploading and downloading files: 00:22:00</p></div><div><div><p>•Downloading files from the internet: 00:23:00</p></div><div><div><p>•Starting programs using our backdoor: 00:07:00</p></div><div><div><p>•Capturing screenshots on the target PC: 00:19:00</p></div><div><div><p>•Embedding backdoor in an image part 1: 00:13:00</p></div><div><div><p>•Embedding backdoor in an image part 2: 00:09:00</p></div><div><div><p>•Checking for administrator privileges: 00:12:00</p></div><div><div><p>•Adding help option: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Importing Pynput: 00:10:00</p></div><div><div><p>•Simple keylogger: 00:10:00</p></div><div><div><p>•Adding report function: 00:11:00</p></div><div><div><p>•Writing key strokes to a file: 00:14:00</p></div><div><div><p>•Adding the keylogger to our reverse shell part 1: 00:23:00</p></div><div><div><p>•Adding the keylogger to our reverse shell part 2: 00:08:00</p></div><div><div><p>•Final project test: 00:14:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Printing banner: 00:11:00</p></div><div><div><p>•Adding available options: 00:11:00</p></div><div><div><p>•Starting threads for bruteforce: 00:08:00</p></div><div><div><p>•Writing function to run the attack: 00:11:00</p></div><div><div><p>•Bruteforcing router login: 00:10:00</p></div><div><div><p>•Bypassing antivirus with your future programs: 00:14:00</p></div><div><div><p>•Sending malware with spoofed email: 00:15:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•What will you learn in this section?: 00:03:00</p></div><div><div><p>•Why is ethical hacking a valuable skill?: 00:23:00</p></div><div><div><p>•What is the best ethical hacking certification?: 00:17:00</p></div><div><div><p>•Tips for getting your first job as an ethical hacker: 00:18:00</p></div><div><div><p>•How I started my career as an ethical hacker: 00:14:00</p></div><div><div><p>•How to price your work: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Bonuses. Enjoy the Benefits: 01:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Assignment - Ethical Hacking with Kali Linux: 00:00:00</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>

Apex Learning

Kali Linux

IT Certifications

Cyber Security

Hacking

Certified Ethical Hacker (CEH)

Ethical Hacking

Ethical Hacking with Kali Linux

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This course is intended for networking and security professionals involved in the day-to-day management of a FortiAnalyzer appliance and FortiGate security information..</p>Overview<p>Describe key features and concepts of FortiAnalyzer<br />Deploy an appropriate architecture<br />Manage ADOMs on both FortiAnalyzer and the devices that log to it<br />Configure RAID<br />Register supported devices<br />Encrypt log transmission (SSL / IPSec)<br />View &amp; analyze current and historical logs (FortiView)<br />Monitor events<br />Apply disk quotas to log data from devices<br />Backup, restore, and forward log data<br />Use content archiving (summary and full)<br />Understand the different stages of data processing, from receiving logs to compiling reports<br />Understand SQL queries and datasets used by FortiAnalyzer reports<br />Design datasets, charts, and custom reports<br />Generate reports by schedule or on demand.</p><p>In this 1-day class, you will learn how to use FortiAnalyzer. You will explore setup, registering supported devices and securing communications, managing logs and archives, and configuring both predefined and customized reports.</p></div><div id="course-pills-2"><h4>Introduction to FortiAnalyzer</h4><ul><li>Key features</li><li>Key concepts</li><li>Different FortiAnalyzer models</li></ul><h4>Configuration &amp; Administration</h4><ul><li>Deployment requirements</li><li>Configuration tools</li><li>Configuring network settings</li><li>Backing up system configuration</li><li>Configuring administrative users</li><li>Configuring, enabling, and assigning ADOMs</li><li>Configuring RAID</li></ul><h4>Device Registration</h4><ul><li>Registered and unregistered devices</li><li>Device registration methods</li><li>Modifying options of a registered device</li><li>Methods available to secure communication</li><li>Configuring SSL encryption and encryption levels</li><li>Configuring an IPsec tunnel</li></ul><h4>Logs &amp; Archives</h4><ul><li>Logging basics</li><li>The FortiView tab</li><li>Configuring log arrays and event handlers</li></ul><h4>Reports</h4><ul><li>Reports and functionality</li><li>Relationship between reports, charts, and datasets</li><li>Effect of ADOMs on report settings</li><li>SQL SELECT queries and clauses</li><li>SQL functions and operators</li><li>FortiAnalyzer-specific functions and macros</li><li>Building or customizing charts</li><li>Report features--creating, cloning, configuring</li></ul></div>

FortiAnalyzer

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><b>Course Overview</b></h2>		</div>
				</div>
				<div>
				<div>
					<div><p><span>Discover how to improve customer-facing services by optimising the user's experience when you take this course on using </span><b>Artificial Intelligence in Digital Marketing. </b><span>Technology is now at a level where professional marketers can personalise advertising and communication on an individual level rather than a broad demographic. With this training, you can learn how to predict customer behaviour based on analytics and make your customers aware of the products or services that they need, well before your competitors do. </span></p><p><span>This </span><b>Digital Marketing </b><span>tutorial delivers the total learning package for the combination of machine and online marketing. You will learn about preparing semantic searches, correlating large amounts of purchasing data, using email marketing methods, developing AI writing skills with SQL, and much more. The course even provides a masterclass on the current trend for using chatbots to engage directly with customers. Enrol now to learn how to market in the future. </span></p></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This best selling <strong>Artificial Intelligence In Digital Marketing </strong>has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth <strong>Artificial Intelligence In Digital Marketing </strong>is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p>
<p>The <strong>Artificial Intelligence In Digital Marketing </strong>is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The <strong>Artificial Intelligence In Digital Marketing </strong>is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p>
<p>After successfully completing the<strong> Artificial Intelligence In Digital Marketing</strong>, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the <strong>Artificial Intelligence In Digital Marketing </strong>will help you stand out from the crowd. You can also validate your certification on our website.</p>
<p>We know that you are busy and that time is precious, so we have designed the <strong>Artificial Intelligence In Digital Marketing </strong>to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p>
<p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
					</div>
		</div>
								</div>
					</div>

Course Cloud

Artificial Intelligence In Digital Marketing

<p><strong> Boost Your Career By Enrolling In This Microsoft Excel &amp; Data Analysis Bundle To Overcome Your Challenges!</strong></p><p><strong> 4 in 1 Microsoft Excel &amp; Data Analysis Bundle </strong></p><p>Improve your knowledge and enhance your skills to succeed with this Microsoft Excel &amp; Data Analysis bundle. This Microsoft Excel &amp; Data Analysis bundle is designed to build your competent skill set and enable the best possible outcome for your future. Our bundle is ideal for those who aim to be the best in their fields and are always looking to grow.</p><p><strong>This Microsoft Excel &amp; Data Analysis Bundle Contains 4 of Our Premium Courses for One Discounted Price:</strong></p><ul><li> Course 01: Microsoft Excel Complete Course</li><li> Course 02: Basic Data Analysis</li><li> Course 03: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query</li><li> Course 04: SQL for Data Science, Data Analytics and Data Visualization</li></ul><p>All the courses under this Microsoft Excel &amp; Data Analysis bundle are split into a number of expertly created modules to provide you with an in-depth and comprehensive learning experience. Upon successful completion of the Microsoft Excel &amp; Data Analysis bundle, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Stand out from the crowd and get trained for the job you want.</p><p>With this comprehensive Microsoft Excel &amp; Data Analysis bundle, you can achieve your dreams and train for your ideal career. This Microsoft Excel &amp; Data Analysis bundle covers essential aspects in order to progress in your chosen career.</p><p><strong>Why Prefer Us for Microsoft Excel &amp; Data Analysis?</strong></p><ul><li>All-in-one package of 4 premium courses' Microsoft Excel &amp; Data Analysis bundle</li><li>Earn a certificate accredited by <strong>CPDQS. </strong></li><li><strong>Get a free student ID </strong>card<strong>! </strong>(£10 postal charge will be applicable for international delivery)</li><li>Globally Accepted Standard Lesson Planning</li><li>Free Assessments with this Microsoft Excel &amp; Data Analysis Bundle</li><li>24/7 Tutor Support available with this Microsoft Excel &amp; Data Analysis Bundle</li></ul> <p>Start your learning journey straightaway!</p><p>This Microsoft Excel &amp; Data Analysis's curriculum has been designed by Microsoft Excel &amp; Data Analysis experts with years of Microsoft Excel &amp; Data Analysis experience behind them. The Microsoft Excel &amp; Data Analysis course is extremely dynamic and well-paced to help you understand Microsoft Excel &amp; Data Analysis with ease. You'll discover how to master the Microsoft Excel &amp; Data Analysis skill while exploring relevant and essential topics.</p><p><strong>Assessment Process</strong></p><p>Once you have completed all the courses in the Microsoft Excel &amp; Data Analysis bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        180 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This Microsoft Excel &amp; Data Analysis bundle is suitable for everyone.</p>
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>You will not need any prior background or expertise.</p>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>This Microsoft Excel &amp; Data Analysis bundle will allow you to kickstart or take your career in the related sector to the next stage.</p>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4> Digital certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4> Hard copy certificate</h4>
        <p>
            Hard copy certificate -
            £29
        </p>
            <div><p>If you are an international student, you will be required to pay an additional fee of <strong>10 GBP</strong> for international delivery, and <strong>4.99 GBP</strong> for delivery within the UK, for each certificate</p></div>

                        </div>

Academy for Health and Fitness

Microsoft Excel & Data Analysis - CPD Certified

<div> <div> <div>  </div> <div> <b>Quality Guarantee:</b> <p>Promising training excellence, satisfaction gurantee</p> </div> </div> <div> <div>  </div> <div> <p>Accredited by </p> <p>CPD UK &amp; Quality License Scheme</p> </div> </div> <div> <div>  </div> <div> <p>Tutor Support </p> <p>Unlimited support via email, till you complete the course</p> </div> </div> <div> <div>  </div> <div> <b>Recognised Certification:</b> <p>Accepted by thousands of professional bodies </p> </div> </div> <div> <div>  </div> <div> <p>Start Anytime </p> <p>With 1 year access to the course materials</p> </div> </div> <div> <div>  </div> <div> <p>Online Learning </p> <p>Learn from anywhere, whenever you want </p> </div> </div> </div> <div> <p>This course will take you on an exciting journey into the world of cybersecurity. Here you will learn ethical hacking methodologies and methods to identify and address potential security threats. With expert guidance, you will learn penetration testing, data protection and network security.</p> <h2>This course at a glance</h2> <ul> <li>Accredited by CPD UK</li> <li>Endorsed by Quality Licence Scheme</li> <li>Gain a comprehensive understanding of ethical hacking.</li> <li>Strengthen your skills and knowledge required to become an ethical hacker.</li> <li>Understand the basic Linux commands.</li> <li>Learn to create a secure hacking environment.</li> <li>Gain knowledge about scanning, footprinting and website penetration testing.</li> <li>Understand the process of wireless cracking.</li> <li>Learn about the man in the middle attacks.</li> <li>Learn about system hacking with Metasploit.</li> <li>Understand the basic authentication brute force.</li> </ul> </div> <h2>Why Ethical Hacking Complete Course right for you?</h2> <p>This online ethical hacking complete course is the perfect way to kickstart your network security and ethical hacking career. This flexible online course will provide you with a comprehensive understanding of ethical hacking and the skills required to gain proficiency.</p> <p>This professional ethical hacking complete course will also help you understand the process of creating a secure hacking environment by using your expertise in the field. You will also get to have a crash course on Python and coding after taking this course. This popular online course will also help you understand footprinting, scanning, website penetration testing and a lot more.</p> <p>By the end of the course, you will have a theoretical understanding of ethical hacking and the tools and strategies used to become a thriving ethical hacker.</p> <h2>Ethical Hacking Complete Course Details</h2> <div> <h3 id="small-panelsStayOpen-heading653b67a29c28f">  Accredited by  </h3> <div id="panelsStayOpen-collapse653b67a29c28f"> <div> <p> CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.</p> <p> </p> <p> The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. </p></div> </div> </div> <div> <h3 id="small-panelsStayOpen-heading653b67a29c2a0">  Course Curriculum  </h3> <div id="panelsStayOpen-collapse653b67a29c2a0"> <div> <p></p> <h4>Introduction</h4> <ul> <li>Introduction to The Course</li> <li>VirtualBox Installation</li> <li>Kali Linux Installation</li> <li>Enabling Full-Screen</li> </ul> <h4>Basic Linux Commands</h4> <ul> <li>Basic Commands Part 1</li> <li>Basic Commands Part 2</li> <li>Basic Commands Part 3</li> </ul> <h4>Creating a Secure Hacking Environment</h4> <ul> <li>Changing IP Address and Wireless Adapter Setup</li> <li>Creating a Bootable Kali USB Drive</li> <li>Essential Networking Terms</li> <li>Essential Hacking Terms</li> <li>Additional Kali Tools to Install</li> <li>Changing Our MAC Address with Macchanger</li> </ul> <h4>Footprinting</h4> <ul> <li>Google Hacking</li> <li>Nikto Basics</li> <li>Whois Tool</li> <li>Email Harvesting</li> <li>Shodan</li> <li>Zone Transfer with Dig</li> </ul> <h4>Scanning</h4> <ul> <li>Installing Metasploitable</li> <li>Nmap Part 1</li> <li>Nmap Part 2</li> <li>Nmap Part 3</li> <li>Zenmap</li> <li>TCP Scans</li> <li>Nmap Bypassing Defenses</li> <li>Nmap Scripts Part 1</li> <li>Nmap Scripts Part 2</li> </ul> <h4>Website Penetration Testing</h4> <ul> <li>Installing OWASP</li> <li>HTTP Request</li> <li>HTTP Response</li> <li>Burpsuite Configuration</li> <li>Editing Packets in Burpsuite</li> <li>Whatweb and Dirb</li> <li>Password Recovery Attack</li> <li>Burpsuite Login Bruteforce</li> <li>Hydra Login Bruteforce</li> <li>Session Fixation</li> <li>Injection Attacks</li> <li>Simple Command Injection</li> <li>Exploiting Command Injection Vulnerability</li> <li>Finding Blind Command Injection</li> <li>SQL Basics</li> <li>Manual SQL Injection Part 1</li> <li>Manual SQL Injection Part 2</li> <li>SQLmap Basics</li> <li>XML Injection</li> <li>Installing XCAT And Preventing Injection Attacks</li> <li>Reflected XSS</li> <li>Stored XSS</li> <li>Changing HTML Code with XSS</li> <li>XSSer and XSSsniper</li> </ul> <h4>Wireless Cracking</h4> <ul> <li>Wireless Attacking Theory</li> <li>Enabling Monitor Mode</li> <li>Capturing Handshake with Airodump</li> <li>RockYou.txt</li> <li>Cracking with Aircrack</li> <li>Cracking with Hashcat</li> <li>Creating Password Lists with Crunch</li> <li>Creating Password Lists with Cupp</li> <li>Rainbow Tables Part 1</li> <li>Rainbow Tables Part 2</li> <li>Installing Fluxion</li> <li>Finding and Cracking Hidden Networks</li> <li>Preventing Wireless Attacks</li> </ul> <h4>Man in the Middle Attacks</h4> <ul> <li>ARP Protocol Basics</li> <li>Man in The Middle Attack Theory</li> <li>Installing MITMf</li> <li>Manual ARP Spoofing</li> <li>Problems While Installing MITMf</li> <li>HTTP Traffic Sniffing</li> <li>DNS Spoofing and HTTPS Password Sniffing</li> <li>Hooking Browsers with BEEF</li> <li>Screenshotting Targets Browser</li> <li>Cloning Any Webpage</li> <li>Ettercap Basics</li> </ul> <h4>System Hacking with Metasploit</h4> <ul> <li>MSFconsole Environment</li> <li>Bruteforcing SSH with Metasploit</li> <li>Attacking Tomcat with Metasploit</li> <li>Getting Meterpreter with Command Injection</li> <li>PHP Code Injection</li> <li>2 Metasploitable Exploits</li> <li>Wine Installation</li> <li>Creating Windows Payloads with Msfvenom</li> <li>Encoders and Hex Editor</li> <li>Windows 10 Meterpreter Shell</li> <li>Meterpreter Environment</li> <li>Windows 10 Privilege Escalation</li> <li>Preventing Privilege Escalation</li> <li>Post Exploitation Modules</li> <li>Getting Meterpreter Over Internet with Port Forwarding</li> <li>Eternalblue Exploit</li> <li>Persistence Module</li> <li>Hacking Over The Internet with Ngrok</li> <li>Android Device Attack with Venom</li> <li>The Real Hacking Begins Now!</li> </ul> <h4>Python Crash Course</h4> <ul> <li>Variables</li> <li>Raw Input</li> <li>If-Else Statements</li> <li>For Loops</li> <li>While Loops</li> <li>Python Lists</li> <li>Functions</li> <li>Classes</li> <li>Importing Libraries</li> <li>Files in Python</li> <li>Try and Except Rule</li> </ul> <h4>Coding an Advanced Backdoor</h4> <ul> <li>Theory Behind Reverse Shells</li> <li>Simple Server Code</li> <li>Connection with Reverse Shell</li> <li>Sending and Receiving Messages</li> <li>Sending Messages with While True Loop</li> <li>Executing Commands on Target System</li> <li>Fixing Backdoor Bugs and Adding Functions</li> <li>First Test Using Our Backdoor</li> <li>Trying to Connect Every 20 Seconds</li> <li>Creating Persistence Part 1</li> <li>Creating Persistence Part 2</li> <li>Changing Directory</li> <li>Uploading and Downloading Files</li> <li>Downloading Files from The Internet</li> <li>Starting Programs Using Our Backdoor</li> <li>Capturing Screenshot on The Target PC</li> <li>Embedding Backdoor in an Image Part 1</li> <li>Embedding Backdoor in an Image Part 2</li> <li>Checking for Administrator Privileges</li> <li>Adding Help Option</li> </ul> <h4>Creating a Keylogger for The Backdoor</h4> <ul> <li>Importing Pynput</li> <li>Simple Keylogger</li> <li>Adding Report Function</li> <li>Writing Keystrokes to a File</li> <li>Adding The Keylogger to Our Reverse Shell Part 1</li> <li>Adding The Keylogger to Our Reverse Shell Part 2</li> <li>Final Project Test</li> </ul> <h4>Basic Authentication Bruteforcer</h4> <ul> <li>Printing Banner</li> <li>Adding Available Options</li> <li>Starting Threads for Bruteforce</li> <li>Writing Function to Run The Attack</li> <li>Bruteforcing Router Login</li> <li>Bypassing Antivirus with Your Future Programs</li> <li>Sending Malware with Spoofed Email</li> </ul> <h4>Bonus - Building a Career in Cyber Security</h4> <ul> <li>What will You Learn in This Section?</li> <li>Why is Ethical Hacking a Valuable Skill?</li> <li>What is The Best Ethical Hacking Certification?</li> <li>Tips for Getting Your First Job As an Ethical Hacker</li> <li>How I Started My Career As an Ethical Hacker</li> <li>How to Price Your Work</li> </ul> <p> </p></div> </div> </div> <div> <h3 id="small-panelsStayOpen-heading653b67a29c2ac">  Who should take this course?  </h3> <div id="panelsStayOpen-collapse653b67a29c2ac"> <div> <p></p> <p>This ethical hacking complete course has been designed for those who want to build in ethical hacking. Someone looking to add an advantage to their career in the field of ethical hacking or aspiring to establish their career can also opt for this engaging online course.</p> <p> </p></div> </div> </div> <div> <h3 id="small-panelsStayOpen-heading653b67a29c2b5">  Entry Requirements  </h3> <div id="panelsStayOpen-collapse653b67a29c2b5"> <div> <p></p> <ul> <li>There are no academic entry requirements for this Ethical Hacking Complete course, and it is open to students of all academic backgrounds.</li> <li>However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection.</li> </ul> <p> </p></div> </div> </div> <div> <h3 id="small-panelsStayOpen-heading653b67a29c2bb">  Assessment Method  </h3> <div id="panelsStayOpen-collapse653b67a29c2bb"> <div> <p></p> <p>This Ethical Hacking Complete Course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner can grasp from each section. In the assessment pass mark is 60%. </p></div> </div> </div> <div> <h3 id="small-panelsStayOpen-heading653b67a29c2c1">  Certification  </h3> <div id="panelsStayOpen-collapse653b67a29c2c1"> <div> <p></p> <h4>Endorsed Certificate from Quality Licence Scheme</h4> <p> After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is Â£65.</p> <h4>Certificate of Achievement from Lead Academy</h4> <p> After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of Â£12, and there is an additional fee to obtain a printed copy certificate which is Â£35. </p></div> </div> </div> <p></p><h2><b>FAQs</b></h2> <div id="accordionPanelsStayOpenExample"> <div> <h3 id="panelsStayOpen-heading21">  Is CPD a recognised qualification in the UK?  </h3> <div id="panelsStayOpen-collapse21"> <div> <p>CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading23">  Are QLS courses recognised?  </h3> <div id="panelsStayOpen-collapse23"> <div> <p>Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading25">  When will I receive my certificate?  </h3> <div id="panelsStayOpen-collapse25"> <div> <p>For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading27">  Can I pay by invoice?  </h3> <div id="panelsStayOpen-collapse27"> <div> <p>Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading29">  Can I pay via instalment?  </h3> <div id="panelsStayOpen-collapse29"> <div> <p>Yes, you can pay via instalments at checkout. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading31">  How to take online classes from home?  </h3> <div id="panelsStayOpen-collapse31"> <div> <p>Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading33">  Does age matter in online learning?  </h3> <div id="panelsStayOpen-collapse33"> <div> <p>No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. </p> </div> </div> </div> <div> <h3 id="panelsStayOpen-heading35">  When I will get the login details for my course?  </h3> <div id="panelsStayOpen-collapse35"> <div> <p>After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org </p> </div> </div> </div> </div>

Lead Academy

Ethical Hacking Complete Course

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills.</p>Overview<p>Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries</p><p>This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling.</p>Prerequisites<p></p><ul> <li>Basic understanding of relational databases.</li> <li>Basic Windows knowledge.</li> </ul><p></p></div><div id="course-pills-2"><h3>Module 1: Introduction to Transact-SQL</h3><ul> <li>What is Transact-SQL</li> <li>The SELECT statement</li> <li>The WHERE clause</li> <li>Sorting results</li> <li>Calculations</li> <li>CASE expressions</li> </ul>   <h3>Module 2: Joining tables with Transact-SQL</h3><ul> <li>The JOIN clause</li> <li>Inner joins</li> <li>Outer joins</li> <li>Self joins and cross joins</li> </ul>  <h3>Module 3: Filtering and sorting results</h3><ul> <li>Implement the ORDER BY clause</li> <li>Filter data with the WHERE clause</li> <li>Limit the number of rows returned by a query</li> <li>Implement NULL logic</li> </ul>  <h3>Module 4: SQL Server data types</h3><ul> <li>Understand data types</li> <li>Implement string data types</li> <li>Implement temporal data types</li> </ul>  <h3>Module 5: Inserting, updating and deleting data</h3><ul> <li>Insert new records</li> <li>Update existing records</li> <li>Delete data</li> </ul>   <h3>Module 6: Using SQL Server functions with Transact-SQL</h3><ul> <li>Understand function types in SQL Server</li> <li>Convert data using functions</li> <li>Implement logical functions</li> <li>Work with NULL data using functions</li> </ul>  <h3>Module 7: Aggregating data with Transact-SQL</h3><ul> <li>Implement aggregation in SQL Server</li> <li>Group records in SQL Server</li> <li>Filter aggregated data</li> </ul>   <h3>Module 8: Implement subqueries with Transact-SQL</h3><ul> <li>Implement scalar and multi-valued sub-queries</li> <li>Implement correlated subqueries</li> <li>Implement existence checks with subqueries</li> </ul>   <h3>Module 9: Create queries that use table expressions</h3><ul> <li>Create views</li> <li>Create table-valued functions</li> <li>Implement derived tables</li> <li>Implement common table expressions</li> </ul>  <h3>Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data</h3><ul> <li>Write queries with the UNION operator</li> <li>Write queries with the INTERSECT and EXCEPT operators</li> <li>Write queries with the APPLY operator</li> </ul>    <h3>Module 11: Implement window functions in queries</h3><ul> <li>Understand window functions</li> <li>Impement window functions</li> </ul>    <h3>Module 12: Use PIVOT and grouping sets in queries</h3><ul> <li>Implement PIVOT in queries</li> <li>Implement grouping sets in queries</li> </ul>   <h3>Module 13: Use stored procedures in queries</h3><ul> <li>Query data with stored procedures</li> <li>Interact with stored procedures using input and output parameters</li> <li>Write simple stored procedures</li> <li>Pass dynamic SQL to SQL Server</li> </ul>    <h3>Module 14: Implement programming features in Transact-SQL</h3><ul> <li>Understand T-SQL programming elements</li> <li>Implement loops and conditions in T-SQL queries</li> </ul>   <h3>Module 15: Add error handling to queries</h3><ul> <li>Understand SQL Server error handling</li> <li>Implemet structured exception handling</li> </ul>   <h3>Module 16: Use transactions in queries</h3><ul> <li>Understand database transactions</li> <li>Implement transactions in T-SQL</li> </ul></div>

Computing Skills

Microsoft SQL

SQL Server

55366 Querying Data with Transact-SQL

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>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.</p>Overview<p>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 Intune. 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. Configure an operating-system deployment strategy by using Configuration Manager. Manage and maintain a Configuration Manager site.</p><p>This five-day 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 Endpoint Protection, manage compliance, and create management queries and reports.  Although this course and the associated labs are written for Microsoft Endpoint Configuration Manager and Windows 11, the skills taught will also be backwards compatible with previous editions of System Center Configuration Manager and Windows 10.</p>Prerequisites<p></p><li>Networking fundamentals, including common networking protocols, topologies, hardware, media, routing, switching, and addressing.</li>  <li>Active Directory Domain Services (AD DS) principles and fundamentals of AD DS management.</li>  <li>Installation, configuration, and troubleshooting for Windows-based personal computers.</li>  <li>Basic concepts of public key infrastructure (PKI) security.</li>  <li>Basic understanding of scripting and Windows PowerShell syntax.</li>  <li>Basic understanding of Windows Server roles and services.</li>  <li>Basic understanding of the configuration options for iOS and Android Mobile device platforms.</li><p></p></div><div id="course-pills-2"><h3>1 - Managing computers and mobile devices in the enterprise</h3> <ul> <li>Overview of systems management by using enterprise management solutions</li> <li>Overview of the Configuration Manager architecture</li> <li>Overview of the Configuration Manager administrative tools</li> <li>Tools for monitoring and troubleshooting a Configuration Manager site</li> </ul> <h3>2 - Analyzing data using queries, reports, and CMPivot</h3> <ul> <li>Introduction to queries</li> <li>Configuring SQL Server Reporting Services</li> <li>Analyzing the real-time state of a device by using CMPivot</li> </ul> <h3>3 - Preparing the Configuration Manager management infrastructure</h3> <ul> <li>Configuring site boundaries and boundary groups</li> <li>Configuring resource discovery</li> <li>Organizing resources using device and user collections</li> </ul> <h3>4 - Deploying and managing the Configuration Manager client</h3> <ul> <li>Overview of the Configuration Manager client</li> <li>Deploying the Configuration Manager client</li> <li>Configuring and monitoring client status</li> <li>Managing client settings and performing management operations</li> </ul> <h3>5 - Managing inventory for PCs and applications</h3> <ul> <li>Overview of inventory collection</li> <li>Configuring hardware and software inventory</li> <li>Managing inventory collection</li> <li>Configuring software metering</li> <li>Configuring and managing Asset Intelligence</li> </ul> <h3>6 - Distributing and managing content used for deployments</h3> <ul> <li>Preparing the infrastructure for content management</li> <li>Distributing and managing content on distribution points</li> </ul> <h3>7 - Deploying and managing applications</h3> <ul> <li>Overview of application management</li> <li>Creating applications</li> <li>Deploying applications</li> <li>Managing applications</li> <li>Deploying and managing Windows apps</li> </ul> <h3>8 - Maintaining software updates for managed PCs</h3> <ul> <li>The software updates process</li> <li>Preparing a Configuration Manager site for software updates</li> <li>Managing software updates</li> <li>Configuring automatic deployment rules</li> <li>Monitoring and troubleshooting software updates</li> <li>Enabling third-party updates</li> </ul> <h3>9 - Implementing Defender Protection for managed PCs</h3> <ul> <li>Overview of Endpoint Protection in Configuration Manager</li> <li>Configuring, deploying, and monitoring Endpoint Protection policies</li> <li>Configuring and deploying advanced threat policies</li> <h3>10 - Managing compliance and secure data access</h3> <ul> <li>Overview of Compliance Settings</li> <li>Configuring compliance settings</li> <li>Viewing compliance results</li> <li>Managing resource and data access</li> <h3>11 - Managing operating system deployment</h3> <ul> <li>An overview of operating system deployment</li> <li>Preparing a site for operating system deployment</li> <li>Deploying an operating system</li> <li>Managing Windows as a service</li> <h3>12 - Managing and maintaining a Configuration Manager site</h3> <ul> <li>Configuring role-based administration</li> <li>Configuring Remote Tools</li> <li>Overview of Configuration Manager site maintenance and Management Insights</li> <li>Backing up and recovering a Configuration Manager site</li> <li>Updating the Configuration Manager infrastructure</li> <h3>13 - What?s new in Microsoft Endpoint Configuration Manager</h3> <ul> <li>Whats new in Microsoft Endpoint Manager covering each semi annual release</li> </ul></ul></ul></ul></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55348: Administering Microsoft Endpoint 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. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the 55348: Administering Microsoft Endpoint 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.  <p></p>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.<p></p></div>

Microsoft Certification

Sccm

Microsoft Certified Technology Specialist (MCTS)

IT Manager

Microsoft Certified Trainer (MCT)

55348 Administering Microsoft Endpoint Configuration Manager

<h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(55, 55, 55);">Audience</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">This is an intermediate course for system and database administrators, application developers, and other individuals who need a technical introduction to selected new features of Db2 13 for z/OS.</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Prerequisites</h3><div style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">You should have practical experience with Db2 for z/OS</p></div><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Duration</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">2 days.&nbsp;</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Course Objectives</h3><p style="color: rgb(55, 55, 55); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Learn about the new features and enhancements of Db2 for z/OS (v13), including the technical detail of the functional enhancements of this significant new version of Db2 for z/OS.</p><h3 style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);">Course Content</h3><ul style="color: rgb(55, 55, 55); box-sizing: border-box;" fr-original-style=" color: rgb(55, 55, 55);"><li fr-original-style="" style="box-sizing: border-box;">Unit 1: Db2 v12 Function Levels: Selected Highlights</li><li fr-original-style="" style="box-sizing: border-box;">Unit 2: Migrating to Db2 13</li><li fr-original-style="" style="box-sizing: border-box;">Unit 3: Availability &amp; Scalability</li><li fr-original-style="" style="box-sizing: border-box;">Unit 4: Performance</li><li fr-original-style="" style="box-sizing: border-box;">Unit 5: Application Management and SQL Changes</li><li fr-original-style="" style="box-sizing: border-box;">Unit 6: SQL Data Insights</li><li fr-original-style="" style="box-sizing: border-box;">Unit 7: Security</li><li fr-original-style="" style="box-sizing: border-box;">Unit 8: IBM Db2 Utilities</li><li fr-original-style="" style="box-sizing: border-box;">Unit 9: Instrumentation and Serviceability</li></ul>

Verhoef Training Ltd.

New Db2 13 Functions and Features - CV321G

Early bird

Book your place early to get an extra discount!

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material.</p>Overview<p>After completing this course, you will be able to:<br />Describe key database concepts in the context of SQL Server<br />Describe database languages used in SQL Server<br />Describe data modelling techniques<br />Describe normalization and denormalization techniques<br />Describe relationship types and effects in database design<br />Describe the effects of database design on performance<br />Describe commonly used database objects</p><p>This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance.<br />This material updates and replaces course Microsoft course 10985 which was previously published under the same title.</p></div><div id="course-pills-2"><h4>Module 1: Introduction to databases</h4><ul><li>Introduction to Relational Databases</li><li>Other Databases and Storage</li><li>Data Analysis</li><li>SQL Server Database Languages</li></ul><h4>Module 2: Data Modeling</h4><ul><li>Data Modelling</li><li>Designing a Database</li><li>Relationship Modeling</li></ul><h4>Module 3: Normalization</h4><ul><li>Fundamentals of Normalization</li><li>Normal Form</li><li>Denormalization</li></ul><h4>Module 4: Relationships</h4><ul><li>Introduction to Relationships</li><li>Planning Referential Integrity</li></ul><h4>Module 5: Performance</h4><ul><li>Indexing</li><li>Query Performance</li><li>Concurrency</li></ul><h4>Module 6: Database Objects</h4><ul><li>Tables</li><li>Views</li><li>Stored Procedures, Triggers and Functions</li></ul></div>

Microsoft SQL Server

AWS Certified Database

Database Administration

55315: Introduction to SQL Databases

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications.</p><p></p><p></p><p>This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.</p><p></p>Prerequisites<p>In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses:   </p><li>AZ-900T00 Microsoft Azure Fundamentals  </li><li>DP-900T00 Microsoft Azure Data Fundamentals<p></p></li></div><div id="course-pills-2"><h3>1 - Prepare to maintain SQL databases on Azure</h3> <ul> <li>Describe Microsoft Intelligent Data Platform roles</li> <li>Understand SQL Server in an Azure virtual machine</li> <li>Design Azure SQL Database for cloud-native applications</li> <li>Explore Azure SQL Database Managed Instance</li> </ul> <h3>2 - Deploy IaaS solutions with Azure SQL</h3> <ul> <li>Explain IaaS options to deploy SQL Server in Azure</li> <li>Understand hybrid scenarios</li> <li>Explore performance and security</li> <li>Explain high availability and disaster recovery options</li> </ul> <h3>3 - Deploy PaaS solutions with Azure SQL</h3> <ul> <li>Explain PaaS options for deploying SQL Server in Azure</li> <li>Explore single SQL database</li> <li>Deploy SQL database elastic pool</li> <li>Understand SQL database hyperscale</li> <li>Examine SQL managed instance</li> <li>Describe SQL Edge</li> </ul> <h3>4 - Evaluate strategies for migrating to Azure SQL</h3> <ul> <li>Understand compatibility level</li> <li>Understand Azure preview features</li> <li>Describe Azure database migration options</li> </ul> <h3>5 - Migrate SQL workloads to Azure SQL databases</h3> <ul> <li>Choose the right SQL Server Instance option in Azure</li> <li>Migrate SQL Server to Azure SQL Database offline</li> <li>Migrate SQL Server to Azure SQL Database online</li> <li>Load and move data to Azure SQL Database</li> </ul> <h3>6 - Migrate SQL workloads to Azure Managed Instances</h3> <ul> <li>Evaluate migration scenarios to SQL Database Managed Instance</li> <li>Migrate to SQL Database Managed Instance</li> <li>Load and Move data to SQL Database Managed Instance</li> </ul> <h3>7 - Configure database authentication and authorization</h3> <ul> <li>Describe Active Directory and Azure Active Directory</li> <li>Describe authentication and identities</li> <li>Describe Security Principals</li> <li>Describe database and object permissions</li> <li>Identify authentication and authorization failures</li> </ul> <h3>8 - Protect data in-transit and at rest</h3> <ul> <li>Explore Transparent Data Encryption</li> <li>Configure server and database firewall rules</li> <li>Explain object encryption and secure enclaves</li> <li>Enable encrypted connections</li> <li>Describe SQL injection</li> <li>Understand Azure Key Vault</li> </ul> <h3>9 - Implement compliance controls for sensitive data</h3> <ul> <li>Explore data classification</li> <li>Explore server and database audit</li> <li>Implement Dynamic Data Masking</li> <li>Implement Row Level security</li> <li>Understand Microsoft Defender for SQL</li> <li>Explore Azure SQL Database Ledger</li> <li>Implement Azure Purview</li> </ul> <h3>10 - Describe performance monitoring</h3> <ul> <li>Describe performance monitoring tools</li> <li>Describe critical performance metrics</li> <li>Establish baseline metrics</li> <li>Explore extended events</li> <li>Describe Azure SQL Insights</li> <li>Explore Query Performance Insight</li> </ul> <h3>11 - Configure SQL Server resources for optimal performance</h3> <ul> <li>Explain how to optimize Azure storage for SQL Server virtual machines</li> <li>Describe virtual machine resizing</li> <li>Optimize database storage</li> <li>Control SQL Server resources</li> </ul> <h3>12 - Configure databases for optimal performance</h3> <ul> <li>Explore database maintenance checks</li> <li>Describe database scoped configuration options</li> <li>Describe automatic tuning</li> <li>Describe intelligent query processing</li> </ul> <h3>13 - Explore query performance optimization</h3> <ul> <li>Understand query plans</li> <li>Explain estimated and actual query plans</li> <li>Describe dynamic management views and functions</li> <li>Explore Query Store</li> <li>Identify problematic query plans</li> <li>Describe blocking and locking</li> </ul> <h3>14 - Evaluate performance improvements</h3> <ul> <li>Describe wait statistics</li> <li>Tune and maintain indexes</li> <li>Understand query hints</li> </ul> <h3>15 - Explore performance-based design</h3> <ul> <li>Describe normalization</li> <li>Choose appropriate data types</li> <li>Design indexes</li> </ul> <h3>16 - Automate deployment of database resources</h3> <ul> <li>Describe deployment models in Azure</li> <li>Automate deployment by using Azure Resource Manager templates and Bicep</li> <li>Automate deployment by using PowerShell</li> <li>Automate deployment by using Azure CLI</li> </ul> <h3>17 - Create and manage SQL Agent jobs</h3> <ul> <li>Create a SQL Server maintenance plan</li> <li>Describe task status notifications</li> </ul> <h3>18 - Manage Azure PaaS tasks using automation</h3> <ul> <li>Explore Elastic jobs</li> <li>Understand Azure Automation</li> <li>Build an automation runbook</li> <li>Automate database workflows by using Logic Apps</li> <li>Monitor automated tasks</li> </ul> <h3>19 - Describe high availability and disaster recovery strategies</h3> <ul> <li>Describe recovery time objective and recovery point objective</li> <li>Explore high availability and disaster recovery options</li> <li>Describe Azure high availability and disaster recovery  features for Azure Virtual Machines</li> <li>Describe high availability and disaster recovery options for PaaS deployments</li> <li>Explore an IaaS high availability and disaster recovery solution</li> <li>Describe hybrid solutions</li> </ul> <h3>20 - Explore IaaS and PaaS solutions for high availability and disaster recovery</h3> <ul> <li>Describe failover clusters in Windows Server</li> <li>Configure Always-on availability groups</li> <li>Describe temporal tables in Azure SQL Database</li> <li>Describe active geo-replication for Azure SQL Database</li> <li>Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance</li> </ul> <h3>21 - Back up and restore databases</h3> <ul> <li>Back up and restore SQL Server running on Azure virtual machines</li> <li>Back up a SQL Server virtual machine</li> <li>Back up and restore a database using Azure SQL Database</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-300T00: Administering Microsoft Azure SQL Solutions training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the DP-300T00: Administering Microsoft Azure SQL Solutions 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.  <p></p>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.<p></p></div>

Azure SQL Database

Microsoft AZ-900

Microsoft AZ-104

Microsoft Azure

Microsoft AZ-303

Microsoft AZ-700

DP-300T00 Administering Microsoft Azure SQL Solutions

<p>The Microsoft SQL Server Bootcamp 2022 is all you need to advance your career in the relevant fields.</p><p>Enrol now to discover everything you need to know about the Microsoft SQL Server Bootcamp 2022 and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!</p><p><strong>Expert Support</strong></p><p>Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.</p><p><strong>Key Benefits</strong></p><ul><li>Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.</li><li>Get 24/7 access to all content for a full year.</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li></ul><p><strong>Course Curriculum:</strong></p><p><strong>Microsoft SQL Server Bootcamp 2022</strong></p><ul><li>Section 01: Getting Started</li><li>Section 02: SQL Server setting up</li><li>Section 03: SQL Database basic</li><li>Section 04: SQL DML (Data Manipulation Language)</li><li>Section 05: SQL DDL (Data Definition Language)</li><li>Section 06: SQL DCL (Data Control Language)</li><li>Section 07: SQL Statement Basic</li><li>Section 08: Filtering Data rows</li><li>Section 09: Aggregate functions</li><li>Section 10: SQL Query statements</li><li>Section 11: SQL Group by statement</li><li>Section 12: JOINS</li><li>Section 13: SQL Constraints</li><li>Section 14: Views</li><li>Section 15: Advanced SQL commands</li><li>Section 16: SQL Stored procedures</li><li>Section 17: Import &amp; Export data</li><li>Section 18: Backup and Restore Database</li></ul><p><strong>Course Assessment </strong></p><p>To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.</p><p>When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.</p><p><strong>Certification</strong><br />Once you have finished the course, you will be eligible to apply for a CPD QS accredited certificate as proof of your new skills and your continued professional development. Certificates are available as PDF for £9, or you can request a hard copy to be sent in the post for £15.</p><p><strong>Exam &amp; Retakes:</strong><br />It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.</p><p><strong>Certification</strong><br />Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).</p><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>This Microsoft SQL Server Bootcamp 2022 course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This Microsoft SQL Server Bootcamp 2022 course is open to all, with no formal entry requirements.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon successful completion of the Microsoft SQL Server Bootcamp 2022 Course, learners will be equipped with many indispensable skills and have the opportunity to grab.</p>
                        </div>

The Microsoft SQL Server Bootcamp 2022 is all you need to advance your career in the relevant fields.
Enrol now to discover everything you need to know about the Microsoft SQL Server Bootcamp 2022 and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!
Expert Support
Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.
Key Benefits
Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.
Get 24/7 access to all content for a full year.
Each of our students gets full tutor support on weekdays (Monday to Friday)
Course Curriculum:
Microsoft SQL Server Bootcamp 2022
Section 01: Getting Started
Section 02: SQL Server setting up
Section 03: SQL Database basic
Section 04: SQL DML (Data Manipulation Language)
Section 05: SQL DDL (Data Definition Language)
Section 06: SQL DCL (Data Control Language)
Section 07: SQL Statement Basic
Section 08: Filtering Data rows
Section 09: Aggregate functions
Section 10: SQL Query statements
Section 11: SQL Group by statement
Section 12: JOINS
Section 13: SQL Constraints
Section 14: Views
Section 15: Advanced SQL commands
Section 16: SQL Stored procedures
Section 17: Import & Export data
Section 18: Backup and Restore Database
Course Assessment 
To simplify the procedure of evaluation and accreditation for learners, we provide an automated assessment system. Upon completion of an online module, you will immediately be given access to a specifically crafted MCQ test. The results will be evaluated instantly, and the score will be displayed for your perusal. For each test, the pass mark will be set to 60%.
When all tests have been successfully passed, you will be able to order a certificate endorsed by the Quality Licence Scheme.
Certification
Once you have finished the course, you will be eligible to apply for a CPD QS accredited certificate as proof of your new skills and your continued professional development. Certificates are available as PDF for £9, or you can request a hard copy to be sent in the post for £15.
Exam & Retakes:
It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable.
Certification
Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery).
 Who is this course for? 
This Microsoft SQL Server Bootcamp 2022 course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge.
 Requirements 
This Microsoft SQL Server Bootcamp 2022 course is open to all, with no formal entry requirements.
 Career path 
Upon successful completion of the Microsoft SQL Server Bootcamp 2022 Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

Microsoft Certified Solutions Associate (MCSA)

Bootcamp

Microsoft SQL Server Bootcamp 2022 Course

<div id="course-pills-1">Duration<p>4 Days</p><p>24 CPD hours</p>This course is intended for<p></p><p>The Microsoft Security Operations Analyst collaborates with organizational stakeholders to secure information technology systems for the organization. Their goal is to reduce organizational risk by rapidly remediating active attacks in the environment, advising on improvements to threat protection practices, and referring violations of organizational policies to appropriate stakeholders. Responsibilities include threat management, monitoring, and response by using a variety of security solutions across their environment. The role primarily investigates, responds to, and hunts for threats using Microsoft Sentinel, Microsoft Defender for Cloud, Microsoft 365 Defender, and third-party security products. Since the Security Operations Analyst consumes the operational output of these tools, they are also a critical stakeholder in the configuration and deployment of these technologies.</p><p></p><p></p><p>Learn how to investigate, respond to, and hunt for threats using Microsoft Sentinel, Microsoft Defender for Cloud, and Microsoft 365 Defender. In this course you will learn how to mitigate cyberthreats using these technologies. Specifically, you will configure and use Microsoft Sentinel as well as utilize Kusto Query Language (KQL) to perform detection, analysis, and reporting. The course was designed for people who work in a Security Operations job role and helps learners prepare for the exam SC-200: Microsoft Security Operations Analyst.</p><p></p>Prerequisites<p></p><li>Basic understanding of Microsoft 365</li>  <li>Fundamental understanding of Microsoft security, compliance, and identity products</li>   <li> Intermediate understanding of Windows 10</li>  <li> Familiarity with Azure services, specifically Azure SQL Database and Azure Storage</li>   <li> Familiarity with Azure virtual machines and virtual networking</li>   <li>Basic understanding of scripting concepts.</li><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Microsoft 365 threat protection</h3> <ul> <li>Explore Extended Detection &amp; Response (XDR) response use cases</li> <li>Understand Microsoft Defender XDR in a Security Operations Center (SOC)</li> <li>Explore Microsoft Security Graph</li> <li>Investigate security incidents in Microsoft Defender XDR</li> </ul> <h3>2 - Mitigate incidents using Microsoft 365 Defender</h3> <ul> <li>Use the Microsoft Defender portal</li> <li>Manage incidents</li> <li>Investigate incidents</li> <li>Manage and investigate alerts</li> <li>Manage automated investigations</li> <li>Use the action center</li> <li>Explore advanced hunting</li> <li>Investigate Microsoft Entra sign-in logs</li> <li>Understand Microsoft Secure Score</li> <li>Analyze threat analytics</li> <li>Analyze reports</li> <li>Configure the Microsoft Defender portal</li> </ul> <h3>3 - Protect your identities with Microsoft Entra ID Protection</h3> <ul> <li>Microsoft Entra ID Protection overview</li> <li>Detect risks with Microsoft Entra ID Protection policies</li> <li>Investigate and remediate risks detected by Microsoft Entra ID Protection</li> </ul> <h3>4 - Remediate risks with Microsoft Defender for Office 365</h3> <ul> <li>Automate, investigate, and remediate</li> <li>Configure, protect, and detect</li> <li>Simulate attacks</li> </ul> <h3>5 - Safeguard your environment with Microsoft Defender for Identity</h3> <ul> <li>Configure Microsoft Defender for Identity sensors</li> <li>Review compromised accounts or data</li> <li>Integrate with other Microsoft tools</li> </ul> <h3>6 - Secure your cloud apps and services with Microsoft Defender for Cloud Apps</h3> <ul> <li>Understand the Defender for Cloud Apps Framework</li> <li>Explore your cloud apps with Cloud Discovery</li> <li>Protect your data and apps with Conditional Access App Control</li> <li>Walk through discovery and access control with Microsoft Defender for Cloud Apps</li> <li>Classify and protect sensitive information</li> <li>Detect Threats</li> </ul> <h3>7 - Respond to data loss prevention alerts using Microsoft 365</h3> <ul> <li>Describe data loss prevention alerts</li> <li>Investigate data loss prevention alerts in Microsoft Purview</li> <li>Investigate data loss prevention alerts in Microsoft Defender for Cloud Apps</li> </ul> <h3>8 - Manage insider risk in Microsoft Purview</h3> <ul> <li>Insider risk management overview</li> <li>Create and manage insider risk policies</li> <li>Investigate insider risk alerts</li> <li>Take action on insider risk alerts through cases</li> <li>Manage insider risk management forensic evidence</li> <li>Create insider risk management notice templates</li> </ul> <h3>9 - Investigate threats by using audit features in Microsoft Defender XDR and Microsoft Purview Standard</h3> <ul> <li>Explore Microsoft Purview Audit solutions</li> <li>Implement Microsoft Purview Audit (Standard)</li> <li>Start recording activity in the Unified Audit Log</li> <li>Search the Unified Audit Log (UAL)</li> <li>Export, configure, and view audit log records</li> <li>Use audit log searching to investigate common support issues</li> </ul> <h3>10 - Investigate threats using audit in Microsoft Defender XDR and Microsoft Purview (Premium)</h3> <ul> <li>Explore Microsoft Purview Audit (Premium)</li> <li>Implement Microsoft Purview Audit (Premium)</li> <li>Manage audit log retention policies</li> <li>Investigate compromised email accounts using Purview Audit (Premium)</li> </ul> <h3>11 - Investigate threats with Content search in Microsoft Purview</h3> <ul> <li>Explore Microsoft Purview eDiscovery solutions</li> <li>Create a content search</li> <li>View the search results and statistics</li> <li>Export the search results and search report</li> <li>Configure search permissions filtering</li> <li>Search for and delete email messages</li> </ul> <h3>12 - Protect against threats with Microsoft Defender for Endpoint</h3> <ul> <li>Practice security administration</li> <li>Hunt threats within your network</li> </ul> <h3>13 - Deploy the Microsoft Defender for Endpoint environment</h3> <ul> <li>Create your environment</li> <li>Understand operating systems compatibility and features</li> <li>Onboard devices</li> <li>Manage access</li> <li>Create and manage roles for role-based access control</li> <li>Configure device groups</li> <li>Configure environment advanced features</li> </ul> <h3>14 - Implement Windows security enhancements with Microsoft Defender for Endpoint</h3> <ul> <li>Understand attack surface reduction</li> <li>Enable attack surface reduction rules</li> </ul> <h3>15 - Perform device investigations in Microsoft Defender for Endpoint</h3> <ul> <li>Use the device inventory list</li> <li>Investigate the device</li> <li>Use behavioral blocking</li> <li>Detect devices with device discovery</li> </ul> <h3>16 - Perform actions on a device using Microsoft Defender for Endpoint</h3> <ul> <li>Explain device actions</li> <li>Run Microsoft Defender antivirus scan on devices</li> <li>Collect investigation package from devices</li> <li>Initiate live response session</li> </ul> <h3>17 - Perform evidence and entities investigations using Microsoft Defender for Endpoint</h3> <ul> <li>Investigate a file</li> <li>Investigate a user account</li> <li>Investigate an IP address</li> <li>Investigate a domain</li> </ul> <h3>18 - Configure and manage automation using Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Manage automation upload and folder settings</li> <li>Configure automated investigation and remediation capabilities</li> <li>Block at risk devices</li> </ul> <h3>19 - Configure for alerts and detections in Microsoft Defender for Endpoint</h3> <ul> <li>Configure advanced features</li> <li>Configure alert notifications</li> <li>Manage alert suppression</li> <li>Manage indicators</li> </ul> <h3>20 - Utilize Vulnerability Management in Microsoft Defender for Endpoint</h3> <ul> <li>Understand vulnerability management</li> <li>Explore vulnerabilities on your devices</li> <li>Manage remediation</li> </ul> <h3>21 - Plan for cloud workload protections using Microsoft Defender for Cloud</h3> <ul> <li>Explain Microsoft Defender for Cloud</li> <li>Describe Microsoft Defender for Cloud workload protections</li> <li>Enable Microsoft Defender for Cloud</li> </ul> <h3>22 - Connect Azure assets to Microsoft Defender for Cloud</h3> <ul> <li>Explore and manage your resources with asset inventory</li> <li>Configure auto provisioning</li> <li>Manual log analytics agent provisioning</li> </ul> <h3>23 - Connect non-Azure resources to Microsoft Defender for Cloud</h3> <ul> <li>Protect non-Azure resources</li> <li>Connect non-Azure machines</li> <li>Connect your AWS accounts</li> <li>Connect your GCP accounts</li> </ul> <h3>24 - Manage your cloud security posture management?</h3> <ul> <li>Explore Secure Score</li> <li>Explore Recommendations</li> <li>Measure and enforce regulatory compliance</li> <li>Understand Workbooks</li> </ul> <h3>25 - Explain cloud workload protections in Microsoft Defender for Cloud</h3> <ul> <li>Understand Microsoft Defender for servers</li> <li>Understand Microsoft Defender for App Service</li> <li>Understand Microsoft Defender for Storage</li> <li>Understand Microsoft Defender for SQL</li> <li>Understand Microsoft Defender for open-source databases</li> <li>Understand Microsoft Defender for Key Vault</li> <li>Understand Microsoft Defender for Resource Manager</li> <li>Understand Microsoft Defender for DNS</li> <li>Understand Microsoft Defender for Containers</li> <li>Understand Microsoft Defender additional protections</li> </ul> <h3>26 - Remediate security alerts using Microsoft Defender for Cloud</h3> <ul> <li>Understand security alerts</li> <li>Remediate alerts and automate responses</li> <li>Suppress alerts from Defender for Cloud</li> <li>Generate threat intelligence reports</li> <li>Respond to alerts from Azure resources</li> </ul> <h3>27 - Construct KQL statements for Microsoft Sentinel</h3> <ul> <li>Understand the Kusto Query Language statement structure</li> <li>Use the search operator</li> <li>Use the where operator</li> <li>Use the let statement</li> <li>Use the extend operator</li> <li>Use the order by operator</li> <li>Use the project operators</li> </ul> <h3>28 - Analyze query results using KQL</h3> <ul> <li>Use the summarize operator</li> <li>Use the summarize operator to filter results</li> <li>Use the summarize operator to prepare data</li> <li>Use the render operator to create visualizations</li> </ul> <h3>29 - Build multi-table statements using KQL</h3> <ul> <li>Use the union operator</li> <li>Use the join operator</li> </ul> <h3>30 - Work with data in Microsoft Sentinel using Kusto Query Language</h3> <ul> <li>Extract data from unstructured string fields</li> <li>Extract data from structured string data</li> <li>Integrate external data</li> <li>Create parsers with functions</li> </ul> <h3>31 - Introduction to Microsoft Sentinel</h3> <ul> <li>What is Microsoft Sentinel?</li> <li>How Microsoft Sentinel works</li> <li>When to use Microsoft Sentinel</li> </ul> <h3>32 - Create and manage Microsoft Sentinel workspaces</h3> <ul> <li>Plan for the Microsoft Sentinel workspace</li> <li>Create a Microsoft Sentinel workspace</li> <li>Manage workspaces across tenants using Azure Lighthouse</li> <li>Understand Microsoft Sentinel permissions and roles</li> <li>Manage Microsoft Sentinel settings</li> <li>Configure logs</li> </ul> <h3>33 - Query logs in Microsoft Sentinel</h3> <ul> <li>Query logs in the logs page</li> <li>Understand Microsoft Sentinel tables</li> <li>Understand common tables</li> <li>Understand Microsoft Defender XDR tables</li> </ul> <h3>34 - Use watchlists in Microsoft Sentinel</h3> <ul> <li>Plan for watchlists</li> <li>Create a watchlist</li> <li>Manage watchlists</li> </ul> <h3>35 - Utilize threat intelligence in Microsoft Sentinel</h3> <ul> <li>Define threat intelligence</li> <li>Manage your threat indicators</li> <li>View your threat indicators with KQL</li> </ul> <h3>36 - Connect data to Microsoft Sentinel using data connectors</h3> <ul> <li>Ingest log data with data connectors</li> <li>Understand data connector providers</li> <li>View connected hosts</li> </ul> <h3>37 - Connect Microsoft services to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft services connectors</li> <li>Connect the Microsoft Office 365 connector</li> <li>Connect the Microsoft Entra connector</li> <li>Connect the Microsoft Entra ID Protection connector</li> <li>Connect the Azure Activity connector</li> </ul> <h3>38 - Connect Microsoft Defender XDR to Microsoft Sentinel</h3> <ul> <li>Plan for Microsoft Defender XDR connectors</li> <li>Connect the Microsoft Defender XDR connector</li> <li>Connect Microsoft Defender for Cloud connector</li> <li>Connect Microsoft Defender for IoT</li> <li>Connect Microsoft Defender legacy connectors</li> </ul> <h3>39 - Connect Windows hosts to Microsoft Sentinel</h3> <ul> <li>Plan for Windows hosts security events connector</li> <li>Connect using the Windows Security Events via AMA Connector</li> <li>Connect using the Security Events via Legacy Agent Connector</li> <li>Collect Sysmon event logs</li> </ul> <h3>40 - Connect Common Event Format logs to Microsoft Sentinel</h3> <ul> <li>Plan for Common Event Format connector</li> <li>Connect your external solution using the Common Event Format connector</li> </ul> <h3>41 - Connect syslog data sources to Microsoft Sentinel</h3> <ul> <li>Plan for syslog data collection</li> <li>Collect data from Linux-based sources using syslog</li> <li>Configure the Data Collection Rule for Syslog Data Sources</li> <li>Parse syslog data with KQL</li> </ul> <h3>42 - Connect threat indicators to Microsoft Sentinel</h3> <ul> <li>Plan for threat intelligence connectors</li> <li>Connect the threat intelligence TAXII connector</li> <li>Connect the threat intelligence platforms connector</li> <li>View your threat indicators with KQL</li> </ul> <h3>43 - Threat detection with Microsoft Sentinel analytics</h3> <ul> <li>What is Microsoft Sentinel Analytics?</li> <li>Types of analytics rules</li> <li>Create an analytics rule from templates</li> <li>Create an analytics rule from wizard</li> <li>Manage analytics rules</li> </ul> <h3>44 - Automation in Microsoft Sentinel</h3> <ul> <li>Understand automation options</li> <li>Create automation rules</li> </ul> <h3>45 - Threat response with Microsoft Sentinel playbooks</h3> <ul> <li>What are Microsoft Sentinel playbooks?</li> <li>Trigger a playbook in real-time</li> <li>Run playbooks on demand</li> </ul> <h3>46 - Security incident management in Microsoft Sentinel</h3> <ul> <li>Understand incidents</li> <li>Incident evidence and entities</li> <li>Incident management</li> </ul> <h3>47 - Identify threats with Behavioral Analytics</h3> <ul> <li>Understand behavioral analytics</li> <li>Explore entities</li> <li>Display entity behavior information</li> <li>Use Anomaly detection analytical rule templates</li> </ul> <h3>48 - Data normalization in Microsoft Sentinel</h3> <ul> <li>Understand data normalization</li> <li>Use ASIM Parsers</li> <li>Understand parameterized KQL functions</li> <li>Create an ASIM Parser</li> <li>Configure Azure Monitor Data Collection Rules</li> </ul> <h3>49 - Query, visualize, and monitor data in Microsoft Sentinel</h3> <ul> <li>Monitor and visualize data</li> <li>Query data using Kusto Query Language</li> <li>Use default Microsoft Sentinel Workbooks</li> <li>Create a new Microsoft Sentinel Workbook</li> </ul> <h3>50 - Manage content in Microsoft Sentinel</h3> <ul> <li>Use solutions from the content hub</li> <li>Use repositories for deployment</li> </ul> <h3>51 - Explain threat hunting concepts in Microsoft Sentinel</h3> <ul> <li>Understand cybersecurity threat hunts</li> <li>Develop a hypothesis</li> <li>Explore MITRE ATT&amp;CK</li> </ul> <h3>52 - Threat hunting with Microsoft Sentinel</h3> <ul> <li>Explore creation and management of threat-hunting queries</li> <li>Save key findings with bookmarks</li> <li>Observe threats over time with livestream</li> </ul> <h3>53 - Use Search jobs in Microsoft Sentinel</h3> <ul> <li>Hunt with a Search Job</li> <li>Restore historical data</li> </ul> <h3>54 - Hunt for threats using notebooks in Microsoft Sentinel</h3> <ul> <li>Access Azure Sentinel data with external tools</li> <li>Hunt with notebooks</li> <li>Create a notebook</li> <li>Explore notebook code</li> </ul></div>

Microsoft SC-200

SC-200T00 Microsoft Security Operations Analyst

<strong>Understanding databases and SQL</strong>
        <p>Databases are incredibly important in the modern world, and may seem quite complex to most people. But they're easy to use if you know the right techniques and concepts. With this course, you'll get up to speed with the Structured Query Language (SQL) in an interactive, quick, and easy way. You'll be able to download and use the free trial version of Microsoft SQL Server and understand how to use it confidently. 

You'll start by learning fundamental database concepts, gradually understanding what databases, tables, rows and columns, and data types are. Next, you'll explore how to set up and use Microsoft SQL Server. The course will then delve into SQL, focusing on basic concepts such as SELECT statements; Where, And, or Not; and How to Order and Group By. As you progress, you'll gain insights into comprehensive topics such as Having and Top Clauses; Select Distinct; Union; and Functions. Finally, you'll focus on advanced concepts including Insert and Update Statements; Deleting and Altering Tables; Joining Tables; Primary Keys; and Indexing.

By the end of this course, you'll have the skills you need to effectively use databases with SQL.</p>
        <h2>What You Will Learn</h2><p>Discover the fundamentals of Microsoft SQL Server<br>Explore conditions<br>Understand how to experiment with tables<br>Work with functions</p>
        <h2>Audience</h2><p>This course is for beginners who want to learn SQL, or anyone who wants to understand how to build databases using Microsoft SQL Server.</p>
        <h2>Approach</h2><p>This course will demonstrate how to build databases with Microsoft SQL Server from scratch. You'll cover the theory and implementation through real-world examples.</p>
        <h2>Key Features</h2><p>Install and use Microsoft SQL Server * Gain a basic understanding of databases and their use * Explore SQL and use it with databases</p>
        
        <h2>About the Author</h2><h3>John Elder</h3><p>John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries.

John graduated with honors with a degree in economics from Washington University in St. Louis where he was an artsci scholar. Today he teaches Web Development courses at Codemy the online code school he founded.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>Introduction: Introduction</p></td></tr><tr><td style='padding: 15px;'><p>2. Database Concepts</p><p style='margin: 0'>Introduction: Database Concepts</p></td></tr><tr><td style='padding: 15px;'><p>3. Data Types</p><p style='margin: 0'>Introduction: Data Types</p></td></tr></tbody></table><br><h4>2. Installation and Setup</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Download and Install SQL Server</p><p style='margin: 0'>Installation and Setup: Download and Install SQL Server</p></td></tr><tr><td style='padding: 15px;'><p>2. Download and Install SSMS</p><p style='margin: 0'>Installation and Setup: Download and Install SSMS</p></td></tr><tr><td style='padding: 15px;'><p>3. Connect To Server</p><p style='margin: 0'>Installation and Setup: Connect To Server</p></td></tr><tr><td style='padding: 15px;'><p>4. System Databases</p><p style='margin: 0'>Installation and Setup: System Databases</p></td></tr><tr><td style='padding: 15px;'><p>5. Creating a Database and Table</p><p style='margin: 0'>Installation and Setup: Creating a Database and Table</p></td></tr><tr><td style='padding: 15px;'><p>6. Adding Data To A Table</p><p style='margin: 0'>Installation and Setup: Adding Data To A Table</p></td></tr></tbody></table><br><h4>3. Structured Query Language - SQL</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Intro To SQL</p><p style='margin: 0'>Structured Query Language - SQL: Intro To SQL</p></td></tr><tr><td style='padding: 15px;'><p>2. Select Statements</p><p style='margin: 0'>Structured Query Language - SQL: Select Statements</p></td></tr><tr><td style='padding: 15px;'><p>3. Where Clause</p><p style='margin: 0'>Structured Query Language - SQL: Where Clause</p></td></tr><tr><td style='padding: 15px;'><p>4. And or Not</p><p style='margin: 0'>Structured Query Language - SQL: And or Not</p></td></tr><tr><td style='padding: 15px;'><p>5. Order By</p><p style='margin: 0'>Structured Query Language - SQL: Order By</p></td></tr><tr><td style='padding: 15px;'><p>6. Group By</p><p style='margin: 0'>Structured Query Language - SQL: Group By</p></td></tr><tr><td style='padding: 15px;'><p>7. The Having Clause</p><p style='margin: 0'>Structured Query Language - SQL: The Having Clause</p></td></tr><tr><td style='padding: 15px;'><p>8. The Top Clause</p><p style='margin: 0'>Structured Query Language - SQL: The Top Clause</p></td></tr><tr><td style='padding: 15px;'><p>9. Select Distinct</p><p style='margin: 0'>Structured Query Language - SQL: Select Distinct</p></td></tr><tr><td style='padding: 15px;'><p>10. Union</p><p style='margin: 0'>Structured Query Language - SQL: Union</p></td></tr><tr><td style='padding: 15px;'><p>11. Functions</p><p style='margin: 0'>Structured Query Language - SQL: Functions</p></td></tr><tr><td style='padding: 15px;'><p>12. Insert Statement</p><p style='margin: 0'>Structured Query Language - SQL: Insert Statement</p></td></tr><tr><td style='padding: 15px;'><p>13. Update Statement</p><p style='margin: 0'>Structured Query Language - SQL: Update Statement</p></td></tr><tr><td style='padding: 15px;'><p>14. Delete Statement</p><p style='margin: 0'>Structured Query Language - SQL: Delete Statement</p></td></tr><tr><td style='padding: 15px;'><p>15. Alter Table</p><p style='margin: 0'>Structured Query Language - SQL: Alter Table</p></td></tr><tr><td style='padding: 15px;'><p>16. Null</p><p style='margin: 0'>Structured Query Language - SQL: Null</p></td></tr><tr><td style='padding: 15px;'><p>17. Creating A Table</p><p style='margin: 0'>Structured Query Language - SQL: Creating A Table</p></td></tr><tr><td style='padding: 15px;'><p>18. Drop Table</p><p style='margin: 0'>Structured Query Language - SQL: Drop Table</p></td></tr><tr><td style='padding: 15px;'><p>19. Primary Key</p><p style='margin: 0'>Structured Query Language - SQL: Primary Key</p></td></tr><tr><td style='padding: 15px;'><p>20. Intro To Joining Tables</p><p style='margin: 0'>Structured Query Language - SQL: Intro To Joining Tables</p></td></tr><tr><td style='padding: 15px;'><p>21. Inner Join</p><p style='margin: 0'>Structured Query Language - SQL: Inner Join</p></td></tr><tr><td style='padding: 15px;'><p>22. Left, Right, and Outer Join</p><p style='margin: 0'>Structured Query Language - SQL: Left, Right, and Outer Join</p></td></tr><tr><td style='padding: 15px;'><p>23. Indexing</p><p style='margin: 0'>Structured Query Language - SQL: Indexing</p></td></tr></tbody></table>

Packt

Learn SQL with Microsoft SQL Server

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p></p><p>This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.</p><p></p><p></p><p>This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.</p><p></p></div><div id="course-pills-2"><h3>1 - Introduction to Transact-SQL</h3> <ul> <li>Work with schemas</li> <li>Explore the structure of SQL statements</li> <li>Examine the SELECT statement</li> <li>Work with data types</li> <li>Handle NULLs</li> </ul> <h3>2 - Sort and filter results in T-SQL</h3> <ul> <li>Sort your results</li> <li>Limit the sorted results</li> <li>Page results</li> <li>Remove duplicates</li> <li>Filter data with predicates</li> </ul> <h3>3 - Combine multiple tables with JOINs in T-SQL</h3> <ul> <li>Understand joins concepts and syntax</li> <li>Use inner joins</li> <li>Use outer joins</li> <li>Use cross joins</li> <li>Use self joins</li> </ul> <h3>4 - Write Subqueries in T-SQL</h3> <ul> <li>Understand subqueries</li> <li>Use scalar or multi-valued subqueries</li> <li>Use self-contained or correlated subqueries</li> </ul> <h3>5 - Use built-in functions and GROUP BY in Transact-SQL</h3> <ul> <li>Categorize built-in functions</li> <li>Use scalar functions</li> <li>Use ranking and rowset functions</li> <li>Use aggregate functions</li> <li>Summarize data with GROUP BY</li> <li>Filter groups with HAVING</li> </ul> <h3>6 - Modify data with T-SQL</h3> <ul> <li>Insert data</li> <li>Generate automatic values</li> <li>Update data</li> <li>Delete data</li> <li>Merge data based on multiple tables</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL 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.  <p></p>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.<p></p></div>

Learning & Development

Design & Technology Courses (DT)

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

Database Programming

In this comprehensive course, you will learn everything you need to know about SQL and Microsoft SQL Server, from the basic to advanced topics. With easy-to-follow lessons and hands-on exercises, you will gain the skills and confidence to work with databases like a pro. Perfect for beginners and anyone looking to expand their data management skills.

750 Courses delivered Online

Web Applications for Specialisation on Development Course

By One Education

Data Engineering on Google Cloud

By Nexus Human

Red Hat Services Management and Automation (RH358)

By Nexus Human

B6252 IBM Cognos Framework Manager: Design Metadata Models v11.1.x

By Nexus Human

B6152 IBM Cognos Framework Manager - Design Metadata Models v11.0.x

By Nexus Human

Ethical Hacking with Kali Linux

By Apex Learning

FortiAnalyzer

By Nexus Human

Artificial Intelligence In Digital Marketing

By Course Cloud

Microsoft Excel & Data Analysis - CPD Certified

By Academy for Health and Fitness

Ethical Hacking Complete Course

By Lead Academy