Name: Real-Time Data Stream Processing in Azure
Price: 22.99 GBP
Availability: InStock

<div id="course-pills-1">Duration<p>1 Days</p><p>6 CPD hours</p>This course is intended for<p>This workshop is intended for Cloud Architects and IT professionals who have architectural expertise of infrastructure and solutions design in cloud technologies and want to learn more about Azure and Azure services</p>Overview<p>At the end of this whiteboard design session, you will leave with the information needed to develop a solid migration plan to keep mission-critical apps and data protected as they are transitioned and modernized. Topics covered will include how to get an inventory of a 2008 server environment, how to categorize 2008 workloads and evaluate the best option for each category, migration and upgrade tools available, TCO analysis tools, offers available from Microsoft to leverage existing licenses and innovations of recent product updates, licensing and technologies.</p><p>This course will look at the process of migrating workloads to Azure. You will leave with the information needed to develop a solid migration plan to keep mission-critical apps and data protected as your customers transition and modernize their application, data, and infrastructure environment.</p></div><div id="course-pills-2"><h4>Whiteboard Design Session - Windows Server 2008 and SQL Server 2008 end of support planning</h4><ul><li>Review the customer case study </li><li>Design a proof of concept solution</li><li>Present the solution</li></ul></div>

Nexus Human

Microsoft Certification

Microsoft AZ-900

Microsoft AZ-104

Microsoft Azure

Microsoft AZ-303

Microsoft AZ-700

40550 Microsoft Cloud Workshop - Windows Server and SQL Server 2008 EOS planning

<strong>This course focuses on the beginner-level concepts of cloud computing in two different arenas.

The first part is to explore the world of database technologies or DBaaS (Database as a Service) and the second part revolves around IaaS (Infrastructure as a Service) model.</strong>
        <p>Over the last couple of years, many business companies decided to use more and more cloud services as part of their digital transformation, and you already know data is the new gold.

Therefore, this course is predominantly divided into two important parts: database technologies and infrastructure as a service.

The first part is about databases technologies and, even more specifically, how such technologies are offered as cloud database services (DBaaS) by leading public cloud providers-Azure, AWS, and GCP. We will learn the technical concept, market use cases, advantages, and disadvantages of each database technology while following its evolution path.

The next part is about the IaaS model. The IaaS model provided by large cloud providers is helping companies transform their private IT infrastructure into a utility service.

As a first step, you will review the key terms in cloud computing to establish a clear understanding of the big picture, and then we will zoom in on the IaaS model. The look at building blocks, what are the typical use cases, advantages as well as disadvantages, pricing models, and more.

By the end of this course, you will be able to select the right database technology for a specific use case to dramatically affect any aspect of an application and learn about the IaaS model of cloud computing.

The resource files are uploaded on the GitHub repository at https://github.com/PacktPublishing/Cloud-Computing-for-Beginners---Database-Technologies-and-Infrastructure-as-a-Service</p>
        <h2>What You Will Learn</h2><p>Look at batch and stream processing, operational and analytics data<br>Understand SQL, NoSQL, NewSQL technologies<br>DBaaS portfolio overview - Azure, AWS, GCP<br>Learn the four service models - SaaS, PaaS, IaaS, and FaaS<br>Microservice and cloud-native apps, and different types of clouds<br>Virtualization technologies - virtual machines and containers</p>
        <h2>Audience</h2><p>This course is designed for the software developers, IT professionals, product/project/marketing managers who wish to reduce the footprint of enterprise applications sitting in private data centers and leverage the capabilities in a public cloud environment. Solution architects, technical advisors, telecom experts, and security professionals can also get benefit from this course.<br><br>You don't need to have prior knowledge of cloud computing concepts.</p>
        <h2>Approach</h2><p>This is a hands-on course designed for beginner-level individuals in the field of cloud computing. There are two parts in the course; the first focuses on database technologies and the other on the infrastructure model.</p>
        <h2>Key Features</h2><p>Learn the technical concept, market use cases, advantages, and disadvantages of the DBaaS model * Learn the technical concept, market use cases, advantages, and disadvantages of the IaaS model * Review key terms in cloud computing to establish a clear understanding</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Cloud-Computing-for-Beginners---Database-Technologies-and-Infrastructure-as-a-Service</p>
        <h2>About the Author</h2><h3>Idan Gabrieli</h3><p>Idan Gabrieli has worked in various engineering positions in Israel's high-tech industry. Idan has gained extensive experience with hundreds of business companies, transforming their challenges and opportunities into practical use cases and leveraging cutting-edge technologies.

Idan's expertise spans multiple domains, including cloud computing, machine learning, data science, and electronics. Since 2014, Idan has created and published online courses on various topics worldwide. Idan is recognized as a high-rated instructor by leading educational providers.

Idan simplifies complex technology and provides high-quality educational content with specific learning objectives that are well-structured, combining various multimedia teaching options.</p>
        <h2>Course Outline</h2><h4>1. Introduction to the Course</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Data is Everywhere</p><p style='margin: 0'>This video provides an overview of the course.</p></td></tr><tr><td style='padding: 15px;'><p>2. Our Learning Objectives</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. Basic Database Terminology</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Overview</p><p style='margin: 0'>This video provides an overview of the section.</p></td></tr><tr><td style='padding: 15px;'><p>2. DBMS, Database Instance and Schema</p><p style='margin: 0'>This video explains the DBMS (Database management System), database instance and schema.</p></td></tr><tr><td style='padding: 15px;'><p>3. Operational Data and OLTP</p><p style='margin: 0'>This video explains operational data and OLTP (Online Transaction Processing).</p></td></tr><tr><td style='padding: 15px;'><p>4. Analytics Data and OLAP</p><p style='margin: 0'>This video explains analytics and OLAP (Online Analytical Processing).</p></td></tr><tr><td style='padding: 15px;'><p>5. Data Warehouse and Data Lake</p><p style='margin: 0'>This video explains about the data warehouse and data lake.</p></td></tr><tr><td style='padding: 15px;'><p>6. ETL and ELT</p><p style='margin: 0'>This video explains ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform).</p></td></tr><tr><td style='padding: 15px;'><p>7. Batch and Stream Processing</p><p style='margin: 0'>This video explains the batch and stream processing.</p></td></tr><tr><td style='padding: 15px;'><p>8. Scaling Up and Out</p><p style='margin: 0'>This video explains about scaling up and out.</p></td></tr></tbody></table><br><h4>3. Database Technologies - What, Where, and Why?</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Overview</p><p style='margin: 0'>This video provides an overview of the section.</p></td></tr><tr><td style='padding: 15px;'><p>2. Traditional Relational Database (SQL)</p><p style='margin: 0'>This video focuses on a traditional relational database.</p></td></tr><tr><td style='padding: 15px;'><p>3. Non-relational Database (NoSQL)</p><p style='margin: 0'>This video explains about the non-relational database.</p></td></tr><tr><td style='padding: 15px;'><p>4. Distributed SQL Database (NewSQL)</p><p style='margin: 0'>This video helps to understand about the distributed SQL database.</p></td></tr><tr><td style='padding: 15px;'><p>5. In-memory Database (IMDB)</p><p style='margin: 0'>This video talks about in-memory database.</p></td></tr><tr><td style='padding: 15px;'><p>6. Time Series Database (TSDB)</p><p style='margin: 0'>This video helps you understand the time series database.</p></td></tr></tbody></table><br><h4>4. Types of NoSQL Databases</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Overview</p><p style='margin: 0'>This video provides an overview of the section.</p></td></tr><tr><td style='padding: 15px;'><p>2. #1 - Key-value Database</p><p style='margin: 0'>This video demonstrates the key-value database.</p></td></tr><tr><td style='padding: 15px;'><p>3. #2 - Document Database</p><p style='margin: 0'>This video talks about the document database.</p></td></tr><tr><td style='padding: 15px;'><p>4. #3 - Wide Column Database</p><p style='margin: 0'>This video talks about the wide column database.</p></td></tr><tr><td style='padding: 15px;'><p>5. #4 - Graph Database</p><p style='margin: 0'>This video talks about the graph database.</p></td></tr><tr><td style='padding: 15px;'><p>6. Databases Ranking Review</p><p style='margin: 0'>This video explains the databases ranking review.</p></td></tr></tbody></table><br><h4>5. Database as a Service (DBaaS)</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Overview</p><p style='margin: 0'>This video provides an overview of the section.</p></td></tr><tr><td style='padding: 15px;'><p>2. The Challenges of Traditional Databases</p><p style='margin: 0'>This video demonstrates the challenges of traditional databases.</p></td></tr><tr><td style='padding: 15px;'><p>3. The Concept of DBaaS</p><p style='margin: 0'>This video explains the concept of DBaaS.</p></td></tr><tr><td style='padding: 15px;'><p>4. The Advantages of DBaaS</p><p style='margin: 0'>This video shows the advantages of DBaaS.</p></td></tr><tr><td style='padding: 15px;'><p>5. Azure - DBaaS Portfolio Review</p><p style='margin: 0'>This video shows the DBaaS portfolio review of Azure platform.</p></td></tr><tr><td style='padding: 15px;'><p>6. AWS - DBaaS Portfolio Review</p><p style='margin: 0'>This video shows the DBaaS portfolio review of AWS platform.</p></td></tr><tr><td style='padding: 15px;'><p>7. GCP - DBaaS Portfolio Review</p><p style='margin: 0'>This video shows the DBaaS portfolio review of GCP platform.</p></td></tr></tbody></table><br><h4>6. Summary</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Quick Recap and Thank You!</p><p style='margin: 0'>This video helps with the recap of the concepts learned so far.</p></td></tr></tbody></table><br><h4>7. Getting Started</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Welcome</p><p style='margin: 0'>This video provides an introduction to this part.</p></td></tr><tr><td style='padding: 15px;'><p>2. Our Learning Objectives</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>8. Cloud Computing</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Welcome to the World of Cloud Computing</p><p style='margin: 0'>This video provides an introduction to the cloud computing concepts.</p></td></tr><tr><td style='padding: 15px;'><p>2. Private vs Public</p><p style='margin: 0'>This video explains the difference between private and public cloud computing.</p></td></tr><tr><td style='padding: 15px;'><p>3. Hybrid-cloud and Multi-cloud</p><p style='margin: 0'>This video explains the hybrid-cloud and multi-cloud.</p></td></tr><tr><td style='padding: 15px;'><p>4. Hyperscale Cloud Service Providers</p><p style='margin: 0'>This video explains the hyperscale cloud service providers.</p></td></tr><tr><td style='padding: 15px;'><p>5. Cloud Service Models</p><p style='margin: 0'>This video explains the cloud service models.</p></td></tr><tr><td style='padding: 15px;'><p>6. SaaS - Software as a Service</p><p style='margin: 0'>This video talks about SaaS - Software as a Service.</p></td></tr><tr><td style='padding: 15px;'><p>7. IaaS - Infrastructure as a Service</p><p style='margin: 0'>This video talks about IaaS - Infrastructure as a Service.</p></td></tr><tr><td style='padding: 15px;'><p>8. PaaS - Platform as a Service</p><p style='margin: 0'>This video talks about PaaS - Platform as a Service.</p></td></tr><tr><td style='padding: 15px;'><p>9. FaaS - Function as a Service</p><p style='margin: 0'>This video talks about FaaS - Function as a Service.</p></td></tr><tr><td style='padding: 15px;'><p>10. Demo - AWS, Azure, GCP</p><p style='margin: 0'>This video provides demo on the various cloud service provides - AWS, Azure, and GCP.</p></td></tr></tbody></table><br><h4>9. Virtualization Technologies</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video provides an introduction to the section.</p></td></tr><tr><td style='padding: 15px;'><p>2. Underutilized Physical Servers</p><p style='margin: 0'>This video talks about underutilized physical servers.</p></td></tr><tr><td style='padding: 15px;'><p>3. Virtualization with Virtual Machines</p><p style='margin: 0'>This video demonstrates how to do virtualization with virtual machines.</p></td></tr><tr><td style='padding: 15px;'><p>4. Vertical and Horizontal Scaling</p><p style='margin: 0'>This video explains the vertical and horizontal scaling.</p></td></tr><tr><td style='padding: 15px;'><p>5. Microservices and Cloud-Native Apps</p><p style='margin: 0'>This video focuses on microservices and cloud-native apps.</p></td></tr><tr><td style='padding: 15px;'><p>6. Virtualization with Containers</p><p style='margin: 0'>This video demonstrates how to do virtualization with containers.</p></td></tr><tr><td style='padding: 15px;'><p>7. The Benefits of Containers</p><p style='margin: 0'>This video demonstrates the benefits of containers.</p></td></tr></tbody></table><br><h4>10. Introduction to Infrastructure as a Service (IaaS)</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction and Overview</p><p style='margin: 0'>This video provides an overview and introduction to the section.</p></td></tr><tr><td style='padding: 15px;'><p>2. IaaS - Transform IT to Utility</p><p style='margin: 0'>This video explains how to transform IT to utility in IaaS.</p></td></tr><tr><td style='padding: 15px;'><p>3. Compute, Storage and Networking</p><p style='margin: 0'>This video focuses on compute, storage and networking.</p></td></tr><tr><td style='padding: 15px;'><p>4. Demo - IaaS Solution with Microsoft Azure</p><p style='margin: 0'>This video provides a demo on IaaS solution with Microsoft Azure.</p></td></tr><tr><td style='padding: 15px;'><p>5. Pricing Models</p><p style='margin: 0'>This video talks about the pricing models in Microsoft Azure.</p></td></tr><tr><td style='padding: 15px;'><p>6. Main Advantages</p><p style='margin: 0'>This video focuses on the advantages of IaaS.</p></td></tr><tr><td style='padding: 15px;'><p>7. Disadvantages</p><p style='margin: 0'>This video tells the disadvantages of IaaS.</p></td></tr><tr><td style='padding: 15px;'><p>8. Typical Market Use Cases</p><p style='margin: 0'>This video explains the typical market use cases.</p></td></tr></tbody></table><br><h4>11. Course Summary</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Let's Recap and Thank You!</p><p style='margin: 0'>This video helps with a recap of the concepts learned so far.</p></td></tr></tbody></table>

