Name: AWS Certified Solutions Architect Associate Preparation
Price: 10.99 GBP
Availability: InStock

<h2>Bridging the Gap with Agile</h2>
Learn how a large cloud-computing enterprise used Flawless ExecutionSM, a remarkably scalable agile business framework, across diverse business teams including their Marketing Team, Legal Team, C-Suite and even the Sales Group functional teams that are notorious for avoiding agile methodologies. As part of a major merger, the company sought to unite two sales teams that were not strategically aligned and didn't have a customer-focused mindset. Just as agile methodologies help developers keep the customer at the forefront of the conversation, this sales organization used the agile techniques and practices of Flawless ExecutionSM, to align around the customer's needs, scale best practices, and shift the culture to a more customer-centric mindset. Result: after an abysmal first half in 2016, the team rallied together after implementing Flawless Execution as their process of record over the summer and beat their sales forecast by 17% in Q4. This had an impact on morale for the 22,000-person company and even increased the stock price by 10%.
This and other IILLearning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topicsmay qualify for othercontinuing education credits such as SEUs, or CEUs.
Each professional development activity yields one PDU for one hour spent engaged in the activity. Somelimitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities andassociated policies.

IIL Europe Ltd

Bridging the Gap with Agile

General Admission

<div id="course-pricing" fr-original-style="" style="box-sizing: border-box;">
 </div><div fr-original-style="" style="box-sizing: border-box;">
Do you want to learn how to function with Azure Storage, a cloud storage solution, in order to make highly scalable and available applications? Are you interested to create a strong storage foundation for an Azure machine? If so, take a look at our precise Microsoft Azure Storage course. The contents of the course teach you all the relevant aspects to become efficient in this field.
First and foremost, the course teaches you how to create a practical application in different circumstances using Azure storage services such as queue, blob, table and, file. Following that, it teaches you how to design applications and measure these applications considering the amount of data. After that, it guides you how to backup data automatically, deploy your solution, recover data, store, scale, and monitor data with Azure Storage.
<h3 fr-original-style="" style="box-sizing: border-box;">Who is this course for?</h3>
Microsoft Azure Storage is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don&#39;t have to worry about the quality.
<h3 fr-original-style="" style="box-sizing: border-box;">Requirements</h3>
Our Microsoft Azure Storage is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc.
<h3 fr-original-style="" style="box-sizing: border-box;">CPD Certificate from Course Gate&nbsp;</h3>
At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for &pound;9 and the hard copy for &pound;15. Also, you can order both PDF and hardcopy certificates for &pound;22.
<h3 fr-original-style="" style="box-sizing: border-box;">Career path</h3>
This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry.
</div><div fr-original-style="" style="box-sizing: border-box;">
<h3 fr-original-style="" style="box-sizing: border-box;">
Course Curriculum
</h3>

<div fr-original-style="" style="box-sizing: border-box;">
<table width="100%" fr-original-style="" style="border: none; border-collapse: collapse; empty-cells: show; max-width: 100%; box-sizing: border-box;"><tbody fr-original-style="" style="box-sizing: border-box;"><tr fr-original-style="" style="box-sizing: border-box;"><td colspan="4" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Introduction</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Introduction</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">FREE </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:03:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td colspan="4" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Working with Storage</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Azure Storage Overview</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:03:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Working with Azure Storage Accounts</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:09:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Storage Access</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:05:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Using Azure Blob Storage</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:06:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Using Azure File Storage</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:04:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Azure File Sync</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:10:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Monitoring Storage</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:03:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Content Delivery Network</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:03:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">CDN Profile</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:06:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Azure Backup Vault</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:04:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Azure Site Recovery</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:03:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td colspan="4" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Conclusion</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Course Recap</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:03:00</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td colspan="4" fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Certificate and Transcript</td></tr>
<tr fr-original-style="" style="box-sizing: border-box;"><td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);">Order Your Certificates or Transcripts</td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> </td>
<td fr-original-style="" style="min-width: 5px; box-sizing: border-box; user-select: text; border: 1px solid rgb(221, 221, 221);"> 00:00:00</td></tr></tbody></table></div>

</div>

Course Gate

Microsoft AZ-900

IT Certifications

Cloud Architecture

Cloud Computing

Microsoft AZ-104

Trainers Course

Microsoft Azure

Microsoft AZ-303

Microsoft AZ-700

Microsoft Azure Storage

Welcome to Microsoft sql server development for everyone Course. The world of data is a vast and complex one. But with the right tools, it can be yours to explore. SQL Server is one of those tools. It's a powerful database management system that can help you store, manage, and analyse data in ways that were never before possible.
 
In this Microsoft SQL Server Development for Everyone! course, you'll learn the basics of SQL Server development. You'll learn how to create and manage databases, tables, and data. You'll also learn how to write SQL queries to manipulate data.
 
Starting with a solid Introduction to SQL, you'll grasp core concepts and gain a strong foundation. We'll then dive into Manipulating Tables and Data, equipping you with effective skills for storing, retrieving, updating, and deleting information.
 
But we won't stop there! Our in-depth exploration of Relationships and Foreign Keys will ensure you understand the importance of data integrity and how to establish connections between tables. You'll create robust and reliable databases with enforced referential integrity. Next, we'll empower you with the tools of Group By and Aggregate Functions, enabling efficient data analysis and summarisation. Extracting meaningful insights from vast amounts of information will become second nature to you.
 
To become a well-rounded SQL Server developer, we'll conclude the course with Advanced SQL Server Objects and Concepts. You'll gain a deep understanding of essential elements like stored procedures, views, triggers, and indexes. This knowledge will optimise performance and streamline your development process.
 
By the end of this Microsoft SQL Server Development for Everyone! course, you'll have a strong understanding of how to use SQL Server to manage and manipulate data. You'll be able to build powerful applications that make better decisions. Become a sought-after SQL Server developer and master the art of data management. Join us today and unlock your data-driven potential!
 
Learning Outcomes:
Through this comprehensive course, you should be able to:
 
<ul>
<li>Understand core concepts and gain a strong foundation in SQL Server development.</li>
<li>Acquire skills to effectively manipulate tables and data.</li>
<li>Establish relationships and enforce data integrity using foreign keys.</li>
<li>Utilise group by and aggregate functions for efficient data analysis.</li>
<li>Explore advanced SQL Server objects and concepts like stored procedures and views.</li>
<li>Gain proficiency in implementing triggers and optimising database performance.</li>
<li>Develop the ability to create robust and reliable databases.</li>
</ul>
 
Who is this course for?
This Microsoft SQL Server Development for Everyone! course is perfect for:
 
<ul>
<li>Aspiring developers looking to enhance their programming skills.</li>
<li>Professionals seeking to expand their knowledge of SQL Server development.</li>
<li>Individuals interested in exploring the world of databases and data management.</li>
<li>Students or graduates pursuing a career in database administration or development.</li>
<li>Curious learners eager to harness the power of SQL Server.</li>
</ul>
 
Career Path
Our course will help you to pursue a range of careers, including:
 
<ul>
<li>Database Administrator: £25,000 - £60,000 per year.</li>
<li>SQL Developer: £30,000 - £65,000 per year.</li>
<li>Data Analyst: £25,000 - £55,000 per year.</li>
<li>Business Intelligence Developer: £35,000 - £70,000 per year.</li>
<li>Software Engineer: £30,000 - £70,000 per year.</li>
<li>Data Engineer: £40,000 - £80,000 per year.</li>
<li>Database Architect: £45,000 - £90,000 per year.</li>
</ul>
<h3>Certification</h3>
After studying the course materials of the Microsoft SQL Server Development for Everyone! there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.
<h3>Prerequisites</h3>
This Microsoft SQL Server Development for Everyone! does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft SQL Server Development for Everyone! 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.
 <div>
				<h3>
	Course Curriculum
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4"> Introduction</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction to SQL Server and Databases</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Download and Install SQL Server Express</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Manipulating Tables and Data</td>
				</tr>
								<tr>
					<td></td>
					<td>Connect to Database Instance and Create a Database</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Drop or Remove Database</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What is a Database Table?</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create an SQL Database Table</td>
					<td> </td>
					<td> 00:32:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Insert Data into the Table with SQL Script</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Insert Data into the Table with Management Studio</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Select Data from the Table with SQL Script</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>More Advanced Select Queries Part 1</td>
					<td> </td>
					<td> 00:18:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Update Data in the Table</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Update Data in the Table with Management Studio GUI</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Delete Data from the Table with SQL Script</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Delete Data from the Table with Management Studio GUI</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Relationships and Foreign Keys</td>
				</tr>
								<tr>
					<td></td>
					<td>What are Relationships, Foreign Keys and Normalization</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Relationship in SQL Server</td>
					<td> </td>
					<td> 00:19:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Insert Records in Related Tables</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Run Queries on Related Tables</td>
					<td> </td>
					<td> 00:19:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Left, Right and Full Joins</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td colspan="4">Group By and Aggregate Functions</td>
				</tr>
								<tr>
					<td></td>
					<td>Grouping Data using SQL GROUP BY Clause</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SQL AVG Aggregate Function</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SQL COUNT Aggregate Function</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SQL MAX and MIN Aggregate Functions</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SQL SUM Aggregate Function</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Advanced SQL Server Objects and Concepts</td>
				</tr>
								<tr>
					<td></td>
					<td>Create and Manage Views</td>
					<td> </td>
					<td> 00:23:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Scalar Valued Functions</td>
					<td> </td>
					<td> 00:27:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Inline Table Valued Functions</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Multi Statement Table Valued Functions</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Stored Procedures</td>
					<td> </td>
					<td> 00:28:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Table Triggers</td>
					<td> </td>
					<td> 00:19:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Database Scripting, Backup and Restore</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td colspan="4">Assignment</td>
				</tr>
								<tr>
					<td></td>
					<td>Assignment - Microsoft SQL Server Development for Everyone!</td>
					<td> </td>
					<td> 00:00:00</td>
				</tr>
				</tbody></table></div>

			</div>

Studyhub UK

Microsoft Certification

Microsoft SQL Server

Microsoft SQL

Microsoft Certified Solutions Associate (MCSA)

SQL Server

Microsoft SQL Server Development for Everyone!

