487 Writing courses in Woking delivered Live Online

MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

Definitive Salt training course description Salt is a remote execution framework and configuration management system. This course covers Salt from the basics. After a quick first taste the course moves onto execution modules, salt states, minion and master data, jinja, Salt extensions and then topology and configuration options. Hands on sessions are used to reinforce the theory rather than teach specific manufacturer equipment. What will you learn Install and use Salt. Describe the architecture of Salt. Manage configurations with Salt. Extend Salt. Definitive Salt training course details Who will benefit: Anyone working with Salt. Prerequisites: Linux fundamentals. Duration 2 days Definitive Salt training course contents Introduction What is Salt? High- level architecture, Some quick examples, system management, configuration management, A brief history, Topology options, Extending Salt. Quick start: First taste of Salt Single-master setup, from packages, bootstrap scripts, Starting up, Basic commands, salt: the main workhorse, salt-key: key management, salt-call: execution on the minion, salt-run: co-ordination of jobs on the master, summary of commands, Key management, viewing keys, accepting keys, rejecting keys, key files, Minion targeting, minion ID, list (-L), glob, regular expressions (-E), grains (-G), compound (-C), targeting summary, Additional remote execution details, Conclusion. Execution modules: The functional foundation sys: information and documentation about modules, sys.doc basic documentation, sys.list_modules, sys.list_functions: simple listings, cmd: execute via shell, cmd.run: run any command, pkg: manage packages, virtual modules, pkg.lists_pkgs: list all installed packages, pkg.available version: see what version will be installed, pkg.install: install packages, user: manage users, user.add: add users, user.list_users, user info: get user info, saltutil: access various Salt utilities, Summary. Configuration management: Salt states Salt files overview, SLS example: adding a user, working with the multi-layered state system, Highstate and the top file, the top file, State ordering, require: depend on another state, watch: run based on other changes, odds and ends, Summary. Minion data / master data Grains are minion data, performing basic grain operations, setting grains, targeting with grains in the top file, Pillars are data from the master, querying pillar data, querying other sources with external pillars, Renderers give data options. Extending Salt: part I Introduction to Jinja, Jinja basics, Templating with Jinja, filtering by grains, Custom execution module, Custom state modules, Custom grains, External pillars, Summary. More on the matter Runners, manage minions, manage jobs, The orchestrate runner, The event system, The reactor system, Summary. Extending Salt: part II Python client API, reading configuration data on a master and minion, using the master client (localclient) API, Using the caller client API, Custom runners, writing a custom runner, using the runnerclient API, Summary. Topology and configuration options Master configuration, directories and files, logging, access control, files server options, Topology variations, masterless minions, peer systems, syndication masters, multiple masters. Brief introduction to salt-cloud Overview, Setup AWS and salt-cloud, installing salt-cloud, cloud providers, cloud profiles, cloud maps, Introspection via salt cloud, Creating infrastructure, More information. Using vagrant to run Salt examples YAML.

