140 Courses

Why Learn Bespoke AutoCAD Mac Basic-Intermediate Course? Learn AutoCAD using your projects and learn how to use powerful tools and techniques for drawing, dimensioning, and printing 2D drawings with our Intermediate AutoCAD course. Check our Website How long is the training? 10 hours, Choose and split 10 hrs Mon to Sat 9 am to 7 pm. Book online or call 02077202581 or 07970325184.   Method? 1-on-1, available in both in-person and Live Online. Course Topics Include: Building Fundamental Shapes Working with Lines, Arcs, and Polylines Utilizing Grip Tools Precision Object Alignment Data Management and Backups Exploring File Formats Ensuring Disaster Recovery Mastering Object Creation Handling Measurement Units Dynamic Input Techniques Inquiring Commands and Measurement Tools Effective Object Viewing Navigating Zoom and Pan Object Manipulation Strategies Object Selection Methods Swift Object Management Object Transformation Techniques Scaling and Altering Objects Trim, Extend, and Offset Functions Creating Geometric Variations Object Joining and Editing Corner Filleting and Chamfering Stretching Objects Organizing Your Drawings Layer Management Customizing Object Properties Applying Linetypes Layout Design and Setup Efficient Page Configurations Scaling Drawing Views Adding Annotations Multiline and Single-Line Text Creation Text Styling and Editing Dimensioning Concepts Customizing Dimension Styles Dimension Editing Implementing Multileaders Object Hatching Hatching Editing Reusable Content Management Blocks and Symbols Tool Palette Usage Working with Groups Model Space and Paper Space Understanding Layout Creation and Viewports Viewport Scaling Plotting and PDF Output Managing Multiple Sheet Drawings Utilizing Plotstyles Crafting Custom Drawing Templates Download AutoCAD Mac https://www.autodesk.co.uk After completing the AutoCAD for Mac course, learners can expect the following learning outcomes: Proficiency in AutoCAD: Participants will acquire the skills and knowledge needed to confidently use AutoCAD for Mac, including creating and editing drawings, managing objects, and applying precision techniques. Effective Design Skills: They will gain the ability to produce accurate 2D drawings, making them valuable assets in design-related professions. Jobs that individuals can pursue after completing this course include: Draftsperson: Working in architectural, engineering, or construction firms to create technical drawings and plans. CAD Technician: Assisting in the development of designs for various projects, such as product design or urban planning. Interior Designer: Using AutoCAD for space planning and layout design in the interior design industry. Architectural Designer: Collaborating on architectural projects, including creating floor plans and elevations. Mechanical Designer: Participating in the design and development of mechanical components and systems. Civil Engineering Technician: Supporting civil engineers in designing infrastructure projects, such as roads and bridges. Electrical or Electronics Designer: Assisting in the creation of electrical schematics and electronic circuit diagrams. Landscape Designer: Planning and visualizing outdoor spaces, gardens, and landscapes. Completing this AutoCAD course opens doors to various industries where precise and detailed 2D drawing skills are highly valued. The AutoCAD Mac Bespoke 1 on 1 Basics to Intermediate Level Training Course provides participants with a comprehensive skill set, enabling them to attain proficiency in using AutoCAD Mac. This course covers a wide range of functionalities and caters to individuals at all skill levels, whether they are beginners or experienced users. Participants will begin by learning fundamental features such as drawing, editing, annotations, and dimensioning. As they progress, they will delve into more advanced topics like object manipulation, customizing workspaces, and streamlining workflows. Key Benefits of the Course: Mastery of Mac-AutoCAD: Acquire expertise in both essential and advanced techniques for creating precise 2D drawings. Enhanced Productivity: Increase efficiency by implementing time-saving tips and optimizing your work processes. Versatile Design Abilities: Develop the skills to undertake diverse projects in fields such as architecture, engineering, and more. Industry-Relevant Competencies: Elevate your career prospects across various industries by gaining in-demand AutoCAD skills. Access to Recorded Lessons: Review and reinforce your learning at your convenience with access to recorded lesson sessions. Ongoing Email Support: Receive continuous assistance and guidance via email even after completing the course. Enroll today to benefit from interactive learning experiences guided by experienced instructors. Choose between flexible in-person or online sessions, gain access to lesson recordings, and enjoy a lifetime of email support.  Tailored Guidance: Get personalized coaching and instruction tailored to your unique learning needs and objectives. Convenient Scheduling: Choose from flexible training slots available Monday to Saturday from 9 am to 7 pm, accommodating your busy schedule. Versatile Learning Options: Select between in-person training at our location, conveniently situated just 5 minutes away from Oval Tube Station, or participate in live online sessions from anywhere. Engaging Interactions: Participate in interactive sessions designed for questions, discussions, and problem-solving, creating an immersive learning experience. Effective Progression: Accelerate your learning with focused guidance, allowing you to advance at your own pace while mastering the material. Tailored Curriculum: Customize the course content to align with your prior knowledge and specific areas of interest, ensuring a relevant and engaging learning experience. Real-Time Guidance: Receive immediate feedback from the instructor, enhancing your comprehension and skill development. Comprehensive Support: Enjoy ongoing assistance and clarification opportunities through email or additional sessions beyond the course for an in-depth learning experience.