Embark on a transformative journey into the realm of cutting-edge development with our course, 'Master Spring Boot 3.0 and MongoDB.' Crafted with precision and innovation, this course is a gateway to mastering the intricate dance between Spring Boot and MongoDB, providing you with the skills to revolutionize your coding prowess. Immerse yourself in an engaging learning experience, where each section unfolds like a chapter in a captivating novel, unveiling the secrets of MongoDB, the nuances of Bootstrapping applications, and the artistry of integrating OpenAPI. It's more than a course; it's an odyssey into the heart of modern development, beckoning you to embrace a new era of programming possibilities.
In this dynamic learning adventure, traverse through the course curriculum like an explorer unraveling a map to success. From laying the groundwork in the introduction to conquering complex queries and MongoDB templates, you'll navigate the landscape of development with confidence. The course is not just about acquiring knowledge; it's about transforming that knowledge into practical expertise. Whether you're a novice eager to embark on a coding expedition or a seasoned developer seeking to enhance your skills, this course is your compass to navigate the vast territories of Spring Boot and MongoDB, promising a voyage filled with discovery and mastery.
Learning Outcomes
<ul>
<li>Develop a profound understanding of MongoDB, from environmental preparation to advanced query methods.</li>
<li>Master the art of bootstrapping applications, gaining hands-on experience in crafting robust and efficient systems.</li>
<li>Uncover the intricacies of collections relationships and the use of DBRef, adding a layer of sophistication to your database interactions.</li>
<li>Seamlessly integrate OpenAPI into your projects, enhancing the accessibility and documentation of your applications.</li>
<li>Acquire expertise in document queries and MongoDB templates, empowering you to build scalable and efficient databases.</li>
</ul>
<h3>Why choose this Master Spring boot 3.0 and MongoDB course?</h3>
<ol>
<li>Unlimited access to the course for a lifetime.</li>
<li>Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ 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>Who is this Master Spring boot 3.0 and MongoDB course for?</h3>
<ul>
<li>Aspiring developers keen on mastering the Spring Boot-MongoDB synergy.</li>
<li>Software engineers looking to deepen their understanding of advanced database operations.</li>
<li>Students and coding enthusiasts eager to explore the latest tools in the development landscape.</li>
<li>Professionals seeking to upgrade their skill set in line with industry demands.</li>
<li>Entrepreneurs or tech enthusiasts aiming to build robust applications from the ground up.</li>
</ul>
<h3>Career path</h3>
<ul>
<li>MongoDB Developer: £40,000 - £60,000</li>
<li>Spring Boot Engineer: £45,000 - £70,000</li>
<li>Database Architect: £55,000 - £80,000</li>
<li>Full Stack Developer: £50,000 - £75,000</li>
<li>Java Developer (Specializing in Spring Boot): £45,000 - £65,000</li>
<li>API Integration Specialist: £50,000 - £70,000</li>
</ul>
<h3>Prerequisites</h3>
This Master Spring boot 3.0 and MongoDB does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Master Spring boot 3.0 and MongoDB 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.
<h3>Certification</h3>
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.<div>
				<h3>
	Course Curriculum
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Section 01: Introduction</td>
				</tr>
								<tr>
					<td></td>
					<td>What is MongoDB</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The Difference Between SQL and NoSQL</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to Choose Between SQL and NoSQL</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 02: Prepare The Mongo Environment</td>
				</tr>
								<tr>
					<td></td>
					<td>MongoDB UI Tools</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Why Use Docker for Development</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create an Empty Docker Compose File</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Mongo Server (Docker Compose)</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Mongo Express (Docker Compose)</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Run and Test</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 03: Mongo Terms</td>
				</tr>
								<tr>
					<td></td>
					<td>Collections and Documents in Mongo</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 04: Bootstrapping The Application</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a New Spring Boot 3.0 Project</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Project Structure</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Include the Docker Compose with the Project and Run It</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Project Architecture</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Connect to MongoDB</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a New Database</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Understand Admin - Local and Config Databases</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Java Class</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Transform the Java Class into a Collection</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Mongo Repository</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Insert the First Data into the Collection</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Product Service</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Save the product</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Find Product by ID</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Find All Products</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Delete Product</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 05: CRUD Operations</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Product Controller</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Save Product Operation</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Find All Products</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Find Product by ID</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Delete Product</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Test the CRUD Operations</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 06: DBRef And Collections Relationships</td>
				</tr>
								<tr>
					<td></td>
					<td>Extend the Product Model</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Category Java Class</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>User Category as a Field</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Relationship between Category and Product</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Transform the Category to a Collection</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Category Repository</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Insert Categories at Startup</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>The Issue in Linking Collections</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Add Relationship Between Collections</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 07: OpenApi Integration</td>
				</tr>
								<tr>
					<td></td>
					<td>Add OpenApi Dependency</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Test and Play with Swagger UI</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 08: Documents Queries And Mongo Template</td>
				</tr>
								<tr>
					<td></td>
					<td>Extend the Product Model</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Search Service</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What is MongoTemplate</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Is() Query</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Testing the Is() Query</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Regex() Query</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Lt() Query</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Gt() Query</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Sorting Data</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Paging and Sorting</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 09: Query Methods</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Query Method Service</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>FindByX Query</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>FinByX Ignore Case Query</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>FinByX starting with query</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>FinByX ending with query</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>FinByX containing query</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>FinByX less than</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>FinByX greater than</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>FinByX between</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>FinByX and SortByY</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Paging and Sorting</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
				</tbody></table></div>

			</div>

MongoDB

Master Spring boot 3.0 and MongoDB

Embark on a transformative journey into the realm of AutoCAD Plugin Development using VB.NET and Windows Forms with our meticulously crafted course. From the intricacies of Windows Form and Controls to the hands-on development of diverse projects like DrawRectangle, Automate Update Layer, and Multiple Object Extractor, this course promises to be a dynamic exploration of VB.NET's potential in the AutoCAD ecosystem. Delve into the heart of coding as you master the creation of utility classes, design intuitive user interfaces, and seamlessly integrate controls such as ComboBox, TextBox, RadioButton, and Checkbox. Elevate your programming prowess through real-world applications, ensuring you not only understand the theoretical foundations but also acquire the practical skills needed to thrive in the world of AutoCAD Plugin Development.
Unlock the mysteries of AutoCAD Plugin Development as you navigate through engaging modules, honing your skills with each meticulously crafted project. By the end, you'll emerge not just as a student but as a proficient developer ready to create powerful plugins that enhance AutoCAD functionalities.
Learning Outcomes
<ul>
<li>Gain a comprehensive understanding of Windows Form and Controls, mastering their implementation in AutoCAD Plugin Development.</li>
<li>Develop practical expertise in coding essential controls like ComboBox, TextBox, RadioButton, and Checkbox for seamless integration into your projects.</li>
<li>Acquire the skills to design and execute diverse projects, from DrawRectangle to Multiple Object Extractor, elevating your proficiency in VB.NET.</li>
<li>Learn the art of creating utility classes, a fundamental aspect of building robust and scalable AutoCAD plugins.</li>
<li>Explore automation in AutoCAD through projects like Automate Update Layer and Multiple Plot DWG to PDF, enhancing your capabilities in streamlining tasks.</li>
</ul>
<h3>Why choose this AutoCAD Plugin Development Using VB.NET and Windows Forms course?</h3>
<ul>
<li>Unlimited access to the course for a lifetime.</li>
<li>Opportunity to earn a certificate accredited by the CPD Quality Standards 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 are designed to evaluate advanced cognitive abilities and skill proficiency.</li>
<li>Flexibility to complete the AutoCAD Plugin Development Using VB.NET and Windows Forms 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>
</ul>
<h3>Who is this AutoCAD Plugin Development Using VB.NET and Windows Forms course for?</h3>
<ul>
<li>Aspiring developers eager to specialize in AutoCAD Plugin Development.</li>
<li>Professionals seeking to expand their skill set in VB.NET and Windows Forms for application in the AutoCAD environment.</li>
<li>Students pursuing a career in computer programming with a keen interest in CAD software development.</li>
<li>Architects and engineers looking to customize and enhance AutoCAD functionalities for their specific needs.</li>
<li>Individuals interested in exploring the intersection of coding and design within the AutoCAD ecosystem.</li>
</ul>
<h3>Career path</h3>
<ul>
<li>CAD Plugin Developer: £35,000 - £45,000</li>
<li>Automation Engineer in CAD: £40,000 - £50,000</li>
<li>VB.NET Developer: £30,000 - £40,000</li>
<li>Software Integration Specialist: £45,000 - £55,000</li>
<li>AutoCAD Customization Consultant: £50,000 - £60,000</li>
</ul>
<h3>Prerequisites</h3>
This AutoCAD Plugin Development Using VB.NET and Windows Forms does not require you to have any prior qualifications or experience. You can just enrol and start learning.This AutoCAD Plugin Development Using VB.NET and Windows Forms 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.
<h3>Certification</h3>
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.<div>
				<h3>
	Course Curriculum
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Course Outline</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Landing Page</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Course Outline</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Introduction</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Introduction</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Who is this course for?</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: Tools Needed for this Course</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">What Will You Learn From This Course?</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: What will you learn from this Course - Overview</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Windows Form And Controls</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Windows Form and Controls - Overview</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: ControlsDemo Project - Overview</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: ControlsDemo Project - Creating the Project</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 04: Controls Demo Project - Designing the Form</td>
					<td> </td>
					<td> 00:19:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 05: ControlsDemo Project - Creating the Utility Class</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 06: ControlsDemo Project - Coding the Combobox Control</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 07: ControlsDemo Project - Coding the Textbox Control</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 08: ControlsDemo Project - Coding the Radiobutton Control</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 09: ControlsDemo Project - Coding the Checkbox Control</td>
					<td> </td>
					<td> 00:17:00</td>
				</tr>
								<tr>
					<td colspan="4">Developing Projects</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 01: Draw Rectangle Project - Overview</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 02: Creating the DrawRectangle Project</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 03: DrawRectangle Project - Creating the Utility Class</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 04: DrawRectangle Project - Designing the Form</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 05: DrawRectangle Project - Coding the User Interface Part 1</td>
					<td> </td>
					<td> 00:24:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 06: DrawRectangle Project - Coding the User Interface Part 2</td>
					<td> </td>
					<td> 00:18:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 07: DrawRectangle Project - Running the Program</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 08: Automate Update Layer Project - Overview</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 09: Creating the AutomateUpdateLayer Project</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 10: Automate Update Layer Project - Creating the Utility Class</td>
					<td> </td>
					<td> 00:17:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 11: AutomateUpdateLayer Project - Designing the User Interface</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 12: AutomateUpdateLayer Project - Coding the Form</td>
					<td> </td>
					<td> 00:18:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 13: AutomateUpdateLayer Project - Running the Program</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 14: Automatic Block Extractor Project - Overview</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 15: AutomaticBlockExtractor Project - Creating the Project</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 16: AutomaticBlockExtractor Project - Creating the User Interface</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 17: AutomaticBlockExtractor Project - Coding the Form</td>
					<td> </td>
					<td> 00:27:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 18: AutomaticBlockExtractor Project - Creating the Utility Class</td>
					<td> </td>
					<td> 00:27:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 19: AutomaticBlockExtractor Project - Running the Program</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 20: AutomateUpdateTextStyles Project - Overview</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 21: AutomateUpdateTextStyle Project - Creating the Project</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 22: AutomateUpdateTextStyle Project - Creating the User Interface</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 23: AutomateUpdateTextStyle Project - Coding the Form</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 24: AutomateUpdateTextStyle Project - Coding the Utility Class</td>
					<td> </td>
					<td> 00:16:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 25: AutomateUpdateTextStyle Project - Running the Program</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 26: Multiple Plot DWG to PDF Project - Overview</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 27: MultiplePlotDWGtoPDF Project - Creating the Project</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 28: MultiplePlotDWGtoPDF Project - Creating the User Interface</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 29: MultiplePlotDWGtoPDF Project - Coding the Form</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 30: MultiplePlotDWGtoPDF Project - Creating the Utility Class</td>
					<td> </td>
					<td> 00:30:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 31: MultiplePlotDWGtoPDF Project - Running the Program</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 32: Multiple Object Extractor Project - Overview</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 33: MultipleObjectExtractor Project - Creating the Project</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 34: MultipleObjectExtractor Project - Creating the User Interface</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 35: MultipleObjectExtractor Project - Coding the Form Load Event</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 36: MultipleObjectExtractor Project - Coding the Browse Buttons</td>
					<td> </td>
					<td> 00:10:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 37: MultipleObjectExtractor Project - Coding the Extract Button</td>
					<td> </td>
					<td> 00:20:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 38: MultipleObjectExtractor Project - Coding the ProcessDrawing Method</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 39: MultipleObjectExtractor Project - Coding the ProcessObjectExtraction Method</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 40: MultipleObjectExtractor Project - Coding the ExtractLine Method</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 41: MultipleObjectExtractor Project - Coding the ExtractCircle Method</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 42: MultipleObjectExtractor Project - Coding the ExtractPolyline Method</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 43: MultipleObjectExtractor Project - Coding the ExtractMText Method</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 44: MultipleObjectExtractor Project - Coding the ExtractBlock Method</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Module 45: MultipleObjectExtractor Project - Running the Program</td>
					<td> </td>
					<td> 00:15:00</td>
				</tr>
				</tbody></table></div>

			</div>