Packt

Cloud Computing

This course focuses on the beginner-level concepts of cloud computing in two different arenas.

The first part is to explore the world of database technologies or DBaaS (Database as a Service) and the second part revolves around IaaS (Infrastructure as a Service) model.

Cloud Computing for Beginners - Database Technologies and Infrastructure as a Service

General Admission

<p>Embark on a transformative journey into the realm of data mastery with our comprehensive course, '<strong>Advanced SAS Programming Using MacrosSQL.</strong>' From demystifying the intricacies of SAS Studio to unlocking the potential of Proc SQL, this course is a gateway to proficiency in SAS programming and macro scripting. The curriculum, thoughtfully designed to accommodate learners of all levels, takes you through the essential foundations of SAS, the nuances of macro variables, and the power-packed functionalities of Proc SQL. Dive into the world of nested macro variables, conditional logic, and data manipulation, all while honing your skills through practical examples. This course isn't just about learning syntax; it's a hands-on exploration that empowers you to seamlessly connect the dots between SAS Studio and Proc SQL, bringing your data analytics capabilities to new heights.</p>
<p><strong>Learning Outcomes</strong></p>
<ul>
<li>Master the fundamentals of SAS Studio and navigate through its interface effortlessly.</li>
<li>Develop a deep understanding of macro variables, exploring their applications and delving into nested variations.</li>
<li>Acquire proficiency in SAS Macros, from basic examples to advanced keyword usage and conditional logic.</li>
<li>Unlock the potential of Proc SQL, gaining expertise in data copying, filtering, sorting, and removing duplicates.</li>
<li>Harness the power of data merging using Joins, creating macro variables dynamically in the process.</li>
</ul>
<h3><b>Why choose this Advanced SAS Programming Using MacrosSQL<span> course</span>?</b></h3>
<ol>
<li>Unlimited access to the course for a lifetime.</li>
<li>Opportunity to earn a certificate accredited by the <b>CPD Quality Standards</b> and <b>CIQ </b>after completing this course.</li>
<li>Structured lesson planning in line with industry standards.</li>
<li>Immerse yourself in innovative and captivating course materials and activities.</li>
<li>Assessments designed to evaluate advanced cognitive abilities and skill proficiency.</li>
<li>Flexibility to complete the Course at your own pace, on your own schedule.</li>
<li>Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience.</li>
<li>Unlock career resources for CV improvement, interview readiness, and job success.</li>
</ol>
<h3><b>Who is this Advanced SAS Programming Using MacrosSQL<span> </span></b><b><span>course </span></b><b>for?</b></h3>
<ul>
<li>Data enthusiasts seeking to enhance their SAS programming skills.</li>
<li>Business analysts aiming to leverage SAS for more effective data analysis.</li>
<li>IT professionals aspiring to streamline data management through SAS.</li>
</ul>
<h3><b>Career path</b></h3>
<ul>
<li><strong>SAS Programmer:</strong> £35,000 - £55,000</li>
<li><strong>Data Analyst:</strong> £30,000 - £50,000</li>
<li><strong>Business Intelligence Developer:</strong> £40,000 - £60,000</li>
<li><strong>Database Administrator:</strong> £35,000 - £60,000</li>
<li><strong>Data Scientist:</strong> £45,000 - £70,000</li>
<li><strong>Analytics Manager:</strong> £50,000 - £80,000</li>
</ul>
<h3><b>Prerequisites</b></h3>
<p><span>This </span><b>Advanced SAS Programming Using MacrosSQL</b><span> does not require you to have any prior qualifications or experience. You can just enrol and start learning.This </span><b>Advanced SAS Programming Using MacrosSQL</b><span> was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.</span></p>
<h3><b>Certification</b></h3>
<p><span>After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.</span></p><div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Advanced SAS Programming Using MacrosSQL</td>
				</tr>
								<tr>
					<td colspan="4">Unit - 1</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 0-00- Why SAS</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit - 2</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 2-02- SAS Studio through SAS OnDemand- Registration</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 2-03- Logging-in to SAS after installation</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 2-04- SAS Interface and windows</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit - 3</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 3-00- Section Overview - Macros</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 3-01-Macro Variables - introduction</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 3-02-Application of macro variables</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 3-03-01-Nested macro vars</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 3-03-02-More on Ampersand resolutions using a cool example</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 3-04-00-SAS Macros - introduction</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 3-04-01-SAS Macros - Examples</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 3-04-02-Keyword positional and mixed params</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 3-04-03-Conditional Logic in Macros</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 3-05-Macro Functions</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 3-05-Options Statement- mprint-mlogic-symbolgen</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 3-07-Connecting the two worlds - Call Symput - Symget</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 3-09-01-02- Bringing data into SAS using Import Wizard</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 3-09-02- Bringing data into SAS using LIBNAME statement</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 3-09-03- Bringing data into SAS using FILENAME</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit - 4</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 4-00- Section Overview - Proc SQL</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 4-01-01-Proc SQL - copying data</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 4-01-02-Proc SQL - filtering data</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 4-01-03-Proc SQL - sorting data</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 4-01-04-Proc SQL - removing duplicates</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 4-02-01-Proc SQL - Union</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 4-02-02-Proc SQL - Except</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 4-02-03-Proc SQL - Intersect</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 4-03-00-Merging data using Joins-Introduction</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 4-03-01-Proc SQL - inner join</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 4-03-02-Proc SQL - full join</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 4-03-03-Proc SQL - left and right joins</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 4-04-01-Proc SQL - creating macro vars</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Unit - 5</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Section 5-00- Bonus lecture</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
				</tbody></table></div>

			</div>

Studyhub UK

Online Course Marketing

Online Course Creation

Microsoft Certified Solutions Associate (MCSA)

Ssas

Advanced SAS Programming Using MacrosSQL

<p>Whether you're a beginner looking to start your coding journey or an experienced developer aiming to dive into data science and machine learning, this comprehensive course has you covered.</p><p>In this Python bundle, you'll embark on a transformative learning journey through 11 carefully curated courses. First, you'll lay the foundation with "Python Programming: Python Coding Essential Training," where you'll grasp the fundamentals of Python coding. Then, you'll advance into the world of data with the "Data Structures Complete Course," equipping you with the skills to manipulate and manage data efficiently.</p><p>But that's just the beginning. With courses spanning data science, machine learning, cloud computing, SQL programming, business intelligence, and critical thinking, this bundle is your passport to a versatile skill set that's in high demand. By enrolling in this course, you're investing in a brighter future, gaining the knowledge and expertise that will open doors to exciting career opportunities and enable you to tackle real-world challenges. Don't miss out on this chance to become a Python powerhouse and shape your professional destiny.</p><p><strong>This Python Powerhouse: Python Bundle Course for All Levels Bundle Consists of the following Premium courses:</strong></p><ul><li>Course 01: Python Programming: Python Coding Essential Training</li><li>Course 02: Data Structures Complete Course</li><li>Course 03: Data Science with Python</li><li>Course 04: Data Science &amp; Machine Learning with Python</li><li>Course 05: Python for Data Analysis</li><li>Course 06: Cloud Computing / CompTIA Cloud+ (CV0-002)</li><li>Course 07: SQL Programming Complete Bundle</li><li>Course 08: Higher Order Functions in Python - Level 03</li><li>Course 09: Basic Google Data Studio</li><li>Course 10: Business Intelligence and Data Mining Masterclass</li><li>Course 11: Decision Making and Critical Thinking</li></ul><p><strong>Learning Outcomes</strong></p><p>Upon completion of this bundle, you should be able to:</p><ul><li>Develop a solid foundation in Python programming, enabling them to apply coding skills efficiently.</li><li>Acquire a deep understanding of data structures and their applications in healthcare data management.</li><li>Master the use of Python for data science, allowing them to analyse healthcare data and extract valuable insights.</li><li>Explain SQL programming, which is crucial for handling healthcare databases and managing patient information securely.</li><li>Explore higher-order functions in Python, enhancing their problem-solving skills and programming capabilities.</li><li>Develop basic proficiency in Google Data Studio, a valuable tool for visualising healthcare data.</li><li>Master business intelligence and data mining techniques are specific to the healthcare industry.</li></ul><p>"Python Powerhouse: Python Bundle Course for All Levels" is your gateway to mastering Python and unleashing its potential across various domains. This comprehensive course comprises 11 meticulously designed modules, each geared towards equipping learners with essential skills and knowledge. Starting with "Python Programming: Python Coding Essential Training," you'll build a strong foundation in Python, a programming language known for its versatility and widespread use. As you progress through the "Data Structures Complete Course," you'll delve into the world of efficient data manipulation, a fundamental skill applicable in numerous professional settings.</p><p>One of the highlights of this bundle is "Data Science with Python," which empowers learners to harness Python's capabilities for data analysis. In "Data Science &amp; Machine Learning with Python," you'll take the next step, exploring advanced techniques that are vital in today's data-driven world. Furthermore, "Python for Data Analysis" enhances your proficiency in making data-driven decisions. Beyond data, you'll gain expertise in cloud computing, SQL programming, higher-order functions in Python, Google Data Studio, business intelligence, and critical thinking - all essential skills that can open doors to a multitude of career opportunities. This course is your passport to a fulfilling career by providing a comprehensive toolkit to excel in various domains and industries. Don't miss the chance to become a Python powerhouse and shape your professional destiny.</p><h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                            <p>This course is tailored for:</p><ul><li>Data Enthusiasts</li><li>Intermediate Python Developers</li><li>Data Visualisation Enthusiasts</li><li>Aspiring Business Analysts</li><li>Anyone interested in Python</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>No requirements to enrol this Python Powerhouse: Python Bundle Course for All Levels course.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>Upon completion, various career opportunities include:</p><ul><li><strong>Software Developer</strong> (Average salary range of £35,000 to £70,000)</li><li><strong>Data Analyst</strong> (Average salary range of £25,000 and £60,000.)</li><li><strong>Machine Learning Engineer</strong> (Average salary range of £45,000 to £80,000)</li><li><strong>Web Developer </strong>(Average salary range of £30,000 to £65,000)</li><li><strong>Research Scientist </strong>(Average salary range of £40,000 to £75,000)</li></ul>
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPDQS Accredited e-Certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>CPDQS Accredited Hard-Copy Certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p>You will get the Hard Copy certificate for the title course (<strong>Python Programming: Python Coding Essential Training</strong>) absolutely Free! Other Hard Copy certificates are available for £10 each.</p><p><strong>Please Note:</strong> The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.</p></div>

                        </div>