Give a compliment to your career and take it to the next level. This Adobe After Effects bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Adobe After Effects bundle will help you stay ahead of the pack. Throughout the Adobe After Effects programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Adobe After Effects course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Adobe After Effects Bundle Consists of the following Premium courses: Course 01: Complete Adobe After Effects CC Diploma Course 02: Adobe Lightroom Course 03: Basic Adobe Photoshop Course 04: 2D Animation: Adobe Animate Course 05: Adobe Illustrator Certificate Course Course 06: Adobe Premiere Pro Course 07: Adobe InDesign Training Course 08: Adobe Audition Course 09: Advanced Diploma in User Experience UI/UX Design Course 10: Logo Animation Fundamentals Course 11: Video Editing- DaVinci Resolve Enrol now in Adobe After Effects to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Adobe After Effects expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Course Curriculum : Course 01: Complete Adobe After Effects CC Diploma Module 01 Intro Video Animate Your Name Module 02 Understand the After Effects Workspace Starting a New Composition Adding Media to Your Project and Timeline Using the Basic After Effects Tools Create a Perfect Circle, Alignment, and Shape Colors Working in the Timeline Layer Properties Module 03 Animating in After Effects Position, Scale, and Rotation Animations Tips to Make Your Animations Look More Nautral Using the Graph Editor Challenge - Bouncing Ball Solution - Bouncing Ball Module 04 Working With Solid Layers and the ken Burns Effects Working With Shape Layers, Strokes, and Paths Adding Layer Styles Like Drop Shadow, Bevel, and Gradients Shape Effects - Trim Path Animation, Wiggle, and Zig Zag Module 05 Track Matte Animation - Make Layers Appear And Disappear Using Pre-Compositions to Group Layers Easily Reverse Complicated Animations Playing with Time Blend Modes Stabilize Shaky Footage Module 06 Intro to Motion Graphics Projects Clean Lower Third Logo Reveal Animation Bumper Colorful Transition Text with Mask Path Animation Text Bubble Animation Weather App 1 Weather App 2 Weather App 3 Module 07 Flat Animation Challenge Phil Designs his Flat Animation Scene Animating Fireworks with the Repeater Effect Module 08 Removing Green Screen Background Adding a Background that Matches the Foreground Adding Motion to a Still Image with the Puppet Tool Adding Movement with the Ripple Effect Module 09 Intro to 3D Swinging 3D Text Animation Build Out Your 3D Composition Animating Our 3D Scene Create Stars in After Effects Module 10 Using the Rotoscope Tool Cleaning Up Your Edges Finishing Our Rotobrush Animation Module 11 Easy Screen Replacement with Masks Replacing a Screen Version 2 Screen Replacement with Mocha Module 12 Using the Puppet Pin Tool Animating Your Puppet Pins Animated Blinking Eyes Adding Perspective with Animated Clouds Module 13 Applying Text Animation Presets Create a page Turn Effect with CC page Turn Radial and Linear wipes Color Correction in After Effects Module 14 Motion Tracking Basics Tracking Text and Visual Effects to Video Clip Tracking Rotation and Scale Adding Details to Our Text Module 15 Intro to Character Animation Design Your Character Rigging Your Character Animation Our Character Adding the Animated Background Adding Details to Character Movement Adding the Paper Cut Out Look Module 16 Exporting an H264 File From After Effects Exporting from After Effects with a Transparent Background Exporting from After Effects through Adobe Media Encoder Create an Animated GIF from After Effects Module 17 Audio Tips for After Effects Working with Premiere Pro Module 18 Expressions Basics Animate a Flickering with Expressions Module 19 Conclusion Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Adobe After Effects bundle. Requirements This Adobe After Effects course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Learn advanced joins, folder and workbook integration, and data transformation in our 120-minute course on Microsoft Excel Power Query.

