2398 Courses in Cardiff delivered Online

Limited Time Offer On | 11-in-1 Bundle | CPD QS Certified | 110 CPD Points | Gifts: Hardcopy + PDF Certificates + Transcript + SID - Worth 180 | Customer Support | Lifetime Access | Enrol Today

This comprehensive .NET Core course will provide a strong foundation in clean architecture, SOLID principles, and help implement the CQRS and Mediator patterns. You will also learn to build and consume APIs in a Blazor WebAssembly application. The course content is fully compatible with .NET 6 and .NET 7, ensuring you are up-to-date with the latest version.

Has the Computer System Validation Engineer left and you’ve been handed their responsibilities? Do the thoughts of your next audit fill you with dread? CSV can be frustrating but this program will show you how to manage electronic data in a regulated manufacturing/laboratory/clinical environment using the GAMP framework and ensure compliance with FDA’s 21 CFR Part 11, EU Annex 11 or other regulatory guidelines.

Sharpen your HTML, CSS, and JavaScript by working on a large variety of projects. In this course, we'll be working through a project a day using vanilla JavaScript. Over the next 50 days, you'll have 50 small, unique, DOM-oriented projects under your belt.

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

Life Coaching | Online Course Do you feel the spark to guide other people? Do you need more skills to help people meet their goals confidently? Step into life coaching with our dynamic 'Life Coaching Online Course.' With an average life coach salary ranging from £30,000 to £60,000 per year in the UK, this field offers personal fulfilment and financial reward. Our Life Coaching Online Course course goes beyond the basics. This course talks about psychology and strategies for effective coaching. You'll learn how to utilise neuro-linguistic programming (NLP) to unlock your potential and that of your clients. Besides, you will discover the secrets to managing fears and embracing change, a highly sought-after skill in today's fast-paced world. Life coaches are typically the masters of emotional intelligence. Therefore, this course sheds light on emotional intelligence and communication techniques.  After completing the Life Coaching Online Course, you'll be able to understand and influence others more effectively, enhancing both your personal and professional relationships. Furthermore, this Life Coaching Online Course will assist you in mastering the art of body language and communication techniques and refine your listening skills to understand clients' moods, thoughts, and intentions. Whether you're looking to start a new career as a life coach, enhance your existing coaching skills, or improve your life and those around you, this course is the perfect starting point.  Enrol in the Life Coaching Online Course course and become part of the ever-expanding community of life coaches making a significant impact in the UK and beyond. Learning Outcomes Acquire a comprehensive knowledge of life coaching fundamentals, including NLP technology. Develop and apply enhanced self-awareness to understand personal strengths and weaknesses. Master skills to support clients in overcoming fears and embracing change. Gain expertise in Emotional Intelligence, communication techniques, and body language. Learn ethical coaching practices and principles for business development and client goal setting. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Module 01: Life Coaching: The Purpose and Fundamentals Life Coaching: The Purpose and Fundamentals 00:50:00 Module 02: Develop Your Self-Awareness Develop Your Self-Awareness 00:54:00 Module 03: The Development of Core Beliefs and Managing Fears The Development of Core Beliefs and Managing Fears 00:49:00 Module 04: Life Coaching Types and Key Attributes of a Life Coach Life Coaching Types and Key Attributes of a Life Coach 01:02:00 Module 05: Understanding Emotional Intelligence Understanding Emotional Intelligence 00:46:00 Module 06: Body Language and Communication Techniques Body Language and Communication Techniques 00:46:00 Module 07: A Structure for Client Work and Goal Setting A Structure for Client Work and Goal Setting 00:40:00 Module 08: Basic Principles for Business Development and Growth Basic Principles for Business Development and Growth 00:56:00 Module 09: The Ethical Coach: Protect Yourself and Your Clients The Ethical Coach: Protect Yourself and Your Clients 00:50:00

