259 Courses in Nottingham delivered Live Online

UNIX shell programming training course description This course has been designed as a follow on course for the XML primer course. The course looks at the use of XSLT in the transforming and styling XML documents. What will you learn Read shell scripts. Write shell scripts. Use different types of quotes. Recognise the role of shell scripts within the UNIX system. UNIX shell programming training course details Who will benefit: Programmers developing programs under UNIX. Anyone working with XML. Administrators Support personnel who wish to find out more about the workings of UNIX or write simple utility programs. Prerequisites: UNIX fundamentals Some programming experience would be useful although not essential. Duration 2 days UNIX shell programming training course contents Review of UNIX fundamentals Basic shell scripts What does the shell do? How are commands executed? Different shells. What is a shell script? Comments, creating shell scripts. Variables Setting variables, using variables, set, scope, export, sourcing, environmental variables, read. Positional parameters 0 to $9, $#, $* and others. shift parameter substitution. Control statements The test command, The if statement, while loops, for loops, The case statement, Special characters, Redirection of errors, here documents, quoting. Arithmetic in shell scripts The expr command. System shell scripts Screen handling The terminfo database The tput comand Avanced issues (optional session) Shell functions, getopts, xargs, debugging shell scripts, portability issues. Extras in the Korn shell. Optimising shell scripts The time command, performance tips.

Course Objectives At the end of this course you will be able to: Do advance Table design Do advance Query design and Action Querys Do advance Form design with the use of macros and buttons Export and import data to and from different sources. 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Advanced Table Design Advanced Field Properties Table Properties Advanced Query Design Advanced Naming Conventions Join Tables in Queries Manage Query Joins Use Self-Joins in Queries Summarise Data in Queries Parameter Queries Action Queries Crosstab Queries Advanced Form Design Create Subforms and Linked Forms Form Controls Command Buttons Form Properties Interface, Start-Up and Navigations Forms Working with Macros Create Single Macros Run Macros Work with Sub Macros Use Conditional Macros Run Macros from Buttons Assign Macros to Events Extending Data Reach Import Data Export Data Work with Linked Tables Managing Databases Object Dependencies Database Documenter Performance Analyzers Regular Management of a Database Access Database Security Who is this course for? Who is this course for? The course is aimed at all users who would like to obtain the necessary skills to create advanced table, query, form and reports as well as to automate tasks with the use of macros. Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

Duration 1 Days 6 CPD hours This course is intended for The intended audience for this course would be those who have been using Office 365 for some time and are now looking at optimizing their existing business processes and designing new ones. Overview #NAME? This course delivers an instructor-led product showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product, turning business processes into automated, consistent and visual workPower Automates. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workPower Automate logic for your business workPower Automates. 1 - An Introduction to Power Automate What is Microsoft Power Automate? The benefits of automation How to get to Power Automate Lab 1: Setup your tenant Setup Office 365 Download Course Files Customise your App Launcher Create accounts for colleagues After completing this module, students will be able to: Know what Microsoft Power Automate is The Benefits of using Power Automate to automate processes How to access a Power Automate 2 - Getting Started with Power Automate Using Power Automate templates Navigating in Power Automate Editing a Power Automate Publish and trigger a Power Automate Turn off or delete a Power Automate Lab 1: Building processes in Office 365 Create a Team with a channel Build an absence business process Testing the absence process Optional: Create Feedback Form Optional: Power Automate to Notify of Bad Ratings Optional: Test your Form and Power Automate After completing this module, students will be able to: How to use Power Automate tempaltes How to navigate around Power Automate How to edit Power Automates How to publish and trigger Power Automates How to turn off or delete Power Automates 3 - Power Automate Logic Adding conditions Designing switches Using apply to each Configuring do until logic Adding a scope Lab 1: Scheduling documentation reviews Setup a policy library in SharePoint Design a policy review schedule Testing the policy review process Optional: Notify if a file nears review After completing this module, students will be able to: How to add condtions in a Power Automate How to design switches for a Power Automate How to use apply to each How to configure do until logic How to add a scope 4 - Integration Standard and premium connectors Connecting to web services Using Power Automate with on-premises data Lab 1: Using Power Automate and SQL to Review Sales Create a new orders list Designing the price check process Testing the price check process Optional: Update with managers After completing this module, students will be able to: How to use Standard and Premium connectors How to connect to web services How to using Power Automate with on-premises data 5 - The Mobile App Downloading the mobile app Signing in and account management Building and managing Power Automates Creating buttons Feeds and approvals Lab 1: Optional: Using the Power Automate mobile app Setting up the Power Automate mobile app Create a new Power Automate in the mobile app Using Power Automate buttons in the app Uninstall the Power Automate mobile app After completing this module, students will be able to: How to download the mobile app How to sign into the mobile app How to build and manage Power Automates in the mobile app How to create buttons in the mobile app How to feed and use approvals in the mobile app 6 - Administration and Maintenance Maintaining a Power Automate View history and analytics Sharing a Power Automate Export and import Power Automates Office 365 administration for Power Automate Environments Data policies Data integration Lab 1: Maintaining your Power Automates Share a Power Automate with a colleague Disabling an active Power Automate Deleting a Power Automate After completing this module, students will be able to: How to maintain a Power Automate How to view history and analytics for a Power Automate How to share a Power Automate How to export and import Power Automates How to administrate a Power Automate in Office 365 How to use data policies in a Power Automate How to use data integration in a Power Automate

