2985 Design courses in Linlithgow delivered Live Online

Duration 2 Days 12 CPD hours This course is intended for This SQL training course is designed for students new to writing SQL queries. Overview Upon successful completion of this course, students will be able to: - Understand how relational databases work - Use SQL to output reports - Write queries to obtain data from multiple tables. Students will learn SQL to build applications or to generate business reports.The SQL learned in the course is applicable to all major databases. Relational Database Basics Brief History of SQL Relational Databases Popular Databases SQL Statements Simple SELECTs Introduction to the Northwind Database Some Basics SELECTing All Columns in All Rows Exploring the Tables SELECTing Specific Columns Sorting Records The WHERE Clause and Operator Symbols Using the WHERE clause to check for equality or inequality Using the WHERE clause to check for greater or less than Checking for NULL Using WHERE and ORDER BY Together The WHERE Clause and Operator Words More SELECTs with WHERE Checking Multiple Conditions Writing SELECTs with Multiple Conditions Advanced SELECTs Calculated Fields Calculating Fields Aggregate Functions and Grouping Working with Aggregate Functions Built-in Data Manipulation Functions Data Manipulation Functions Subqueries, Joins and Unions Subqueries Joins Using Joins Outer Joins Unions Working with Unions If time allows, one or more of the following may be covered: Conditional Processing with CASE INSERT, UPDATE, DELETE Student Challenges - Design your own reports

Duration 5 Days 30 CPD hours This course is intended for This course is intended for administrators in a Microsoft-centric environment who want to build reusable units of automation, automate business processes, and enable less-technical colleagues to accomplish administrative tasks. Overview Describe the correct patterns for building modularized tools in Windows PowerShell Build highly modularized functions that comply with native PowerShell patterns Build controller scripts that expose user interfaces and automate business processes Manage data in a variety of formats Write automated tests for tools Debug tools This course covers advanced Windows PowerShell topics, with an emphasis on building reusable tools. Students are introduced to workflow, engage in best practices, and learn a variety of script development and toolmaking techniques. Tool Design Tools do one thing Tools are flexible Tools look native Start with a Command Why start with a command? Discovery and experimentation Build a Basic Function and Module Start with a basic function Create a script module Check prerequisites Run the new command Adding CmdletBinding and Parameterizing About CmdletBinding and common parameters Accepting pipeline input Mandatory-ness Parameter validation Parmeter aliases Emitting Objects as Output Assembling information Constructing and emitting output Quick tests An Interlude: Changing Your Approach Examining a script Critiquing a script Revising the script Using Verbose, Warning, and Informational Output Knowing the six channels Adding verbose and warning output Doing more with verbose output Informational output Comment-Based Help Where to put your help Getting started Going further with comment-based help Broken help Handling Errors Understanding errors and exceptions Bad handling Two reasons for exception handling Handling exceptions in our tool Capturing the actual exception Handling exceptions for non-commands Going further with exception handling Deprecated exception handling Basic Debugging Two kinds of bugs The ultimate goal of debugging Developing assumptions Write-Debug Set-PSBreakpoint The PowerShell ISE Going Deeper with Parameters Parameter positions Validation Multiple parameter sets Value from remaining arguments Help messages Aliases More CmdletBinding Writing Full Help External help Using PlatyPs Supporting online help ?About? topics Making your help updatable Unit Testing Your Code Sketching out the test Making something to test Expanding the test Going further with Pester Extending Output Types Understanding types The Extensible Type System Extending an object Using Update-TypeData Analyzing Your Script Performing a basic analysis Analyzing the analysis Publishing Your Tools Begin with a manifest Publishing to PowerShell Gallery Publishing to private repositories Basic Controllers: Automation Scripts and Menus Building a menu Using UIChoice Writing a process controller Proxy Functions A proxy example Creating the proxy base Modifying the proxy Adding or removing parameters Working with XML Data Simple: CliXML Importing native XML ConvertTo-XML Creating native XML from scratch Working with JSON Data Converting to JSON Converting from JSON Working with SQL Server Data SQL Server terminology and facts Connecting to the server and database Writing a query Running a query Invoke-SqlCmd Thinking about tool design patterns Design tools that use SQL Server for data storage Final Exam Lab problem Break down the problem Do the design Test the commands Code the tool

