3081 Courses in Sheffield delivered Online

Level 4 QLS Endorsed Course | CPD Accredited | Free PDF Certificate | Lifetime Access | Tutor Support

Duration 5 Days 30 CPD hours This course is intended for This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators. Overview Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language. They will learn the syntax, structure and features of the language. In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c. Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Choosing a Database Programming Language What is Database Programming? PL?SQL Performance Advantages Integration wth Other Languages PL/SQL Language Fundamentals PL/SQL Program Structure LANGUAGE SYNTAX RULES EMBEDDING SQL WRITING READABLE CODE GENERATING DATABASE OUTPUT SQL*PLUS INPUT OF A PROGRAM BLOCK Declare Section About the Declare Section DECLARE PRIMITIVE TYPES DECLARATION OPTIONS NOT NULL CONSTANT DATA DICTIONARY INTEGRATION %TYPE DECLARE SIMPLE USER---DEFINED TYPES TYPE... TABLE TYPE... RECORD EXTENDED USER---DEFINED TYPES Begin Section About the Begin Section Manipulating Program Data Logic Control & Branching GOTO LOOP IF-THEN-ELSE CASE Exception Section ABOUT THE EXCEPTION SECTION ISOLATING THE SPECIFIC EXCEPTION PRAGMA EXCEPTION_INIT SQLCODE &SQLERRM Example SQL%ROWCOUNT &SELECT...INTO Beyond the Basics: Explicit Cursors ABOUT EXPLICIT CURSORS EXTENDED CURSOR TECHNIQUES FOR UPDATE OF Clause WHERE CURRENT OF Clause Using FOR?LOOP Cursors Beyond the Basics: Nested BlocksBeyond the Basics: Declared Subprograms USING DECLARED SUBPROGRAMS DECLARED PROCEDURE DECLARED FUNCTION Introducing Databse-Resident Program Units ABOUT DATABASE---RESIDENT PROGRAMS PHYSICAL STORAGE & EXECUTION TYPES OF STORED PROGRAM UNITS STORED PROGRAM UNIT ADVANTAGES MODULAR DESIGN PRINCIPLES Creating Stored Procedures & Functions STORED PROCEDURES & FUNCTIONS CREATE PROCEDURE / CREATE FUNCTION CREATING PROCEDURES & FUNCTIONS RAISE_SALARY() Procedure SALARY_VALID() Function THE PARAMETER SPECIFICATION DEFAULT Clause SYSTEM & OBJECT PRIVILEGES USING THE DEVELOPMENT TOOLS Executing Stored Procedures & Functions CALLING PROCEDURES & FUNCTIONS UNIT TESTING WITH EXECUTE ANONYMOUS BLOCK UNIT TESTING SPECIFYING A PARAMETER NOTATION SQL WORKSHEET UNIT TESTING CALLING FUNCTIONS FROM SQL Maintaining Stored Program Units RECOMPILING PROGRAMS Mass Recompilation Using UTL_RECOMP() DROPPING PROCEDURES & FUNCTIONS DROP PROCEDURE / FUNCTION DATA DICTIONARY METADATA Using USER_OBJECTS Using USER_SOURCE Using USER_ERRORS Using USER_OBJECT_SIZE Using USER_DEPENDENCIES Managing Dependencies DEPENDENCY INTERNALS TRACKING DEPENDENCIES THE DEPENDENCY TRACKING UTILITY SQL DEVELOPER DEPENDENCY INFO DEPENDENCY STRATEGY CHECKLISTS Creating & Maintaining Packages ABOUT PACKAGES CREATING PACKAGES MAINTAINING PACKAGES PERFORMANCE CONSIDERATIONS Advanced Package Capabilities DEFINER & INVOKER RIGHTS WHITE LITS & ACCESSIBLE BY PERSISTENT GLOBAL OBJECTS DEFINING INITIALIZATION LOGIC OBJECT ORIENTATION SUPPORT Advanced Cursor Techniques USING CUSROS VARIABLES USING SYS_REFCURSOR USING CURSOR EXPRESSIONS Using System-Supplied Package DBMS_OUTPUT() UTL_FILE() FOPEN() EXAMPLE Database Trigger Concepts ABOUT DATABASE TRIGGERS DML EVENT TRIGGER SUB---TYPES DATABASE TRIGGER SCENARIO TRIGGER EXECUTION MECHANISMS TRIGGERS WITHIN SQL WORKSHEET Creating Database Triggers STATEMENT-LEVEL TRIGGERS Using RAISE_APPLICATION_ERROR() ROW---LEVEL TRIGGERS EXAMPLES OF TRIGGERS EMPLOYEE_SALARY_CHECK Example EMPLOYEE_JOURNAL Example BUDGET_EVENT Example INSTEAD OF TRIGGERS TRIGGERS WITHIN AN APPLICATION Maintaining Database Triggers CALL SYNTAX TRIGGER MAINTENANCE TASKS SHOW ERRORS TRIGGER DROP TRIGGER ALTER TRIGGER MULTIPLE TRIGGERS FOR A TABLE HANDLING MUTATING TABLE ISSUES Implementing System Event Triggers WHAT ARE SYSTEM EVENT TRIGGERS? DEFININGTHE SCOPE AVAILABLE SYSTEM EVENTS SYSTEM EVENT ATTRIBUTES Additional course details: Nexus Humans Oracle 12c PL/SQL Fundamentals 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 Oracle 12c PL/SQL Fundamentals 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.