AutoCAD

ARCHICAD

Autodesk

TurboCAD

Automation Anywhere

AutoCAD Plugin Development Using VB.NET and Windows Forms

Online Course Creation

AWS Certification

AWS Certified Developer

AWS Certified Cloud Practitioner

Professional Skills Course (PSC)

AWS Certified Solutions Architect

AWS Solutions Architect & SysOps Administrator

<div>
						<div>
				<div>
									<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
								<div>
				Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes:<ul><li>Establish a strong foundation in SQL and MySQL.</li><li>Set up and configure SQL Server for efficient data handling.</li><li>Master SQL's Data Manipulation, Definition, and Control Language.</li><li>Create and optimize SQL queries for data analysis.</li><li>Perform advanced data analytics using SQL.</li><li>Understand the power of GROUP BY and JOIN statements.</li><li>Implement data constraints and views for data integrity and security.</li><li>Develop proficiency in stored procedures, data import/export, and database backup/restore.</li></ul> Why buy this Learn MySQL from Scratch for Data Science and Analytics? <ul><li>Unlimited access to the course for forever</li><li>Digital Certificate, Transcript, student ID all included in the price</li><li>Absolutely no hidden fees</li><li>Directly receive CPD accredited qualifications after course completion</li><li>Receive one to one assistance on every weekday from professionals</li><li>Immediately receive the PDF certificate after passing</li><li>Receive the original copies of your certificate and transcript on the next working day</li><li>Easily learn the skills and knowledge from the comfort of your home</li></ul> CertificationAfter studying the course materials of the Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for?This Learn MySQL from Scratch for Data Science and Analytics course is ideal for<ul><li>Aspiring Data Scientists and Analysts.</li><li>Database Administrators and Developers.</li><li>Students and professionals seeking to enter the field of Data Science.</li><li>Anyone looking to enhance their SQL and MySQL skills for data-related roles.</li></ul> PrerequisitesThis Learn MySQL from Scratch for Data Science and Analytics was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path<ul><li>Data Analyst: £25,000 - £50,000 per year.</li><li>Database Administrator: £30,000 - £60,000 per year.</li><li>SQL Developer: £30,000 - £60,000 per year.</li><li>Data Scientist: £40,000 - £80,000 per year.</li><li>Business Intelligence Analyst: £35,000 - £65,000 per year.</li></ul>					</div>
						</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
									</div>
			</div>
					</div><div>
				<h3>
	Course Curriculum
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Learn MySQL from Scratch for Data Science and Analytics</td>
				</tr>
								<tr>
					<td colspan="4">Section 01: Getting Started</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to get course requirements</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Getting started on Windows, Linux or Mac</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to ask great questions</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>FAQ's</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What is Source Code?</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 02: SQL Server setting up</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>MySQL Server Installation</td>
					<td> </td>
					<td> 00:14:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Connect MySQL Server Instance</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>MySQL Workbench overview</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Download and Restore Sample Database</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 03: SQL Database basics</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Overview of Databases</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Database</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SQL Data Types</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Column Data Types on Workbench</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Table</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Overview of Primary and Foreign Key</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Primary Key</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Foreign Key</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Temporary tables</td>
					<td> </td>
					<td> 00:12:00</td>
				</tr>
								<tr>
					<td></td>
					<td>EER - Enhanced Entity Relationship Diagrams</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 04: SQL DML (Data Manipulation Language)</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Insert statement</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Update statement</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Delete statement</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 05: SQL DDL (Data Definition Language)</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>CREATE table statement</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>DROP statement</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>ALTER statement</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>TRUNCATE statement</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>COMMENT in query</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>RENAME table</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 06: SQL DCL (Data Control Language)</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Database user</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>GRANT permissions</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>REVOKE permissions</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 07: SQL Statement Basic</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SQL Statement basic</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT Statement</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT DISTINCT</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT with column headings</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Column AS statement</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>DASHBOARD Analytics</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 08: Filtering Data rows</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT WHERE Clause - theory</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT WHERE Clause - practical</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 09: Aggregate functions for Data Analysis</td>
				</tr>
								<tr>
					<td></td>
					<td>Sum()</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Min()-Max()</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 10: SQL Data Analyticstatements</td>
				</tr>
								<tr>
					<td></td>
					<td>Order By statement</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT TOP 3 records</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>BETWEEN command</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>IN operator</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Search Data usingLIKE cards</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 11: SQL Group by statement</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Group by - theory</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data Analytics with Group By</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>HAVING statement</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 12: JOINS</td>
				</tr>
								<tr>
					<td></td>
					<td>Overview of Joins</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What are Joins</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Inner join</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Left outer join</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Right outer join</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Union</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>CERTESIAN Product or Cross Join</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Query Exercise</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Solution for Query Exercise</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 13: SQL Constraints</td>
				</tr>
								<tr>
					<td></td>
					<td>Section introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Check constraint</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>NOT NULL constraint</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>UNIQUE constraint</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 14: Views</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Views</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data Analytic Views from multiple tables</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 15: Advanced SQL Functions</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Timestamp</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Extract from timestamp</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Mathematical scalar functions</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>String functions3</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Advanced functions</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Sub Queries</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT with calculations</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 16: SQL Stored procedures</td>
				</tr>
								<tr>
					<td></td>
					<td>Create stored procedure</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Stored procedure with parameter</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Drop Procedure</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 17: Import &amp; Export data</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Import .csv file</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Export Data to .csv file</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 18: Backup and Restore Database</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Database backup</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Restoring Database backup</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
				</tbody></table></div>

			</div>

Learning & Development

Data Engineering

AWS Certified Database

Data Skills

Learn MySQL from Scratch for Data Science and Analytics

<div>
<div>
<div>
<div>
<div>
<div>
This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals.
<h3>Learning Outcomes:</h3>
<ul>
<li>Set up and configure SQL Server and SQL Azure Data Studio for data analysis.</li>
<li>Master SQL statements for data manipulation, data structure, and user management.</li>
<li>Utilize SQL queries, joins, and aggregate functions for efficient data analysis.</li>
<li>Understand SQL constraints, views, and advanced commands for in-depth data exploration.</li>
<li>Create and implement SQL stored procedures to automate tasks.</li>
<li>Leverage Azure Data Studio for data visualization and perform data analysis with SQL.</li>
</ul>
</div>
</div>
</div>
</div>
</div>
</div>
<h3>Why buy this SQL for Data Science, Data Analytics and Data Visualization?</h3>
<ol>
<li>Unlimited access to the course for forever</li>
<li>Digital Certificate, Transcript, student ID all included in the price</li>
<li>Absolutely no hidden fees</li>
<li>Directly receive CPD accredited qualifications after course completion</li>
<li>Receive one to one assistance on every weekday from professionals</li>
<li>Immediately receive the PDF certificate after passing</li>
<li>Receive the original copies of your certificate and transcript on the next working day</li>
<li>Easily learn the skills and knowledge from the comfort of your home</li>
</ol>
<h3>Certification</h3>
After studying the course materials of the SQL for Data Science, Data Analytics and Data Visualization there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.
<h3>Who is this course for?</h3>
This SQL for Data Science, Data Analytics and Data Visualization course is ideal for
<ul>
<li>Students</li>
<li>Recent graduates</li>
<li>Job Seekers</li>
<li>Anyone interested in this topic</li>
<li>People already working in the relevant fields and want to polish their knowledge and skill.</li>
</ul>
<h3>Prerequisites</h3>
This SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization 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.
<h3>Career path</h3>
As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home.<div>
				<h3>
	Course Curriculum
</h3>

