Name: React JS and Python Django Full Stack Master Course
Price: 18.99 GBP
Availability: InStock

<strong>In this course, you will learn C# programming for desktop applications. These lessons assume no prior knowledge of programming or the C# language and will have you up and running in no time. By the end of this course, you will have enough knowledge to build a functional Windows Forms application, connected to a Microsoft SQL Server database, with all your program code and changes being tracked on GitHub.</strong>
        <p>C#, the most versatile programming language in the .NET framework, allows developers to build Windows, web, and mobile applications. It has strong community support, and more than five million developers prefer C#. This course will teach you how to build a Windows Forms application using C#.

The course starts by highlighting the learning objectives and explaining the installation process of Visual Studio 2022. Next, you will learn the basic and advanced concepts of C# console programming needed for application development. You will also understand how to use WinForms, ADO.Net, and Language Integrated Query (LINQ) to create WinForms applications. Moving along, you will learn to build data-driven GUI applications using Windows Forms and manage databases with SQL server management studio.

Next, you will understand the concept of user management and learn how to use utility classes to keep the code clean. Later, you will learn to develop multi-document interface (MDI) applications and learn the techniques to add a Visual Studio project to source control.

By the end of this course, you will have moved around in Visual Studio and examined logic and syntax errors so much that it will be second nature for you when working in the .NET environment. This will put your newly learned skills to practical use and impress your boss and co-workers.

The code files and all related resources are uploaded on GitHub at: https://github.com/PacktPublishing/C-Console-and-Windows-Forms-Development-with-Entity-Framework</p>
        <h2>What You Will Learn</h2><p>Find out how to create desktop applications with C#<br>Connect Windows Forms applications to a database<br>Discover how to use C# operators for math and logic tasks<br>Handle database changes and manage create, read, update, and delete (CRUD) operations<br>Write Language Integrated Query (LINQ) to retrieve data from databases<br>Connect to and upload a project to GitHub</p>
        <h2>Audience</h2><p>This beginner-friendly course is for anyone wanting to learn LINQ and wanting to learn .NET programming with C#. This course will also be beneficial for those who want to learn desktop development with Windows Forms from scratch.<br><br>No prior knowledge of C# or .NET is required.</p>
        <h2>Approach</h2><p>This course is very beginner-friendly and chock full of development tips. This huge course offers premium content, smartly broken up to highlight a set of related activities based on each module. We will also look at troubleshooting and debugging errors as we go along; implementing best practices; writing efficient logic, and understanding why developers do things the way they do. Your knowledge will grow, step by step, throughout the course and you will be challenged to be the best you can be.</p>
        <h2>Key Features</h2><p>Become familiar with C#, Language Integrated Query (LINQ), ADO.NET, and SQL server concepts * Learn how to apply the principles of object-oriented programming in C# * Get ready to build and run amazing Windows Forms applications</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/C-Console-and-Windows-Forms-Development-with-Entity-Framework</p>
        <h2>About the Author</h2><h3>Trevoir Williams</h3><p>Trevoir Williams is a software engineer and part-time lecturer. With a master's degree in computer science, he has spent over a decade teaching web, software, and database development courses. He also has extensive industry experience in web application development, Azure Cloud system, and server administration.

He enjoys teaching IT and development courses and hopes to impart knowledge of the latest developments in industry standards and techniques to his students.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><br><h4>2. Development Environment Setup</h4><p></p><br><h4>3. C# Console Programming - Basic Control Structures</h4><p></p><br><h4>4. C# Console Programming - More Advanced Concepts</h4><p></p><br><h4>5. Winforms Applications - The Basics</h4><p></p><br><h4>6. Multi Document Interface (MDI) and More Database Operations</h4><p></p><br><h4>7. Managing Database Changes and CRUD Operations</h4><p></p><br><h4>8. User Management and Login Functionality</h4><p></p><br><h4>9. Add To Source Control</h4><p></p><br><h4>10. BONUS Discounts</h4><p></p>

Packt

GitHub

Programming

SQL Server

In this course, you will learn C# programming for desktop applications. These lessons assume no prior knowledge of programming or the C# language and will have you up and running in no time. By the end of this course, you will have enough knowledge to build a functional Windows Forms application, connected to a Microsoft SQL Server database, with all your program code and changes being tracked on GitHub.

C# Console and Windows Forms Development with Entity Framework

General Admission

<div id="course-pills-1">Duration<p>2 Days</p><p>12 CPD hours</p>This course is intended for<p>This in an Introductory and beyond level course is geared for experienced Java developers seeking to be proficient in Apache Kafka.  Attendees should be experienced developers who are comfortable with Java, and have reasonable experience working with databases.</p>Overview<p>Working in a hands-on learning environment, students will explore<br />Overview of Streaming technologies<br />Kafka concepts and architecture<br />Programming using Kafka API<br />Kafka Streams<br />Monitoring Kafka<br />Tuning / Troubleshooting Kafka</p><p>Apache Kafka is a real-time data pipeline processor. It high-scalability, fault tolerance, execution speed, and fluid integrations are some of the key hallmarks that make it an integral part of many Enterprise Data architectures.  In this lab intensive two day course, students will learn how to use Kafka to build streaming solutions.</p></div><div id="course-pills-2"><h4>Introduction to Streaming Systems</h4><ul><li>Fast data</li><li>Streaming architecture</li><li>Lambda architecture</li><li>Message queues</li><li>Streaming processors</li></ul><h4>Introduction to Kafka</h4><ul><li>Architecture</li><li>Comparing Kafka with other queue systems (JMS / MQ)</li><li>Kaka concepts : Messages, Topics, Partitions, Brokers, Producers, commit logs</li><li>Kafka &amp; Zookeeper</li><li>Producing messages</li><li>Consuming messages (Consumers, Consumer Groups)</li><li>Message retention</li><li>Scaling Kafka</li></ul><h4>Programming With Kafka</h4><ul><li>Configuration parameters</li><li>Producer API (Sending messages to Kafka)</li><li>Consumer API (consuming messages from Kafka)</li><li>Commits , Offsets, Seeking</li><li>Schema with Avro</li></ul><h4>Kafka Streams</h4><ul><li>Streams overview and architecture</li><li>Streams use cases and comparison with other platforms</li><li>Learning Kafka Streaming concepts (KStream, KTable, KStore)</li><li>KStreaming operations (transformations, filters, joins, aggregations)</li></ul><h4>Administering Kafka</h4><ul><li>Hardware / Software requirements</li><li>Deploying Kafka</li><li>Configuration of brokers / topics / partitions / producers / consumers</li><li>Security: How secure Kafka cluster, and secure client communications (SASL, Kerberos)</li><li>Monitoring : monitoring tools</li><li>Capacity Planning : estimating usage and demand</li><li>Trouble shooting : failure scenarios and recovery</li></ul><h4>Monitoring and Instrumenting Kafka</h4><ul><li>Monitoring Kafka</li><li>Instrumenting with Metrics library</li><li>Instrument Kafka applications and monitor their performance</li></ul></div>

Nexus Human

Apache Kafka

Kafka

