4609 Courses in Cardiff delivered Online

Course Overview The database is a must for collecting, saving, sorting and finding out data of your website or software. An effective database can make your software more engaging and interactive. learn how to use Microsoft SQL Server from this Microsoft SQL Server Development course and boost the quality of your software. This Microsoft SQL Server Development course will teach you the functions of databases and querying from scratch. You will learn about Microsoft SQL Server, relational database management systems, various functions, tables and relationships from this course. You will be able to use the database for your software development and management. This course will also teach you the best practices for database development and management. Learning Outcomes Learn how to use Microsoft SQL management studio Familiarize with basic database design Learn how you can use select statements Be able to insert delete or update data into data tables Learn about the best practices for database development Create relationships among multiple tables Learn how you can use foreign keys Be able to create Complex database objects Understand how to backup and restore database Who is this course for? This course is helpful for anyone who wants to learn about the database management system and SQL servers. You will be able to understand the function of the database, logic and usability of the database for your Microsoft SQL server development. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, 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 hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Microsoft SQL Server Development is a useful qualification to possess and would be beneficial for any related profession or industry such as: Software Engineer Web Developers Data Security Officers Database Administrators Database Developers Introduction Introduction to SQL Server and Databases 00:04:00 Download and Install SQL Server Express 00:05:00 Manipulating Tables and Data Connect to Database Instance and Create a Database 00:06:00 Drop or Remove Database 00:04:00 What is a Database Table? 00:02:00 Create an SQL Database Table 00:32:00 Insert Data into the Table with SQL Script 00:15:00 Insert Data into the Table with Management Studio 00:05:00 Select Data from the Table with SQL Script 00:09:00 More Advanced Select Queries Part 1 00:18:00 Update Data in the Table 00:10:00 Update Data in the Table with Management Studio GUI 00:02:00 Delete Data from the Table with SQL Script 00:06:00 Delete Data from the Table with Management Studio GUI 00:01:00 Relationships and Foreign Keys What are Relationships, Foreign Keys and Normalization 00:11:00 Create a Relationship in SQL Server 00:19:00 Insert Records in Related Tables 00:13:00 Run Queries on Related Tables 00:19:00 Left, Right and Full Joins 00:11:00 Group By and Aggregate Functions Grouping Data using SQL GROUP BY Clause 00:12:00 SQL AVG Aggregate Function 00:11:00 SQL COUNT Aggregate Function 00:04:00 SQL MAX and MIN Aggregate Functions 00:04:00 SQL SUM Aggregate Function 00:04:00 Advanced SQL Server Objects and Concepts Create and Manage Views 00:23:00 Scalar Valued Functions 00:27:00 Inline Table Valued Functions 00:09:00 Multi Statement Table Valued Functions 00:12:00 Stored Procedures 00:28:00 Table Triggers 00:19:00 Database Scripting, Backup and Restore 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Manage your company books and finances professionally Having trouble keeping up with lots of transactions and financial records of your company? Whether there is an increased number of sales or employees, you need a solid understanding of bookkeeping and payroll management to keep your books neat. Learn how to improve your skills as an accounting professional with this course. Description: Bookkeeping and managing payrolls are very important for a company as they eventually need to keep books by law for at least 6 years. This has made accounting technicians or professionals in charge of a company's finances to learn the secrets behind professional bookkeeping. If you are a business owner yourself or acting as an accounts manager, you might feel the necessity of understanding bookkeeping and payroll management. These skills add values to your career and give you what it takes to stand out in the crowd by proving yourself by accurately record financial purchases, sales, and receipts. This course is designed especially for you to deliver the rules of bookkeeping and professional tips that will help you in the long run. After successfully completing this course, you will be able to handle any kind of accounting records, manage compensations of your employees, prepare professional invoices and also prepare statements that help your business to take better decision. Who is the course for? Professionals, who work in the business or corporate setting, especially people who are assigned to manage the accounts and payroll. People who are interested in learning more about bookkeeping & payroll management. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  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. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: 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 a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Diploma in Bookkeeping & Payroll Management course is a useful qualification to possess and would be beneficial for the following careers: Account Manager Auditor Benefits Administration Specialist Bookkeepers Finance Officer Payroll Officers Payroll Manager. Bookkeeping Module One - Introduction 00:30:00 Module Two - Basic Terminology 01:00:00 Module Three - Basic Terminology (II) 01:00:00 Module Four - Accounting Methods 01:00:00 Module Five - Keeping Track of Your Business 01:00:00 Module Six - Understanding the Balance Sheet 01:00:00 Module Seven - Other Financial Statements 01:00:00 Module Eight - Payroll Accounting Terminology 01:00:00 Module Nine - End of Period Procedures 01:00:00 Module Ten - Financial Planning, Budgeting and Control 01:00:00 Module Eleven - Auditing 01:00:00 Module Twelve - Wrapping Up 00:30:00 Managing Payroll What Is Payroll? 00:30:00 Principles Of Payroll Systems 01:00:00 Confidentiality And Security Of Information 00:30:00 Effective Payroll Processing 01:00:00 Increasing Payroll Efficiency 01:00:00 Risk Management in Payroll 00:30:00 Time Management 00:30:00 Personnel Filing 00:30:00 When Workers Leave Employment 01:00:00 Hiring Employees 00:30:00 Paye and Payroll for Employers 01:00:00 Tell HMRC about a New Employee 01:00:00 Net And Gross Pay 00:30:00 Statutory Sick Pay 00:30:00 Minimum Wage for Different types of Work 01:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Diploma in Bookkeeping & Payroll Management 00:30:00 Final Exam Final Exam- Diploma in Bookkeeping & Payroll Management 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 5 Days 30 CPD hours This course is intended for This course is for professionals who need knowledge about implementing various Service Provider core technologies and advanced routing technologies. Network administrators System engineers Project managers Network designers Overview After taking this course, you should be able to: Describe the main characteristics of routing protocols that are used in Service provider environments Implement advanced features of multiarea Open Shortest Path First (OSPFv2) running in Service Provider networks Implement advanced features of multilevel Intermediate System to Intermediate System (ISIS) running in Service Provider networks Configure route redistribution Configure Border Gateway Protocol (BGP) in order to successfully connect the Service Provider network to the customer or upstream Service Provider Configure BGP scalability in Service Provider networks Implement BGP security options Implement advanced features in order to improve convergence in BGP networks Troubleshoot OSPF, ISIS, and BGP Implement and verify MPLS Implement and troubleshoot MPLS traffic engineering Implement and verify segment routing technology within an interior gateway protocol Describe how traffic engineering is used in segment routing networks Implement IPv6 tunneling mechanisms Describe and compare core multicast concepts Implement and verifying the PIM-SM protocol Implement enhanced Protocol-Independent Multicast - Sparse Mode (PIM-SM) features Implement Multicast Source Discovery Protocol (MSDP) in the interdomain environment Implement mechanisms for dynamic Rendezvous Point (RP) distribution The Implementing Cisco Service Provider Advanced Routing Solutions (SPRI) 5-day course teaches you theories and practices to integrate advanced routing technologies including routing protocols, multicast routing, policy language, Multiprotocol Label Switching (MPLS), and segment routing, expanding your knowledge and skills in service provider core networks. This course prepares you for the 300-510 Implementing Cisco© Service Provider Advanced Routing Solutions (SPRI) exam. The course qualifies for 40 Cisco Continuing Education credits (CE) towards recertification. This course will help you: Gain the high-demand skills to maintain and operate advanced technologies related to Service Provider core networks Increase your knowledge and skills for implementing Service Provider core advanced technologies though hands-on application and practical instruction Prepare to take the 300-510 SPRI exam Course Outline Implementing and Verifying Open Shortest Path First Multiarea Networks Implementing and Verifying Intermediate System to Intermediate System Multilevel Networks Introducing Routing Protocol Tools, Route Maps, and Routing Policy Language Implementing Route Redistribution Influencing Border Gateway Protocol Route Selection Scaling BGP in Service Provider Networks Securing BGP in Service Provider Networks Improving BGP Convergence and Implementing Advanced Operations Troubleshooting Routing Protocols Implementing and Verifying MPLS Implementing Cisco MPLS Traffic Engineering Implementing Segment Routing Describing Segment Routing Traffic Engineering (SR TE) Deploying IPv6 Tunneling Mechanisms Implementing IP Multicast Concepts and Technologies Implementing PIM-SM Protocol Implementing PIM-SM Enhancements Implementing Interdomain IP Multicast Implementing Distributed Rendezvous Point Solution in Multicast Network

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Fibre splicing training course description A short, concise hands on fibre optic cable splicing course providing comprehensive coverage of fibre splicing. Over 50% of the course is practical based. What will you learn Prepare cable for splicing. Splice fibre optic cable. Fibre splicing training course details Who will benefit: Those wishing to be able to splice fibre. Prerequisites: None. Duration 1 day Fibre splicing training course contents Fibre optic essential review Fibre cable types. SMF, MMF. Safe working practices. Cable handling issues. Hands on: Handling fibre optic cable. Preparing fibre for splicing Cutting and stripping tools, cleaving methods, fibre cleaning materials. Hands on: Fibre preparation. Splicing Joining fibres, splicers, fusion splicing, mechanical splicing, splicing procedure. cleaving, splicing parameters. Splicing vs. connectors. Which splice? Hands on: Splicing fibre. Splice loss mechanisms End gap, concentricity, end angle, NA mismatch, finish and dirt, coaxiality, Axial run out, core mismatch, back reflection. Testing Testing successful fibre splicing. Hands on: Testing spliced fibre.

