8497 Instructor courses 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 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 three-day instructor-led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis in other words, making meaning from the data rather than transaction-oriented data-tier application development. The course starts with a brief discussion of levels of measurement and quantitative research methodogy, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path from RDBMS data retrieval through analytical tools such as SQL Server Reporting Services, PowerBI, Excel, R, SAS, and SPSS. Module 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 Module 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 Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSSJOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNERJOIN Understanding Joins, Part 3: The OUTERJOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTERJOINs Combining JOIN Operations with WHERE and ORDER BY Module 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 Module 5: Subqueries, Derived Tables and Common Table Expressions Non-correlated and correlated subqueries Derived tables Common table expressions Module 6: Encapsulating Data Retrieval Logic Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Module 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 Additional course details: Nexus Humans 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 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.

Duration 1 Days 6 CPD hours This course is intended for This course is intended for the following participants: Individuals planning to deploy applications and create application environments on Google Cloud Platform Developers, systems operations professionals, and solution architects getting started with Google Cloud Platform Executives and business decision makers evaluating the potential of Google Cloud Platform to address their business needs. Overview This course teaches participants the following skills: Identify Google Cloud counterparts for Azure IaaS, Azure PaaS, Azure SQL, Azure Blob Storage, Azure Application Insights, and Azure Data Lake Configure accounts, billing, projects, networks, subnets, firewalls, VMs, disks, auto scaling, load balancing,storage, databases, IAM, and more Manage and monitor applications Explain feature and pricing model differences This 1-day instructor led course introduces Azure professionals to the core capabilities of Google Cloud in the four technology pillars: networking, compute, storage, and database. It is designed for Azure system administrators, Solution Architects and SysOps Administrators familiar with Azure features and setup; and want to gain experience configuring Google Cloud products immediately. With presentations, demos, and hands-on labs, participants get details of similarities, differences, and initial how-tos quickly. Introducing Google Cloud Explain the advantages of Google Cloud. Define the components of Google's network infrastructure, including: Points of presence, data centers, regions, and zones. Understand the difference between Infrastructure-as-a-Service (IaaS) and Platform-as-a-Service (PaaS). Getting Started with Google Cloud Identify the purpose of projects on Google Cloud. Understand how Azure's resource hierarchy differs from Google Cloud's Understand the purpose of and use cases for Identity and Access Management. Understand how Azure AD differs from Google Cloud IAM. List the methods of interacting with Google Cloud. Launch a solution using Cloud Marketplace. Virtual Machines in the Cloud Identify the purpose and use cases for Google Compute Engine Understand the basics of networking in Google Cloud. Understand how Azure VPC differs from Google VPC. Understand the similarities and differences between Azure VM and Google Compute Engine. Understand how typical approaches to load-balancing in Google Cloud differ from those in Azure. Deploy applications using Google Compute Engine Storage in the Cloud Understand the purpose of and use cases for: Cloud Storage, Cloud SQL, Cloud Bigtable and Cloud Datastore. Understand how Azure Blob compares to Cloud Storage. Compare Google Cloud?s managed database services with Azure SQL. Learn how to choose among the various storage options on Google Cloud. Load data from Cloud Storage into BigQuery Containers in the Cloud Define the concept of a container and identify uses for containers. Identify the purpose of and use cases for Google Container Engine and Kubernetes. Understand how Azure Kubernetes Service differs from from Google Kubernetes Engine. Provision a Kubernetes cluster using Kubernetes Engine. Deploy and manage Docker containers using kubectl Applications in the Cloud Understand the purpose of and use cases for Google App Engine. Contrast the App Engine Standard environment with the App Engine Flexible environment. Understand how App Engine differs from Azure App Service. Understand the purpose of and use cases for Google Cloud Endpoints. Developing, Deploying and Monitoring in the Cloud Understand options for software developers to host their source code. Understand the purpose of template-based creation and management of resources. Understand how Google Cloud Deployment Manager differs from Azure Resource Manager. Understand the purpose of integrated monitoring, alerting, and debugging Understand how Google Monitoring differs from Azure Application Insights and Azure Log Analytics. Create a Deployment Manager deployment. Update a Deployment Manager deployment. View the load on a VM instance using Google Monitoring. Big Data and Machine Learning in the Cloud Understand the purpose of and use cases for the products and services in the Google Cloud big data and machine learning platforms. Understand how Google Cloud BigQuery differs from Azure Data Lake. Understand how Google Cloud Pub/Sub differs from Azure Event Hubs and Service Bus. Understand how Google Cloud?s machine-learning APIs differ from Azure's. Load data into BigQuery from Cloud Storage. Perform queries using BigQuery to gain insight into data Summary and Review Review the products that make up Google Cloud and remember how to choose among them Understand next steps for training and certification Understand, at a high level, the process of migrating from Azure to Google Cloud.

Fans of Taylor Swift, Lady Gaga or Michael Jackson will be pleased to attend our fantastic pop singing courses offered in a relaxed and non-judgmental environment. Sing your favourite songs while improving your vocal abilities immensely. Open to adults from beginners to advanced.