Working with Apache Kafka (for Developers) (TTDS6760)

<div>
	<h3><b>Description: </b></h3>
<p><span>Programming is the language used by computer programmers to define relationship, semantics, and grammar to be able to make the computer and other digital machines work. In web development, it is used to allow new interactive applications and software to have a control through accessing different system resources. Learn the basics of Programming and Database by enrolling in this course. </span></p>
<h3><b>Who is the course for?</b></h3>
<ul>
<li><span>Beginner to advanced level users can want to acquire or upgrade their programming skills</span></li>
<li><span>People who have an interest in learning about programming  and database</span></li>
</ul>
<h3><b>Entry Requirement:</b></h3>
<ul>
<li><span>This course is available to all learners, of all academic backgrounds. </span></li>
<li><span>Learners should be aged 16 or over to undertake the qualification.</span></li>
<li><span>Good understanding of English language, numeracy and ICT are required to attend this course.</span></li>
</ul>
<h3><b>Assessment:  </b></h3>
<ul>
<li><span>At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.</span></li>
<li><span>Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. </span></li>
</ul>
<h3><b>Certification: </b></h3>
<ul>
<li><span>After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. </span></li>
<li><span>PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.</span></li>
</ul>
<h3><b>Why choose us?</b></h3>
<ul>
<li><span>Affordable, engaging &amp; high-quality e-learning study materials;</span></li>
<li><span>Tutorial videos/materials from the industry leading experts;</span></li>
<li><span>Study in a user-friendly, advanced online learning platform;</span></li>
<li><span>Efficient exam systems for the assessment and instant result; </span></li>
<li><span>The UK &amp; internationally recognised accredited qualification;</span></li>
<li><span>Access to course content on mobile, tablet or desktop from anywhere anytime;</span></li>
<li><span>The benefit of career advancement opportunities;</span></li>
<li><span>24/7 student support via email.</span></li>
</ul>
<h3><b>Career Path:</b></h3>
<p><span>The Programming and Database Course will be very helpful to have especially for these careers:</span></p>
<ul>
<li><span>Computer Maintenance Staff</span></li>
<li><span>IT Department Manager</span></li>
<li><span>IT Specialists</span></li>
<li><span>Computer Engineer</span></li>
<li><span>Computer Specialist</span></li>
<li><span>Programmers.</span></li>
</ul>
		</div><table width="100%">				<tbody><tr>
					<td colspan="4">Beginners Programming</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction To Programming</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How To Write A Program</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The List Of Programming Languages</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Selecting The Right Compiler</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Is An Interpreter</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>How To Write A Program With An Editor</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The Functions Of A Debugger</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Build Strong Components For Programming</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Profiling And Optimizing Your Program</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Installing Your Program</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>BASIC Programming Language</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Getting Started with BASIC Programming Language</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>BASIC Overview of BASIC Components</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>BASIC Special Variables</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>BASIC Probability Functions</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Filtering the Data Set or Splitting the Data Set</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DATA Blocks</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DELETE Statement</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>FORNEXT Statement</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>IF. . . THEN Statement</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Wrapping Up</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Database Basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What is a Database</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Definition of Terms</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Database Users and Languages</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Components of a Database System</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Basic Set Concepts</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Relations as a Database</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Relational Database Operators</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Database keys</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Mock Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Mock Exam- Programming and Database Course</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Final Exam</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Final Exam- Programming and Database Course</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Certificate and Transcript</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Order Your Certificates and Transcripts</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
				</tbody></table>

John Academy

Computing Skills

Programming Fundamentals

Database Programming

Programming Languages

Computer Programming

Trainers Course

Programming and Database Course

<strong>Learn Azure Serverless Computing in a weekend with Azure Functions. This course covers core concepts such as serverless functions, event-driven applications, Azure Service Bus, database interaction, email sending, monitoring, transaction management, integrations, and more! Gain valuable and in-demand skills in Microsoft Azure's Serverless Computing.</strong>
        <p>Serverless functions are a single-purpose, programmatic feature of serverless computing (cloud computing execution model). It helps execute code written in the language of your choice with Azure Functions, an event-driven computing experience. Scale on-demand and pay only for the time your code is executed. Available as a managed service in Azure and Azure Stack, the open-source functions runtime also works on multiple destinations, including Kubernetes, Azure IoT Edge, on-premises, and even in other clouds.

You will start with learning Azure Serverless Functions from scratch in a stepwise manner. Then look at the basic concepts of serverless computing, event-driven application, Azure Functions, and Azure Service Bus. After that, you will look at Azure Serverless Functions' interaction with the database, Azure Service Bus, and queue bindings in Azure Serverless Functions.

You will explore how to send emails and messages using Azure Functions. Additionally, you will delve into version control using GitHub Actions Workflow and learn about Azure Functions monitoring. Finally, you will have the opportunity to develop a transaction management system application with Azure Functions.

By the end of this course, you will have learned Azure Serverless Computing concepts with Azure Functions.

All the resource files are added to the GitHub repository at: https://github.com/PacktPublishing/Learn-Azure-Serverless-Functions-in-a-Weekend</p>
        
        <h2>Audience</h2><p>This course is designed for cloud consultants who work on platform automation requirements or those who want to experience the power of Azure Serverless Computing.<br><br>Azure IAAS and PAAS administrators, Azure/application developers, and cloud computing enthusiasts will also gain a lot from this course.<br><br>To get the most out of this course, you should have some basic understanding of the command line (Win CMD/Unix Shell) that will help you quickly grasp the concepts, and Visual Studio Code installed on the laptop.</p>
        <h2>Approach</h2><p>This is a concise, easy-to-understand, to-the-point, and well-balanced course on Azure Serverless Functions. At the start of every video, you will look at a brief introduction to what you will be learning/implementing/executing that will help you get a clear idea and set expectations from each video. You will be building and delivering a transaction process system application in the last section.</p>
        <h2>Key Features</h2><p>A beginner-level course on Azure Functions and allied operations with the latest tools from scratch * Comes bundled with all the resource files and PPTs * A well-structured, stepwise, and complete course on Azure Serverless Functions and computing</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Learn-Azure-Serverless-Functions-in-a-Weekend</p>
        <h2>About the Author</h2><h3>Vijay Saini</h3><p>Vijay Saini is an accomplished IT professional who brings a wealth of expertise to the table. With a diversified background across multiple domains, Vijay has proven himself a valuable asset to his current role as a leading cloud service provider. His strong focus on automation has resulted in significant cost savings for the business, making him a valuable asset to the team.

