193 Writing courses in London

Overview The International English Language Testing System (IELTS) measures the language proficiency of people who want to study or work where English is used as a language of communication. We offer both group and private IELTS preparation courses. Online Trainer led IELTS Coaching. Our method Throughout the course students work on all four modules; listening, reading, writing, and speaking. We also help our students with the grammar and vocabulary knowledge they need to achieve their band score. We believe that the best way to learn exam English is to relate it to real life. Our trainer will show you how your IELTS skills can be used in every day situations and will help to achieve higher bands and fulfil the requirement of the universities and colleges.

Definitive Puppet training course description Puppet is a framework and toolset for configuration management. This course covers Puppet to enable delegates to manage configurations. Hands on sessions follow all the major sections. What will you learn Deploy Puppet. Manage configurations with Puppet. Build hosts with Puppet. Produce reports with Puppet. Definitive Puppet training course details Who will benefit: Anyone working with Puppet. Prerequisites: Linux fundamentals. Duration 2 days Definitive Puppet training course contents Getting started with Puppet What is Puppet, Selecting the right version of Puppet, Installing Puppet, Configuring Puppet. Developing and deploying Puppet The puppet apply command and modes of operation, Foreground Puppet master, Developing Puppet with Vagrant, Environments, Making changes to the development environment, Testing the new environments with the Puppet agent, Environment branching and merging, Dynamic Puppet environments with Git branches, Summary, Resources. Scaling Puppet Identifying the challenges, Running the Puppet master with Apache and Passenger, Testing the Puppet master in Apache, Load balancing multiple Puppet masters, Scaling further, Load balancing alternatives. Measuring performance, Splay time, Summary, Going further, Resources. Externalizing Puppet configuration External node classification, Storing node configuration in LDAP, Summary, Resources. Exporting and storing configuration Virtual resources, Getting started with exported and stored configurations, Using exported resources, Expiring state resources, Summary, Resources. Puppet consoles The foreman, Puppet enterprise console, Puppetboard, Summary, Resources. Tools and integration Puppet forge and the module tool, Searching and installing a module from the forge, Generating a module, Managing module dependencies, Testing the modules, Developing Puppet modules with Geppetto, Summary, Resources. Reporting with Puppet Getting started, Configuring reporting, Report processors, Custom reporting, Other Puppet reporters, Summary, Resources. Extending Facter and Puppet Writing and distributing custom facts, Developing custom types, providers and functions, Summary, Resources, Complex data structures, Additional backends, Hiera functions in depth, Module data bindings, Hiera examples. Jiera-2, Summary, Resources. Mcollective Installing and configuring Mcollective, testing, Mcollective plugins, accessing hosts with Metadata. Hiera Lists, initial Hiera configuration, Hiera command line utility, complex data structures, additional backends, Hiera functions in depth, module data bindings. Hiera-2.

Oracle SQL training course description The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create SQL statements to query database tables. Use standard aggregate functions and related SELECT statement clauses. Join Tables. Use basic subqueries and the set operators. Use numeric, character and date functions. Use conversion and other miscellaneous functions. Use SQL parameters. Use complex subqueries. Create and alter tables and views. Insert, update and delete rows in database tables. Manage sequences and synonyms. Oracle SQL training course details Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. Prerequisites: None. Duration 3 days Oracle SQL training course contents Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.

Certified ScrumMaster® This course is an introduction to Scrum and the principles and tools required to be an effective Scrum Product Owner. You will come away with a good understanding of the Scrum framework and the underlying principles required to make effective decisions regarding the application of the Scrum framework to different situations. Participants successfully completing this course earn a Certified Scrum Product Owner® (CSPO®) designation. The Scrum Alliance certification includes a one-year membership with Scrum Alliance. What You Will Learn You'll learn how to: Use the principles, practices, and tools required to be an effective Scrum Product Owner Make effective decisions regarding the application of the Scrum framework to different situations, including: Setting product vision and goals Chartering the project Writing user stories and structuring your product backlog Scaling the Product Owner Estimating for forward planning Applying prioritization techniques Planning and tracking release progress Getting Started Introduction Course structure Course goals and objectives Agile Principles and Scrum Overview Process control models Incremental and iterative development Shifting the focus on product management Overview of the Scrum process Agile principles Lean principles Scrum Roles and Responsibilities Scrum roles Cross-functional teams Product Owner Responsibilities The Scrum Project Community What happens to my traditional role in Scrum? Chartering the Project Establishing a shared vision Elevator Statement Data sheets Product Vision Box Magazine Review / Press Release Product Backlog and User Stories Product uncertainty and progressive refinement User role modeling User Stories Product backlog characteristics Getting backlog items ready Slicing User Stories Using the product backlog to manage expectations Sprints Done and Scaling Done The Scrum process in detail Sustainable pace The Product Owner's role in each of the Scrum meetings Scaling the Product Owner Scaling Scrum Approaches to scaling the Product Owner Estimation for Forward Planning Why comparative estimation works Planning Poker Affinity Estimation Prioritization Techniques Additional Product Backlog Prioritization Techniques Kano Analysis Theme Screening Release Planning and Tracking Progress Velocity Release Planning Tracking release progress