Criminal Law is essential for keeping our communities safe and ensuring fairness. This course strips away the complexity, giving you a clear view of what it takes to understand and apply the laws that define and deal with crimes. You'll get to grips with the real issues that law professionals grapple with daily, and see how tackling these issues head-on can lead to a more just society.   With each module, you'll find yourself getting to the heart of what makes laws work and why they're so crucial for society's well-being. From the adrenaline-fueled chase of crime prevention to the meticulous analysis needed for a fair trial, you'll learn the ropes of what it takes to uphold the law. It's not just about knowing the rules; it's about understanding how they protect us all.   Knowing about criminal law isn't just for lawyers and police officers. It's valuable knowledge that enhances your awareness of the world and your place in it. By the end of this course, you won't just watch the news; you'll interpret it. You won't just follow rules; you'll appreciate their role in your daily life. This course is a step towards being more informed, involved, and invested in the well-being of your community.   Learning Outcomes Understand the foundational principles and structure of Criminal Law. Identify the critical elements that constitute a crime. Assess the roles of individuals in crimes, including accomplices. Evaluate the key processes from police investigation to prosecution. Analyse the principles guiding sentencing and crime prevention. Examine the legal definitions and responses to major crimes. Investigate the impact of criminal law on society and individuals.   Who is this course for Aspiring criminologists and legal practitioners. Law enforcement officials seeking deeper legal insights. Legal studies students interested in criminal law specialization. Professionals in security and crime prevention sectors. Community workers and policymakers focused on justice and safety.   Why Choose This Course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success.   Career Path Criminal Lawyer: £25,000 - £100,000+ per annum. Police Detective: £30,000 - £60,000 per annum. Forensic Psychologist: £31,000 - £87,000 per annum. Probation Officer: £22,000 - £37,000 per annum. Criminologist: £20,000 - £40,000 per annum. Prerequisites No previous qualifications or experiences are necessary to embark on this Criminology: Criminal Law journey. Crafted by seasoned experts, this course is accessible across a myriad of digital platforms, offering the flexibility to learn at your convenience with a stable internet connection.   Certification Upon completion of the course content, a written evaluation awaits learners. Passing this assessment allows for the acquisition of a digital certificate at a nominal fee of £4.99 GBP. If a physical certificate is desired, it can be procured for an additional charge of £8. Course Curriculum Module 01: Introduction to Criminal Law Introduction to Criminal Law 00:19:00 Module 02: Elements of a Crime Elements of a Crime 00:27:00 Module 03: Incitement, Conspiracy and Attempt Incitement, Conspiracy and Attempt 00:27:00 Module 04: Accomplice Accomplice 00:26:00 Module 05: Crime Prevention Crime Prevention 00:27:00 Module 06: The Police The Police 00:33:00 Module 07: Prosecution, Caution and Diversion Prosecution, Caution and Diversion 00:26:00 Module 08: Youth Justice Youth Justice 00:23:00 Module 09: The Trial The Trial 00:26:00 Module 10: Sentencing Process Sentencing Process 00:25:00 Module 11: Homicide Homicide 00:31:00 Module 12: Offences against Person Offences against Person 00:21:00 Module 13: Sexual Offences Sexual Offences 00:20:00 Module 14: Theft Theft 00:22:00 Module 15: Blackmail, Robbery & Burglary Blackmail, Robbery & Burglary 00:22:00 Module 16: White-Collar Crime White-Collar Crime 00:25:00 Module 17: Terrorism & Law Terrorism & Law 00:23:00 Module 18: Property Offences Property Offences 00:22:00 Module 19: Cybercrime & Piracy Cybercrime & Piracy 00:29:00 Module 20: Prisons Prisons 00:26:00 Module 21: Probation Service Probation Service 00:26:00 Module 22: War Crimes War Crimes 00:34:00 Assignment Assignment - Criminology: Criminal Law 00:00:00