Vijay is highly knowledgeable in the areas of Microsoft Azure, cloud technologies, DBMS, and Python, and is a specialist in automation using PowerShell. With a passion for teaching, Vijay has leveraged e-learning platforms to share his expertise with others, helping them develop their own skills and knowledge.</p>
        <h2>Course Outline</h2><h4>1. Introduction to the Course</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Course Structure</p><p style='margin: 0'>This video helps you with the structure of the course and demonstrates the basic takeaways from this course.</p></td></tr><tr><td style='padding: 15px;'><p>2. Introduction to Serverless Computing</p><p style='margin: 0'>This video provides an introduction to serverless computing.</p></td></tr><tr><td style='padding: 15px;'><p>3. Event-Driven Architecture</p><p style='margin: 0'>This video explains the event-driven architecture from scratch.</p></td></tr><tr><td style='padding: 15px;'><p>4. What Is Azure Functions</p><p style='margin: 0'>This video explains Azure Functions in detail.</p></td></tr></tbody></table><br><h4>2. Creating Azure Function in Azure Portal</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Deploying Functions App in Azure Portal</p><p style='margin: 0'>This video helps you with deploying Functions app in Azure Portal.</p></td></tr><tr><td style='padding: 15px;'><p>2. Creating First Function in Azure Portal</p><p style='margin: 0'>This video helps you with creating your first function in Azure Portal.</p></td></tr></tbody></table><br><h4>3. Azure Functions Local Development Environment</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Configuring the Local Development Environment</p><p style='margin: 0'>This video demonstrated configuring the local development environment.</p></td></tr><tr><td style='padding: 15px;'><p>2. Creating Functions App and Understanding the File Structure</p><p style='margin: 0'>This video demonstrates defining and indexing in data structures.</p></td></tr><tr><td style='padding: 15px;'><p>3. Developing Azure Functions in Local Functions App</p><p style='margin: 0'>This video helps you with developing Azure Functions in the local functions app.</p></td></tr></tbody></table><br><h4>4. Develop Azure Functions with VS Code</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Develop Azure Functions with VS Code</p><p style='margin: 0'>This video demonstrates how to develop Azure Functions with Visual Studio Code.</p></td></tr></tbody></table><br><h4>5. Developing Azure Functions Applications with Azure SQL Database</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Environment Setup - Creating a Serverless Azure SQL Database</p><p style='margin: 0'>This video helps you with the environment setup. You will be creating a serverless Azure SQL database.</p></td></tr><tr><td style='padding: 15px;'><p>2. Developing Azure Functions API to Get Online Course Details - Part 1</p><p style='margin: 0'>This video will help you develop an Azure Functions API to connect to a SQL database and retrieve the course information from the online courses' SQL table.</p></td></tr><tr><td style='padding: 15px;'><p>3. Developing Azure Functions API to Get Online Course Details - Part 2</p><p style='margin: 0'>In the last video, you connected the function to the database, but it is not returning anything on the browser page. In this video, you will return the database to the browser page. So, basically, you will publish the formatted output in the browser and in the logs.</p></td></tr><tr><td style='padding: 15px;'><p>4. Azure Functions to Collect Feedback and Store in Database</p><p style='margin: 0'>In this video, you will see how Azure Functions is used to collect feedback and store it in the database.</p></td></tr><tr><td style='padding: 15px;'><p>5. Azure Functions to Perform Schedule Database Cleanup</p><p style='margin: 0'>In this video, you will study how Azure Functions is used to perform schedule database cleanup.</p></td></tr></tbody></table><br><h4>6. Azure Service Bus</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction to Azure Service Bus</p><p style='margin: 0'>This video provides an introduction to Azure Service Bus.</p></td></tr><tr><td style='padding: 15px;'><p>2. Deploy Azure Service Bus</p><p style='margin: 0'>This video helps deploy Azure Service Bus.</p></td></tr></tbody></table><br><h4>7. Azure Functions Integrations</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Azure Functions to Take Input from HTTP and Write Blobs</p><p style='margin: 0'>This video will help you develop Azure Functions to take input from HTTP and write blobs. You will be learning Azure Functions integrations with the help of bindings.</p></td></tr><tr><td style='padding: 15px;'><p>2. Azure Functions to Process Blob Storage</p><p style='margin: 0'>This video will help you develop Azure Functions to process blob storage. You will parse the text from an HTTP request and save it as a blob file in an Azure storage account container. You will process each blob in a blob container and save the output into another container.</p></td></tr><tr><td style='padding: 15px;'><p>3. Azure Functions to Add Message into Storage Queue</p><p style='margin: 0'>In this video, you will develop Azure Functions to add messages to the storage queue. The Azure Queue Storage is a service for storing a large number of messages.</p></td></tr><tr><td style='padding: 15px;'><p>4. Azure Functions to Add Message to Service Bus Topic</p><p style='margin: 0'>This video helps you develop Azure Functions to add messages to the service bus topic. Here, we will process a storage queue, read the messages, process them, and add them to Azure Service Bus Topic.</p></td></tr></tbody></table><br><h4>8. Azure Functions Integrations - Enhancing the Function Code</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Importing/Shared Code for Azure Functions</p><p style='margin: 0'>This video will help in importing/shared code for Azure Functions.</p></td></tr><tr><td style='padding: 15px;'><p>2. Binding Expression and Function Monitoring</p><p style='margin: 0'>This video explains binding expression and function monitoring in detail.</p></td></tr></tbody></table><br><h4>9. Developing a Transaction Processing System</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Transaction Management System - Requirement and Architecture</p><p style='margin: 0'>This video explains the transaction management system. You will look at the problem statement, do a requirement analysis, understand the application architecture, and the ways to implement it (steps to resolve the business problem of transaction management system).</p></td></tr><tr><td style='padding: 15px;'><p>2. HTTP Function to Queue Message</p><p style='margin: 0'>This video demonstrates how to develop an HTTP function to queue messages. Here, you will develop an HTTP trigger function, keeping in mind that it will be used by the payment gateway system to submit the payment status. It should take this information and then queue it inside Aure Service Bus as a message.</p></td></tr><tr><td style='padding: 15px;'><p>3. Azure Service Bus Trigger Function to Add Records to Database</p><p style='margin: 0'>This video demonstrates how to develop the Azure Service Bus trigger function to add records to the database. Here, you will move on to develop a second function that gets triggered upon queueing a message in our Azure Service Bus. It will take the information out of the message and record it in the Techsckool database and send the message alert to the client.</p></td></tr><tr><td style='padding: 15px;'><p>4. Send Email with Azure Functions</p><p style='margin: 0'>This video demonstrates how to send emails with Azure Functions. Here, you will continue using the previously developed function but this time, you are going to add the functionality of sending out an email notification to the client.</p></td></tr></tbody></table>

Python

Learn Azure Serverless Computing in a weekend with Azure Functions. This course covers core concepts such as serverless functions, event-driven applications, Azure Service Bus, database interaction, email sending, monitoring, transaction management, integrations, and more! Gain valuable and in-demand skills in Microsoft Azure's Serverless Computing.

Learn Azure Serverless Functions in a Weekend

<strong>This course uses Azure PowerShell to automate tasks and manage Azure Cloud services with ease. The course is intended to help people learn Azure concepts quickly and give enough practice exercises to get them started with their cloud journey with a specific focus on Microsoft Azure and task automation.</strong>
        <p>Azure PowerShell (PowerShell + Az Module) is a set of cmdlets to manage Azure resources directly from the PowerShell command line. Azure PowerShell is designed to make it easy to learn and get started with managing Azure resources and provides powerful features for automation. It is used to perform powerful, common tasks in Microsoft Azure through an extension of Windows PowerShell. Without logging in, users can enter a single cmdlet from the command line to create a new virtual machine.

