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

43970 PE courses

GraphQL with NodeJs: Beginner to Advanced

4.3(43)

By John Academy

Description GraphQL is a query and manipulation language of API that accomplishes queries with existing data. It is alternative to REST that is maintained by people, community, companies, and individuals across the world. To know more details about it, look at the GraphQL with NodeJs: Beginner to Advanced course. It will guide you further in your quest to regard this topic. The contents of this course will assist you to learn its basic to advance functions knowing how to start with GraphQL and NodeJs, do CURD Operations with NodeJs, MongoDB, and GraphQL, and fragment, union, and interfaces with GraphQL. The GraphQL with NodeJs: Beginner to Advanced course will assist you to learn how to set page number, make caching and batching, filtering, sorting and to know about the subscription and data loaders in GraphQL. It also enables you to test the data authentication and authorization with Jest in MngoDB, NodeJs, and GraphQL. The purpose of the course is to make you efficient in this field providing with all required information must. Learn vibrantly with the help of this course. Certification: After completing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? GraphQL with NodeJs: Beginner to Advanced is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our GraphQL with NodeJs: Beginner to Advanced 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Getting Started Create Express Server in NodeJs FREE 00:04:00 Create GraphQL Server using express 00:08:00 Understand GraphQL Resolver Arguments 00:03:00 Connect GraphQL App with MongoDB using Mongoose 00:04:00 CURD(Create, Read,Update,Delete) Operations with Nodejs, GraphQL, and MongoDB Create Record in MongoDB Using GraphQL Mutation 00:06:00 Get Records From MongoDB Using GraphQL Query 00:02:00 Update Records From MongoDB Using GraphQL Mutation 00:02:00 Delete Record From MongoDB Using GraphQL Mutation 00:02:00 Authentication and Authorization in GraphQL, Nodejs and MongoDB Create GraphQL Server with GraphQL Yoga 00:03:00 Split up your schema definition, resolvers, and Query type into multiple files 00:07:00 Create a Mongoose User model for Authentication in GraphQL 00:03:00 Register and Encrypt User Data and Return JWT Payload with Graph 00:07:00 Operations and Variables in GraphQL 00:02:00 Validate Input in GraphQL with Joi 00:04:00 Authenticate a User using a JSON Web Token in GraphQL 00:03:00 Merge GraphQL Resolvers into a Single Object using lodash.merge 00:02:00 Create a Middleware for Authentication in GraphQL 00:07:00 Apply Authentication Middleware on GraphQL Resolvers 00:03:00 Create Nested Resolvers to remove duplicate code from individual 00:07:00 Pagination, Filtering, And Sorting in GraphQL Paginate List of Data in GraphQL 00:04:00 Filter Nodes with Matching Rule GraphQL Queries 00:03:00 Sort GraphQL Query Results by Field 00:02:00 Cursor Based Pagination 00:09:00 Fragments, Interfaces, and Unions in GraphQL Send Multiple Queries in a Single Request using Aliases in GraphQL 00:02:00 Enhancing Fields Reusability with Fragments in GraphQL 00:02:00 Create Enum to represents a collection of related values 00:03:00 Create an Interface to represent the reusable fields in GraphQL 00:06:00 Interface Demo with - ResolveType 00:05:00 Create Union to return more than object type from GraphQL field 00:11:00 Subscriptions and DataLoaders in GraphQL Introduction to Subscriptions 00:01:00 Adding real-time functionality with GraphQL Subscriptions 00:06:00 Why Data Loaders in GraphQL 00:02:00 Create DataLoader in GraphQL 00:05:00 Batching in GraphQL 00:05:00 Caching in GraphQL 00:03:00 Testing with Jest in GraphQL and NodeJs Integrate Jest Testing Framework with GraphQL, and NodeJs 00:05:00 Write Unit test for Resolvers in GraphQL 00:04:00 Write Integration Test for Queries And Mutations in GraphQL 00:04:00 Order your Certificate Order Your Certificate 00:00:00

GraphQL with NodeJs: Beginner to Advanced
Delivered Online On Demand2 hours 41 minutes
£11.99

Microsoft PowerPoint 2010 Complete Course- Beginners, Intermediate & Advanced

