Who is this course for? The Architecture and Interior Design course is ideal for individuals aiming to master both interior design and architecture. Guided by certified tutors from Autodesk and Adobe, students will gain comprehensive skills in these fields. Click here for more info: Website Duration: 40 hours.1-on-1 Training. In-Person or Live online. When can I book: 9 am - 7 pm (Choose your preferred day and time once a week). Flexible timing with advance booking Course Features: Compatibility: Our training courses are compatible with both Mac and Windows operating systems, ensuring accessibility for all users. Price Assurance: We guarantee the best value for your investment, ensuring competitive pricing for high-quality training. Personalized Training: Benefit from one-on-one training sessions tailored to your specific needs and skill level, ensuring a personalized learning experience. Flexible Scheduling: Enjoy the flexibility to choose your preferred training time and day. Sessions are available seven days a week, from Monday to Sunday, between 9 am and 8 pm, accommodating your busy schedule. Lifetime Support: Receive lifetime email and phone support, ensuring that you have access to assistance even after completing the course. Technical Assistance: Get help with configuring your computer for software installation, ensuring a smooth learning experience without technical hurdles. Referral Discounts: Earn special discounts when you refer a friend to our courses, making learning a rewarding experience for you and your network. Group Training Savings: Avail significant savings on group training courses, encouraging collaborative learning and making education more accessible for groups. When can you schedule this Training Course? Personalized training experience with our flexible 1-on-1 sessions. Design your own timetable by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 a.m. and 7 p.m. Alternatively, you can call 02077202581 to book over the phone. How long is the training? The course spans 40 hours, which you can divide over as many days as needed to fit your ideal schedule. What's the teaching method? Our sessions are 1-on-1, offered either in-person face to face or live online. You'll receive personalized attention, tailored content, a flexible learning pace, and individual support. Live online 1-on-1 sessions over Zoom are also an option. What will you learn? In this comprehensive training program, you'll gain proficiency in a thoughtfully curated selection of software tools. Option A: AutoCAD (13 hours) SketchUp (10 hours) Vray (6 hours) Photoshop (6 hours) InDesign (5 hours) Additionally, you'll receive free online portfolio design assistance, career growth guidance, and mock interviews to enhance your job market readiness. Option B: AutoCAD (10 hours) 3ds Max (17 hours) Vray (4 hours) Photoshop (5 hours) InDesign (4 hours) Certified trainers in AutoCAD, 3ds Max, SketchUp, and Adobe software will conduct this training program. It caters to beginners, intermediate, and advanced learners, focusing on core skills for creating 2D drawings, plans, sections, elevations, construction details, and 3D visualizations. Our experienced instructors will guide you through essential commands and methodologies for producing precise 2D and 3D drawings. We have developed these CAD courses, utilizing the expertise of our professionals to provide the most efficient and effective instruction. Upon completion, participants will: Master Software Tools: Excel in AutoCAD, SketchUp, Vray, Photoshop, and InDesign for digital design. Advanced Design Skills: Create intricate 2D/3D designs, plans, and visualizations. Project Management: Manage layouts, plotting, and projects efficiently. Realistic Rendering: Produce lifelike visualizations using Vray. Creative Composition: Understand design principles for impactful creations. Portfolio Development: Create a professional online portfolio. Career Readiness: Prepare for job interviews and enhance resumes. Potential Jobs: Architect Interior/Exterior Designer CAD Technician Visualization Specialist Design Consultant Project Manager These skills open doors to varied roles in architecture and design, ensuring career growth and job readiness. Course Features: Compatibility: Our training courses are compatible with both Mac and Windows operating systems, ensuring accessibility for all users. Price Assurance: We guarantee the best value for your investment, ensuring competitive pricing for high-quality training. Personalized Training: Benefit from one-on-one training sessions tailored to your specific needs and skill level, ensuring a personalized learning experience. Flexible Scheduling: Enjoy the flexibility to choose your preferred training time and day. Sessions are available seven days a week, from Monday to Sunday, between 9 am and 8 pm, accommodating your busy schedule. Lifetime Support: Receive lifetime email and phone support, ensuring that you have access to assistance even after completing the course. Technical Assistance: Get help with configuring your computer for software installation, ensuring a smooth learning experience without technical hurdles. Referral Discounts: Earn special discounts when you refer a friend to our courses, making learning a rewarding experience for you and your network. Group Training Savings: Avail significant savings on group training courses, encouraging collaborative learning and making education more accessible for groups. When can you schedule this Training Course? Personalized training experience with our flexible 1-on-1 sessions. Design your own timetable by pre-booking a convenient hour of your choice, available from Monday to Saturday between 9 a.m. and 7 p.m. Alternatively, you can call 02077202581 to book over the phone. How long is the training? The course spans 40 hours, which you can divide over as many days as needed to fit your ideal schedule. What's the teaching method? Our sessions are 1-on-1, offered either in-person face to face or live online. You'll receive personalized attention, tailored content, a flexible learning pace, and individual support. Live online 1-on-1 sessions over Zoom are also an option. What will you learn? In this comprehensive training program, you'll gain proficiency in a thoughtfully curated selection of software tools. Option A: AutoCAD (13 hours) SketchUp (10 hours) Vray (6 hours) Photoshop (6 hours) InDesign (5 hours) Additionally, you'll receive free online portfolio design assistance, career growth guidance, and mock interviews to enhance your job market readiness. Option B: AutoCAD (10 hours) 3ds Max (17 hours) Vray (4 hours) Photoshop (5 hours) InDesign (4 hours) Certified trainers in AutoCAD, 3ds Max, SketchUp, and Adobe software will conduct this training program. It caters to beginners, intermediate, and advanced learners, focusing on core skills for creating 2D drawings, plans, sections, elevations, construction details, and 3D visualizations. Our experienced instructors will guide you through essential commands and methodologies for producing precise 2D and 3D drawings. We have developed these CAD courses, utilizing the expertise of our professionals to provide the most efficient and effective instruction.
Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.
Become a Certified User Experience Professional Build a career in UX with the world’s only university credit-rated online UX course. Acquire the mindset, the skills and the confidence that make UX designers so valuable. A rewarding and meaningful career awaits. Why become a UX designer? Be in demand UX is a high-growth sector. The demand for UX designers far outstrips the supply of qualified professionals. Get well paid UX designers are highly paid. The average entry-level salary for a UX designer in the United Kingdom is £35,465 (PayScale, 2019) Love your job UX designers make an impact. They solve real-world problems using an exciting mix of research, design, technology and psychology. Study method Online, self-paced Duration 6 months Access to content 12 months Qualification Level 8 Diploma - User Experience Design Awarded by Glasgow Caledonian University Regulated by SQA Additional info Exam(s) / assessment(s) is included in price Tutor is available to students Description Duration: 6 months Get certified in six months following a flexible, structured learning path. Delivery: Online The course is delivered entirely online, including video modules, mentor-led webinars and support. Assessment: 2-hour exam Before getting certified, you'll be assessed during a two-hour exam taken online. Outcomes for you Think like a UX designer; adopt the mindset that sets them apart Showcase your knowledge with a portfolio of project work Speak with the confidence that comes from a true, deep understanding of UX Advance your career with job-ready skills Complete a university credit-rated course, valued by employers globally Become a Certified UX Professional Learn with us We’ve worked hard to design the best possible online learning experience for you. As well as an unmatched syllabus, our approach includes: Projects & portfolio Learn by doing with a series of real-world projects ideal for your UX portfolio. Mentors & webinars Be guided by our hand-picked, world-class mentors during monthly webinars. Structure & support Stay motivated with a structured programme supported by fellow students and our customer success team. What you’ll learn We’ve put together a university credit-rated curriculum that’s deep, rigorous and covers everything you need to know to become a certified UX professional and turbocharge your career. Module 01 - Introduction to UX design Module 02 - User research Module 03 - User goals Module 04 - Structure and navigation Module 05 - Interactions Module 06 - Design principles Module 07 - Design patterns Module 08 - Mobile Module 09 - Workflows Module 10 - Prototyping and handover Module 11 - AI and UX Module 12 - Creating your portfolio Module 13 - Career guidance Hub Tutorials for Figma Projects and portfolio - Projects that build into a portfolio Exam - 2-hour final exam Requirements Background You don’t need experience in design or technology to enrol in our courses, although having one or both is a definite bonus. Our students come from a diverse array of backgrounds, including project management, development, graphic design, product management, business analysis and so on. Commitment You do need to be motivated and committed. We set a high bar. Studying for one of our professional qualifications requires a certain amount of time, energy and focus. Our team will be there to support you along every step of the way but success will come as a result of your own diligence. Career path The average salary for entry level user experience designers is £28,000 The average salary for user experience designers with 1-5 years experience ranges from £29,000 to £50,000 The average salary for user experience managers/leads is £80,000 Information from LinkedIn Salary Reports, based on real jobs listings.
Data has become the most important resource for every organisation – but the insights gained from data analysis will only ever be truly valuable if they can be clearly expressed to other people. This course is for anybody who works with data, and needs to communicate the meaning that's in the numbers to colleagues, customers, bosses or external stakeholders. It will give you or your team the confidence and skills to translate raw data into compelling visual stories for your key audiences. The principles and skills covered apply to the simplest PowerPoint chart, to more complex interactive visualisations. We’ll work with you before the course to ensure that we understand your organisation and what you’re hoping to achieve. Sample learning content Session 1: What makes a great data-driven story The key elements of a successful infographic or presentation. Industry best practice, and discussion of good (and bad) examples. A simple framework for identifying the Audience, Story and Action. Session 2: Data in context How to balance function and aesthetic appeal. Identifying the right graph, chart, infographic or other visual. Framing the data and providing contextual information. Session 3: Designing for the human brain Using colours to add emphasis and meaning. Design and layout principles, and creating hierarchies of information. The principle of ‘self-sufficiency’, and removing clutter. Session 4: Navigation and narrative Tailoring visualisations for different types of communications. Structuring presentations and longer reports. Thinking in layers to create interactive dashboards. Delivery We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people. Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets. Testimonial “I was familiar with Alan’s work as a Guardian Masterclass instructor on data visualisation and digital journalism, which made it easy for me to recommend him for onsite training at the Liverpool School of Tropical Medicine. We had a large group of people interested in honing their abilities to depict their research and stories in engaging ways. Alan’s course provided great insight about common communication pitfalls and how to avoid them, how to become better communicators by understanding the audience diversity, and it showcased some great online tools for creating infographics. This should be mandatory training for all students, academics, report writers and those involved with conveying research to the media as it will help increase the clarity and accessibility of our own research stories.” Dr Lee Haines | Liverpool School of Tropical Medicine
Film and VFX face to face training customised and bespoke. One to One Online or Face to Face
1-2-1 bespoke training course
ITIL® 4 Specialist: High Velocity IT: In-House Training The ITIL® 4 Specialist: High-Velocity IT module is part of the Managing Professional stream for ITIL® 4. Candidates need to pass the related certification exam for working towards the Managing Professional (MP) designation. This course is based on the ITIL® 4 Specialist: High-Velocity IT exam specifications from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, candidates acquire the relevant knowledge required to pass the certification exam. This module addresses the specifics of digital transformation and helps organizations to evolve towards a convergence of business and technology, or to establish a new digital organization. It was designed to enable practitioners to explore the ways in which digital organizations and digital operating models function in high-velocity environments. Working practices such as Agile and Lean, and technical practices and technologies such as Cloud, Automation, and Automatic Testing are included. What You Will Learn At the end of this course, participants will be able to: Understand concepts regarding the high-velocity nature of the digital enterprise, including the demand it places on IT. Understand the digital product lifecycle in terms of the ITIL operating model. Understand the importance of the ITIL guiding principles and other fundamental concepts for delivering high-velocity IT. Know how to contribute to achieving value with digital products. Course Introduction Let's Get to Know Each Other Course Learning Objectives Target Audience Characteristics ITIL® 4 Certification Scheme Course Components Course Agenda Module-End Exercises Exam Details Introduction to High-Velocity IT High-Velocity IT Digital Technology Digital Organizations Digital Transformation High-Velocity IT Approaches Relevance of High-Velocity IT Approaches High-Velocity IT Approaches in Detail High-Velocity IT Operating Models Introduction ITIL® Perspective High-Velocity IT Aspects High-Velocity IT Applications ITIL® Building Blocks for High-Velocity IT Digital Product Lifecycle Service Value Streams Four Dimensions of Service Management ITIL® Management Practices High-Velocity IT Culture Key Behavior Patterns ITIL® Guiding Principles Supporting Models and Concepts for Purpose Ethics Design Thinking Supporting Models and Concepts for People Reconstructing for Service Agility Safety Culture Stress Prevention Supporting Models and Concepts for Progress Working in Complex Environments Lean Culture ITIL® Continual Improvement Model High-Velocity IT Objectives and Techniques High-Velocity IT Objectives High-Velocity IT Techniques Techniques for Valuable Investments Prioritization Techniques Minimum Viable Products and Services Product / Service Ownership A/B Testing Techniques for Fast Developments Basic Concepts Related to Fast Development Infrastructure as Code Reviews Continual Business Analysis Continuous Integration / Continuous Delivery (CI/CD) Continuous Testing Kanban Techniques for Resilient Operations Introduction to Resilient Operations Technical Debt Chaos Engineering Definition of Done Version Control Algorithmic IT Operations ChatOps Site Reliability Engineering (SRE) Techniques for Co-created Value Basic Concepts of Co-created Value Service Experience Techniques for Assured Conformance DevOps Audit Defense Toolkit DevSecOpsPeer Review
Join us for an insightful masterclass that delves into the profound effects of neglect on a child's life. This session is meticulously designed for professionals working closely with children in various educational settings, providing essential knowledge and practical tools to identify, manage, and seek support for neglected children.
Enhance your expertise in HV/MV power system design and protection coordination with EnergyEdge's virtual instructor-led training. Join now!
Essential GEPON training course description Designed to benefit those requiring an in depth knowledge of the principles and applications of the IEEE Ten Gigabit Ethernet and Gigabit Ethernet Passive Optical Networking and Fibre to the X in NG network applications and their associated equipment, its flexibility and function within a modern transmission network. Using an effective mix of instruction and correlation to theory based learning the delegate will gain a complete understanding of the equipment and the tasks to be undertaken in a real life situation. What will you learn Compare FTTx networks. Compare PON variants. Recognise the GEPON architecture. Explain how GEPON works. Recognise GEPON issues. Essential GEPON training course details Who will benefit: Anyone requiring GEPON knowledge. Prerequisites: Introduction to data communications and networking. Duration 2 days Essential GEPON training course contents FTTN, FTTC, FTTH Single Mode Fibre (SMF) and various types, Multimode Fibre (MMF), Fibre Safety and properties (Dispersion/attenuation), Fibre Reel cables and types, Fibre installation and air blown fibre, Transmitters and receivers - power budget/laser classes, Fibre to the home (FTTH), FTTC (Fibre to the Cabinet), FTTN (Fibre to the node), FTTD (Fibre to the Desk), FFTH Topologies and wavelengths, Active or Passive Optical Network (PON). WDM equipment and GPON OSP design Wavelength considerations, WDM/DWDM/CWDM EDFA optical amplification, AWG (Arrayed Waveguide Grating) splitters, Couplers (splitters) and losses, Optical splitters 1x2, 1x4, 1x8, 1x16, 1x32, 1x64, 2x64. IEEE PON variants Gigabit Ethernet Passive Optical Network (GEPON), Time Division PON (TDM-PON), Wave Division Multiplexing PON (WDM-PON), 1Gbps, 10Gbps, 40Ggps, 100Gbps, Strategies for TDM-PON to WDM-PON migration, Architecture of NG-PON (hybrid WDM/TDM PON), Additional services than triple play. GEPON design GEPON OSP centralized design, GEPON OSP distributed design, GEPON PON splitters x4 x8 x32, Fibre splice trays / fibre cassette trays / fibre enclosures, GEPON field testing /GEPON field installation verification, GEPON physical layer testing, Optical Time Domain Reflectometer (OTDR), Optical power source /Optical power meter, Optical Return Loss (ORL), APON/BPON/GPON/EPON/GEPON/10-GEPON comparison. IEEE 802.3ah GEPON: Ethernet in the first mile IEEE 802.3 options, Optical Ethernet options, Ethernet in the first mile, 1000BASE-LX, 1000BASE-SX, IEEE 802.1Q VLANs, Q-in-Q and MAC-in-MAC. QofS Ethernet TOS and priority methods PCP and DiffServe, Reference model / terminology / architecture, Example of ONT functional blocks, Example of OLT functional blocks, FTTx scenarios, The four switching arrangements for external access network backup. IEEE 802.3av 10-GEPON Physical layer, 10GBASE-SR, 10GBASE-LX4, 10GBASE-ER, 10GBASE-LR, 10GBASESW, 10GBASE-LW, 10GBASE-EW, Enhancement band, Bit rate and wavelengths, Compatibility, Forward error correction. IEEE 802.3ca 25G, 50G and 100G NG-EPON MAC frame structure, Downstream multiplexing / Upstream multiplexing, Media access control and ONU registration, Alarm messages. IEEE 802.3bk extended EPON Laser Types PRX40 and PR40, Reference model. GEPON issues and standards GEPON components OLT / GEPON ONT and examples GEPON management, RG (Residential Gateway), HPNA (Home Phone Network Alliance), Power Line Carrier (PLC), GPON DLNI, G.hn or G.9960 MOCA, FTTH Council certification, Standard for network certification, Qualify for use of the fibre-connected home badge, GEPON frame synchronization to network timing, Direct clock synchronization interface (BITS), Multiservice Access Platform (MSAP), Software planning tool. Superconnected cities / voucher scheme. Ethernet OAM Link monitoring, remote failure indication, Remote loopback.