991 Courses

If you got a call from a TV producer asking you to appear on Newsnight, would you say ‘yes’? And if you did, could you make your argument in a way that captured the attention of the audience without being interrupted? Our media training courses are aimed at senior spokespeople and experts who give interviews on TV, radio or in print. We equip them with the skills and confidence to take control and give engaging, memorable and effective performances in which they deliver their key messages, no matter what the circumstances. Highly interactive and practical, each course includes a series of realistic print, radio and television exercises with experienced journalists. We provide immediate feedback following each interview, including techniques for improvement, advice about potential answers and the framing of key messages. While all our media training courses are bespoke, on a typical course we will cover: how the media operates how to prepare for interviews the differences between TV, radio and print interviews how to conduct different types of interview, such as pro-active, reactive, expert commentator and hostile (crisis communications) developing key messages which convey your views persuasively how to take control of an interview, stick to your own agenda and deliver key messages successfully use of language, body language, dress and delivery After the course, each delegate receives the Rough House Media Toolkit, including written feedback, recorded copies of their interview exercises, the Rough House Media Guide to Interviews and further supporting materials. We also provide a confidential assessment to the PR team of each delegate’s suitability for different types of interview. Venue We deliver courses in the most appropriate format for your circumstances – whether face to face or online. Face to face courses are portable: they can be held in purpose-built studios, at your own offices or at an external venue. In the latter two cases, we create a mock studio for the practical exercises. Online courses give you flexibility and enable you to offer training to delegates from all over the world. We have run virtual courses for people from the Far East, South Asia, North America and Europe, as well as the UK.

Exciting news! My popular 'Getting Started in Data Governance' course is making it's way across the pond! Due to numerous requests, I'm thrilled to announce that I will be hosting a U.S. edition of the course.

Private sketching tours and classes with ink and watercolour artist Mark Kirkham, known locally as The Edinburgh Sketcher hosted by The Arienas Collective, or at an agreed location of your choice.

In this comprehensive course, we will guide you through the world of Oracle Database Administration, starting from the basics and equipping you with the skills to create databases, manage storage, implement backup plans, apply patches, troubleshoot issues, and excel in the role of a professional DBA.

Aligned with the AIGP certification program, AI Governance Professional Training is for professionals tasked with implementing AI governance and risk management in their organizations. It provides baseline knowledge and strategies for responding to complex risks associated with the evolving AI landscape. This training meets the rapidly growing need for professionals who can develop, integrate and deploy trustworthy AI systems in line with emerging laws and policies. About This Course This training teaches critical artificial intelligence governance concepts that are also integral to the AIGP certification exam. While not purely a 'test prep' course, this training is appropriate for professionals who plan to certify, as well as for those who want to deepen their AI governance knowledge. Both the training and the exam are based on the same body of knowledge.   Module 1: Foundations of artificial intelligence Defines AI and machine learning, presents an overview of the different types of AI systems and their use cases, and positions AI models in the broader socio-cultural context. Module 2: AI impacts on people and responsible AI principles Outlines the core risks and harms posed by AI systems, the characteristics of trustworthy AI systems, and the principles essential to responsible and ethical AI. Module 3: AI development life cycle Describes the AI development life cycle and the broad context in which AI risks are managed. Module 4: Implementing responsible AI governance and risk management Explains how major AI stakeholders collaborate in a layered approach to manage AI risks while acknowledging AI systems' potential societal benefits. Module 5: Implementing AI projects and systems Outlines mapping, planning and scoping AI projects, testing and validating AI systems during development, and managing and monitoring AI systems after deployment. Module 6: Current laws that apply to AI systems Surveys the existing laws that govern the use of AI, outlines key GDPR intersections, and provides awareness of liability reform. Module 7: Existing and emerging AI laws and standards Describes global AI-specific laws and the major frameworks and standards that exemplify how AI systems can be responsibly governed. Module 8: Ongoing AI issues and concerns Presents current discussions and ideas about AI governance, including awareness of legal issues, user concerns, and AI auditing and accountability issues. Accreditation The associated exam is accredited by the IAPP under its ANSI Accreditation Who Should Attend? Any professionals tasked with developing AI governance and risk management in their operations, and anyone pursuing IAPP Artificial Intelligence Governance Professional certification. Prerequisites A general understanding of AI, Corporate Governance, and Business value would be of benefit to participants. Assessment As with all IAPP exams, the AIGP is a 90 question, multiple choice exam to be completed within 150 minutes. Exams are hosted by Pearsonvue and can be taken either remotely, or via any one of hundreds of exam venues globally. A passing score is achieved at 70% Our Guarantee We are an approved IAPP training provider Exam pass guarantee, or retrain until you do, for free What's Included? Participant Guide Study Guide Practice Exam Exam voucher Breakfast, lunch, coffees and snacks (Classroom courses only) Certification Logo

