• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

37787 Courses in Cardiff delivered Online

MySQL foundation

5.0(3)

By Systems & Network Training

MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

MySQL foundation
Delivered in Internationally or OnlineFlexible Dates
£2,367

Web development fundamentals

5.0(3)

By Systems & Network Training

Web development training course description This three-day course helps build a foundation in the development of Web applications. This is not a HTML course but covers the technologies needed to develop web applications. Technologies covered include: ASP.NET, XML, AJAX and HTTP error codes. What will you learn Program Web applications. Work with data and services. Troubleshoot and debug Web applications. Work with client side scripting. Configure and deploy web applications. Web development training course details Who will benefit: Anyone looking for an introduction to web development. Prerequisites: None. Duration 3 days Web development training course contents Programming web applications Customise the layout and appearance of a web page CSS; tables; embedding images; page layout for navigation. Understand ASP.NET intrinsic objects Request; Server; Application; Session; Response; HttpContext. Understand state information in web applications Understand how state is stored based on application design and hardware; understand different types such as session state, view state, control state and application state. Understand events and control page flow Application and page life cycle events; page events; control events; application events; session events; cross-page posting; Response.Redirect; Server.Transfer; IsPostBack; setting AutoEventWireup. Understand controls Understanding various types of controls, including user, server, web and validation controls; know which is the appropriate type of control for a scenario. Understand configuration files Understanding the usage of web.config and machine.config, and the settings that can be made. Working with data and services Read and write XML data Understanding XML, XML validation Does not include: Web services; XPath syntax; XmlDocument; XPathNavigator; XPathNodeIterator; XPathDocument; XmlReader; XmlWriter; XmlDataDocument; XmlNamespaceManager. Distinguish between DataSet & DataReader objects The ability to choose the proper data object to use based on application requirements/design. Call a service from a web page Creating a basic WCF service or web service so that it can be consumed; App_WebReferences; configuration. Understand DataSource controls LinqDataSource: ObjectDataSource; XmlDataSource; SqlDataSource. Bind controls to data by using data binding syntax Ensure that data is updated and displayed in data-aware controls. Manage data connections and databases Database connections; connection objects; connection pools; transaction objects. Troubleshooting and debugging web applications Debug a web application Use in conjunction with custom error pages to display appropriate error information to the appropriate user; implement tracing of a web application, Trace.axd, Trace=True on @Page directive. Handle web application errors HTTP error codes. Working with client-side scripting Understand client-side scripting Purpose of client-side scripting; various client-side scripting languages. LE/370 and Intrinsic Functions. Understand AJAX concepts ASP.NET AJAX implementation; working with client-side libraries, EnablePartialRendering, Triggers, ChildrenAsTriggers, Scripts, Services, UpdateProgress, Timer, ScriptManagerProxy, extender controls. Configuring and deploying web applications Configure authentication and authorisation Forms authentication, Windows authentication; authorisation; file authorisation; impersonation Does not include: Windows Cardspace authentication, Passport (Windows Live ID) authentication, Custom authentication. Configure projects, solutions and reference assemblies Local assemblies; shared assemblies (GAC); web application projects; solutions; configuration files; AppSettings. Publish web applications Choosing the appropriate method to deploy an application based on existing or intended environment; updatable vs. not updateable; MSI deployment; Internet Information Server (IIS) installation and configuration. Understand application pools Purpose of application pools; effect of application pools on web applications.

Web development fundamentals
Delivered in Internationally or OnlineFlexible Dates
£2,367

Office 365 Administration Training