Develop a deep understanding of electricity pricing and marginal cost analysis with EnergyEdge's virtual instructor-led training course. Enroll now for a rewarding learning journey!

Help! I can't Wait to ask for a Break...and more! This workshop is a must for parents, caregivers and professionals working and/or living with people who have complex communication needs. You will learn how to teach critical communication skills that lead to greater independence in the home, work, school and community settings. We review nine specific skills: requesting reinforcers, requesting help, requesting a break, indicating yes and no, waiting, following directions, schedule-following and transitioning. Through lecture, demonstrations, video and participatory activities, you will acquire specific teaching strategies that are relevant for anyone who has limited communication skills, regardless of their communicative modality (e.g., Picture Exchange Communication System [PECS], signing, device use, speech). WHAT YOU WILL LEARN Define functional communication Identify and evaluate nine critical communication skills Design effective teaching strategies to promote these skills independent of modality Incorporate effective visual strategies for all communicators Incorporate critical communication skills into functional activities and routines WORKSHOP DETAILS Agenda: 9:00 AM - 4:30 PM Registration Time: 8:30 AM - 9:00 AM Tuition Includes: Detailed handout with space for note taking, delegate practise/resources pack - value £15 Certificate of Attendance CEUs: 6.0 BACB CEUs; Satisfactory completion of this course requires participants to be present for the duration of the course and to participate in all student responding activities (e.g. questions, role play, quizzes, and surveys). Pyramid Educational Consultants is an approved BACB ACE Provider for Learning (Type 2) Continuing Education Credits. The BACB does not warrant, endorse, sponsor, approve, or partner with the event, organisation, or instructor.

Training duration: 10 hrs Course info Method: 1-2-1, Personalized attention, Tailored content, Flexible pace, Individual support. Schedule: Personalized training experience with our flexible 1-2-1 sessions. Tailor your own schedule by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 am and 7 pm. Unlock visual effects and motion graphics skills with our 3ds Max and After Effects Course. Certified tutors guide you through seamless integration of 3D models and animations. Live online format, recorded lessons, and lifetime email support provided. Enroll now and explore exciting career opportunities in visual effects, animation, and motion graphics. Course Outline: Adobe After Effects Fundamentals. Getting Started Overview of the workspace and interface. Importing and organizing assets for seamless workflow. Understanding projects and compositions for effective project management. Working with layers to create complex compositions. Applying Effects (FX) Introduction to applying effects in After Effects. Fixed and applied FX for enhancing visual appeal. Understanding animation principles for smooth motion. Modifying motion paths to control animation trajectories. Mastering keyframes for precise animation control. Exploring the basics of the graph editor for advanced animation adjustments. Text Animation Creating and animating text in After Effects. Enhancing text with layer styles for engaging visuals. Utilizing animation options for dynamic text effects. Implementing motion blur for realistic motion. Shape Layers Introduction to shape layers and their versatility. Creating shapes from Illustrator files for flexible designs. Working with paths and their applications in animations. Utilizing animation options to breathe life into shapes. Exporting and Finalizing Projects Effective project management and organization techniques. Understanding export options for optimal rendering. Exporting projects through Media Encoder for various platforms. Utilizing dynamic link to Premiere Pro for seamless integration. Masks and Chroma-keying Creating and animating masks for selective visual effects. Utilizing tracking masks for precise adjustments. Limiting effects to specific areas using track mattes and property links. Mastering green-screen chroma-keying with Keylight 1.2. Additional Effects Exploring additional effects such as Warp Stabilizer, Camera Tracker, Motion Tracker, and Puppet Pin tool. Implementing these effects to enhance motion graphics and visual effects. Creative applications and hands-on practice with each effect. By the end of this fast-paced and practical Adobe After Effects training course, participants will achieve the following learning outcomes: Key Skills in After Effects: Gain proficiency in essential After Effects skills to transform video projects effectively. Professional Techniques: Master a range of professional techniques and processes invaluable for film makers, motion designers, and animators. Project Planning: Learn how to plan projects, prepare assets, and set compositions for seamless video production. Animation and Effects: Acquire the ability to apply and animate various transformations and effects on images, videos, and text elements. Masking and Compositing: Develop skills in masking and compositing to create visually stunning and cohesive compositions. Rendering Videos: Understand the video rendering process to produce high-quality final outputs.

