1735 Courses delivered Live Online

In this week’s RESULTS Mastery Live, we are going to discuss how to use email marketing to increase sales.

A thorough Introduction to Android Studio, packed with essential and interesting features of this package to help you create Android Apps. Online Instructor-led. Classroom on-request. Practical, Hands-on. From basics to efficient.

Join our webinar and learn how to seamlessly integrate the powerful Cademy booking system into your website. Don't miss this opportunity to unlock the potential of seamless course booking and registration on your website. Join us for this informative webinar and discover how to effectively embed the Cademy booking system for a hassle-free experience for your learners.

Join our webinar to discover our best practice advice on how to effectively promote and sell your educational services. Don't miss this opportunity to enhance your course marketing skills and boost your sales. Join us for this engaging webinar and take your educational offerings to new heights.

English as a foreign language Prepare to pass the citizenship English language test (IELTS life skills) Classes from A1 to B1 level of the CEFR (Common European Framework of Reference for Languages) . A1-A2 Elementary This course is designed for students of English who have little knowledge of the English language and want to achieve a better level. The course will focus on speaking practice, reading comprehension and pronunciation skills, writing and grammar. The syllabus: countries, numbers, possessive pronouns, days of the week, pronunciation skills (linking, stress, intonation). Family vocabulary and everyday objects; present tense of most common regular and irregular verbs. Asking questions and talking about activities, can and can’t, transports, some and any, how much and how many. Past simple, regular and irregular verbs, ordering food and drinks, dates and other past time phrases, buying tickets, asking politely, past simple, negative forms and questions, shops and shopping for clothes. Comparative adjectives, use of articles, going out and staying in, might and will, education and careers, filling a form, present perfect and sentence stress. Prepositions of movement, going places and describing things in a town, real life: for example, telephoning; consolidation activities. A2 - B1 Pre-intermediate This course will develop further your English language skills acquired with the Elementary course. This course will help you with the preparation for the citizenship test. Each lesson will focus on a grammar topic, vocabulary, reading and pronunciation practice, writing. The syllabus: revision of questions; present simple and frequency phrases. Talking about leisure activities and games, past simple, positive and negative, time phrases (at, on, in ago), describing feelings, talking about daily routines and jobs; should and shouldn’t, present continuous for future arrangements; inviting people; Comparative and superlative adjectives, questions with: how, what and what … like? Describing people; vowel sounds and silent letters, weak forms of prepositions. Quantifiers with countable and uncountable nouns, asking and giving directions. Present tense after if, adjectives for describing places, talking about how things were in the past, used to, past continuous, talking about health. Like and would like, conditional sentences with would, present simple passive and past simple passive, talking about products and personal items, writing a review, giving your opinion. Present perfect continuous and past perfect. Job interviews, getting a job and personal characteristics, meeting people; making suggestions. B1 - B2 Intermediate Asking and answering questions: everyday activities, people around you. The difference between have and have got. Speaking practice. E-mail writing (informal). Pronunciation and stress sounds activities. Past simple and continuous. Pronunciation of the -ed sound for past simple endings. Vocabulary: remembering and forgetting. Listening and speaking: first meetings and childhood memories (used to). Real life: showing interest. Pronunciation: sounding polite. Speaking practice. The sound /w/. Comparatives and superlatives. Describing towns and cities. Readings and discussions topics about travel and places to visit. Phrases for comparing. Design your own tour. Real life: booking a flight. Present perfect simple: strong and weak forms of ‘have’. Describing life events. Speaking: talking about people you admire. Writing task: curriculum vitae. Vocabulary: ‘take’. For, since and ago and the present perfect continuous. Pronunciation: linking. Comparing the past and the present. Future forms and future clauses with if, when etc. Talking about work. How to write a covering letter. Real life: a formal telephone call. Adjectives: -ed/-ing. Extreme adjectives. Write a review of a book/concert. Writing a consumer review. The passive forms. Speaking practice. Ripetizioni d’inglese Who these courses are for: Italian speakers who live in the UK who want to improve their skills to pass the UK citizenship exams (IELTS life skills). for Italian schoolchildren who need to prepare for exams (such as ‘esame di maturita’). for Italian students who want to improve their grades at school or simply need help with homework. for adults who want to improve their English for work or travel. IELTS – International English Language Testing System Life in the UK Test

