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

3077 Courses in Sheffield delivered Online

GCSE Maths & GCSE English Preparation Course - CPD Accredited

4.9(27)

By Apex Learning

Give a compliment to your career and take it to the next level. This Learning Maths & English GCSE will provide you with the essential knowledge and skills required to shine in your professional career. Whether you want to develop skills for your next job or want to elevate skills for your next promotion, this Learning Maths & English GCSEwill help you keep ahead of the pack. The Learning Maths & English GCSEincorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can reinforce your professional skills and knowledge, reaching out to the level of expertise required for your position. Further, this Learning Maths & English GCSEwill add extra value to your resume to stand out to potential employers. Throughout the programme, it stresses how to improve your competency as a person in your profession while at the same time it outlines essential career insights in this job sector. Consequently, you'll strengthen your knowledge and skills; on the other hand, see a clearer picture of your career growth in future. By the end of the Learning Maths & English GCSE, you can equip yourself with the essentials to keep you afloat into the competition. Along with this Learning Maths & English GCSE Preparation course, you will get 10 other premium courses. Also, you will get an original Hardcopy and PDF certificate for the title course and a student ID card absolutely free. What other courses are included with this Functional Skills Maths + Functional Skills English? Course 1: Advanced Mathematics Course 2: Maths: Algebra and Analytic Geometry Course 3: Learn Trigonometry and Trigonometric Functions Course 4: Functional Skills English Practice Level 2 Course 5: TEFL/TESOL Diploma Course 6: Teaching Assistant Course 7: Lesson Planning for Teaching Course 8: Remote Teaching Online Course 9: Leadership in Teaching Course 10: Creative Writing Complete Course So, enrol GCSE Maths & GCSE English Preparation Course now to advance your career! How will I get my GCSE Maths & GCSE English Preparation Course Certificate? After successfully completing the GCSE Maths & GCSE English Preparation Course course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £10 * 11 = £110) Hard Copy Certificate: Free (For The Title Course) If you want to get hardcopy certificates for other courses, generally you have to pay £20 for each. But this Fall, Apex Learning is offering a Flat 50% discount on hard copy certificates, and you can get each for just £10! P.S. The delivery charge inside the U.K. is £3.99 and the international students have to pay £9.99. Curriculum of Learning Maths & English GCSE Bundle Course 1: Advanced Mathematics Unit 01: Introduction Unit 02: Mathematical Logic Unit 03: Matrices Unit 04: Trigonometric Functions Unit 05: Pair of Straight Line Unit 06: Lines & Planes Unit 07: Linear Programming Course 2: Maths: Algebra and Analytic Geometry Number Sense and Algebra Analytic Geometry Course 3: Learn Trigonometry and Trigonometric Functions Course Promo Module 01: Fundamentals Module 02: Trigonometry Unit Circle Approach Module 03: Trigonometry: Right Triangle Approach Module 04: Analytic Trigonometry Module 05: Polar Coordinates Course 4: Functional Skills English Practice Level 2 Introduction to the Course Basics of Grammar The Basics of Sentence Structure of Sentence Questions Punctuation and Capitalisation Spelling Common Mistakes and Ways to Improve Course 5: TEFL/TESOL Diploma Module 1: Introduction to Teaching English Module 2: Linguistics Basics for TESOL Module 3: Working With a Variety of Approaches for TESOL Module 4: Teaching Speaking Module 5: Teaching Listening for TESOL Course 6: Teaching Assistant Teaching Assistant SEN Teaching Autism Awareness ADHD Awareness Dyslexia Course 7: Lesson Planning for Teaching Module 01: An Introduction to Planning and Teaching Module 02: Planning and Preparation in Teaching Module 03: Curriculum Module 04: Structure and Format Module 05: Methodology Course 8: Remote Teaching Online Module 1: Introduction to Remote Teaching Module 2: Remote Teaching Strategies Module 3: Remote Teaching Tools Module 4: Remote Teaching Methods Module 5: Instructional Strategies & Final Tips Course 9: Leadership in Teaching Module 01: An introduction to Leadership in Teaching Module 02: Teacher Leadership Module 03: The Skills of Teacher Leadership Module 04: What Teacher Leaders Need to Know Module 05: Stressors and Stress Management in Schools Module 06: Mentoring as part of effective leadership Course 10: Creative Writing Complete Course 01. Creative Writing Course: Writing Storybooks For Children 02. Creative Writing Course - Short Stories Course 11: Creative Writing Complete Course Module 1: Understanding Behaviour & Relationships as a TA Module 2: Experienced TAs Maintain Strong Communications with The Students Module 3: Communication and Interaction Module 4: Cognition and Learning Module 5: Social, Emotional and Mental Health Difficulties CPD 145 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this GCSE Maths & GCSE English Preparation Course - CPD Accredited bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this Learning GCSE Maths & GCSE English Preparation course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Learning Maths & English GCSEis fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this Learning GCSE Maths & GCSE English Preparation Course - CPD Accredited course, it can be studied in your own time at your own pace. Career path Having these Learning GCSE Maths & GCSE English Preparation Course - CPD Accredited various certificate will increase the value in your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