<div>
<table width="100%">				<tbody><tr>
					<td colspan="4">Section 01: Getting Started</td>
				</tr>
								<tr>
					<td></td>
					<td>Introduction</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to get course requirements</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Getting started on Windows, Linux or Docker</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to ask great questions</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>FAQ's</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 02: SQL Server setting up</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Microsoft SQL Server Installation</td>
					<td> </td>
					<td> 00:19:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SQL Server Management Studio (SSMS) Installation</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to connect MS SQL (Windows Authentication)</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>How to connect MS SQL (SQL Server Authentication)</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Download and Restore Sample Database</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 03: SQL Azure Data Studio</td>
				</tr>
								<tr>
					<td></td>
					<td>What is Azure Data Studio</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Azure Data Studio Installation steps</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Azure Data Studio to Connect SQL Server</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Database</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Create a Table</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Insert Data rows</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>View the Data returned by Query</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 04: SQL Database basic SSMS</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Overview of Databases8</td>
					<td> </td>
					<td> 00:11:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Database</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SQL Data Types</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Column Data Types on SSMS</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Table</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Overview of Primary Key and Foreign Key</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Primary Key</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Foreign Key</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Temporary tables</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 05: SQL Statements for DATA</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Insert statement</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Update statement</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Delete statement</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 06: SQL Data Structure statements</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>CREATE table statement</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>DROP statement</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>ALTER statement</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>TRUNCATE statement</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>COMMENT in query</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>RENAME</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 07: SQL User Management</td>
				</tr>
								<tr>
					<td></td>
					<td>Create Database user</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>GRANT permissions</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td></td>
					<td>REVOKE permissions</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 08: SQL Statement Basic</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SQL Statement basic</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT Statement</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT DISTINCT</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT with column headings</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Column AS statement</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 09: Filtering Data rows</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT WHERE Clause - theory</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT WHERE Clause - practical</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 10: Aggregate functions</td>
				</tr>
								<tr>
					<td></td>
					<td>Sum()</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Min()-Max()</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 11: SQL Query statements</td>
				</tr>
								<tr>
					<td></td>
					<td>Order By statement</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT TOP clause in SQL</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>BETWEEN command</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>IN operator</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Wildcard Characters and LIKE</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 12: SQL Group by statement</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Group by - theory8</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Group by - practical</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>HAVING statement</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 13: JOINS for Multiple table Data Analysis</td>
				</tr>
								<tr>
					<td></td>
					<td>Overview of Joins</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>What are Joins</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Inner join</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Left outer join</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Right outer join</td>
					<td> </td>
					<td> 00:02:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Full outer join</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Union</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Cartesian Product with the Cross Join</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Query Exercise</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Solution for Query Exercise</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 14: SQL Constraints</td>
				</tr>
								<tr>
					<td></td>
					<td>Section introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Check constraint</td>
					<td> </td>
					<td> 00:07:00</td>
				</tr>
								<tr>
					<td></td>
					<td>NOT NULL constraint</td>
					<td> </td>
					<td> 00:08:00</td>
				</tr>
								<tr>
					<td></td>
					<td>UNIQUE constraint</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 15: Views</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Views</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Reporting with multiple tables</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 16: Advanced SQL commands</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Timestamp</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Extract from timestamp</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Mathematical scalar functions</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>String functions</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Sub Query</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>SELECT with calculations</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 17: SQL Stored procedures</td>
				</tr>
								<tr>
					<td></td>
					<td>Create stored procedure</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Stored procedure with parameter</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 18: Azure Data Studio Visualization</td>
				</tr>
								<tr>
					<td></td>
					<td>Installing SandDance Extension</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Visualization Charts</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Multiple Table Data Charts</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 19: Azure Studio SQL for Data Analysis</td>
				</tr>
								<tr>
					<td></td>
					<td>Type Decision for Data Analysis</td>
					<td> </td>
					<td> 00:13:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Data Analysis with Case Statement and String Text</td>
					<td> </td>
					<td> 00:09:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 20: Import &amp; Export data</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Import Flat File</td>
					<td> </td>
					<td> 00:05:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Import .csv or excel file</td>
					<td> </td>
					<td> 00:03:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Export Data to Excel or any format</td>
					<td> </td>
					<td> 00:06:00</td>
				</tr>
								<tr>
					<td colspan="4">Section 21: Backup and Restore Database</td>
				</tr>
								<tr>
					<td></td>
					<td>Section Introduction</td>
					<td> </td>
					<td> 00:01:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Creating Database backup</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
								<tr>
					<td></td>
					<td>Restoring Database backup</td>
					<td> </td>
					<td> 00:04:00</td>
				</tr>
				</tbody></table></div>

			</div>

Azure SQL Database

Data Studio

SQL for Data Science, Data Analytics and Data Visualization

Online Course Marketing

Digital Marketing

Search Engine Optimisation (SEO)

Search Engine Optimisation Audit

Professional Development

Google Digital Marketing

SEO Masterclass

Finance Cert & Exam Prep

AWS Certified Solutions Architect Associate Preparation

<div id="course-pills-1">Duration4 Days24 CPD hoursThis course is intended forSuccessful students have experience and knowledge in IT operations, including networking, virtualization, identity, security, business continuity, disaster recovery, data platforms, and governance. Students also have experience designing and architecting solutions. Before attending this course, students must have previous experience deploying or administering Azure resources and strong conceptual knowledge of: <ul> <li>Azure compute technologies such as VMs, containers and serverless solutions </li> <li>Azure virtual networking to include load balancers </li> <li>Azure Storage technologies (unstructured and databases) </li> <li>General application design concepts such as messaging and high availability </li> </ul>This course teaches Azure Solution Architects how to design infrastructure solutions. Course topics cover governance, compute, application architecture, storage, data integration, authentication, networks, business continuity, and migrations. The course combines lecture with case studies to demonstrate basic architect design principles.PrerequisitesBefore attending this course, students must have previous experience deploying or administering Azure resources and conceptual knowledge of: <li>Azure Active Directory</li> <li>Azure compute technologies such as VMs, containers and serverless solutions</li> <li>Azure virtual networking to include load balancers</li> <li>Azure Storage technologies (unstructured and databases)</li> <li>General application design concepts such as messaging and high availability</li> <li>AZ-104T00 - Microsoft Azure Administrator</li></div><div id="course-pills-2"><h3>1 - Design governance</h3> <ul> <li>Design for governance</li> <li>Design for management groups</li> <li>Design for subscriptions</li> <li>Design for resource groups</li> <li>Design for resource tags</li> <li>Design for Azure Policy</li> <li>Design for role-based access control (RBAC)</li> <li>Design for Azure landing zones</li> </ul> <h3>2 - Design an Azure compute solution</h3> <ul> <li>Choose an Azure compute service</li> <li>Design for Azure Virtual Machines solutions</li> <li>Design for Azure Batch solutions</li> <li>Design for Azure App Service solutions</li> <li>Design for Azure Container Instances solutions</li> <li>Design for Azure Kubernetes Service solutions</li> <li>Design for Azure Functions solutions</li> <li>Design for Azure Logic Apps solutions</li> </ul> <h3>3 - Design a data storage solution for non-relational data</h3> <ul> <li>Design for data storage</li> <li>Design for Azure storage accounts</li> <li>Design for data redundancy</li> <li>Design for Azure Blob Storage</li> <li>Design for Azure Files</li> <li>Design for Azure managed disks</li> <li>Design for storage security</li> </ul> <h3>4 - Design a data storage solution for relational data</h3> <ul> <li>Design for Azure SQL Database</li> <li>Design for Azure SQL Managed Instance</li> <li>Design for SQL Server on Azure Virtual Machines</li> <li>Recommend a solution for database scalability</li> <li>Recommend a solution for database availability</li> <li>Design security for data at rest, data in motion, and data in use</li> <li>Design for Azure SQL Edge</li> <li>Design for Azure Cosmos DB and Table Storage</li> </ul> <h3>5 - Design data integration</h3> <ul> <li>Design a data integration solution with Azure Data Factory</li> <li>Design a data integration solution with Azure Data Lake</li> <li>Design a data integration and analytic solution with Azure Databricks</li> <li>Design a data integration and analytic solution with Azure Synapse Analytics</li> <li>Design strategies for hot, warm, and cold data paths</li> <li>Design an Azure Stream Analytics solution for data analysis</li> </ul> <h3>6 - Design an application architecture</h3> <ul> <li>Describe message and event scenarios</li> <li>Design a messaging solution</li> <li>Design an Azure Event Hubs messaging solution</li> <li>Design an event-driven solution</li> <li>Design a caching solution</li> <li>Design API integration</li> <li>Design an automated app deployment solution</li> <li>Design an app configuration management solution</li> </ul> <h3>7 - Design authentication and authorization solutions</h3> <ul> <li>Design for identity and access management (IAM)</li> <li>Design for Microsoft Entra ID</li> <li>Design for Microsoft Entra business-to-business (B2B)</li> <li>Design for Azure Active Directory B2C (business-to-customer)</li> <li>Design for conditional access</li> <li>Design for identity protection</li> <li>Design for access reviews</li> <li>Design service principals for applications</li> <li>Design managed identities</li> <li>Design for Azure Key Vault</li> </ul> <h3>8 - Design a solution to log and monitor Azure resources</h3> <ul> <li>Design for Azure Monitor data sources</li> <li>Design for Azure Monitor Logs (Log Analytics) workspaces</li> <li>Design for Azure Workbooks and Azure insights</li> <li>Design for Azure Data Explorer</li> </ul> <h3>9 - Design network solutions</h3> <ul> <li>Recommend a network architecture solution based on workload requirements</li> <li>Design patterns for Azure network connectivity services</li> <li>Design outbound connectivity and routing</li> <li>Design for on-premises connectivity to Azure Virtual Network</li> <li>Choose an application delivery service</li> <li>Design for application delivery services</li> <li>Design for application protection services</li> </ul> <h3>10 - Design a solution for backup and disaster recovery</h3> <ul> <li>Design for backup and recovery</li> <li>Design for Azure Backup</li> <li>Design for Azure blob backup and recovery</li> <li>Design for Azure files backup and recovery</li> <li>Design for Azure virtual machine backup and recovery</li> <li>Design for Azure SQL backup and recovery</li> <li>Design for Azure Site Recovery</li> </ul> <h3>11 - Design migrations</h3> <ul> <li>Evaluate migration with the Cloud Adoption Framework</li> <li>Describe the Azure migration framework</li> <li>Assess your on-premises workloads</li> <li>Select a migration tool</li> <li>Migrate your structured data in databases</li> <li>Select an online storage migration tool for unstructured data</li> <li>Migrate offline data</li> </ul> <h3>12 - Introduction to the Microsoft Azure Well-Architected Framework</h3> <ul> <li>Azure Well-Architected Framework pillars</li> <li>Cost optimization</li> <li>Operational excellence</li> <li>Performance efficiency</li> <li>Reliability</li> <li>Security</li> </ul> <h3>13 - Microsoft Azure Well-Architected Framework - Cost Optimization</h3> <ul> <li>Develop cost-management discipline</li> <li>Design with a cost-efficiency mindset</li> <li>Design for usage optimization</li> <li>Design for rate optimization</li> <li>Monitor and optimize over time</li> </ul> <h3>14 - Microsoft Azure Well-Architected Framework - Operational excellence</h3> <ul> <li>Embrace DevOps culture</li> <li>Establish development standards</li> <li>Evolve operations with observability</li> <li>Deploy with confidence</li> <li>Automate for efficiency</li> <li>Adopt safe deployment practices</li> </ul> <h3>15 - Microsoft Azure Well-Architected Framework - Performance efficiency</h3> <ul> <li>Negotiate realistic performance targets</li> <li>Design to meet capacity requirements</li> <li>Achieve and sustain performance</li> <li>Improve efficiency through optimization</li> </ul> <h3>16 - Microsoft Azure Well-Architected Framework - Reliability</h3> <ul> <li>Design for business requirements</li> <li>Design for resilience</li> <li>Design for recovery</li> <li>Design for operations</li> <li>Keep it simple</li> </ul> <h3>17 - Microsoft Azure Well-Architected Framework - Security</h3> <ul> <li>Plan your security readiness</li> <li>Design to protect confidentiality</li> <li>Design to protect integrity</li> <li>Design to protect availability</li> <li>Sustain and evolve your security posture</li> </ul> <h3>18 - Getting started with the Microsoft Cloud Adoption Framework for Azure</h3> <ul> <li>Customer narrative</li> <li>Common blockers</li> </ul> <h3>19 - Prepare for successful cloud adoption with a well-defined strategy</h3> <ul> <li>Customer narrative</li> <li>Capture strategic motivation</li> <li>Define objectives and key results</li> <li>Evaluate financial considerations</li> <li>Understand technical considerations</li> <li>Create a business case</li> </ul> <h3>20 - Prepare for cloud adoption with a data-driven plan</h3> <ul> <li>Customer narrative</li> </ul> <h3>21 - Choose the best Azure landing zone to support your requirements for cloud operations</h3> <ul> <li>Customer narrative</li> <li>Common operating models</li> <li>Design areas for Azure landing zones</li> <li>Design principles for Azure landing zones</li> <li>Journey to the target architecture</li> <li>Choose an Azure landing zone option</li> <li>Deploy the Azure landing zone accelerator</li> <li>Enhance your landing zone</li> </ul> <h3>22 - Migrate to Azure through repeatable processes and common tools</h3> <ul> <li>Customer narrative</li> <li>Migration process</li> <li>Migration tools</li> <li>Common tech platforms</li> </ul> <h3>23 - Address tangible risks with the Govern methodology of the Cloud Adoption Framework for Azure</h3> <ul> <li>Customer narrative</li> <li>Govern methodology</li> <li>Corporate policies</li> <li>Governance disciplines</li> <li>Deploy a cloud governance foundation</li> <li>The Cost Management discipline</li> </ul> <h3>24 - Ensure stable operations and optimization across all supported workloads deployed to the cloud</h3> <ul> <li>Establish business commitments</li> <li>Deploy an operations baseline</li> <li>Protect and recover</li> <li>Enhance an operations baseline</li> <li>Manage platform and workload specialization</li> </ul> <h3>25 - Innovate applications by using Azure cloud technologies</h3> <ul> <li>Follow the innovation lifecycle</li> <li>Azure technologies for the build process</li> <li>Infuse your applications with AI</li> <li>Azure technologies for measuring business impact</li> <li>Azure technologies for the learn process</li> </ul> <h3>26 - Prepare for cloud security by using the Microsoft Cloud Adoption Framework for Azure</h3> <ul> <li>Customer narrative</li> <li>Methodology</li> <li>Security roles and responsibilities</li> <li>Simplify compliance and security</li> <li>Simplify security implementation</li> <li>Security tools and policies</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans AZ-305T00: Designing Microsoft Azure Infrastructure Solutions training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the AZ-305T00: Designing Microsoft Azure Infrastructure Solutions course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. 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.</div>