Enjoy our outstanding blues singing courses for adults and develop the blues growl used by Bessie Smith, Big Bill Broonzy or Little Richard. Discover amazing vocal techniques that will make your blues feel authentic and enhance your vocal abilities under the tutoring of experts.

Level 4 QLS Endorsed Diploma | 120 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

This is a comprehensive course designed to provide a solid foundation in web development principles and practices. This course is intentionally structured to provide a technical understanding of web development concepts without delving into intricate implementation details. Anyone looking to better understand how web applications are built can take this course.

Personal Trainer : Personal Trainer Online Training Are you ready to advance your fitness career by becoming a certified personal trainer? It would be the perfect place for you to start your journey with us. Our Personal Trainer : Personal Trainer course is approved and recognised in the fitness industry, ensuring that you obtain a high-quality education. They boost your learning experience by bringing a wealth of expertise and practical knowledge to the Personal Trainer : Personal Trainer course. Throughout our Personal Trainer : Personal Trainer course, you will gain a deep understanding of anatomy, physiology, exercise science, and nutrition. With this Personal Trainer : Personal Trainer course you will learn how to guide clients towards achieving their fitness goals and promoting a healthy lifestyle by doing our Personal Trainer : Personal Trainer course. The Personal Trainer : Personal Trainer course provides effective feedback and assistance, ensuring you obtain the direction you need to flourish in your studies and future job as a Personal trainer. Main Course: Personal trainer Free Courses are including with this Personal trainer: Personal trainer Course Along with The Personal trainer: Personal trainer Course, We Offer a free Gym InstructorCourse Along with The Personal trainer: Personal trainer Course, We Offer a free Diploma in Sports Nutrition Course Special Offers of this Personal trainer: Personal trainer Training Course This Personal trainer: Personal trainer Course includes a FREE PDF Certificate. Lifetime access to this Personal trainer: Personal trainer Course Instant access to this Personal trainer: Personal trainer Course Get FREE Tutor Support to this Personal trainer: Personal trainer Course Personal Trainer : Personal Trainer Online Training Our Comprehensive Personal Trainer : Personal Trainer Certification Course also provides you with the knowledge and skills required to become an excellent personal trainer. The Personal Trainer : Personal Trainer course also offers a transformative learning experience that encourages you to make a positive impact on the lives of your future clients. Don’t delay! Enrol in our Personal Trainer : Personal Trainer course now! Who is this course for? Personal Trainer : Personal Trainer Online Training The Personal Trainer : Personal Trainer course is perfect for those who are really interested in fitness and wish to share their enthusiasm with others. This Personal Trainer : Personal Trainer course is suitable for anyone who wants to make a career in this field. Requirements Personal Trainer : Personal Trainer Online Training To enrol in this Personal Trainer : Personal Trainer Course, students must fulfil the following requirements. To join in our Personal Trainer : Personal Trainer course, you must have a strong command of the English language. To successfully complete our Personal Trainer : Personal Trainer course, you must be vivacious and self driven. To complete our Personal Trainer : Personal Trainer course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Personal Trainer : Personal Trainer course. Career path Personal Trainer : Personal Trainer Completing the Comprehensive Personal Trainer: Personal Trainer Certification Course will offer you a plethora of interesting and gratifying employment prospects in the fitness sector.

If you love dogs and want to turn that passion into a profession, this is your moment. The Dog Training: Dog Agility bundle is more than just pet knowledge — it’s your launchpad into one of the most heartwarming, fast-growing service industries out there. From dog walkers to animal therapists, from agility instructors to grooming assistants — employers want versatile professionals. This 20-course bundle was designed to make you just that. Description Dog training is no longer just a hobby — it’s a career path. And the professionals who stand out are those who bring more to the table than just pet handling. That’s where this all-in-one bundle comes in. With courses crossing training, grooming, public health, and communication, this isn’t just a skills upgrade — it’s a career toolkit. Whether you’re aiming for a role at a kennel, working with a veterinary team, or offering private dog agility sessions, these credentials show you mean business. You’ll also benefit from training in people skills — because dog professionals don’t just work with pets; they deal with clients, teams, and the public every day. It’s a comprehensive, CV-polishing, value-packed set. And the demand for trained, confident dog professionals has never been higher. The clock’s ticking — will someone else take the job meant for you? FAQ What kinds of jobs does this apply to? Dog trainer, agility instructor, kennel assistant, pet groomer, animal care worker, dog walker, veterinary support, and more. Do I need a background in dog care? No. Beginners and career-switchers are welcome. Is this suitable for freelance or employed roles? Both. The skills apply across pet businesses, vet clinics, shelters, and private services. Will this help me get hired? Yes. It focuses on the skills and credentials employers and clients look for. How long do I have access? You get full access with no time pressure — learn at your own pace. Is this good value? Incredible value. You’re getting 20 job-relevant courses for a fraction of the cost of in-person training.