This half day course provides participants with the knowledge and skills to write a simple but effective business plan for their organisation. It considers aspects of why business planning is important, what background research is needed, what subject areas to include and how to monitor progress against the business plan. For in-house courses the session could be extended to a whole day with participants spending the afternoon working on a first draft of a business plan.

Certified ScrumMaster®: In-House Training This course is an introduction to Scrum and the principles and tools required to be an effective Scrum Product Owner. You will come away with a good understanding of the Scrum framework and the underlying principles required to make effective decisions regarding the application of the Scrum framework to different situations. Participants successfully completing this course earn a Certified Scrum Product Owner® (CSPO®) designation. The Scrum Alliance certification includes a one-year membership with Scrum Alliance. What You Will Learn You'll learn how to: Use the principles, practices, and tools required to be an effective Scrum Product Owner Make effective decisions regarding the application of the Scrum framework to different situations, including: Setting product vision and goals Chartering the project Writing user stories and structuring your product backlog Scaling the Product Owner Estimating for forward planning Applying prioritization techniques Planning and tracking release progress Getting Started Introduction Course structure Course goals and objectives Agile Principles and Scrum Overview Process control models Incremental and iterative development Shifting the focus on product management Overview of the Scrum process Agile principles Lean principles Scrum Roles and Responsibilities Scrum roles Cross-functional teams Product Owner Responsibilities The Scrum Project Community What happens to my traditional role in Scrum? Chartering the Project Establishing a shared vision Elevator Statement Data sheets Product Vision Box Magazine Review / Press Release Product Backlog and User Stories Product uncertainty and progressive refinement User role modeling User Stories Product backlog characteristics Getting backlog items ready Slicing User Stories Using the product backlog to manage expectations Sprints Done and Scaling Done The Scrum process in detail Sustainable pace The Product Owner's role in each of the Scrum meetings Scaling the Product Owner Scaling Scrum Approaches to scaling the Product Owner Estimation for Forward Planning Why comparative estimation works Planning Poker Affinity Estimation Prioritization Techniques Additional Product Backlog Prioritization Techniques Kano Analysis Theme Screening Release Planning and Tracking Progress Velocity Release Planning Tracking release progress

Overview Improve your knowledge of the English language and pronunciation and practice your speaking and vocabulary with our video lessons and with live face to face with the trainer online and In-Class. Choose your English course level from our wide range of english courses and start learning online today. Take any of our high quality online English lessons with the highlu experienced trainer and improve your English speaking skills along with your grammar, reading and writing. Start by taking our English lessons to help you find your level and increase your communication skills also find lessons and resources to improve your English skills. Throuh this course you will get more practice to improve your general English with our extended listening and reading materials and online trainer led training. Improve your the grammar and vocabulary and support your learning.

This General English tutoring course is designed for adult learners who want to improve their overall English language proficiency. Participants will focus on developing their speaking, listening, reading, and writing skills in a variety of everyday contexts. Through interactive activities, discussions, and authentic materials, learners will gain confidence and fluency in using English for both social and practical purposes. Course Duration: 12 weeks (48 sessions) Course Objectives: By the end of this course, participants will: 1. Communicate confidently and effectively in English in various everyday situations. 2. Expand vocabulary and improve language accuracy. 3. Develop listening skills to understand different accents and speech patterns. 4. Enhance reading comprehension skills for various types of texts. 5. Write accurately and coherently for different purposes. Course Outline: Week 1: Introduction to General English - Introduction to course objectives, expectations, and methodology - Assessment of participants' current language proficiency and individual learning goals - Overview of key language skills and areas of focus Week 2: Speaking and Conversation Skills - Developing oral communication skills for everyday conversations - Role-plays and discussions on common topics and situations - Enhancing fluency, pronunciation, and vocabulary in spoken English Week 3: Vocabulary Expansion - Expanding general vocabulary and idiomatic expressions - Exercises and activities to reinforce and practice new words and phrases - Incorporating vocabulary into oral and written communication Week 4: Grammar and Language Accuracy - Reviewing and reinforcing essential grammar rules and structures - Identification and correction of common errors in speaking and writing - Exercises and activities to improve language accuracy Week 5: Listening and Comprehension Skills - Developing listening skills to understand different accents and speech patterns - Authentic listening materials such as dialogues, podcasts, and videos - Strategies for understanding main ideas, details, and specific information Week 6: Reading and Comprehension Skills - Developing reading skills for different types of texts (articles, short stories, etc.) - Strategies for skimming, scanning, and understanding written information - Identifying main ideas, supporting details, and inferring meaning from context Week 7: Writing Skills: Emails and Messages - Improving writing skills for everyday correspondence (emails, messages, etc.) - Practice exercises for clarity, coherence, and appropriate tone - Polishing grammar, vocabulary, and sentence structure in written communication Week 8: Writing Skills: Informal and Formal Writing - Developing writing skills for informal and formal purposes (letters, essays, etc.) - Techniques for organising ideas, supporting arguments, and expressing opinions - Practice exercises for clarity, coherence, and appropriate style in written communication Week 9: Pronunciation and Intonation - Developing clear and accurate pronunciation skills - Focus on individual sounds, stress, rhythm, and intonation patterns - Practice exercises and activities for improved spoken English Week 10: Everyday Practical English - Enhancing language skills for everyday practical situations (shopping, dining, etc.) - Role-plays and interactive exercises for real-life communication - Polishing conversational skills, expressions, and cultural understanding Week 11: Cultural Understanding and Communication - Understanding cultural nuances in English-speaking countries - Developing intercultural communication skills for effective interactions - Practising respectful and inclusive language in diverse environments Week 12: Review and Final Evaluation - Reviewing course content and addressing individual needs - Comprehensive review exercises for all language skills - Final evaluation and feedback session Note: This syllabus is a guideline and can be customised based on the specific needs, interests, and proficiency levels of the participants. The course may also include additional topics or activities to cater to learners' specific goals or areas of interest.