WCNA training course description Wireshark is a free network protocol analyser. This hands-on course provides a comprehensive tour of using Wireshark to troubleshoot networks. The course concentrates on the information needed in order to pass the WCNA exam. Students will gain the most from this course only if they already have a sound knowledge of the TCP/IP protocols. What will you learn Analyse packets and protocols in detail. Troubleshoot networks using Wireshark. Find performance problems using Wireshark. Perform network forensics. WCNA training course details Who will benefit: Technical staff looking after networks. Prerequisites: TCP/IP Foundation for engineers Duration 5 days WCNA training course contents What is Wireshark? Network analysis, troubleshooting, network traffic flows. Hands on Download/install Wireshark. Wireshark introduction Capturing packets, libpcap, winpcap, airpcap. Dissectors and plugins. The menus. Right click. Hands on Using Wireshark. Capturing traffic Wireshark and switches and routers. Remote traffic capture. Hands on Capturing packets. Capture filters Applying, identifiers, qualifiers, protocols, addresses, byte values. File sets, ring buffers. Hands on Capture filters. Preferences Configuration folders. Global and personal configurations. Capture preferences, name resolution, protocol settings. Colouring traffic. Profiles. Hands on Customising Wireshark. Time Packet time, timestamps, packet arrival times, delays, traffic rates, packets sizes, overall bytes. Hands on Measuring high latency. Trace file statistics Protocols and applications, conversations, packet lengths, destinations, protocol usages, strams, flows. Hands on Wireshark statistics. Display filters Applying, clearing, expressions, right click, conversations, endpoints, protocols, combining filters, specific bytes, regex filters. Hands on Display traffic. Streams Traffic reassembly, UDP and TCP conversations, SSL. Hands on Recreating streams. Saving Filtered, marked and ranges. Hands on Export. TCP/IP Analysis The expert system. DNS, ARP, IPv4, IPv6, ICMP, UDP, TCP. Hands on Analysing traffic. IO rates and trends Basic graphs, Advanced IO graphs. Round Trip Time, throughput rates. Hands on Graphs. Application analysis DHCP, HTTP, FTP, SMTP. Hands on Analysing application traffic. WiFi Signal strength and interference, monitor mode and promiscuous mode. Data, management and control frames. Hands on WLAN traffic. VoIP Call flows, Jitter, packet loss. RTP, SIP. Hands on Playing back calls. Performance problems Baselining. High latency, arrival times, delta times. Hands on Identifying poor performance. Network forensics Host vs network forensics, unusual traffic patterns, detecting scans and sweeps, suspect traffic. Hands on Signatures. Command line tools Tshark, capinfos, editcap, mergecap, text2pcap, dumpcap. Hands on Command tools.