Lean Six Sigma is a methodology used by project managers worldwide to streamline the business process. It works by breaking down the workflow into manageable stages, improving quality of service, reducing waste and optimising resources. In the Six Sigma and Lean Process, you will learn how to apply the Lean Six framework for your organisation, with step-by-step guidance. In this Lean Six Sigma training program, you will be introduced to improvement tools and techniques that are designed to help you plan and problem-solve more efficiently. Whether you are an aspiring Project Manager or want to take your expertise to the next level, our experienced instructor will walk you through key methodologies proven to drive business performance and enhance customer value in no time. Who is this Course for? This Six Sigma and Lean Process course is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. 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. Method of Assessment: Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Course Curriculum Six Sigma and Lean Process - Updated Version Module 1: Understanding Lean 00:24:00 Module 2: The Lean Culture 00:20:00 Module 3: The Five Principles of Lean 00:11:00 Module 4: Value and Waste 00:20:00 Module 5: Value Stream Mapping (VSM) 00:20:00 Module 6: The Principles of Flow and Pull 00:15:00 Module 7: Overview of Six Sigma 00:12:00 Module 8: The Define Phase 00:19:00 Module 9: The Measure Phase 00:22:00 Module 10: The Analyse Phase 00:23:00 Module 11: The Improve Phase 00:22:00 Module 12: The Control Phase 00:15:00 Six Sigma and Lean Process - Old Version Lean Process Module One - Getting Started 00:30:00 Module Two - Understanding Lean 01:00:00 Module Three - Liker's Toyota Way 01:00:00 Module Four - The TPS House 01:00:00 Module Five - The Five Principles of Lean Business 01:00:00 Module Six - The First Improvement Concept (Value) 01:00:00 Module Seven - The Second Improvement Concept (Waste) 01:00:00 Module Eight - The Third Improvement Concept (Variation) 01:00:00 Module Nine - The Fourth Improvement Concept (Complexity) 01:00:00 Module Ten - The Fifth Improvement Concept (Continuous Improvement) 01:00:00 Module Eleven - The Improvement Toolkit 00:30:00 Module Twelve - Wrapping Up 01:30:00 Six Sigma Six Sigma Basics 00:15:00 Improvement Tools 00:30:00 Management Tools for Generating Ideas 00:15:00 Continuous Improvement 00:30:00 Customer Relationships 00:30:00 Mock Exam Mock Exam - Six Sigma and Lean Process 00:20:00 Final Exam Final Exam - Six Sigma and Lean Process 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Elevate your career with the Mastering Medical Teaching Mini Bundle, your essential gateway to becoming a sought-after professional in medical education and healthcare training. Whether you’re aiming for roles in hospitals, training centres, or community health organisations, this bundle is packed with the right skills to make you hireable. Featuring Nursing, Paramedic Training, Counselling, Healthcare, and First Aid, these core areas place you at the forefront of medical teaching careers where demand continues to grow. Don’t miss your chance to stand out with a skill set employers actively search for—grab this bundle now before the competition does. Description In today’s healthcare landscape, expertise in Nursing, Paramedic Training, Counselling, Healthcare, and First Aid is indispensable for medical teaching professionals. Nursing forms the foundation of compassionate patient care and clinical knowledge that every medical educator needs. Paired with Paramedic Training, this bundle prepares you to train others in emergency and critical care, two of the most urgent and highly valued healthcare sectors. Counselling skills provide the essential emotional intelligence and communication techniques that healthcare educators rely on to support both patients and learners. Healthcare expertise ensures you have a broad understanding of medical systems and patient management, making your teaching well-rounded and effective. Meanwhile, First Aid remains a fundamental skill, essential for anyone involved in healthcare education, guaranteeing you’re prepared to teach life-saving interventions. This bundle seamlessly integrates Nursing, Paramedic Training, Counselling, Healthcare, and First Aid, aligning your profile with exactly what employers demand in medical teaching roles. The value is unmatched—gain comprehensive, job-relevant skills in one cost-effective package and step confidently into your next career chapter. FAQ Q: What careers can this bundle prepare me for? A: Medical Educator, Nursing Trainer, Paramedic Instructor, Healthcare Trainer, Counselling Facilitator, First Aid Instructor. Q: Why is Nursing so important in medical teaching? A: Nursing provides the clinical expertise and compassionate care foundation critical for training healthcare staff. Q: How does Paramedic Training add value? A: It equips you to teach emergency response and critical care—high-demand areas in healthcare education. Q: What role does Counselling play in this bundle? A: Counselling enhances communication and emotional support skills, essential for effective teaching. Q: Is Healthcare knowledge necessary for teaching? A: Absolutely. It ensures you understand healthcare systems and patient care holistically. Q: Why include First Aid? A: First Aid is a universal skill crucial to all healthcare teaching programs. Q: Is this bundle suitable for newcomers and experienced professionals? A: Yes. It’s designed to benefit career starters and seasoned healthcare educators alike. Q: Is this bundle cost-effective? A: Definitely. You get five essential, job-focused skills in one affordable training package.