40101 Courses in Cardiff delivered Online

Level 3 & 5 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access | Tutor Support

Level 5 & 7 Endorsed Diploma | FREE QLS Hard Copy Certificate | FREE 5 CPD Courses & PDF Certificates | Lifetime Access

Duration 5 Days 30 CPD hours This course is intended for 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. Overview 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 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. Prerequisites Basic understanding of relational databases. Basic Windows knowledge. Module 1: Introduction to Transact-SQL What is Transact-SQL The SELECT statement The WHERE clause Sorting results Calculations CASE expressions Module 2: Joining tables with Transact-SQL The JOIN clause Inner joins Outer joins Self joins and cross joins Module 3: Filtering and sorting results Implement the ORDER BY clause Filter data with the WHERE clause Limit the number of rows returned by a query Implement NULL logic Module 4: SQL Server data types Understand data types Implement string data types Implement temporal data types Module 5: Inserting, updating and deleting data Insert new records Update existing records Delete data Module 6: Using SQL Server functions with Transact-SQL Understand function types in SQL Server Convert data using functions Implement logical functions Work with NULL data using functions Module 7: Aggregating data with Transact-SQL Implement aggregation in SQL Server Group records in SQL Server Filter aggregated data Module 8: Implement subqueries with Transact-SQL Implement scalar and multi-valued sub-queries Implement correlated subqueries Implement existence checks with subqueries Module 9: Create queries that use table expressions Create views Create table-valued functions Implement derived tables Implement common table expressions Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data Write queries with the UNION operator Write queries with the INTERSECT and EXCEPT operators Write queries with the APPLY operator Module 11: Implement window functions in queries Understand window functions Impement window functions Module 12: Use PIVOT and grouping sets in queries Implement PIVOT in queries Implement grouping sets in queries Module 13: Use stored procedures in queries Query data with stored procedures Interact with stored procedures using input and output parameters Write simple stored procedures Pass dynamic SQL to SQL Server Module 14: Implement programming features in Transact-SQL Understand T-SQL programming elements Implement loops and conditions in T-SQL queries Module 15: Add error handling to queries Understand SQL Server error handling Implemet structured exception handling Module 16: Use transactions in queries Understand database transactions Implement transactions in T-SQL

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