Overview Are you ready to develop your career to the next level? Interested to kickstart a rewarding career as a warehouse manager? This Warehouse course is ideal for ambitious candidates just like you who are looking to reach the very top of their career ladder! You'll learn the functions and objectives of warehousing operations, get to know the different types of warehouses and master the art of effective warehouse management. No need for prior experience or professional background. It's high time to consider a career in warehouse management! How will I get my certificate? At the end of the course there will be a written assignment test which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Warehouse. It is available to all students, of all academic backgrounds. Requirements Our Warehouse is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 19 lectures • 07:45:00 total length •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:15: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 •Assignment - Warehouse Management Training Level 5: 00:00:00

Javascript Asynchronous Basics is a course that will assist you to become a front-end developer with thorough and

Description Kinesiology Diploma Kinesiology is the science of human movement. Kinesiology examines how the human body initiates and controls movement. Movement is complex as its success greatly depends on the organized and coordinated working together of different systems like the cardiovascular, neuromuscular and energy-producing systems. Kinesiology studies how body systems interact with each other during movement which can include different forms of training and exercises. It also throws light into how performance can be enhanced during training preventing and overcoming injuries and other issues that affect the physical fitness of people. Kinesiology Diploma is an introductory course that takes you through the basic concepts and principles of the field of kinesiology. Kinesiology Diploma is easy to read and understand and covers not only the primary aspects of kinesiology but also its sub-disciplines like biomechanics and exercise science. If you are a student of kinesiology, a coach, an athlete or anyone who wants to know more about his or her body, then this course is for you. What You Will Learn 1: Introducing Kinesiology 2: The History and Philosophy of Sport and Exercise 3: The Brain and Movement 4: Exercise Metabolism 5: The Cardiovascular System 6: Adapting to your Environment 7: Nuts and bolts of Movement 8: Bone composition and functions 9: The Joints in Human Body 10: The Muscles Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

In this course, we'll learn how to visualize data with real weather data downloaded from the US National Weather Service using the R programming language and RStudio. We recommend that you have some background in HTML, CSS, and JavaScript. You don't need to be an expert by any means, but you should have experience building web pages with HTML and CSS, and you should have basic programming skills with JavaScript.

Become an expert in Microsoft Excel with our comprehensive online training program. Learn formulas, charts, pivot tables, data analysis, macros, and more. Develop in-demand Excel skills through hands-on exercises and project work. Gain proficiency in this powerful software to advance your career or improve productivity.