This English Exam Preparation course is specifically designed for adult learners who are preparing to take an English language proficiency exam, such as IELTS, TOEFL, or Cambridge exams. Participants will focus on developing the necessary skills and strategies to achieve a successful outcome in their chosen exam. Through targeted practice, exam-specific tasks, and personalised feedback, learners will gain confidence and proficiency in all sections of the exam. Course Duration: 12 weeks (48 sessions) Course Objectives: By the end of this course, participants will: 1. Understand the format and requirements of the chosen English language proficiency exam. 2. Develop effective strategies for each section of the exam. 3. Enhance reading, writing, listening, and speaking skills within the context of the exam. 4. Expand vocabulary and improve language accuracy for exam-specific tasks. 5. Practice time management techniques to complete tasks within the allocated time. Course Outline: Week 1: Introduction to the Exam - Introduction to the chosen English language proficiency exam - Overview of the exam format, sections, and scoring criteria - Assessment of participants' current language proficiency and individual learning goals Week 2: Reading Skills and Strategies - Understanding different question types in the reading section - Developing reading skills for comprehension, skimming, and scanning - Practice exercises and strategies to improve speed and accuracy Week 3: Writing Skills and Strategies - Analyzing the writing tasks and requirements of the exam - Developing skills for organising ideas, structuring paragraphs, and coherence - Practice exercises for different writing tasks (essays, reports, letters, etc.) Week 4: Listening Skills and Strategies - Identifying question types and understanding the listening section format - Developing listening skills for main ideas, details, and inference - Practice exercises and strategies for improving listening accuracy and note-taking Week 5: Speaking Skills and Strategies - Understanding the speaking section requirements and assessment criteria - Developing skills for fluency, coherence, and pronunciation - Practice exercises for different speaking tasks (interviews, presentations, etc.) Week 6: Vocabulary Expansion for Exam Tasks - Expanding vocabulary in specific topics and themes relevant to the exam - Practice exercises to reinforce and use new vocabulary effectively - Techniques for deducing meaning from context and using appropriate vocabulary Week 7: Grammar and Language Accuracy - Reviewing and reinforcing essential grammar rules and structures - Identification and correction of common grammar errors in exam tasks - Exercises and activities to improve language accuracy in writing and speaking Week 8: Time Management and Exam Strategies - Strategies for time management and prioritizing tasks during the exam - Practice exercises to improve speed and efficiency in completing tasks - Tips and techniques for maximizing scores in each section Week 9: Mock Exam: Reading and Writing - Simulating a complete reading and writing section of the exam - Timed practice sessions to replicate exam conditions - Detailed feedback and analysis of strengths and areas for improvement Week 10: Mock Exam: Listening and Speaking - Simulating a complete listening and speaking section of the exam - Timed practice sessions to replicate exam conditions - Detailed feedback and analysis of strengths and areas for improvement Week 11: Exam Strategies Review and Practice - Reviewing and reinforcing exam strategies for each section - Targeted practice exercises to address specific challenges and areas of improvement - Individualised feedback and guidance based on participants' performance Week 12: Final Evaluation and Exam Tips - Comprehensive review of all exam sections and strategies - Final evaluation to assess participants' progress and readiness for the exam - Tips for managing test anxiety and mental preparation for the exam Note: This syllabus is a guideline and can be customised based on the specific exam requirements and the needs, interests, and proficiency levels of the participants. The course may also include additional topics or activities to cater to learners' specific goals or areas of focus.

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.