9084 Instructor courses

If you are looking forward to building your graphic design portfolio, then you are at the right place. This course consists of 12 plus hours of premium content that will help you build 40+ projects, which you can later add to your portfolio. You are going to design Facebook ads, Instagram posts, newsletters, YouTube thumbnails, CVs, and much more with the help of Photoshop. You need to be familiar with the basics of Photoshop to get started.

Unlock the secrets of optimal nutrition with the 'Nutrition Masterclass: Build Your Perfect Diet & Meal Plan.' This comprehensive course takes you on a journey towards a healthier lifestyle, creatively blending nutrition science with practical applications. Explore the world of nutritional yeast, Zoe Nutrition, and Optimum Nutrition Whey Protein as you embark on this enlightening educational adventure. Learning Outcomes: Gain a deep understanding of nutrition principles and how they apply to your daily life. Create personalized meal plans that cater to your unique dietary needs and goals. Explore the benefits and uses of nutritional yeast and Optimum Nutrition Whey Protein. Navigate common dieting trends, making informed choices for your well-being. Develop a holistic approach to healthy eating, focusing on macro and micronutrients. Why buy this Nutrition Masterclass: Build Your Perfect Diet & Meal Plan? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Nutrition Masterclass: Build Your Perfect Diet & Meal Plan there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Nutrition Masterclass: Build Your Perfect Diet & Meal Plan for? Health enthusiasts looking to optimise their diets for better wellness. Individuals seeking to lose weight or gain muscle through nutrition. Anyone curious about the role of supplements in their daily routine. Those interested in understanding and demystifying dieting trends. Aspiring nutritionists or wellness coaches eager to expand their knowledge. Prerequisites This Nutrition Masterclass: Build Your Perfect Diet & Meal Plan does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Nutrition Masterclass: Build Your Perfect Diet & Meal Plan was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Nutrition Consultant: £25,000 - £40,000 per annum Dietitian: £30,000 - £45,000 per annum Personal Trainer specialising in nutrition: £20,000 - £35,000 per annum Health Coach: £25,000 - £35,000 per annum Food Blogger/Influencer: Varies widely Wellness Educator: £25,000 - £40,000 per annum Course Curriculum Introduction Welcome To The Course & What You Will Learn 00:04:00 Get to Know Your Instructor 00:03:00 Meal Planning Basics Meal Planning Explained 00:04:00 Calories Explained 00:04:00 Micronutrients Introduction 00:01:00 Protein Explained 00:02:00 How much protein do you need to consume per day 00:04:00 Fats explained 00:03:00 How Much Fat Should You Eat Per Day 00:04:00 Carbohydrate Explained 00:03:00 Macronutrients Explained 00:01:00 The Different Types of carbs 00:05:00 How Much Carbs should you eat per day 00:03:00 Meal Timing Intro 2 copy 00:01:00 Protein Timing 00:04:00 Carbohydrate Timing 00:02:00 Fat Timing 00:01:00 Pre-Workout Meal 00:04:00 Post Workout Meal 00:02:00 What About the Anabolic Window 00:01:00 Food Composition Introduction 2 copy 00:02:00 Protein Composition 00:02:00 Carbohydrate Composition 00:03:00 Fat Composition 00:01:00 Supplements Top 3 Beginner Supplements 00:04:00 How to Use Protein Powder When, How Much & With What 00:06:00 How to Use Creatine When,How Much & With What 00:04:00 Other Supplements to consider 00:05:00 Setting Up Your Diet How To Determin Your Optimal Calorie Intake 2 00:03:00 How to Track Calories 00:05:00 Determining Protein Intake 00:01:00 Determining Fat Intake 00:01:00 What About the Ramaining Calories 00:02:00 Determining Meal Structure 00:03:00 Quality Protein Sources 00:01:00 Quality Carbs Sources 00:01:00 Quality Sources Of Fat 00:01:00 Adjusting Your Diet For Weight Loss & Muscle Gains Adjusting You Diet For Weight Gain 00:04:00 Adjusting Your Diet For Weight Loss 00:05:00 Cheat Days and Cheat Meals 00:05:00 Post Workout Shake 00:02:00 Healthy Dieting Healthy Dieting Intro copy 00:01:00 Dieting myth #1 Carbs are bad for you 00:02:00 Dieting Myth #2 Fat is bad for you 00:02:00 Dieting Myth #3 Protein is bad for you 00:04:00 Dieting Myth #5 Avoid Salt At All Cost 00:01:00 Dieting Myth #6 Eat several small meals throughout the day to lose weight 00:01:00 Dieting Myth #7 Diet Foods Will Lead To Weight Loss 00:01:00 Red Meat Always Causes Cancer 00:03:00 Common Dieting Trends Explained Common Diets Intro Copy 00:01:00 Gluten Free Diet Explained 00:03:00 Paleo Diet Explained 00:04:00 Low Carb Diet Explained 00:03:00 Intermittend Fasting Explained 00:03:00 Vegan Diet Explained 00:05:00 Micronutrients Micronutrients Introduction 00:01:00 Vitamin A 00:02:00 Vitamin B 00:01:00 Vitamin C 00:01:00 Vitamin D 00:02:00 Vitmain E 00:01:00 Vitamin K 00:01:00 Calcium 00:02:00 Magnesium 00:01:00 Phosphorus 00:01:00 Potassium 00:01:00 Sodium 00:01:00 Copper 00:01:00 Iron 00:01:00 Zinc 00:02:00 Water 00:04:00 More Dieting Tips & Strategies Intro Specific dieting tips and strategies 00:01:00 5 Best Supplements to Boost Your Immune System 00:04:00 How to Read a Nutrition Label 00:03:00 How to Do You Own Research 00:04:00

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.

Empower your career with Sage 50 Payroll! Master efficient payroll management, HR tasks, auto-enrolment. Boost your skills, become a sought-after professional!

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.

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

Craft 3D jewellery on this one day intermediate silver clay boxes and beads class in Edinburgh City Centre