Name: Data Visualization and Reporting with Power BI
Price: 12 GBP
Availability: InStock

Packt

Cloud Computing

With this 2-in-1 course, you will get access to AWS Technical Essentials and AWS Certified Solutions Architect - Associate certification exam content.

AWS Solutions Architect Associate (SAA-C02) Exam Prep Course - 2021 UPDATED!

General Admission

Harpenden

<p>There is a lot to learn in Power BI, this course takes a comprehensive look at the fundamentals of analysing data and includes a balanced look at the four main components that make up Power BI Desktop: Report view, Data view, Model view, and the Power Query Editor. It also demonstrates how to utilise the online Power BI service.</p><p>It looks at authoring tools that enable you to connect to and transform data from a variety of sources, allowing you to produce detailed reports through a range of visualisations, in an interactive and dynamic way.</p><p>It also includes a detailed look at formulas by writing both M functions in Power Query, and DAX functions in Desktop view. This knowledge will allow you to take your reports to the next level.</p><p>The aim of this course is to provide a complete introduction to understanding the Power BI analysis process, by working hands-on with examples that will equip you with the necessary skills to start applying your learning straight away.</p><section>
                    <h3>1 Getting Started</h3><ul><li>The Power BI ecosystem</li><li>Opening Power BI Desktop</li><li>Power BI's four views</li><li>Introduction to Dashboards</li></ul> <h3>2 Importing Files</h3><ul><li>Importing data sources</li><li>Importing an Excel file</li><li>Importing a CSV file</li><li>Importing a database</li><li>Connect to an SQL Server Database</li><li>Import vs. Direct Query</li><li>Importing from the web</li><li>Importing a folder of files</li><li>Managing file connections</li></ul> <h3>3 Shape Data in the Query Editor</h3><ul><li>The process of shaping data</li><li>Managing data types</li><li>Keeping and removing rows</li><li>Add a custom column</li><li>Appending tables together</li><li>Hiding queries in reports</li><li>Fixing error issues</li><li>Basic maths operations</li></ul> <h3>4 The Data Model</h3><ul><li>Table relationships</li><li>Relationship properties</li></ul> <h3>5 Merge Queries</h3><ul><li>Table join kinds</li><li>Merging tables</li></ul> <h3>6 Inserting Dashboard Visuals</h3><ul><li>Things to keep in mind</li><li>Inserting maps</li><li>Formatting Maps</li><li>Inserting charts</li><li>Formatting Charts</li><li>Inserting a tree map</li><li>Inserting a table, matrix, and card</li><li>Controlling number formats</li><li>About report themes</li><li>Highlighting key points</li><li>Filter reports with slicers</li><li>Sync slicers across dashboards</li><li>Custom web visuals</li></ul> <h3>7 Publish and share Reports</h3><ul><li>Publishing to Power BI service</li><li>Editing online reports</li><li>Pinning visuals to a dashboard</li><li>What is Q&amp;A?</li><li>Sharing dashboards</li><li>Exporting reports to PowerPoint</li><li>Exporting reports as PDF files</li></ul> <h3>8 The Power Query Editor</h3><ul><li>Fill data up and down</li><li>Split column by delimiter</li><li>Add a conditional column</li><li>More custom columns</li><li>Merging columns</li></ul> <h3>9 The M Functions</h3><ul><li>Inserting text functions</li><li>Insert an IF function</li><li>Create a query group</li></ul> <h3>10 Pivoting Tables</h3><ul><li>Pivot a table</li><li>Pivot and append tables</li><li>Pivot but don't aggregate</li><li>Unpivot tables</li><li>Append mismatched headers</li></ul> <h3>11 Data Modelling Expanded</h3><ul><li>Understanding relationships</li><li>Mark a date table</li></ul> <h3>12 DAX New Columns</h3><ul><li>New columns and measures</li><li>New column calculations</li><li>Insert a SWITCH function</li></ul> <h3>13 Introduction to DAX Measures</h3><ul><li>Common measure functions</li><li>Insert a SUM function</li><li>Insert a COUNTROWS function</li><li>Insert a DISTINCTCOUNT function</li><li>Insert a DIVIDE function</li><li>DAX rules</li></ul> <h3>14 The CALCULATE Measure</h3><ul><li>The syntax of CALCULATE</li><li>Insert a CALCULATE function</li><li>Control field summarisation</li><li>Things of note</li></ul> <h3>15 The SUMX measure</h3><ul><li>X iterator functions</li><li>Anatomy of SUMX</li><li>Insert a SUMX function</li><li>When to use X functions</li></ul> <h3>16 Time Intelligence Measures</h3><ul><li>Importance of a calendar table</li><li>Insert a TOTALYTD function</li><li>Change financial year end date</li><li>Comparing historical data</li><li>Insert a DATEADD function</li></ul> <h3>17 Hierarchies and Groups</h3><ul><li>Mine data using hierarchies</li><li>Compare data in groups</li></ul> 


                </section>

The In House Training Company

Powerbi

Business Analytics & Intelligence

Microsoft Power BI

Excel Analytics

Microsoft Power Platform

Microsoft BI

Power BI - introduction (2 day) (In-House)

<strong>We are in such an era where cyber security plays an important part. With systems getting smarter, we are seeing machine learning interrupting computer security. With the adoption of machine learning in upcoming security products, it is important for pentesters and security researchers to understand the working of these systems and how to breach them.</strong>
        <p>We are in an era where cyber security plays an important part and the race between attackers and defenders is tremendously growing. Companies are heavily investing to protect their data. Pentesting and privilege escalation tests prove to be a vital step to eradicate or lower down the vulnerabilities within a system, network, or application to detect weaknesses that an attacker could exploit.

Throughout the course, we'll solve a number of vulnerable machines on VulnHub, TryHackMe, and HackTheBox along with the other platforms. The topic of privilege escalation will be thoroughly explained, which provides the best tools to pass a certification such as OSCP. Furthermore, we will not only focus on Linux machines but Windows machines as well.

Important topics that will be covered are as follows:

Advanced Linux
CTF Solutions
Linux Privilege Escalation
Windows Privilege Escalation
Kernel Exploit
SUID
Sudo
Cronjobs
Metasploit
Potato Attacks
Brute Force
Meterpreter Shells

By the end of this course, you will have taken a big step to advance your cyber security career.

Warning: This course aims to provide a good training for people who want to be cyber security professionals. You should not break the law in any way with the offensive penetration test techniques and you accept the responsibility by taking this course.