4.3(43)

By John Academy

Description: Microsoft PowerPoint is considered as the most powerful presentation for presenting visual and graphical items. This program can help you to create handouts and even developing an animated presentation with audio. Through this course, you will know you will learn all the skills, knowledge, and information about the PowerPoint software that you can use for your work. You will learn all the available presentation tasks such as inserting slides from other presentation or even recording your show as videos. All of these tasks and features, whether it's for beginners, intermediate, or advanced level users, are beneficial for your career for any activity you could think of. Who is the course for? Professionals who want to learn about Microsoft PowerPoint 2010 functions and tools. People who have an interest in knowing all about Microsoft PowerPoint 2010 features. 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 hardcopy 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 recognised 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 Microsoft PowerPoint 2010 complete course would be beneficial for any professions or career from any industry you are in, such as: Administrative Assistant Administrator Manager Office Staff Personal Assistant Secretary. Microsoft PowerPoint 2010 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing PowerPoint 00:30:00 Module Three - Working with Presentations 00:30:00 Module Four - Your First Presentation 01:00:00 Module Five - Working with Text 00:30:00 Module Six - Formatting Text 00:30:00 Module Seven - Formatting Paragraphs 01:00:00 Module Eight - Advanced Formatting Tasks 00:30:00 Module Nine - Customizing Slide Elements 01:00:00 Module Ten - Setting Up Your Slide Show 00:30:00 Module Eleven - Showtime 01:00:00 Module Twelve - Wrapping Up 01:00:00 Activities-Microsoft PowerPoint 2010 for Beginners 00:00:00 Microsoft PowerPoint 2010 Intermediate Level Module One - Getting Started 00:30:00 Module Two - Working with the PowerPoint Environment 01:00:00 Module Three - Working with Presentations 01:00:00 Module Four - Formatting Presentations 01:00:00 Module Five - Formatting Text Boxes 01:00:00 Module Six - Creating a Photo Album 01:00:00 Module Seven - Working with Graphical Elements 01:00:00 Module Eight - Working with Audio and Video Content 01:00:00 Module Nine - Working with Transitions and Animations 01:00:00 Module Ten - Collaborating on Presentations 01:00:00 Module Eleven - Delivering Presentations 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft PowerPoint 2010 Intermediate Level 00:00:00 Microsoft PowerPoint 2010 Advanced Level Module One - Getting Started 00:30:00 Module Two - Adding Pictures 01:00:00 Module Three - Working with Text Boxes 01:00:00 Module Four - Adding SmartArt 01:00:00 Module Five - Adding Tables 01:00:00 Module Six - Inserting Advanced Objects 01:00:00 Module Seven - Advanced Drawing Tasks 01:00:00 Module Eight - PowerPoint's Research Tools 01:00:00 Module Nine - Creating Notes and Handouts 01:00:00 Module Ten - Using Slide Masters 01:00:00 Module Eleven - Advanced Presentation Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft PowerPoint 2010 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft PowerPoint 2010 Complete Course- Beginners, Intermediate, Advanced 00:30:00 Final Exam Final Exam- Microsoft PowerPoint 2010 Complete Course- Beginners, Intermediate, Advanced 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Microsoft PowerPoint 2010 Complete Course- Beginners, Intermediate & Advanced
Delivered Online On Demand32 hours
£11.99

Oracle 11g PL/SQL Intermediate

4.3(43)

By John Academy