Limited Offer Time | 12-in-1 Premium Bundle | CPD QS Certified | 120 CPD Points | Gifts: Hardcopy + PDF Certificates + Transcript + Student ID Card | Lifetime Access | Customer Support

Do you have Passion for Nails? Are you ready to build and maintain relationships with clients? Do you feel being creative with Nail Styles and Designs? Then, this Online Course is for you. Onces you will finish it you will be ready to clean, shape, trim, file, smooth and polish nails.   Nail Technician Course Introduction This Nail Technician Diploma comprises of 25 informative modules that takes around 20 hours to complete. The course is accompanied by a host of instructional videos, helpful illustrations, how-to instructions, advice and more. During the nail technician course you will have access to online support as you study the introduction to nails, how to start your own business, nail art, marketing your business and so much more. The nail technician course is offered online at an affordable price, giving you the ability to study in the comfort of your own home and at your own pace. You can access the modules anywhere where you have an internet connection and from any smart device. On completion, you can download and print your certificate, which you can use to boost your career as a nail technician moving forward.   Sample tutorial to create nails from the beginning using acrylic application What will you learn on this online nail technician course This course is brimming with 25 modules designed to give you complete training in becoming a successful nail technician and providing you with guidance and insight to starting your own nail salon Understand nail technology and what a nail technician does Learn the different skin layers and how this plays a role in nail technology Get an understanding of nail anatomy, how fast nails grow and the different sections of the nail that you need to know as a nail technician Learn how to prepare your work area effectively. This module covers hygiene and the importance of cleaning your work area effectively between patients Understand the importance of consulting with your clients, offering guidance and how to give clients clear instructions on how to care for their nails moving forward Learn how to perform a manicure from the supplies you will need and how to shape the nails for the best results Learn the art of performing the perfect pedicure each and every time. This module will provide you with the advice you need from what supplies you will need to removing old nail polish to shining nails and more Understand the art of false nails from the supplies you will need to adding plastic tips, lengthening acrylics and finishing off acrylic nails perfectly This module will teach you how to incorporate a hand and arm massage into your nail appointment to provide your clients with an added service Understand all there is to know about gel nails and what makes them so popular You will also get step by step instructions on completing gel nails along with a useful instructional video Get useful advice on using nail tips Learn all there is to know about nail art. Know why a base coat is so important, get inspiration for designs and more Get some valuable tips on nail maintenance and how to help your clients make their manicure and pedicure last longer The importance of health and hygiene and how to keep your work station clean at all times An introduction to salon management Advice on starting your own salon, working as a technician or starting a mobile business Learn how to set up a successful salon with decoration tips and advice Marketing, pricing and merchandising in your salon Understand about staffing your salon, employee law and everything you need to know when it comes to adding staff members to your salon Get valuable insight into customer relations management to ensure the highest levels of customer service at all times Learn to manage costs effectively, along with the importance of reporting and record keeping Benefits of the Nail Technician Diploma   Once you will finish this Online Course, you will be ready to begin your Career as a Nail Technician. You will be ready to work as a Nail Technician or even having your own business. Are you ready for that? Don't wait more time, the future is here, the new future can be tomorrow.   Some of the benefits taking this Nail Technician Online Course  Improved career opportunities Ability to enjoy consistent earnings Study in the comfort of your own home online Study at your own pace Affordable study solution No traveling costs Recognized certification on successful completion and passing of the multiple-choice test Course Content Module 1: Introduction to Nail Technology Module 2: Anatomy of the Skin Module 3 : Nail Anatomy Module 4 : Preparing Your Work Area Module 5 : Client Consultation and Communication, Preparing Your Client Module 6 : How to Perform a Manicure Module 7 : How to Perform a Pedicure Module 8 : Artificial Nails Module 9 : Arm and Hand Massage Module 10 : Gel Polish Module 11 : Nail Tips (Shaping and Painting & Artificial Tips) Module 12 : Basic Nail Art Module 13 : Nail Maintenance Module 14: Health and Hygiene Module 15: An Introduction to Salon Management Module 16: Start a salon, become a mobile technician, or work for someone else? Module 17: Setting up a Salon and Red Tape Module 18: Salon Decoration Module 19: Marketing Your Nail Salon / Service Module 20: Setting Your Pricing Module 21: Merchandising Your Salon Module 22: Employees and Staffing Module 23: Customer Relationship Management Module 24: Managing Costs Module 25: Forms and Record Keeping

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 Adobe After Effects Training 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 Adobe After Effects Training Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This Adobe After Effects Training 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 Adobe After Effects Training 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 Adobe After Effects Training ? Lifetime 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 Adobe After Effects Training 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 Adobe After Effects Training course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This Adobe After Effects Training does not require you to have any prior qualifications or experience. You can just enrol and start learning. This Adobe After Effects Training 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 Adobe After Effects Training is a great way for you to gain multiple skills from the comfort of your home. Course Promo Learn After Effects for Social Media Promo 00:01:00 Project #1(Beginner) - Create an Instagram Story Quick Introduction 00:01:00 Set up Our Project File 00:04:00 Add Our Background and Animate it 00:06:00 Throw in Some Text 00:06:00 Animate the Text In and Out 00:11:00 Music, Render 00:05:00 Project #2 (Intermediate) - Create "Viral Style" Text Boxes and Learn Animation Create a Text Box and Align 00:04:00 The Anchor Point & Scaling 00:06:00 Animating the Text Box 00:04:00 Fit the Text in the Box 00:05:00 The Grand Reveal 00:04:00 Render and Congratulations 00:08:00 Project#3 (Advanced) Screen Capture and Web Presentation Project Screen Capture Software 00:05:00 Replace a Phone or Laptop Screen 00:10:00 Create a '3D' Display 00:09:00 PROJECT - Create your own Web Browser 00:16:00 Project #4 (Advanced) Create a Social Media Animated Poster Social Media Project Introduction 00:02:00 The Master Plan 00:08:00 Time to Design 00:16:00 Trim Paths 00:04:00 Animate Your Image 00:06:00 Let's Talk About Text 00:17:00 Shake that Button 00:09:00 Texture, Render, Congratulations 00:11:00 Assignment Assignment - Adobe After Effects Training 02:28:00 Order Your Certificate Order Your Certificate QLS

