3038 Courses delivered Online

Course Overview Access the database and set of services that will put you in touch with the network resources that will get your work completed with this training for Windows Active Directory. The AD is a directory service developed explicitly by Microsoft for Windows domain networks, and knowledge of it is crucial for those working in Network or Security Administration. With this total learning package, you can gain all the skills and techniques for utilising AD to make your IT life more straightforward.  This Active Directory (AD) course provides a valuable introduction to the foundations of the Active Directory Domain Services and their support functions. You will be taught multifunctional competencies with them, from installing and configuring to maintenance and management. A masterclass will also be given for using AD certificate services and managing group policies. Ensure that your knowledge of Windows is complete by taking this comprehensive coaching now. This best selling Active Directory has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Active Directory is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Active Directory is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Active Directory is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Active Directory, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Active Directory will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Active Directory to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Course Overview Discover how to make images come to life and use them to make projects stand out from the crowd with this 2D Animation: Adobe Animate course. During the coaching, you will be given a masterclass on this incredibly popular online application, which is well-known in the professional industry for creating components of video games, films, and company websites. This Adobe Animate tutorial enables you to quickly learn the benefits and functions of this benchmark software. Starting from the basics, you will soon be proficient in digital drawing, character moving and imagery impact. Everything you need to create a unique and functional design for your future productions can be found here, and all are supported by expert guidance and simple instructions. Enrol now and take your animating abilities to new levels of excellence and potential. This best selling 2D Animation: Adobe Animate has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth 2D Animation: Adobe Animate is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The 2D Animation: Adobe Animate is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The 2D Animation: Adobe Animate is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the 2D Animation: Adobe Animate, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the 2D Animation: Adobe Animate will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the 2D Animation: Adobe Animate to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

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.

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.

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.

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.

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

Level 7 QLS Endorsed Course | Endorsed Certificate Included | Plus 5 Career Guided Courses | CPD Accredited

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  

Autocad face to face training customised and bespoke. Online or Face to Face