Description The Oracle Database server composes PL/SQL units and stores it in the database. Mainly, PL/SQL functions to hold to hold SQL declaration within its sentence structure. Do you want to know more about SL/SQL function? How does it bring optimal proficiency in 'procedural language'? if so, take a look at the Oracle 11g PL/SQL Intermediate course. It will assist you in understanding all you need to know about Oracle 11g PL/SQL. The course designs to help the learners to know its function incorporation with different strings, numbers, table row record, and error management. The Oracle 11g PL/SQL Intermediate course teaches the fundamental form and structure of the program unit saved within database, creating and managing stored methods, functions, packaged programs, and database prompts. Its contents aim to take you further in your quest to teach the effective methods including variables and cursor expressions. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Oracle 11g PL/SQL Intermediate is certified by CPD Qualifications Standards and CiQ. 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 background. Requirements Our Oracle 11g PL/SQL Intermediate 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:03:00 Preparing Your Environment Install Oracle XE 00:11:00 SQL Developer Installation 00:20:00 Workstation Setup 00:12:00 Database Program Units Introducing the Database Program Unit 00:19:00 Working with Stored Procedures and Functions Creating Stored Procedures and Functions 00:19:00 Understanding the Parameter Specification 00:23:00 Executing Procedures and Functions 00:26:00 Calling Functions from within SQL 00:13:00 Handling Compilation Errors 00:08:00 Maintaining Stored Procedures and Functions Recompiling and Dropping Programs 00:16:00 Data Dictionary Storage 00:25:00 Managing Dependencies 00:13:00 Tracking Dependencies 00:08:00 Using the Dependency Tracking Utility 00:09:00 Creating and Maintaining Packages What Is a Package? 00:10:00 Creating a Package 00:19:00 Package Definition Information 00:08:00 Advanced Programming Techniques 00:06:00 Using Persistent Global Objects 00:04:00 Including Initialization Logic 00:15:00 Object Oriented Support within Packages 00:14:00 Package Maintenance 00:18:00 Advanced Cursor Techniques Learning to Use Cursor Variables 00:24:00 Advanced Cursor Techniques Weak Cursor Definitions 00:16:00 REFCURSOR Cursor Definition 00:05:00 Using Cursor Expression 00:14:00 Using System Supplied Packages Using the DBMS OUTPUT() Package 00:12:00 Using the UTL FILE() Package 00:30:00 Creating Database Triggers Understanding the Database Trigger 00:23:00 Statement-Level Triggers 00:23:00 Row-Level Triggers 00:12:00 Row Level Trigger Example 1 00:11:00 Row Level Trigger Example 2 00:07:00 Row Level Trigger Example 3 00:08:00 Working with the INSTEAD OF Trigger 00:11:00 Using Triggers within an Application 00:09:00 Trigger Maintenance Using the CALL Statement 00:09:00 Trigger Maintenance Tasks 00:12:00 Work with Multiple Triggers for a Single Table 00:11:00 Handling Mutating Table Issues 00:22:00 Using the Compound Trigger 00:06:00 Working with System Event Triggers What Is a System Event Trigger 00:05:00 Defining Scope 00:04:00 Identifying Available System Events 00:12:00 Conclusion Conclusion 00:02:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Oracle 11g PL/SQL Intermediate
Delivered Online On Demand10 hours 7 minutes
£11.99

Health And Fitness Masterclass: Beginner To Advanced

4.5(3)