Apex Learning

Python Powerhouse: Python Bundle Course for All Levels

<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
			<div></div>
		</div>
				</div>
				</div>
				<div>
				<div>
			
				</div>
				<div>
				<div>
					<div><p>Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Web Application Penetration Testing Course has been specially designed to help learners gain a good command of Web Application Penetration Testing Course, providing them with a solid foundation of knowledge to become a qualified professional.</p><p>Through this Web Application Penetration Testing Course, you will gain both practical and theoretical understanding of Web Application Penetration Testing Course that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.</p><p>Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals. </p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</div></section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2><b> Learning outcome</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Familiar yourself with the recent development and updates of the relevant industry</span>
									</li>
								<li>
											<span>
													</span>
										<span>Know how to use your theoretical knowledge to adapt in any working environment</span>
									</li>
								<li>
											<span>
													</span>
										<span>Get help from our expert tutors anytime you need</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to course contents that are designed and prepared by industry professionals</span>
									</li>
								<li>
											<span>
													</span>
										<span>Study at your convenient time and from wherever you want</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					
			</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Why should I take this course?</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>Affordable premium-quality E-learning content, you can learn at your own pace.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will receive a completion certificate upon completing the course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Internationally recognized Accredited Qualification will boost up your resume.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will learn the researched and proven approach adopted by successful people to transform their careers.</span>
									</li>
								<li>
											<span>
													</span>
										<span>You will be able to incorporate various techniques successfully and understand your customers better.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
			<h2> <b>Requirements</b></h2>		</div>
				</div>
				<div>
				<div>
					<ul>
							<li>
											<span>
													</span>
										<span>No formal qualifications required, anyone from any academic background can take this course.</span>
									</li>
								<li>
											<span>
													</span>
										<span>Access to a computer or digital device with internet connectivity.</span>
									</li>
						</ul>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section><div>
                            <div>
                                <h2>Course Curriculum</h2>
                            </div>
                            			<div>
				

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"><strong>Unit 01: Introduction</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>About The Course</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Unit 02: BE PREPARED</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Web Attack Simulation Lab</td><td><span>🕐 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Unit 03: WEB APPLICATION TECHNOLOGIES</strong></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Web application technologies 101 - PDF</td><td><span>🕐 01:34:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>HTTP Protocol Basics</td><td><span>🕐 00:11:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Encoding Schemes</td><td><span>🕐 00:13:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Same Origin Policy - SOP</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>HTTP Cookies</td><td><span>🕐 00:11:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Cross-origin resource sharing</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Web application proxy - Burp suite</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Unit 04: INFORMATION GATHERING - MAPPING THE APPLICATIONS</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Fingerprinting web server</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>DNS Analysis - Enumerating subdomains</td><td><span>🕐 00:04:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Metasploit for web application attacks</td><td><span>🕐 00:12:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Web technologies analysis in real time</td><td><span>🕐 00:03:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Outdated web application to server takeover</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>BruteForcing Web applications</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Shodan HQ</td><td><span>🕐 00:07:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Harvesting the data</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Finding link of target with Maltego CE</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Unit 05: CROSS-SITE SCRIPTING ATTACKS - XSS</strong></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Cross Site Scripting- XSS - PDF</td><td><span>🕐 01:08:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Cross site scripting</td><td><span>🕐 00:07:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Reflected XSS</td><td><span>🕐 00:14:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Persistent XSS</td><td><span>🕐 00:11:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>DOM-based XSS</td><td><span>🕐 00:10:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Website defacement through XSS</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>XML Documents &amp; database</td><td><span>🕐 00:14:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Generating XSS attack payloads</td><td><span>🕐 00:13:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>XSS in PHP, ASP &amp; JS Code review</td><td><span>🕐 00:13:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Cookie stealing through XSS</td><td><span>🕐 00:12:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Advanced XSS phishing attacks</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Advanced XSS with BeEF attacks</td><td><span>🕐 00:10:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Advanced XSS attacks with Burp suite</td><td><span>🕐 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Code Review Guide</td><td><span>🕐 06:20:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Unit 06: SQL INJECTION ATTACKS - EXPLOITATIONS</strong></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Injection attacks - PDF</td><td><span>🕐 01:30:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Introduction to SQL Injection</td><td><span>🕐 00:16:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Dangers of SQL Injection</td><td><span>🕐 00:05:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Hunting for SQL Injection vulnerabilities</td><td><span>🕐 00:20:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>In-band SQL Injection attacks</td><td><span>🕐 00:27:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Blind SQL Injection attack in-action</td><td><span>🕐 00:10:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Exploiting SQL injection - SQLMap</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Fuzzing for SQL Injection - Burp Intruder</td><td><span>🕐 00:14:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Unit 07: CROSS SITE REQUEST FORGERY - XSRF</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>CSRF or XSRF attack methods</td><td><span>🕐 00:12:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Anti-CSRF Token methods</td><td><span>🕐 00:15:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Anti-CSRF token stealing-NOT easy</td><td><span>🕐 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Unit 08: AUTHENTICATION &amp; AUTHORIZATION ATTACKS</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Authentication bypass-hydra</td><td><span>🕐 00:11:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>HTTP Verb Tampering</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>HTTP parameter pollution - HPP</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Authentication</td><td><span>🕐 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Unit 09: CLIENT SIDE SECURITY TESTING</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Client side control bypass</td><td><span>🕐 00:10:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Unit 10: FILE RELATED VULNERABILITIES</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>LFI &amp; RFI attacks</td><td><span>🕐 00:13:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Unrestricted file upload - content type</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Unrestricted File Upload - Extension Type</td><td><span>🕐 00:06:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Remote code execution using Shell Uploads</td><td><span>🕐 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Unit 11: XML EXTERNAL ENTITY ATTACKS - XXE</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>XML Documents &amp; database</td><td><span>🕐 00:14:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>XXE attacks in action</td><td><span>🕐 00:14:00</span></td>
				</tr>
								<tr>
					<td colspan="4"><strong>Resources</strong></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Advance intruder attack types</td><td><span>🕐 00:23:00</span></td>
				</tr>
								<tr>
					<td>▶</td>
					<td>Finding details with open source</td><td><span>🕐 00:17:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
		                        </div>

Skill Up

IT Skills

Cyber Security

Web Development

Trainers Course

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Web Application Penetration Testing Course

PostgreSQL

Database Programming

Python

Build 9 projects to master 2 essential and modern technologies: Python and PostgreSQL

The Complete Python and PostgreSQL Developer Course

<p>The Learn MySQL from Scratch for Data Science and Analytics 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 Learn MySQL from Scratch for Data Science and Analytics and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!</p><p><strong>Expert Support</strong></p><p>Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course.</p><p><strong>Key Benefits</strong></p><ul><li>Learning materials of the Design course contain engaging voiceover and visual elements for your comfort.</li><li>Get 24/7 access to all content for a full year.</li><li>Each of our students gets full tutor support on weekdays (Monday to Friday)</li></ul><p><strong>Course Curriculum:</strong></p><p><strong>Section 01: Getting Started</strong></p><ul><li>Introduction</li><li>How to get course requirements</li><li>Getting started on Windows, Linux or Mac</li><li>How to ask great questions</li><li>FAQ's</li><li>What is Source Code?</li></ul><p><strong>Section 02: SQL Server setting up</strong></p><ul><li>Section Introduction</li><li>MySQL Server Installation</li><li>Connect MySQL Server Instance</li><li>MySQL Workbench overview</li><li>Download and Restore Sample Database</li></ul><p><strong>Section 03: SQL Database basics</strong></p><ul><li>Section Introduction</li><li>Overview of Databases</li><li>Creating Database</li><li>SQL Data Types</li><li>Column Data Types on Workbench</li><li>Creating Table</li><li>Overview of Primary and Foreign Key</li><li>Primary Key</li><li>Foreign Key</li><li>Creating Temporary tables</li><li>EER - Enhanced Entity Relationship Diagrams</li></ul><p><strong>Section 04: SQL DML (Data Manipulation Language)</strong></p><ul><li>Section Introduction</li><li>Insert statement</li><li>Update statement</li><li>Delete statement</li></ul><p><strong>Section 05: SQL DDL (Data Definition Language)</strong></p><ul><li>Section Introduction</li><li>CREATE table statement</li><li>DROP statement</li><li>ALTER statement</li><li>TRUNCATE statement</li><li>COMMENT in query</li><li>RENAME table</li></ul><p><strong>Section 06: SQL DCL (Data Control Language)</strong></p><ul><li>Create Database user</li><li>GRANT permissions</li><li>REVOKE permissions</li></ul><p><strong>Section 07: SQL Statement Basic</strong></p><ul><li>Section Introduction</li><li>SQL Statement basic</li><li>SELECT Statement</li><li>SELECT DISTINCT</li><li>SELECT with column headings</li><li>Column AS statement</li><li>DASHBOARD Analytics</li></ul><p><strong>Section 08: Filtering Data rows</strong></p><ul><li>SELECT WHERE Clause - theory</li><li>SELECT WHERE Clause - practical</li></ul><p><strong>Section 09: Aggregate functions for Data Analysis</strong></p><ul><li>Sum()</li><li>Min()-Max()</li></ul><p><strong>Section 10: SQL Data Analyticstatements</strong></p><ul><li>Order By statement</li><li>SELECT TOP 3 records</li><li>BETWEEN command</li><li>IN operator</li><li>Search Data usingLIKE cards</li></ul><p><strong>Section 11: SQL Group by statement</strong></p><ul><li>Section Introduction</li><li>Group by - theory</li><li>Data Analytics with Group By</li><li>HAVING statement</li></ul><p><strong>Section 12: JOINS</strong></p><ul><li>Overview of Joins</li><li>What are Joins</li><li>Inner join</li><li>Left outer join</li><li>Right outer join</li><li>Union</li><li>CERTESIAN Product or Cross Join</li><li>Query Exercise</li><li>Solution for Query Exercise</li></ul><p><strong>Section 13: SQL Constraints</strong></p><ul><li>Section introduction</li><li>Check constraint</li><li>NOT NULL constraint</li><li>UNIQUE constraint</li></ul><p><strong>Section 14: Views</strong></p><ul><li>Creating Views</li><li>Data Analytic Viewsfrom multiple tables</li></ul><p><strong>Section 15: Advanced SQL Functions</strong></p><ul><li>Section Introduction</li><li>Timestamp</li><li>Extract from timestamp</li><li>Mathematical scalar functions</li><li>String functions</li><li>Advanced functions</li><li>Sub Queries</li><li>SELECT with calculations</li></ul><p><strong>Section 16: SQL Stored procedures</strong></p><ul><li>Create stored procedure</li><li>Stored procedure with parameter</li><li>Drop Procedure</li></ul><p><strong>Section 17: Import &amp; Export data</strong></p><ul><li>Section Introduction</li><li>Import .csv file</li><li>Export Data to .csv file</li></ul><p><strong>Section 18: Backup and Restore Database</strong></p><ul><li>Section Introduction</li><li>Creating Database backup</li><li>Restoring Database backup</li></ul><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 Learn MySQL from Scratch for Data Science and Analytics 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 Learn MySQL from Scratch for Data Science and Analytics 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 Learn MySQL from Scratch for Data Science and Analytics Course, learners will be equipped with many indispensable skills and have the opportunity to grab.</p>
                        </div>

