660 Courses in Nottingham delivered Live Online

This class is designed for people who want to Learn Salsa\Zumba or any Latin Dance rhythm private class on Zoom platform for couples or individuals to achieve a good knowledge of the Salsa, Samba, Bachata, Merengue or Latin dance steps One to One lesson, 4 minimum pack lesson booking. Taught by native instructor You can have this lesson at our premises, on Zoom, Pre-recorded or home visit, the choice is yours!!! The Program includes: 10 or 20 Lesson 1on1 lesson Walking & Leading techniques Female & Male Teachers Footwork & Upper body techniques Steps & routines names (brain method) Body posture and language Tempo & beat music technique Fully equipped dance studio Ownership of your footage work progress & Docs Music library via Spotify & Apple Music Personal online library on Google Drive or Dropbox Salsa or Latin Dance rhythm private class in London for couples or individuals to achieve a good knowledge of the salsa, samba, bachata, merengue or Latin dance steps One to One lesson, 4 minimum pack lesson book Teach by native instructor We have been training people in salsa in london for almost 20 years and still in business as salsa in west london is increasing massively.

In this course you will understand what mentoring is about, understand your roles in the process. Gain self-insight into your own interpersonal style and way of relating to others that may affect mentoring interactions.

Hire us for the first dance at your wedding, any Salsa or Latin Dance rhythm private class at your venue or at our premises in Hammersmith. We have a vast experience on building up confidence in couples who want to make even more glamorous their wedding day. You can have this lesson at our premises, on Zoom, Pre-recorded or home visit, the choice is yours!!! The Program includes: 5 or 10 Lesson 1on1 lesson  Walking & Leading techniques Female & Male Teachers Footwork & Upper body techniques Steps & routines names (brain method) Body posture and language Tempo & beat music technique Fully equipped dance studio Ownership of your footage work progress & Docs Music library via dropbox or Spotify Salsa or any Latin Dance (Tango, Bachata, Merengue, etc) wedding class in London for couples who want to make the wedding day even more glamorous and stand out forever, 5 minimum pack lesson book, Taught by the native instructor We have been training couples for almost 12 years in salsa, Tango, Samba, and many other Latin rhythms in London

This course is designed to help adult learners develop the necessary language skills for academic success in an English-speaking environment. Through a combination of reading, writing, listening, and speaking exercises, participants will enhance their abilities to comprehend and produce academic texts, engage in critical thinking, and effectively communicate their ideas in written and spoken English.  Course Duration: 12 weeks (24 sessions) Course Objectives: By the end of this course, participants will: 1. Improve their academic vocabulary and understanding of complex grammatical structures. 2. Enhance their reading comprehension skills for academic texts. 3. Develop effective note-taking strategies for lectures and presentations. 4. Enhance their academic writing skills, including essay structure and research techniques. 5. Improve their ability to deliver academic presentations and participate in discussions. 6. Gain familiarity with academic conventions and citation styles. Course Outline: Week 1: Introduction to Academic English - Assessing participants' language proficiency and academic goals - Overview of the course syllabus and expectations - Introduction to academic vocabulary and common idiomatic expressions Week 2: Reading Comprehension - Scanning and skimming techniques for efficient reading - Strategies for understanding main ideas and supporting details - Vocabulary building through reading academic texts Week 3: Note-taking Skills - Effective note-taking during lectures and presentations - Organizing and summarising information - Practice exercises and listening activities Week 4: Academic Writing: Paragraph Structure - Understanding the components of a well-structured paragraph - Developing topic sentences and supporting ideas - Practice exercises on paragraph development Week 5: Academic Writing: Essay Structure - Introduction to essay structure: introduction, body, and conclusion - Crafting clear and concise thesis statements - Developing coherent and well-supported arguments Week 6: Research Skills and Citations - Introduction to academic research techniques - Evaluating sources for credibility and relevance - Understanding and applying citation styles (e.g., APA, MLA) Week 7: Grammar for Academic Writing - Review of essential grammar structures for academic writing - Practice exercises on sentence structure and complex grammar - Common grammatical errors to avoid in academic writing Week 8: Academic Writing: Research Papers - Understanding the research paper format and structure - Conducting literature reviews and integrating sources - Drafting and revising research papers Week 9: Academic Speaking: Presentations - Preparing and delivering effective academic presentations - Using visual aids and engaging the audience - Practicing presentation skills through individual and group activities Week 10: Academic Speaking: Discussions and Debates - Participating in academic discussions and debates - Expressing opinions and supporting arguments effectively - Listening and responding critically to others' viewpoints Week 11: Academic Writing: Critical Analysis - Analyzing and critiquing academic texts - Developing critical thinking and evaluation skills - Writing critical analysis essays Week 12: Review and Final Projects - Reviewing course content and addressing individual needs - Finalizing and presenting individual projects - Course evaluation and feedback session Note: This syllabus is a guideline and can be customised based on the specific needs and preferences of the participants. You can opt in and out of different modules. 

