2171 Languages courses

English Language Course for adults to study for 5 weeks and attend 21 hours of lessons per week.  

Duration 3 Days 18 CPD hours This course is intended for This course is geared for anyone needing to interface with an Oracle database such as end users, business analysts, application developers and database administrators / DBAs. Overview Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course participants will explore: Using PL/SQL programming language for database applications and development incorporating PL/SQL modules within the application architecture from the initial design and planning phase The essentials of building executable PL/SQL program units Each of the major segments of a working program and how these interact with each other during program execution Important error or exception handling capabilities of the language. How database-resident program units can be used as part of the overall database application architecture Applying these new skills to the development of PL/SQL packages. Advanced database programming capabilities and benefits How database triggers can be used as part of an advanced database application design Oracle 19c PL/SQL Fundamentals is a three-day, hands-on course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The course also explores applying the newly learned skills to the development of database applications. Participants will learn how to use database-resident stored program units such as procedures, functions, packages and database triggers. Students will also learn about the latest features in Oracle 19c. 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 and Substitution Variables Using SQL Developer Using SQL *Plus Choosing a Database Programming Language What is Database Programming PL/SQL Programming PL/SQL Performance Advantages Integration with Other Languages PL/SQL Language Essentials PL/SQL Program Structure Language Syntax Rules Embedding SQL Writing Readable Code Generating Readable Code Generating Database Output SQL * Plus Input of 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 & Braching 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 Extend Cursor Techniques For Update of Clause Where Current of Clause Using for ? Loop Cursors Introduction Database Resident Programming Units About Database ? Resident Programs Physical Storage & Execution Types of Stored Program Units Stored Program Unit Advantages Modular Design Principles Creating Stored Procedures and 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 and 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 Programming Units Recompiling Programs Mass Recompilation Using UTL_RECOMP() Dropping Procedures & Functions Drop 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 About Packages Creating Packages Maintaining Packages Performance Considerations Advanced Package Capabilities Definer & Invoker Rights White Lists & Accessible By Persistent Global Objects Defining Initilization Logic Object Orientation Support Advanced Cursor Techniques Using Cursor Variables Using SYS_REFCURSOR Using Cursor Expressions Using System Supplied Packages DBMS_OUTPUT() UTL_FILE() FOPEN() Example Database Trigger Concepts About Database Triggers DML Event Trigger Sub-Types Database Trigger Scenario Trigger Exhaustion Mechanisms Trigger 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 and 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 Defining the Scope Available System Events System Event Attributes

This comprehensive, hands-on course empowers beginners with essential web development skills. From HTML, CSS, and JavaScript to GitHub and Bootstrap, master the tools of the trade. Learn to build, style, and deploy websites effortlessly. No prior knowledge of programming or web development is needed.

Master the art of self-hosting WordPress on Linux with our comprehensive video course, designed to empower technical professionals to fully control their web presence.