Nexus Human

AZ-305T00 Designing Microsoft Azure Infrastructure Solutions

Packt

Scala

Big Data

Scala is doubtless one of the most in-demand skills for data scientists and data engineers. This competitive course will teach you the essential concepts and methodologies of Scala with a lot of practical implementations.

Scala & Spark-Master Big Data with Scala and Spark

This is an amazing course for anyone who wants to get started with functional programming with libraries such as cats-effect/ZIO and understand IO Monad in depth.

Learn about functional programming and effects from this most structured and well-thought-out course on Scala IOs.
 Modern applications often need to describe complex workflows involving multiple external systems. These are notoriously difficult to get right as it requires handling errors, various retry strategies, and non-determinism because of concurrent executions. In this course, you will learn how to solve this problem using both imperative and functional programming.

This course is divided into three parts.

The first part covers building a CLI tool imperatively. Here, you will learn how to test code with external dependencies, handle errors, and retry if something goes wrong. One of the goals of the section is to discover how functional programmers came up with the notion of IO. It's the commonest way to action the functional programming world.

In the next part, you will create and implement an IO class from scratch; this will solve two different problems, of which one is searching for a flight aggregator. In the final part, you will extend IO to execute tasks concurrently. Here, you will be looking to add concurrency methods to IO implementation so that you can execute some tasks in the background.

By the end of the course, you will be able to read and write code using popular Scala libraries such as cats-effect, Monix, and ZIO. This skill is in high demand.

All the resource files are added to the GitHub repository at: https://github.com/PacktPublishing/Supercharge-Scala-Future---FP-Tower
 <h2>What You Will Learn</h2>Install SBT, Scala, and IntelliJ IDEA Understand the difference between IO (cats-effect, Monix, ZIO) and Future Learn to use lazy evaluation to repeat actions and execute code concurrently Write property-based tests for real-world examples Understand the dangers of blocking code in a concurrent environment Execute a project on flight search aggregator
 <h2>Audience</h2>This course is designed for developers interested in concurrency, functional programming, and backend developers. Scala developers more familiar with Akka, Play, and Future will also gain a lot from this course. Individuals who want to gain the skills to join one of the many companies using functional Scala and learn to think functionally will be best suited to this course. You will need to have moderate programming experience with Scala. The author will take you through downloading and installing SBT, Scala, and an IDE.
 <h2>Approach</h2>This course is designed with a practical and hands-on approach. In this course, you will write lots of Scala code, test it using both example-based and property-based tests, experience issues caused by blocking logic and concurrent execution, and work your way to efficient solutions in small and incremental steps. The author guides you through all the exercises and provides a complete set of solutions.
 <h2>Key Features</h2>Learn by demystifying complex concepts using explanations that are free of confusing jargon * Gain the skills to join one of the many companies using functional Scala * Learn to think functionally with the help of all requisite resources and learn from scratch
 <h2>Github Repo</h2>https://github.com/PacktPublishing/Supercharge-Scala-Future---FP-Tower
 <h2>About the Author</h2><h3>Julien Truffaut</h3>Fp-Tower by Julien Truffaut offers online Scala courses that help in learning the practical side of functional programming, so you can improve your skills and your career. He is a programmer who specializes in functional programming and the Scala programming language. He has been conducting functional programming seminars and online courses with remarkable success for over seven years. He focuses on demystifying complex subjects through straightforward explanations free of jargon.

He is the author of Monocle, an optics library for functional Scala developers, which allows them to quickly transform and access deeply nested data structures. This is comparable to XPath or jq, except that it applies to all immutable data structures.
 <h2>Course Outline</h2><h4>1. Actions with Imperative Programming</h4><table width='100%'><tbody><tr><td style='padding: 15px;'>1. IntroductionThis video provides an overview of the course.</td></tr><tr><td style='padding: 15px;'>2. Console Exercise - TestingThis video demonstrates how to take users' input through the command line.</td></tr><tr><td style='padding: 15px;'>3. Console Exercises - Error HandlingThis video demonstrates how to take users' input through the command line, making it more user-friendly using the error handling feature.</td></tr><tr><td style='padding: 15px;'>4. EvaluationThis video demonstrates how code is executed in Scala and how to delay an execution to an appropriate time. You will start by reviewing the techniques to define a code expression in Scala.</td></tr><tr><td style='padding: 15px;'>5. Console Exercises - retry and onErrorThis video helps you learn the concept of retrying an operation with a single higher order function and reuse to refactor the code of readDataOfBirthRetry and readSubscribeToMailingListRetry.</td></tr><tr><td style='padding: 15px;'>6. Console Exercises - Code OrganizationThis video demonstrates and explains code organization.</td></tr></tbody></table> <h4>2. Build Your Own IO</h4><table width='100%'><tbody><tr><td style='padding: 15px;'>1. What Is an IO?This video provides an overview about IO (Input/Output).</td></tr><tr><td style='padding: 15px;'>2. IO CompositionThis video explains about IO composition.</td></tr><tr><td style='padding: 15px;'>3. For ComprehensionThis video demonstrates the comprehension part.</td></tr><tr><td style='padding: 15px;'>4. Error Handling with IOThis video talks about error handling with IO.</td></tr><tr><td style='padding: 15px;'>5. RefactoringThis video explains the concept of refactoring.</td></tr></tbody></table> <h4>3. Project: Search Flight Aggregator</h4><table width='100%'><tbody><tr><td style='padding: 15px;'>1. First ImplementationThis video provides an introduction and the project's implementation from scratch.</td></tr><tr><td style='padding: 15px;'>2. Traverse and SequenceThis video demonstrates the concepts of traverse and sequence in this project.</td></tr><tr><td style='padding: 15px;'>3. Concurrent IOThis video explains one of the toughest concepts, which is Concurrent IO.</td></tr><tr><td style='padding: 15px;'>4. Non-Blocking IOThis video explains about Non-Blocking IO.</td></tr></tbody></table> <h4>4. Conclusion</h4><table width='100%'><tbody><tr><td style='padding: 15px;'>1. Thank You and ConclusionThis video talks about the course conclusion and helps you with the next steps.</td></tr></tbody></table>

Java

Programming

This is an amazing course for anyone who wants to get started with functional programming with libraries such as cats-effect/ZIO and understand IO Monad in depth.