GCSE Maths & GCSE English Preparation Course - CPD Accredited
Delivered Online On Demand
£53

Software and Web Development (Online) - CPD Accredited

4.7(47)

By Academy for Health and Fitness

***24 Hour Limited Time Flash Sale*** Software and Web Development Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter How about launching your software engineering or web development career through comprehensive training across today's most in-demand programming languages? As technology reshapes industries across the UK, skilled coders are in short supply, with over 300,000 developer roles needed by 2025. This Software and Web Development bundle equips you with the skills to join this exciting field, whether you're a complete beginner or looking to upskill. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Software and Web Development bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Software and Web Development Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Software and Web Development Career Bundle: Course 01: C++ Development: The Complete Coding Guide Course 02: Basic C# Coding Course 03: Computer Vision: C++ and OpenCV with GPU support Course 04: Python Basic Programming for Absolute Beginners Course 05: Python Programming for Everybody Course 06: Data Science with Python Course 07: Need Another ONE COURSE Course 08: Basic Asynchronous JavaScript Course 09: JavaScript Promises Course 10: Learn to Use Python for Spatial Analysis in ArcGIS Course 11: Higher Order Functions in Python - Level 03 Course 12: Javascript Programming for Beginners Course 13: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 14: SQL Programming Masterclass Course 15: jQuery Masterclass Course: JavaScript and AJAX Coding Bible Course 16: SQL NoSQL Big Data and Hadoop Course 17: Root Cause Analysis Course 18: Business Intelligence and Data Mining Masterclass Course 19: JavaScript Foundations for Everyone Course 20: Microsoft SQL Server Development for Everyone Course 21: R Programming for Data Science Course 22: Data Analytics with Tableau Course 23: Intermediate Python Coding Course 24: Google Data Studio: Data Analytics Course 25: Introduction to Data Analysis Course 26: Level-3 Machine Learning Course with Python Course 27: Complete Google Analytics Course Course 28: JavaScript Functions Course 29: Quick Data Science Approach from Scratch Course 30: JavaScript Masterclass: ES6 Modern Development With Software and Web Development, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. Learning Outcomes Build robust applications and analyse data with confidence. Uncover the secrets of image processing and analysis. Craft interactive web experiences with JavaScript frameworks. Utilise SQL and Python for data manipulation and visualisation. Create dynamic dashboards with Excel formulas and VBA. Understand the world of SQL, NoSQL, and Hadoop. Enrol in Software and Web Development today and take the first step towards achieving your goals and dreams. Why buy this Bundle? Free CPD Accredited Certificate upon completion of Software and Web Development Get a free student ID card with Software and Web Development Lifetime access to the Software and Web Development course materials Get instant access to this Software and Web Development course Learn Software and Web Development from anywhere in the world 24/7 tutor support with the Software and Web Development course. Start your learning journey straightaway with our Software and Web Development Training! The software and Web Development premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Software and Web Development is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Software and Web Development course. After passing the Software and Web Development exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Software and Web Development course is ideal for: Students seeking mastery in Software and Web Development Professionals seeking to enhance Software and Web Development skills Individuals looking for a Software and Web Development-related career. Anyone passionate about Software and Web Development Requirements This Software and Web Development doesn't require prior experience and is suitable for diverse learners. Career path This Software and Web Development bundle will allow you to kickstart or take your career in the related sector to the next stage. Software developer Web developer Data scientist Database admin Business analyst Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Software and Web Development (Online) - CPD Accredited
Delivered Online On Demand6 days
£149