For new users and the curious. Hello, For new users and the curious. IMPORTANT: Firstly, once you are signed up, send us your requests on what you would like to see within the demonstration and learn on the course. We will then cater for your needs and answer them during the session. This is designed to be an introduction into how to start a room by room survey using the Heat Engineer app, then sending this survey to the online dashboard. We will then go through the different steps to complete this heat loss report. Optional pages will also be worked through and shown. Examples of how to select the flow temperature and the heat source (heat pumps and boilers) will be presented once the heat loss result is completed.

Why Choose 3ds Max Basics Training Course? Click for more info What am I going to get from this course? Create your own models in 3ds Max; Use built in poly modelling tools to create basic 3D objects. Learn everything you need about 3ds Max with this guide, from the basics of modelling and animation to more advanced steps.  Duration: 10 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. 3ds Max Basic Training Course: Course Name: 3ds Max Basics Training Course. Core Skills for 3D Modeling, Rendering, Animations, and Games. Target Audience: Beginners and new users from diverse industries, including architects, interior designers, engineers, game developers, artists, and animators.Course Outline: 3D Modeling and Animation with 3ds MaxI. Introduction to 3ds Max- Course overview and objectives - Navigating the user interface - Basic settings and preferencesII. Creating 3D Objects- Building simple shapes with primitive objects - Craft complex designs using Editable Poly - Enhancing objects with modifiers - Applying materials and textures for realistic effectsIII. Lighting Techniques- Illuminating scenes with different light sources - Exploring various types of lighting - Adjusting light properties for desired effects - Casting shadows to enhance realismIV. Camera Control- Creating and configuring camera views - Fine-tuning camera settings for optimal shots - Animating cameras for dynamic scenesV. Animation Fundamentals- Mastering keyframe animation techniques - Utilizing the time slider and track view - Animating object transformations - Adding movement to materials and texturesVI. Rendering Process- Configuring render settings for high-quality output - Selecting appropriate output formats - Streamlining rendering with batch processing - Enhancing final renders with post-processing effectsVII. Project-Based Learning- Applying acquired skills to complete a final project - Exercising creativity and problem-solving abilities - Integrating modeling, animation, lighting, and rendering into the projectIn-Depth Course Outline:1. Modeling- Edit Poly Modeling: Extrude, Chamfer, Cut, and Slices - Symmetry Mirror Modeling - Designing a Table and Chair - Creating a Basic House Model - Working with Lines and Shapes - Importing Plans from AutoCAD/Vectorworks - Crafting Interior Spaces - Adding Doors, Windows, Railings, and Trees - Implementing Stairs2. Modifiers- Exploring Compound Objects - Utilizing Connect, Scatter, Pro Boolean, Loft, and Terrain Modifiers - Manipulating Bend, Taper, Twist, Stretch, Skew, FFD, Wave, Ripple, and Lattice - Employing the Lathe Modifier for Curved Objects3. 3ds Max Basic Lights- Mastering Omni, Spot, and Direct Lights for Illumination4. 3ds Max Camera- Understanding Free and Target Cameras for Optimal Shots5. Texturing and Rendering- Applying Diffuse and Bump Mapping Techniques - Integrating Environment and Background Images - Configuring Render Settings for High-Quality Images - Lighting and Rendering Scenes in 3ds MaxAre you ready to take your 3D modeling and animation skills to the next level? Download the 30-day free trial of 3ds Max from Autodesk and embark on a transformative learning journey today. Explore the possibilities and unleash your creative potential!