Learn about functional programming and effects from this most structured and well-thought-out course on Scala IOs.

Supercharge Scala Future | FP-Tower

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

Design & Technology Courses (DT)

Teaching & Training

DP-080T00 Querying Data with Microsoft Transact-SQL

In this course, we will process massive streams of real-time data using Spark Streaming and create Spark applications using the Scala programming language (v2.12). We will also get our hands-on with some real live Twitter data, simulated streams of Apache access logs, and even data used to train machine learning models.
 In this course, you will learn the basics of the Scala programming language; learn how Apache Spark operates on a cluster; set up discretized streams with Spark Streaming and transform them as data is received; analyze streaming data over sliding windows of time; maintain stateful information across streams of data; connect Spark Streaming with highly scalable sources of data, including Kafka, Flume, and Kinesis; dump streams of data in real-time to NoSQL databases such as Cassandra; run SQL queries on streamed data in real-time; train machine learning models in real-time with streaming data, and use them to make predictions that keep getting better over time; and also, package, deploy, and run self-contained Spark Streaming code to a real Hadoop cluster using Amazon Elastic MapReduce.

This course is very hands-on, filled with achievable activities and exercises to reinforce your learning. By the end of this course, you will be confidently creating Spark Streaming scripts in Scala and be prepared to tackle massive streams of data in a whole new way. You will be surprised at how easy Spark Streaming makes it!

All the codes and supporting files for this course are available at https://github.com/packtpublishing/streaming-big-data-with-spark-streaming-scala-and-spark-3-
 <h2>What You Will Learn</h2>Process large amounts of real-time data using the Spark Streaming module Create efficient Spark applications using the Scala programming language Integrate Spark Streaming with various data sources Integrate Spark Streaming with Spark SQL to query your data in real time Train machine learning models with streaming data, and use for real-time predictions Maintain stateful data across a continuous stream of input data
 <h2>Audience</h2>If you are a student who wants to learn how to use Apache Spark or a big data professional who wants to process large amounts of data on a real-time basis, this course is for you. Some basic programming and scripting experience is required to get the most out of the course.
 <h2>Approach</h2>This course is very hands-on, filled with achievable activities and exercises to reinforce your learning. In this course, we will cover some real live Twitter data, simulated streams of Apache access logs, and even data used to train machine learning models! You will write and run real Spark Streaming jobs right at home on your own PC.
 <h2>Key Features</h2>Process streams of real-time data from various sources with Spark Streaming * Query your streaming data in real-time using Spark SQL * A comprehensive tutorial with practical examples to help you develop real-time Spark applications
 <h2>Github Repo</h2>https://github.com/packtpublishing/streaming-big-data-with-spark-streaming-scala-and-spark-3-
 <h2>About the Author</h2><h3>Frank Kane</h3>Frank Kane has spent nine years at Amazon and IMDb, developing and managing the technology that automatically delivers product and movie recommendations to hundreds of millions of customers all the time. He holds 17 issued patents in the fields of distributed computing, data mining, and machine learning. In 2012, Frank left to start his own successful company, Sundog Software, which focuses on virtual reality environment technology and teaches others about big data analysis.
 <h2>Course Outline</h2><h4>1. Getting Started</h4>In this first section, we will introduce the course and set up the development environment for Spark and Scala. We will then create our first Spark Streaming application to display live Twitter feeds.<table width='100%'><tbody><tr><td style='padding: 15px;'>1. Introduction, and Getting Set UpA brief introduction to the course, and then we will get your development environment for Spark and Scala all set up on your desktop. A quick test application will confirm Spark is working on your system!</td></tr><tr><td style='padding: 15px;'>2. [Activity] Stream Live Tweets with Spark Streaming!Get set up with a Twitter developer account and run your first Spark Streaming application to listen to and print out live Tweets as they happen!</td></tr></tbody></table> <h4>2. A Crash Course in Scala</h4>In this section, we will take a deep dive into Scala. Even if you've never used Scala before, we will cover all of the syntax and structure that you will need to know in order to begin mining your data. We will run through flow control, functions, and data structures with numerous examples throughout so that you can see everything in action and make sure you're understanding it.<table width='100%'><tbody><tr><td style='padding: 15px;'>1. [Activity] Scala BasicsWe start our crash course in the Scala programming language by covering some basics of the language: types and variables, printing, and Boolean comparisons.</td></tr><tr><td style='padding: 15px;'>2. [Exercise] Flow Control in ScalaOur Scala crash course continues, illustrating various means of flow control in Scala. For loops, do/while loops, while loops and so on.</td></tr><tr><td style='padding: 15px;'>3. [Exercise] Functions in ScalaScala is a functional programming language, and so understanding how functions work and are treated in Scala is hugely important! This lecture covers the fundamentals, and lets you put it into practice.</td></tr><tr><td style='padding: 15px;'>4. [Exercise] Data Structures in ScalaWe wrap up our Scala crash course with commonly used data structures using in Spark with Scala. Tuples, lists, and maps.</td></tr></tbody></table> <h4>3. Spark Streaming Concepts</h4>In this section, we will introduce the core concepts of Spark and Spark Streaming. We will define and work with RDDs (Resilient Distributed Datasets) and show you examples of what they can do. RDDs are the key to understanding Spark, and therefore also Spark Streaming. This is also where we will dive deeper into Spark Streaming itself, understanding its inner workings and how the concept of windowing will enable you to aggregate and analyze data over time. Finally, we will take a look at reliability and fault tolerance with regards to Spark Streaming and a few ways in which you can maximize reliability.<table width='100%'><tbody><tr><td style='padding: 15px;'>1. Introduction to SparkBefore you can learn about Spark Streaming, you need to understand how Spark itself works at a high level! This video covers the why and how of Apache Spark, of which Spark Streaming is a component.</td></tr><tr><td style='padding: 15px;'>2. The Resilient Distributed Dataset (RDD)The fundamental object of Spark programming is the Resilient Distributed Dataset (RDD), and this is used not just in Spark but also within Spark Streaming scripts. This lecture explains what they are and what you can do with them.</td></tr><tr><td style='padding: 15px;'>3. [Activity] RDD's in Action: Simple Word Count ApplicationLet's walk through and actually run a simple Spark script that counts the number of occurrences of each word in a book.</td></tr><tr><td style='padding: 15px;'>4. Introduction to Spark StreamingWe finally have all the pr-requisite knowledge to start talking about Spark Streaming itself in more detail! We will cover how it works, what it's for, and its architecture.</td></tr><tr><td style='padding: 15px;'>5. [Activity] Revisiting the PrintTweets applicationNow that we know more, let's go revisit that first Spark Streaming application we ran in lecture two, and dive into how it really works.</td></tr><tr><td style='padding: 15px;'>6. Windowing: Aggregating data over longer time spansWindowing allows you to analyze streaming data over a sliding window of time, which lets you do much more than just transform streaming data and store it someplace else. We will cover the concepts of the batch, window, and slide intervals, and how they work together to let you aggregate streaming data over some period of time.</td></tr><tr><td style='padding: 15px;'>7. Fault Tolerance in Spark StreamingHow can Spark Streaming do so much work continuously in a reliable manner? We will uncover some of its tricks for reliability, as well as tips for configuring Spark Streaming to be as reliable as possible.</td></tr></tbody></table> <h4>4. Spark Streaming Examples with Twitter</h4>Now that we have seen the theory behind Spark Streaming, this section is dedicated to putting all of that into action. We will look at three practical examples of taking Twitter data and applying our new learning to it with file output, windowing, and live tracking, and analysis.<table width='100%'><tbody><tr><td style='padding: 15px;'>1. [Exercise] Saving Tweets to DiskWe will build on our "print tweets" example to actually store the incoming tweets to disk and illustrate how Spark Streaming can handle file output.</td></tr><tr><td style='padding: 15px;'>2. [Exercise] Tracking the Average Tweet LengthCompute the average length of a tweet, using windowing in Spark Streaming.</td></tr><tr><td style='padding: 15px;'>3. [Exercise] Tracking the Most Popular HashtagsThis is a fun one! We will track the most popular hashtags in Twitter over time and watch how they change in real time!</td></tr></tbody></table> <h4>5. Spark Streaming Examples with Clickstream / Apache Access Log Data</h4>This section will continue to look at some of the more advanced aspects of Spark Streaming, this time using Apache access logs to monitor website traffic in real time, showing the most accessed pages and flagging up and log errors as they occur. We will also use SparkSQL to query our data live. Finally, we will look at Spark 2's new structured streaming approach, and how we can use DataSets to streamline our analysis.<table width='100%'><tbody><tr><td style='padding: 15px;'>1. [Exercise] Tracking the Top URL's RequestedWe will simulate an incoming stream of Apache access logs and use Spark Streaming to keep track of the most-requested web pages in real time!</td></tr><tr><td style='padding: 15px;'>2. [Exercise] Alarming on Log ErrorsThis example will listen to an Apache access log stream and raise an alarm if too many errors are returned by the server in real time.</td></tr><tr><td style='padding: 15px;'>3. [Exercise] Integrating Spark Streaming with Spark SQLWe will integrate Spark Streaming with Spark SQL, allowing us to run SQL queries on data as it is streamed in! Again, we will use Apache logs as an example.</td></tr><tr><td style='padding: 15px;'>4. Introduction to Structured StreamingSpark 2.0 introduced experimental support for Structured Streaming, a new DataSet-based API for Spark Streaming that is bound to become increasingly important. Learn how it works.</td></tr><tr><td style='padding: 15px;'>5. [Activity] Analyzing Apache Log files with Structured StreamingAs an example, we will stream Apache access logs in from a directory and use Structured Streaming to count up status codes over a one-hour moving window.</td></tr></tbody></table> <h4>6. Integrating with Other Systems</h4>In this section, we will examine how Spark Streaming can be integrated with other popular data science systems. We will see how it can work with Apache Kafka to listen to and process messages in real time; how Apache Flume can work with Spark Streaming to process huge amounts of log data; using Amazon Kinesis with Spark Streaming to process live data on an AWS/EC2 cluster; and using Cassandra to store massive datasets and analyze them at speed. We will also cover how to write your own Data Receiver class in order to connect Spark Streaming to other proprietary systems.<table width='100%'><tbody><tr><td style='padding: 15px;'>1. Integrating with Apache KafkaApache Kafka is a popular and robust technology for publishing messages across a cluster on a large scale. We will show how to get Spark Streaming to listen to Kafka topics and process them in real time.</td></tr><tr><td style='padding: 15px;'>2. Integrating with Apache FlumeFlume is a popular technology for publishing log information at large scale, especially on a Hadoop cluster. We will illustrate how to set up both push-based and pull-based Flume configurations with Spark Streaming and discuss the tradeoffs of each.</td></tr><tr><td style='padding: 15px;'>3. Integrating with Amazon KinesisAmazon's Kinesis Streaming service is basically Kafka on AWS. If you're working with an AWS/EC2 cluster, you will want to know how to integrate Spark Streaming with Kinesis - and that's what this lecture covers.</td></tr><tr><td style='padding: 15px;'>4. [Activity] Writing Custom Data ReceiversWhat if you need to integrate Spark Streaming with some proprietary system that does not have an existing connection library? Well, you can always write your own Receiver class. This example shows you how and actually lets you build and run one.</td></tr><tr><td style='padding: 15px;'>5. Integrating with CassandraCassandra is a popular "NoSQL" database that can be used to provide fast access to massive data sets to real-time applications. Dumping data transformed by Spark Streaming into a Cassandra database can expose that data to your larger, real-time services. We will show you how, and actually run a simple example.</td></tr></tbody></table> <h4>7. Advanced Spark Streaming Examples</h4>In this section, we will run through some more advanced real-world examples of Spark Streaming. We will examine tracking stateful information, machine learning with K-Means clustering, and feeding data into linear regression models.<table width='100%'><tbody><tr><td style='padding: 15px;'>1. [Exercise] Stateful Information in Spark StreamsSpark has the ability to track arbitrary state across streams of data as they come in, such as web sessions, running totals and so on. This example shows you how it all works, and challenges you to track your own state using our example as a baseline.</td></tr><tr><td style='padding: 15px;'>2. [Activity] Streaming K-Means ClusteringSpark Streaming integrates with some of Spark's MLLib (Machine Learning Library) capabilities. This example creates a real-time K-Means clustering example; it does unsupervised machine learning that continually gets better as more training data feeds into it.</td></tr><tr><td style='padding: 15px;'>3. [Activity] Streaming Linear RegressionSpark Streaming can also feed data in real-time to linear regression models, that get better over time as more data is fed into them. This example shows linear regression in action with Spark Streaming.</td></tr></tbody></table> <h4>8. Spark Streaming in Production</h4>This section covers how to move your applications into a production environment, using the spark-submit command to process scripts from the command line. We will also look at packaging scripts and dependencies with SBT and running code on a real cluster with Amazon's Elastic MapReduce (EMR). Finally, we will troubleshoot some code. We will see what can go wrong, and how you can identify and debug issues and tune your Spark applications for peak performance.<table width='100%'><tbody><tr><td style='padding: 15px;'>1. [Activity] Packaging and Running Spark Code in ProductionYour production applications won't be run from within the Scala IDE; you will need to run them from a command line, and potentially on a cluster. The spark-submit command is used for this. We will show you how to package up your application and run it using spark-submit from a command prompt.</td></tr><tr><td style='padding: 15px;'>2. [Activity] Packaging Your Code with SBTIf your Spark Streaming application has external library dependencies that might not be already present on every machine in your cluster, the SBT tool can manage those dependencies for you, and package them into the JAR file you run with spark-submit. We will show you how it works with a real example.</td></tr><tr><td style='padding: 15px;'>3. Running on a Real Hadoop Cluster with EMRWe will run our simple word count example on a real cluster, using Amazon's Elastic MapReduce service! This just shows you what's involved in running a Spark Streaming job on a real cluster as opposed to your desktop; there are a few parameters to Spark-submit you need to worry about and getting your scripts and data in the right place is also something you need to deal with.</td></tr><tr><td style='padding: 15px;'>4. Troubleshooting and Tuning Spark JobsSpark jobs rarely run perfectly, if at all, on the first try - some tuning and debugging is usually required and arriving at the right scale of your cluster is also necessary. We will cover some performance tips, and how to troubleshoot what's going on with a Spark Streaming job running on a cluster.</td></tr></tbody></table> <h4>9. You Made It!</h4>This final section runs through some recommendations on where to learn more about Spark Streaming.<table width='100%'><tbody><tr><td style='padding: 15px;'>1. Learning MoreWant to learn more about Spark Streaming? Here are a few books and other resources I've found valuable.</td></tr></tbody></table>