A beginner-level course loaded with JavaScript coding examples so that you can learn the fundamentals of JavaScript code. Explore the fundamental core concepts of using JavaScript and how to apply JavaScript code to create interactive web applications with the help of this carefully structured course. The fundamentals of JavaScript are all you need to start coding today and build amazing things with JavaScript.

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want This course covers the basics of agile project management, its principles, benefits and the role of leaders in agile project management. In this course, you will learn agile methodologies and master various essential skills to lead and deliver projects with adaptability and efficiency. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Understand the fundamentals of both agile and conventional project management Recognise the principles and benefits of agile project management Understand the role of leaders in agile project management Know how to maintain diversity in an agile team Recognise the stages of both agile and conventional project management Know how to initiate a project and manage an agile team Learn the fundamental of establishing an effective communication Know how to develop and lead a high-performance team Gain skills and knowledge to develop yourself as a self-confident professional Know how to perform risk analysis and use strategies to manage risks Learn how to set goals and manage individuals Why Agile Project Management Training Course right for you? This agile project management training course is ideal for Project Managers who want to gain skills and knowledge about agile project management, as well as for those who want to create an effective agile project management strategy for their company. This course will help you develop a comprehensive understanding of both Agile and conventional project management ideas and techniques, as well as how to combine them in the proper ratios to handle any project. You will understand how to maintain diversity in an agile team, the stages of agile project management and how to ensure effective communication among all members. This course explains the definition stage, the planning stage, the delivery stage, and the closure stage of the conventional project management system. Finally, you will learn how to manage individuals and manage your team as a project manager. Upon successful completion of this course, you gain skills ad knowledge about both agile project management and conventional project management system to build a successful career in the project management sector. Agile Project Management Training Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Introduction Introduction What is Agile Project Management What is Agile Project Management What is Agile Manifesto What is Agile Manifesto Four Foundational Agile Values Four Foundational Agile Values Twelve Supporting Agile Principles Twelve Supporting Agile Principles Role of Leaders in Agile PM Role of Leaders in Agile PM Managing Diversity in an Agile Team Managing Diversity in an Agile Team Importance of Leadership in Agile Importance of Leadership in Agile SCRUM Methodology SCRUM Methodology Extreme Programming Methodology Extreme Programming Methodology Stages of Agile Project Management Stages of Agile Project Management Importance of Accountability Importance of Accountability Agile Team - Values & Ethics Agile Team - Values & Ethics Agile Team Management Agile Team Management Pitfalls to Effective Communication Pitfalls to Effective Communication Tips for Effective Communication Tips for Effective Communication Launchpresentation Project Management Fundamentals: Know the Principles and Get it Right What is a Project The Four Stage Project Lifecycle Project Stages and Boundaries One Reason why Projects go Wrong Terminology used in the Project Stages More on Project Gateways / Stage Gates Project Definition Stage: The Vital Foundation to Your Success Define your Project: Goals and Objectives Understanding Project Scope Dealing with Scope Creep Project Definition: Summary Project Planning Stage: Failing to Plan = Planning to Fail The Book of the Plan The Stakeholder Engagement Process Stakeholder Analysis Milestones are your Best Friends The Work Breakdown Structure The Gantt Chart Tools for Creating a Gantt Chart The Linear Responsibility Chart (LRC) aka The RACI Chart The Risk Management Process Risk Analysis The Six Strategies for Managing Risks The Risk Register (or Risk Log) Project Delivery Stage: Don't you Love it When a Plan Comes Together The Four Essentials of Leading your Team Project Delivery - The Three Key Cycles Project Closure Stage: Deep Sigh - You're Nearly Done Closing Words Personal Effectiveness - How to Be an Awesome Professional Monday: Self-confidence Tuesday: Personal Time Management Wednesday: Assert Yourself Thursday: Problem Solving Friday: Presenting Managing Individuals - How to Get the Best From Your People Monday: Goal Setting Tuesday: Delegation Wednesday: Feedback Thursday: Poor Performance Friday: Coaching Communication Skills - How to Make Your Management Voice Heard Monday: Listening Tuesday: Motivating Wednesday: Meetings Thursday: Negotiating Friday: Conflict Team Management - How to Create and Keep A High Performance Team Monday: The Power of Teams Tuesday: Team Development Wednesday: Team Maintenance Thursday: The Four Essentials of Team Management Friday: Team Meetings Manager's Toolkit - How to Adapt to Whatever The Job Throws At Yo Monday: Emotional Intelligence Tuesday: Transactional Analysis Wednesday: The SCOPE Process Thursday: Selecting Management Styles Friday: The Powerhouse Loop Who should take this course? This agile project management training course is primarily aimed at: Project managers Team leaders Project team members Aspiring project managers Anyone looking to enhance their project management skills Anyone who wants to learn about agile project management New project managers who want to gain agile project management skills However, this course is not restricted to any single profession or field of work. This course can also benefit anyone who wants to learn more about agile project management in order to handle their own projects. Entry Requirements There are no academic entry requirements for this agile project management training course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This agile project management training course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

The Motivation Skills Training is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a recognised certification. This Motivation Skills Training consists of several modules that take around 2 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification Upon successful completion of the course, you will be able to obtain your course completion PDF Certificate at £9.99. Print copy by post is also available at an additional cost of £15.99 and the same for PDF and printed transcripts. Course Content Motivation Skills Training Goals & What is Motivation? 00:06:00 The SOURCE of All Motivation 00:02:00 'Virtual Reality' & Programming 00:16:00 Other Factors 00:28:00 What Creates Change - Part 1 00:17:00 What Creates Change - Part 2 00:23:00 What Creates Change - Part 3 00:29:00 How Can We Influence Others? 00:12:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Duration 1 Days 6 CPD hours This course is intended for Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites SQL Querying Fundamentals - Part 1 1 - Using Subqueries to Perform Advanced Querying Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries 2 - Manipulating Table Data Insert Data Modify and Delete Data 3 - Manipulating the Table Structure Create a Simple Table Create a Table with Constraints Add or Drop Table Columns Add or Drop Constraints Modify the Column Definition Back Up Tables Delete Tables 4 - Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Drop Views 5 - Indexing Data Create Indices Drop Indices 6 - Managing Transactions Create Transactions Commit Transactions