This course is designed to take the system administrators to an advanced level and make them more efficient at their work. You will find ways to automate your daily work using the advantages of Windows PowerShell. It covers a wider list of topics such as how to deploy a virtual machine in Azure Cloud, connecting local PowerShell to Azure, deploying new Azure resources using PowerShell, Azure PowerShell to query and format output, how to administer Azure storage using Azure PowerShell, application code development, code enhancement, and publishing of the application. The last section focuses on PowerShell basics.

By the end of this course, you will be able to administer and manage Azure resources and automate Azure tasks using PowerShell easily. Administrators will find it easier to create, test, deploy, and manage Azure cloud platform services.

The code files and all other resources are uploaded on GitHub at https://github.com/PacktPublishing/Learning-Azure-Process-Automation-using-PowerShell</p>
        <h2>What You Will Learn</h2><p>Install Azure PowerShell in local machine and connect it to Azure<br>Deploy virtual machine using Azure PowerShell<br>Use PowerShell to perform system administration tasks<br>Create resource groups using Azure PowerShell<br>Azure PowerShell query output and format output<br>Azure PowerShell to automate stop, start, and resize of virtual machines</p>
        <h2>Audience</h2><p>This course can be taken by absolute beginners including candidates with non-technical backgrounds, such as those involved in selling or purchasing and somehow involved with cloud-based solutions/services, as well as those with a technical background who have a need to validate their foundation-level knowledge around cloud services and Azure. System administrators using cloud services in their day-to-day life will benefit the most.<br><br>Basic beginner-level knowledge of Azure cloud and awareness of basic PowerShell commands are highly recommended for this course but not mandatory.</p>
        <h2>Approach</h2><p>The course has hands-on practical exercises and real-world scenarios to help you master Azure. The important concepts of Azure PowerShell will be demonstrated in the most engaging way to keep you engrossed throughout.<br><br>This is a complete guide to sail you through your journey as a system administrator who is using cloud services from scratch.</p>
        <h2>Key Features</h2><p>Demonstration of the importance of Azure PowerShell and real-world scenarios to help you master Azure * Learn how to automate your boring and repetitive work using simple PowerShell tiny scripts * Engaging explanation of Azure concepts and regular test-your-knowledge exercises within lectures</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Learning-Azure-Process-Automation-using-PowerShell</p>
        <h2>About the Author</h2><h3>Vijay Saini</h3><p>Vijay Saini is an accomplished IT professional who brings a wealth of expertise to the table. With a diversified background across multiple domains, Vijay has proven himself a valuable asset to his current role as a leading cloud service provider. His strong focus on automation has resulted in significant cost savings for the business, making him a valuable asset to the team.

Vijay is highly knowledgeable in the areas of Microsoft Azure, cloud technologies, DBMS, and Python, and is a specialist in automation using PowerShell. With a passion for teaching, Vijay has leveraged e-learning platforms to share his expertise with others, helping them develop their own skills and knowledge.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><br><h4>2. Environment Setup for Azure PowerShell</h4><p></p><br><h4>3. Deploying New Azure Resources using PowerShell</h4><p></p><br><h4>4. Azure PowerShell to Query & Format Output</h4><p></p><br><h4>5. Learning Azure PowerShell ways to administer Azure Storage</h4><p></p><br><h4>6. Microsoft Azure Process Automation</h4><p></p><br><h4>7. My Cloud Bucket - A Node.js based web storage application</h4><p></p><br><h4>8. Appendix</h4><p></p>

Azure PowerShell

Cloud Computing

Microsoft Azure

This course uses Azure PowerShell to automate tasks and manage Azure Cloud services with ease. The course is intended to help people learn Azure concepts quickly and give enough practice exercises to get them started with their cloud journey with a specific focus on Microsoft Azure and task automation.

Learning Azure Process Automation Using PowerShell

Java

Sitecore

Apache Spark

Data Analysis

This course primarily focuses on explaining the concepts of Python and PySpark. It will help you enhance your data analysis skills using structured Spark DataFrames APIs.

Apache Spark 3 for Data Engineering and Analytics with Python

<div>
					<div>
								<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
							</div>
				</div>
			<p><span>This </span><b>Oracle 11g PL/SQL Part 2</b><span> course will be very advantageous for you to learn about developing database server-side PL/SQL program units within an Oracle database. This course covers a variety of topics which include understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. In addition to that, you'll take the support of advanced programming techniques such as cursor variables and cursor expressions, which broadly discussed in the course. This course is ideal to prepare yourself for the Oracle certification exams (OCP).</span></p>
<p><span>Upon successful completion of this course, you'll stand out from your competition while you're chasing your dream job!</span></p>
<h3><strong>What Will I Learn?</strong></h3>
<ul>
<li><span>Prepare your environment</span></li>
<li>Introducing Database Program Units</li>
<li>Creating and Maintaining Stored Procedures &amp; Functions</li>
<li><span>Creating and Maintaining Packages</span></li>
<li><span>Advanced Cursor Techniques</span></li>
<li><span>Using System-Supplied Packages</span></li>
<li><span>Creating and Maintaining Database Triggers</span></li>
<li><span>Implementing System Event Triggers</span></li>
</ul>
<h3><strong>Requirements</strong></h3>
<div>
<ul>
<li>Familiarity with database and programming principles</li>
</ul>
<h3><strong>Who is the target audience?</strong></h3>
<ul>
<li>Application designers and developers</li>
<li>Database administrators</li>
<li>Business users and non-technical senior end users</li>
</ul>
</div><table>				<tbody><tr>
					<td colspan="4"> Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Install Oracle XE</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL Developer Installation</td>
					<td> </td>
					<td><span><i></i> 00:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Workstation Setup</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Database Program Units</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introducing the Database Program Unit</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with Stored Procedures and Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating Stored Procedures and Functions</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding the Parameter Specification</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Executing Procedures and Functions</td>
					<td> </td>
					<td><span><i></i> 00:26:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Calling Functions from within SQL</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Handling Compilation Errors</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Maintaining Stored Procedures and Functions</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Recompiling and Dropping Programs</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Data Dictionary Storage</td>
					<td> </td>
					<td><span><i></i> 00:25:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Managing Dependencies</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Tracking Dependencies</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Dependency Tracking Utility</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Creating and Maintaining Packages</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Is a Package?</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating a Package</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Package Definition Information</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Advanced Programming Techniques</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Persistent Global Objects</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Including Initialization Logic</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Object Oriented Support within Packages</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Package Maintenance</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Advanced Cursor Techniques</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Learning to Use Cursor Variables</td>
					<td> </td>
					<td><span><i></i> 00:24:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Advanced Cursor Techniques Weak Cursor Definitions</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>REFCURSOR Cursor Definition</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Cursor Expression</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Using System Supplied Packages</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the DBMS OUTPUT() Package</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the UTL FILE() Package</td>
					<td> </td>
					<td><span><i></i> 00:30:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Creating Database Triggers</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding the Database Trigger</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Statement-Level Triggers</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row-Level Triggers</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row Level Trigger Example 1</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row Level Trigger Example 2</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Row Level Trigger Example 3</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with the INSTEAD OF Trigger</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Triggers within an Application</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Trigger Maintenance</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the CALL Statement</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Trigger Maintenance Tasks</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Work with Multiple Triggers for a Single Table</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Handling Mutating Table Issues</td>
					<td> </td>
					<td><span><i></i> 00:22:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Compound Trigger</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with System Event Triggers</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Is a System Event Trigger</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Defining Scope</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Identifying Available System Events</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Conclusion</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Course Certification</td>
				</tr>
				</tbody></table>