4.7(47)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** Office 365 Administration Training Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Office 365 Administration Training Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Office 365 Administration Training bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Office 365 Administration Training Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Office 365 Administration Training Career Bundle: Course 01: Microsoft Office 365 Automation Course Course 02: Microsoft Office Essentials Masterclass Course 03: Microsoft Teams for Everyone Course 04: Office Administration & Skills Diploma Course 05: Admin, Secretarial & PA Course 06: Executive Secretary and PA Course 07: Compliance Officer Training Level 3 Course 08: Customer Service Training Course 09: Facilities Management Certificate (FMC) Course 10: Diploma in Performance Management Course 11: Project Management Course Course 12: Change Management Course 13: Financial Analysis Course Course 14: Business Administration Course 15: Diploma in Business Proposal Writing Course 16: Business Etiquette and Professional Behavior Course 17: Business Improvement Course 18: Negotiation Skills Certificate Course 19: Retail Management Skills Course 20: Product Management Course 21: Visual Merchandising Diploma Course 22: Strategic Marketing & Planning Course 23: Business Training: Communication Skills Course 24: Level 3: Public Speaking Diploma Course Course 25: Developing Interpersonal Skills Course Course 26: Workplace Confidentiality Course 27: Minute Taking Course 28: Touch Typing Masterclass Course 29: Email Writing Training Course 30: Document Control With Office 365 Administration Training, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Don't let this opportunity pass you by. Enrol in Office 365 Administration Training today and take the first step towards achieving your goals and dreams. Why buy this Office 365 Administration Training? Free CPD Accredited Certificate upon completion of Office 365 Administration Training Get a free student ID card with Office 365 Administration Training Lifetime access to the Office 365 Administration Training course materials Get instant access to this Office 365 Administration Training course Learn Office 365 Administration Training from anywhere in the world 24/7 tutor support with the Office 365 Administration Training course. Start your learning journey straightaway with our Office 365 Administration Training Training! Office 365 Administration Training premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of the Office 365 Administration Training is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Office 365 Administration Training course. After passing the Office 365 Administration Training exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Office 365 Administration Training course is ideal for: Students seeking mastery in Office 365 Administration Training Professionals seeking to enhance Office 365 Administration Training skills Individuals looking for a Office 365 Administration Training-related career. Anyone passionate about Office 365 Administration Training Requirements This Office 365 Administration Training doesn't require prior experience and is suitable for diverse learners. Career path This Office 365 Administration Training bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Hard Copy Certificate Hard copy certificate - Included If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate CPD Accredited Digital Certificate Digital certificate - Included

Office 365 Administration Training
Delivered Online On Demand7 days
£209

Diploma in Architecture and Interior Design Diploma 1-2-1

By Real Animation Works

Face to face One to one.

Diploma in Architecture and Interior Design Diploma 1-2-1
Delivered in Internationally or OnlineFlexible Dates
£4,000

Communication Strategies

By Nexus Human

Duration 1 Days 6 CPD hours For the better part of every day, we are communicating to and with others. Whether it?s the speech you deliver in the boardroom, the level of attention you give your spouse when they are talking to you, or the look you give the cat, it all means something. This workshop will help participants understand the different methods of communication and how to make the most of each of them. 1 - Getting Started Icebreaker Housekeeping Items The Parking Lot Workshop Objectives 2 - The Big Picture What is Communication? How Do We Communicate? Other Factors in Communication 3 - Understanding Communication Barriers An Overview of Common Barriers Language Barriers Cultural Barriers Differences in Time and Place 4 - Paraverbal Communication Skills The Power of Pitch The Truth about Tone The Strength of Speed 5 - Non-Verbal Communication Understanding the Mehrabian Study All About Body Language Interpreting Gestures 6 - Speaking Like a STAR S = Situation T = Task A = Action R = Result Summary 7 - Listening Skills Seven Ways to Listen Better Today Understanding Active Listening Sending Good Signals to Others 8 - Asking Good Questions Open Questions Closed Questions Probing Questions 9 - Appreciative Inquiry The Purpose of AI The Four Stages Examples and Case Studies 10 - Mastering the Art of Conversation Level One: Discussing General Topics Level Two: Sharing Ideas and Perspectives Level Three: Sharing Personal Experiences Our Top Networking Tips 11 - Advanced Communication Skills Understanding Precipitating Factors Establishing Common Ground Using ?I? Messages 12 - Wrapping Up Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations Additional course details: Nexus Humans Communication Strategies training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Communication Strategies course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Communication Strategies
Delivered OnlineFlexible Dates
£395

NASM Group Personal Training Specialist (GPTS)

5.0(13)

By Platinum Training Institute

With the NASM Group Personal Training Specialization, you can take your fitness career further. With this one-of-a-kind course, you’ll learn how to design, develop, and deliver successful training programs that combine the best of one-on-one training with the tenets of group fitness. By mastering the strategies and tools necessary for group personal training, you’ll maximize your time and revenue by training more people, more efficiently. You’ll accomplish this by learning how to develop a strategic business plan and workout plans rooted in the proven exercise science, as well as understanding the coaching and communication skills needed in a group setting and knowing how to teach, train and motivate participants. We’ll teach you the skills and methods needed to design and deliver a successful group personal training experience, whether that’s just two clients or more than 10 in a single time slot!

NASM Group Personal Training Specialist (GPTS)
Delivered Online On Demand
£250

Firefighters Training Coordinator

4.7(160)

By Janets

Register on the Firefighters Training Coordinator today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as proof of your course completion. The Firefighters Training Coordinator is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Firefighters Training Coordinator Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Firefighters Training Coordinator, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Module 01: Introduction to Firefighter Introduction to Firefighter 00:13:00 Module 02: Fire Safety Legislation Fire Safety Legislation 00:24:00 Module 03: Understanding Fire Understanding Fire 00:25:00 Module 04: Fire Risk Assessment Fire Risk Assessment 00:30:00 Module 05: Fire Safety Arrangements Fire Safety Arrangements 00:30:00 Module 06: Evacuation & Safety Evacuation & Safety 00:18:00 Module 07: Fire Extinguishers Fire Extinguishers 00:17:00 Module 08: Emergency First Aid at Work Emergency First Aid at Work 00:13: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.