One Education

Learn MySQL from Scratch for Data Science and Analytics Course

Java

Programming

Learn how to build real-world applications using Spring Framework 5 and Spring Boot 2

Getting Started with Spring Boot 2

<strong>A beginner-friendly course for aspiring pentesters with 10+ hours of applied ethical hacking and security content covering core concepts such as using VMware, basics of Linux, Nmap, Metasploit, privilege escalation, known vulnerabilities, SQL injections, pivoting, cracking passwords, and much more. You need to know the basics of Linux and networking to get started.</strong>
        <p>In this course, you will learn the very basics of installing VMware and what to do to create the virtual environment that contains both our hacker machine and the target labs. Learn how to do advanced information gathering and reconnaissance in both active and passive modes as well as get the required templates and guides that will explain to you how to store the data you have gathered in a professional way.

After that, we will take the data that was gathered in the previous section and use it to conduct vulnerability assessments. Moving ahead, we will also discuss how to use the Metasploit framework to ease the process of exploitation without neglecting the way to exploit things manually.

Next, we will see how to beat the security of custom websites having specific vulnerabilities such as SQL injection, Cross Site Scripting (XSS), unrestricted file uploads, command injection, and brute forcing. Learn post exploitation with and without Metasploit framework as well as know many manual methods to do privilege escalation on a target, to move from standard user access to a full root/admin level shell. In the last and final section of the course, we will focus on how to write a report in a professional format.

By the end of the course, you will be able to perform professional penetration testing in real life.

All resources are placed here: https://github.com/PacktPublishing/Offensive-Hacking-Unfolded---Become-a-Pro-Pentester</p>
        <h2>What You Will Learn</h2><p>Create a virtual environment that has the hacker and target lab<br>Understand both active and passive modes<br>Learn to identify, analyze and rank vulnerabilities in a purely manual way<br>Evade scan time and runtime antiviruses for lifetime<br>Learn about Nmap and Vega<br>Learn to write industry grade penetration testing reports</p>
        <h2>Audience</h2><p>This course is for anyone curious about practical hacking and for people wanting to become advanced pentesters. It can also be taken by students willing to explore security testing. Knowing the basics of Linux and networking as well as knowing the extreme basics of hacking will be an added advantage.</p>
        <h2>Approach</h2><p>The course is purely a hands-on course loaded with demonstrations and resources that will help you with security testing and hacking.</p>
        <h2>Key Features</h2><p>Learn how to use Metasploit framework to ease the process of exploitation * Go specifically deep into hacking web technologies, applications, and servers * Learn how to beat the security of custom websites having specific vulnerabilities</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Offensive-Hacking-Unfolded---Become-a-Pro-Pentester</p>
        <h2>About the Author</h2><h3>Avinash Yadav</h3><p>Avinash Yadav is a young information security expert with a special focus on cybersecurity management as well as double-blind penetration testing. He brings his experience to the table through his passion for teaching. He has authored a couple of online courses with well-curated concepts and practicals on penetration testing and information security that the students can pursue to build up skills that are needed to be able to work in the cybersecurity domain rather than just focusing on random sources of information.

He looks forward to helping aspiring students on their journey to explore penetration testing, ethical hacking, and information security to become the person they would want to be, in an arguably short period of time!</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction to the Course</p><p style='margin: 0'>The video will explain to you all that you will be learning in this course.</p></td></tr></tbody></table><br><h4>2. Fundamentals</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Lab Setup Using the VMware Player</p><p style='margin: 0'>This video will demonstrate how to set up the VMware player that will be needed for the course.</p></td></tr><tr><td style='padding: 15px;'><p>2. Theoretical Basics</p><p style='margin: 0'>In this video, we will understand some theoretical basics before starting with the demonstration.</p></td></tr></tbody></table><br><h4>3. Information Gathering</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Passive Reconnaissance - Part 1</p><p style='margin: 0'>This video explains passive information gathering, also known as reconnaissance.</p></td></tr><tr><td style='padding: 15px;'><p>2. Passive Reconnaissance - Part 2</p><p style='margin: 0'>In this video, we are continuing to understand passive reconnaissance using Built With, which helps us identify the technologies on which different websites are running.</p></td></tr><tr><td style='padding: 15px;'><p>3. Passive Reconnaissance - Part 3</p><p style='margin: 0'>As part of this video, we will cover an IoT search engine called Shodan.</p></td></tr><tr><td style='padding: 15px;'><p>4. Active Reconnaissance - Part 1</p><p style='margin: 0'>In this video, we will look at the active information gathering technique also called active reconnaissance.</p></td></tr><tr><td style='padding: 15px;'><p>5. Active Reconnaissance - Part 2</p><p style='margin: 0'>In this video, we will look at Nmap and how to use it.</p></td></tr><tr><td style='padding: 15px;'><p>6. Active Reconnaissance - Part 3</p><p style='margin: 0'>In this video, you will learn about another tool called DirBuster.</p></td></tr></tbody></table><br><h4>4. Vulnerability Analysis</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Manually Identify, Analyze, and Rank Vulnerabilities</p><p style='margin: 0'>This video explains how to manually identify, analyze, and rank vulnerabilities.</p></td></tr><tr><td style='padding: 15px;'><p>2. Automated Vulnerability Assessment Using Nessus</p><p style='margin: 0'>This video will explain automated vulnerability assessment using Nessus.</p></td></tr><tr><td style='padding: 15px;'><p>3. Automated Vulnerability Assessment - Nmap and VEGA</p><p style='margin: 0'>This video will explain automated vulnerability assessment using Nmap and Vega.</p></td></tr></tbody></table><br><h4>5. Exploitation</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Lab 1 - Exploitation with Metasploit Framework</p><p style='margin: 0'>In a video, you will learn about exploitation with the Metasploit framework.</p></td></tr><tr><td style='padding: 15px;'><p>2. Lab 2 - Exploitation Using Manual Public Exploits</p><p style='margin: 0'>The video will demonstrate exploitation using manual public exploits.</p></td></tr></tbody></table><br><h4>6. Web Penetration Test</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. CMS Hacking - Initial Information Gathering</p><p style='margin: 0'>In this video, we will look at the initial information gathering.</p></td></tr><tr><td style='padding: 15px;'><p>2. CMS Hacking - Directory Busting and CMS Scanning</p><p style='margin: 0'>The video will show us directory busting and CMS scanning.</p></td></tr><tr><td style='padding: 15px;'><p>3. CMS Hacking - General Brute Forcing and Exploitation</p><p style='margin: 0'>In this video, we will be looking at general brute force and exploitation.</p></td></tr><tr><td style='padding: 15px;'><p>4. Do You Know the Power of Version Numbers? - Part 1</p><p style='margin: 0'>This video explains the power of version numbers.</p></td></tr><tr><td style='padding: 15px;'><p>5. Do You Know the Power of Version Numbers? - Part 2</p><p style='margin: 0'>The video will continue working in the same lab and see if we can get the original password hash.</p></td></tr><tr><td style='padding: 15px;'><p>6. Important Specific Vulnerabilities Such as SQL Injection In-Depth</p><p style='margin: 0'>In this video, we will be looking at specific vulnerabilities such as SQL injection in-depth.</p></td></tr><tr><td style='padding: 15px;'><p>7. Important Specific Vulnerabilities Such as XSS In-Depth</p><p style='margin: 0'>In this video we will look at specific vulnerabilities such as XSS in-depth.</p></td></tr><tr><td style='padding: 15px;'><p>8. Important Specific Vulnerabilities Such as File Upload and Command Injection</p><p style='margin: 0'>The video will explain vulnerabilities such as file upload and command injection.</p></td></tr><tr><td style='padding: 15px;'><p>9. Part 1 Web Server Hacking: Introduction and Enumeration Ideas</p><p style='margin: 0'>In this video, we will hack a web server and learn about the various enumeration ideas.</p></td></tr><tr><td style='padding: 15px;'><p>10. Part 2 Web Server Hacking: Risky PUT and DELETE Methods</p><p style='margin: 0'>In this video, we will look at risky PUT and DELETE methods.</p></td></tr><tr><td style='padding: 15px;'><p>11. Part 3 Web Server Hacking: SSH Brute Forcing w/ Hydra</p><p style='margin: 0'>In this video, we will look at SSH brute force with Hydra.</p></td></tr></tbody></table><br><h4>7. Network Pentesting</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. The Core of Network Testing - Part 1</p><p style='margin: 0'>In this video, we will look at the core of network testing in a practical way of performing pentesting.</p></td></tr><tr><td style='padding: 15px;'><p>2. The Core of Network Testing - Part 2</p><p style='margin: 0'>The video will show us a demonstration by looking at another service, which is HTTP.</p></td></tr><tr><td style='padding: 15px;'><p>3. The Core of Network Testing - Part 3</p><p style='margin: 0'>In this video, we will be looking at a tool-rpc info-p and the samba port.</p></td></tr><tr><td style='padding: 15px;'><p>4. Post Exploitation Using Metasploit - Part 1</p><p style='margin: 0'>In this video, we will look at the steps to take after you have gained access to a system.</p></td></tr><tr><td style='padding: 15px;'><p>5. Post Exploitation Using Metasploit - Part 2</p><p style='margin: 0'>The video will explain the concept of pivoting.</p></td></tr><tr><td style='padding: 15px;'><p>6. Post Exploitation Using Metasploit - Part 3</p><p style='margin: 0'>In this video, we will be looking at post modules and how to configure a module.</p></td></tr><tr><td style='padding: 15px;'><p>7. Privilege Escalation Techniques - Part 1</p><p style='margin: 0'>This video will start with privilege escalation techniques.</p></td></tr><tr><td style='padding: 15px;'><p>8. Privilege Escalation Techniques - Part 2</p><p style='margin: 0'>In the second part of the video, we will talk about service and apps exploits.</p></td></tr><tr><td style='padding: 15px;'><p>9. Privilege Escalation Techniques - Part 3</p><p style='margin: 0'>In the third part of the video, we will be talking about improper permissions.</p></td></tr><tr><td style='padding: 15px;'><p>10. Privilege Escalation Techniques - Part 4</p><p style='margin: 0'>In this video, we will look at privilege escalation in the real world.</p></td></tr></tbody></table><br><h4>8. Security Control Evasion</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. #1 Bypass Antivirus - Making the Base Payload</p><p style='margin: 0'>In this video, you will learn how to make the base payload.</p></td></tr><tr><td style='padding: 15px;'><p>2. #2 Bypass Antivirus - The Actual Evasion Technique!</p><p style='margin: 0'>This video will introduce you to the actual evasion technique.</p></td></tr></tbody></table><br><h4>9. Writing Great Reports</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Clean Documentation in a Professional Test</p><p style='margin: 0'>In this video, you will learn how to write clean documentation in a professional test.</p></td></tr></tbody></table>

Penetration Testing

Kali Linux

Security

A beginner-friendly course for aspiring pentesters with 10+ hours of applied ethical hacking and security content covering core concepts such as using VMware, basics of Linux, Nmap, Metasploit, privilege escalation, known vulnerabilities, SQL injections, pivoting, cracking passwords, and much more. You need to know the basics of Linux and networking to get started.

Offensive Hacking Unfolded - Become a Pro Pentester

<strong>Delve into big data streaming with Azure using Event Hubs, Data Lake, and Azure Stream Analytics</strong>
        <p>A modern digital company captures a large amount of data every day. This data gets locked in data islands such as caches, queues, and logs, and extracting this data and making it useful poses a major challenge. Real-time data processing is the most effective alternative to traditional extract, transform, and load (ETL) processes. This course will help you to think of data as an ever-flowing stream of events instead of data as islands locked away in databases.

