3077 Courses delivered Online

Level 1 Award in Facilities Management Explore the fundamental principles, strategies, and key services that drive effective facility management. Discover the intricacies of managing facilities for service organizations and the critical aspect of risk management in this dynamic field of study. Learning Outcomes: Explain the fundamentals of Facilities Management concepts. Develop effective Facility Management strategies and plans. Identify key services within Facilities Management practices. Differentiate functions in Facility Management for various contexts. Apply risk management principles to Facilities Management. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Level 1 Award in Facilities Management Course Syllabus Facilities Management Basics: Gain a comprehensive understanding of facilities management, its significance, and its role in modern organizations. Facilities Management Strategies: Learn effective strategies for optimizing facility operations, enhancing cost-efficiency, and ensuring seamless functionality. Facilities Management Services: Explore the essential services encompassed by facilities management, including maintenance, security, and sustainability. Functions in Facilities Management: Dive into the various functions involved in facilities management, from space planning to technology integration. Facilities Management for Service Organizations: Understand how facilities management principles apply specifically to service-oriented organizations, ensuring smooth service delivery. Risk Management: Acquire skills in identifying and mitigating risks associated with facilities management to maintain a safe and compliant environment.

This is a comprehensive and practical Apache Spark course. In this course, you will learn and master the art of framing data analysis problems as Spark problems through 20+ hands-on examples, and then scale them up to run on cloud computing services. Explore Spark 3, IntelliJ, Structured Streaming, and a stronger focus on the DataSet API.

Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. Relational Databases & Data Models About Data Models About the Relational Model The Electronics Data Model About the Relational DBMS 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 Using the Database Interface About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Introduction to the SQL Language About the SQL Language Characteristics of SQL Introducing SQL Using Select SQL Rules The Select Statement The Select Statement Distinct/Unique Keyword Using Alias Names Restricting Results with the Where Clause About Logical Operators Equality Operator Boolean Operators REGEXP_LIKE() In Operator Sorting Data with the Order By Clause About the Order by Clause Multiple Column Sorts Specify the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns, Functions & Top-N Queries Rowid Pseudo Column ORA_ROWSCN PSEUDO Column ROWNUM Pseudo Column About the Built-In Functions SYSDATE User & UID SESSIONTIMEZONE Function Using the Dual Table Row Limiting & Top-N Queries FETCH First x Rows Only Clause OFFSET x Rows Clause FETCH?PERCENT Clause The WITH TIES Option Joining Tables About Joins Inner Joins Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators SQL Set Operator Examples UNION Example INTERECT Example MINUS Example UNION All Summary Functions Using Sub-Queries Finding Data with Sub-Queries Standard Sub-Queries Correlated Sub-Queries The EXISTS Operator Aggregating Data within Groups About Summary Groups Find Groups within the Tables Select Data From the Base Tables Select Groups from the Results Use DDL to Create & Manage Tables Create Table Statement Column Data Types Not Null Default Describe Alter Table Statement Drop Table Statement Table DDL Using SQL Developer Alter User Statement Alter Session Statement NLS_Language NLS_Date Use DML to Manipulate Data The Insert Statement The Delete Statement The Update Statement About Transactions Transaction Rollback Transaction Commit Transaction Savepoint The Set Transaction Statement Set Transaction Read Only Statement Rules Understanding the Data Models The Company Data Model The Electronics Data Model About the SQL-99 Standard SQL-92 & SQL-99 Cross Joins Natural Joins Inner Joins Implicit Inner Join Outer Joins Anti Joins Named Sub-Queries Enhancing Groups with Rollup & Cube Using Rollup The Grouping() Function Using Cube SQL Functions: Character Handling What are the SQL Functions? String Formatting Functions UPPER(), LOWER() Example INITCAP() Example Character Codes Functions CHR((), ASCII() Examples PAD & TRIM Functions RPAD() Example RTRIM() Example TRIM() Example String Manipulation Functions DECODE () Example SUBSTR() Example INSTR() Example TRANSLATE() Example REPLACE() Example String Comparison Functions LEAST() Example Phonetic Search Function SOUNDEX() Example SQL Functions: Numeric Handling About the Numeric Data Functions GREATEST() Example ABS() Example ROUND() Example TRUNC() Example SIGN() Example TO_NUMBER() Example & Data ype Conversions NULL VALUES FUNCTIONS NVL() & NVL2() Function NVL() Example (Character) NVL() Example (Numeric Loss of Data) NVL() Example (Numeric Output) NVL2() Example COALESCE() Function NULLIF() Function SQL Functions: Date Handling Date Formatting Functions TO_CHAR() & TO_DATE() Format Patterns TO_CHAR() Examples TO_DATE() Examples EXTRACT() Example Date Arithmetic Functions MONTHS_BETWEEN() Example ADD_MONTHS() Example LAST_DAY() Example NEXT_DAY() Example TRUNC(), ROUND() Dates Example NEW_ TIME() Example About V$TIMEZONE_NAMES CAST() FUNCTION & TIME ZONES Database Objects: About Database Objects About Database Objects About Schemas Making Object References Database Objects: Relational Views About Relations Views The Create View Statement Why Use Views? Accessing Views with DML Maintaining View Definitions Alter View Drop View DDL Using SQL Developer Database Objects: Indexes About Indexes Create & Drop Index Statements Indexes & Performance Data Dictionary Storage Database Objects: Creating Other Objects About Sequences Referencing NEXTVAL Referencing CURRVAL Within the DEFAULT Clause Alter Sequence & Drop Sequence ALTER SEQUENCE DROP SEQUENCE About Identity Columns CREATE TABLE?GENERATED AS IDENTITY ALTER TABLE?GENERATED AS IDENTITY Start With Limit Value ALTER TABLE...DROP IDENTITY About Synonyms CREATE & DROP SYNONYM Statements CREATE SYNONYM DROP SYNONYM Public Vs Private Synonyms CREATE SCHEMA AUTHORIZATION Database Objects: Object Management Using DDL The RENAME Statement TABLESPACE Placement CREATE TABLE?TABLESPACE The Comment Statement The TRUNCATE TABLE Statement Database Objects: Security About Object Security Grant Object Privileges Revoke Object Privileges Object Privileges & SQL Developer Data Integrity Using Constraints About Constraints NOT NULL Constraint NOT NULL Example CHECK Constraint UNIQUE Constraint PRIMARY KEY Constraint REFERENCES Constraint ON DELETE CASCADE Example ON DELETE SET NULL Example Constraints on Existing Tables Constraints & SQL Developer Managing Constraint Definitions RENAMING & DROPPING Constraints ENABLING & DISABLING Constraints DEFERRED Constraint Enforcement SET CONSTRAINTS Handling Constraint Exceptions Constraints with Views DATA Dictionary Storage The Data Dictionary Structure More About the Data Dictionary OBJECT-SPECIFIC Dictionary Views USER_UPDATABLE_COLUMNS The Dictionary Structure METADATA & SQL Developer Additional course details: Nexus Humans Oracle 12c 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 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.

The Simplest Guide™ to Advanced SAS Programming | Macros | SQL is an accelerated path to learning advanced SAS programming taught in a simple, visual, and immersive style. If you already know SAS, this course will equip you with skills to reveal amazing insights within your data, while helping you prepare for advanced SAS certification exams.

Medical Writing - Turning the language of medicine into narratives that heal and enlighten

About Course Engineering Calculus Made Simple (Derivatives) Learn the basics of derivatives in a clear and concise way, tailored for electrical engineering students. This course is designed to help you understand and apply the concept of derivatives to electrical problems, without requiring you to have a deep understanding of calculus theory. In this course, you will learn: What derivatives are and how to calculate them How to use derivatives to solve real-world engineering problems Useful trigonometric identities How to approach derivatives using limits and theorems And more! By the end of this course, you will be able to: Calculate the derivatives of basic electrical functions Use derivatives to solve for voltage, current, and other electrical quantities Understand the relationship between derivatives and other calculus concepts, such as limits and integrals This course is perfect for electrical engineering students who want to learn the basics of derivatives without getting bogged down in complex calculus theory. Enroll today and start your journey towards becoming a more proficient electrical engineer! Benefits of learning derivatives for electrical engineering students: Derivatives are essential for understanding and solving many electrical engineering problems. For example, derivatives can be used to calculate the voltage and current in circuits, the torque of a motor, and the resonant frequency of a circuit. Derivatives can also be used to design new electrical components and systems. For example, derivatives can be used to design a filter that can remove noise from a signal or to design a control system that can keep a motor running at a constant speed. Having a good understanding of derivatives will make you a more competitive job applicant and will make you more successful in your career as an electrical engineer. Enroll today and start learning the basics of derivatives for electrical engineering! What Will You Learn? Students will learn mathematical derivatives as they apply to electrical functions Students will learn about limits. Students will learn useful Trig Identities. Students will learn the Squeeze Theorem. Course Content Engineering Calculus (Derivatives) Introduction Functions Limits The Derivative Trig Identities The Squeeze Theorem The Derivative of Sin(x) The Derivative of Cos(x) Other Derivatives A course by Graham Van Brunt P. Eng. Lead Instructor and Founder of PSPT RequirementsA basic knowledge of mathematics and trigonometry Audience Electrical Engineers Technologists Technicians Electrical Students Audience Electrical Engineers Technologists Technicians Electrical Students

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that in the UK alone, there are over 1.2 million job openings in the tech sector? And guess what? Coding skills are in high demand! But where do you even begin? This Coding Training Bundle is your one-stop shop to becoming a coding wizard, no matter your starting point. Our Coding (Computer Programming, Python & JavaScript) bundle equips you with the fundamental building blocks of coding, empowering you to build websites, automate tasks, and even create your own software. You'll master the fundamentals of web development with HTML, CSS, and JavaScript. Then, refine your knowledge of object-oriented programming with Python and C++, learning to build robust applications. Finally, solidify your understanding of JavaScript with a dedicated course. This Coding Bundle Contains 4 of Our Premium Courses for One Discounted Price: Course 01: Introduction to Coding With HTML, CSS, & Javascript Course 03: Python Basic Programming for Absolute Beginners Course 02: C++ Programming for Absolute Beginners Course 04: JavaScript Fundamentals Don't miss out on this opportunity to become a tech-savvy professional and unlock your true potential. Enrol today in this Coding course and start coding your way to success! Learning Outcomes of Coding: Computer Programming (Python) Understand the basic building blocks of web development with HTML, CSS, and Javascript. Grasp core Python programming concepts like variables, data types, loops, and functions. Explore C++, a powerful language for game development and systems programming. Solidify your understanding of Javascript, a cornerstone of web and mobile app development. Gain the foundational knowledge to pursue further learning in various coding specializations. Develop the problem-solving and analytical skills crucial for a successful coding career. Why Choose Us? Get a Free CPD Accredited Certificate upon completion of Coding: Computer Programming (Python) Get a free student ID card with Coding: Computer Programming (Python) Training program (£10 postal charge will be applicable for international delivery) The Coding: Computer Programming (Python) is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Coding: Computer Programming (Python) course materials The Coding: Computer Programming (Python) comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Introduction to Coding With HTML, CSS, & Javascript Welcome HTML 5 CSS 3 Bootstrap Project 1 - Design A Landing Page Project 2 - Business Website Project 3 - Portfolio Course 02: Python Basic Programming for Absolute Beginners Section 01: Introduction Section 02: Introduction To Python And Setting Up Section 03: PythonBasic Section 04: Python Strings Section 05: Python Operators Section 06: Python Sequences Section 07: Python Statements Section 08: Python Control Flow Statements Section 09: Python Games For Beginners Section 10: Python Functions Section 11: Working With File Structure Section 12: Regular Expressions Section 13: PythonProject Course 03: C++ Programming for Absolute Beginners Section 01: Getting Started With C++ Section 02: Setting Up Local Development Section 03: C++ Basics Section 04: C++ Data Types Section 05: C++ Operators Section 06: C++ Strings Section 07: C++ Decision Making Section 08: C++ Control Flow Loops Section 09: C++ Arrays Section 10: C++ Functions How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*4 = £51) CPD Hard Copy Certificate: £29.99 CPD 160 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Tech enthusiasts Creative minds Problem solvers Future coders Career changers Requirements You will not need any prior background or expertise in this Coding bundle. Career path This Coding bundle will allow you to kickstart or take your career in the related sector to the next stage, such as: Web Developer Software Engineer Data Analyst Mobile App Developer Game Developer Freelancer Certificates CPD QS Accredited PDF Certificate Digital certificate - Included CPD QS Accredited Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

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 Event Management - Party Planner 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 the professional training that employers are looking for in today's workplaces. The Event Management - Party Planner Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Event Management - Party Planner 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 Event Management - Party Planner Course, like every one of Skillwise'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 Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Event Management - Party Planner? Unlimited access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance 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 Event Management - Party Planner 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Event Management - Party Planner 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 skills. Prerequisites This Event Management - Party Planner does not require you to have any prior qualifications or experience. You can just enroll and start learning. This Event Management - Party Planner was made by professionals and it is compatible with all PCs, Macs, 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 a bonus, you will be able to pursue multiple occupations. This Event Management - Party Planner is a great way for you to gain multiple skills from the comfort of your home.   Module 01: Introduction to Party Planner Introduction to Party Planner 00:12:00 Module 02: Types of Parties - Overview Types of Parties - Overview 00:16:00 Module 03: Skills You Need to Be a Party Planner Skills You Need to Be a Party Planner 00:15:00 Module 04: Starting Your Party Planning Business Starting Your Party Planning Business 00:13:00 Module 05: Party Planning Business Functions Party Planning Business Functions 00:18:00 Module 06: Initial Planning & Budgeting Initial Planning & Budgeting 00:21:00 Module 07: Guest Demographics Guest Demographics 00:13:00 Module 08: Choosing a Theme Choosing a Theme 00:17:00 Module 09: Venue Requirements Venue Requirements 00:16:00 Module 10: Food and Beverage Food and Beverage 00:13:00 Module 11: Vendors Every Party Planner Should Know Vendors Every Party Planner Should Know 00:19:00 Module 12: Generating a Client Base Generating a Client Base 00:23:00 Module 13: Networking Networking 00:18:00 Module 14: Making the Party Memorable Making the Party Memorable 00:24:00 Assignment Assignment - Event Management - Party Planner 07:01:00