Apache Spark

In this course, we will process massive streams of real-time data using Spark Streaming and create Spark applications using the Scala programming language (v2.12). We will also get our hands-on with some real live Twitter data, simulated streams of Apache access logs, and even data used to train machine learning models.

Streaming Big Data with Spark Streaming, Scala, and Spark 3!

<div id="course-pills-1">Duration1 Days6 CPD hoursThis course is intended forDevelopersOverviewThe basics of and motivation for using the functional programming paradigmFeatures of the Scala languageWorking with variables in ScalaUsing Scala collectionsControlling code flow in ScalaImporting and using Scala code librariesScala training course will teach students the key language concepts and programming techniques, essential for students to focus on the covered subjects without having to also learn a complex programming language at the same time.</div><div id="course-pills-2"><h4>Scala Basics</h4><ul><li>Scala Background Information</li><li>Key Scala Concepts</li><li>Programming in Scala</li></ul><h4>Variables</h4><ul><li>Scala Variables</li><li>Numerical</li><li>Boolean</li><li>String</li></ul><h4>Collections</h4><ul><li>Tuples</li><li>The Collections Hierarchy</li><li>Sets</li><li>Lists</li><li>Arrays</li><li>Maps</li><li>Common Conversions</li></ul><h4>Flow Control</h4><ul><li>Looping</li><li>Iterators</li><li>Functions</li><li>Passing Functions</li><li>Collection Iteration Methods</li><li>Pattern Matching</li></ul><h4>Libraries</h4><ul><li>Classes and Objects</li><li>Packages</li><li>Import</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans Just Enough Scala training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Just Enough Scala course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.</div>

Service Design Courses (SDC)

Just Enough Scala

Data Processing

This is a comprehensive and practical Apache Spark course. In this course, you will learn and master the art of framing data analysis problems as Spark problems through 20+ hands-on examples, and then scale them up to run on cloud computing services. Explore Spark 3, IntelliJ, Structured Streaming, and a stronger focus on the DataSet API.

Apache Spark with Scala - Hands-On with Big Data!

This course does not require any prior knowledge of Apache Spark or Hadoop. The author explains Spark architecture and fundamental concepts to help you come up to speed and grasp the content of this course.

The course will help you understand Spark programming and apply that knowledge to build data engineering solutions.
 Apache Spark is a lightning-fast unified analytics engine for big data and machine learning. Since its release, Apache Spark has seen rapid adoption by enterprises across a wide range of industries. Internet powerhouses such as Netflix, Yahoo, and eBay have deployed Spark at a massive scale. It has quickly become the largest open-source community in big data. So, mastering Apache Spark opens a wide range of professional opportunities.

This course starts with an introduction to Apache Spark where you see what Apache Spark is in brief. Then, you will be installing and using Apache Spark. After that, you will look at the Spark execution model and architecture in detail. Next, you will learn the Spark programming model and developer experience. Following that, you will look at the Spark Structured API foundation, and Spark data sources and sinks. Then, you will explore Spark Data frame and dataset transformations along with aggregations in Apache Spark. Finally, you will look at the Spark Data frame joins in detail.

By the end of this course, you will understand Spark programming and apply that knowledge to build data engineering solutions.

All the resource files are uploaded on the GitHub repository at https://github.com/PacktPublishing/Spark-Programming-in-Scala-for-Beginners-with-Apache-Spark-3
 <h2>What You Will Learn</h2>Learn Apache Spark and Spark architecture Look at data engineering and data processing in Spark Work with data sources and sinks Work with data frames, datasets, and Spark SQL Use IntelliJ IDEA for Spark development and debugging Understand unit testing, managing application logs, and cluster deployment
 <h2>Audience</h2>This course is designed for software engineers willing to develop a data engineering pipeline and application using Apache Spark. It is also for data architects and data engineers who are responsible for designing and building the organization's data-centric infrastructure. It will also be beneficial for the managers and architects who do not directly work with Spark implementation, and still, they work with the people who implement Apache Spark at the ground level. Before proceeding with the course, you will need basic knowledge of the Scala programming language.
 <h2>Approach</h2>This is a hands-on and well-balanced course with theoretical and practical content. The course is example-driven and follows a working session-like approach. The author will be taking a live coding approach and explaining all the concepts needed along the way. The section will have a summary video at the end to revise the learned concepts.
 <h2>Key Features</h2>A comprehensive course designed for the beginner-level for Spark programming in Scala * Deep dive into Spark 3 architecture and data engineering * Complete tested source code and examples used on Apache Spark 3.0.0 open-source distribution from the author's end
 <h2>Github Repo</h2>https://github.com/PacktPublishing/Spark-Programming-in-Scala-for-Beginners-with-Apache-Spark-3
 <h2>About the Author</h2><h3>Scholar Nest</h3>ScholarNest is a small team of people passionate about helping others learn and grow in their careers by bridging the gap between their existing and required skills.

Together, they have over 40+ years of experience in IT as a developer, architect, consultant, trainer, and mentor. They have worked with international software services organizations on various data-centric and Big Data projects.

It is a team of firm believers in lifelong continuous learning and skill development. To popularize the importance of continuous learning, they started publishing free training videos on their YouTube channel. They conceptualized the notion of continuous learning, creating a journal of our learning under the Learning Journal banner.
 <h2>Course Outline</h2><h4>1. Apache Spark Introduction</h4> <h4>2. Installing and Using Apache Spark</h4> <h4>3. Spark Execution Model and Architecture</h4> <h4>4. Spark Programming Model and Developer Experience</h4> <h4>5. Spark Structured API Foundation</h4> <h4>6. Spark Data Sources and Sinks</h4> <h4>7. Spark Dataframe and Dataset Transformations</h4> <h4>8. Aggregations in Apache Spark</h4> <h4>9. Spark Dataframe Joins</h4> <h4>10. Keep Learning</h4>

Hadoop

This course does not require any prior knowledge of Apache Spark or Hadoop. The author explains Spark architecture and fundamental concepts to help you come up to speed and grasp the content of this course.

The course will help you understand Spark programming and apply that knowledge to build data engineering solutions.

Spark Programming in Scala for Beginners with Apache Spark 3