About this Training Course Oil & Gas professionals increasingly need to translate complex findings, analysis and recommendations for effective decision-making. If you face challenges in getting your findings into paper, you will benefit from this training course. The Technical Report Writing and Presentation Skills for Oil & Gas Engineers and Technical Professionals course focuses on the unique needs of technical professionals who write for both technical and non-technical readers. This separately bookable training course will demonstrate how technical professionals can use their technical knowledge and logical edge to write in a reader-friendly style, produce grammatically accurate reports and persuasively communicate for buy-in purposes. An ILM Recognised programme. Training Objectives LEARNING OUTCOMES FOR TECHNICAL REPORT WRITING SKILLS By the end of this course, participants will be able to: Write and turn-around accurate technical documents quickly to meet deadlines and productivity goals Understand how technical reports should be structured by applying a systematic approach to the writing task, involving planning, drafting, revision and production Use clear & powerful language to target and persuade readers for positive results Use tried and tested proof reading techniques to check and review documents more effectively Identify and avoid common pitfalls in technical report writing LEARNING OUTCOMES FOR TECHNICAL PRESENTATION SKILLS By the end of this course, participants will be able to: Present and sell your technical presentation more effectively both internally and externally Plan and structure your meetings and presentations for maximum effect Capture your technical and non-technical audience by delivering your presentation with power and authority Handle questions, interruptions and objections with confidence Target Audience This programme has been researched and developed for all Oil & Gas Engineers and Technical Professionals Course Level Basic or Foundation Trainer Your course leader managed the Business Skills Unit of the British Council programmes as well as oversee all training-related matters from 1997. The trainer considers himself a trainer first and specialises predominantly in high-level writing and technical report writing programmes. In addition to conducting training in Technical Writing, the trainer has also been the chief editor for many large writing projects. These include a year-long project editing the entire Start-Up Manual (including the Black Start Manual) for Nippon Oil's Helang Integrated Platform, a 4-month project rewriting the manuals for the Puteri Dulang FSO off Terengganu, and editing the current revision of the PETRONAS Procedures and Guidelines for Upstream Activities (PPGUA). POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Effecting Business Process Improvement: Virtual In-House Training Business analysts facilitate the solution of business problems. The solutions are put into practice as changes to the way people perform in their organizations and the tools they use. The business analyst is a change agent who must understand the basic principles of quality management. This course covers the key role that business analysts play in organizational change management. What you will Learn You will learn how to: Define and document a business process Work with various business modeling techniques Perform an enterprise analysis in preparation for determining requirements Analyze business processes to discern problems Foundation Concepts Overview of business analysis and process improvement Defining the business process Introducing the proactive business analyst Focusing on business process improvement for business analysts Launching a Successful Business Process Improvement Project Overview of the launch phase Understanding and creating organizational strategy Selecting the target process Aligning the business process improvement project's goals and objectives with organizational strategy Defining the Current Process Overview of current process phase Documenting the business process Business modeling options: work-flow models Business modeling options: Unified Modeling Language (UML) model adaptations for business processes Analyzing the Current Process Process analysis overview Evaluation: establishing the control group Opportunity techniques: multi-discipline problem-solving Opportunity techniques: matrices Building and Sustaining a Recommended Process Overview of the recommended process and beyond Impact analysis Recommended process Transition to the business case Return to proactive state

This course is designed to enable candidates to develop the knowledge of the terminology and basic concepts of TOGAF Standard, 10th Edition and principles of Enterprise Architecture. Candidates will also be able to analyze and apply knowledge of TOGAF Standard.