By Studyhub UK

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Health And Fitness Masterclass: Beginner To Advanced Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Health And Fitness Masterclass: Beginner To Advanced Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Health And Fitness Masterclass: Beginner To Advanced Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Health And Fitness Masterclass: Beginner To Advanced Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Health And Fitness Masterclass: Beginner To Advanced? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Health And Fitness Masterclass: Beginner To Advanced 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 course for? This Health And Fitness Masterclass: Beginner To Advanced course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Health And Fitness Masterclass: Beginner To Advanced does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Health And Fitness Masterclass: Beginner To Advanced 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Health And Fitness Masterclass: Beginner To Advanced is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction Introduction & What You Will Learn 00:04:00 Get To Know Your Instructor 00:04:00 Why Your Fitness Matters 00:03:00 The Perfect Fitness Diet: Meal Planning Basics Fitness Dieting Introduction 00:02:00 Meal Planning Explained 00:04:00 Calories Explained 00:04:00 Protein Explained 00:02:00 How Much Protein Should I Consume Per Day? 00:04:00 Fats Explained 00:03:00 How Much Fat Should I Consume Per Day? 00:04:00 Carbohydrates Explained 00:03:00 How Many Carbs Should I Consume Per Day? 00:03:00 Meal Timing Introduction 00:01:00 Protein Timing 00:04:00 Carb Timing 00:02:00 Fat Timing 00:01:00 The Ideal Pre-Workout Meal 00:04:00 The Ideal Post-Workout Meal 00:02:00 Food Composition Introduction 00:02:00 Protein Composition 00:02:00 Carbohydrate Composition 00:03:00 Fat Composition 00:01:00 Top 3 Beginner Supplements 00 00:04:00 Setting Up Your Fitness Diet Determining Your Daily Calorie Intake 00:03:00 Determining Your Ideal Protein Intake 00:01:00 Determining Your Ideal Carb Intake 00:02:00 Determining Your Ideal Fat Intake 00:01:00 Adjusting Your Diet For Muscle Gain 00:04:00 Adjusting Your Diet For Weight Loss 00:05:00 The Perfect Fitness Workout: Cardio What Makes Up A Complete Fitness Workout? 00:03:00 Aerobic Exercise Overview 00:01:00 Traditional Cardio Explained 00:03:00 HIIT Cardio Explained 00:07:00 Sample HIIT Workout 00:05:00 The Perfect Fitness Workout: Bodyweight Training The Fundamentals Of Resistance Training 00:01:00 Bodyweight vs. Weight Training 00:02:00 Bodyweight Training Fundamentals 00:02:00 The Muscle Building Formula 00:09:00 Bodyweight Beginner Workout 00:07:00 Push Ups 00:01:00 Pull Ups 00:01:00 Bodyweight Squats 00:01:00 Lunges 00:01:00 The Perfect Fitness Workout: Weight Training Weight Training Fundamentals 00:03:00 Weight Training Beginner Workout 00:06:00 Bench Press 00:01:00 Squat 00:01:00 Deadlift 00:01:00 Military Press 00:01:00 Flexibility Introduction 00:01:00 Most Common Stretching Mistakes 00:04:00 Static vs. Dynamic Stretching 00:05:00 Your Daily Stretching Routine 00:03:00 How To Warm Up Correctly 00:02:00 Putting Everything Together: Your Weekly Training Schedule 00:01:00 The Right Fitness Mindset Fitness Mindset Introduction 00:01:00 How To Master Willpower 00:02:00 The Modern Problem 00:02:00 The Role Of Stress In Motivation 00:02:00 Motivation & Goal Setting 00:04:00 More Tips To Staying Motivated 00:01:00 5 Steps To Long Term Improvements 00:05:00 How To Track Your Progress 00 00:04:00 Visualizing Your Ideal Body 00:02:00 How To Avoid The 'What The Hell Effect' 00:01:00 Coaching Tools Bonus Lecture Extra Section 0 course promo 00:02:00 12 - The Different Types of carbs copy 00:05:00 20 - What about the anabolic window copy 00:01:00 25 - Supplement intro copy 00:01:00 27 - HOW TO USE PROTEIN POWDER_ WHEN, HOW MUCH & WITH WHAT copy 00:06:00 28 - HOW TO USE CREATINE_ WHEN, HOW MUCH & WITH WHAT copy 00:04:00 29 - Other Supplements to consider copy 00:05:00 34 - Determining Meal Structure copy 00:03:00 37 - Cheat days and cheat meals copy 00:05:00 43 how to progress with your hiit workouts copy 00:02:00 55 Progressive Overload copy 00:03:00 60 Barbell Row (Overhand) copy 00:01:00 61 Pull-Up copy 00:01:00

Health And Fitness Masterclass: Beginner To Advanced
Delivered Online On Demand3 hours 38 minutes
£10.99

Learn MySQL from Scratch for Data Science and Analytics

4.5(3)

By Studyhub UK

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. 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 course for? This Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics 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 Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00

Learn MySQL from Scratch for Data Science and Analytics
Delivered Online On Demand5 hours 47 minutes
£10.99

DSEAR Certification

4.5(3)

By Studyhub UK