The Mortgage Advisor Training Course is essential in today's world, equipping you with vital skills to navigate the complex landscape of mortgage intelligence. Understanding various architectures and market insights through in-depth analysis is crucial for providing expert advice and recommendations. Mastery of documentation proficiency and insurance strategies ensures seamless transactions, while knowledge of compliance and regulations ensures regulatory harmony in client interactions. These skills are not just beneficial but necessary in daily life and professional careers, enhancing your ability to secure job opportunities in the UK market as a Mortgage Advisor. With salaries averaging around £30,000 to £40,000 per annum, the demand for Mortgage Advisors is on the rise, reflecting an increasing sector by 10% annually. This Mortgage Advisor Training course offers numerous advantages, enabling you to excel in a field where expertise is highly valued and sought after. Embrace the opportunity to become a proficient Mortgage Advisor and carve a successful career path in this growing industry. Key Features: CPD Certified Mortgage Advisor Training Course Free Certificate Developed by Specialist Lifetime Access Course Curriculum Mortgage Advisor Training Module 01: Foundations of Mortgage Intelligence Module 02: Mortgage Architectures: Types and Structural Insights Module 03: Market Maestro: In-Depth Mortgage Market Analysis Module 04: Advisor's Arsenal: Expert Mortgage Advice and Recommendations Module 05: Seamless Transactions: Mortgage Documentation Proficiency Module 06: Financial Shields: Mortgage Protection and Insurance Strategies Module 07: Regulatory Harmony: Mortgage Compliance and Regulations Module 08: Crafting Connections: Professional Skills and Client Management Learning Outcomes: Master introductory principles shaping effective mortgage advisory skills and strategies. Understand diverse mortgage types and structures for tailored client solutions. Analyze the mortgage market comprehensively, identifying trends and potential opportunities. Provide sound mortgage advice and recommendations aligned with client financial goals. Navigate the intricacies of mortgage documentation and streamline transaction processes efficiently. Develop expertise in mortgage protection and insurance strategies for client financial security. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Mortgage Advisor Training course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Mortgage Advisor Training. Moreover, this course is ideal for: Individuals aspiring to become skilled mortgage advisors with strategic proficiency. Financial professionals seeking to diversify their expertise into mortgage consultation. Real estate professionals desiring in-depth knowledge of mortgage market dynamics. Graduates in finance or related fields aiming to specialize in mortgage advisory. Anyone keen on entering the mortgage industry with a solid foundational understanding. Requirements There are no requirements needed to enrol into this Mortgage Advisor Training course. We welcome individuals from all backgrounds and levels of experience to enrol into this Mortgage Advisor Training course. Career path After finishing this Mortgage Advisor Training course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Mortgage Advisor Training are: Mortgage Advisor - £25K to 60K/year. Mortgage Broker - £30K to 70K/year. Financial Advisor - £30K to 50K/year. Mortgage Consultant - £25K to 55K/year. Real Estate Agent - £20K to 50K/year. Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