Training duration: 10 hrs Click here for info Method: 1-2-1, Personalized attention, Tailored content, Flexible pace, Individual support. Schedule: Personalized training experience with our flexible 1-2-1 sessions. Tailor your own schedule by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 am and 7 pm. Autodesk Maya Training Course with our flexible evening training course. Designed to accommodate busy schedules, this course allows you to learn Maya at your convenience, either in-person or through live online sessions. Master essential features and workflows to create captivating 3D models, animations, and visual effects. Benefit from expert guidance, hands-on projects, and lifetime email support, ensuring a rewarding learning experience. Enroll now to ignite your creativity and open doors to exciting opportunities in the animation and visual effects industry. The Autodesk Maya Evening Training Course offers a flexible learning option for busy professionals and students with daytime commitments. Master the powerful tools and capabilities of Autodesk Maya during convenient evening sessions. Participants will receive comprehensive training in 3D modeling, materials, animation, lighting, and rendering. The course progresses to advanced topics, including dynamics, character rigging, shading, and compositing. Enroll in this course to develop valuable skills in 3D computer graphics and animation. Benefit from interactive learning experiences and expert guidance, whether attending in-person or joining live online sessions. Maya Evening Training Courses Duration: 10 hours Course Outline: I. Introduction to Maya (1 hour) Gain insights into Maya's versatile applications and interface. Master navigation and project management. II. Creating 3D Models (2 hours) Learn polygon modeling basics and refine objects with precision. III. Texturing and Materials (1 hour) Apply and customize materials for enhanced visuals. IV. Lighting and Rendering (1.5 hours) Explore lighting techniques and rendering. V. Animation (2.5 hours) Understand animation principles and rig characters. VI. Special Effects (1 hour) Harness particle systems and create captivating effects. VII. Intermediate Modeling Techniques (1 hour) Venture into NURBS modeling and sculpting tools. VIII. Conclusion and Next Steps (0.5 hour) Recap and explore further learning resources. Autodesk Maya Evening Training Course Topics Covered: Modeling, Texturing, Animation, Lighting, Rendering, and more. Download Autodesk Maya! Create expansive worlds, characters, and effects. Subscribe now for a year and start your 3D model and animation journey. Visit https://www.autodesk.co.uk/maya for a free trial. Upon completing the Autodesk Maya Evening Training Course, participants will gain proficiency in 3D modeling, texturing, animation, lighting, and rendering using Autodesk Maya. They will acquire the skills to create captivating visuals and animations, opening up opportunities in diverse industries such as entertainment, gaming, and architectural visualization. The flexible evening schedule allows for convenient learning, accommodating busy professionals and students.

Why Choose Twinmotion Realtime Rendering Training Course? Click here for info Empower architects, designers, and visualization experts with our Twinmotion training. Learn tools, materials, lighting, animation, and rendering. Explore advanced techniques for lifelike landscape and special effects using Twinmotion's asset library. Opt for in-person or live online sessions. Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm Twinmotion Real-time 3D Architecture Visualization Course Outline: Module 1: Introduction to Twinmotion Explore Twinmotion's real-time 3D visualization capabilities Master the Twinmotion interface for efficient scene manipulation Prepare 3D files for import and manage the workflow Module 2: Materials and Realism Enhance scenes with realistic materials and visual quality Utilize videos as materials and apply glow effects Create grunge materials for added texture and realism Employ the X-ray material for specific visualization needs Module 3: Landscape and Vegetation Integrate vegetation using Twinmotion's scatter, HQ trees, and growth features Customize grass and utilize HQ vegetation assets for realism Create time-lapse effects for vegetation growth Module 4: Library and Object Import Access the Twinmotion library for furniture and objects Seamlessly import external 3D objects Obtain high-quality 3D assets from the internet and add to the user library Utilize BIM-objects for additional assets Module 5: Lighting and Animation Work with various lighting options, including area light and volumetric light Add animated characters and vehicles for dynamism Incorporate construction vehicles and aircraft for realism Module 6: Volumes and Interactivity Utilize volumes and the animator feature for dynamic scenes Implement urban elements and measurement tools for accuracy Module 7: Nature and Weather Effects Utilize Twinmotion's nature features, including physical sky and weather effects Create realistic lighting for outdoor scenes Add ocean effects for water elements Module 8: Rendering Techniques Master rendering processes, from creating images to exporting panoramas and animations Implement depth of field improvements for captivating visuals Create BIM motion virtual reality phases for immersive experiences Utilize the Twinmotion presenter feature for streamlined presentations Module 9: Final Project Apply knowledge and skills to complete a final render project in Twinmotion Download Twinmotion https://www.twinmotion.com › download Learn how to download and install Twinmotion, the fast, easy real-time archvis tool.

Introduction to AI for Business