Arabic Legal Writing and Drafting Skills Why Attend This course focuses on clear legal writing in Arabic. Effective communication with lawyers is about more than simply words. It entails understanding the unique way lawyers think and approach the legal, political, and business world. During this Arabic course, a number of legal documents are discussed, including drafting contracts, letters, policies and company bylaws. Participants also look at a wide variety of commercial agreements during practical drafting sessions. This course helps participants to draft confidently and effectively in Arabic regardless of the governing law. Course Methodology The course consists of group discussions as well as individual and team tasks. There will be writing practice throughout the exercises. Course Objectives By the end of the course, participants will be able to: Apply a plain Arabic style of writing to all legal documents Recognize the need for legal clarity in different types of legal documents: legal letters, emails, memorandum and opinions Apply good legal writing practice Use best practice techniques to write contracts, letters, policies and company bylaws Correct common mistakes in legal writing Address and deal with challenges and issues relating to the use of legal jargon Proofread effectively Target Audience The course is suitable for Arabic speakers looking for a better understanding of how to write Arabic legal documents. This course is for lawyers, legal secretaries, commercial managers, contract managers, HR executives and managers, purchasing managers, tender executives and anyone who must draft, amend or update contracts, legal letters and company policies and bylaws.  Target Competencies Drafting letters, policies, company bylaws and contracts Proofreading Writing in plain Arabic Understanding legal terms Legal writing practice Note The Dubai Government Legal Affairs Department has introduced a Continuing Legal Professional Development (CLPD) programme to legal consultants authorised to practice through a licensed firm in the Emirate of Dubai. We are proud to announce that the Dubai Government Legal Affairs Department has accredited EMG Associates as a CLPD provider. In addition, all our legal programmes have been approved. Basic legal writing concepts and contract drafting The various types of legal documents Tips in writing bilingual legal documents Signs of a well drafted contract; the simple rules! The language of drafting Identifying the legal formalities for a binding contract Structure and formation of a commercial contract: following the formula The importance of Boilerplate clauses Plain Arabic in legal correspondence and writing a legal letter Good legal writing practice Pitfalls and issues relating to the use of legal jargon in legal writing Writing different types of emails Layout of a letter Body of a letter Putting a letter together Typical sentences in legal letters The letter writing clinic: looking at the ten most common problems Writing a legal policy or company bylaw and legal writing troubleshooting Layout of a policy or bylaw Body of a policy or bylaw How to write the best policy or bylaw Understanding the principles of legal interpretation The four defects that affect legal writing Use of consistent terminology Easily confused words How courts react to legal writing and what to expect

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want This Professional Web Design Course will help you to learn the art of web design and gain expertise in the latest design tools, coding languages, empowering you to create stunning websites and launch a successful career in web designing. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Learn the fundamentals of web designing such as tables, background images, and customisation Learn the anatomy of a website such as header, navigation, body, footer, and sidebar Understand navigation styles such as the sidebar, horizontal, hamburger theory, and multimedia menus Learn everything about color theory, domain names, KPIs, and website layout techniques Understand different Photoshop web design projects such as Nike, Manhattan, Seaside, Real Estate, Retro Gallery, and Trek Mountain Bike Camp Know how to use Hamburger menu and hero images to outperform your website's UI Develop an understanding of HTML, structure of an HTML doc, images and attributes Understand the meaning of pseudo-classes, pseudo-elements and selectors Have a basic knowledge of font, background styles, and style sheets Why Professional Web Design Course right for you? This professional web design course online is designed for those who want to learn web design basics, beautiful typography, use colors like a pro and understand how to work with images, icons, spacing and layout. You will learn the super cool jquery effects such as animations, scroll effects and sticky navigation. By the end of this course, you will have a thorough understanding of simple-to-use web design guidelines and tips to make your website stand out from the crowd. Professional Web Design Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum How IT Works How IT Works Introduction Introduction Photoshop Crash Course for Web Design Types of Layers Aligning Layers Stack, Copy + Delete Layers Organizing Layers Layer Styles Type Tool Shapes 101 5 Essential Tools 101 Gradient Tools 101 Smart Objects 101 History Panel 101 Retouching Tools 101 - Stamp Tool Retouching Tools 101 - Patch Tool Retouching Tools 101 - Content Aware Tool Anatomy of Website - for Web Designers Header Navigation Hero Body Footer Sidebar Web Design Styles Brief History & My Thoughts 7 Popular Web Design Styles Get Inspired Grid System + Bonus Tip Grid System Bonus: Pixel Perfect Photoshop Web Design Project 1 - Nike Briefing of Project Images Retouch Images Retouch Like a Pro - Quick Tip Header Part 1 Header Part 2 Mega Menu Hero Body Footer Photoshop Web Design Project 2 - Manhattan Logo Redesign Header Hero Part 1 Hero Part 2 Social Proof - Body Part 1 or Part of Hero Body Part 2 Body Part 4 - Part 1 Body Part 4 - Part 2 Footer Final Tweaks Photoshop Web Design Project 3 - Seaside Briefing of Project Logo Header Hero Body - Services Body - Samples Part 1 Body - Samples Part 2 Body - Samples Part 3 Body - Samples Part 4 Body - Contact Footer Tweaks Photoshop Web Design Project 4 - Real Estate Briefing of Project Retouch Hero Imag Header Hero Custom Icons Part 1 Custom Icons Part 2 Body - Services Body - Property Owner Call to Action Body - Listings Body - Blog + Sidebar Footer Tweaks Photoshop Web Design Project 5 - Watkins Glen Briefing of Project Header + Hero Body - Things to do Part 1 Body - Things to do Part 2 Body - Info Footer Tweaks Photoshop Web Design Project 6 - Retro Gallery Briefing of Project Logo Header Hero Part 1 - Custom Retro Slider Hero Part 2 - Custom Retro Slider Hero Part 3 - Custom Retro Slider E-commerce Listings Part 1 E-commerce Listings Part 2 Footer Photoshop Web Design Project 7 - Trek Mountain Bike Camp Briefing of Project Watercolor Header + Hero Body Content Body Register Footer Who should take this course? This comprehensive professional web design course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of professional web design. Entry Requirements There are no academic entry requirements for this professional web design course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This professional web design course online assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Description: In today's world websites are a basic necessity for everyone. All businesses have a website to advertise their products and services to existing and new customers. This course is what you need to understand web development basics as it will help you discover niche, identify platforms, select web host, use SEO & social sites and more. You do not want to fall behind everyone else, which is why you should consider taking this accredited Web Development Complete Course. You will be able to find out website design terminologies, discover new techniques to build your website for free, creating your site layout and a lot more. This is all geared towards helping you build your desired websites. In the next section, you focus on programming languages including HTML, CSS and PHP to see if these intrigue you enough to take the challenging yet unique road to web development. If you decide against that though, this course is prepared to teach you to use Joomla in order to get started in creating your first ever website. Who is the course for? People who want to learn PHP, HTML and CSS programming People interested in website development Entrepreneurs or business owners wanting to develop a website for their business Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Web Development Complete Course is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Web developers Entrepreneurs Website designers Programmers Basic Coding for Web Development HTML Basics 00:30:00 CSS Basics 01:00:00 Web Design & Development: HTML5, CSS3 and JavaScript 02:00:00 Web Development Basics What Are Niche Website? 01:00:00 The Role Of Visualization In Education 00:15:00 Identify Your Best Platform Or Software 01:00:00 Select A Web Host 01:00:00 Collect Your Site 00:15:00 Building A Content Rich Website 00:15:00 Build Backlinks 00:30:00 Use SEO, Multimedia And Social Sites 01:30:00 Use Analytics 01:00:00 Wrapping Up 00:15:00 Web Designing The Best Website Design for Your Business 01:00:00 What's in a Domain Suffixes 00:31:00 Website Design Terminology 01:00:00 CSS Explanation 01:00:00 Website Designs & Power Stations 01:00:00 How Can I Build my Website for Free 01:00:00 Six Steps to Website Design for Beginners 01:00:00 Dreamweaver or CoffeeCup for Website Design 01:00:00 Using Dreamweaver to Create your Site Layout 00:30:00 Three Crucial Steps to Creating Your Website 01:00:00 Dos and Don'ts of Website Creation9 01:00:00 SEO Basics for Effective Website Design 01:30:00 Ideas for Your Internet Business Website Design 01:00:00 Immediately Applicable Design Tips for a User-Friendly Website 01:00:00 6 Best Reasons to Create a Website 01:00:00 Common Mistakes in Website Design 01:00:00 Too Much or Too Little 00:30:00 Why Successful Website Development is Committed to Design 01:00:00 Ideas for Your Personal Website Design 01:00:00 How to Create a Social Networking Website to Enhance your Business 01:00:00 Tips for Designing an Affiliate Website 01:00:00 How to Use WordPress for your Website 01:30:00 Top 14 Reasons to Create a Blog 00:30:00 Tips for Designing a Successful Blog 00:30:00 More Tips Ahead 00:30:00 PHP Programming Welcome to the world of programming! 00:30:00 Getting Started 01:00:00 Let's Start Coding! 01:00:00 PHP Strings 01:00:00 PHP Variables 01:00:00 Useful Variables 00:30:00 PHP Includes & Problem Solving 01:00:00 Tip When Creating Inc Pages 00:30:00 Redirecting Using PHP 00:30:00 Multiple Conditions 01:00:00 PHP Arrays 01:00:00 PHP Loops 01:00:00 Note on PHP Math Functions: 00:30:00 Functions 01:00:00 PHP Sessions 00:30:00 Cookies 01:00:00 Introduction to MySQL 01:00:00 Making The Connection 01:00:00 Inserting Data 01:00:00 Deleting / Removing Data 00:15:00 Using Joomla INTRODUCTION TO JOOMLA 00:30:00 SCOPE OF JOOMLA 00:30:00 BENEFITS OF JOOMLA 00:30:00 COMPARISON WITH OTHER CONTENT MANAGEMENT SYSTEMS 01:00:00 WHY DEVELOPERS DRAWS TO JOOMLA? 00:30:00 How do I in install Joomla? 03:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Web Development Complete Course 00:30:00 Final Exam Final Exam- Web Development Complete Course 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Live & study Spanish in your teacher’s home in Valencia! Immerse yourself in the vibrant culture and language with 20 hours of personalized Spanish lessons, held in cozy settings or while exploring the city, all guided by your host-teacher.

Live & study Spanish in your teacher’s home in Barcelona! Experience the city’s rich culture and language with 20 hours of tailored Spanish lessons, whether in comfortable indoor spaces or while discovering Barcelona’s iconic sights.

English Language Course for adult students who want to study for 5 weeks and attend 15 hours of lessons per week.