148 Courses in London

Essential 5G training course description This course is designed to give delegates an explanation of the technologies and interworking requirements of the next generation of cellular communications. It is not a definitive set of descriptions but a possibility of the final deployment. we will investigate the 10 pillars for 5G which will include various Radio Access Technologies that are required to interwork smoothly. We will look at the 4G Pro features and other RATs. What will you learn List the ten pillars of 5G deployment. Describe the 5G Internet. Explain virtualization and RAT virtulization. Describe Software Defined Networks (SDN). Explain carrier aggregation. Describe the mobile cloud. Explain an overall picture of 5G architecture. Essential 5G training course details Who will benefit: Anyone looking for an understanding of the technologies and interworking requirements of the next generation of cellular communications. Prerequisites: None. Duration 3 days Essential 5G training course contents Drivers for 5G 5G Road Map, 10 Pillars of 5G, evolving RATs, oSON, MTCm, mm-wave, backhaul, EE, new spectrum, spectrum sharing, RAN virtualisation. 4G LTE Advanced MIMO technology in release 8, Downlink & uplink MIMO R8, MIMO technology in LTE advanced, Downlink 8-layer SU-MIMO, Downlink MU-MIMO, Uplink MU-MIMO, Uplink transmit diversity, Coordinated multi-point operation (CoMP), Independent eNB & remote base station configurations, Downlink CoMP. ICIC & eICIC ICIC, Homogeneous to heterogeneous network evolution, Introduction to eICIC, Macro-pico scenario, Macro-femto scenario, Time orthogonal frequencies. Almost Blank Subframe (ABS). Carrier aggregation Component carriers (CC), CC aggregation deployments, Intra-band contiguous solutions, Intra-band non-contiguous solutions, Inter-band non-contiguous solutions, CA bandwidth classes, Aggregated transmission bandwidth configurations (ATBC), Possible carrier aggregation configs. eIMTA TDD UL-DL reconfig. for traffic adaptation, Reconfig. mechanisms, Interference mitigation schemes, Dynamic & flexible resource allocation. 5G architectures 5G in Europe, horizon 2020 framework, 5G infrastructure PPP, METIS project, 5G in North America, academy research, company R&D, 5G specifications. The 5G internet High-level view of Cloud Services, The Internet of Things & context awareness, Network reconfiguration & virtualization support, server proliferation, how VMs fix underutilised server problem, enter the hypervisor, why are VM such a big deal? SDN, evolution of the data centre network, high availability, low latency, scalability, security, cost model explodes, service-oriented API. OpenFlow switches, OpenFlow controllers, how SDN works. The big picture, pulling it all together, why the network had to change, how SDN & NFV tie together. Evolutionary approach to the internet, architectures for distributed mobility management, MEDIEVAL & MEDIVO projects, a clean slate approach, mobility first architecture. VNet, INM, NetInf, ForMux, MEEM. Generic Path (GP) & anchorless mobility (AM), Quality of Service support, network resource provisioning, resourcing inside a network. IntServ, RSVP, DiffServ, CoS. Emerging approach for resource over- provisioning, example use case architecture for scalable resource control scenarios in the 5G internet. Integrating SDN/NFV for efficient resource over-reservation control, control information repository, service admission control policies, network resource provisioning, control enforcement functions, network configurations & operations. Small cells for 5G Average spectral efficiency evolution, WiFi & Femto cells, Capacity limits. Achievable gains with densifications, multi-antenna techniques, small cells. Mobile data demand, approach & methodology, subscriber density and traffic demand projections to 2020. Demand versus capacity, global mobile data traffic increase modelling, country level backhaul traffic projections, Small cell challenges, backhaul, spectrum, automation. Cooperation for next gen wireless networks Diversity & relaying strategies, cooperation & network coding, ARQ & MAC protocols, NCCARQ & PRCSMA packet exchange, Physical layer impact on MAC protocol analysis, NCCARQ overview, PHY layer impact, Case study on NCCARQ. Mobile clouds Mobile cloud, Mobile cloud enablers, mobile user domain, wireless technologies, WWAN WLAN and WPAN range, Bluetooth, IEEE.802.15.4 & software stacks, infrared, near field communications (NFC). Network coding, store & forward vs compute & forward, linear network coding, random linear coding. Security for 5G communications Potential 5G communication systems architectures, Security issues & challenges. Mobile malware attacks targeting the UE, 5G mobile botnets, access networks, attacks on 4G networks, C-RNTI & packet sequence number based UE location tracking, false buffer status reports attacks, message insertion attacks, HeNB attacks, physical attacks, credential attacks, configuration and protocol attacks, attacks on MON, user data & identity attacks, mobile operator's core network, DDoS attacks targeting MON, signalling amplification, HSS saturation, external IP networks.

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