Why Learn Adobe After Effects Basic to Advanced Training Course? Click here for the course info This course offers basic to advanced training in After Effects, focusing on best techniques for motion graphics and visual effects for films and TV. After Effects is the leading software for motion graphics and VFX, widely used in video and screen-based media, to achieve stunning visual outcomes. Duration: 40 hrs Method: 1-on-1  Schedule: Tailor your own schedule by pre-booking. Available from Mon to Sat 9 am and 7 pm. The introductory training covers fundamental tools and features, including animation techniques, layer control, effects, track mattes, and masks. To gain insight into the effects you'll learn to create, you can explore examples on our blogs. Comprehensive After Effects Training: From Basic to Advanced Course Duration: 40 hours Course Overview: This 40-hour training course is designed to take you from a beginner's level to an advanced understanding of Adobe After Effects. Throughout the course, you will explore various tools, techniques, and features that will enable you to create impressive motion graphics, visual effects, and animations. By the end of the training, you will have gained the expertise to handle After Effects with confidence and efficiency. Course Outline: Module 1: Getting Started with After Effects What is Adobe After Effects? Tour of the interface Setting preferences Setting Auto-Save Module 2: Getting Started with Projects and Compositions Creating a new project/composition Creating a new composition from footage Importing assets Organizing assets Working with layers Module 3: Animation Techniques Keyframing Temporal and spatial keyframes Motion paths Modifying motion paths Orientation Anchor point essentials Rove across time Toggle hold Exponential scale The Graph Editor Motion sketch Module 4: Layer Control Arrange, organize, and navigate layers Lock, hide, and solo layers Understand Switches and Modes view Module 5: Working with Shapes Understanding how shape layers work in After Effects Creating shape layers Multiple shapes on the same layer? Shapes and their anchor points Moving anchor points Animating shapes Module 6: Effects Examples of effects Applying effects Customizing effects properties Module 7: Track Mattes and Masks Creating Masks Creating Track Mattes Differences between masks and track mattes Animating masks and track mattes Module 8: Type and Type Animation Working with type Basic text animation Text animation presets Layer styles Module 9: Exporting Your Compositions Export options in After Effects Exporting directly from After Effects Exporting through Media Encoder   After Effects Free Download & Free Trial https://www.adobe.com â€º products › free-trial-download Download the full official version of Adobe After Effects for free. Create incredible motion graphics and the best visual effects with a free trial today! Learning Outcomes: Master the Adobe After Effects interface and preferences. Efficiently manage projects and compositions, importing and organizing assets. Create captivating animations using keyframing, motion paths, and anchor points. Utilize the Graph Editor for precise motion control. Organize and control layers effectively with Switches and Modes view. Create and animate shape layers for dynamic visual effects. Apply and customize effects to enhance visual impact. Implement masks and track mattes for creative effects. Create text animations and utilize animation presets. Export compositions using various options in After Effects.