This course employs live labs to get you up to speed with Azure Event Hubs and teach you how to create C# console applications for sending and receiving data from Event Hubs. As you advance, you'll learn how to capture and archive data from Azure Event Hubs to Azure Data Lake. The subsequent videos will show you how to provision Event Hubs, Data Lake, and SQL Server databases in Azure. Toward the end of the course, you'll write an analytics job to stream live data from an event hub to a SQL Server database.

By the end of this course, you'll have developed a solid understanding of how to stream big data using Azure Stream Analytics.

All the codes and supporting files for this course will be available at- https://github.com/PacktPublishing/Real-Time-Data-Stream-Processing-in-Azure</p>
        <h2>What You Will Learn</h2><p>Gain a thorough understanding of Azure Stream Analytics<br>Discover how to ingest data using Azure Event Hubs<br>Find out how to archive data from Event Hubs to Azure Data Lake<br>Provision Event Hubs, Data Lake, and SQL Server in Azure<br>Listen to an event hub and stream the data to a SQL Server table<br>Communicate with event hubs for effortless data transfer<br>Discover how event hub groups work</p>
        <h2>Audience</h2><p>This course is for Azure developers and big data engineers looking to change their approach to data processing. To take this course, you should have an Azure portal account. A free Azure trial account will also work.</p>
        <h2>Approach</h2><p>This course makes use of live labs and engaging videos to offer an interesting learning experience.</p>
        <h2>Key Features</h2><p>Learn to think of data as an ever-flowing stream of events * Discover how to harness the power of data events using Azure Stream Analytics * Get up to speed with Azure Event Hubs</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/real-time-data-stream-processing-in-azure</p>
        <h2>About the Author</h2><h3>Hersh Bhasin</h3><p>Hersh Bhasin is a published author and work as a Cloud Architect with J.P. Morgan Chase where he is part of the Enterprise Cloud Solutions Architecture team responsible for creating cloud architectural blueprints, guidance, Infrastructure as Code and best practices for fostering cloud adoption across the three public cloud providers (AWS, Azure and Google).</p>
        <h2>Course Outline</h2><h4>1. course-intro</h4><p></p><br><h4>2. understanding-eventhubs</h4><p></p><br><h4>3. Lab- Provisioning An Event Hub</h4><p></p><br><h4>4. 	Lab -Sending Events to an Event Hub</h4><p></p><br><h4>5. Lab-Receiving Events from an Event Hub</h4><p></p><br><h4>6. 	Lab-Event Hub Consumer Groups</h4><p></p><br><h4>7. 	Lab-Capturing Event Data to a Data Lake</h4><p></p><br><h4>8. 	Understanding Azure Stream Analytics</h4><p></p><br><h4>9. Lab-streaming</h4><p></p>

Data Processing

Delve into big data streaming with Azure using Event Hubs, Data Lake, and Azure Stream Analytics

Real-Time Data Stream Processing in Azure

London

<article>
<div>
<h5>Learn SQL Course, 1-Day</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>SQL Queries Course, 1-Day. </b>Basic SQL syntax. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Learn SQL Course, 1-Day</h5>
	  </div>
	  <div></div>
	  <p> With SQL Queries, you could learn SQL in a day, and master the basics of SQL, get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course London, UK. 
	  <br />Queries are made easy and simple, saving hours of online training.
 
		<br />This 1 Day course is packed with power query techniques.

<br /><br />This SQL Introduction Course is hands-on, practical with many excellent query examples.
<br /><br />This course is Platform Independent.
<br /><br />This SQL course is hands-on and practical, to give you in-depth, practical experience of the topics covered.
<br /><br />Ask your SQL questions in small, friendly classroom SQL Course. 
<br /><br />Online, Instructor-led, Interactive, full screen sharing.

	  </p>
	<div>
	<h5> Learn SQL Relational Database Concepts:</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Database:</strong>  
					<br />What is a Relational Database?
<br />Tables, Rows and Columns
<br />Indexes, Primary Keys and Foreign Keys
<br />Data Types  
					</p> 
			 
				 
			</div>
	<div>
	<h5>Learn SQL Essentials:</h5>
	</div> <div></div>
	<div> 
				<p> <strong>Basics.</strong>
					<br />SQL Language Essentials:
<br />The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values
<br />SQL Arithmetic Operations, Expression Queries
<br />SQL Column Aliases
<br />Limit/Top, Distinct

				 
				</p>
			</div>
	<div>
	<h5>Summarizing and Grouping Data:</h5>
	</div> <div></div>
	<div> 
				<p>  <strong>Group by</strong>
				<br />
Aggregate Functions (Sum, Avg, Count, Max, Min)
<br />The Group By Clause
<br />The Having Clause
				 
				</p>
			</div>
	<div>
	<h5>Querying Multiple Tables:</h5>
	</div> <div></div>
	<div>
				<p>   <strong>Joins</strong>
					<br />
Joining Tables
<br />Inner Joins, Outer Joins, Self Joins, Full Joins, 
<br />Cross Joins
<br />Alternative Join Syntax
				</p>
			</div>

	 
	
	 
	<div>
	<h5>Basic Subqueries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Sub-queries</strong>
			<br />Basics of CTE tables
			<br />SQL subqueries 
			<br />Using subqueries in the from clause
			<br />Using subqueries in the where clause
			<br />Using subqueries in the select clause
			<br />Using subqueries in the having clause 
			
		</p>
	</div>
	<div>
	<h5>Combine Queries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Combine Queries</strong>
			<br />The Union Operator
			<br /> Intersect and Minus Operators
			<br /> Simulating combine Intersect and Minus queries by using sub-queries
					   

			 

		</p>
	</div>
	  
</div>
 

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>SQL Course Notes</li>
				<li>SQL Code Examples</li>
				<li>Practical SQL Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the SQL Course</h5>
	                  </div>
 
	 
 <div id="eventbrite-widget-container-100389112538"></div>




									
					
					 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
										<li>
										<div id="LTF_ST_m8v4lCcicRynaFxnT4tD2JOVCitkIkMwzh0sIQRc9Toth01PZo"></div>
										</li>	
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Learn SQL Course, 1-Day
This SQL course is platform independent.
SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
Join us on your booked dates on https://meet.goto.com/910697125
Learn SQL Course, 1-Day Online Instructor-led
With SQL Queries, you could learn SQL in a day, and master the basics of SQL, and get interesting, insightful, and essential business intelligence from data by using SQL queries on this SQL Course in London, UK. 
Queries are made easy and simple, saving hours of online training. 
This 1 Day course is packed with power query techniques. 

This SQL Introduction Course is hands-on, practical with many excellent query examples.
This SQL course is hands-on and practical to give you in-depth, practical experience of the topics covered.
Ask your SQL questions in a small, friendly classroom SQL course. 

Learn SQL. Relational Database Concepts:
 Database: 
What is a Relational Database?

Tables, Rows and Columns

Indexes, Primary Keys and Foreign Keys

Data Types 
Learn SQL Essentials:
 Basics. 
SQL Language Essentials:

The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values

SQL Arithmetic Operations, Expression Queries

SQL Column Aliases

Limit/Top, Distinct 
Summarizing and Grouping Data:
 Group by 

Aggregate Functions (Sum, Avg, Count, Max, Min)

The Group By Clause

The Having Clause 
Querying Multiple Tables:
 Joins 

Joining Tables

Inner Joins, Outer Joins, Self Joins, Full Joins, 
Cross Joins

Alternative Join Syntax 
Basic Subqueries
 Sub-queries 
Basics of CTE tables 
SQL subqueries 
Using subqueries in the from clause 
Using subqueries in the where clause 
Using subqueries in the select clause 
Using subqueries in the having clause 
 
 Combine Queries 
The Union Operator 
 Intersect and Minus Operators 
 Simulating combined Intersect and Minus queries by using sub-queries 

What is included
PCWorkshops Course Certificate on completion
SQL Course Notes
SQL Code Examples
Practical SQL Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  



PCWorkshops

Data Skills

SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 

Learn SQL Basics, 1-day Course, Online Instructor-Led