Introduction to Writing SQL Queries (TTSQL003)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This is an introductory- level course appropriate for those who are developing applications using relational databases, or who are using SQL to extract and analyze data from databases and need to use the full power of SQL queries. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert practitioner, attendees will learn to: Maximize the potential of SQL to build powerful, complex and robust SQL queries Query multiple tables with inner joins, outer joins and self joins Construct recursive common table expressions Summarize data using aggregation and grouping Execute analytic functions to calculate ranks Build simple and correlated subqueries Thoroughly test SQL queries to avoid common errors Select the most efficient solution to complex SQL problems A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. SQL is the cornerstone of all relational database operations. In this hands-on course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation. Introduction: Quick Tools Review Introduction to SQL and its development environments Using SQL*PLUS Using SQL Developer Using the SQL SELECT Statement Capabilities of the SELECT statement Arithmetic expressions and NULL values in the SELECT statement Column aliases Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword Use of the DESCRIBE command Restricting and Sorting Data Limiting the Rows Rules of precedence for operators in an expression Substitution Variables Using the DEFINE and VERIFY command Single-Row Functions Describe the differences between single row and multiple row functions Manipulate strings with character function in the SELECT and WHERE clauses Manipulate numbers with the ROUND, TRUNC and MOD functions Perform arithmetic with date data Manipulate dates with the date functions Conversion Functions and Expressions Describe implicit and explicit data type conversion Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions Nest multiple functions Apply the NVL, NULLIF, and COALESCE functions to data Decode/Case Statements Using the Group Functions and Aggregated Data Group Functions Creating Groups of Data Having Clause Cube/Rollup Clause SQL Joins and Join Types Introduction to JOINS Types of Joins Natural join Self-join Non equijoins OUTER join Using Subqueries Introduction to Subqueries Single Row Subqueries Multiple Row Subqueries Using the SET Operators Set Operators UNION and UNION ALL operator INTERSECT operator MINUS operator Matching the SELECT statements Using Data Manipulation Language (DML) statements Data Manipulation Language Database Transactions Insert Update Delete Merge Using Data Definition Language (DDL) Data Definition Language Create Alter Drop Data Dictionary Views Introduction to Data Dictionary Describe the Data Dictionary Structure Using the Data Dictionary views Querying the Data Dictionary Views Dynamic Performance Views Creating Sequences, Synonyms, Indexes Creating sequences Creating synonyms Creating indexes Index Types Creating Views Creating Views Altering Views Replacing Views Managing Schema Objects Managing constraints Creating and using temporary tables Creating and using external tables Retrieving Data Using Subqueries Retrieving Data by Using a Subquery as Source Working with Multiple-Column subqueries Correlated Subqueries Non-Correlated Subqueries Using Subqueries to Manipulate Data Using the Check Option Subqueries in Updates and Deletes In-line Views Data Control Language (DCL) System privileges Creating a role Object privileges Revoking object privileges Manipulating Data Overview of the Explicit Default Feature Using multitable INSERTs Using the MERGE statement Tracking Changes in Data

Introduction to Writing SQL Queries (TTSQL003)
Delivered OnlineFlexible Dates
Price on Enquiry

Data Analysis and Forecasting in Excel

4.5(3)

By Studyhub UK