Adobe After Effects Fast-Track Course (Live Online) through our comprehensive course, beginners, intermediate, and advanced learners. Perfect your skills at the top Training Centre in the UK. Dive into motion graphics and animation with hands-on training led by expert tutors ensuring a practical and interactive learning experience. Click here for more info: Website Duration: 5 hours Approach: Personalized 1-on-1sessions and Customized content. Schedule: Select your preferred hour from Monday to Saturday between 9 am and 7 pm. Adobe After Effects Essentials (5-hour course) Session 1: Introduction to After Effects (1 hour) Overview of After Effects and its applications in motion graphics and visual effects. Understanding the workspace and interface. Importing and organizing assets for seamless workflow. Creating projects and compositions. Session 2: Animation Basics (1.5 hours) Working with layers: Adding, editing, and arranging layers in the timeline. Keyframe animation: Introduction to keyframes and creating simple animations. Motion paths: Manipulating motion paths for dynamic animations. Easing motion: Applying ease in and ease out to smoothen animations. Animation presets: Utilizing built-in presets for efficient animation. Session 3: Effects and Compositing (1.5 hours) Applying effects: Adding visual effects to layers and compositions. Compositing techniques: Understanding blending modes and layer styles. Masking and track mattes: Using masks to control the visibility of layers and apply effects. Motion tracking: Applying tracking data to objects in a scene. Session 4: Text and Shape Animation (1 hour) Text animation: Creating and animating text layers with different styles. Shape layers: Introduction to shape layers and their applications. Animating shapes: Using shape layers to create dynamic animations. Session 5: Final Project and Exporting (1 hour) Applying all the learned techniques to create a final motion graphics project. Refining the project and adding finishing touches. Understanding export settings and rendering the final output. Read the usefull Blogs https://realanimationworks.com/government-funded-interior-design-courses-in-london-your-path-to-creative-excellence/ Upon completing the Adobe After Effects Essentials course, participants will: Master the Interface: Understand After Effects' layout, tools, and key functionalities, gaining confidence in navigating the software. Animation Proficiency: Gain expertise in animating images, videos, and text layers using keyframes, easing techniques, and smooth transitions. Effects Application: Learn to apply, customize, and animate various visual effects, enhancing the overall visual appeal of multimedia projects. Masking and Precision Editing: Master the art of creating and animating masks for detailed and accurate editing, enabling seamless integration of visual elements. Advanced Compositing Skills: Explore advanced compositing techniques for combining multiple elements seamlessly, achieving professional-level visual integration. Export and Rendering Mastery: Understand export settings, ensuring optimal video quality for diverse output formats. Learn the art of efficient rendering for polished final products. Certificate of Completion: Receive a certificate validating the successful completion of the course, showcasing newfound skills to potential employers or clients. Practical Knowledge: Acquire practical insights and techniques applicable to real-world projects, ensuring the ability to create visually captivating multimedia content independently. Lifetime Learning Support: Benefit from lifetime email support, enabling continuous learning and assistance with any post-course queries or challenges. After Effects CC Training: From Novices to Experts Immerse yourself in the world of motion graphics and VFX with our Adobe Certified After Effects Courses, suitable for total novices and experts alike. Learn to create captivating motion graphics, smooth animations, and stunning special effects in a professional environment. Choose from four learning options: London Classroom: Attend in-person sessions 1-2-1 in our dynamic studio. Live Online Classes: Join interactive classes from the comfort of your home or office. Bespoke Training: Tailor the course to your specific needs and preferences. Whichever path you select, all options cover the same lesson plan delivered by our Certified Professional Trainers. Rest assured, your learning experience is fully supported by our 100% Satisfaction Guarantee. Personalized After Effects Training: Tailored for You! Custom one-on-one sessions, in-person or online. Work with your files, learn at your pace. Expert trainers in London. Team training available. Benefits: Unlimited post-course support via phone/email. Access to training materials and a handbook. Free pre-course consultation. Achieve impressive results: create captivating videos, animated logos, and more. Master cinematic effects and enhance your visual storytelling skills.