iStudy UK

Oracle SQL

Oracle

Oracle Fusion HCM

Oracle 1Z0-819

Oracle Database

Oracle 11g PL/SQL Part 2

<div>
					<div>
								<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
							</div>
				</div>
			<p><span>The </span><b>Oracle 11g PL/SQL Part 1</b><span> course will focus on giving you the best knowledge of coding and designing PL/SQL and SQL scripts.</span></p>
<p><span>Initially, you'll learn how to start programming in Oracle PL/SQL. You'll understand the history of PL/SQL, installing Oracle Express Edition, connecting to Database, Relational Database, Oracle SQL in an easy-to-grasp method. This course includes mostly practical examples with explanations which makes it more valuable. </span></p>
<p><span>Upon successful completion of this course, you can have the pleasure to code in PL/SQL which further help to boost your career.</span></p>
<p><span>From beginners to expert learner can benefit from this course. So enrol today and see what else is in the </span><b>Oracle 11g PL/SQL Part 1</b><span> course.</span></p>
<h3><strong>What Will I Learn?</strong></h3>
<ul>
<li><span>Prepare your environment</span></li>
<li>Work with Oracle database tools</li>
<li>Understand and work with language features</li>
<li><span>Work with the DECLARE clause</span></li>
<li><span>Work with the BEGIN clause</span></li>
<li><span>Work with the EXCEPTION clause</span></li>
<li><span>Use explicit cursors</span></li>
<li><span>Understand and use nested blocks</span></li>
<li><span>Understand the difference between nested blocks and subprograms</span></li>
</ul>
<h3><strong>Requirements</strong></h3>
<div>
<ul>
<li>Familiarity with database and programming principles</li>
</ul>
<h3><strong>Who is the target audience?</strong></h3>
<ul>
<li>Application designers and developers</li>
<li>Database administrators</li>
<li>Business users and non-technical senior end users</li>
</ul>
</div><table>				<tbody><tr>
					<td colspan="4"> Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Preparing Your Environment</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Course Setup</td>
					<td> </td>
					<td><span><i></i> 00:37:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Working with Oracle Database Tools</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Selecting the Appropriate Database Tool</td>
					<td> </td>
					<td><span><i></i> 00:31:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Language Features</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding PL/SQL</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>PL/SQL Blocks</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with SQL Plus</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td colspan="4">The DECLARE Clause</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>DECLARE Clause Objects</td>
					<td> </td>
					<td><span><i></i> 00:16:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>PL/SQL Available Data Types</td>
					<td> </td>
					<td><span><i></i> 00:17:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Declaring Simple Data Types and Assignments</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Declaring Complex Data Types and Assignments</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Declaring Complex RowTypes and Assignments</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Declaring Complex Tables</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Declaring Complex Records</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating and Declaring User-Defined Types</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td colspan="4">The BEGIN Clause</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Can Be Included in the BEGIN Clause</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with CHAR and VARCHAR2 Variables</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Handling String Literals</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Numeric Variables</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Date Variables</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Assigning and Using Boolean Variables</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Comparison Operators</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using SQL Functions</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>SQL DML within PL/SQL</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using SELECT</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Exceptions and Embedded SQL</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Sequences</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Logic Control and Branching</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using GOTO</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with LOOPS</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating and Using the Indefinite Loop</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating and Using the Conditional Loop</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using Nested Loops</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the If-Then-Else</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the CASE Statement</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">The EXCEPTION Clause</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What Are the Types of Exceptions</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Trapping Exceptions</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Identify Exception Details</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating User-Defined Exceptions</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using SQLCODE and SQLERRM Objects</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understand the Implicit Cursor</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating User-Defined Events</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Explicit Cursors</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding the Concept and Purpose of Explicit Cursors</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Learn about Cursor Attributes</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Using the Continue Statement</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Working with Updateable Cursors</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Creating and Using Cursor Parameters</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>FOR...LOOP Cursors</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Nested Blocks</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Understanding Nested Blocks</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Difference between Global vs Local Objects and Exceptions</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Declared Subprograms</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Subprograms: How They Differ from Nested Blocks</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Conclusion</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Course Certification </td>
				</tr>
				</tbody></table>

Oracle 11g PL/SQL Part 1

<strong>Are you looking to leverage the capabilities of React to build interactive elements for a website? Then this is the course for you. This course is carefully structured to make the process of learning the latest version of React both practical and easy. Build practical projects such as Feedback app, GitHub Finder, House Marketplace, and Full-Stack MERN support ticket system while learning. An intermediate-level knowledge of JavaScript is required.</strong>
        <p>The course starts with React fundamentals including components, props, hooks, state, and so on. Then learn about React hooks such as useState, useEffect, useContext, useReducer, and useRef. Next, you will create custom hooks and see React Router v6.

Then, you will learn how to handle the global state with context, reducers, and hooks.

You will see Firebase 9 authentication, queries, storage, and deploy React apps to Vercel and Netlify. Basic animation with Framer Motion, implementing Leaflet maps and Swiper sliders, and working on full-stack MERN (MongoDB, Express, React, Node.js) are some of the highlights of this course.

All these concepts are explained practically with the help of four different apps/projects. If you have not used React before, the Feedback App project will help you learn the fundamentals of React. The GitHub Finder project further explores the management of the app-level state by introducing actions and reducers. You will work with third-party APIs.

The House Marketplace app will introduce you to Firebase and prepare you to learn a lot about its capabilities as a platform for user authentication, cloud file storage, and a dedicated NoSQL database. Finally, the final project (full-stack MERN support ticket system) is a full-fledged full-stack app that uses Redux and Redux Toolkit.

By the end of the course, you will have built four projects with all the concepts taught. You will also have gained enough confidence and skillset to kickstart your journey with React.