The resource files are uploaded on the GitHub repository at https://github.com/PacktPublishing/The-Complete-Pentesting-Privilege-Escalation-Course</p>
        <h2>What You Will Learn</h2><p>Explore Kernel Exploit<br>Learn about the Python Reverse Shell<br>Perform Sudo privilege escalation<br>Implement SUID privilege escalation<br>Execute Potato Attack<br>Perform manual privilege escalation</p>
        <h2>Audience</h2><p>If you want to become a cybersecurity professional and want to deepen your knowledge in ethical hacking topics or are preparing yourself for certifications such as OSCP, then you are at the right place. This is an intermediate to advanced course.<br><br>If you want to make the most of it, you should already have a background in cybersecurity and Python. You should have a working Kali Linux or a counterpart system already; this will not be covered during the course. Due to the licensing issues, in the Windows pentest and privilege escalation sections, you will need a 'HackTheBox' membership.</p>
        <h2>Approach</h2><p>This training will be completely hands-on experience but without neglecting the theory. We will cover a lot of scenarios where we solve vulnerable machines, which you will face a lot during pentests and certification exams. The course does not limit exploiting machines using Linux machines but Windows machines as well.<br><br>This will be a big step for you to advance your cybersecurity career.</p>
        <h2>Key Features</h2><p>Execute privilege escalation for Linux * Execute privilege escalation for Windows * Solve CTF (Catch the Flag) solutions and move ahead in the game level</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/The-Complete-Pentesting-Privilege-Escalation-Course</p>
        <h2>About the Author</h2><h3>Codestars By Rob Percival</h3><p>Rob Percival is a highly regarded web developer and Udemy instructor with over 1.7 million students. Over 500,000 of them have taken Rob's Complete Web Developer Course 2.0, as well as his Android Developer and iOS Developer courses.</p><br><h3>Atil Samancioglu</h3><p>Atil Samancioglu is a best-selling online instructor and has instructed more than 80,000 students on Ethical Hacking. Atil has trained more than 20.000 students on the following Ethical Hacking subjects: Kali Linux, Metasploit, metasploitable, social engineering, Nmap, Man-in-the-Middle attacks, MITM proxy, Beef, Wireshark, Maltego, SQL Injection, XSS, social media safety, VPN server creation, Meterpreter, Ettercap, WPA Enterprise. He currently works as eBusiness Team Leader in a multinational company.</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'>This video provides an overview of the tutor and about the AI sciences.</p></td></tr><tr><td style='padding: 15px;'><p>2. Course Manual</p><p style='margin: 0'>This video provides an extension and focus areas about this course in detail.</p></td></tr></tbody></table><br><h4>2. Bandit</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Bandit Introduction</p><p style='margin: 0'>This video provides an introduction to the Bandit wargame. We will work together to solve and go from level 0 to level 3 of this wargame.</p></td></tr><tr><td style='padding: 15px;'><p>2. Bandit File Find Cat</p><p style='margin: 0'>In this video, we will continue with the CTF (Capture the Flag) series; you will advance from level 3 to level 7 in the Bandit wargame.</p></td></tr><tr><td style='padding: 15px;'><p>3. Bandit Strings Grep</p><p style='margin: 0'>In this video, we will continue with the CTF (Capture the Flag) series; you will advance from level 7 to level 9 in the Bandit wargame.</p></td></tr><tr><td style='padding: 15px;'><p>4. Bandit Base64</p><p style='margin: 0'>In this video, we will continue with the CTF (Capture the Flag) series; you will advance from level 9 to level 12 in the Bandit wargame.</p></td></tr><tr><td style='padding: 15px;'><p>5. Bandit Gzip Bzip Tar</p><p style='margin: 0'>In this video, we will continue with the CTF (Capture the Flag) series; you will advance from level 12 to level 15 in the Bandit wargame.</p></td></tr><tr><td style='padding: 15px;'><p>6. Bandit Nmap</p><p style='margin: 0'>In this video, we will continue with the CTF (Capture the Flag) series; you will advance from level 15 to level 17 in the Bandit wargame.</p></td></tr><tr><td style='padding: 15px;'><p>7. Bandit Diff SSH</p><p style='margin: 0'>In this video, we will continue with the CTF (Capture the Flag) series; you will advance from level 17 to level 19 in the Bandit wargame.</p></td></tr><tr><td style='padding: 15px;'><p>8. Bandit SUID</p><p style='margin: 0'>In this video, we will continue with the CTF (Capture the Flag) series; you will advance from level 19 to level 21 in the Bandit wargame.</p></td></tr><tr><td style='padding: 15px;'><p>9. Bandit Cron</p><p style='margin: 0'>In this video, we will continue with the CTF (Capture the Flag) series; you will advance from level 21 to level 23 in the Bandit wargame.</p></td></tr><tr><td style='padding: 15px;'><p>10. Bandit Cron Advanced</p><p style='margin: 0'>In this video, we will continue with the CTF (Capture the Flag) series; you will advance from level 23 to level 24 in the Bandit wargame.</p></td></tr><tr><td style='padding: 15px;'><p>11. Bandit NCat Python</p><p style='margin: 0'>In this video, we will continue with the CTF (Capture the Flag) series; you will advance from level 24 to level 25 in the Bandit wargame.</p></td></tr><tr><td style='padding: 15px;'><p>12. Bandit Vim More</p><p style='margin: 0'>In this video, we will continue with the CTF (Capture the Flag) series; you will advance from level 25 to level 27 in the Bandit wargame.</p></td></tr><tr><td style='padding: 15px;'><p>13. Bandit Git</p><p style='margin: 0'>In this video, we will continue with the CTF (Capture the Flag) series; you will advance from level 27 to level 32 in the Bandit wargame.</p></td></tr><tr><td style='padding: 15px;'><p>14. Bandit Shell</p><p style='margin: 0'>In this video, we will continue with the CTF (Capture the Flag) series; you will advance from level 32 to level 33 in the Bandit wargame.</p></td></tr></tbody></table><br><h4>3. Wakanda</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Wakanda Setup</p><p style='margin: 0'>This video shows the way to set up for the Wakanda CTF (Catch the Flag) series.</p></td></tr><tr><td style='padding: 15px;'><p>2. Web Service</p><p style='margin: 0'>This video will help you analyze the Nmap scan results and try and find the vulnerable service in order to hack the machine.</p></td></tr><tr><td style='padding: 15px;'><p>3. Gathering More Information</p><p style='margin: 0'>This video explains how to gather more information post breaking through the vulnerable machine.</p></td></tr><tr><td style='padding: 15px;'><p>4. Python Reverse Shell</p><p style='margin: 0'>In this video, we will try to change the name of the user from "mamadou" to "devops", which we have hacked.</p></td></tr><tr><td style='padding: 15px;'><p>5. Sudo Privilege Escalation</p><p style='margin: 0'>In this video, we are going to escalate our privilege one more time in the hacked machine.</p></td></tr></tbody></table><br><h4>4. Mr. Robot</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Mr. Robot Setup</p><p style='margin: 0'>This video shows the way to set up for the "Mr. Robot" CTF (Catch the Flag) series.</p></td></tr><tr><td style='padding: 15px;'><p>2. Username Brute Force</p><p style='margin: 0'>This video will help you move ahead with getting the username of the vulnerable machine to solve the puzzle of "Mr. Robot".</p></td></tr><tr><td style='padding: 15px;'><p>3. Password Brute Force</p><p style='margin: 0'>This video will help you move ahead with getting the password of the vulnerable machine to solve the puzzle of "Mr. Robot".</p></td></tr><tr><td style='padding: 15px;'><p>4. Hacking WordPress</p><p style='margin: 0'>This video will be further escalating the CTFs by updating the file in the hacked website's library.</p></td></tr><tr><td style='padding: 15px;'><p>5. Changing User</p><p style='margin: 0'>In this video, we are going to escalate our privilege one more time in the hacked machine.</p></td></tr><tr><td style='padding: 15px;'><p>6. SUID Privilege Escalation</p><p style='margin: 0'>In this video, we are going to escalate our privilege to become root.</p></td></tr></tbody></table><br><h4>5. FristiLeaks</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. FristiLeaks Setup</p><p style='margin: 0'>This video shows the way to set up for the "FristiLeaks" CTF (Catch the Flag) series.</p></td></tr><tr><td style='padding: 15px;'><p>2. Hacking the Server</p><p style='margin: 0'>This video shows how to log in to the server.</p></td></tr><tr><td style='padding: 15px;'><p>3. Switching to Admin</p><p style='margin: 0'>This video explains how to switch the admin in the vulnerable machine.</p></td></tr><tr><td style='padding: 15px;'><p>4. Cryptology</p><p style='margin: 0'>This video shows if we can become root using the admin user access.</p></td></tr><tr><td style='padding: 15px;'><p>5. Root</p><p style='margin: 0'>This video finally helps you get root access to the vulnerable machine.</p></td></tr></tbody></table><br><h4>6. Linux Privilege Escalation</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. TryHackMe Setup</p><p style='margin: 0'>This video shows the way to set up to hack the vulnerable machine from the "TryHackMe" server on Linux.</p></td></tr><tr><td style='padding: 15px;'><p>2. Enumeration</p><p style='margin: 0'>This video explains what our first step of action should be after hacking any vulnerable system.</p></td></tr><tr><td style='padding: 15px;'><p>3. Kernel Exploit</p><p style='margin: 0'>This video explores kernel exploits.</p></td></tr><tr><td style='padding: 15px;'><p>4. More Password Enumeration</p><p style='margin: 0'>This video demonstrates more password enumeration.</p></td></tr><tr><td style='padding: 15px;'><p>5. Sudo List</p><p style='margin: 0'>This video focuses on the sudo list.</p></td></tr><tr><td style='padding: 15px;'><p>6. Shadow</p><p style='margin: 0'>This video explores sudo list and shadow further.</p></td></tr><tr><td style='padding: 15px;'><p>7. Preload</p><p style='margin: 0'>This video explains about the preload command.</p></td></tr><tr><td style='padding: 15px;'><p>8. What is SUID?</p><p style='margin: 0'>This video explains about SUID.</p></td></tr><tr><td style='padding: 15px;'><p>9. SUID Privilege Escalation</p><p style='margin: 0'>This video explores SUID and its use for privilege escalations.</p></td></tr><tr><td style='padding: 15px;'><p>10. Path</p><p style='margin: 0'>This video explains working on the SUID files and looking at path.</p></td></tr><tr><td style='padding: 15px;'><p>11. Environment Variables</p><p style='margin: 0'>This video shows exploiting environmental variables with path.</p></td></tr><tr><td style='padding: 15px;'><p>12. Crontab</p><p style='margin: 0'>This video explains about the cron.d and crontab in order to escalate the privilege further.</p></td></tr><tr><td style='padding: 15px;'><p>13. Sudo Vulnerability</p><p style='margin: 0'>This video explains new concepts to escalate our privilege in Linux.</p></td></tr></tbody></table><br><h4>7. Windows Privilege Escalation</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. HackTheBox Setup</p><p style='margin: 0'>This video shows the way to set up to hack the vulnerable machine from the "HackTheBox" server on Windows.</p></td></tr><tr><td style='padding: 15px;'><p>2. HackTheBox VPN</p><p style='margin: 0'>This video shows the way to set up "HackTheBox" account and VPN.</p></td></tr><tr><td style='padding: 15px;'><p>3. First Machine Setup</p><p style='margin: 0'>This video shows how to set up the machine in order to reach the "Devel" machine, which is vulnerable machine in our case.</p></td></tr><tr><td style='padding: 15px;'><p>4. Hacking Windows</p><p style='margin: 0'>This video explores ways to hack the Windows machine.</p></td></tr><tr><td style='padding: 15px;'><p>5. Windows Command Prompt</p><p style='margin: 0'>In this video, we will dive deep into the Windows commands so that we can move ahead with further escalation.</p></td></tr><tr><td style='padding: 15px;'><p>6. Exploit Suggester</p><p style='margin: 0'>In this video, we will turn the information into valuable suggestion or escalation tips. The focus will be on the escalator suggester.</p></td></tr><tr><td style='padding: 15px;'><p>7. Other Tools</p><p style='margin: 0'>This video talks about the other tools apart from the exploit suggester.</p></td></tr><tr><td style='padding: 15px;'><p>8. Admin</p><p style='margin: 0'>This video explains how to become an administrator for the hacked Windows machine.</p></td></tr><tr><td style='padding: 15px;'><p>9. Potato Attack</p><p style='margin: 0'>This video explores further vulnerabilities in the "Devel" machine and looks at potato attack.</p></td></tr><tr><td style='padding: 15px;'><p>10. Manual Privilege Escalation</p><p style='margin: 0'>This video explores ways to do privilege escalations using manual action.</p></td></tr></tbody></table><br><h4>8. Arctic</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Arctic Setup</p><p style='margin: 0'>This video shows the way to set up to hack the vulnerable machine, "Arctic".</p></td></tr><tr><td style='padding: 15px;'><p>2. Admin Dashboard</p><p style='margin: 0'>In this video, we will try to log in to the administration dashboard of "ColdFusion".</p></td></tr><tr><td style='padding: 15px;'><p>3. ColdFusion</p><p style='margin: 0'>In this video, we are going to upload the shell to the ColdFusion administrator panel.</p></td></tr><tr><td style='padding: 15px;'><p>4. Schelevator</p><p style='margin: 0'>This video explains about the Schelevator module to exploit vulnerable machine.</p></td></tr></tbody></table><br><h4>9. Closing</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Closing</p><p style='margin: 0'>This video demonstrates the further learning guide and it's also a thank you video.</p></td></tr></tbody></table>