In the digital age, the ability to interpret and predict data trends is paramount. Introducing 'Data Analysis and Forecasting in Excel', a comprehensive course tailored to unveil the intricacies of Excel's powerful tools. Dive deep into the world of worksheets, discover the magic of PivotTables, and unravel the secrets of data visualisation. Whether you're a novice eager to delve into data or a seasoned analyst looking to refine your skills, this course promises a transformative journey into the realm of Excel analytics. The curriculum is designed with the utmost care to ensure a holistic understanding. From the basics of modifying worksheets to the advanced techniques of forecasting data, every module is a step towards mastering Excel. With a focus on real-world applications, learners will be equipped to harness the potential of Excel, making data-driven decisions with confidence and precision. Visualisation is at the heart of understanding data. This course not only teaches you how to analyse data but also how to represent it effectively using charts, PivotCharts, and the innovative Sparklines. By the end of this course, you'll be adept at mapping data, automating workbook functionalities, and employing lookup functions with finesse. Learning Outcomes: Master the techniques of modifying and organising worksheets for optimal data representation. Understand and implement effective list management strategies within Excel. Analyse complex datasets and derive meaningful insights. Design and create compelling visual representations using charts and other visual tools. Efficiently utilise PivotTables and PivotCharts for advanced data analysis. Integrate and manage data across multiple worksheets and workbooks. Implement lookup functions and audit formulas to ensure data accuracy and integrity. Why buy this Data Analysis and Forecasting in Excel course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Data Analysis and Forecasting in Excel 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 Who is this Data Analysis and Forecasting in Excel course for? Individuals keen on mastering Excel for data interpretation and visualisation. Business analysts aiming to enhance their data forecasting abilities. Students pursuing a career in data analytics or business intelligence. Managers and decision-makers seeking to make data-driven strategies. Researchers looking to streamline and enhance their data processing techniques. Career path Data Analyst: Average salary range £30,000 - £50,000 annually. Business Intelligence Analyst: Average salary range £35,000 - £55,000 annually. Market Research Analyst: Average salary range £27,000 - £45,000 annually. Financial Analyst: Average salary range £35,000 - £60,000 annually. Operations Research Analyst: Average salary range £40,000 - £65,000 annually. Management Analyst: Average salary range £45,000 - £70,000 annually. Prerequisites This Data Analysis and Forecasting in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Analysis and Forecasting in Excel 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Modifying a Worksheet Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00 Search for and Replace Data 00:09:00 Use Proofing and Research Tools 00:07:00 Working with Lists Sort Data 00:10:00 Filter Data 00:10:00 Query Data with Database Functions 00:09:00 Outline and Subtotal Data 00:09:00 Analyzing Data Apply Intermediate Conditional Formatting 00:07:00 Apply Advanced Conditional Formatting 00:05:00 Visualizing Data with Charts Create Charts 00:13:00 Modify and Format Charts 00:12:00 Use Advanced Chart Features 00:12:00 Using PivotTables and PivotCharts Create a PivotTable 00:13:00 Analyze PivotTable Data 00:12:00 Present Data with PivotCharts 00:07:00 Filter Data by Using Timelines and Slicers 00:11:00 Working with Multiple Worksheets and Workbooks Use Links and External References 00:12:00 Use 3-D References 00:06:00 Consolidate Data 00:05:00 Using Lookup Functions and Formula Auditing Use Lookup Functions 00:12:00 Trace Cells 00:09:00 Watch and Evaluate Formulas 00:08:00 Automating Workbook Functionality Apply Data Validation 00:13:00 Search for Invalid Data and Formulas with Errors 00:04:00 Work with Macros 00:18:00 Creating Sparklines and Mapping Data Create Sparklines 00:07:00 MapData 00:07:00 Forecasting Data Determine Potential Outcomes Using Data Tables 00:08:00 Determine Potential Outcomes Using Scenarios 00:09:00 Use the Goal Seek Feature 00:04:00 Forecasting Data Trends 00:05:00

Data Analysis and Forecasting in Excel
Delivered Online On Demand4 hours 43 minutes
£10.99

DP-300T00 Administering Microsoft Azure SQL Solutions

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for The audience for this course is data professionals managing data and databases who want to learn about administering the data platform technologies that are available on Microsoft Azure. This course is also valuable for data architects and application developers who need to understand what technologies are available for the data platform with Azure and how to work with those technologies through applications. This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases. Prerequisites In addition to their professional experience, students who take this training should have technical knowledge equivalent to the following courses: AZ-900T00 Microsoft Azure Fundamentals DP-900T00 Microsoft Azure Data Fundamentals 1 - Prepare to maintain SQL databases on Azure Describe Microsoft Intelligent Data Platform roles Understand SQL Server in an Azure virtual machine Design Azure SQL Database for cloud-native applications Explore Azure SQL Database Managed Instance 2 - Deploy IaaS solutions with Azure SQL Explain IaaS options to deploy SQL Server in Azure Understand hybrid scenarios Explore performance and security Explain high availability and disaster recovery options 3 - Deploy PaaS solutions with Azure SQL Explain PaaS options for deploying SQL Server in Azure Explore single SQL database Deploy SQL database elastic pool Understand SQL database hyperscale Examine SQL managed instance Describe SQL Edge 4 - Evaluate strategies for migrating to Azure SQL Understand compatibility level Understand Azure preview features Describe Azure database migration options 5 - Migrate SQL workloads to Azure SQL databases Choose the right SQL Server Instance option in Azure Migrate SQL Server to Azure SQL Database offline Migrate SQL Server to Azure SQL Database online Load and move data to Azure SQL Database 6 - Migrate SQL workloads to Azure Managed Instances Evaluate migration scenarios to SQL Database Managed Instance Migrate to SQL Database Managed Instance Load and Move data to SQL Database Managed Instance 7 - Configure database authentication and authorization Describe Active Directory and Azure Active Directory Describe authentication and identities Describe Security Principals Describe database and object permissions Identify authentication and authorization failures 8 - Protect data in-transit and at rest Explore Transparent Data Encryption Configure server and database firewall rules Explain object encryption and secure enclaves Enable encrypted connections Describe SQL injection Understand Azure Key Vault 9 - Implement compliance controls for sensitive data Explore data classification Explore server and database audit Implement Dynamic Data Masking Implement Row Level security Understand Microsoft Defender for SQL Explore Azure SQL Database Ledger Implement Azure Purview 10 - Describe performance monitoring Describe performance monitoring tools Describe critical performance metrics Establish baseline metrics Explore extended events Describe Azure SQL Insights Explore Query Performance Insight 11 - Configure SQL Server resources for optimal performance Explain how to optimize Azure storage for SQL Server virtual machines Describe virtual machine resizing Optimize database storage Control SQL Server resources 12 - Configure databases for optimal performance Explore database maintenance checks Describe database scoped configuration options Describe automatic tuning Describe intelligent query processing 13 - Explore query performance optimization Understand query plans Explain estimated and actual query plans Describe dynamic management views and functions Explore Query Store Identify problematic query plans Describe blocking and locking 14 - Evaluate performance improvements Describe wait statistics Tune and maintain indexes Understand query hints 15 - Explore performance-based design Describe normalization Choose appropriate data types Design indexes 16 - Automate deployment of database resources Describe deployment models in Azure Automate deployment by using Azure Resource Manager templates and Bicep Automate deployment by using PowerShell Automate deployment by using Azure CLI 17 - Create and manage SQL Agent jobs Create a SQL Server maintenance plan Describe task status notifications 18 - Manage Azure PaaS tasks using automation Explore Elastic jobs Understand Azure Automation Build an automation runbook Automate database workflows by using Logic Apps Monitor automated tasks 19 - Describe high availability and disaster recovery strategies Describe recovery time objective and recovery point objective Explore high availability and disaster recovery options Describe Azure high availability and disaster recovery features for Azure Virtual Machines Describe high availability and disaster recovery options for PaaS deployments Explore an IaaS high availability and disaster recovery solution Describe hybrid solutions 20 - Explore IaaS and PaaS solutions for high availability and disaster recovery Describe failover clusters in Windows Server Configure Always-on availability groups Describe temporal tables in Azure SQL Database Describe active geo-replication for Azure SQL Database Explore auto-failover groups for Azure SQL Database and Azure SQL Managed Instance 21 - Back up and restore databases Back up and restore SQL Server running on Azure virtual machines Back up a SQL Server virtual machine Back up and restore a database using Azure SQL Database Additional course details: Nexus Humans DP-300T00: Administering Microsoft Azure SQL Solutions 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 DP-300T00: Administering Microsoft Azure SQL Solutions 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.