Microsoft Lync training course description This course teaches IT staff how to plan, design, deploy, configure, and administer a Microsoft Lync Server solution. The course emphasizes Lync Server Enterprise Unified Communications features focussing particularly on coexisting with and migrating from legacy communication services. The labs in this course create a solution that includes IM and Presence, Conferencing, and Persistent Chat. This course helps prepare for Exam 70-336. What will you learn Describe the Lync Server architecture. Install and deploy Lync Server. Use Lync Server management interfaces. Deploy and manage clients. Manage and administer dial-in conferencing. Design audio and video for web conferencing. Plan for instant message and presence Federation. Deploy and configure persistent chat in Lync. Configure archiving and monitoring services. Troubleshoot Lync Server. Describe the required daily, weekly, and monthly maintenance tasks. Use SIP commands and analyze SIP logs. Configure high availability features in Lync. Design load balancing in Lync Server. Backup and restore Lync Server data. Microsoft Lync training course details Who will benefit: Technical staff working with Microsoft Lync. Prerequisites: Supporting Windows 2008 or 2012. Duration 5 days Microsoft Lync training course contents Microsoft Lync Server architecture Lync Server architecture, Lync core capabilities, Lync design process, assessing infrastructure requirements and updating the design, planning for all Microsoft solutions framework phases. Designing a Lync Server topology Infrastructure requirements for Lync Server, using the planning tool, using topology builder, server infrastructure, documentation. Hands on Environment preparation and Lync Server pools. Users and rights in Microsoft Lync Server Managing Lync Server, role based access control. Hands on Using the management shell, configuring role-based access control. Client/device deployment and management Deploy and manage clients, prepare for device deployment, IP phones. Hands on Clients. Conferencing in Lync Server Introduction to conferencing in Lync Server, designing for audio\video and web conferencing, dial-in conferencing in Lync Server, managing and administering conferencing. Hands on Conferencing in Microsoft Lync. Designing and deploying external access Conferencing and external capabilities of Lync Server, planning for IM and presence federation, designing edge services. Hands on Deploying Edge Server and Configuring Remote Access, Validating the Edge Server. Deploying Lync Server persistent chat Overview of persistent chat architecture in Lync Server, designing persistent chat, deploying and persistent chat. Hands on persistent chat server. Monitoring and archiving The archiving service, the monitoring service, configuring archiving and monitoring. Hands on Archiving and monitoring in Lync Server. Administration and maintenance of Lync Lync Server troubleshooting tools, Lync Server operational tasks, Lync Server troubleshooting techniques. Hands on Lync administration tools, centralized logging service, analysing Lync Server logs and traces. High Availability in Lync Server High availability in Lync Server, configuring high availability in Lync Server, planning for load balancing, designing load balancing. Hands on Configuring database mirroring, experiencing a scheduled SQL Server outage, experiencing an unscheduled SQL Server outage. Disaster recovery in Lync Server Disaster recovery in Lync Server, tools for backing up and restoring Lync Server, critical Lync Server data to back up and restore, critical data to export and import, designing branch site resiliency. Hands on Configure pool pairing, experiencing a pool failure or outage. Planning a migration to Lync Server Coexistence and migration, migration steps, planning for clients and devices. Designing a client migration and device migration strategy. Hands on Creating a migration plan, documenting the migration phases.

InDesign is the professional choice for creating brochures, posters, magazines, e-books and apps. Through this Zoom delivered, online introductory course, you will receive expert InDesign training in how to create documents and prepare them for print or export as a PDF. Professional colour management, typography and advanced graphics and effects are all explored. This course covers all you need to know to get started with the application.

At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. Course level is beginners to intermediate.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE Topic A: Explore Crystal Reports Topic B: Use Crystal Reports Help Topic C: Customize Report Settings 2 - WORKING WITH REPORTS Topic A: Create a Report Topic B: Modify a Report Topic C: Display Specific Report Data Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS Topic A: Create a Formula Topic B: Edit a Formula Topic C: Filter Data by Using a Formula Topic D: Work with Advanced Formulas and Functions Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS Topic A: Create a Parameter Field Topic B: Use a Range Parameter in a Report Topic C: Create a Prompt 5 - GROUPING REPORT DATA Topic A: Group Report Data Topic B: Modify a Group Report Topic C: Group by Using Parameters Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT Topic A: Format a Report Topic B: Insert Objects in a Report Topic C: Suppress Report Sections Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA Topic A: Create a Report Based on Excel Data Topic B: Modify a Report Generated from Excel Data Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA Topic A: Export Data Topic B: Create Mailing Labels 9 - APPENDIX Appendix A: Setting Up and Configuring Data Sources Appendix B: Using Report Processing Techniques Appendix C: Using Functions in Formulas