SQL Queries Course, 1-Day. Basic SQL syntax. This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. Private individuals are also very welcome.

Whether you're crafting a compelling blog, scrutinising a screenplay, or decoding ad scripts, you need to deploy and perceive language with the target audience at heart. The A-Level English Language course, designed for the self-paced scholar, empowers you to refine your command of a tongue embraced by 390 million worldwide 🌍. Delve into a comprehensive array of texts and augment your critical understanding with our bespoke course.  If your aspirations hinge on written and spoken communication, English Language is a powerful asset to bolster your career trajectory. A-Levels are not just qualifications; they're a testament to your proficiency, a beacon recognised and respected by universities and employers across the UK. An A-Level is not just a line on your CV, but a symbol of academic rigour, enhancing your career prospects and unlocking new horizons 🌈. This distance learning course, sculpted to the most current specifications, is your stepping stone to success. It kicks off with a lucid induction and assignments intricately designed to help you accumulate the skills and knowledge needed for the final hurdle - the exam 🎯. What's in it for you?  A fresh, invigorating course tailored to the latest specifications with dynamic content 📚 The fast track option (exams due 2022) for those eager to accelerate their progress ⏩ A complimentary e-textbook to facilitate your learning 📖 Access to a consortium of partnership exam centres (guaranteed exam venue) 📍 Limitless tutor support - from drafting a study plan to unwavering support throughout your journey 📈 An exam pass guarantee - If at first you don't succeed, we'll steer you towards your next attempt 🥇 Awarding Body: AQA Our course code: X903 Qualification code: 7702 AQA qualifications are not only internationally acclaimed and taught in 30 countries but also highly sought after by employers and universities. They enable students to springboard into the next stage of their lives. Our suite of AQA qualifications caters to a diverse range of abilities and includes GCSEs, IGCSEs, and A-levels 🏅. ⏳ Study Hours Anticipate committing between 250 and 300 hours to this comprehensive course. This estimate includes time dedicated to the completion of assignments.  💻 Study Method Our digital learning platform offers an engaging, dynamic, and flexible learning experience. Should you prefer hard copies, all learning materials can be printed at your convenience. We utilise a multitude of media to deliver this course, including videos, quizzes, and interactive exercises.  📚 Course Duration Embark on your learning voyage today. Benefit from unlimited support from our dedicated tutors for up to 24 months from your enrolment date. ✍️ Assessment Examinations are scheduled from Summer 2022. Your course will culminate in two standard written exams: Official Examinations: 2 hours 30 minutes, accounting for 40% of your total grade 2 hours 30 minutes, accounting for 40% of your total grade 1 coursework task, contributing 20% of your total grade (refer to NEA section) We will provide a guaranteed exam location at one of our many centres nationwide for your convenience. Assignments During your course journey, you will be asked to complete: • 10 assignments These are non-graded tasks designed to provide opportunities for tutor feedback and to gauge your progress. Non-exam Assessment (NEA): • 1 coursework task, contributing 20% of your total grade This coursework, part of the A-level assessment, is completed during your learning journey and forwarded to your exam centre for marking. More details will be provided upon enrolment. 🎓 Course Outcomes Upon successful completion, you will be awarded an A-Level in English Language by AQA (7702). This syllabus is specifically selected for its compatibility with distance learning. Your certification will be identical to those conferred by traditional schools, colleges, and universities. 📚 Additional Information Difficulty - Level 3 Pre-requisites - A strong recommendation of prior study in English language to GCSE level or equivalent. UCAS Points - 56 📘 Course Content Methods of language analysisPhonetics, phonology and prosodicsGraphologyLexis and semanticsGrammar, including morphologyPragmaticsDiscourse Textual variations and representationsThe textual range (various subjects, writers, audiences)Functions of the textsIdentity and representationsHow audiences are addressed and positionedStructure and organisation of the texts Children’s language developmentPhonological, pragmatic, lexical, semantic and grammatical developmentThe development of written languageThe functions of children’s languageTheories and research about language development Diversity and changeLanguage in its wider social, geographical and temporal contextsProcesses of language changeSocial attitudes to language diversity and change Language discoursesStudying texts that convey attitudes to language diversity and changeMethods of conveying views and opinions about language issues: representations, identities and positioning.Connecting to discourses about languageThe directed writing task Language Investigation (NEA)Choosing an investigation focusCarrying out the investigation (including ethics, record keeping and referencing)Organising and analysing the data and interpretation of findingsConcluding your investigation Original writing (NEA)An overview of the assessment and marking criteria, including organising and referencing workChoosing your area of original writing (Power of persuasion, storytelling & power of information)Choosing and analysing style modelsProducing a reflective commentary Preparing for the A Level examinationsRevision TipsExam TechniquesPreparing for Paper 1Preparing for Paper 2 Delve into the subtleties and nuances of the English language, studying everything from phonetics to pragmatics, grammar to graphology, and language development to discourses. This course will provide you with a comprehensive understanding of the richness and diversity of English, equipping you with the knowledge and skills needed for your A-Level examination.