I am able to travel to you to help you develop your partnership with your horse. I specialise in developing confidence in both horse and rider both on the flat and over fences. As a list 5 BD Dressage judge I can help you with test riding for BD Intro, Prelim and Novice tests. I can help with BE 90, 100 & Novice tests. As I am training for list 4 I can also help you with Elementary BD and Intermediate BE The times listed are a general guide of my availability. If you would prefer a time that is not listed please select the time that is closest to you preference, the message me via Email, WhatsApp or Facebook to see if we can arrange a better time for you. Instructions Make sure we have access to an arena, with a poop scoop and poles if you want them.

Public Speaking Courses That Work Our public speaking courses are refreshingly different and transformative. Mindful presenting is the key to the future of high impact public speaking training. In fact, we are changing organisations one presentation at a time. We do that by providing training that empowers and equips professionals to present with greater confidence, clarity and impact.

Public Speaking Courses That Work Our public speaking courses are refreshingly different and transformative. Mindful presenting is the key to the future of high impact public speaking training. In fact, we are changing organisations one presentation at a time. We do that by providing training that empowers and equips professionals to present with greater confidence, clarity and impact.

Public Speaking Courses That Work Our public speaking courses are refreshingly different and transformative. Mindful presenting is the key to the future of high impact public speaking training. In fact, we are changing organisations one presentation at a time. We do that by providing training that empowers and equips professionals to present with greater confidence, clarity and impact.

Say goodbye to shop-bought pasta with this Two Hour BYOB Pasta Making Workshop with The Avenue Cookery School. Kick things off with a helpful demonstration from the chef as you learn how to make the perfect ravioli with the most delicious filling from scratch. Prepare to get hands-on putting your new-found knowledge to the test, before sitting down with the alcoholic tipple you brought along to the class and enjoying the fruits of your labour. You’ll receive useful pasta tips and tricks throughout the class, which you can apply in the future when recreating this delicious dish at home. (You can add bottomless wine at £20pp) What's Included Two Hour BYOB Pasta Making Workshop with The Avenue Cookery School Fun, informative and social class Learn how make the perfect ravioli with the most delicious filling from scratch Receive expert tips and tricks throughout All equipment, aprons and ingredients included BYOB (Bring Your Own Booze) with no corkage fee Recipe booklet emailed to you after the class Experience gift pack including personalised voucher and message card