DP-300T00 Administering Microsoft Azure SQL Solutions
Delivered OnlineFlexible Dates
£2,380

Warehouse

4.5(3)

By Studyhub UK

The 'Warehouse' course provides a comprehensive understanding of warehouse management, covering essential topics such as functions, benefits, types of warehousing, and the role of technology in modern warehouse operations. Participants will delve into supply chain management concepts, warehouse safety, inventory control, and the pivotal role of human resource management. With a focus on improving efficiency and reducing costs, this course equips learners with the knowledge and skills needed to excel in warehouse management and contribute to the success of supply chain logistics. Learning Outcomes: Grasp the fundamental principles and benefits of warehouse management. Explore various types of warehousing and their functions in the supply chain. Understand the core functions of a warehouse management system. Identify challenges in warehouse management and strategies for overcoming them. Gain insights into technology's impact on warehouse operations. Comprehend supply chain management concepts and their application in warehouses. Learn about essential inventory management techniques and control flow. Enhance warehouse safety protocols and cost management strategies. Why buy this Warehouse? 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 Warehouse 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 Warehouse does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Individuals seeking a career in logistics, warehouse management, or supply chain. Warehouse managers, supervisors, and personnel aiming to enhance their skills. Entrepreneurs or business owners involved in inventory and logistics management. Professionals interested in improving warehouse efficiency and reducing costs. Prerequisites This Warehouse 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 Warehouse Manager - Median salary of $50,000 - $80,000 per year. Logistics Coordinator - Median salary of $40,000 - $60,000 per year. Inventory Control Specialist - Median salary of $40,000 - $60,000 per year. Supply Chain Analyst - Median salary of $50,000 - $70,000 per year. Operations Manager (with warehouse focus) - Median salary of $60,000 - $100,000 per year. Course Curriculum Warehouse Fundamentals of Warehouse Management 00:30:00 Warehousing: Function, Benefits and Types of Warehousing 00:30:00 Core Functions Of A Warehouse Management System 00:15:00 Challenges Of Warehouse Management 00:30:00 Technology In The Warehouse 00:45:00 Supply Chain Management Concepts 00:30:00 Warehouse Management Technologies to Adopt 00:15:00 Order Picking in the Warehouse 00:18:00 Managing Warehouse Inventory 00:15:00 Organize the Storage of Inventory in a Warehouse 00:15:00 Inventory Management Techniques 00:30:00 Inventory Control Flow of Processing 01:00:00 Logistics and Supply Chain In A Warehouse 00:30:00 Inventory Classification In The Warehouse 00:15:00 The Role Of Human Resource management In A Warehouse 00:30:00 Warehouse Safety 00:30:00 Warehouse Cost Management 00:15:00 Improve Warehouse Efficiency and Reduce Costs 00:15:00 Mock Exam Mock Exam- Warehouse 00:20:00 Final Exam Final Exam- Warehouse 00:20:00

