33860 Courses in Cardiff delivered Online

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.

One of the most effective healing, relaxing and invigorating technique for both mind and body is without no doubt massage. Massage therapy helps to keep your organs, muscles, tissues and even bones healthy. It also increases blood flow and stimulates the internal body process. In today's world, it has become one of the most common beauty techniques that is preferable by people all around the world. Thus, if you are looking for a way to get in touch with these huge customer base by providing massage therapies, you must become a professional massage therapist. This course is specially design for people just like you. With the help of this online course, you will be able to learn the way of massaging, understand different body parts and how they work. Besides that, you will get to know about different types of massage techniques that can work like medicine for a human body. Finally, you will be able to perform most popular massages and become a professional therapist in no time. Course Highlights Professional Massage Therapist Course is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Professional Massage Therapist Course into 28 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 16 hours, 55 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Professional Massage Therapist Course Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Professional Massage Therapist Course is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Professional Massage Therapist Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Massage Therapist Introduction to Massage Therapy 00:15:00 Massage History 00:15:00 The Role of A Massage Therapist 00:30:00 Tissues, Organs, & Neuromuscular systems 01:00:00 General Benefits of Massage 00:15:00 Indian Head Massage 00:15:00 Facial Massage 00:30:00 Neck Massage 00:30:00 Back Massage 00:15:00 Full Body Massage 00:15:00 Swedish Massage 00:15:00 Sports Massage 00:30:00 LomiLomi Massage 00:15:00 Anti-Cellulite Massage 00:15:00 Hot Stone Massage 00:15:00 Thai Foot Massage 00:15:00 Prenatal Massage 00:15:00 Medical Massage 01:00:00 Baby Massage 01:00:00 Trigger Point Therapy 01:00:00 Thai Massage 01:00:00 Reflexology 01:00:00 How A Massage Therapist Can Start A Business 02:00:00 Marketing Your Business 01:00:00 Complimentary Massages 00:30:00 Building Your Clientele 00:30:00 Other Ways To Market Your Business 01:00:00 Conclusion to Massage 00:15:00 Mock Exam Mock Exam- Professional Massage Therapist Course 00:20:00 Final Exam Final Exam- Professional Massage Therapist Course 00:20:00

This qualification is a MASTERS level Qualification. On completion you will receive the LEVEL 7 DIPLOMA IN STRATEGIC MANAGEMENT AND LEADERSHIP PRACTICE AWARDED BY THE CHARTERED MANAGEMENT INSTITUTE.

[vc_row][vc_column][vc_column_text] Description: Do you work from home or need to make telephone calls for your job? Does your telephone etiquette need improving? This Professional Telephone Receptionist Course is ideal for aspiring receptionists, or telephone receptionists who wish to build their skills for career advancement. Communication and customer service is an essential skill in any industry. Whether face to face or on the phone, being able to communicate professionally is a crucial aspect of any receptionist role. Throughout this telephone receptionist training course, you will learn how to be an effective communicator and will learn fundamental verbal communication techniques.  You will also learn essential time management and telephone skills for communicating with clients and colleagues on the telephone. Different forms of communication will also be explored in this course, and you will also look into the challenges teleworkers face. Whether you're a call centre agent or professional receptionist, you will be a communication expert and more confident person on completion of this communication skills training course. Who is the course for? Home-based receptionist and any communication or administrative specialists who need to learn how to become expert or professional with their telephone communication skills. People who have an interest in learning how to become their own professional receptionist. 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: The Professional Telephone Receptionist Course is a useful qualification to possess, and would be beneficial for the following careers: Call Center Agent Contact Operator Customer Service Representative Home-based Professional Information Center Expert Telemarketer and telesales Telephone Researcher [/vc_column_text][/vc_column][/vc_row] Professional Telephone Receptionist Course Module One - Getting Started 00:30:00 Module Two - Core Skills Required 01:00:00 Module Three - Self-Management (I) 01:00:00 Module Four - Self-Management (II) 01:00:00 Module Five - Time Management (I) 01:00:00 Module Six - Time Management (II) 01:00:00 Module Seven - Organizing and Planning (I) 01:00:00 Module Eight - Organizing and Planning (II) 01:00:00 Module Nine - Communication (I) 01:00:00 Module Ten - Communication (II) 01:00:00 Module Eleven - Additional Challenges 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Professional Telephone Receptionist Course - Activities 00:00:00 Mock Exam Mock Exam- Professional Telephone Receptionist Course 00:20:00 Final Exam Final Exam- Professional Telephone Receptionist Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

[vc_row][vc_column][vc_column_text] Description: Public speaking is a distinct performance where someone delivers a speech to an audience. Performing a speech can have general purposes, depending on what the event it is about. It could be a speech on informing, persuading, or entertaining your audience. If you are someone who is struggling or just interested in giving professional public speeches, then this Professional Public Speaking course will help you learn. You will know all the public speaking basics and techniques to become a successful public speaker. You will acquire the communication skills you need and learn how to be confident in giving public speeches. Who is the course for? Professionals who want to learn how to communicate effectively through public speaking Anyone who needs to learn how to communicate through public speaking. Entry Requirement: This Professional Public Speaking 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 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: The Professional Public Speaking Course will be very beneficial and helpful to professionals, especially to the following careers: Marketing and Promotions Specialist Marketing Manager Sales Manager Sales and Promotions Specialist Supervisor Top Executive. [/vc_column_text][/vc_column][/vc_row] Public Speaking Basics Module One - Getting Started 00:30:00 Module Two - Identifying Your Audience 01:00:00 Module Three - Creating a Basic Outline 00:30:00 Module Four - Organizing the Program 00:30:00 Module Five - Fleshing It Out 00:30:00 Module Six - Putting It All Together 01:00:00 Module Seven - Being Prepared 00:30:00 Module Eight - Overcoming Nervousness 01:00:00 Module Nine - Delivering Your Speech (I) 01:00:00 Module Ten - Delivering Your Speech (II) 00:30:00 Module Eleven - Questions and Answers 00:30:00 Module Twelve - Wrapping Up 00:30:00 Activities 00:00:00 Public Speaking Techniques Introducing Public Speaking 01:00:00 Public Speaking and The Speakers 01:00:00 Getting Started: The First Speech 01:00:00 Raise The Confidence 01:00:00 Overcome Your Fear 01:00:00 Select The Topic 01:00:00 Analyze The Audience 01:00:00 Organize The Speech 01:00:00 Outline The Speech 00:30:00 Prepare The Visual Aids Effectively 00:30:00 Deliver The Message Effectively 01:00:00 Short Questions with Answers 00:30:00 Becoming a Successful Public Speaker Public Speaking Basics 01:00:00 Know Your Audience 00:30:00 Use The Right Words 00:30:00 Decide What You Want To Convey 00:30:00 Learn How to Communicate 00:30:00 What Happens If Your Don't Connect to Your Audience 00:30:00 Wrapping Up 00:15:00 Overcoming the Fear Good Communication Skills 00:15:00 Interpersonal Skills 00:30:00 Getting Comfortable in Conversation 00:30:00 Redesigning Yourself for Strength 00:30:00 Professionalism 00:15:00 Maximizing Meetings 00:15:00 Controlling Nervousness 00:15:00 Mock Exam Mock Exam- Professional Public Speaking Course 00:30:00 Final Exam Final Exam- Professional Public Speaking Course 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com

Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. For more queries, reach out to us: info@mangates.com