<div id="course-pills-1">Duration4 Days24 CPD hoursThis course is intended forThis course is geared for experienced skilled Java developers, software developers, data scientists, machine learning experts or others who wish to transtion their coding skills to Scala, learning how to code in Scala and apply it in a practical way. This is not a basic class.OverviewWorking in a hands-on learning environment led by our expert instructor you'll: Get comfortable with Scala's core principles and unique features, helping you navigate the language confidently and boosting your programming skills. Discover the power of functional programming and learn techniques that will make your code more efficient,maintainable, and enjoyable to write. Become proficient in creating dynamic web applications using the Play Framework, and easily connect to databases with the user-friendly Slick library. Master concurrency programming with Akka, empowering you to build scalable and fault-tolerant applications that excel in performance. Enhance your testing skills using ScalaTest and ScalaCheck, ensuring the reliability and quality of your Scala applications, while having fun in the process. Explore the fascinating world of generative AI and GPT technologies, and learn how to integrate them into your projects,adding a touch of innovation and intelligence to your Scala solutions. If your team requires different topics, additional skills or a custom approach, our team will collaborate with you to adjust the course to focus on your specific learning objectives and goals.Discover the power of Scala programming in our comprehensive, hands-on technical training course designed specifically for experienced object-oriented (OO) developers. Scala is a versatile programming language that combines the best of both OO and functional programming paradigms, making it ideal for a wide range of projects, from web applications to big data processing and machine learning. By mastering Scala, you'll be able to develop more efficient, scalable, and maintainable applications. Fast Track to Scala Programming for OO / Java Developers is a four day hands-on course covers the core principles of Scala, functional programming, web application development, database connectivity, concurrency programming, testing, and interoperability between Scala and Java. Additionally, you'll explore cutting-edge generative AI and GPT technologies, learning how to integrate them into your Scala applications for intelligent suggestions or automation. Throughout the course you?ll explore the latest tools and best practices in the Scala ecosystem, gaining valuable knowledge and experience that can be directly applied to your day-to-day work. With 50% of the course content dedicated to hands-on labs, you'll gain practical experience applying the concepts you've learned across various projects, such as building functional web applications, connecting to databases, designing modular components, and implementing concurrency. Upon completing the course, you'll have a solid understanding of the language and its features, empowering you to confidently apply your new skills in data science and machine learning projects. You'll exit well-prepared to create efficient, scalable, and maintainable Scala applications, regardless of the complexity of your projects.</div><div id="course-pills-2"><h4>Introduction to Scala</h4><ul><li>Scala features and benefits</li><li>Comparing Scala with Java and other OO languages</li><li>Installing Scala and setting up the development environment</li></ul><h4>Object-Oriented Programming in Scala</h4><ul><li>Classes and objects</li><li>Traits, mixins, and inheritance</li><li>Companion objects and factories</li><li>Encapsulation and polymorphism</li></ul><h4>Functional Programming Basics</h4><ul><li>Pure functions and referential transparency</li><li>Higher-order functions and currying</li><li>Immutability and persistent data structures</li><li>Pattern matching and recursion</li></ul><h4>Having Fun with Functional Data Structures</h4><ul><li>Lists, sets, and maps in Scala</li><li>Folding and reducing operations</li><li>Stream processing and lazy evaluation For-comprehensions</li></ul><h4>Building Web Applications in Functional Style</h4><ul><li>Introduction to Play Framework</li><li>Functional web routing and request handling</li><li>JSON handling with Play-JSON</li><li>Middleware and functional composition</li></ul><h4>Connecting to a Database</h4><ul><li>Introduction to Slick library</li><li>Database configuration and setup</li><li>Querying and updating with Slick</li><li>Transactions and error handling</li></ul><h4>Building Scalable and Extensible Components </h4><ul><li>Modular architecture and design patterns Dependency injection with MacWire Type classes and type-level programming Implicit parameters and conversions</li></ul><h4>Concurrency Programming &amp; Akka</h4><ul><li>Introduction to Akka framework and Actor model</li><li>Actor systems and message passing</li><li>Futures and Promises</li><li>Supervision and fault tolerance</li><li></li></ul><h4>Building Confidence with Testing</h4><ul><li>Introduction to ScalaTest and ScalaCheck</li><li>Unit testing and property-based testing</li><li>Test-driven development in Scala</li><li>Mocking and integration testing</li><li></li></ul><h4>Interoperability between Scala and Java</h4><ul><li>Calling Java code from Scala</li><li>Using Java libraries in Scala projects</li><li>Converting Java collections to Scala collections</li><li>Writing Scala code that can be called from Java</li></ul><h4>Using Generative AI and GPT</h4><ul><li>Technologies in Scala Programming</li><li>Overview of GPT and generative AI</li><li>Integrating GPT with Scala applications</li><li>Use cases and practical examples</li></ul></div>

Programming Fundamentals

Programming Languages

Software Development

Fast Track to Scala Programming for OO / Java Developers (TTSCL2104)

<div id="course-pills-1">Duration4 Days24 CPD hoursThis course is intended forThis course is geared for experienced skilled Java developers, software developers, data scientists, machine learning experts or others who wish to transtion their coding skills to Scala, learning how to code in Scala and apply it in a practical way. This is not a basic class.OverviewWorking in a hands-on learning environment led by our expert instructor you'll: Get comfortable with Scala's core principles and unique features, helping you navigate the language confidently and boosting your programming skills. Discover the power of functional programming and learn techniques that will make your code more efficient, maintainable, and enjoyable to write. Become proficient in creating dynamic web applications using the Play Framework, and easily connect to databases with the user-friendly Slick library. Master concurrency programming with Akka, empowering you to build scalable and fault-tolerant applications that excel in performance. Enhance your testing skills using ScalaTest and ScalaCheck, ensuring the reliability and quality of your Scala applications, while having fun in the process. Explore the fascinating world of generative AI and GPT technologies, and learn how to integrate them into your projects, adding a touch of innovation and intelligence to your Scala solutions. If your team requires different topics, additional skills or a custom approach, our team will collaborate with you to adjust the course to focus on your specific learning objectives and goals.Discover the power of Scala programming in our comprehensive, hands-on technical training course designed specifically for experienced object-oriented (OO) developers. Scala is a versatile programming language that combines the best of both OO and functional programming paradigms, making it ideal for a wide range of projects, from web applications to big data processing and machine learning. By mastering Scala, you'll be able to develop more efficient, scalable, and maintainable applications. Fast Track to Scala Programming for OO / Java Developers is a four day hands-on course covers the core principles of Scala, functional programming, web application development, database connectivity, concurrency programming, testing, and interoperability between Scala and Java. Additionally, you'll explore cutting-edge generative AI and GPT technologies, learning how to integrate them into your Scala applications for intelligent suggestions or automation. Throughout the course you?ll explore the latest tools and best practices in the Scala ecosystem, gaining valuable knowledge and experience that can be directly applied to your day-to-day work. With 50% of the course content dedicated to hands-on labs, you'll gain practical experience applying the concepts you've learned across various projects, such as building functional web applications, connecting to databases, designing modular components, and implementing concurrency. Upon completing the course, you'll have a solid understanding of the language and its features, empowering you to confidently apply your new skills in data science and machine learning projects. You'll exit well-prepared to create efficient, scalable, and maintainable Scala applications, regardless of the complexity of your projects.</div><div id="course-pills-2"><h4>Introduction to Scala </h4><ul><li>Scala features and benefits </li><li>Comparing Scala with Java and other OO languages </li><li>Installing Scala and setting up the development environment </li></ul><h4>Object-Oriented Programming in Scala</h4><ul><li>Classes and objects </li><li>Traits, mixins, and inheritance </li><li>Companion objects and factories </li><li>Encapsulation and polymorphism </li></ul><h4>Functional Programming Basics</h4><ul><li>Pure functions and referential transparency </li><li>Higher-order functions and currying </li><li>Immutability and persistent data structures </li><li>Pattern matching and recursion </li></ul><h4>Having Fun with Functional Data Structures </h4><ul><li>Lists, sets, and maps in Scala </li><li>Folding and reducing operations </li><li>Stream processing and lazy evaluation </li><li>For-comprehensions </li></ul><h4>Building Web Applications in Functional Style</h4><ul><li>Introduction to Play Framework </li><li>Functional web routing and request handling </li><li>JSON handling with Play-JSON Middleware and functional composition </li></ul><h4>Connecting to a Database</h4><ul><li>Introduction to Slick library </li><li>Database configuration and setup </li><li>Querying and updating with Slick </li><li>Transactions and error handling</li></ul><h4>Building Scalable and Extensible Components</h4><ul><li>Modular architecture and design patterns </li><li>Dependency injection with MacWire </li><li>Type classes and type-level programming </li><li>Implicit parameters and conversions</li></ul><h4>Concurrency Programming &amp; Akka </h4><ul><li>Introduction to Akka framework and Actor model </li><li>Actor systems and message passing </li><li>Futures and Promises </li><li>Supervision and fault tolerance </li></ul><h4>Building Confidence with Testing </h4><ul><li>Introduction to ScalaTest and ScalaCheck </li><li>Unit testing and property-based testing </li><li>Test-driven development in Scala </li><li>Mocking and integration testing</li></ul><h4>Interoperability between Scala and Java</h4><ul><li>Calling Java code from Scala </li><li>Using Java libraries in Scala projects </li><li>Converting Java collections to Scala collections </li><li>Writing Scala code that can be called from Java </li></ul><h4>Using Generative AI and GPT Technologies in Scala Programming</h4><ul><li>Overview of GPT and generative AI </li><li>Integrating GPT with Scala applications </li><li>Use cases and practical examples</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4> Nexus Humans Fast Track to Scala Programming Essentials for OO / Java Developers (TTSCL2104) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Fast Track to Scala Programming Essentials for OO / Java Developers (TTSCL2104) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.</div>

376 Scala courses

Bridging the Gap with Agile

By IIL Europe Ltd

Microsoft Azure Storage

By Course Gate

Microsoft SQL Server Development for Everyone!

By Studyhub UK

Master Spring boot 3.0 and MongoDB

By Studyhub UK

AutoCAD Plugin Development Using VB.NET and Windows Forms

By Studyhub UK

AWS Solutions Architect & SysOps Administrator

By Course Gate

Learn MySQL from Scratch for Data Science and Analytics

By Studyhub UK

SQL for Data Science, Data Analytics and Data Visualization

By Studyhub UK

SEO Masterclass

By Course Gate

AWS Certified Solutions Architect Associate Preparation

By Studyhub UK

Search By Location