The Beauty industry offers a rewarding career that spans the globe. With diverse branches, having a range of skills enhances opportunities. This comprehensive Mega-course comprises 72 Modules, equipping aspiring beauty professionals with knowledge and skills to succeed in their careers. Study time is 60 hours. Students will learn, Waxing, Nail Technology, and Makeup Artistry, gaining a well-rounded education in beauty and grooming.   Waxing Course: Waxing is a popular service enjoyed by both men and women worldwide. This course provides a comprehensive understanding of waxing techniques and practices. Topics covered in the course include: The function of the skin and hair anatomy. Benefits of waxing and different hair removal methods. Conducting consultations and maintaining a safe environment. Creating a professional working environment. Equipment used in the industry, including disposable products. Waxing techniques for various body parts. Aftercare solutions and problem handling.   Nail Technician Course: The nail technician course focuses on the art of nail care and enhancement. Key highlights of the course include: Role of a nail technician and nail anatomy. Importance of hygiene and workspace preparation. Conducting consultations and offering nail care advice. Performing manicures and pedicures. Nail preparation, shaping, and working with acrylic and gel nails. Nail art and design ideas. Maintaining equipment and workstations with proper hygiene practices. Insights on setting up and managing a nail technician business.   Make-up Artist Course: The make-up artist course explores the world of make-up and its applications. The course covers the following aspects: History of make-up and the role of a make-up artist. Latest trends and techniques in make-up. Skin anatomy and common client issues and solutions. Functions of brushes, products, and tools. Equipment care and maintenance. Make-up styles for different occasions and seasons. Techniques for eyebrow shaping, eyeliner, false lash application, blush, and lip products. Make-up requirements for TV, film, magazines, and character looks. The course provides additional career opportunities in the make-up industry.   Complete Beauty Diploma: Upon completion of the entire program, students gain: A comprehensive understanding of the beauty industry. Essential skills in waxing, nail technology, and make-up artistry. Confidence to embark on a rewarding career in the beauty sector.

Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Whether you work in machine learning or finance or are pursuing a career in web development or data science, Python is one of the most important skills you can learn. Python was developed upon the premise that there should be only one way (and preferably one obvious way) to do things, a philosophy that has resulted in a strict level of code standardization. The core programming language is quite small and the standard library is also large. In fact, Python's large library is one of its greatest benefits, providing a variety of different tools for programmers suited for many different tasks. Learn how to build a promising and lucrative career by training to become a Computer Programmer without any previous skill needed. By utilising the popular Python programming platform and language, you will swiftly learn how to understand the principles of writing programs and using variables in their construction. You will also be taught how to set up conditional and repeated executions in a routine, alongside the ability to recode and reuse other programs for templates or loops. Code yourself a bright future now. With a single payment you will gain access to Python Training including 10 Career development courses, original hardcopy certificate, transcript and a student ID card which will allow you to get discounts on things like music, food, travel and clothes etc. What other courses are included with this Python? Level 2 Microsoft Office Essentials Microsoft Teams Leadership & Management Diploma Working from Home Essentials Mental Health and Working from Home Online Meeting Management Effective Communication Skills Time Management Report Writing Emotional Intelligence and Human Behaviour Benefits you'll get from choosing Apex Learning for this Python Training: Pay once and get lifetime access to 11 CPD courses including this Python Training Course Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules of Python Training designed by expert instructors Learn about Python Training at your ease - anytime, from anywhere Study the Python Training from your computer, tablet or mobile device The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Python Training expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Curriculum: Course 01: Python Programming for Everybody Module 01 A Installing Python Documentation Command Line Variables Simple Python Syntax Keywords Import Module Module 02 Additional Topics If Elif Else Iterable For Loops Execute Exceptions Module 03 Data Types Number Types More Number Types Strings More Strings Files Lists Dictionaries Tuples Sets Module 04 Comprehensions Definitions Functions Default Arguments Doc Strings Variadic Functions Factorial Module 05 Function Objects Lambda Generators Closures Classes Object Initialization Class Static Members Classic Inheritance Data Hiding How will I get my Certificate? After successfully completing this Training 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. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this bundle. Requirements This course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Duration 2 Days 12 CPD hours This course is intended for This introductory-level course is intended for Business Analysts and Data Analysts (or anyone else in the data science realm) who are already comfortable working with numerical data in Excel or other spreadsheet environments. No prior programming experience is required, and a browser is the only tool necessary for the course. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Throughout the hands-on course students, will learn to leverage Python scripting for data science (to a basic level) using the most current and efficient skills and techniques. Working in a hands-on learning environment, guided by our expert team, attendees will learn about and explore (to a basic level): How to work with Python interactively in web notebooks The essentials of Python scripting Key concepts necessary to enter the world of Data Science via Python This course introduces data analysts and business analysts (as well as anyone interested in Data Science) to the Python programming language, as it?s often used in Data Science in web notebooks. This goal of this course is to provide students with a baseline understanding of core concepts that can serve as a platform of knowledge to follow up with more in-depth training and real-world practice. An Overview of Python Why Python? Python in the Shell Python in Web Notebooks (iPython, Jupyter, Zeppelin) Demo: Python, Notebooks, and Data Science Getting Started Using variables Builtin functions Strings Numbers Converting among types Writing to the screen Command line parameters Flow Control About flow control White space Conditional expressions Relational and Boolean operators While loops Alternate loop exits Sequences, Arrays, Dictionaries and Sets About sequences Lists and list methods Tuples Indexing and slicing Iterating through a sequence Sequence functions, keywords, and operators List comprehensions Generator Expressions Nested sequences Working with Dictionaries Working with Sets Working with files File overview Opening a text file Reading a text file Writing to a text file Reading and writing raw (binary) data Functions Defining functions Parameters Global and local scope Nested functions Returning values Essential Demos Sorting Exceptions Importing Modules Classes Regular Expressions The standard library Math functions The string module Dates and times Working with dates and times Translating timestamps Parsing dates from text Formatting dates Calendar data Python and Data Science Data Science Essentials Pandas Overview NumPy Overview SciKit Overview MatPlotLib Overview Working with Python in Data Science Additional course details: Nexus Humans Python for Data Science: Hands-on Technical Overview (TTPS4873) 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 Python for Data Science: Hands-on Technical Overview (TTPS4873) 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.