Warehouse
Delivered Online On Demand8 hours 28 minutes
£10.99

Central Banking Monetary Policy

4.5(3)

By Studyhub UK

Embark on a journey through the intricate realm of central banking and monetary policy with our comprehensive course. Delve into the captivating history of central banking, tracing its evolution alongside the international monetary system. Explore modern roles and functions, understanding central banks' pivotal role in global economic landscapes. From dissecting monetary policy implementation to unravelling the complexities of money creation in the modern economy, this course offers a nuanced understanding essential for navigating the financial realm with expertise. Unlock the secrets of the monetary policy transmission mechanism and gain insights into maintaining financial stability amidst dynamic market conditions. Navigate through challenges confronting central banking institutions, equipping yourself with the insight to address them effectively. In times of crisis, learn optimal monetary policy operations strategies to mitigate risks and foster economic resilience. Through engaging modules led by industry experts, immerse yourself in a transformative learning experience that equips you with the knowledge and skills to thrive in central banking and monetary policy. Learning Outcomes: Grasp the historical evolution of central banking and its significance within the international monetary system. Understand the multifaceted roles and functions of modern central banking institutions. Analyze the intricacies of monetary policy implementation and its impact on financial markets. Evaluate the mechanisms of money creation in the contemporary economic landscape. Identify challenges facing central banking and develop strategies for effective crisis management. Why buy this Central Banking Monetary Policy 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. Certification After studying the course materials of the Central Banking Monetary Policy 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 Central Banking Monetary Policy course for? Financial analysts seeking a deeper understanding of central banking dynamics. Economics students aiming to specialize in monetary policy and financial markets. Professionals in banking and finance industries exploring career advancement opportunities. Policy makers and government officials involved in economic decision-making processes. Individuals interested in gaining insights into global economic systems and financial stability. Prerequisites This Central Banking Monetary Policy does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Central Banking Monetary Policy 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 Central Bank Economist: £40,000 - £70,000 Per Annum Financial Analyst: £30,000 - £50,000 Per Annum Monetary Policy Advisor: £45,000 - £80,000 Per Annum Risk Management Specialist: £35,000 - £60,000 Per Annum Economic Researcher: £35,000 - £55,000 Per Annum Financial Regulatory Analyst: £35,000 - £65,000 Per Annum Course Curriculum Module 01: The History of Central Banking and International Monetary System The History of Central Banking and International Monetary System 00:09:00 Module 02: Modern Central Banking Roles and Functions Modern Central Banking Roles and Functions 00:12:00 Module 03: Monetary Policy Implementation in Financial Market Operations Monetary Policy Implementation in Financial Market Operations 00:08:00 Module 04: Money Creation in the Modern Economy Money Creation in the Modern Economy 00:09:00 Module 05: The Monetary Policy Transmission Mechanism The Monetary Policy Transmission Mechanism 00:14:00 Module 06: Financial Stability: Monitoring and Identifying Risks Financial Stability Monitoring and Identifying Risks 00:11:00 Module 07: Challenges for Central Banking Challenges for Central Banking 00:10:00 Module 08: Optimal Monetary Policy Operations in Crisis Times Optimal Monetary Policy Operations in Crisis Times 00:08:00

Central Banking Monetary Policy
Delivered Online On Demand1 hour 21 minutes
£10.99

Asynchronous JavaScript Basics

4.5(3)

By Studyhub UK