General admission

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>The Certified Ethical Hacking v12 course will significantly benefit security officers, auditors, security professionals, site administrators, and anyone who is concerned about the integrity of the network infrastructure.</p>Overview<p>Information security controls, laws, and standards. Various types of footprinting, footprinting tools, and countermeasures. Network scanning techniques and scanning countermeasures Enumeration techniques and enumeration countermeasures Vulnerability analysis to identify security loopholes in the target organization?s network, communication infrastructure, and end systems. System hacking methodology, steganography, steganalysis attacks, and covering tracks to discover system and network vulnerabilities. Different types of malware (Trojan, Virus, worms, etc.), system auditing for malware attacks, malware analysis, and countermeasures. Packet sniffing techniques to discover network vulnerabilities and countermeasures to defend against sniffing. Social engineering techniques and how to identify theft attacks to audit human-level vulnerabilities and social engineering countermeasures. DoS/DDoS attack techniques and tools to audit a target and DoS/DDoS countermeasures. Session hijacking techniques to discover network-level session management, authentication/authorization, and cryptographic weaknesses and countermeasures. Webserver attacks and a comprehensive attack methodology to audit vulnerabilities in webserver infrastructure, and countermeasures. Web application attacks, comprehensive web application hacking methodology to audit vulnerabilities in web applications, and countermeasures. SQL injection attack techniques, injection detection tools to detect SQL injection attempts, and countermeasures. Wireless encryption, wireless hacking methodology, wireless hacking tools, and Wi-Fi security tools. Mobile platform attack vector, android vulnerability exploitations, and mobile security guidelines and tools. Firewall, IDS and honeypot evasion techniques, evasion tools and techniques to audit a network perimeter for weaknesses, and countermeasures. Cloud computing concepts (Container technology, serverless computing), the working of various threats and attacks, and security techniques and tools. Penetration testing, security audit, vulnerability assessment, and penetration testing roadmap. Threats to IoT and OT platforms and defending IoT and OT devices. Cryptography ciphers, Public Key Infrastructure (PKI), cryptography attacks, and cryptanalysis tools.</p><p>CEH provides an in-depth understanding of ethical hacking phases, various attack vectors, and preventative countermeasures. It will teach you how hackers think and act maliciously so you will be better positioned to setup your security infrastructure and defend against future attacks. An understanding of system weaknesses and vulnerabilities helps organizations strengthen their system security controls to minimize the risk of an incident. CEH was built to incorporate a hands-on environment and systematic process across each ethical hacking domain and methodology, giving you the opportunity to work towards proving the required knowledge and skills needed to achieve the CEH credential. You will be exposed to an entirely different posture toward the responsibilities and measures required to be secure. Now in its 12th version, CEH continues to evolve with the latest operating systems, tools, tactics, exploits, and technologies.</p></div><div id="course-pills-2"><h3>1 - Introduction to Ethical Hacking</h3> <ul> <li>Information Security Overview</li> <li>Cyber Kill Chain Concepts</li> <li>Hacking Concepts</li> <li>Ethical Hacking Concepts</li> <li>Information Security Controls</li> <li>Information Security Laws and Standards</li> </ul> <h3>2 - 2 - Foot-printing and Reconnaissance</h3> <ul> <li>Footprinting Concepts</li> <li>Footprinting through Search Engines</li> <li>Footprinting through Web Services</li> <li>Footprinting through Social Networking Sites</li> <li>Website Footprinting</li> <li>Email Footprinting</li> <li>Who is Footprinting</li> <li>DNS Footprinting</li> <li>Network Footprinting</li> <li>Footprinting through Social Engineering</li> <li>Footprinting Tools</li> <li>Footprinting Countermeasures</li> </ul> <h3>3 - Scanning Networks</h3> <ul> <li>Network Scanning Concepts</li> <li>Scanning Tools</li> <li>Host Discovery</li> <li>Port and Service Discovery</li> <li>OS Discovery (Banner Grabbing/OS Fingerprinting) </li><li>Scanning Beyond IDS and Firewall</li> <li>Draw Network Diagrams</li> </ul> <h3>4 - Enumeration</h3> <ul> <li>Enumeration Concepts</li> <li>NetBIOS Enumeration</li> <li>SNMP Enumeration</li> <li>LDAP Enumeration</li> <li>NTP and NFS Enumeration</li> <li>SMTP and DNS Enumeration</li> <li>Other Enumeration Techniques</li> <li>Enumeration Countermeasures</li> </ul> <h3>5 - Vulnerability Analysis</h3> <ul> <li>Vulnerability Assessment Concepts</li> <li>Vulnerability Classification and Assessment Types</li> <li>Vulnerability Assessment Solutions and Tools</li> <li>Vulnerability Assessment Reports</li> </ul> <h3>6 - System Hacking</h3> <ul> <li>System Hacking Concepts</li> <li>Gaining Access</li> <li>Escalating Privileges</li> <li>Maintaining Access</li> <li>Clearing Logs</li> </ul> <h3>7 - Malware Threats</h3> <ul> <li>Malware Concepts</li> <li>APT Concepts</li> <li>Trojan Concepts</li> <li>Virus and Worm Concepts</li> <li>Fileless Malware Concepts</li> <li>Malware Analysis</li> <li>Countermeasures</li> <li>Anti-Malware Software</li> </ul> <h3>8 - Sniffing</h3> <ul> <li>Sniffing Concepts</li> <li>Sniffing Technique: MAC Attacks</li> <li>Sniffing Technique: DHCP Attacks</li> <li>Sniffing Technique: ARP Poisoning</li> <li>Sniffing Technique: Spoofing Attacks</li> <li>Sniffing Technique: DNS Poisoning</li> <li>Sniffing Tools</li> <li>Countermeasures</li> <li>Sniffing Detection Techniques</li> </ul> <h3>9 - Social Engineering</h3> <ul> <li>Social Engineering Concepts</li> <li>Social Engineering Techniques</li> <li>Insider Threats</li> <li>Impersonation on Social Networking Sites</li> <li>Identity Theft</li> <li>Countermeasures</li> </ul> <h3>10 - Denial-of-Service</h3> <ul> <li>DoS/DDoS Concepts</li> <li>DoS/DDoS Attack Techniques</li> <li>BotnetsDDoS Case Study</li> <li>DoS/DDoS Attack Tools</li> <li>Countermeasures</li> <li>DoS/DDoS Protection Tools</li> </ul> <h3>11 - Session Hijacking</h3> <ul> <li>Session Hijacking Concepts</li> <li>Application Level Session Hijacking</li> <li>Network Level Session Hijacking</li> <li>Session Hijacking Tools</li> <li>Countermeasures</li> </ul> <h3>12 - Evading IDS, Firewalls, and Honeypots</h3> <ul> <li>IDS, IPS, Firewall, and Honeypot Concepts</li> <li>IDS, IPS, Firewall, and Honeypot Solutions</li> <li>Evading IDS</li> <li>Evading Firewalls</li> <li>IDS/Firewall Evading Tools</li> <li>Detecting Honeypots</li> <li>IDS/Firewall Evasion Countermeasures</li> </ul> <h3>13 - Hacking Web Servers</h3> <ul> <li>Web Server Concepts</li> <li>Web Server Attacks</li> <li>Web Server Attack Methodology</li> <li>Web Server Attack Tools</li> <li>Countermeasures</li> <li>Patch Management</li> <li>Web Server Security Tools</li> </ul> <h3>14 - Hacking Web Applications</h3> <ul> <li>Web Application Concepts</li> <li>Web Application Threats</li> <li>Web Application Hacking Methodology</li> <li>Web API, Webhooks, and Web Shell</li> <li>Web Application Security</li> </ul> <h3>15 - SQL Injection</h3> <ul> <li>SQL Injection Concepts</li> <li>Types of SQL Injection</li> <li>SQL Injection Methodology</li> <li>SQL Injection Tools</li> <li>Evasion Techniques</li> <li>Countermeasures</li> </ul> <h3>16 - Hacking Wireless Networks</h3> <ul> <li>Wireless Concepts</li> <li>Wireless Encryption</li> <li>Wireless Threats</li> <li>Wireless Hacking Methodology</li> <li>Wireless Hacking Tools</li> <li>Bluetooth Hacking</li> <li>Countermeasures</li> <li>Wireless Security Tools</li> </ul> <h3>17 - Hacking Mobile Platforms</h3> <ul> <li>Mobile Platform Attack Vectors</li> <li>Hacking Android OS</li> <li>Hacking iOS</li> <li>Mobile Device Management</li> <li>Mobile Security Guidelines and Tools</li> </ul> <h3>18 - IoT and OT Hacking</h3> <ul> <li>IoT Hacking</li> <li>IoT Concepts</li> <li>IoT Attacks</li> <li>IoT Hacking Methodology</li> <li>IoT Hacking Tools</li> <li>Countermeasures</li> <li>OT Hacking</li> <li>OT Concepts</li> <li>OT Attacks</li> <li>OT Hacking Methodology</li> <li>OT Hacking Tools</li> <li>Countermeasures</li> </ul> <h3>19 - Cloud Computing</h3> <ul> <li>Cloud Computing Concepts</li> <li>Container Technology</li> <li>Serverless Computing</li> <li>Cloud Computing Threats</li> <li>Cloud Hacking</li> <li>Cloud Security</li> </ul> <h3>20 - Cryptography</h3> <ul> <li>Cryptography Concepts</li> <li>Encryption Algorithms</li> <li>Cryptography Tools</li> <li>Public Key Infrastructure (PKI) </li><li>Email Encryption</li> <li>Disk Encryption</li> <li>Cryptanalysis</li> <li>Countermeasures</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans EC-Council Certified Ethical Hacker (CEH) v.12 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 EC-Council Certified Ethical Hacker (CEH) v.12 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>

Certified in Cybersecurity (CC)

IT Certifications

Certified Ethical Hacker (CEH)

Certified Cyber Professional (CCP)

Ethical Hacking

EC-Council Certified Ethical Hacker (CEH) v12

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

Sccm

Microsoft Certified Technology Specialist (MCTS)

Commercial & Contract Management Certification Program (CCM)

IT Manager

Microsoft Certified Trainer (MCT)

55348 Administering Microsoft Endpoint Configuration Manager