Penetration Testing

Kali Linux

Security

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

The Complete Pentesting and Privilege Escalation Course

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This hands-on course is geared for experienced DBAs already working with Oracle.</p>Overview<p>This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises.  Working in a hands-on learning environment led by our expert facilitator, you'll learn how to:<br />Implement backup and recovery settings and perform backup operations to the media of your choice.<br />Move data between databases and files<br />Use Oracle Database recovery processes to recover from media and other failures.<br />Diagnose and repair data failures<br />Use flashback technologies and data duplication to complement backup and recovery procedures<br />Secure the availability of their database using backup and recovery strategies</p><p>Geared for DBAs and other technical support staff, Oracle Database 19c Backup and Recovery is a hands-on course that allows you to develop appropriate backup and recovery procedures to address their business model and requirements.  Throughout the course you?ll explore how to implement basic backup and recovery procedures, move data between databases and files, and employ basic monitoring procedures. You?ll  also learn how to secure the availability of a database by using appropriate backup and recovery strategies, how to how to perform backup and recovery operations using RMAN, and how to use Flashback features to recover from human error. This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises.  Working in a hands-on learning environment led by our expert facilitator, you?ll learn how to:Implement backup and recovery settings and perform backup operations to the media of your choice.Move data between databases and filesUse Oracle Database recovery processes to recover from media and other failures.Diagnose and repair data failuresUse flashback technologies and data duplication to complement backup and recovery proceduresSecure the availability of their database using backup and recovery strategies</p></div><div id="course-pills-2"><h4>Backup Methods</h4><ul><li>User Managed Backups</li><li>Oracle Managed Backups Types of Failures</li><li>Types of Recoveries</li></ul><h4>Recovery Configuration</h4><ul><li>Configuring the Database for Archivelog</li><li>Configuring the Database for No-Archivelog</li><li>Configuring the Flash Recovery Area</li></ul><h4>Configuring RMAN</h4><ul><li>RMAN Default Settings</li><li>Command Line</li><li>Enterprise Manager</li></ul><h4>RMAN Backups</h4><ul><li>Full RMAN Backup</li><li>Compressed Backups</li><li>Uncompressed Backups</li><li>Partial RMAN Backup</li><li>Incremental Backups</li><li>Change Tracking File</li></ul><h4>Managing Backups</h4><ul><li>Backup Reports</li><li>Backup Maintenance</li><li>Backup Catalog</li><li>Backup Crosscheck</li></ul><h4>RMAN Complete Recovery</h4><ul><li>RMAN Complete Recovery</li><li>Database Recovery</li><li>Tablespace Recovery</li><li>Datafile Recovery</li></ul><h4>RMAN In-Complete Recovery</h4><ul><li>Time Based Recovery</li><li>Sequence Based Recovery</li><li>SCN Based Recovery</li></ul><h4>Non-Database File Recovery</h4><ul><li>Spfile Recovery</li><li>Controlfile Recovery</li><li>Incremental Recovery</li><li>Flash Recovery Area for a Fast Recovery</li></ul><h4>User Managed Backup</h4><ul><li>Configuring User Managed Backups</li><li>Perform a User Managed Backup</li></ul><h4>User Managed Recovery</h4><ul><li>User Managed Complete Recovery</li><li>User Managed Incomplete Recovery</li></ul><h4>Configuring Flashback</h4><ul><li>Flashback Query</li><li>Flashback Drop</li><li>Flashback Database</li></ul><h4>Performing Flashback Recoveries</h4><ul><li>Flashback Query</li><li>Flashback Drop</li><li>Flashback Transaction Query</li><li>Flashback Versions Query</li></ul><h4>Performing Flashback Database</h4><ul><li>Determining the FRA Size</li><li>FRA Retention</li><li>Performing a Flashback Database</li></ul><h4>RMAN Duplicate Command</h4><ul><li>Setting up for a Duplicate Database</li><li>Creating the Duplicate spfiles</li><li>Performing the Duplicate Command.</li></ul><h4>RMAN Recovery Catalog</h4><ul><li>Configuring for the Recovery Catalog</li><li>Creating the Recovery Catalog</li></ul><h4>Backups with the Recovery Catalog</h4><ul><li>Registering the Database with the Recovery Catalog</li><li>Performing Backups with the Recovery Catalog</li></ul><h4>Recoveries with the Recovery Catalog</h4><ul><li>Identifying Type of Recoveries with the Recovery Catalog</li><li>Performing Recoveries with the Recovery Catalog</li></ul><h4>Recovery Catalog Maintenance</h4><ul><li>Registering Additional Databases with the Recovery Catalog</li><li>Cataloging Additional Backups with the Recovery Catalog</li><li>Recovery Catalog Scripts</li></ul><h4>DataPump</h4><ul><li>Configuring Datapump</li><li>DataPump Exports</li><li>DataPump Imports</li></ul><h4>Tuning RMAN</h4><ul><li>RMAN Sessions</li><li>RMAN Channels</li><li>RMAN Job Progress</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle 19c Database Backup and Recovery (TTOR21619) 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 Oracle 19c Database Backup and Recovery (TTOR21619) 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>