All the resource files are added to the GitHub repository at: https://github.com/packtpublishing/react-front-to-back</p>
        <h2>What You Will Learn</h2><p>Learn React fundamentals including components, props, hooks, state<br>Learn React hooks and how to create custom hooks<br>Handle global state with context, reducers, and hooks<br>Learn how to use context and reducers to manage global state<br>Look at Firebase 9 authentication and basic animation with Framer Motion<br>Deploy React apps to Vercel and Netlify</p>
        <h2>Audience</h2><p>This course is for anyone who wants to learn React from scratch and become a React developer. Individuals who want to sharpen their skills as a React developer or who are looking to further their skills as a front-end developer will also benefit from this course.<br><br>You should have intermediate-level knowledge of JavaScript before learning React or any framework as some advanced JavaScript concepts are being used here.</p>
        <h2>Approach</h2><p>This course is highly practical, and its hands-on approach adds a layer of comprehension with four projects! This course explores many of the components of the React framework and comes bundled with a full stack MERN project. Coding through these projects will offer you a lot of opportunities for repetition and a deep understanding of the flow of React fundamentals.</p>
        <h2>Key Features</h2><p>Learn modern React by building 4 projects and suitable for beginners and intermediate React developers * Build a House Marketplace with React and Firebase 9 * Build a full-stack MERN support ticket system with Redux Toolkit</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/react-front-to-back</p>
        <h2>About the Author</h2><h3>Brad Traversy</h3><p>Brad Traversy has been programming for around 12 years and teaching for almost 5 years. He is the owner of Traversy Media, which is a successful web development YouTube channel and specializes in everything from HTML5 to front-end frameworks such as Angular as well as server-side technologies such as Node.js, PHP, and Python. Brad has mastered explaining overly complex topics in a simple manner that is understandable. Invest in your knowledge by watching Brad's courses.</p>
        <h2>Course Outline</h2><h4>1. Introduction to the Course</h4><p></p><br><h4>2. React Basics and JSX (JavaScript XML)</h4><p></p><br><h4>3. Components, Props, and State</h4><p></p><br><h4>4. Forms, Validation, and Simple Animation</h4><p></p><br><h4>5. Creating Routes and Links</h4><p></p><br><h4>6. Context API, useContext Hook, and Deployment</h4><p></p><br><h4>7. APIs and HTTP Requests</h4><p></p><br><h4>8. GitHub Finder Project Start</h4><p></p><br><h4>9. Working with the GitHub API</h4><p></p><br><h4>10. User Profile and Alerts</h4><p></p><br><h4>11. Refactoring Context and Actions</h4><p></p><br><h4>12. More Advanced React Hooks</h4><p></p><br><h4>13. House Marketplace Project Start</h4><p></p><br><h4>14. Firebase Authentication and Profile</h4><p></p><br><h4>15. Get and Create Listings</h4><p></p><br><h4>16. Single Listings, Map, Slider, and Edit</h4><p></p><br><h4>17. MERN Project Start, API, and Backend Authentication</h4><p></p><br><h4>18. Front-End Authentication</h4><p></p><br><h4>19. Tickets Functionality</h4><p></p><br><h4>20. Notes Functionality and Deploy</h4><p></p>

JavaScript

Node.js

Postman

Web Development

MongoDB

Are you looking to leverage the capabilities of React to build interactive elements for a website? Then this is the course for you. This course is carefully structured to make the process of learning the latest version of React both practical and easy. Build practical projects such as Feedback app, GitHub Finder, House Marketplace, and Full-Stack MERN support ticket system while learning. An intermediate-level knowledge of JavaScript is required.

React Front to Back 2022 [V]

<strong>In this course, you will learn full-stack web development with React JS for the frontend and Python Django for the backend. You will learn and explore various databases such as Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, and SQLite.</strong>
        <p>The demand for a full-stack web developer is the highest compared to any technology professional. They are paid exceptionally well both in companies and as freelancers. This is because full-stack web developers have a diverse set of skills; they are good at database development, backend development, and frontend development.

In this course, you will learn full-stack web development with React JS for the frontend and Python Django for the backend. We will build the same backend project with different databases such as Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, and SQLite.

This course is divided into the following sections:

- React JS, Python Django, and MongoDB
- React JS, Python Django, and MySQL
- React JS, Python Django, and PostgreSQL
- React JS, Python Django, and Microsoft SQL Server
- React JS, Python Django, and SQLite

By the end of the course, you will learn the various databases and will create a backend project.

All resources and code files are placed here: https://github.com/PacktPublishing/React-JS-and-Python-Django-Full-Stack-Master-Course</p>
        <h2>What You Will Learn</h2><p>Learn all about full-stack web development<br>Learn all about React JS front end development<br>Learn how to build REST APIs<br>Learn to add routing to the application<br>Learn how to install Visual Studio Code and Postman<br>Learn about serializers and API methods</p>
        <h2>Audience</h2><p>This course is for Python developers, backend developers, frontend developers, Angular and React developers. A basic understanding of HTML, CSS, JavaScript, and Python programming is needed.</p>
        <h2>Approach</h2><p>The course follows a hands-on approach. We will build the same backend project with different databases such as Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, and SQLite.</p>
        <h2>Key Features</h2><p>Learn how to upload an image and save it on the backend server * Explore about adding a bootstrap table with custom sorting and filtering features * Learn about modal pop-up window with drop-down and date picker</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/React-JS-and-Python-Django-Full-Stack-Master-Course</p>
        <h2>About the Author</h2><h3>Vinay Kumar R</h3><p>Vinay Kumar is currently working as a full-stack web developer. He has experience in the development of web applications and business intelligence. Vinay has worked on technologies such as .NET, Angular, React JS, Vue JS, SSIS, and Power BI. He creates programming tutorial videos in his free time.</p>
        <h2>Course Outline</h2><h4>1. React JS, Django and Mongo DB</h4><p></p><br><h4>2. React JS, Django and MySQL</h4><p></p><br><h4>3. React JS, Django and Microsoft SQL</h4><p></p><br><h4>4. React JS, Django and PostgreSQL</h4><p></p><br><h4>5. React JS, Django and SQLIite</h4><p></p>

React JS

In this course, you will learn full-stack web development with React JS for the frontend and Python Django for the backend. You will learn and explore various databases such as Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, and SQLite.

React JS and Python Django Full Stack Master Course

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

Microsoft SQL

Data Skills

55366 Querying Data with Transact-SQL

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

Microsoft SQL Server

AWS Certified Database

Database Administration

55315: Introduction to SQL Databases

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

Powershell

Microsoft AZ-104

Power Automate

Microsoft AZ-303

Microsoft Power Automate

AZ-040T00 Automating Administration with Powershell

<div>
					<div>
								<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
							</div>
				</div>
			<p><span>This </span><b>Introduction to Database Design</b><span> course teaches the basis of relational database design and explains how to make a good database design and become an expert on it.</span></p>