Firefighters Training Coordinator
Delivered Online On Demand2 hours 50 minutes
£25

Level 3 Learning & Development Practitioner

By Cavity Dental Training

Unlock Your Potential as a Learning & Development Practitioner with Our Level 3 Course This qualification allows candidates to learn, develop and practice the skills required for employment and a career in Learning & Development. The content covers all essential areas of learning & development and is mapped out to the institute of apprenticeships standards. It’s a work-based program combining on-the-job training with classroom learning, equipping you with skills to support employee learning and development (L&D) within an organisation. Learn about the Cavity Training Learning & Development Practitioner Course You will be introduced to the role and responsibilities and essential attributes and behaviours required in the various L&D roles that may be required for effective learning and development in an organisation. Additionally, it will teach you the policies and processes required for effective organisation learning. You will learn how to identify and analyse learning needs, establish team and individual capability and learning gaps, in line with organisational performance outcomes and to enable effective evaluation. This may include the needs of the staff impacted by the move to a net carbon zero economy by 2050 and the requirements for a just transition. Fees This course can be completed as an government funded apprenticeship, through Cavity Training, or as a privately funded course for £2500. You can either pay as a lump sum or alternatively, you can split into 12 instalments. Entry Requirements Whilst any entry requirements will be a matter for individual employers, typically an apprentice will have an area of technical, vocational or behavioural expertise in which the organisation needs others to acquire through training. And a minimum of English & Maths GCSE. Structure Our candidates are trained to the highest standards and are fully supported to develop all of the knowledge, skills and behaviours required to be an outstanding Learning & Development practitioner. The course duration is typically 18-24 months. Knowledge Our course is delivered via live training webinars with specialist tutors. Skills and Behaviours You will be appointed a designated Learning & Skills Teacher, who will coach you through your qualification and complete regular assessments with you to support you to complete your qualification. You will have weekly contact from your tutor. How we compare with our competitors? Don't just take our word for it, here is what our staff think Bridget I did my course years ago. It was classroom based one night per week. I think I would prefer to be more ‘hands on’ like it is now. Cavity really are a great company to work for. I truly believe that there expertise will ensure the next generation are amazing! Gina I did mine over an apprenticeship but the company my employer used wasn’t great and I didn’t get much support. Although I passed I can only imagine the length that Cavity have gone to to ensure that the students feel supported. As an employee, its super! Enquire Today

Level 3 Learning & Development Practitioner
Delivered OnlineFlexible Dates
£209 to £2,500

Level 2, 3 and 5 HR Training & Development

By Imperial Academy

Level 5 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 150 CPD Points | Lifetime Access

Level 2, 3 and 5 HR Training & Development
Delivered Online On Demand
£100

Advanced DNS for engineers

5.0(3)

By Systems & Network Training

Advanced DNS training course description This two-day hands on DNS training course studies both the UNIX BIND and the Microsoft (MS DNS) implementations. The course follows on from our Definitive DNS for engineers course starting with best practices. The majority of the course is spent on securing DNS and in particular DNSSEC. Some parts are specific to BIND. Students choose whether to use Windows or UNIX for the hands on sessions. What will you learn Implement DNS best practices. Harden DNS servers. Install, configure, maintain and troubleshoot DNSSEC. Advanced DNS training course details Who will benefit: Technical staff wanting to learn DNS including: Network personnel. System administrators. Prerequisites: Total DNS for engineers Duration 2 days Advanced DNS training course contents Best practices MX and PTR records, lame delegations, disallowing recursion, TTLs, online testing. Hands on Review of your DNS servers. Split DNS Partitioning internal and external DNS, views. Hands on Implementing split DNS. Hardening DNS ACLs, recursion, queries, trusted sources, chroot jail, secure BIND template. Hands on Securing the DNS server. DNSSEC What is DNSSEC? DNSSEC benefits, DNSSEC RRs. DNSKEY, RRSIG, NSEC, DS. Hands on Creating DNSSEC keys. Securing zone transfers TSIG, shared secret. Securing DDNS. Hands on Secure file transfers. Zone integrity Trusted anchors, Chains of trust, Zone status, Zone signing, Keys. ZSK, KSK, adding keys to a zone file. Secure delegations. Hands on Zone signing Maintaining Signed zones Key rollover, pre publish, double signing, rollover cache.

Advanced DNS for engineers
Delivered in Internationally or OnlineFlexible Dates
£1,727