The DSEAR (Dangerous Substances and Explosive Atmospheres Regulations) Certification course provides an introduction to DSEAR, ATEX, and explosive atmospheres. It covers general safety practices, safe working with flammable substances, equipment, protection systems, and the essential process of risk assessment. Learning Outcomes: Understand the fundamentals of DSEAR and its importance in managing dangerous substances and explosive atmospheres. Gain knowledge of ATEX (Atmosphères Explosibles) regulations and their relevance to safety in explosive atmospheres. Learn general safety practices to ensure the prevention of accidents and incidents in workplaces. Acquire skills for safe working with flammable substances, minimizing risks and hazards. Understand the importance of equipment and protection systems in maintaining safety in hazardous environments. Learn how to conduct effective risk assessments to identify and mitigate potential dangers and threats related to dangerous substances and explosive atmospheres. Why buy this DSEAR Certification? 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 DSEAR Certification 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 course for? Safety officers seeking to enhance their expertise in explosive atmospheres. Engineers and technicians involved in hazardous area equipment maintenance. Managers overseeing safety in industries handling flammable materials. Compliance professionals aiming to ensure adherence to DSEAR regulations. Industry personnel aspiring to upskill in safety and risk management. Prerequisites This DSEAR Certification does not require you to have any prior qualifications or experience. You can just enrol and start learning.This DSEAR Certification 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 Safety Engineer: £35,000 - £55,000 Per Annum Risk Assessment Officer: £30,000 - £45,000 Per Annum Compliance Manager: £40,000 - £60,000 Per Annum Hazardous Area Technician: £25,000 - £40,000 Per Annum Fire and Explosion Expert: £45,000 - £65,000 Per Annum Safety and Compliance Consultant: £50,000 - £70,000 Per Annum Course Curriculum DSEAR Certification Introduction to DSEAR 00:24:00 ATEX and Explosive Atmospheres 00:19:00 General Safety 00:35:00 Safe Working with Flammable Substances 00:17:00 Equipment and Protection System 00:34:00 Risk Assessment 00:25:00 Assignment Assignment - DSEAR Certification 00:00:00

DSEAR Certification
Delivered Online On Demand2 hours 34 minutes
£10.99

Functional Skills Level 2 - Maths and English

4.5(3)

By Studyhub UK