Nexus Human

Oracle SQL

Oracle

Oracle Fusion HCM

Oracle 1Z0-819

Database Administration

Oracle Database

Oracle 19c Database Backup and Recovery (TTOR21619)

<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 Administrator, Database Administrator, Network Administrator, Systems Administrator.</p>Overview<p>Upon successful completion of this course, students will be able to Configure and use Transparent Data Encryption, Understand and use Oracle Key Vault, Understand Oracle Data Redaction, Understand and use Oracle Data Masking and Subsetting, Understand security risks and identify appropriate Oracle solutions, Configure general authentication and authorization, Understand and implement Global Users, Set up and maintain a simple wallet, Install and use Oracle Database Vault, and Configure and use Transparent Sensitive Data Protection.</p><p>In the Oracle Database Security: Preventive Controls course, students learn how they can use Oracle Database Security products and technologies to meet the security, privacy and compliance requirements of their organization.</p></div><div id="course-pills-2">In the Oracle Database Security: Preventive Controls course, students learn how they can use Oracle Database Security products and technologies to meet the security, privacy and compliance requirements of their organization.</div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Oracle Database Security - Preventive Controls 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 Oracle Database Security - Preventive Controls 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>

Oracle Primavera

AWS Certified Database

Trainers Course

Oracle Database Security - Preventive Controls

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>Application developers who want to build cloud-native applications or redesign existing applications that will run on Google Cloud Platform</p>Overview<p>This course teaches participants the following skills:<br />Use best practices for application development.<br />Choose the appropriate data storage option for application data.<br />Implement federated identity management.<br />Develop loosely coupled application components or microservices.<br />Integrate application components and data sources.<br />Debug, trace, and monitor applications.<br />Perform repeatable deployments with containers and deployment services.<br />Choose the appropriate application runtime environment; use Google Container Engine as a runtime environment and later switch to a no-ops solution with Google App Engine flexible environment.</p><p>Learn how to design, develop, and deploy applications that seamlessly integrate components from the Google Cloud ecosystem. This course uses lectures, demos, and hands-on labs to show you how to use Google Cloud services and pre-trained machine learning APIs to build secure, scalable, and intelligent cloud-native applications.</p></div><div id="course-pills-2"><h4>Best Practices for Application Development</h4><ul><li>Code and environment management.</li><li>Design and development of secure, scalable, reliable, loosely coupled application components and microservices.</li><li>Continuous integration and delivery.</li><li>Re-architecting applications for the cloud.</li></ul><h4>Google Cloud Client Libraries, Google Cloud SDK, and Google Firebase SDK</h4><ul><li>How to set up and use Google Cloud Client Libraries, Google Cloud SDK, and Google Firebase SDK.</li><li>Lab: Set up Google Client Libraries, Cloud SDK, and Firebase SDK on a Linux instance and set up application credentials.</li></ul><h4>Overview of Data Storage Options</h4><ul><li>Overview of options to store application data.</li><li>Use cases for Google Cloud Storage, Cloud Firestore, Cloud Bigtable, Google Cloud SQL, and Cloud Spanner.</li></ul><h4>Best Practices for Using Cloud Firestore</h4><ul><li>Best practices related to using Cloud Firestore in Datastore mode for:Queries, Built-in and composite indexes, Inserting and deleting data (batch operations),Transactions,Error handling.</li><li>Bulk-loading data into Cloud Firestore by using Google Cloud Dataflow.</li><li>Lab: Store application data in Cloud Datastore.</li></ul><h4>Performing Operations on Cloud Storage</h4><ul><li>Operations that can be performed on buckets and objects.</li><li>Consistency model.</li><li>Error handling.</li></ul><h4>Best Practices for Using Cloud Storage</h4><ul><li>Naming buckets for static websites and other uses.</li><li>Naming objects (from an access distribution perspective).</li><li>Performance considerations.</li><li>Setting up and debugging a CORS configuration on a bucket.</li><li>Lab: Store files in Cloud Storage.</li></ul><h4>Handling Authentication and Authorization</h4><ul><li>Cloud Identity and Access Management (IAM) roles and service accounts.</li><li>User authentication by using Firebase Authentication.</li><li>User authentication and authorization by using Cloud Identity-Aware Proxy.</li><li>Lab: Authenticate users by using Firebase Authentication.</li></ul><h4>Using Pub/Sub to Integrate Components of Your Application</h4><ul><li>Topics, publishers, and subscribers.</li><li>Pull and push subscriptions.</li><li>Use cases for Cloud Pub/Sub.</li><li>Lab: Develop a backend service to process messages in a message queue.</li></ul><h4>Adding Intelligence to Your Application</h4><ul><li>Overview of pre-trained machine learning APIs such as Cloud Vision API and Cloud Natural Language Processing API.</li></ul><h4>Using Cloud Functions for Event-Driven Processing</h4><ul><li>Key concepts such as triggers, background functions, HTTP functions.</li><li>Use cases.</li><li>Developing and deploying functions.</li><li>Logging, error reporting, and monitoring.</li></ul><h4>Managing APIs with Cloud Endpoints</h4><ul><li>Open API deployment configuration.</li><li>Lab: Deploy an API for your application.</li></ul><h4>Deploying Applications</h4><ul><li>Creating and storing container images.</li><li>Repeatable deployments with deployment configuration and templates.</li><li>Lab: Use Deployment Manager to deploy a web application into Google App Engine flexible environment test and production environments.</li></ul><h4>Execution Environments for Your Application</h4><ul><li>Considerations for choosing an execution environment for your application or service:Google Compute Engine (GCE),Google Kubernetes Engine (GKE), App Engine flexible environment, Cloud Functions, Cloud Dataflow, Cloud Run.</li><li>Lab: Deploying your application on App Engine flexible environment.</li></ul><h4>Debugging, Monitoring, and Tuning Performance</h4><ul><li>Application Performance Management Tools.</li><li>Stackdriver Debugger.</li><li>Stackdriver Error Reporting.</li><li>Lab: Debugging an application error by using Stackdriver Debugger and Error Reporting.</li><li>Stackdriver Logging.</li><li>Key concepts related to Stackdriver Trace and Stackdriver Monitoring.</li><li>Lab: Use Stackdriver Monitoring and Stackdriver Trace to trace a request across services, observe, and optimize performance.</li></ul></div>