Macrame class with local artist Lucy Wayman hosted by The Arienas Collective creative workshop space in Edinburgh City Centre.

Join FlashAcademy and GEMS FirstPoint School Dubai, as we explore how we can empower multilingual learners.

The Greek Language Summer Camp is a great way for your child to greatly improve their Greek and have fun with other international children. Our program is for children aged 6-15 years and aims to develop children’s speaking skills and boost their confidence when speaking Greek. Young learners are usually faster to learn and grasp foreign languages, especially some aspects of languages like the pronunciation and new vocabulary. This is precisely why close contact with a Greek speaking environment and native Greek speakers is the perfect opportunity for children to engage in the Greek language fast and absorb new skills very quickly.

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.

Regular expressions training course description Regular expressions are an extremely powerful tool for manipulating text and data. They are now standard features in a wide range of languages and popular tools, including Python and MySQL. Regular expressions allow you to code complex and subtle text processing that you never imagined could be automated. Once you've mastered regular expressions, they'll become an invaluable part of your toolkit. You will wonder how you ever got by without them. What will you learn Use Regular Expressions. Troubleshoot Regular Expressions. Compare RE features among different versions. Explain how the regular expression engine works. Optimize REs. Match what you want, not what you don't want. Regular expressions training course details Who will benefit: Anyone looking to use regular expressions. Prerequisites: None. Duration 1 day Regular expressions training course contents Introduction to Regular Expressions Solving real problems, REs as a language, the filename analogy, language analogy, RE frame of mind, searching text files: egrep, egrep metacharacters, start and end of the line, character classes, matching any character with dot, alternation, ignoring differences in capitalization, word boundaries, optional items, other quantifiers: repetition, parentheses and backreferences, the great escape, expanding the foundation, linguistic diversification, the goal of a RE, more examples, RE nomenclature, Improving on the status quo. Extended introductory examples A short introduction to Perl, matching text with regular expressions, toward a more real-world example, side effects of a successful match, Intertwined regular expression, intermission, modifying text with regular expressions, example: form letter, example: prettifying a stock price, automated editing, a small mail utility, adding commas to a number with lookaround, text-to-HTML conversion, that doubled-word thing. Regular expression features and flavours The regex landscape, origins of REs, care and handling of REs, Integrated handling, procedural and object-oriented handling, search-and-replace example. strings character encodings and modes, strings as REs, character-encoding issues, unicode, regex modes and match modes, common metacharacters and features, character representations, character classes and class-like constructs, anchors and other 'zero-width assertions', comments and mode modifiers, grouping capturing conditionals and control. The mechanics of expression processing Two kinds of engines, new standards, regex engine types, from the department of redundancy department, testing the engine type, match basics, about the examples, rule 1: the match that begins earliest wins, engine pieces and parts, rule 2: the standard quantifiers are greedy, regex-directed versus text-directed, NFA engine: regex-directed, DFA engine: text-directed, first thoughts: NFA and DFA in comparison, backtracking, two important points on backtracking, saved states, backtracking and greediness, more about greediness and backtracking, problems of greediness, multi-character 'quotes', lazy quantifiers, greediness and laziness, laziness and backtracking, possessive quantifiers and atomic grouping, possessive quantifiers ?, +, *+, ++ and {m,n}+, the backtracking of lookaround, is alternation greedy? taking advantage of ordered alternation, NFA DFA and posix, the longest-leftmost', posix and the longest-leftmost rule, speed and efficiency. Practical regex techniques Continuation lines, matching an IP address, working with filenames, matching balanced sets of parentheses, watching out for unwanted matches, matching delimited text, knowing your data and making assumptions, stripping leading and trailing whitespace, matching and HTML tag, matching an HTML link, examining an HTTP URL, validating a hostname, plucking a hostname, plucking a URL, parsing CSV files. Crafting an efficient expression Efficiency vs. correctness, localizing greediness, global view of backtracking, more work for POSIX NFA, work required during a non-match, being more specific, alternation can be expensive, benchmarking, know what you re measuring, benchmarking with Python, common optimisations, the mechanics of regex application, pre-application optimizations, optimizations with the transmission, optimization of the regex itself, techniques for faster expressions, common sense techniques, expose literal text, expose anchors, lazy versus greedy: be specific, split into multiple REs, mimic initial-character discrimination, use atomic grouping and possessive quantifiers, lead the engine to a match, unrolling the loop, observations, using atomic grouping and possessive quantifiers, short unrolling examples, unrolling C comments, the free flowing regex, a helping hand to guide the match, a well-guided regex is a fast regex.