4G & 5G Roaming Scenarios & Procedures course description This course is designed to explain the roaming procedures of modern mobile networks, based on the GSMA roaming specification the course explains all scenarios where a mobile subscriber may find themselves whilst visiting a preferred mobile network partner. Interconnection between MNOs and the use of GRX & IPX as an interworking process. The course will work through the registration & authentication procedure, download of the user profile, the APN configuration & DIAMETER process to verify user authenticity. VoLTE roaming and IMS registration procedures for voice support & SMS delivery will be discussed and explained. What will you learn Architecture Models Technical requirements for interfaces - 4G Roaming Scenarios Technical requirements & recommendations for services Other Technical Requirements & Recommendations Technical Requirements for QoS support Technical Requirements & Recommendations for Interfaces - 5G Scenarios Technical Requirements & Recommendations for Interworking & Coexistence with E-UTRAN & EPC Technical Requirements & Recommendations for Services Other Technical Requirements & Recommendations 4G & 5G Roaming Scenarios & Procedures course details Who will benefit: Those working in mobile networks. Prerequisites: None. Duration 3 days 4G & 5G Roaming Scenarios & Procedures course contents Architecture Models 4G Evolved Packet System 5G Core Network SGs Interface for CSFB& SMS over SGs Technical Requirements for Interfaces - 4G Roaming Scenarios General requirements for inter-PLMN interfaces Stream Control Transmission Protocol (SCTP) IAMETER S8 Interface SGW selection PGW selection GTP Transport Layer engineering S9 interface Implementation requirements Guidelines for DIAMETER over S9 S6a & S6d interface Gy interface Guidelines for DIAMETER over Gy Legacy interworking scenarios VPLMN has not implemented LTE HPLMN has not implemented LTE Co-existence scenarios Possible scenarios 2G/3G roaming agreement only 2G/3G LTE roaming agreement LTE roaming registrations Consequences of different APN approaches when roaming Guidance regarding the APN approach when roaming Inter-RAT handover Handover & access restrictions to/from 2G/3G & LTE (Active mode) Access restriction for 2G/3G and/or LTE (Idle mode) Handover of PDN Connections between GERAN/UTRAN & LTE Handover to/from non-3GPP accesses & LTE Bandwidth considerations ARP considerations at handover from LTE to 2G/3G Tech requirements & recommendations for Services SMS SMS over SGs Voice CSFB Roaming retry for CSFB Roaming Forwarding for CSFB Coexistence of Roaming Forwarding & Roaming Retry Recommended procedures IMS Voice Roaming Architecture Other Technical Requirements & Recommendations Access Control Addressing APN for IMS based services IMS Well Known APN APN for Home Operator Services Gateway Selection Inter-PLMN roaming handover Data off related functionality Emergency Services Emergency PDN connectivity Emergency Call indicator Security GTP Security DIAMETER Security DIAMTER Roaming hubbing Default APN E-UTRA NR Dual Connectivity with EPC GW Selection for E-UTRA-NR Dual Connectivity TAC/LAC Restriction Guidelines Technical Requirements for QoS support QoS parameters definition QoS Management in the Home Routed architecture QoS control for IMS APN in the S8HR architecture Support of QoS in GRX/IPX QoS Control in Local Breakout architecture Technical Requirements & Recommendations for Interfaces - 5G Scenarios General requirements for inter-PLMN interfaces Transport protocol - TCP/IP Serialisation protocol - JSON Interface Definition language - OpenAPI Application Protocol - HTTP2 Inter-PLMN (N32) Interface N32c N32f ALS & IPX HTTP Proxy SMF & UPF in HPLMN & VPLMN Requirements related to Service Based Architecture Naming, addressing & routing for 5G SA roaming SEPP load distribution SEPP administration, naming convention & routing SEPP HTTP redirections Technical Requirements & Recommendations for Interworking & Coexistence with E-UTRAN & EPC Interworking scenarios Coexistence scenarios Inter-RAT Handover Handover & Access restriction between 5GC & EPC Technical Requirements & Recommendations for Services Network slicing Voice, Video & Messaging Location support UE Route Selection Policy Other Technical Requirements & Recommendations Access control IP Addressing DNN for IMS based services Emergency PDU Session Emergency Services Fallback Security Steering of Roaming in 5GS Technical Requirements for QoS support 5G QoS model 5G QoS profile QoS Control

Inspiring, interactive and unique 4-hour CPD certified training on Communication and Co-production with Parents/Carers

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - Introduction to Transact-SQL Work with schemas Explore the structure of SQL statements Examine the SELECT statement Work with data types Handle NULLs 2 - Sort and filter results in T-SQL Sort your results Limit the sorted results Page results Remove duplicates Filter data with predicates 3 - Combine multiple tables with JOINs in T-SQL Understand joins concepts and syntax Use inner joins Use outer joins Use cross joins Use self joins 4 - Write Subqueries in T-SQL Understand subqueries Use scalar or multi-valued subqueries Use self-contained or correlated subqueries 5 - Use built-in functions and GROUP BY in Transact-SQL Categorize built-in functions Use scalar functions Use ranking and rowset functions Use aggregate functions Summarize data with GROUP BY Filter groups with HAVING 6 - Modify data with T-SQL Insert data Generate automatic values Update data Delete data Merge data based on multiple tables Additional course details: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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.