Calling all aspiring filmmakers and film enthusiasts! Join us for an engaging taster session on filmmaking, specially designed for students like you. Led by BA Practical Course Leader Devon Dickson, this session aims to explore the art of creating films that go beyond traditional performances and instead capture evocative and unforgettable cinematic truth. Discover how visual narrative can unlock your unique voice as a filmmaker. Devon Dickson, an accomplished writer, producer, and director with over 25 years of experience, will share his valuable insights gained from working on feature films, television shows, and over 300 commercials across 30 countries. His work has reached billions of viewers worldwide, making him a remarkable mentor for budding filmmakers. During this taster session, you'll delve into the philosophy and principles that form the foundations of our teaching here at Central Film School. Through practical examples and captivating case studies, you'll witness how this innovative approach to filmmaking can elevate your creativity and storytelling skills. Whether you're a film student, a passionate movie lover, or simply curious about the art of cinema, this taster session promises to be an inspiring and educational experience. No prior experience in filmmaking is required, so all students are welcome to attend. Don't miss out on this unique opportunity to learn from one of the industry's most experienced professionals. Reserve your spot now and embark on a journey to unlock your unique voice in filmmaking!

Train to become a Driving Instructor with Driving Skills Academy and earn up to £40,000 + per annum after meeting all your business and car expenses. If you want to be your own boss and are looking for a well-paid job that you can fit in and around your lifestyle then becoming a driving instructor could be the ideal full time or part time career.

Classes from A1 to C2 level of the CEFR (Common European Framework of Reference for Languages). A1 - A2 Beginners Let’s start learning French! With this course you will learn the basic elements and key phrases of the French language from the very beginning. You might know a few words and expressions already, but what about making your visit more authentic by interacting with people once you are there? The exercises and activities in this course will build your confidence with useful expressions, pronunciation, grammar practice, verb drills (present tense of most common verbs) and speaking/listening activities, games and quizzes will be included along the way. The syllabus: French language sounds are unique, so you need to know how to pronounce each sound correctly. This course will aim not only at building your confidence when speaking French but also to sound French! Greetings, formal and informal address; how to introduce yourself/ introduce others, ask for something in cafés and restaurants, giving/exchange details, understanding numbers and prices, talking about jobs and family, where you live; asking and understanding directions and other basic vocabulary when going around shopping; you will also learn some cultural traits and fun facts about French people. B1 - B2 Intermediate Now that you know some French, why not improve your language skills further?The intermediate course is structured around grammar activities (such as prepositions, combined articles and pronouns), verb drills (past tenses, progressive forms, future tense), comprehension activities, short stories, common idiomatic expressions, games and quizzes. The syllabus: describing people, booking hotels, booking accommodation online and via emails, more about numbers, describing places, expressing admiration, enquiring about services such as public transport; talking about homes, finding a house; expressing likes and dislikes, shopping (markets), buying shoes and clothes, expressing preferences, writing invitations, giving your opinion, making suggestions, buying tickets, understanding directions, describing situations in the past; making plans for the future. C1 - C2 Advanced The advanced course is designed for students who already know French but want to take their knowledge further in order to hone their skills in all aspects of the language learning. With the advanced course, the student will have the opportunity to learn the grammar and vocabulary acquired with the intermediate course, but more in depth with more listening and practical activities and role play. The focus of this course is to prepare the student to live in a French speaking country. The teaching approach will also include a variety of newspapers articles (short at the beginning and longer articles as the student progresses further). The articles are used as conversation topics in order to hone vocabulary and grammar skills. Short videos from trusted resources will also be used for speaking practice during the class to boost fluency and to learn new common expressions. This course may include writing tasks about specific topics which the student will discuss during the class with the teacher. The syllabus: Includes talking about saying what you have done recently using a variety of verbs and expressions, referring to events in the past using the imperfect tense and the past tense, understanding the weather forecast, making suggestions, understanding and giving instructions, comparing things, giving reasons, solving problems, discussing preferences, asking for and giving advice, talking about holidays, making plans for the future. French school support tuition. We provide help to students who need support with homework in order to pass their exams. Ad hoc extra activities and grammar notes can be provided to revise and consolidate the notions acquired at school. Help with short essay writing and proof reading also available. Online French classes: The online classes are delivered via Skype and classes can be for individuals and for small groups. We can prepare you for DELF B1 (Diplôme d’études en langue Française).

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.

