Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Overview In this course, you will create complex reports using tools in Crystal Reports 2016. You will: Create automatic and manual running totals. Work with cross-tab reports. Add subreports. Create drill-downs in a report. Use SQL statements in report processing. Create complex formulas. Add charts to reports. Enhance report functionality. In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency. 1 - CREATING RUNNING TOTALS Topic A: Create a Running Total Field Topic B: Modify a Running Total Field Topic C: Create a Manual Running Total 2 - WORKING WITH CROSS-TABS Topic A: Create a Cross-Tab Report Topic B: Format a Cross-Tab Report Topic C: Create Groups in Cross-Tab Reports 3 - ADDING SUBREPORTS Topic A: Insert a Subreport Topic B: Edit a Subreport Topic C: Share Variables 4 - CREATING DRILL-DOWNS IN A REPORT Topic A: Create a Drill-Down Topic B: Create Headings for Drill-Down Data 5 - USING SQL STATEMENTS IN REPORT PROCESSING Topic A: Create a Report Using SQL Queries Topic B: Summarize Report Data Topic C: Create Joins Using SQL Topic D: Create Subqueries Topic E: Create an SQL Expression Field 6 - CREATING COMPLEX FORMULAS Topic A: Work with Loops Topic B: Work with Arrays 7 - ADDING CHARTS TO REPORTS Topic A: Create Charts Topic B: Create a Chart with Drill-Down Topic C: Create a Top N Chart Topic D: Create a Cross-Tab Chart Topic E: Create Charts for Grouped Data Topic F: Format a Chart Topic G: Create a Chart Template 8 - ENHANCING REPORT FUNCTIONALITY Topic A: Organize Data Based on a Hierarchy Topic B: Create a Dynamic Image Topic C: Create a Report Alert Topic D: Create a Geographic Map 9 - APPENDIX Appendix A: Managing Reports Appendix B: Processing Data on the Server Appendix C: Detecting and Fixing Problems
Become a certified UI designer Learn how to create beautiful, pixel-perfect user interfaces Accelerate your career with an in-demand skillset Get a professional qualification in just 12 weeks Manage your own schedule with our flexible, self-paced online course Expand your career options UI skills are needed worldwide, and demand is growing. With a globally recognised qualification, you’ll become a more valuable, sought-after professional. Design with confidence You’ll understand the ‘why’ of good UI design by knowing the principles behind it. You’ll be able to defend your decisions and design with confidence. Work in a creative, rewarding job UI designers add personality and visual appeal to user interfaces. It’s an enjoyable career that rewards creativity: the perfect entry into tech for visually-minded people. A flexible, university-backed curriculum Our curriculum is university credit-rated and approved by the industry. Over 12 weeks, you’ll learn the principles and skills you need to become a confident UI designer. Study method Online, self-paced Duration 12 weeks Access to content 12 months Qualification Professional Certificate in UI Design Awarded by Scottish Qualifications Authority trading as SQA Additional info Exam(s) / assessment(s) is included in price Tutor is available to students Description During this 12 week, online course you will learn: Introduction to UI Design Brand and Personality Layout Design Principles Interactivity Typography Colour, shapes and effects Iconography and imagery Design process Presenting ideas UI design tools You will also work on a project and your portfolio with access to weekly mentor sessions, an active student community, and support from our student success team. Who is this course for? Graphic designers and digital designers who want to upskill to UI design UI designers who want to strengthen their knowledge and craft UX professionals who want to become more rounded product designers Anybody with a design background looking for a creative job in tech Requirements 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 mix of backgrounds, including project management, development, graphic design, product management, business analysis and so on. You 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. You need to be comfortable learning in English. All video lessons, course materials, webinars, correspondence and the final exam are delivered in English. Career path Students typically graduate into UI Designer jobs. The average UI Designer salary in the UK with 3-5 years experience is £62,500. This is based on data from Payscale, Totaljobs, Indeed, Talent, and Glassdoor
Build a rewarding career in content design Build a rewarding career in content design with a globally recognised, industry-approved qualification. Get the mindset, the confidence and the skills that will help you stand out in a rapidly growing industry. Why take this course: Be in demand. Certified qualifications will help you stand out in a fast-growing industry Build a career with impact. Design content experiences that will influence users worldwide Broaden your opportunities. Optimise your skills to get hired at leading companies Get qualified. Earn a university credit-rated certification approved by industry leaders Gain the confidence you need to succeed. Our mentors, career advisors and student community will support you all the way University credit-rated, industry-approved Our content design course is credit-rated by Glasgow Caledonian University and has been reviewed and endorsed by leaders in the tech industry. It covers everything you need to become a certified content design professional. Study method Online, self-paced Duration 10 weeks Access to content 12 months Qualification Professional Certificate in Content Design Awarded by Scottish Qualifications Authority trading as SQA Additional info Exam(s) / assessment(s) is included in price Tutor is available to students Description In this Professional Certificate in Content Design course you will learn: An introduction to content design. Understand what content design is and the role of a content designer. Principles of good content design Learn the core principles of content design and why it matters. Voice, tone and style Learn how voice, tone, and style can create a cohesive product experience. Understanding your users Uncover your audience's goals and content needs. Writing for interfaces Learn to write microcopy for buttons, notifications and other UI elements. The product mindset Develop a product mindset by learning about product design systems and tools. Testing content Learn how to test, evaluate and improve your content. AI for content design Learn how to use AI tools to become a more effective content designer. Working in content design Learn how to be the content champion within your organisation. Support at every step From day one, you’ll be part of a lively community of tutors, mentors and fellow students that support each other along the way. Student Success team Our friendly and responsive team will help you stay on track and keep you accountable. Course mentor Your course mentor is an expert content designer who brings years of practical insight. Student community Collaborate, share tips and build connections on our lively student Slack channels. Who is this course for? Writers and journalists who want to enhance their skills for the digital world UX and UI designers who want to become more rounded professionals Content designers looking for a formal qualification that validates their expertise Digital marketers who need content design skills to succeed in their roles Anybody with a writing, content or design background looking for a creative tech job Requirements Background You don’t need experience in design or technology to enrol in our courses. To get the most value from this course, you will need some experience in writing and a genuine interest in words and language. 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. English language To take this course, you should be fluent in verbal and written English. If English is not your first language, you should have a proficiency of C1 as defined by the CEFRL (Common European Framework of Reference for Languages).
Phenomenological explorations for existential seekers. Ten live dialogues between Prof Ernesto Spinelli and International Existential Therapists which clearly illustrate their journey intertwined with the method of the investigation. We are looking to highlight the role of the researcher as an existential seeker. Workshop – Reflections on Existence through a Phenomenological Method. The two-hour practical module where participants, inspired by the previous presentation and dialogue, explore and elaborate on their practice and research with the guest teacher and Bárbara Godoy. This process ends with the opportunity to experience oneself in a clearing. Here we can reflect on how our research is affecting, disturbing and inspiring our own relationship with Being. TIMES AND DATES: Ten Saturdays 2 pm to 5 pm (UK time) 27 Jan. “Placebo” with Prof Ernesto Spinelli and Bárbara Godoy 24 Feb. “Reflexivity” with Prof Carla Willig and Prof Ernesto Spinelli 23 March “Homecoming” with Prof Robert Romanyshyn and Prof Ernesto Spinelli 27 April “Ungraspable” with Dr Todd Dubose and Prof Ernesto Spinelli 18 May “Homelessness” with Dr Greg Madison and Prof Ernesto Spinelli 22 Jun. “Psychedelics” with Dr Yaqui Martinez and Prof Ernesto Spinelli 20 Jul. “Anxiety” with Prof Kirk Schneider and Prof Ernesto Spinelli 26 Oct. “Intentionality” with Dr Betty Cannon and Prof Ernesto Spinelli 23 Nov. “Vulnerability” with Prof Simon du Plock and Prof Ernesto Spinelli 12 Dec. “Enacting” with Bárbara Godoy and Prof Ernesto Spinelli Full course (including dialogues): £600 (2 pm to 5 pm – UK time) BOOK HERE > Venue: Online Zoom
Emergencies & Complications 1 DAY INTENSIVE COURSE ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! Additional information ATTENDANCE ONLINE (Theory), IN CLINIC (Practice) COURSE LEVEL INTERMEDIATE | Advanced Course
Fibre splicing training course description A short, concise hands on fibre optic cable splicing course providing comprehensive coverage of fibre splicing. Over 50% of the course is practical based. What will you learn Prepare cable for splicing. Splice fibre optic cable. Fibre splicing training course details Who will benefit: Those wishing to be able to splice fibre. Prerequisites: None. Duration 1 day Fibre splicing training course contents Fibre optic essential review Fibre cable types. SMF, MMF. Safe working practices. Cable handling issues. Hands on: Handling fibre optic cable. Preparing fibre for splicing Cutting and stripping tools, cleaving methods, fibre cleaning materials. Hands on: Fibre preparation. Splicing Joining fibres, splicers, fusion splicing, mechanical splicing, splicing procedure. cleaving, splicing parameters. Splicing vs. connectors. Which splice? Hands on: Splicing fibre. Splice loss mechanisms End gap, concentricity, end angle, NA mismatch, finish and dirt, coaxiality, Axial run out, core mismatch, back reflection. Testing Testing successful fibre splicing. Hands on: Testing spliced fibre.
ADVANCED 8 CPD POINTS 1 DAY INTENSIVE COURSE ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! Lipolysis (Fat Disolving) achieves good results in the following body zones: – Chin (double chin) – Hips (love handles) – Stomach (abdominal area) – Thighs (saddlebags) – Upper arms (arm toning) – Pseudo gynecomastia (male breasts) – Back (bra fat or muffin top) The acids present in Aqualyx cause fat destruction in the body. Aqualyx main active ingredient is deoxycholic acid. Deoxycholic acid is a bile acid, synthesized in the human liver. The fatty acids are then released into the body, to be broken down by our usual metabolic processes in the liver. Naturally occurring bile acid is used by the body to emulsify fat. Aqualyx comes in a water based injection that dissolves fat cells that it comes into contact with. A single vial will be sufficient. Small are for larger areas, such as the abdomen or the inner thigh, anywhere between 5 to 10 vials One treatment of AQUALYX® usually includes only 1 or 2 injection sites, as well as a local anaesthetic solution of lidocaine which is used to irradicate any pain and make the procedure as comfortable as possible. Course Content Disinfection, Health & Safety. Consultation and timings including data protection, medical history and client consent Skin Types Skin analysis Pre and post treatment procedures Injection protocol and techniques Safe handling needles, before, during and after treatment Product knowledge Setting up Treatment procedure Results clients can expects and managing expectations Contractions and aftercare advice Treatment planning and pricing Post care instruction Fat dissolving products (Lemon Bottle), very safe. Lemon Bottle is a high-concentration fat dissolve solution that combines Riboflavin (vitamin B2) and other premium ingredients that create fat decomposition by accelerating metabolism of fat cells. Become a certified Lemon Bottle fat-dissolving treatments expert with our comprehensive and accredited courses designed specifically for UK practitioners. We have the perfect course to suit your needs, focusing on the Lemon Bottle system. Minimal swelling, minimal pain. Begins working immediately. You need to be medically qualified as a doctor, dentist, nurse, pharmacist or paramedic with full governing body registration and have completed a Foundation Filler Course and to have administered a number of cases. Additional information ATTENDANCE ONLINE (Theory), IN CLINIC (Practice) COURSE LEVEL INTERMEDIATE | Advanced Course
Peering at LINX training course description A one or two day induction course covering the technical procedures of LINX along with correct interaction with LINX and LINX members. This course focuses on the implementation of the technologies within the LINX network. For those already competent in BGP the one day version of this course is sufficient. What will you learn Explain the role of LINX in the Internet. Correctly connect to LINX. Recognise the correct procedures for peering at LINX. Use the current Best Current Practices. Peering at LINX training course details Who will benefit: Technical staff of new LINX members. Technical staff of companies preparing to join LINX. Non technical staff may also benefit from this course. Prerequisites: None. (For technical staff with BGP knowledge 1 day) Duration 1 to 2 days Peering at LINX training course contents Introduction and review Networks, The Internet, IP, routers, Autonomous systems, the structure of the Internet, the role of Internet Exchanges. BGP and peering. LINX, EuroIX, RIPE. What you get when you join LINX. LINX products: Connexions, Virtual PoPs, Colocation resales, LINX from anywhere. LINX infrastructure The original architecture, The growth of LINX, the current topology. LINX London locations. Dual LAN topology. LON1, LON2. Use of MPLS to connect London sites. Regional peering: LINX NoVa, LINX Manchester, LINX Wales, LINX Scotland, ManxIX, JEDIX. Connecting with LINX nnecting with LINX Locations. 1/10/100/400G. Interface specifications. Link aggregation. The racks and space provided, access to the racks, connecting WAN circuits into LINX. The connection form, How to link your ISP with LINX, switch assignments, limits on traffic, average measured traffic, getting statistics from LINX, Using looking glass. Allowed traffic. Port security Configuration hints LINX IP details, IPv4, IPv6, PTR records, Cisco base configuration, Juniper base configuration. Peering with other LINX members Preparing for peering, the peering template, setting up the peering, RFC 2142, the RIPE database, contacts, peeringdb.net, solving downed BGP sessions, escalation procedures. Peering configuration hints Cisco BGP configuration, Juniper BGP configuration. LINX additional services Private interconnect, LINX time service. NTP, Strata. The LINX route server Bi lateral peering, Multi lateral peering. How the LINX route server is configured. Use of communities on the route server, template for peering with the route server. Summary Getting further information, the LINX website, the LINX mailing lists.
Learn all the skills you need to be a highly successful investor or professional analyst. In just 12 months.
The Level 5 qualifications in Management and Leadership are aimed at those who are working as middle managers and those who are aspiring to be senior managers. This qualification is mainly focused on the improvement of the student’s capabilities and core management skills such as resource management, recruitment, and information management. The Level 5 Diploma in Management and Leadership has been devised for developing the key skills of middle managers and those who are striving to be senior managers. This diploma is a benchmark qualification for full CMI membership which will take you one step closer to the status of a Chartered Manager. We have a 100% pass rate due to the high levels of support delivered through our online learning platform and individual coaches/assessors are assigned to all students. Our speed of response is second to none and our 5-star rating from our students speaks for itself. We are delighted to have supported students to unleash their potential from a diverse range of organisations both within the UK and internationally from organisations that have most recently included: Michelin Barclays Firstsource Mercedes Benz Shangrila Hotels and Resorts Virgin Money UK Person College London North Norfolk District Council G&L Scientific Coca Cola New Balance PureGym As a CMI accredited Chartered Manager Centre, many of our students go on to achieve recognition as Chartered Managers through our centre. Study method Online, self-paced Duration 9 months Access to content Access until course completion Qualification Level 5 Diploma - Extended Diploma in Business and Management CPD 540 CPD hours / points Additional info Exam(s) / assessment(s) is included in price Tutor is available to students CPD 540 CPD hours / points Accredited by Chartered Management Institute Key Benefits Latest and emerging as well as classical leadership and management concepts, theories and models. Practical guidance and support from our coaches and assessors who are all CMI Chartered Managers or Fellows. An internationally – recognised professional qualification. The credits earned at this course can be transferred to other courses if the students want to pursue MBA or any other Masters. On successful completion of the programme, students will be able to demonstrate their understanding and ability to apply leadership and management good practice which will improve their attractiveness to employers. The programme covers a choice of the following Units to a Total Qualification Time of 540 hours: CMI 502 Developing, Managing and Leading Individuals and Teams to Achieve Success (60 Hours TUT) CMI 504 Managing Performance (50 Hours TUT) CMI 506 Managing Equality, Diversity and Inclusion (50 Hours TUT) CMI 514 Managing Change (50 Hours TUT) CMI 513 Managing Projects to Achieve Results (60 Hours TUT) CMI 515 Creating and Delivering Operational Plans (60 Hours TUT) CMI 517 Principles of innovation (50 Hours TUT) CMI 520 Managing finance (60 Hours TUT) CMI 523 Principles of marketing products and services (60 Hours TUT) CMI 524 Conducting a Management Project (100 Hours TUT) CMI 525 Using Reflective Practice to Inform Personal and Professional Development (50 Hours TUT) We also provide students with access to the full CMI syllabus and support them if they wish to choose alternative Units. What the programme offers Level 5 Diploma in Leadership & Management from Chartered Management Institute (CMI) Student membership of the Chartered Management Institute Full learning support and all course materials All registration and assessment fees (We don't believe in hidden costs) Unrivalled one-to-one tutor support throughout the entire learning journey. A dedicated Chartered Manager as your programme coach/assessor 24-7 access to our extensive online Academy and CMI's Management Direct learning platform. All assessment and support materials are accessible through our online learning platform Assessment feedback within 48 hours to keep students motivated and on track The opportunity to progress to become recognised as a Chartered Manager upon successful completion Who is this course for? Middle Managers, potential middle managers and senior managers/business owners who want to consolidate their understanding of leadership and management good practice and gain formal recognition of their leadership and management abilities from the Chartered Management Institute – the only worldwide Chartered leadership and management professional body. Requirements None - we offer an inclusive and welcoming learning environment to all our students and there are no barriers to entry. Prospective students should be aware this CMI level 5 qualification is approximately equivalent to an academic degree level. Students will be required to submit assignments to this level. Career path A career in leadership and management. A possible progression route on successful completion of a Level 5 qualification in Strategic Management and Leadership would be to, Progress to other qualifications at the next level (e.g. from Level 5 Certificate to Level 6 or 7 Certificate)