<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>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>This course is intended for IT Professionals who are already experienced in general Windows Server, Windows client, Azure, and Microsoft 365 administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of PowerShell or any scripting language is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Microsoft Exchange Server, Microsoft SharePoint Server, and Microsoft SQL Server.</p><p></p><p></p><p>This course provides students with the fundamental knowledge and skills to use PowerShell for administering and automating administration of Windows servers. This course provides students the skills to identify and build the command they require to perform a specific task. In addition, students learn how to build scripts to accomplish advanced tasks such as automating repetitive tasks and generating reports. This course provides prerequisite skills supporting a broad range of Microsoft products, including Windows Server, Windows Client, Microsoft Azure, and Microsoft 365. In keeping with that goal, this course will not focus on any one of those products, although Windows Server, which is the common platform for all of those products, will serve as the example for the techniques this course teaches.</p><p></p>Prerequisites<p>Before attending this course, students must have: </p><ul><li>-Experience with Windows networking technologies and implementation.</li> <li>- Experience with Windows Server administration, maintenance, and troubleshooting.</li></ul><p></p></div><div id="course-pills-2"><h3>1 - Review Windows PowerShell</h3> <ul> <li>Learn about Windows PowerShell</li> <li>Get familiar with Windows PowerShell applications</li> <li>Identify factors to install and use Windows PowerShell</li> <li>Configure the Windows PowerShell console</li> <li>Configure the Windows PowerShell Integrated Scripting Environment (ISE)</li> <li>Use Visual Studio Code with PowerShell</li> </ul> <h3>2 - Understand the command syntax in Windows PowerShell</h3> <ul> <li>Discover the structure of PowerShell cmdlets</li> <li>Discover the parameters for using PowerShell cmdlets</li> <li>Review the tab completion feature in PowerShell</li> <li>Display the About files content in PowerShell</li> </ul> <h3>3 - Find commands and Get-Help in Windows PowerShell</h3> <ul> <li>Define modules in PowerShell</li> <li>Find cmdlets in PowerShell</li> <li>Use command aliases in PowerShell</li> <li>Use Show-Command and Get-Help in PowerShell</li> <li>Interpret the help file contents and update the local help content in PowerShell</li> </ul> <h3>4 - Manage Active Directory Domain Services using PowerShell cmdlets</h3> <ul> <li>Manage user accounts in PowerShell</li> <li>Manage groups and group memberships in PowerShell</li> <li>Manage computer accounts in PowerShell</li> <li>Manage organizational units and Active Directory objects in PowerShell</li> </ul> <h3>5 - Manage network service settings for Windows devices using PowerShell cmdlets</h3> <ul> <li>Manage IP addresses in PowerShell</li> <li>Manage IP routing in PowerShell</li> <li>Manage DNS clients in PowerShell</li> <li>Manage Windows Firewall settings in PowerShell</li> </ul> <h3>6 - Manage Windows Server settings using PowerShell cmdlets</h3> <ul> <li>Automate management tasks using the Group Policy management cmdlets</li> <li>Manage server roles and services using PowerShell cmdlets</li> <li>Manage Hyper-V Virtual Machines using PowerShell cmdlets</li> <li>Manage Internet Information Services using PowerShell cmdlets</li> </ul> <h3>7 - Manage settings for a local Windows machine using PowerShell cmdlets</h3> <ul> <li>Manage Windows 10 using PowerShell</li> <li>Manage permissions with PowerShell</li> </ul> <h3>8 - Understand the Windows PowerShell pipeline</h3> <ul> <li>Review Windows PowerShell pipeline and its output</li> <li>Discover object members in PowerShell</li> <li>Control the formatting of pipeline output</li> </ul> <h3>9 - Select, sort, and measure objects using the pipeline</h3> <ul> <li>Sort and group objects by property in the pipeline</li> <li>Measure objects in the pipeline</li> <li>Select a set of objects in the pipeline</li> <li>Select object properties in the pipeline</li> <li>Create and format calculated properties in the pipeline</li> </ul> <h3>10 - Filter objects out of the pipeline</h3> <ul> <li>Learn about the comparison operators in PowerShell</li> <li>Review basic filter syntax in the pipeline</li> <li>Review advanced filter syntax in the pipeline</li> <li>Optimize the filter performance in the pipeline</li> </ul> <h3>11 - Enumerate objects in the pipeline</h3> <ul> <li>Learn about enumerations in the pipeline</li> <li>Review basic syntax to enumerate objects in the pipeline</li> <li>Review advanced syntax to enumerate objects in the pipeline</li> </ul> <h3>12 - Send and pass data as output from the pipeline</h3> <ul> <li>Write pipeline data to a file</li> <li>Convert pipeline objects to other forms of data representation in PowerShell</li> <li>Control additional output options in PowerShell</li> </ul> <h3>13 - Pass pipeline objects</h3> <ul> <li>Pipeline parameter binding</li> <li>Identify ByValue parameters</li> <li>Pass data by using ByValue</li> <li>Pass data by using ByPropertyName</li> <li>Identify ByPropertyName parameters</li> <li>Use manual parameters to override the pipeline</li> <li>Use parenthetical commands</li> <li>Expand property values</li> </ul> <h3>14 - Connect with data stores using PowerShell providers</h3> <ul> <li>Define Windows PowerShell providers</li> <li>Review the built-in providers in PowerShell</li> <li>Access provider help in PowerShell</li> </ul> <h3>15 - Use PowerShell drives in PowerShell</h3> <ul> <li>Explain PowerShell drives in PowerShell</li> <li>Use PowerShell drive cmdlets in PowerShell</li> <li>Manage the file system in PowerShell</li> <li>Manage the registry in PowerShell</li> <li>Work with certificates in PowerShell</li> <li>Work with other PowerShell drives in PowerShell</li> </ul> <h3>16 - Review CIM and WMI</h3> <ul> <li>Review architecture of CIM and WMI</li> <li>Review repositories in CIM and WMI</li> <li>Locate online class documentation by using CIM and WMI cmdlets</li> </ul> <h3>17 - Query configuration information by using CIM and WMI</h3> <ul> <li>List local repository namespaces and classes by using CIM and WMI</li> <li>Query instances by using commands and WMI Query Language</li> <li>Connect to remote computers by using CIM and WMI cmdlets</li> <li>Query repository classes from remote computers by using CIMSession objects</li> </ul> <h3>18 - Query and manipulate repository objects by using CIM and WMI methods</h3> <ul> <li>Discover methods of repository objects by using CIM and WMI</li> <li>Locate class methods and documentation by using CIM and WMI</li> <li>Invoke methods of repository objects by using CIM and WMI</li> </ul> <h3>19 - Manage variables in Windows PowerShell scripts</h3> <ul> <li>Define variables in Windows PowerShell scripts</li> <li>Create variable names in Windows PowerShell scripts</li> <li>Assign values and types to variables in Windows PowerShell scripts</li> <li>Identify the methods and properties of variables in Windows PowerShell scripts</li> <li>Use string variables and methods in Windows PowerShell scripts</li> <li>Use date variables and methods in Windows PowerShell scripts</li> </ul> <h3>20 - Work with arrays and hash tables in Windows PowerShell scripts</h3> <ul> <li>Define an array in Windows PowerShell scripts</li> <li>Work with array lists in Windows PowerShell scripts</li> <li>Define hash tables in Windows PowerShell Scripts</li> <li>Work with hash tables in Windows PowerShell scripts</li> </ul> <h3>21 - Create and run scripts by using Windows PowerShell</h3> <ul> <li>Review Windows PowerShell scripts</li> <li>Modify scripts in the PowerShell Gallery</li> <li>Create scripts using Windows PowerShell</li> <li>Review the PowerShellGet module in Windows PowerShell</li> <li>Run scripts and set the execution policy in Windows PowerShell</li> <li>Review Windows PowerShell and AppLocker</li> <li>Sign the scripts digitally in Windows PowerShell</li> </ul> <h3>22 - Work with scripting constructs in Windows PowerShell</h3> <ul> <li>Review and use the ForEach loop in Windows PowerShell scripts</li> <li>Review and use the If construct in Windows PowerShell scripts</li> <li>Review and use the Switch construct in Windows PowerShell scripts</li> <li>Review the For construct in Windows PowerShell scripts</li> <li>Review other loop constructs in Windows PowerShell scripts</li> <li>Review Break and Continue in Windows PowerShell scripts</li> </ul> <h3>23 - Import data in different formats for use in scripts by using Windows PowerShell cmdlets</h3> <ul> <li>Use the Get-Content command in Windows PowerShell scripts</li> <li>Use the Import-Csv cmdlet in Windows PowerShell scripts</li> <li>Use the Import-Clixml cmdlet in Windows PowerShell scripts</li> <li>Use the ConvertFrom-Json cmdlet in Windows PowerShell scripts</li> </ul> <h3>24 - Use methods to accept user inputs in Windows PowerShell scripts</h3> <ul> <li>Identify values that might change in Windows PowerShell scripts</li> <li>Use the Read-Host cmdlet in Windows PowerShell scripts</li> <li>Use the Get-Credential cmdlet in Windows PowerShell scripts</li> <li>Use the Out-GridView cmdlet in Windows PowerShell scripts</li> <li>Pass parameters to a Windows PowerShell script</li> </ul> <h3>25 - Troubleshoot scripts and handle errors in Windows PowerShell</h3> <ul> <li>Interpret error messages generated for Windows PowerShell commands</li> <li>Add output to Windows PowerShell scripts</li> <li>Use breakpoints in Windows PowerShell scripts</li> <li>Interpret error actions for Windows PowerShell commands</li> </ul> <h3>26 - Use functions and modules in Windows PowerShell scripts</h3> <ul> <li>Review functions in Windows PowerShell scripts</li> <li>Use variable scope in Windows PowerShell scripts</li> <li>Create modules in Windows PowerShell scripts</li> <li>Use the dot sourcing feature in Windows PowerShell</li> </ul> <h3>27 - Manage single and multiple computers by using Windows PowerShell remoting</h3> <ul> <li>Review the remoting feature of Windows PowerShell</li> <li>Compare remoting with remote connectivity</li> <li>Review the remoting security feature of Windows PowerShell</li> <li>Enable remoting by using Windows PowerShell</li> <li>Use one-to-one remoting by using Windows PowerShell</li> <li>Use one-to-many remoting by using Windows PowerShell</li> <li>Compare remoting output with local output</li> </ul> <h3>28 - Use advanced Windows PowerShell remoting techniques</h3> <ul> <li>Review common remoting techniques of Windows PowerShell</li> <li>Send parameters to remote computers in Windows PowerShell</li> <li>Set access protection to variables, aliases, and functions by using the scope modifier</li> <li>Enable multi-hop remoting in Windows PowerShell</li> </ul> <h3>29 - Manage persistent connections to remote computers by using Windows PowerShell sessions</h3> <ul> <li>Review persistent connections in Windows PowerShell</li> <li>Create and manage persistent PSSessions by using Windows PowerShell</li> <li>Disconnect PSSessions by using Windows PowerShell</li> <li>Review the feature of implicit remoting in Windows PowerShell</li> </ul> <h3>30 - Review Azure PowerShell module</h3> <ul> <li>Review Azure PowerShell</li> <li>Review the benefits of the Azure PowerShell module</li> <li>Install the Azure PowerShell module</li> <li>Migrate Azure PowerShell from AzureRM to Azure</li> <li>Review Microsoft Azure Active Directory module for Windows PowerShell and Azure Active Directory PowerShell for Graph modules</li> </ul> <h3>31 - Review the features and tools for Azure Cloud Shell</h3> <ul> <li>Review the characteristics of Azure Cloud Shell</li> <li>Review the features and tools of Azure Cloud Shell</li> <li>Configure and experiment with Azure Cloud Shell</li> </ul> <h3>32 - Manage Azure resources with Windows PowerShell</h3> <ul> <li>Create a new Azure virtual machine by using Windows PowerShell commands</li> <li>Manage Azure virtual machines by using Windows PowerShell commands</li> <li>Manage Azure related storage by using Azure PowerShell</li> <li>Manage Azure subscriptions by using Azure PowerShell</li> </ul> <h3>33 - Manage users, groups, and licenses in Microsoft Entra ID by using Windows PowerShell</h3> <ul> <li>Review benefits to manage Microsoft 365 services by using Windows PowerShell</li> <li>Connect to the Microsoft 365 tenant by using Windows PowerShell</li> <li>Manage users in Microsoft 365 by using Windows PowerShell</li> <li>Manage groups in Microsoft 365 by using Windows PowerShell</li> <li>Manage roles in Microsoft 365 by using Windows PowerShell</li> <li>Manage licenses in Microsoft 365 by using Windows PowerShell</li> </ul> <h3>34 - Manage Exchange Online by using Windows PowerShell</h3> <ul> <li>Connect to Exchange Online by using Windows PowerShell</li> <li>Manage mailboxes in Exchange Online by using Windows PowerShell</li> <li>Manage resources in Exchange Online by using Windows PowerShell</li> <li>Manage admin roles in Exchange Online by using Windows PowerShell</li> </ul> <h3>35 - Manage SharePoint Online by using Windows PowerShell</h3> <ul> <li>Install and connect to SharePoint Online Management Shell by using Windows PowerShell</li> <li>Manage SharePoint Online users and groups by using Windows PowerShell</li> <li>Manage SharePoint sites by using Windows PowerShell</li> <li>Manage SharePoint Online external user sharing by using Windows PowerShell</li> </ul> <h3>36 - Manage Microsoft Teams by using Windows PowerShell</h3> <ul> <li>Review Microsoft Teams PowerShell module</li> <li>Install the Microsoft Teams PowerShell module</li> <li>Manage teams with Microsoft Teams PowerShell module</li> </ul> <h3>37 - Create and manage background jobs using Windows PowerShell</h3> <ul> <li>Define the types of background jobs in Windows PowerShell</li> <li>Start remote jobs and CIM/WMI jobs in Windows PowerShell</li> <li>Monitor jobs in Windows PowerShell</li> <li>Retrieve results for running jobs in Windows PowerShell</li> </ul> <h3>38 - Create and manage scheduled jobs using Windows PowerShell</h3> <ul> <li>Create and run Windows PowerShell scripts as scheduled tasks</li> <li>Define scheduled jobs in Windows PowerShell</li> <li>Create job option and job trigger objects in Windows PowerShell</li> <li>Create and register a scheduled job in Windows PowerShell</li> <li>Retrieve the results from a scheduled job in Windows PowerShell</li> </ul></div>

Azure PowerShell

Powershell

Power Automate

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

<article>
<div>
<h5>Java EVENINGS Course</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>Python EVENINGS Course. </b>Basic Python syntax and principles of Object Orientated Programming. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Python Basics EVENINGS Course </h5>
	  </div>
	  <div></div>
	  <p> 
 
				This Python course London Evening covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom.
				This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language.
				These concepts are daily used by programmers and is your first step to working as a programmer.
				By the end, you'll be comfortable in programming Python code.
				You will have done small projects.
				This will serve for you as examples and samples that you can use to build larger projects.
				You can publish your code online to keep as a portfolio.

<br />
This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered.

	  </p>
	<div>
	<h5>Week 1: Basics</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Python Data Types and Variables:</strong>  
					<br />  Primitive types; Characters &amp; Strings; Boolean; Working with variables and its scope; Conversion and casting types in Python.	 
					<br /> <strong>Operators and Expressions: </strong>   
					<br />  Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators.
					</p> 
			 
				<p><strong> Decision Making:</strong>
				<br />If statement; If - else statement; If- elif - else statement; Nested if - else.
				</p><p><strong>Using Loops:</strong>
				<br />The while, while-else.
				<br />For loop;
				<br />Jump statements: break, continue;
				<br />Nesting loops.				
				</p>
			</div>
	<div>
	<h5>Week 2: Data Structures</h5>
	</div> <div></div>
	<div> 
				<p> Lists.
					<br />Tuples.
					<br />Sets.
					<br />Dictionary. Nested Dictionary.
					<br />Json Files.
				</p>
			</div>
	<div>
	<h5>Week 3: Python built-in functions</h5>
	</div> <div></div>
	<div> 
				<p>  
				<br />Using Built-in modules and functions:
				<br />Strings Functions.
				<br />Pattern matching with Regex.
				<br />Maths Functions.
				<br />Random Functions.
				<br />Python Date functions.
				</p>
			</div>
	<div>
	<h5>Week 4: OOP: Using Modules, functions, classes</h5>
	</div> <div></div>
	<div>
				<p>  Creating and using custom Functions.
					<br />Creating functions;
					<br />Using parameters and return values;
					<br />
					<br />Introduction to Classes and Objects:
					<br />Creating a Class; 
					<br />Creating an Object; Using an Object; 
					<br />Adding Instance variables; Controlling accessibility; Naming conventions for class members. 
					<br /> Class Constructors; Parameterized Constructors.
					<br />Inheritance. Overload.
				</p>
			</div>

	<div>
	<h5>Week 5: Pandas DataBase Basics</h5>
	</div> <div></div>
	<div>	 
		<p> <b>Connection details:</b>
				Connect to a database using access codes. 
				<br /><b>Select Queries:</b>
				Retrieving records and iterating results sets, using variables and parameters in queries. 
				<br />Working with DDL comands:
				Create a database, drop a database.
				Create a table, alter tables, drop a table. 
				<br />Working with DML Commands:
				Insert, delete, update records.
		</p>
	</div>
	
	 
	<div>
	<h5>Week 6: Pandas Dataframe Basics</h5>
	</div> <div></div>
	<div>	 
		<p> Getting data into a dataframe:
			<br />Dict to Dataframe, Dataframe to Dict.
			<br />Excel To Dict, Dict to Excel , working with Excel data, multiple Excel sheets.

			<br />Dataframe basics:
			<br />Slicing Dataframes,
			<br />Getting information about the dataframe,
			<br />Filter, sort and query a Dataframes,
			<br />Duplicate values,
			<br />Working with null-values,
			<br />Sampling,
			<br />Group by,
			<br />Join.

		</p>
	</div>
	  