Embark on a journey to master the intricacies of Asynchronous JavaScript and open doors to web development techniques that will set you apart in the tech world. The 'Asynchronous JavaScript Basics' course is a treasure trove of knowledge, meticulously designed for those who yearn to wield the power of non-blocking code with finesse. Begin with a gripping scenario that sets the stage, introducing you to the dynamic realms of synchronous and asynchronous operations. With each module, unlock a deeper understanding of how JavaScript engines handle tasks behind the scenes, enabling websites to perform efficiently and responsively. As you delve into the course, witness the magic of asynchronous JavaScript unfold through engaging workshops and demos. The curriculum promises to transform your coding approach, allowing you to implement features such as 'setTimeout' and 'setInterval', manage 'Promises', and gracefully orchestrate asynchronous flows with 'Async/Await'. The carefully structured roadmap and hands-on demonstrations are not just lessons but stepping stones to becoming proficient in creating smoother user experiences and robust web applications. Learning Outcomes Comprehend the distinction between synchronous and asynchronous JavaScript and the scenarios for their use. Utilize 'setTimeout' and 'setInterval' functions to manage time-controlled scripting tasks. Implement 'Promises' to handle future events and asynchronous operations efficiently. Apply 'Async/Await' syntax for writing cleaner and more readable asynchronous code. Understand and use JavaScript Generator Functions to control the execution flow of functions. Why choose this Asynchronous JavaScript Basics course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Asynchronous JavaScript Basics 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. Who is this Asynchronous JavaScript Basics course for? Individuals keen on enhancing their JavaScript knowledge for advanced web development. Developers seeking to improve site responsiveness and user experience. Programmers looking to upskill in modern JavaScript practices. Web enthusiasts curious about the execution of non-blocking code. Students or hobbyists interested in the mechanics of JavaScript engines. Career path Front-End Developer: £25,000 - £50,000 Back-End Developer: £30,000 - £60,000 Full Stack Developer: £35,000 - £70,000 Web Application Developer: £28,000 - £55,000 JavaScript Developer: £30,000 - £65,000 UI/UX Developer: £27,000 - £50,000 Prerequisites This Asynchronous JavaScript Basics does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Asynchronous JavaScript Basics 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Basic Asynchronous JavaScript An Async Javascript Scenario 00:02:00 Defining Asynchronous / What is Synchronous code? 00:04:00 WORKSHOP -Exploring Synchronicity in JavaScript 00:09:00 All About Asynchronous Code 00:06:00 Course Roadmap 00:01:00 What is setTimeout? 00:05:00 DEMO - Delaying Code Execution with setTimeout 00:10:00 What is setInterval? 00:02:00 DEMO - Repeating Tasks with setInterval 00:07:00 Chapter Summary 00:01:00 What is Async / Await? 00:03:00 What are Promises? 00:02:00 DEMO - Wrapping setTimeout with a Promise 00:05:00 All About Async 00:02:00 DEMO - Performing Asynchronous Tasks Concisely with Async / Await 00:12:00 What are JavaScript Generator Functions? 00:02:00 Demo - Asynchronous JavaScript via generators 00:08:00 Course Summary 00:02:00 Assignment Assignment - Asynchronous JavaScript Basics 00:00:00

Asynchronous JavaScript Basics
Delivered Online On Demand1 hour 23 minutes
£10.99

Hospitality Management and Restaurant Business: Part 2

By iStudy UK

Course Description The Hospitality Management and Restaurant Business: Part 2 course is designed to give you a deeper understanding of different aspects of the restaurant business and hospitality management. In this course, you are expected to learn about the arrival chronology, from greeting to check-in and check-out. You will be led through the procedures for the front office communications. In addition to that, the course will explain to you the role and functions of the Housekeeping department. You will also learn about the duties and responsibilities of a food and beverage manager. Doing this course will enable you to explain the importance of service quality in the hospitality sector. If all these sound good, enrol today and start learning!  Learning outcome  Learn about the arrival chronology Understand the procedures for the front office communications Know the role and functions of the Housekeeping department Explore the duties and responsibilities of a food and beverage manager Explain the importance of service quality in the hospitality sector How Much Do Restaurant Managers Earn? Senior - £32,000(Appx.) Average - £29,000(Appx.) Starting - £26,000(Appx.) Requirement Our Hospitality Management and Restaurant Business: Part 2 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. Hospitality Management and Restaurant Business: Part 2 Module 01: Management of Front Office Operations 00:16:00 Module 02: Management of Housekeeping, Engineering and Security Operations 00:24:00 Module 03: Management of Food and Beverage Operations 00:17:00 Module 04: Management of Service Quality in Hospitality Industry 00:17:00 Module 05: Creating an Online Ordering System 00:32:00 Module 06: Restructuring Management 00:24:00 Assignment Assignment - Hospitality Management and Restaurant Business: Part 2 00:00:00

Hospitality Management and Restaurant Business: Part 2
Delivered Online On Demand2 hours 10 minutes
£25

Power Query and Power Pivot in Microsoft Excel: A Quickstart Guide

By Ideas Into Action