<p><span>Designing a database is quite simple, but you've to understand a few rules before jump onto it. It is essential to know about these rules, otherwise, you will tend to make errors. If you find it hard to deal with database, scripts and all the technical parts, then this comprehensive course is just for you.</span></p>
<p><span>The course includes the followings:</span></p>
<ul>
<li><span>Creating database and database users</span></li>
<li><span>Introduction of data, different data types, foreign key constraints, and other relevant concepts used to create the best database</span></li>
<li><span>Importing database tables</span></li>
<li><span>Explore all types of relationships</span></li>
<li><span>Designing all types of relationships within a database.</span></li>
<li><span>Learn three common forms of database normalisation</span></li>
<li><span>Application of database for the business purpose</span></li>
<li><span>And much more...</span></li>
</ul>
<h3><strong>What Will I Learn?</strong></h3>
<ul>
<li><span>What is a database</span></li>
<li>Understand different types of databases</li>
<li>Understand normalization</li>
<li><span>Assign relationships</span></li>
<li><span>Eliminate repetition</span></li>
<li><span>Relate tables with IDs</span></li>
<li><span>Design rules</span></li>
</ul>
<h3><strong>Requirements</strong></h3>
<div>
<ul>
<li>Basic Microsoft Windows training or equivalent experience</li>
</ul>
<h3><strong>Who is the target audience?</strong></h3>
<ul>
<li>Students just getting started with designing databases and those who have been designing databases but looking for tips on more effective design</li>
</ul>
</div><table>				<tbody><tr>
					<td colspan="4"> Introduction</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Introduction</td>
					<td><span>FREE</span> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Database Basics</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Overview</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What is a Database?</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Different Types of Databases</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>The Process of Database Design</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Normalizing</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Overview - Normalizing</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>What is Normalization?</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Basic Steps to Normalization</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>A. Brainstorm</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>B. Organize</td>
					<td> </td>
					<td><span><i></i> 00:03:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>C. Eliminate Repetition</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>D. Assign Relationships</td>
					<td> </td>
					<td><span><i></i> 00:01:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>D1. One to One Relationship</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>D2. One to Many Relationship</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>D3. Many to Many Relationship</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Relating Tables with IDs</td>
					<td> </td>
					<td><span><i></i> 00:02:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Examples of Bad Design</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Examples of Good Design</td>
					<td> </td>
					<td><span><i></i> 00:06:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Design Rules</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Conclusion</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Conclusion</td>
					<td> </td>
					<td><span><i></i> 00:04:00</span></td>
				</tr>
								<tr>
					<td colspan="4">Course Certification</td>
				</tr>
				</tbody></table>

Database Design & Development

Database Design

Data Architecture

Database Management

Introduction to Database Design

<div id="course-pills-1">Duration<p>3 Days</p><p>18 CPD hours</p>This course is intended for<p>This course is intended for IT professionals who are experienced in general Windows Server and Windows Client administration. Students should have a foundational knowledge of Windows PowerShell, which they can obtain by taking course 10961C: Automating Administration with Windows PowerShell. In addition, this course provides scripting guidance for Microsoft Azure administrators and developers who support development environments and deployment processes.</p>Overview<p>After completing this course, you will be able to:<br />Create advanced functions.<br />Use Microsoft .NET Framework and REST API in Windows PowerShell.<br />Handle script errors.<br />Use XML, JSON, and custom formatted data.<br />Manage Microsoft Azure resources<br />Analyze and debug scripts<br />Understand Windows PowerShell workflow.</p><p>This course teaches students how to automate administrative tasks using PowerShell. Students will learn crucial scripting skills such as creating advanced functions, writing controller scripts, and handling script errors. Candidates will learn how to use PowerShell when working with Microsoft Azure, SQL Server, Active Directory, IIS, Windows PowerShell Workflow, .NET resources, the REST API and XML, CSV &amp; JSON formatted data files.This course replaces retired Microsoft course 10962.</p></div><div id="course-pills-2"><h4>Module 1: Creating advanced functions</h4><ul><li>Lesson 1: Converting a command into an advanced function</li><li>Lesson 2: Creating a script module</li><li>Lesson 3: Defining parameter attributes and input validation</li><li>Lesson 4: Writing functions that accept pipeline input</li><li>Lesson 5: Producing complex pipeline output</li><li>Lesson 6: Using comment-based Help</li><li>Lesson 7: Using Whatif and Confirm parameters</li></ul><h4>Module 2: Using Microsoft .NET Framework and REST API in Windows PowerShell</h4><ul><li>Lesson 1: Using .NET Framework in PowerShell</li><li>Lesson 2: Using REST API in PowerShell</li></ul><h4>Module 3: Writing controller scripts</h4><ul><li>Lesson 1: Understanding controller scripts</li><li>Lesson 2: Writing controller scripts with a user interface</li><li>Lesson 3: Writing controller scripts that create reports</li></ul><h4>Module 4: Handling script errors</h4><ul><li>Lesson 1: Understanding error handling</li><li>Lesson 2: Handling errors in a script</li></ul><h4>Module 5: Using XML, JSON, and custom-formatted data</h4><ul><li>Lesson 1: Working with XML formatted data</li><li>Lesson 2: Working with JSON formatted data</li><li>Lesson 3: Working with custom-formatted data</li></ul><h4>Module 6: Enhancing server management with Desired State Configuration and Just Enough Administration</h4><ul><li>Lesson 1: Implementing Desired State Configuration</li><li>Lesson 2: Implementing Just Enough Administration</li></ul><h4>Module 7: Analyzing and debugging scripts</h4><ul><li>Lesson 1: Debugging in Windows PowerShell</li><li>Lesson 2: Analyzing and debugging an existing script</li></ul><h4>Module 8: Understanding Windows PowerShell Workflow</h4><ul><li>Lesson 1: Understanding Windows PowerShell Workflows</li><li>Lesson 2: Running Windows PowerShell Workflows</li></ul></div>

Microsoft Certification

Microsoft AZ-900

Microsoft AZ-700

55318: Advanced Automated Administration with Windows PowerShell

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					<div><p>The comprehensive SQL Server 101 : Microsoft SQL Server for Absolute Beginners has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the SQL Server 101 : Microsoft SQL Server for Absolute Beginners today, and learn from the very best the industry has to offer!</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div><p>This best selling SQL Server 101 : Microsoft SQL Server for Absolute Beginners has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth SQL Server 101 : Microsoft SQL Server for Absolute Beginners is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The SQL Server 101 : Microsoft SQL Server for Absolute Beginners is CPD-accredited, so you can be confident you're completing a quality training course which will boost your CV and enhance your career potential. The SQL Server 101 : Microsoft SQL Server for Absolute Beginners is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p><p>After successfully completing the SQL Server 101 : Microsoft SQL Server for Absolute Beginners, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the SQL Server 101 : Microsoft SQL Server for Absolute Beginners will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the SQL Server 101 : Microsoft SQL Server for Absolute Beginners to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>

Course Cloud

SQL Server 101 : Microsoft SQL Server for Absolute Beginners

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					<div><p>The comprehensive Advanced SAS Programming With MacrosSQL has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Advanced SAS Programming With MacrosSQL today, and learn from the very best the industry has to offer!</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div><p>This best selling Advanced SAS Programming With MacrosSQL has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Advanced SAS Programming With MacrosSQL is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The Advanced SAS Programming With MacrosSQL is CPD-accredited, so you can be confident you're completing a quality training course  will boost your CV and enhance your career potential. The Advanced SAS Programming With MacrosSQL is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p><p>After successfully completing the Advanced SAS Programming With MacrosSQL, you will be awarded a certificate of completion  as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Advanced SAS Programming With MacrosSQL will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the Advanced SAS Programming With MacrosSQL to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>