AWS Certified Developer

Cloud Architecture

AWS Certified Cloud Practitioner

Google Suite

Google Cloud

Developing Applications with Google Cloud

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>Cloud Solutions Architects, DevOps Engineers. Individuals using Google Cloud Platform to create new solutions or to integrate existing systems, application environments, and infrastructure with a focus on Google Compute Engine.</p>Overview<p>Configure VPC networks and virtual machines Administer Identity and Access Management for resources Implement data storage services in GCP Manage and examine billing of GCP resources Monitor resources using Stackdriver services Connect your infrastructure to GCP Configure load balancers and autoscaling for VM instances Automate the deployment of GCP infrastructure services Leverage managed services in GCP</p><p>This class introduces participants to the comprehensive and flexible infrastructure and platform services provided by Google Cloud Platform, with a focus on Compute Engine. Through a combination of presentations, demos, and hands-on labs, participants explore and deploy solution elements, including infrastructure components such as networks, systems, and application services. This course also covers deploying practical solutions including securely interconnecting networks, customer-supplied encryption keys, security and access management, quotas and billing, and resource monitoring.</p></div><div id="course-pills-2"><h4>Introduction to Google Cloud Platform</h4><ul><li>List the different ways of interacting with GCP</li><li>Use the GCP Console and Cloud Shell</li><li>Create Cloud Storage buckets</li><li>Use the GCP Marketplace to deploy solutions</li></ul><h4>Virtual Networks</h4><ul><li>List the VPC objects in GCP</li><li>Differentiate between the different types of VPC networks</li><li>Implement VPC networks and firewall rules</li><li>Design a maintenance server</li></ul><h4>Virtual Machines</h4><ul><li>Recall the CPU and memory options for virtual machines</li><li>Describe the disk options for virtual machines</li><li>Explain VM pricing and discounts</li><li>Use Compute Engine to create and customize VM instances</li></ul><h4>Cloud IAM</h4><ul><li>Describe the Cloud IAM resource hierarchy</li><li>Explain the different types of IAM roles</li><li>Recall the different types of IAM members</li><li>Implement access control for resources using Cloud IAM</li></ul><h4>Storage and Database Services</h4><ul><li>Differentiate between Cloud Storage, Cloud SQL, Cloud Spanner, Cloud Firestore and Cloud Bigtable</li><li>Choose a data storage service based on your requirements</li><li>Implement data storage services</li></ul><h4>Resource Management</h4><ul><li>Describe the cloud resource manager hierarchy</li><li>Recognize how quotas protect GCP customers</li><li>Use labels to organize resources</li><li>Explain the behavior of budget alerts in GCP</li><li>Examine billing data with BigQuery</li></ul><h4>Resource Monitoring</h4><ul><li>Describe the Stackdriver services for monitoring, logging, error reporting, tracing, and debugging</li><li>Create charts, alerts, and uptime checks for resources with Stackdriver Monitoring</li><li>Use Stackdriver Debugger to identify and fix errors</li></ul><h4>Interconnecting Networks</h4><ul><li>Recall the GCP interconnect and peering services available to connect your infrastructure to GCP</li><li>Determine which GCP interconnect or peering service to use in specific circumstances</li><li>Create and configure VPN gateways</li><li>Recall when to use Shared VPC and when to use VPC Network Peering</li></ul><h4>Load Balancing and Autoscaling</h4><ul><li>Recall the various load balancing services</li><li>Determine which GCP load balancer to use in specific circumstances</li><li>Describe autoscaling behavior</li><li>Configure load balancers and autoscaling</li></ul><h4>Infrastructure Automation</h4><ul><li>Automate the deployment of GCP services using Deployment Manager or Terraform</li><li>Outline the GCP Marketplace</li></ul><h4>Managed Services</h4><ul><li>Describe the managed services for data processing in GCP</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans Architecting with Google Compute Engine 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 Architecting with Google Compute Engine 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>