Leading in a Disruptive Age: Don´t Just Manage Projects ... Lead Them How can a leader in today's organization get the right mix across teams, leadership, and the culture that binds them together? This session will cover the latest trends in what drives teams, the disconnects between leaders and their teams, and considerations for building a winning project culture that drives value to both the customer and organization across factors of people, process, and technology. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Construction Project Administration bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The Construction Project Administration related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Construction Project Administration bundle will help you build a solid foundation to become a proficient worker in the sector. This Construction Project Administration Bundle consists of the following 25 CPD Accredited Premium courses - Course 1: Construction Industry Scheme (CIS) Course 2: Property Development Diploma Course 3: Property Management Training Course 4: Real Estate Investor Level 3 Course 5: Public Housing Management Course 6: Construction Management - Level 5 Diploma Course 7: Customer Service Course 8: Document Control and Management Course 9: Fundraising Course 10: Environmental Law & Impact Assessment Course 11: Working at Height Course 12: Effective Communication Skills for Technical People Course 13: Leadership & Management Course 14: Leadership Styles Course 15: Building Surveyor Course 16: Property Law Course 17: Contracts Law UK Course 18: Decision Making in High Stress Course 19: Contract Management Training UK Course 20: Property Business Training - Level 5 Course 21: Residential Property Sales Course 22: Land Surveyor Course 23: Cost Estimation for Multiplex Building with Xactimate Course 24: UK Land Management Complete Training Course 25: Public Speaking Skills - CPD Accredited 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Learning Outcome This tailor-made Construction Project Administration bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Construction Project Administration Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Construction Project Administration bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Construction Project Administration Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for IT professionals who are responsible for planning, configuring, and managing an Office 365 environment. Students who attend this course are expected to have a fairly broad understanding of several on-premises technologies such as Domain Name System (DNS) and Active Directory Domain Services (AD DS). In addition, they should have a general understanding of Microsoft Exchange Server, Microsoft Teams, and Microsoft SharePoint. Overview Plan and provision Office 365 Manage Users and Groups in Office 365 Deploy and Configure Tools and Applications for Office 365 Plan and Manage Exchange Online Plan and Manage SharePoint Online Plan and Manage Microsoft Teams Plan and Manage other Office 365 Services Implement Security and Compliance in Office 365 Report, Monitor and Troubleshoot Office 365 This five-day course describes how to set up, configure and manage an Office 365 tenant including identities, and the core services of Microsoft 365. In this five-day course, you will learn how to plan the configuration of an Office 365 tenant including integration with existing user identities; plan, configure and manage core services; and report on key metrics. Although this course and the associated labs are written for Office 365 with Windows 11, the skills taught will also be backwards compatible with Windows 10. This course is based on the features available in the Office 365 E3 license as these are the core features in Office 365 and Microsoft 365 plans. 1 - Planning and Provisioning Office 365 Overview of Office 365 Core Services of Office 365 Requirements for an Office 365 Tenant Planning a Pilot and Deployment Creating an Office 365 Tenant Adding Custom Domains and Managing DNS Settings Lab: Provisioning Office 365 2 - Managing Users and Groups in Office 365 Managing User Accounts and Licences Managing Passwords and Authentication Create and Managing the Different Types of Groups in Office 365 Managing Users and Groups with PowerShell Managing Users and Groups in the Azure AD Admin Center Role Based Access and Administrative Roles Planning and Configuring Directory Synchronization Lab: Managing Users and Groups in Office 365 Lab: Planning and Configuring Directory Synchronisation 3 - Deploying and Configuring Tools and Applications for Office 365 Planning Network Configuration for Office 365 Tools and Applications Using the Office Configuration Tool Click to Run Installation Use and Control Managing Centralized Deployment of Tools, Applications and Add-ins Reporting Lab: Deploying and Configuring Tools and Applications for Office 365 4 - Planning and Managing Exchange Online What is Exchange Online Managing Exchange Online Mailboxes Managing Office 365 Groups in Exchange Online Configuring Exchange Online Permissions Managing Exchange Online using PowerShell Plan and Configure Mail Flow Plan and Configure Email Protection Lab: Planning and Managing Exchange Online 5 - Planning and Managing SharePoint Online What is SharePoint Online Understanding the relationship between SharePoint, OneDrive, Teams, and Office 365 Groups SharePoint Online Architecture Configure SharePoint Online Configure and Control External Sharing Managing SharePoint Online Site Collections Managing SharePoint Online using PowerShell Lab: Planning and Managing SharePoint Online 6 - Planning and Managing Microsoft Teams What is Microsoft Teams How Microsoft Teams integrates with other Office 365 Services Create and Manage Organization Wide Settings Create, Manage and Assign Microsoft Teams Policies Plan and Configure External and Guest Access Managing Microsoft Teams using PowerShell Lab: Planning and Managing Microsoft Teams 7 - Planning and Managing Other Office 365 Services Yammer Planner Visio Bookings Delve Forms Power Platform Stream Sway Viva Scheduler Add-ins, including Find Time and Junk Reporter Lab: Planning and Managing Office 365 Services 8 - Security and Compliance in Office 365 Overview of Security and Compliance Features in Office 365 Extending Security and compliance Features with Additional Licences Using the Microsoft Defender Portal and Secure Score Using the Office 365 Compliance Portal and Compliance Score Plan and Configure Retention Labels and Policies Plan and Configure Data Loss Prevention Policies Create and Assign Sensitivity Labels Configure Safe Attachments and Safe Links Policies Plan and Configure Multi Factor Authentication Lab: Configure Security and Compliance in Office 365 9 - Reporting, Monitoring and Troubleshooting Office 365 Monitoring Office 365 Service Health Troubleshooting Administrative Access in Office 365 Troubleshoot Directory Synchronization Troubleshooting Exchange Online Troubleshooting SharePoint Online Troubleshooting Microsoft Teams Troubleshooting Office 365 Security and Compliance Lab: Reporting, Monitoring and Troubleshooting in Office 365

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Noise and Hearing Protection, COSHH Awareness and Asbestos Surveying bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 37 course mega bundle that will exceed your expectations within your budget. The Noise and Hearing Protection, COSHH Awareness and Asbestos Surveying related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Noise and Hearing Protection, COSHH Awareness and Asbestos Surveying bundle will help you build a solid foundation to become a proficient worker in the sector. This Noise and Hearing Protection, COSHH Awareness and Asbestos Surveying Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Site Management Safety Training Scheme Course 2: CDM Regulations Course 3: Site Safety Plus Course 4: CSCS Health and Safety in a Construction Environment (Leading to CSCS Green Card) Course 5: Construction Project Management Course 6: Asbestos Surveying Course 7: COSHH Awareness Course 8: Noise and Hearing Protection Course 9: Working in Confined Spaces Course 10: Working at Height Training Course 11: Construction Management Level 3 Course 12: Environmental Engineering Course 13: Emergency First Aid at Work (EFAW) Course 14: Construction Project Management Course 15: Purchasing and Procurement Diploma Course 16: Operations and Supply Chain Management Course 17: Gas Safety Course 18: Environmental Health Course 19: Abrasive Wheels Course 20: Construction Risk Assessment Course 21: LOLER Regulations and LOLER Inspection Training Course 22: Manual Handling Interactive Training Course 23: Fire Safety Course 24: Quality Assurance (QA) Management Course 25: Quantity Surveying Course 26: Banksman Course 27: PUWER Course 28: Supervisor Training Course 29: Logistic Maangement Course 30: Concussion Injuriy 7 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Course 6:Business English Perfection Course Course 7:Networking Skills for Personal Success Learning Outcome This tailor-made Noise and Hearing Protection, COSHH Awareness and Asbestos Surveying bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Noise and Hearing Protection, COSHH Awareness and Asbestos Surveying Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 370 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Noise and Hearing Protection, COSHH Awareness and Asbestos Surveying bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Noise and Hearing Protection, COSHH Awareness and Asbestos Surveying Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Feeling Stuck in Your Career? The Merchandising : Fashion Stylist Fundamentals Bundle is Your Skill-Building Solution. This exceptional collection of 25 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the Merchandising & Fashion Stylist Fundamentals bundle provides an engaging learning experience, helping you learn skills across various disciplines. With Merchandising: Fashion Stylist Fundamentals Bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The Merchandising & Fashion Stylist Fundamentals bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the Merchandising: Fashion Stylist Fundamentals bundle on your job life and career growth! This Merchandising: Fashion Stylist Fundamentals Bundle Comprises the Following CPD Accredited Courses: Course 01: Fashion Stylist Fundamentals Course 02: Image Stylist Course 03: Fashion and Lifestyle Blogger Course 04: Fabrics for Fashion Design: Essential Learning for Designers Course 05: Fashion Store Assistant Course 06: Fashion Law Online Course for Legal Guidance in Fashion Industry Course 07: Sewing Craft: Crochet Course 08: Designing Shirt Course 09: Grow Your T-Shirt Business With Online Marketing Course 10: Start A T-Shirt Business Course 11: Visual Merchandising Diploma Course 12: Merchandising Course 13: Product Photography Course 14: Retail Management Diploma Course 15: Retail Sales Assistant Course Course 16: Retail Industry and Buyer Behaviours Course 17: Career Development Plan Fundamentals Course 18: CV Writing and Job Searching Course 19: Learn to Level Up Your Leadership Course 20: Networking Skills for Personal Success Course 21: Ace Your Presentations: Public Speaking Masterclass Course 22: Learn to Make a Fresh Start in Your Life Course 23: Motivation - Motivating Yourself & Others Course 24: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 25: Decision Making and Critical Thinking What will make you stand out? Upon completion of this online Merchandising: Fashion Stylist Fundamentals Bundle, you will gain the following: CPD QS Accredited Proficiency with this Merchandising & Fashion Stylist Fundamentals Bundle After successfully completing the Merchandising & Fashion Stylist Fundamentals bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Merchandising & Fashion Stylist Fundamentals Bundle The online test with immediate results You can study and complete the Merchandising & Fashion Stylist Fundamentals bundle at your own pace. Study for the Merchandising & Fashion Stylist Fundamentals bundle using any internet-connected device, such as a computer, tablet, or mobile device. The Merchandising: Fashion Stylist Fundamentals bundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience designed to enrich both your personal and professional development. Advance the future of learning with the Merchandising & Fashion Stylist Fundamentals bundle, a comprehensive, complete collection of 25 courses. Each course in the Merchandising & Fashion Stylist Fundamentals bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the Merchandising & Fashion Stylist Fundamentals bundle offers the flexibility and convenience to learn at your own pace. Make the Merchandising & Fashion Stylist Fundamentals package your trusted partner in your lifelong learning journey. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Merchandising: Fashion Stylist Fundamentals is perfect for: Expand your knowledge and skillset for a fulfilling career with the Merchandising & Fashion Stylist Fundamentals bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the Merchandising & Fashion Stylist Fundamentals bundle. Discover your passion or explore new career options with the diverse learning opportunities in the Merchandising & Fashion Stylist Fundamentals bundle. Learn on your schedule, in the comfort of your home - the Merchandising & Fashion Stylist Fundamentals bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the Merchandising & Fashion Stylist Fundamentals bundle. Certificates CPD Certificates Digital certificate - Included

With our CV builder, you can make a professional CV for job and university applications in minutes. Low cost and fast delivery.