Advanced SAS Programming With MacrosSQL

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><b>Course Overview</b></h2>		</div>
				</div>
				<div>
				<div>
					<div><p><span>Become a PHP &amp; MySQL pro by learning all the web development features for creating websites.</span></p><p><span>The <strong>PHP &amp; MySQL Web Development &amp; OOP Coding</strong> course covers everything you need to know to master PHP programming and gain valuable industry skills. It will take you through the fundamentals of PHP and MySQL, starting from the very basics for complete beginners. </span></p><p><span>Through this in-depth training course, you will familiarise with all the features of MySQL, and learn best practices for cross platform development, taught by an expert in the field. If you are looking to kickstart a career in programming or computer science, then this course will equip you with up-to-date skills that will ensure you gain a competitive edge in the job market.</span></p></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This best selling <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p><p>After successfully completing the<strong> PHP &amp; MySQL Web Development &amp; OOP Coding</strong>, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
					</div>
		</div>
								</div>
					</div>

PHP & MySQL Web Development & OOP Coding

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><b>Course Overview</b></h2>		</div>
				</div>
				<div>
				<div>
					<div><p><span>Master MySQL by learning all the web development skills for creating complex, high-quality web databases.</span></p><p><span>The <strong>Basic MySQL Online Course</strong> covers the complete fundamentals of MySQL for relational database management, e-commerce and logging applications. It is designed to equip learners with in-demand industry skills, taking them through the basics such as installation, for those who are new to the field. </span></p><p><span>This practical training course will explore all the core features of MySQL, as well as best practices for cross platform development, taught by an experienced professional in the field. If you are looking to establish a career in programming or computer science, then this in-depth training will ensure you gain a competitive edge in the job market.</span></p></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This best selling <strong>Basic MySQL Online Course </strong>has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth <strong>Basic MySQL Online Course </strong>is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The <strong>Basic MySQL Online Course </strong>is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The <strong>Basic MySQL Online Course </strong>is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p><p>After successfully completing the<strong> Basic MySQL Online Course</strong>, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the <strong>Basic MySQL Online Course </strong>will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the <strong>Basic MySQL Online Course </strong>to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
					</div>
		</div>
								</div>
					</div>

Basic MySQL Online Course

<p><strong>The easy way to store your data and retrieve it when you need it!</strong></p> <p>Database training is vital for success if you want to work in the technology business. Companies are looking for experts who can use databases effectively and have a solid understanding of them. Our course can assist you in developing the skills and information required to flourish in the computer business.</p> <p>This well-designed course can teach you the fundamentals of database design, including creating and managing databases, manipulating data, and developing data-driven applications. You'll gain knowledge of several database types, including relational, object-oriented, distributed, and NoSQL. Along with measures to protect data security, you will learn about database performance and optimisation.</p> <p>Our course is a fantastic method to get started in the profession or obtain expertise for a present position. Many businesses are looking for candidates with good database knowledge and effective usage skills. You may differentiate yourself from the competition by enrolling in a course and gaining the skills and knowledge you need.</p> <p>Along with this Database Course, you will get <strong>11 premium courses, an original hardcopy</strong>, <strong>11 PDF Certificates (Main Course + Additional Courses) </strong>Student ID card as gifts.</p> <p>So, don't wait up. Enrol now!</p> <p><strong>This Database Bundle Consists of the following Premium courses: </strong> </p> <p><strong>Courses are included in this Database Bundle?</strong></p> <ul> <li><strong> Course 01:</strong> Microsoft SQL Server Development for Everyone</li><li><strong> Course 02:</strong> SQL Programming Masterclass</li><li><strong> Course 03: </strong>SQL NoSQL Big Data and Hadoop</li><li><strong> Course 04: </strong>Python Programming for Everybody</li><li><strong> Course 05: </strong>Data Science with Python</li><li><strong> Course 06:</strong> JavaScript Foundations for Everyone</li><li><strong> Course 07: </strong>C# Programming - Beginner to Advanced</li><li><strong> Course 08: </strong>R Programming for Data Science</li><li><strong> Course 09: </strong>Three.js &amp; WebGL 3D Programming Course for Beginners</li><li><strong> Course 10: </strong>Basic Google Data Studio</li><li><strong> Course 11: </strong>Data Analytics with Tableau</li></ul> <p><strong>Learning Outcomes</strong></p> <ul> <li>Have a fundamental understanding of database design, implementation, and upkeep.</li><li>Be able to query databases and learn the SQL language.</li><li>To preserve data, use security procedures and backup procedures.</li><li>Examine database performance and note any enhancements.</li><li>Be familiar with approaches for database normalisation and optimisation.</li><li>Create web services and database applications.</li><li>Use DBMS software for managing and storing data.</li><li>Identify technologies and trends in databases.</li></ul><p>These 11 courses cover programming and data science topics such as SQL, Python, JavaScript, C#, R, Three.js, WebGL, Google Data Studio, and Tableau. They teach skills in database management, data analysis, manipulation, visualization, and reporting for beginners to advanced learners. The bundle incorporates skills to shed some light on your way and boost your career. Hence, you can strengthen your Database Expertise and essential knowledge, which will assist you in reaching your goal.</p> <p><strong>Certificate:</strong></p> <ul> <li><strong>PDF Certificate: Free (Previously it was £6*11 = £66)</strong></li></ul> <ul> <li><strong>Hard Copy Certificate: Free (For The Title Course: Previously it was £10)</strong></li></ul><h2>
        
        <div>CPD</div>
    </h2>

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

                        <div id="who_is_this_course_for">
                             <ul> <li>Individuals interested in learning programming and data science skills</li><li>Professionals seeking to enhance their knowledge and skill set</li><li>Entrepreneurs or business owners wanting to understand and manage data effectively</li><li>Students or graduates in computer science, data science, or related fields</li><li>Anyone looking to start a career in programming or data science</li><li>Data analysts, data scientists, or data engineers looking to expand their skill set</li></ul> 
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                             <p>There is no time limit for completing this course; it can be studied in your own time at your own pace.</p> 
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                             <p>People tend to pursue their careers in the following professions in the database sector</p> <ul> <li>Database Administrator</li><li>Database Developer</li><li>Database Architect</li><li>Database Analyst</li><li>Database Designer</li></ul> <p>The salary range for a Database Professional in the UK is typically between £25,000 and £50,000 per annum.</p> 
                        </div><h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>Certificate of completion</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div> <p>You will get the Hard Copy certificate for the title course (<strong>Microsoft SQL Server Development for Everyone</strong>) absolutely Free! Other Hard Copy certificates are available for £10 each. </p> <p><strong>Please Note:</strong> The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.</p> </div>
        <h4>Certificate of completion</h4>
        <p>
            Digital certificate -
            Included
        </p>

                        </div>

241 Database Design & Development courses delivered Online

C# Console and Windows Forms Development with Entity Framework

By Packt

Working with Apache Kafka (for Developers) (TTDS6760)

By Nexus Human

Programming and Database Course

By John Academy

Learn Azure Serverless Functions in a Weekend

By Packt

Learning Azure Process Automation Using PowerShell

By Packt

Apache Spark 3 for Data Engineering and Analytics with Python

By Packt

Oracle 11g PL/SQL Part 2

By iStudy UK

Oracle 11g PL/SQL Part 1

By iStudy UK

React Front to Back 2022 [V]

By Packt

React JS and Python Django Full Stack Master Course

By Packt