Google Workspace

AWS Certified Solutions Architect

Google Digital Marketing

Architecting with Google Compute Engine

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This introductory-level Python course is geared for experienced web developers new to Python who want to use Python and Django for full stack web development projects.</p>Overview<p>Working in a hands-on learning environment, guided by our expert team, attendees will learn to:<br />Develop full-stack web sites based on content stored in an RDMS<br />Use python data types appropriately<br />Define data models<br />Understand the architecture of a Django-based web site<br />Create Django templates for easy-to-modify views<br />Map views to URLs<br />Take advantage of the built-in Admin interface<br />Provide HTML form processing</p><p>Geared for experienced web developers new to Python, Introduction to Full Stack Web Development with Python and Django is a five-day hands-on course that teaches students how to develop Web applications using the Django framework. Students will explore the basics of creating basic applications using the MVC (model-view-controller) design pattern, as well as more advanced topics such as administration, session management, authentication, and automated testing. This comprehensive, practical course provides an in-depth exploration of working with the programming language, not an academic overview of syntax and grammar.  Students will immediately be able to use Python to complete tasks in the real world.</p></div><div id="course-pills-2"><h4>The Python Environment</h4><ul><li>Starting Python</li><li>Using the interpreter</li><li>Running a Python script</li><li>Getting help</li><li>Editors and IDEs</li></ul><h4>Getting Started</h4><ul><li>Using variables</li><li>Built in functions</li><li>Strings</li><li>Numbers</li><li>Converting among types</li><li>Writing to the screen</li><li>Command line parameters</li></ul><h4>Flow Control</h4><ul><li>About flow control<br />Conditional expressions<br />Relational and Boolean operators<br />while loops</li></ul><h4>Lists and Tuples</h4><ul><li>About sequences<br />Lists and list methods<br />Tuples<br />Indexing and slicing<br />Iterating through a sequence<br />Sequence functions, keywords, and operators<br />List comprehensions</li></ul><h4>Working with Files</h4><ul><li>File overview<br />The with statement<br />Opening a file<br />Reading/writing files</li></ul><h4>Dictionaries and Sets</h4><ul><li>About dictionaries<br />Creating and using dictionaries<br />About sets<br />Creating and using sets</li></ul><h4>Functions</h4><ul><li>Returning values<br />Function parameters<br />Variable Scope<br />Sorting with functions</li></ul><h4>Errors and Exception Handling</h4><ul><li>Exception overview</li><li>Using try/catch/else/finally</li><li>Handling multiple exceptions</li><li>Ignoring exceptions</li></ul><h4>Modules and Packages</h4><ul><li>Creating Modules</li><li>The import statement</li><li>Module search path</li><li>Creating packages</li></ul><h4>Classes</h4><ul><li>About OO programming</li><li>Defining classes</li><li>Constructors</li><li>Properties</li><li>Instance methods and data</li><li>Class/static methods and data</li><li>Inheritance</li></ul><h4>Django Architecture</h4><ul><li>Django overview</li><li>Sites and apps</li><li>Shared configuration</li><li>Minimal Django layout</li><li>Built in flexibility</li></ul><h4>Configuring a Project</h4><ul><li>Executing manage.py</li><li>Starting the project</li><li>Generating app files</li><li>App configuration</li><li>Database setup</li><li>The development server</li><li>Using cookiecutter</li></ul><h4>Creating models</h4><ul><li>Defining models</li><li>Related objects</li><li>SQL Migration</li><li>Simplel model access</li></ul><h4>Login for Nothing and Admin for Free</h4><ul><li>Setting up the admin user</li><li>Using the admin interface</li></ul><h4>Views</h4><ul><li>What is a view</li><li>HttpResponse</li><li>URL route configuration</li><li>Shortcut: get_object_or_404()</li><li>Class-based views</li></ul><h4>Templates</h4><ul><li>About templates</li><li>Variable lookups</li><li>The url tag</li><li>Shortcut: render()</li></ul><h4>Querying Models</h4><ul><li>QuerySets</li><li>Field lookups</li><li>Chaining filters</li><li>Slicing QuerySets</li><li>Related fields</li><li>Q objects</li></ul><h4>Advanced Templates Use</h4><ul><li>Comments</li><li>Inheritance</li><li>Filters</li><li>Escaping HTML</li><li>Custom filters</li></ul><h4>Forms</h4><ul><li>Forms overview</li><li>GET and POST</li><li>The Form class</li><li>Processing the form</li><li>Widgets</li><li>Validation</li><li>Forms in templates</li></ul><h4>Automated Testing</h4><ul><li>Why create tests?</li><li>When to create tests</li><li>Using Django's test framework</li><li>Using the test client</li><li>Running tests</li><li>Checking code coverage</li></ul></div>

Online Course Creation

Design & Technology Courses (DT)

Web Development

Full Stack Developer

Back End Web Development

Full Stack Web Development with Python and Django (TTPS4860)