Imagine entering a realm where English prose and mathematical formulas dance together in perfect harmony, creating a tapestry of information that nourishes your mind and soul. This is what our Functional Skills Level 2 - Maths and English course promises - a symbiotic blend of numerical precision and linguistic elegance that empowers you to unlock your full potential. As you delve into the intricacies of multiplication, decimals, and grammar, you'll find yourself armed with the tools to conquer academic and professional challenges with ease. Each lesson is a stepping stone towards mastery, with expertly crafted content that makes learning feel like a thrilling adventure. The interactive lectures and practical exercises are your companions on this journey, guiding you towards a realm of clarity and confidence. No longer will you feel daunted by complex word problems or perplexed by the intricacies of sentence structure. Instead, you'll embrace them as opportunities to showcase your newfound prowess. As you emerge from this transformative experience, you'll find yourself not just proficient, but fluent in the language of Maths and English. Your enhanced skills will open doors to new opportunities, enabling you to communicate more effectively, solve problems with precision, and excel in your academic and professional pursuits. Learning Outcomes Apply multiplication techniques for digit numbers 11, 22, 33. Understand and utilise decimal and fraction conversions. Solve word problems involving ratios and proportions. Gain proficiency in basic grammar and sentence structure. Develop skills for accurate spelling and punctuation use. Understand operations on integers and rational numbers. Solve complex problems using BODMAS rules. Why Choose This Course 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. Who is this course for? Students aiming to enhance their Maths and English skills. Professionals seeking to improve their linguistic abilities. Individuals preparing for competitive exams. Anyone interested in expanding their academic knowledge. Individuals seeking to develop critical thinking skills. Career Path Increased eligibility for jobs requiring strong Maths and English skills. Writer or Editor Communications Specialist Data Analyst Teacher or Tutor in Maths or English Administrative or Office Professional. Salary range in the UK: £20,000 - £40,000, depending on the field and position. Certification  Upon completion of the Functional Skills Level 2 - Maths and English course materials, you are eligible to take a written assignment test either during or post-course. Successfully passing the test allows you to obtain the PDF certificate for £5.99. Additionally, you may order an original hard copy certificate at an extra cost of £9.60. Prerequisites  There are no prerequisites or prior qualifications required to enrol in the Functional Skills Level 2 - Maths and English course. This programme has been professionally developed to be compatible with all PCs, Macs, tablets, and smartphones. Conveniently access the course content from any location at any time, provided you have a reliable internet connection. Course Curriculum Functional Maths Training Course Lecture 1 Introduction 00:02:00 Lecture 2 Multiplying any digit number by 11, 22, and 33 00:09:00 Lecture 3 Integers and ordering of integers 00:06:00 Lecture 4 Addition and Subtractions of Integers 00:07:00 Lecture 5 Operations on Integers 00:04:00 Lecture 6 Multiplication and Division of Integers 00:04:00 Lecture 7 Powers of Integers (Exponents) 00:04:00 Lecture 8 Complete knowledge about factors and multiples 00:06:00 Lecture 9 Divisibility tests for 2,3,4,5,6 00:07:00 Lecture 10 Divisibility rules 7,8,9,10,11 00:06:00 Lecture 11 Prime Factorization 00:06:00 Lecture 12 Highest Common Factor HCF 00:10:00 Lecture 13 Least Common Multiple LCM 00:16:00 Lecture 14 Relation between LCM and HCF 00:04:00 Lecture 15 Classification of Fractions 00:04:00 Lecture 16 Convert mixed to improper and improper to mixed fractions 00:03:00 Lecture 17 Equivalent Fractions 00:04:00 Lecture 18 Comparing Fractions after converting to like fractions 00:09:00 Lecture 19 Reducing a fraction to lowest term 00:04:00 Lecture 20 Addition and subtraction OF fractions 00:08:00 Lecture 21 Multiplication and division of fractions 00:11:00 Lecture 22 Word problems on fractions 00:16:00 Lecture 23 BODMAS and rules to remove brackets 00:03:00 Lecture 24 Simplify expressions using BODMAS rules 00:05:00 Lecture 25 Simplify expressions involving fractions using BODMAS 00:07:00 Lecture 26 Decimal numbers in relation to fractions 00:08:00 Lecture 27 Like and unlike Decimals 00:05:00 Lecture 28 Ordering of Decimal numbers 00:10:00 Lecture 29 Addition and subtraction of Decimal 00:07:00 Lecture 30 Multiplication of Decimal 00:03:00 Lecture 31 Division of Decimal 00:05:00 Lecture 32 Rational number 00:02:00 Lecture 33 Representation of Rational Numbers on Number line 00:04:00 Lecture 34 Determining which fraction is terminating or non terminating 00:05:00 Lecture 35 shortcut method of writing decimal expansion of fraction to decimal 00:08:00 Lecture 36 Rounding to whole number 00:06:00 Lecture 37 Rounding to required number of decimals (1 d.p. ) 00:05:00 Lecture 38 rounding to significant digits 00:07:00 Lecture 39 Practice question on three methods of approximation 00:05:00 Lecture 40 Estimation 00:05:00 Lecture 41 Scientific Notation 00:07:00 Lecture 42 Operation on numbers when they are in scientific notation 00:06:00 Lecture 43 Percentage to fraction and fraction to percentage 00:06:00 Lecture 44 Percentage of a quantity and conversation to decimal 00:06:00 Lecture 45 Expressing one quantity as percentage of another quantity 00:06:00 Lecture 46 Finding increase decrease percent 00:05:00 Lecture 47 Uses of percentages-Word Problems 00:09:00 Lecture 48 Ratio- How to express as simple ratio 00:09:00 Lecture 49 How to compare Ratios 00:04:00 Lecture 50 Word problems on finding ratios 00:07:00 Lecture 51To divide a given quantity into a given Ratio 00:11:00 Lecture 52 Proportion 00:04:00 Lecture 53 Practice problems on Proportion 00:06:00 Lecture 54 Continued proportion 00:06:00 Lecture 55 Direct Variation ( or proportion) 00:04:00 Lecture 56 Problems based on Direct proportion 00:10:00 Lecture 57 Inverse Variation ( or proportion) 00:10:00 Lecture 58 Multiple Ratios 00:10:00 Lecture 59 Basics - Profit and Loss 00:04:00 Lecture 60 More practice problems on Profit & Loss 00:06:00 Lecture 61 Selling price formula and Problems 00:04:00 Lecture 62 Cost price formula and Problems 00:03:00 Lecture 63 Higher problems on Profit and Loss 00:08:00 Lecture 64 Basics - Discount.mp4 00:05:00 Lecture 65 Practice problems on Discount 00:04:00 Lecture 66 Tax 00:06:00 Functional skills English Introduction to the Course 00:13:00 Basics of Grammar 00:16:00 The Basics of Sentence 00:11:00 Structure of Sentence 00:19:00 Question 00:13:00 Punctuation & Capitalisation 00:24:00 Spelling 00:27:00 Common Mistakes and Ways to Improve 00:21:00