Complete Python training course description Python is an agile, robust, expressive, fully objectoriented, extensible, and scalable programming language. It combines the power of compiled languages with the simplicity and rapid development of scripting languages. This course covers Python from the very basics of 'hello world!' through to object oriented programming and advanced topics such as multi threading. Hands on follows all the major sections in order to reinforce the theory. What will you learn Read Python programs. Write Python programs. Debug Python programs. Use Python's objects and memory model as well as its OOP features. Complete Python programming training course details Who will benefit: Anyone wishing to learn Python. Prerequisites: None. Duration 5 days Complete Python programming training course contents Welcome to Python: What is Python? Origins, features. Downloading and installing Python, Python manuals, comparing Python, other implementations. Getting started: Program output, the print statement, "hello world!", Program input, raw_input(), comments, operators, variables and assignment, numbers, strings, lists and tuples, dictionaries, indentation, if statement, while Loop, for loop. range(), list comprehensions. Files, open() and file() built-in functions. Errors and exceptions. Functions, Classes, Modules, useful functions. Python basics: Statements and syntax, variable assignment, identifiers, basic style guidelines, memory management, First Python programs, Related modules/developer tools. Python Objects: Other built-in types, Internal Types, Standard type operators, Standard type built-in functions, Categorizing standard types, Unsupported types. Numbers: Integers, Double precision floating point numbers, Complex numbers, Operators, Built-in and factory functions, Other numeric types. Sequences: strings, lists, and tuples: Sequences, Strings, Strings and operators, String-only operators, Built-in functions, String built-in methods, Special features of strings, Unicode, Summary of string highlights, Lists, Operators, Built-in functions, List type built-in methods, Special features of lists, Tuples, Tuple operators and built-in functions, Tuples special features, Copying Python objects and shallow and deep copies. Mapping and set types: Mapping Type: dictionaries and operators, Mapping type built-in and factory functions, Mapping type built-in methods, Dictionary keys, Set types, Set type operators, Built-in functions, Set type built-in methods. Conditionals and loops: If, else and elif statements, Conditional expressions, while, for, break, continue and pass statements, else statement . . . take two, Iterators and iter(), List comprehensions, Generator expressions. Files and input/output: File objects, File built-in functions [open() and file()], File built-in methods and attributes, Standard files, Command-line arguments, File system, File execution, Persistent storage modules. Errors and exceptions: What are exceptions? Detecting and handling exceptions, Context management, Exceptions as strings, Raising exceptions, Assertions, Standard exceptions, Creating Exceptions, Why exceptions, Exceptions and the sys module. Functions: Calling, creating and passing functions, formal arguments, variable-length arguments, functional programming, Variable scope, recursion, generators. Modules: Modules and files, Namespaces, Importing modules, Module import features, Module built-in functions, Packages, Other features of modules. Object-Oriented Programming (OOP): Classes, Class attributes, Instances, Instance attributes, Binding and method invocation, Static methods and class methods, Composition, Sub-classing and derivation, Inheritance, Built-in functions for classes, and other objects, Customizing classes with special methods, Privacy, Delegation, Advanced features of new-style classes (Python 2.2+), Related modules and documentation. Execution environment: Callable and code Objects, Executable object statements and built-in functions, Executing other programs. 'Restricted' and 'Terminating' execution, operating system interface. Regular expressions: Special symbols and characters, REs and Python, Regular expressions example. Network programming: Sockets: communication endpoints, Network programming in Python, SocketServer module, Twisted framework introduction. Internet client programming: What are internet clients? Transferring files, Network news, E-mail. Multithreaded Programming: Threads and processes Python, threads, and the global interpreter lock, The thread and threading Modules. GUI programming: Tkinter and Python programming, Tkinter Examples, Brief tour of other GUIs. Web programming: Web surfing with Python: creating simple web clients, Advanced Web clients, CGI: helping web servers process client data, Building CGI applications, Using Unicode with CGI, Advanced CGI, Web (HTTP) Servers. Database programming: Python database application programmer's interface (DB-API), ORMs. Miscellaneous Extending Python by writing extensions, Web Services, programming MS Office with Win32 COM, Python and Java programming with Jython.

These groups are for emerging young writers and will ensure your child loves writing from the beginning! We will play games, laugh and have lots of fun exploring imaginative ideas and beginning to structure a story. For this class your child needs to be able to write at least one sentence on their own. 4 children maximum fully interactive weekly 55 minute lessons qualified, expert teacher optional homework set weekly additional resources set via online classroom lesson recordings for absent students written progress reports three times per year Classes are £90 per month