<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 Administrator, Database Administrator, End User, Network Administrator, and Systems Administrator.</p>Overview<p>Upon completion of this course, students will be able to Describe and determine database security requirements, Understand Oracle security solutions to help meet security requirements, Implement basic database security, Configure network security, and Discover basic security configuration issues.</p><p>This Introduction to Oracle Database Security Ed 1 training teaches you how to use Oracle Database features to help meet the security, privacy and compliance requirements of your organization.</p></div><div id="course-pills-2"><h4>Introduction</h4><ul><li>Course Objectives</li><li>Course Schedule</li><li>Detective Security Controls</li><li>Preventive Security Controls</li><li>Your Learning Aids</li><li>Basic Workshop Architecture</li><li></li></ul><h4>Understanding Security Requirements</h4><ul><li>Fundamental Data Security Requirements</li><li>Security Risks</li><li>Techniques to Enforce Security</li></ul><h4>Choosing Security Solutions</h4><ul><li>Database Access Control: Authentication</li><li>Protecting Against Database Bypass with Encryption</li><li>Protecting Sensitive Data</li><li>Protecting against Application Bypass</li><li>Detecting Threats</li><li>Compliance</li></ul><h4>Implementing Basic Database Security</h4><ul><li>Database Security Checklist</li><li>Reducing Administrative Effort</li><li>Principle of Least Privilege</li><li>Objects Protection</li><li></li></ul><h4>Configuring Network Security</h4><ul><li>Network Access Control</li><li>Listener Security</li><li>Listener Usage Control</li><li>Manage fine-grained access to external network services</li></ul><h4>Discovering Basic Configuration Issues</h4><ul><li>Accessing Enterprise Manager Security Reports</li><li>Using Various Security Reports</li></ul></div>

IT Security

Basic Security Training (BST)

Data Security

Introduction to Oracle Database Security Ed 1