By taking our Traffic Marshal Course, you can keep the general public safe while also ensuring that expert drivers are properly protected. Marshals are a valuable resource in a variety of public and private sectors. This function is critical for everyone's safety and the smooth operation of normal activities, whether it's maintaining safety and records at a car park or major event or guiding trucks in a busy construction site. This course can help you advance your career, and the content was compiled by industry pros that understand the right ideals and practices. This Diploma in Traffic Marshal at QLS Level 4 is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 120 CPD points) to make your skill development and career progression related to Traffic Marshal substantial and easier than ever! The Traffic Marshal Course covers all of the necessary training to undertake and perform the duties of this position. You'll study the essential abilities required of a Traffic Marshal, as well as the procedures employed in UK traffic control. The procedures for assessing traffic risk and maneuvering vehicles are thoroughly examined, as are the nationally recognised hand signals required for the task. You'll also learn about road safety rules and regulations, as well as health and safety measures for any public location. Each of the interactive online modules can be completed at your leisure and from any computer with an internet connection. Upon successful completion of this course, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling on this course. With this comprehensive course, you can achieve your dreams and train for your ideal career. This course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. This training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join this course today - gear up with the essential skills to set yourself up for excellence! Learning Outcomes of Traffic Marshal Course: Understand the roles and responsibilities of a UK Traffic Marshal Learn how to manage and control traffic in a busy area or public place Know how to set up temporary traffic control zones Be aware of pedestrian and worker safety considerations Discover how to assess the risks in a site or public place accurately Be comfortable with using standard recognised hand signals Gain the ability to reverse and direct heavy vehicles safely Attain an acute understanding of all appropriate health and safety rules *** Course Curriculum *** Diploma in Traffic Marshal at QLS Level 4 Module 01: Introduction to Traffic Marshalling What Is Traffic Marshallingl Scope and Salary Module 02: Traffic Management What Is Traffic and Traffic Control Road Traffic Control Traffic Elements Traffic Control Devices Module 03: Temporary Traffic Control Fundamental Principles of Temporary Traffic Control Temporary Traffic Control Zones Lane Closure on a Multi-lane Road Pedestrian and Worker Safety Pedestrian Considerations Module 04: Traffic Risk Assessment Ensuring a Safe Worksite & Building Complex Separating Pedestrians and Vehicles Speed Lighting Parking Loading Areas Protecting Structures Vehicle Handling Traffic Routes Module 05: Vehicle Signaling The Importance of Proper Signalling Hand Signals Standard Coded Signals Hand Signaling Devices Module 06: Reversing Vehicles Role of Banksmen in Reversing Vehicles Safe Practices for Assisting Reversing Vehicles Other Reversing Techniques Minimising Reversing Risks Module 07: Health and Safety Pedestrian and Vehicle Separation Signaler Safety High Visibility Personal Protective Equipment Legislation and the Safe Use of Vehicles in Construction Assessment Process ou have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Traffic Marshal at QLS Level 4 exams. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Traffic Marshal Course Right for You? Our course is designed to assist any individual, regardless of their current skill level, to perform the duties of a Traffic Marshal. This role can then be assumed in a wide variety of locations that need traffic control. This course is ideal for anyone interested in this topic and who wants to learn more about it. The online course will help you gain a strong understanding of the core concepts and will allow you to gain in-depth knowledge of the subject matter. This course is suitable for everyone. There are no specific entry requirements, and you can access the course materials from anywhere in the world. Requirements There are no prerequisites for the Traffic Marshal programme; everyone is welcome! Any enthusiastic learner from anywhere in the world is welcome to enrol in this Traffic Marshal course without hesitation. All students must be over the age of 16 and have a love for learning and literacy. This course is entirely online and may be accessed from any internet-connected device, including a computer, tablet, or smartphone. This course enables you to work at your own pace while developing a high-quality skillset. Career path This course is ideal for those about to assume the role of a Traffic Marshal or a job that holds similar responsibilities. As such, it covers the following careers and roles: Security Officer Construction Site Worker Traffic Enforcement Officer Health and Safety Officer Transport Officer Certificates Certificate of completion Digital certificate - £10

Information on the risks and practical advice to address them TSC's eBooks, whitepapers, and reports cover some of the most important risks in information and cyber security — risks that constantly challenge information and cyber security professionals who work tirelessly to reduce them across their organisations and home users alike.

Information on the risks and practical advice to address them TSC's eBooks, whitepapers, and reports cover some of the most important risks in information and cyber security — risks that constantly challenge information and cyber security professionals who work tirelessly to reduce them across their organisations and home users alike.