This one-day introduction workshop is intended for users who need to get to grips with the essentials of Microsoft Outlook. It will provide you with the basic skills you need to effectively start using Outlook to manage your emails, calendar, contacts, tasks and notes. This course will help participants: Send messages with added email options applied Quickly file messages away for safe keeping Manage messages and attachments Organise calendar meetings and check other people's schedules Respond to a meeting request Create a contacts list Manage daily tasks Use reading and folder panes Create and manage folders Use auto reply Use notes Utilise Outlook's printing functionality 1 Getting started Using the reading pane Using the folder pane Changing inbox views Managing the to-do bar 2 Emailing messages Replying to and forwarding messages Adding message options Attaching files to an email message Opening and saving attachments 3 Outlook folders Creating and managing folders Moving messages into folders Adding folders to favourites Using search folder Always moving messages in conversation Automatically move messages with rules 4 Managing messages Using instant search Finding messages by criteria Grouping and sorting messages Categorising messages Adding message follow up flags Filtering messages with the people pane 5 Using auto reply Replying to messages whilst you are away Managing auto reply settings Applying rules to auto reply 6 Outlook calendars Adding and editing appointments Adding calendar reminders Moving and copying appointments Creating all day events Recurring appointments Sharing your calendar Opening another user's calendar 7 Planning a meeting Arranging meetings Inviting attendees to meetings Responding to meeting invites 8 Outlook contacts Creating and editing a contact Saving emails as contacts Finding contacts Sending messages to contacts Creating contact groups 9 Adding tasks Creating and editing tasks Completing tasks Assigning a task to another user Responding to a task request 10 Notes Creating and editing tasks Emailing notes Sticking notes on your desktop 11 Printing Printing messages Printing calendars Printing contacts

Get ready to learn how to make your own tote bag. A fun and easy project for beginners. Book your spot today Learn to make a tote bag - a reusable & eco-friendly bag Join us for a fun and interactive in-person event where you can learn to make your own stylish tote bag! Whether you're a beginner or have some sewing experience, this event is perfect for anyone looking to unleash their creativity and learn a new skill. During this event, our experienced instructors will guide you step-by-step through the process of creating a beautiful tote bag. You'll learn essential sewing techniques, such as measuring, cutting, stitching, and finishing. Relax and enjoy the process of creating something beautiful with your own hands You will also get: - Fabric to make your bag and all other necessary materials and equipment - Expert guidance and tips from your workshop host - Email support for the next 3 months What you need to bring: - Your own sewing machine with its power cable Please make sure the machine works and has been recently serviced. Please bring along the manual and all the accessories that came with it including spare bobbins and the bobbin case if applicable. Don't worry if you don't have a sewing machine, as we have machines you can borrow. - Threads and a sewing kit (you can buy one from us if you want) - Notepad and pen The workshop is limited to 6 people per session. If you want a private group session, please message us with your booking. Note: You need to know how to thread and use your machine. We offer an introduction to sewing machine workshop too, if you wanted to get to grips with your machine. You will receive a confirmation email after booking from our website. Please provide your phone number so we can message you in case of emergencies. Whether you want to make a personalized gift for a loved one or simply want to expand your crafting skills, this event is a fantastic opportunity to have fun and meet like-minded individuals. So, grab your friends and join us for a creative and enjoyable day of sewing! Spaces are limited, so reserve your spot now and get ready to embark on a sewing adventure! Note: If less than 3 participants have booked on this workshop, we will reschedule the workshop for a more convenient date or a different location. Priority will be given to existing paid participants first who have the option to confirm or cancel within 7 days. Frequently asked questions What is the age range for the workshop? This workshop is suitable for adults and kids. What should I bring with me to the workshop? Bring your own sewing machine with it’s power cable if you are not borrowing from us. The manual and all the accessories the machine came with Bobbin, bobbin case if applicable Threads and a full sewing kit. You can purchase one from us Notepad and pen How many participants will attend this workshop? There will be a maximum of 6 participants at this workshop. Small groups work best as everyone gets a chance to learn and ask questions. Please note: The workshop would be rescheduled if there are less than 3 participants booked for the date. Is the venue wheelchair accessible? Unfortunately, this venue isn't wheelchair accessible. There are 2 short sets of stairs to get to the room. Please don't hesitate to reach out if you want further info or any specific needs or concerns. I will do my best to accommodate you. What is the cancellation and refund policy for the workshop series? Cancellation notice period: Refunds: 28 days or more before the course start date - Full refund minus the fees15-27 days before the course start date - 50% refund minus the fees 14 days or less before the course start date We will try & fill the space. If we fill it, full refund minus fees.

Creative workshop to surprise your mother on Mother's Day gifting her a one-of-a-kind handmade pressed flower card