<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 <strong>Data Visualization and Reporting with Power BI</strong></span> 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 <strong>Data Visualization and Reporting with Power BI</strong></span> comes with accredited certification from CPD, 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>
			<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.<br /></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 <strong>Data Visualization and Reporting with Power BI</strong></span>. 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 <strong>Data Visualization and Reporting with Power BI</strong></span> 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>Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-</p><ul><li>Open doors of opportunities</li><li>Increase your adaptability</li><li>Keep you relevant</li><li>Boost confidence</li></ul><p>And much more!</p>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
						</div>
					</div> <h3>Course Curriculum</h3><div><p>15 sections • 140 lectures • 14:25:00 total length</p></div><div><div><div><div><div><div><div><p>•Welcome!: 00:01:00</p></div><div><div><p>•What is Power BI?: 00:03:00</p></div><div><div><p>•Download &amp; Installing Power BI Desktop: 00:04:00</p></div><div><div><p>•Getting to know the interface: 00:03:00</p></div><div><div><p>•Mini Project: Transform Data: 00:07:00</p></div><div><div><p>•Mini Project: Visualize Data: 00:05:00</p></div><div><div><p>•Mini Project: Creating a Data Model: 00:07:00</p></div><div><div><p>•Course Outline: What will you learn in this course?: 00:05:00</p></div><div><div><p>•How to learn best with this course?: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Creating our initial project file: 00:04:00</p></div><div><div><p>•Working with the attached project files: 00:04:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Exploring the Query Editor: 00:06:00</p></div><div><div><p>•Connecting to our data source: 00:07:00</p></div><div><div><p>•Editing rows: 00:08:00</p></div><div><div><p>•Changing data types: 00:08:00</p></div><div><div><p>•Replacing values: 00:03:00</p></div><div><div><p>•Close &amp; Apply: 00:03:00</p></div><div><div><p>•Connecting to a csv file: 00:03:00</p></div><div><div><p>•Connecting to a web page: 00:05:00</p></div><div><div><p>•Extracting characters: 00:06:00</p></div><div><div><p>•Splitting &amp; merging columns: 00:09:00</p></div><div><div><p>•Creating conditional columns: 00:06:00</p></div><div><div><p>•Creating columns from examples: 00:09:00</p></div><div><div><p>•Merging Queries: 00:17:00</p></div><div><div><p>•Pivoting &amp; Unpivoting: 00:06:00</p></div><div><div><p>•Appending Queries: 00:08:00</p></div><div><div><p>•Practice &amp; Solution: Population table: 00:15:00</p></div><div><div><p>•The Fact-Dimension-Model: 00:09:00</p></div><div><div><p>•Practice: Load the dimension table: 00:04:00</p></div><div><div><p>•Organizing our queries in groups: 00:03:00</p></div><div><div><p>•Entering data manually: 00:05:00</p></div><div><div><p>•Creating an index column: 00:03:00</p></div><div><div><p>•Workflow &amp; more transformations: 00:05:00</p></div><div><div><p>•Module summary: 00:05:00</p></div><div><div><p>•Exercise  1 - Instruction: 00:02:00</p></div><div><div><p>•Exercise  1 - Exercise Solution: 00:11:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Advanced Editor - Best practices: 00:09:00</p></div><div><div><p>•Performance: References vs. Duplicating: 00:10:00</p></div><div><div><p>•Performance: Enable / Disable Load &amp; Report Refresh: 00:05:00</p></div><div><div><p>•Group by: 00:05:00</p></div><div><div><p>•Mathematical Operations: 00:05:00</p></div><div><div><p>•Run R Script: 00:15:00</p></div><div><div><p>•Using Parameters to dynamically transform data: 00:06:00</p></div><div><div><p>•M formula language: Basics: 00:07:00</p></div><div><div><p>•M formula language: Values, Lists &amp; Tables: 00:14:00</p></div><div><div><p>•M formula language: Functions: 00:13:00</p></div><div><div><p>•M formula language: More functions &amp; steps: 00:05:00</p></div><div><div><p>•Exercise 2 - Instructions: 00:01:00</p></div><div><div><p>•Exercise 2 - solution: 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Understanding the relationship: 00:05:00</p></div><div><div><p>•Create &amp; edit relationships: 00:06:00</p></div><div><div><p>•One-to-many &amp; one-to-one relationship: 00:06:00</p></div><div><div><p>•Many-to-many (m:n) relationship: 00:08:00</p></div><div><div><p>•Cross filter direction: 00:06:00</p></div><div><div><p>•Activate &amp; deactivate relationships: 00:06:00</p></div><div><div><p>•Model summary: 00:03:00</p></div><div><div><p>•Exercise 3 Create Model: 00:02:00</p></div><div><div><p>•Exercise 3 Solution: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Our first visual: 00:08:00</p></div><div><div><p>•The format tab: 00:12:00</p></div><div><div><p>•Understanding tables: 00:10:00</p></div><div><div><p>•Conditional formatting: 00:09:00</p></div><div><div><p>•The Pie Chart: 00:06:00</p></div><div><div><p>•All about the filter visual: 00:13:00</p></div><div><div><p>•The filter pane for developers: 00:09:00</p></div><div><div><p>•Cross filtering &amp; edit interactions: 00:04:00</p></div><div><div><p>•Syncing slicers across pages: 00:07:00</p></div><div><div><p>•Creating drill downs: 00:08:00</p></div><div><div><p>•Creating drill throughs: 00:07:00</p></div><div><div><p>•The tree map visual: 00:07:00</p></div><div><div><p>•The decomposition tree: 00:05:00</p></div><div><div><p>•Understanding the matrix visual: 00:05:00</p></div><div><div><p>•Editing pages: 00:07:00</p></div><div><div><p>•Buttons &amp; Actions: 00:09:00</p></div><div><div><p>•Bookmarks to customize your report: 00:10:00</p></div><div><div><p>•Analytics and Forecasts with line charts: 00:10:00</p></div><div><div><p>•Working with custom visuals: 00:07:00</p></div><div><div><p>•Get data using R Script &amp; R Script visual: 00:08:00</p></div><div><div><p>•Asking questions - Q&amp;A visual: 00:04:00</p></div><div><div><p>•Wrap up - data visualization: 00:08:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Python in Power BI - Plan of attack: 00:03:00</p></div><div><div><p>•Setting up Python for Power BI: 00:03:00</p></div><div><div><p>•Transforming data using Python: 00:11:00</p></div><div><div><p>•Creating visualizations using Python: 00:08:00</p></div><div><div><p>•Violin plots, pair plots &amp; ridge plots using Python: 00:15:00</p></div><div><div><p>•Machine learning (BayesTextAnalyzer) using Python: 00:00:00</p></div><div><div><p>•Performance &amp; Troubleshooting: 00:03:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:01:00</p></div><div><div><p>•Show Empathy &amp; Identify the Requirement: 00:03:00</p></div><div><div><p>•Finding the Most Suitable KPI's: 00:02:00</p></div><div><div><p>•Choose an Effective Visualization: 00:04:00</p></div><div><div><p>•Make Use of Natural Reading Pattern: 00:03:00</p></div><div><div><p>•Tell a Story Using Visual Cues: 00:05:00</p></div><div><div><p>•Avoid Chaos &amp; Group Information: 00:02:00</p></div><div><div><p>•Warp Up - Storytelling with Data: 00:02:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:03:00</p></div><div><div><p>•The project data: 00:04:00</p></div><div><div><p>•Measures vs. Calculated Columns: 00:15:00</p></div><div><div><p>•Automatically creating a date table in DAX: 00:08:00</p></div><div><div><p>•CALENDAR: 00:05:00</p></div><div><div><p>•Creating a complete date table with features: 00:04:00</p></div><div><div><p>•Creating key measure table: 00:03:00</p></div><div><div><p>•Aggregation functions: 00:06:00</p></div><div><div><p>•The different versions of COUNT: 00:14:00</p></div><div><div><p>•SUMX - Row based calculations: 00:09:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•CALCULATE - The basics: 00:11:00</p></div><div><div><p>•Changing the context with FILTER: 00:07:00</p></div><div><div><p>•ALL: 00:08:00</p></div><div><div><p>•ALL SELECTED: 00:03:00</p></div><div><div><p>•ALL EXCEPT: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•How to go on now?: 00:03:00</p></div><div><div><p>•Power BI Pro vs Premium &amp; Signing up: 00:04:00</p></div><div><div><p>•Exploring the interface: 00:04:00</p></div><div><div><p>•Discovering your workspace: 00:03:00</p></div><div><div><p>•Connecting Power BI Desktop &amp; Cloud: 00:04:00</p></div><div><div><p>•Understanding datasets &amp; reports: 00:03:00</p></div><div><div><p>•Working on reports: 00:04:00</p></div><div><div><p>•Updating reports from Power BI Desktop: 00:04:00</p></div><div><div><p>•Creating and working with workspaces: 00:07:00</p></div><div><div><p>•Installing &amp; using a data gateway: 00:13:00</p></div><div><div><p>•Get Quick Insights: 00:03:00</p></div><div><div><p>•Creating dashboards: 00:04:00</p></div><div><div><p>•Sharing our results through Apps: 00:10:00</p></div><div><div><p>•Power BI Mobile App: 00:05:00</p></div><div><div><p>•Creating the layout for the Mobile App: 00:04:00</p></div><div><div><p>•Wrap up - Power BI Cloud: 00:07:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Introduction: 00:03:00</p></div><div><div><p>•Creating a Row-Level Security: 00:05:00</p></div><div><div><p>•Row-Level Security in the Cloud: 00:04:00</p></div><div><div><p>•Row-Level Security &amp; Data Model: 00:05:00</p></div><div><div><p>•Dynamic Row-Level Security: 00:07:00</p></div><div><div><p>•Dynamic Many-to-Many RLS: 00:04:00</p></div><div><div><p>•Hierarchical Row-Level Security: 00:13:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•JSON &amp; REST API: 00:10:00</p></div><div><div><p>•Setting up a local MySQL database: 00:14:00</p></div><div><div><p>•Connecting to a MySQL database in Power BI: 00:05:00</p></div><div><div><p>•Connecting to a SQL database (PostgreSQL): 00:05:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Congratulations &amp; next steps: 00:06:00</p></div><div><div><p>•The End: 00:01:00</p></div></div></div></div></div><div><div><div><div><div><div><p>•Resources - Data Visualization and Reporting with Power BI: 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>

Apex Learning

Data Visualization

Data Skills

Data Visualization and Reporting with Power BI

<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)

Commercial & Contract Management Certification Program (CCM)

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

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.

One Education

IT Certifications

Microsoft Certified Solutions Associate (MCSA)

Bootcamp

Microsoft SQL Server Bootcamp 2022 Course

<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>

Learn SQL with Microsoft SQL Server

<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

<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

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

AWS Solutions Architect Associate (SAA-C02) Exam Prep Course - 2021 UPDATED!

By Packt

Power BI - introduction (2 day) (In-House)

By The In House Training Company

The Complete Pentesting and Privilege Escalation Course

By Packt

Oracle 19c Database Backup and Recovery (TTOR21619)

By Nexus Human

Oracle Database Security - Preventive Controls

By Nexus Human

Developing Applications with Google Cloud

By Nexus Human

Architecting with Google Compute Engine

By Nexus Human

Full Stack Web Development with Python and Django (TTPS4860)

By Nexus Human

Introduction to Oracle Database Security Ed 1

By Nexus Human

Data Visualization and Reporting with Power BI

By Apex Learning