Welcome to GLA Tutors, your go-to platform for GCSE English tutoring. At GLA Tutors, we understand the significance of excelling in GCSE English and strive to provide comprehensive and customised support to help students achieve outstanding results. Our team of experienced tutors is well-versed in the AQA examination board's specification for GCSE English. We have meticulously analysed the AQA specification to ensure that our tutoring services align with the curriculum requirements and cover all the essential elements and skills. The AQA GCSE English specification consists of two main components: 1. English Language: - Paper 1: Explorations in Creative Reading and Writing - Paper 2: Writers' Viewpoints and Perspectives - Spoken Language Endorsement 2. English Literature: - Paper 1: Shakespeare and the 19th-century novel - Paper 2: Modern Texts and Poetry Our tutors at GLA Tutors possess a deep understanding of each component and are equipped with the knowledge and resources to provide comprehensive support in all areas. Whether it's analysing texts, honing writing skills, or developing effective communication skills, our tutors are dedicated to helping students excel in their GCSE English exams. We believe in a personalised approach to tutoring. We understand that every student has unique learning needs and preferences. Our tutors tailor their teaching methods to accommodate individual learning styles, ensuring that each student receives the support and guidance they need to succeed. Our tutoring sessions are interactive and engaging. We foster a supportive learning environment where students are encouraged to ask questions, participate in discussions, and develop critical thinking skills. Our tutors employ a range of teaching techniques, including close textual analysis, essay writing practice, and creative writing exercises, to help students master the key skills required for GCSE English. With GLA Tutors, you can be confident that you will receive top-quality tutoring in GCSE English. Our tutors are committed to helping you unlock your full potential, providing guidance, and instilling confidence in your ability to excel in your exams. Join us and let us help you achieve outstanding success in GCSE English. We can provide assistance for everything you need to prepare students for exams, including: past papers, mark schemes and examiners’ reports specimen papers and mark schemes for new courses exemplar student answers with examiner commentaries guidance in planning and writing cohesively high quality revision guides

Duration 2 Days 12 CPD hours This course is intended for Anyone desiring to improve their ability to speak self-assuredly, in front of both internal and external groups will benefit from this course. Overview Understand what separates an effective presentation from an ineffective presentation. Design a proficient presentation geared toward their audience. Create powerful slides that enhance the address. Enhance their public speaking skills with tips and techniques used by professional speakers. Prepare mentally for their best performance. Engage their audience more effectively and with greater passion. Whether speaking publicly or to a specific audience, your ability to build, develop and deliver a purposeful presentation is key to being able to convey your message and achieve your desired results. From open to close, it is crucial to learn the tools necessary to maintain engagement and to organize ideas to create coherent and convincing oral presentations. In this course, you will learn strategies to structure and develop presentation content focused on audience need and key points, identifying the areas in which you are most polished, as well as picking up hints and tips to address any gaps. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. Foundation, Structure, and Organization Why a presentation The difference between effective and ineffective presentations Delivering passion and value Structure determines success 2. Creating the Basic Structure Building the backbone Capturing audience attention Understanding your audience 3. Organizing Your Program Planning analog Creating the topic outline Fact-Finding 4. Designing and Building Your Presentation Choosing proper content Building and writing Your presentation Slide design 5. Delivering Your Presentation Preparing mentally Appearing confident in front of the crowd 6. Engaging Your Audience from Start to Finish Understanding and matching learning styles Closing Your presentation and providing calls to action Additional course details: Nexus Humans The Art of Effective Presentations (Second Edition) 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 The Art of Effective Presentations (Second Edition) 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.