Are you new to wood turning? Want to learn in detail about wood turning? Or are you willing to program and sharpen your wood-working skills? Then you are at the right destination, enroll now to benefit from the information provided by our most acnknowledgeable experts. Description:  Wood turning has had a particular place in the business world for many years. It is used in different structures in making furniture and furniture parts, building trim, instrument parts, toys and numerous other valuable and lovely articles in daily use. Through this course, you will learn about wood turning in details. You will learn about lathe and how can you take care of it. You will also be informed about the different tools and equipment that are used. You will also go through the various methods of cutting. You will learn the necessary, skills, knowledge and information of wood turning in this course.  Who is the course for? This course is designed for individuals who are willing to learn about the wood turning in detail and are also willing to take wood turning as their future career profession. It is also for people who are ready to enhance their current skills and abilities in wood turning. 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 CIT 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 hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hard copy 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: Diploma in Wood Turning useful qualification to possess and would be beneficial for the following professionals: Wood mill operator. Facilities manager. Teacher-cabinet making. Furniture Finisher Picture Framer. Wood Machinists Woodturner. Wood machinists and other wood trade's workers. Updated Version - Diploma in Wood Turning Module 01: Introduction to Woodworking Introduction to Woodworking 00:11:00 Module 02: Measurement and Layout Measurement and Layout 00:13:00 Module 03: Hand Tools for Woodworking Hand Tools for Woodworking 00:13:00 Module 04: Power Tools for Woodworking Power Tools for Woodworking 00:17:00 Module 05: Joinery Techniques Joinery Techniques 00:17:00 Module 06: Wood Finishing and Refinishing Part 1 Wood Finishing and Refinishing Part 1 00:14:00 Module 07: Wood Finishing and Refinishing Part 2 Wood Finishing and Refinishing Part 2 00:10:00 Module 08: Advanced Woodworking Techniques Advanced Woodworking Techniques 00:14:00 Old Version - Diploma in Wood Turning Diploma in Wood Turning INTRODUCTORY 01:00:00 THE LATHE 01:00:00 WOOD TURNING TOOLS 01:00:00 SPINDLE TURNING 01:00:00 TOOL PROCESSES IN SPINDLE TURNING 01:00:00 OVAL TURNING 01:00:00 DUPLICATE TURNING 01:00:00 FINISHING AND POLISHING 01:00:00 FACE-PLATE AND CHUCK TURNING 01:00:00 TOOL PROCESSES IN FACE-PLATE AND CHUCK TURNING 01:00:00 SPIRAL TURNING 01:00:00 Mock Exam Mock Exam - Diploma in Wood Turning 00:20:00 Final Exam Final Exam - Diploma in Wood Turning 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

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 2 Days 12 CPD hours Overview #NAME? A course that teaches the core Adobe Captivate skills needed to create eLearning courses. 1 - EXPLORING CAPTIVATE Explore a Finished Captivate Project Zoom and Magnify Navigate a Project Explore and Reset the Workspace Preview the Entire Project 2 - NEW PROJECTS & SOFT SKILLS ELEARNING Create a Blank Project Add Images to Placeholders Import Images Use a Smart Shape as a Button Disable Click Sounds 3 - SCREEN RECORDINGS Rehearse a Script Review Recording Settings Review Recording Modes Record Using Multiple Modes Record a Custom Simulation Record a Demonstration that Pans Manually Record the Screen 4 - VIDEO DEMOS Record a Video Demo Add a Video Zoom Add a Video Pan Smooth a Mouse Path and Show Visual Clicks Split a Video Trim a Video Insert a Video Project into a Standard Project Publish a Video Demo 5 - CAPTIONS, STYLES, TIMING, AND ROUND TRIPPING Insert and Edit Text Captions Edit the Default Caption Style Change a Callout Type Used by a Text Caption Control Slide Timing Control Slide Object Timing Check Spelling Align Slide Objects Export Captions to Word Import Captions from Word into Captivate 6 - POINTERS, PATHS, PATHS, BOXES, AND BUTTONS Control Mouse Effects Edit a Mouse Path Clone an Object Style Insert a Highlight Box Insert an Image Button Control Appear After Timing 7 - IMAGES AND VIDEOS Insert, Resize, and Restore an Image Import Images into the Library Resize, Transform, and Align Images Manage Unused Library Assets Create an Image Slideshow Insert a Video Set Video Properties 8 - AUDIO Work with Rollover Captions Import Audio onto a Slide Object Import Background Audio Add a Slide Note Calibrate a Microphone Record Slide Audio Import Audio onto a Slide Edit an Audio File Insert Silence Convert Text-to-Speech 9 - STATES, ANIMATIONS, AND OBJECT EFFECTS Change State Views for a Button Add an Animation to a slide Insert a Text Animation Apply an Effect to a Slide Object Apply a Free Fall Effect to an Object 10 - SOFTWARE SIMULATIONS Hide the Mouse Replace Phrases Insert a Click Box Insert a Text Entry Box 11 - WORKING WITH POWERPOINT Create a Project from a Presentation Edit the Source Presentation Synchronize with Source Rescale a Project 12 - QUIZZING Edit Quizzing Object Styles Set the Quiz Preferences Question Slides Insert Question Slides Edit a Question Slide Compare Submit All to Submit Buttons Insert a Knowledge Check Review a GIFT File Import a GIFT File into a Project Create Question Pools Move Questions to Pools Insert Random Question Slides 13 - PUBLISHING Apply a Skin Edit, Save, and Delete a Skin Name Slides Check Publish Settings and Add a Loading Screen Publish as SWF and PDF Run the HTML5 Tracker Publish as HTML5

Face to Face Training Customised and Bespoke.