Duration 5 Days 30 CPD hours This course is intended for Security administrators Security consultants Network administrators System engineers Technical support personnel Cisco integrators and partners Overview After taking this course, you should be able to: Describe key concepts of NGIPS and NGFW technology and the Cisco Firepower Threat Defense system, and identify deployment scenarios Perform initial Cisco Firepower Threat Defense device configuration and setup tasks Describe how to manage traffic and implement Quality of Service (QoS) using Cisco Firepower Threat Defense Describe how to implement NAT by using Cisco Firepower Threat Defense Perform an initial network discovery, using Cisco Firepower to identify hosts, applications, and services Describe the behavior, usage, and implementation procedure for access control policies Describe the concepts and procedures for implementing security intelligence features This course gives you knowledge and skills to use and configure Cisco© Firepower Threat Defense technology, beginning with initial device setup and configuration and including routing, high availability, Cisco Adaptive Security Appliance (ASA) to Cisco Firepower Threat Defense migration, traffic control, and Network Address Translation (NAT). You will learn how to implement advanced Next-Generation Firewall (NGFW) and Next-Generation Intrusion Prevention System (NGIPS) features, including network intelligence, file type detection, network-based malware detection, and deep packet inspection. You will also learn how to configure site-to-site VPN, remote-access VPN, and Secure Sockets Layer (SSL) decryption before moving on to detailed analysis, system administration, and troubleshooting. Cisco Firepower Threat Defense Overview Examining Firewall and IPS Technology Firepower Threat Defense Features and Components Examining Firepower Platforms Examining Firepower Threat Defense Licensing Cisco Firepower Implementation Use Cases Cisco Firepower NGFW Device Configuration Firepower Threat Defense Device Registration FXOS and Firepower Device Manager Initial Device Setup Managing NGFW Devices Examining Firepower Management Center Policies Examining Objects Examining System Configuration and Health Monitoring Device Management Examining Firepower High Availability Configuring High Availability Cisco ASA to Firepower Migration Migrating from Cisco ASA to Firepower Threat Defense Cisco Firepower NGFW Traffic Control Firepower Threat Defense Packet Processing Implementing QoS Bypassing Traffic Cisco Firepower NGFW Address Translation NAT Basics Implementing NAT NAT Rule Examples Implementing NAT Cisco Firepower Discovery Examining Network Discovery Configuring Network Discovery Implementing Access Control Policies Examining Access Control Policies Examining Access Control Policy Rules and Default Action Implementing Further Inspection Examining Connection Events Access Control Policy Advanced Settings Access Control Policy Considerations Implementing an Access Control Policy Security Intelligence Examining Security Intelligence Examining Security Intelligence Objects Security Intelligence Deployment and Logging Implementing Security Intelligence File Control and Advanced Malware Protection Examining Malware and File Policy Examining Advanced Malware Protection Next-Generation Intrusion Prevention Systems Examining Intrusion Prevention and Snort Rules Examining Variables and Variable Sets Examining Intrusion Policies Site-to-Site VPN Examining IPsec Site-to-Site VPN Configuration Site-to-Site VPN Troubleshooting Implementing Site-to-Site VPN Remote-Access VPN Examining Remote-Access VPN Examining Public-Key Cryptography and Certificates Examining Certificate Enrollment Remote-Access VPN Configuration Implementing Remote-Access VPN SSL Decryption Examining SSL Decryption Configuring SSL Policies SSL Decryption Best Practices and Monitoring Detailed Analysis Techniques Examining Event Analysis Examining Event Types Examining Contextual Data Examining Analysis Tools Threat Analysis System Administration Managing Updates Examining User Account Management Features Configuring User Accounts System Administration Cisco Firepower Troubleshooting Examining Common Misconfigurations Examining Troubleshooting Commands Firepower Troubleshooting