Power Query and Power Pivot in Microsoft Excel:  A Quickstart Guide   Course Description   Copyright Ross Maynard 2022   Course Description Power Query and Power Pivot are two tools available in Microsoft Excel. If you are serious about data analysis, then you need to know how to use these tools. This Quickstart guide will give you the skills you need to get started with these powerful features. The Power Query tool allows you to import external data and then modify it to meet your needs, before loading it into Excel. These editing tasks are all things you can do manually in Excel, but Power Query greatly speeds things up when you have a large volume of data. The Power Pivot tool allows you to connect multiple data tables in an extended pivot table. Power Pivot also introduces new analysis and query tools to further enhance data analysis. If data analysis is your thing, then this course will help you get up to speed with these feature-filled tools. Through screen-capture video, the course provides a step-by-step guide to the foundation skills needed to use both Power Query and Power Pivot effectively. The course is designed to make your first steps into Power Query easy and to build your confidence to use them on your own. Both Power Query and Power Pivot are also available in Microsoft Power BI – the data visualisation suite. Once you have learned how to use Power Query and Power Pivot in Excel with this course, you’ll have a head start in getting to grips with Power BI Get up to speed with Power Query and Power Pivot in Microsoft Excel with this Quickstart guide.     Key Learning Points  On completion of the course, delegates will be able to: Use Power Query to load data from an external source into Microsoft Excel Clean and manipulate external data before loading it into Excel Consolidate separate files with Power Query Update Excel tables with new data in the same format Use Power Query to “unpivot” report tables to prepare the data for analysis Explain the core functionality of Power Pivot Link data tables together in the Power Pivot data model Create pivot tables that draw data from several source data tables Create performance measures and new analysis in the Power Pivot data model Use the most popular DAX query language functions in Power Pivot     Curriculum Lesson 1: Power Query Quickstart Lesson 2: Consolidating Files with Power Query Lesson 3: Unpivoting a Table Lesson 4: Power Pivot Quickstart Lesson 5: Power Pivot – Adding Data and Functionality Lesson 6: Key DAX Functions for Power Pivot Lesson 7: The DAX CALCULATE Function Lesson 8: Key Learning Points     Pre-Course Requirements There are no pre-course requirements     Additional Resources Starter spreadsheets for each lesson are provided so that learners can follow the steps presented.     Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel     Questions What is the main feature of Power Query? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     What is the main feature of Power Pivot? The ability to link data tables together to create pivot tables that allow data to be drawn from any and all of the source tables The ability to clean and manipulate large volumes of external data efficiently and to load the result into Microsoft Excel The removal of Microsoft Excel’s restrictions on file sizes and the number of rows of data allowed The ability to visualise data in dashboards and management reports     Which of the following actions cannot be performed within Power Query? Split text into multiple columns Trimming text and removing spaces Creating calculated columns using DAX functions Make date based calculations   Which of the following statements is true? You can use Power Query to combine files that have the same format and open them all in the same spreadsheet You can use Power Query to link data tables and create pivot tables that pull data items from all the linked tables You can use Power Query to create interactive dashboard reports You can use Power Query to export data files to Microsoft Access and other databases     Which of the following provides a compelling case to use Power Pivot in Microsoft Excel? The data visualisation and presentation features of Power Pivot are much more powerful than those in Excel Power Pivot offers the ability to clean large files of data imported from other systems quickly Existing reports and tables can be “reverse engineered” (unpivoted) to create data tables for more advanced analysis Files sizes in Power Pivot are smaller than in Excel and there is no limit on the number of rows of data that can be stored. This makes it much faster and more efficient to use Power Pivot for large data sets     Power Pivot uses analysis functions from the DAX formula language. What does “DAX” stand for? Digital Architecture Extraction Data Arbitrage Extrapolation Display Analytics Extension Data Analysis Expressions Deeply Annoying Exercise   The DAX CALCULATE function is one of the most powerful and useful functions available in Power Pivot. Which statement best describes it? It performs row by row calculations defined by the user and adds the total of them all together for a specified table It performs row by row calculations defined by the user and displays the maximum result for a specified table It performs a defined calculation and then applies filters specified by the user It filters the data in a specified table according to criteria set by the user   As well as in Power Pivot in Microsoft Excel, in what application are DAX functions also available? Microsoft PowerPoint Microsoft Forms Microsoft Teams Microsoft Power BI   How do DAX functions differ from Microsoft Excel functions? DAX functions are designed specifically for use with SQL based data sources DAX functions are completely new and provide additional functionality within Microsoft Excel DAX functions never take a cell reference or a range as reference, but instead take a column or table as reference DAX date and time functions return a date as a serial number, whereas Excel date and time functions return a datetime data type  

Power Query and Power Pivot in Microsoft Excel: 
A Quickstart Guide
Delivered Online On Demand
£9.99