Functional Skills Level 2 - Maths and English
Delivered Online On Demand9 hours 20 minutes
£10.99

Hydrogen Sulphide Training: Safety and Awareness in Hazardous Environments

4.5(3)

By Studyhub UK

Venturing into the enigmatic world of Hydrogen Sulphide (H2S) introduces you to one of the most hazardous gases, yet offers immense opportunities for those trained in its safety and awareness. Our course, 'Hydrogen Sulphide Training: Safety and Awareness in Hazardous Environments', enlightens you with profound knowledge about the associated dangers and protective measures for H2S. Embrace a curriculum that spans from the rudiments of H2S consciousness, its lurking perils, state-of-the-art detection methodologies, comprehensive safety protocols, to adept emergency response tactics. Learning Outcomes Upon completion of this course, participants will be able to: Understand the fundamental principles of H2S and its potential risks. Identify the latest tools and techniques for H2S detection and monitoring. Implement robust safety protocols to mitigate H2S related threats. Execute immediate and effective emergency responses during H2S incidents. Recognise the broader implications of H2S in various professional environments. Why buy this Hydrogen Sulphide Training: Safety and Awareness in Hazardous Environments? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Hydrogen Sulphide Training: Safety and Awareness in Hazardous Environments 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 Hydrogen Sulphide Training: Safety and Awareness in Hazardous Environments course for? This Hydrogen Sulphide Training: Safety and Awareness in Hazardous Environments does not require you to have any prior qualifications or experience. You can just enrol and start learning. Individuals seeking to augment their understanding of H2S in hazardous terrains. Safety officers and supervisors aiming to bolster workplace safety. Environmental scientists and researchers delving into gas-related studies. Emergency responders keen on sharpening their response strategies. Industrial workers in sectors where H2S exposure is prevalent. Prerequisites This Hydrogen Sulphide Training: Safety and Awareness in Hazardous Environments does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Hydrogen Sulphide Training: Safety and Awareness in Hazardous Environments 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 Safety Officer: Average UK Salary - £30,000 to £40,000 per annum. Environmental Research Scientist: Average UK Salary - £32,000 to £45,000 per annum. Emergency Response Coordinator: Average UK Salary - £35,000 to £50,000 per annum. Industrial Supervisor: Average UK Salary - £28,000 to £38,000 per annum. Hazardous Materials Specialist: Average UK Salary - £34,000 to £46,000 per annum. Industrial Hygienist: Average UK Salary - £36,000 to £48,000 per annum Course Curriculum Module 01: Introduction to H2S Awareness Introduction to H2S Awareness 00:13:00 Module 02: Hazards Associated with H2S Hazards Associated with H2S 00:13:00 Module 03: Detection and Monitoring of H2S Detection and Monitoring of H2S 00:16:00 Module 04: Safety Measures Safety Measures 00:19:00 Module 05: Emergency Response Emergency Response 00:17:00

Hydrogen Sulphide Training: Safety and Awareness in Hazardous Environments
Delivered Online On Demand1 hour 18 minutes
£10.99

Women Health Care

4.5(3)

By Studyhub UK