</div>
 

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>Python Course Notes</li>
				<li>Python Code Examples</li>
				<li>Practical Python Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the Python  Course</h5>
	                  </div>
 
<div id="eventbrite-widget-container-60636103217"></div>




							 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Python EVENINGS Course
Basic Python syntax and principles of object-oriented programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details:
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 4 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
How to attend:  
Connection Link For the course: https://meet.goto.com/910697125
Once you have made the payment, use the above link on the date booked, to connect with the trainer. 
Python Basics EVENINGS Course
 This Python course London Evening covers the essential Python Basics, in our interactive, instructor led Live Virtual Classroom. This Python Basics course is a very good introduction to essential fundamental programming concepts using Python as programming language. These concepts are daily used by programmers and is your first step to working as a programmer. By the end, you'll be comfortable in programming Python code. You will have done small projects. This will serve for you as examples and samples that you can use to build larger projects. You can publish your code online to keep as a portfolio. 

This Python Programming course is hands-on and practical, to give you in-depth, practical experience of the topics covered. 
Week 1: Basics
 Python Data Types and Variables: 
Primitive Data types; Working with variables and its scope; Conversion and casting types in Python. 
 Operators and Expressions:  
 Introduction of operators; Arithmetic operators; Relational operators; Assignment operator; Logical operators; Increment and decrement operators. 
 Decision Making: 
If statement; If - else statement; If- elif - else statement; Nested if - else. 
Using Loops: 
The while, while-else. 
For loop; 
Jump statements: break, continue; 
Nesting loops. 
Week 2: Data Structures & Database
Lists.  
Tuples. 
Sets. 
Dictionary. Nested Dictionary. 
Json Files. 
Reading csv and text files
Connecting with a database and run SQL Queries. 
Week 3: Python built-in functions &  Pandas Dataframe Basics
 
Using built-in modules and functions: 
Strings Functions. 
Maths Functions. 
Random Functions. 
Data Frames; 
Getting data into a dataframe: 
Dict to Dataframe, Dataframe to Dict.  
Dataframe basics: 
Slicing Dataframes, 
Getting information about the dataframe, 
Filter and query a Dataframes, 
Working with null-values.
Week 4: OOP: Using Modules, functions, classes
 Creating and using custom Functions. 
Creating functions; 
Using parameters and return values; 
 
Introduction to Classes and Objects: 
Creating a Class; 
Creating an Object; Using an Object; 
Adding instance variables; controlling accessibility; and naming conventions for class members. 
 Class Constructors; Parameterized Constructors. 
Inheritance. Overload. 

What is included
PCWorkshops Course Certificate on completion
Python Course Notes
Python Code Examples
Practical Python Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  

Programming Fundamentals

Computer Programming

Professional Skills Course (PSC)

Instructor

Basic Python syntax and principles of Object Orientated Programming. 
Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 

Python EVENINGS Course, Online Instructor-led

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This class has something for everything, from beginners who wish to customise their data entry forms in SharePoint right up to advanced users who need to use advanced formulas to deliver more bespoke actions to their apps.</p>Overview<p>After taking this course, students will be able to: - Understand when to use PowerApp. - Describe the components of PowerApps and their correct use. - Create PowerApps from existing data sources. - Brand PowerApps. - Customize PowerApps beyond just using the automated wizards. - Connect to a range of data sources from Excel to Azure SQL. - Understand the difference between canvas apps and model-driven apps. - Integrate PowerApps with other Office 365 systems ? including Teams and SharePoint Online. - Administer and Maintain PowerApps</p><p>Students will be taught how to design, test and publish new apps that work with a variety of data sources. We will take users through a selection of well-crafted lessons to help them build new applications for their business.</p></div><div id="course-pills-2"><h3>1 - AN INTRODUCTION TO POWERAPPS</h3> <ul> <li>What is PowerApps?</li> <li>The benefits of apps</li> <li>How to get PowerApps</li> <li>Canvas Apps and Model-Driven Apps</li> <li>License Options and Costs</li> <li>Discover PowerApps with Templates</li> <li>Lab 1: Introduction to PowerApps</li> </ul> <h3>2 - GETTING STARTED WITH POWERAPPS</h3> <ul> <li>Building a new app from a data source</li> <li>Add, edit and remove controls</li> <li>Intro to Formulas</li> <li>Testing an app</li> <li>App Settings</li> <li>Publish and Share Apps</li> <li>Version History and Restore</li> <li>PowerApps Mobile App</li> <li>Lab 1: Getting Started</li> </ul> <h3>3 - BRANDING AND MEDIA</h3> <ul> <li>Less is more</li> <li>Duplicate Screens</li> <li>Fonts</li> <li>Screen Colours and Matching Colours</li> <li>Screen Backgrounds</li> <li>Buttons and Icons</li> <li>Hide on Timer</li> <li>Size and Alignment by reference</li> <li>Show and Hide on Timer</li> <li>Lab 1: Branding and Media</li> </ul> <h3>4 - POWERAPPS CONTROLS</h3> <ul> <li>Text Controls for Data Entry and Display</li> <li>Controls ? Drop downs, combo box, date picker, radio button and more</li> <li>Forms ? Add and edit data in underlying data sources quickly</li> <li>Charts ? present information in pie, line and bar charts</li> <li>Lab 1: Build Apps from Blank</li> </ul> <h3>5 - DATA SOURCES AND LOGIC</h3> <ul> <li>Data Storage and Services</li> <li>How do I decide which database to use?</li> <li>Connect to on-premises data - Gateway</li> <li>What is Delegation?</li> <li>Specific Data Examples</li> <li>Displaying Data</li> <li>Lab 1: Data Source and Logic</li> </ul> <h3>6 - MODEL-DRIVEN APPS</h3> <ul> <li>What is a model-driven app?</li> <li>Where will my data be stored?</li> <li>How do create a model-driven app</li> <li>Canvas vs model-driven summary</li> <li>Lab 1: Model-Driven App</li> </ul> <h3>7 - POWERAPP INTEGRATION</h3> <ul> <li>Embed PowerApps in Teams</li> <li>Embed PowerApps in SharePoint Online</li> <li>Start a Flow from a PowerApp</li> <li>Lab 1: PowerApp Integration</li> </ul> <h3>8 - ADMINISTRATION AND MAINTENANCE OF POWERAPPS</h3> <ul> <li>Identify which users have been using PowerApps</li> <li>Reuse an app in another location (move from testing or development to production)</li> <li>Review app usage</li> <li>Prevent a user from using PowerApps</li> <li>Manage environments</li> <li>Lab 1: Administration and Maintenance</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans 55265 Microsoft PowerApps 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 55265 Microsoft PowerApps 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 Power Apps

Power Apps

Microsoft Power Platform

<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

Microsoft SQL

AWS Certified Database

SQL Server

Database Administration

55315: Introduction to SQL Databases

<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

55366 Querying Data with Transact-SQL

<h3><b>Overview</b></h3><p><span>With the ever-increasing demand for SQL in personal &amp; professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in SQL  may be.</span></p><p><span>Learning about SQL  or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in SQL . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on SQL  is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates.</span></p><p><span>The self-paced online learning methodology by compete high in this SQL  course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course!</span></p><p><span>Instead of searching for hours, enrol right away on this SQL  course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.</span></p><h3><b>Who is this course for?</b></h3><p><span>While we refrain from discouraging anyone wanting to do this SQL  course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it:</span></p><ol><li><span>Anyone looking for the basics of SQL ,</span></li><li><span>Jobseekers in the relevant domains,</span></li><li><span>Anyone with a ground knowledge/intermediate expertise in SQL ,</span></li><li><span>Anyone looking for a certificate of completion on doing an online training on this topic,</span></li><li><span>Students of SQL , or anyone with an academic knowledge gap to bridge,</span></li><li><span>Anyone with a general interest/curiosity</span></li></ol><h3><b>Career Path</b></h3><p><span>This SQL  course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. </span></p><div><div><div><h3>
Course Curriculum</h3><div><div><h4>
Module 1- Introduction to SQL</h4><div><div><ul><li><div>
<span></span><h5>
Introduction to SQL</h5></div><div>
<span>
00:00													</span>
<span></span></div></li></ul></div></div></div><div><h4>
Module 2 - SQL Installation</h4><div><div><ul><li><div>
<span></span><h5>
SQL Installation</h5></div><div>
<span>
00:00													</span>
<span></span></div></li></ul></div></div></div><div><h4>
Module 3 - Beginner SQL</h4><div><div><ul><li><div>
<span></span><h5>
Beginner SQL</h5></div><div>
<span>
00:00													</span>
<span></span></div></li></ul></div></div></div><div><h4>
Module 4 - Queries</h4><div><div><ul><li><div>
<span></span><h5>
Queries</h5></div><div>
<span>
00:00													</span>
<span></span></div></li></ul></div></div></div><div><h4>
Module 5 - Intermediate SQL</h4><div><div><ul><li><div>
<span></span><h5>
Intermediate SQL</h5></div><div>
<span>
00:00													</span>
<span></span></div></li></ul></div></div></div><div><h4>
Module 6 - Advanced SQL Operators</h4><div><div><ul><li><div>
<span></span><h5>
Advanced SQL Operators</h5></div><div>
<span>
00:00													</span>
<span></span></div></li></ul></div></div></div></div></div></div></div>

Overview
With the ever-increasing demand for SQL in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in SQL may be.
Learning about SQL or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in SQL . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on SQL is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates.
The self-paced online learning methodology by compete high in this SQL course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course!
Instead of searching for hours, enrol right away on this SQL course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run.
Who is this course for?
While we refrain from discouraging anyone wanting to do this SQL course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it:
Anyone looking for the basics of SQL ,
Jobseekers in the relevant domains,
Anyone with a ground knowledge/intermediate expertise in SQL ,
Anyone looking for a certificate of completion on doing an online training on this topic,
Students of SQL , or anyone with an academic knowledge gap to bridge,
Anyone with a general interest/curiosity
Career Path
This SQL course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. 

Course Curriculum
Module 1- Introduction to SQL
Introduction to SQL

00:00
Module 2 - SQL Installation
SQL Installation

00:00
Module 3 - Beginner SQL
Beginner SQL

00:00
Module 4 - Queries
Queries

00:00
Module 5 - Intermediate SQL
Intermediate SQL

00:00
Module 6 - Advanced SQL Operators
Advanced SQL Operators

00:00

772 Courses

40550 Microsoft Cloud Workshop - Windows Server and SQL Server 2008 EOS planning

By Nexus Human

Cloud Computing for Beginners - Database Technologies and Infrastructure as a Service

By Packt

Advanced SAS Programming Using MacrosSQL

By Studyhub UK

Python Powerhouse: Python Bundle Course for All Levels

By Apex Learning

Web Application Penetration Testing Course

By Skill Up

The Complete Python and PostgreSQL Developer Course

By Packt

Learn MySQL from Scratch for Data Science and Analytics Course

By One Education

Getting Started with Spring Boot 2

By Packt

Offensive Hacking Unfolded - Become a Pro Pentester

By Packt

Real-Time Data Stream Processing in Azure

By Packt

Search By Location