5432 Courses in Cardiff delivered Live Online

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

Duration 1 Days 6 CPD hours This course is intended for The typical students of this course will be business professionals who want to enhance their communication skills to interact more effectively with superiors, colleagues, team members, customers, and vendors, and ultimately improve their overall job performance. Overview Interact productively with others in the workplace on a day-to-day basis. Build positive relationships with diverse individuals. Consider organizational communication systems. Communicate with peers. Communicate with supervisors. Communicate with external people. Communicate during conflict and change. To be successful in the workplace, you must be able to effectively communicate and cooperate with coworkers and external people. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. Prerequisites To ensure your success in this course, you should have some level of work experience in any of a variety of organizational settings. 1. Interacting with Others Topic A- Understand the Communication Process Topic B- Apply Core Communication Skills Topic C- Observe Nonverbal Communication 2. Building Positive Relationships Topic A- Create Connection Topic B- Adapt Appropriately to Different Communication Styles Topic C- Accommodate Diversity 3. Considering Organizational Communication Systems Topic A- Analyze Organizational Culture Topic B- Ensure Communication Flows Effectively 4. Communicating with Peers Topic A- Interact Effectively with Peers Topic B- Work Productively in a Group Topic C- Engage in Productive Meetings Topic D- Lead a Team 5. Communicating with Supervisors Topic A- Communicate with Different Supervisor Styles Topic B- Discuss Important Topics with Your Supervisor 6. Communicating with External People Topic A- Interact Effectively with Customers Topic B- Work Productively with Vendors 7. Communicating During Conflict and Change Topic A- Communicate Through Conflict Topic B- Communicate Through Change Additional course details: Nexus Humans Effective Interpersonal Communication for Business Professionals 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 Effective Interpersonal Communication for Business Professionals 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.

Arm yourself with a robust research toolkit that will help you uncover deep behavioural insights on user needs and motivations so you can design better experiences.

ARE YOU READY TO ADVANCE YOUR GRAPHIC DESIGN SKILLS?

Learn how to establish deliberate and creative interactions that allow users to navigate a platform in the ways that makes sense to them.

Registration starts at 7:30 AM. The training will begin promptly at 8:00 AM. Please plan your arrival accordingly to ensure you don't miss any important information. Reduce Emissions, Save Costs, Earn a CPC Hours, and Ensure Full Compliance Topics Covered: FORS Lo-CITY Driver Training (3.5 hours): • Relationship between driving style, fuel consumption, and environmental impact • Benefits of regular vehicle maintenance and checks • Fuel-efficient driving techniques • Utilising in-vehicle technology for fuel economy • Benefits of journey planning • Alternative fuels for commercial vehicles Highway Code Training Content: Course introduction, objectives, and expectations. Introduction to the Highway Code and its relevance. Types of road users and training for various groups. Respecting and understanding the risks to different road user categories. Confirmation of knowledge quizzes covering all aspects of the Highway Code and traffic regulations. Course Details: Format: Remote Session (7 hours) CPC Hours: Yes Cost: £89.50 - Includes course fee, Driver CPC Upload fee, VAT This award-winning program (awarded the prestigious Education in Transport award at the 2017 National Courier Awards) is perfect for any fleet operator looking to: Meet FORS Gold accreditation requirements. Improve driver performance and fuel efficiency. Reduce their environmental footprint. Enhance corporate social responsibility. Please note that this course is delivered online and provides 7 hours of Driver CPC training. Ready to get started? Book online or feel free to contact our training department at training@totalcompliance.co.uk or call 0345 9001312 to register for this valuable course. Please review our Terms and Conditions for more information.

Arm yourself with a robust research toolkit that will help you uncover deep behavioural insights on user needs and motivations so you can design better experiences.

BOHS P304 is designed to give practical guidance on assessing the health risks caused by hazardous substances, in order to meet the requirements of the Control of Substances Hazardous to Health (COSHH) Regulations 2002 for a 'suitable and sufficient' risk assessment.

BOHS P304 is designed to give practical guidance on assessing the health risks caused by hazardous substances, in order to meet the requirements of the Control of Substances Hazardous to Health (COSHH) Regulations 2002 for a 'suitable and sufficient' risk assessment.

Course Objectives At the end of this course you will be able to: Customise tables and charts Customise formatting with styles and themes Modify pictures in a document Create customised graphic elements Insert content using Quick Parts Control text flow Use templates to automate document creation Perform mail merges Use macros to automate common tasks '1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk Customer Feedback Excelent enviroment for training. Tahnk you. Jenny Price - ACER ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Working with Tables and Charts Sort Table Data Control Cell Layout Perform Calculations in a Table Create a Chart Customising Formats Using Styles and Themes Create and Modify Text Styles Create Custom List or Table Styles Apply Document Themes Using Images in a Document Resize an Image Adjust Image Appearance Integrate Pictures and Text Insert and Format Screenshots Use the Snipping tool Creating Custom Graphic Elements Create Text Boxes and Pull Quotes Draw Shapes Add WordArt and Other Text Effects Create Complex Illustrations with SmartArt Inserting Content Using Quick Parts Insert Building Blocks Create and Modify Building Blocks Insert Fields Using Quick Parts Controlling Text Flow Control Paragraph Flow Insert Section Breaks Insert Columns Link Text Boxes to Control Text Flow Using Templates Create a Document Using a Template Create a Template Using Mail Merge The Mail Merge Features Merge Envelopes and Labels Create a Data Source Using Word Using Macros Automate Tasks Using Macros Create a Macro Who is this course for? Who is this course for? This course is designed for users who to create or modify complex business documents as well as customised Word efficiency tools Requirements Requirements Preferably, delegates should have attended the Word Introduction course. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included