This course on Women's Health Care provides comprehensive insights into various aspects of women's health and well-being. Covering topics from nutrition to reproductive health and gynecological disorders, it equips learners with essential knowledge for both personal health and professional practice. Learning Outcomes: Understand the fundamentals of women's health and its importance. Gain knowledge about nutrition tailored to women's unique needs. Comprehend the menstrual cycle, reproductive system, and their functions. Identify common gynecological disorders and pregnancy complications. Learn about family planning methods and maternal-fetal medicine. Explore nongynecological disorders affecting women's health. Recognize different cancers in women and their prevention. Understand the Women's Health Strategy for England and its implications. Why buy this Women Health Care?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Women Health Care you will be able to take the MCQ test that will assess your knowledge. 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 course for? This Women Health Care course is ideal for Aspiring healthcare professionals interested in women's health. Women seeking to enhance their understanding of personal health. Current healthcare practitioners looking to specialize in women's health. Public health advocates and educators focusing on women's well-being. Prerequisites This Women Health Care 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 Women's Health Practitioner: £30,000 - £70,000 per year. Obstetrician/Gynecologist: £60,000 - £150,000 per year. Women's Health Educator: £25,000 - £50,000 per year. Public Health Specialist (Women's Health Focus): £30,000 - £70,000 per year. Clinical Researcher in Women's Health: £40,000 - £80,000 per year. Course Curriculum Module 01: Introduction to Women's Health Practitioner Introduction to Women's Health Practitioner 00:09:00 Module 02: Women's Health and Nutrition Women's Health and Nutrition 00:23:00 Module 03: Menstrual Cycle and Reproductive System Menstrual Cycle and Reproductive System 00:15:00 Module 04: Gynaecological Disorders and Pregnancy Complications Gynaecological Disorders and Pregnancy Complications 00:32:00 Module 05: Family Planning Family Planning 00:13:00 Module 06: Maternal-Fetal Medicine Maternal-Fetal Medicine 00:15:00 Module 07: Nongynecological Disorders Nongynecological Disorders 00:20:00 Module 08: Cancers in Women Cancers in Women 00:15:00 Module 09: Women's Health Strategy for England Women's Health Strategy for England 00:27:00

Women Health Care
Delivered Online On Demand2 hours 49 minutes
£10.99

Level 3 Cost Estimate Certification

4.5(3)

By Studyhub UK

Embark on a transformative journey with the 'Level 3 Cost Estimate Certification' course, a comprehensive program designed to revolutionise your understanding of construction management and cost estimation. This meticulously structured course, beginning with an introduction to construction management, paves the way for an in-depth exploration into the intricacies of cost estimation. As you progress, the curriculum delves into the pivotal role of a cost estimator and introduces novel perspectives on cost estimation. With modules addressing the critical elements and factors influencing cost estimation, the course culminates with a keen focus on cost management and material management in construction. Each module is crafted to provide a thorough grounding in theory, complemented by real-world applications, ensuring a balanced and enriching learning experience. Learning Outcomes Acquire a robust foundation in construction management and its integral components. Master the art and science of accurate cost estimation in construction projects. Gain insights into the evolving role of cost estimators in modern construction. Understand the various elements and factors that impact cost estimation. Develop skills in effective cost management and material handling in construction. Why buy this Level 3 Cost Estimate Certification? 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 Level 3 Cost Estimate Certification you will be able to take the MCQ test that will assess your knowledge. 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 Level 3 Cost Estimate Certification course for? Aspiring cost estimators seeking a structured educational pathway. Construction professionals aiming to enhance their cost management capabilities. Individuals interested in transitioning to construction project management. Graduates keen on building a career in construction and cost estimation. Industry professionals aiming to update their knowledge with current trends. Prerequisites This Level 3 Cost Estimate Certification 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 Cost Estimator: £25,000 - £40,000 Per Annum Construction Project Manager: £30,000 - £50,000 Per Annum Quantity Surveyor: £28,000 - £45,000 Per Annum Construction Manager: £35,000 - £55,000 Per Annum Building Surveyor: £26,000 - £42,000 Per Annum Commercial Manager: £40,000 - £60,000 Per Annum Course Curriculum Level 3 Cost Estimate Certification Module 01- Introduction to Construction Management 00:16:00 Module 02- Cost Estimation 00:34:00 Module 03- Role of Cost Estimator and New Aspects of Cost Estimation 00:10:00 Module 04 - Elements and Factors influencing Cost Estimation 00:16:00 Module 05 -Cost Estimation in Construction Industry 00:38:00 Module 06 - Cost Management 00:19:00 Module 07 - Management of Material for construction 00:20:00

Level 3 Cost Estimate Certification
Delivered Online On Demand2 hours 33 minutes
£10.99