Achieving certification for Compliance Management Systems (ISO 37301:2021) through an external audit process to help you identify, prevent and address compliance risks within your organisation provides a range of benefits. What if you could gain the expertise to conduct internal audits in-house, to not only successfully complete ISO certification, but allow you to continue to monitor your adherence to that certification standard? 'Prove your competency to the wider compliance industry.' Created by UKAS accredited ISO certification experts, this wholly unique, internationally focussed, 2-day online internal auditor training course is a fantastic way to develop your in-house expertise and allow your team to attain the competence they need to maintain and continually improve your management system. A cost-effective route, negating the need to hire external consultants Avoid closing a business for what might be a lengthy audit Prove your ' culture of compliance', and in turn, strengthen your 2nd and 3rd lines of defence Add additional skills to your CV, demonstrating your commitment to best practice while gaining a competitive advantage for your organisation. 'Don't just tick the boxes, demonstrate a culture of compliance.' Ensure you are fully compliant with relevant legislation and regulation and give confidence to the regulators, your partners, and clients that you have processes in place to comply with the law. Developing knowledge of compliance management system standards/normative documents Developing knowledge of ICA Audit (certification body's) processes Developing knowledge of relevant business sectors Developing knowledge of business management practices and how they integrate into business activities Developing knowledge of audit principles, practices, and techniques Developing knowledge of client products, processes, and organization Developing language skills appropriate to all levels within the client organization Developing notetaking and report-writing skills Developing presentation skills Developing interviewing skills

Ditch the Scripts - Master the craft of language Patterns, Scripts, and Metaphors. Make your SFH session more relatable to the client. Creative Hypnotherapy – Creating Language Patterns, Scripts and Metaphors Join us for an exciting online event as we delve into the world of creative hypnotherapy. This workshop is designed to help you enhance your language patterns, scripts, and metaphors, allowing you to become a more effective hypnotherapist. During this engaging session, you will learn various techniques and strategies to create powerful and impactful language patterns that can be used in hypnotherapy sessions. In this workshop, we will look at the art of introducing creative hypnotherapy into a normal SF hypnotherapy session. We will look at the art of crafting language patterns, using metaphorical techniques in language patterns and scripts, and the Art of writing personal metaphors to ensure they resonate with the client's subconscious. We will look at the work of the master himself in indirect and conversational suggestion and hypnosis Erikson and the techniques he used and explore his inspiration within the work of NLP Learning Outcomes from this CPD Definition of Hypnosis The Mind and Hypnosis Direct and Indirect language used in Hypnosis Erikson and Conversational Hypnosis NLP – Submodalities & Predicates Eriksonian Language Patterns used in NLP NLP Milton Language Pattern and Script Formulae The Building Blocks for Hypnosis Scripts and Language Patterns Constructing a Hypnotherapy Script Writing Techniques Understanding the Role of Metaphors in Hypnosis This workshop will equip you to cater each session to your client in a personal way, it will build rapport with your clients and take away any resistance in pre-written scripts or language patterns allowing a deeper resonation with the client's subconscious in hypnosis. It will also make you comfortable with using direct suggestions in your sessions in a solution-focused manner. You will also receive a copy of a reference handbook that covers techniques, and formulae used in writing and customising language patterns and scripts, examples of scripts and metaphors, and a detailed breakdown of what each part of the script is doing. This workshop is a MUST for any qualified solution-focused hypnotherapist who wants to add a sprinkling of energy and creativity to their sessions. A certificate of attendance will also be given to all attendees for 4 hours of CPD attendance. Don't miss out on this exciting online workshop – reserve your spot today!

Lower Intermediate Communication Training in all 4 Integrated Skills: Listening, Speaking, Reading and Writing. Learn the REAL language, not "textbook English".

These sessions are created for students eager to explore more complex texts and refine their analytical skills. Students will enhance their ability to critically evaluate literature, comparing themes and characters across a wide range of texts. They'll advance their creative and non-fiction writing, taking it to the next level by focusing on sophisticated language use and technical accuracy. through engaging discussions around fascinating topics, such as moral issues and social contexts, students will develop their oral communication. The overall aim of thios course is to deepen their love of language in an enjoyable environment. 6 children maximum fully interactive weekly 55 minute lessons qualified, expert teacher optional homework set weekly additional resources set via online classroom lesson recordings for absent students written progress reports three times per year Classes are £90 per month. Variety of times and dates available. Enquire to find out more!