12 Other courses in Leeds

OVERVIEW -------------------------------------------------------------------------------- This Course is specially designed to enhance communication skills and gain advanced skills in office management. It will help identify key features of the role and will navigate through all the components and techniques for operating an efficient support team. This course will update your interpersonal skills, communication skills and other skills required to have effective office management and gain advanced administrative skills.

MYSQL PERFORMANCE & TUNING TRAINING COURSE DESCRIPTION This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. WHAT WILL YOU LEARN * Develop a monitoring and tuning plan * Use server configuration and status variables. * Identify and improve problem queries. * Make efficient use of indexes. * Monitor and size memory caches and locks. * Tune the MyISAM and InnoDB storage engine. * Evaluate the use of partitioning for performance. MYSQL PERFORMANCE & TUNING TRAINING COURSE DETAILS * Who will benefit: Anyone who wishes to monitor and tune MySQL performance. * Prerequisites: Delegates must have a working knowledge of MySQL Database Administration * Duration 3 days MYSQL PERFORMANCE & TUNING TRAINING COURSE CONTENTS * Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. * MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. * Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. * Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. * Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. * Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. * Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. * The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. * Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. * Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. * Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. * Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

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.

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.

In the past, popular thought treated artificial intelligence (AI) as if it were the domain of science fiction or some far-flung future. In the last few years, however, AI has been given new life. The business world has especially given it renewed interest. However, AI is not just another technology or process for the business to consider - it is a truly disruptive force.

A popular 3 day programme aimed at team supervisors and managers. Develop skills in managing yourself, your job and managing others.

This one-day workshop is designed to build upon skills already acquired using Microsoft Word, whether participants are self-taught or have previously attended a course. It gives participants a good understanding of managing different types of paragraph indents, and managing automated numbered paragraph lists. This course will help participants: * Create and manage the layout of paragraphs * Create and manage multi-level numbered paragraphs * Effectively insert, use and manage section breaks * Create and manage columns * Find, create and apply styles * Create and update a table of contents from styles * Work with styles to manage formatting * Work with sums in tables and use table headings * Input and edit text using AutoText * Work with SmartArt graphics * Link to other files using paste special 1 MANAGING PARAGRAPH LAYOUT * Controlling paragraph layouts with indents * Creating and managing paragraph hanging indents 2 NUMBERING PARAGRAPHS * Creating a new multi-level numbered paragraph * Managing existing multi-level numbered paragraphs 3 INSERTING COLUMNS * Creating columns from existing paragraphs * Setting up columns * Managing columns 4 DOCUMENT SECTION BREAKS * Controlling document layout using section breaks * Managing page orientation using section breaks * Managing page numbering using section breaks 5 USING STYLES * Applying quick styles * Finding existing styles * Creating and saving styles * Modifying styles * Creating a table of contents from styles * Updating a table of contents 6 USING QUICK PARTS * Saving content to quick parts * Modifying saved quick parts * Inserting content using AutoText * Editing AutoText entries * Inputting text using AutoCorrect 7 ADVANCED TABLE FEATURES * Sorting table columns * Running sums in tables * Repeating table headings at top of page * Importing Excel content in tables * Using table properties 8 CREATING A MAIL MERGE * Creating letters, labels and emails * Merging addresses from external files * Using Outlook's address book to merge * Merging to email 9 SMARTART GRAPHIC * Visually communicate content with SmartArt * Choosing a SmartArt graphic * Inputting into SmartArt * Modifying and formatting SmartArt graphics 10 LINKING TO OTHER FILES * Linking to files using paste special * Linking an Excel chart to a document * Managing linked content from Word

The often-used phrase, 'just the receptionist', completely misrepresents the role. An excellent receptionist is a most valuable resource for any organisation. This programme has been designed specifically to deal with the essential skills necessary to represent the organisation to the best possible effect. It will also help you get the most out of your working day. There are six key reasons to take part in this workshop. It will help you: * See your role in a new light * Develop your communication skills * Deal with different types of customer and situation * Boost your confidence * Cope in a pressurised environment * Get more satisfaction from your working day 1 INTRODUCTION * Workshop objectives and personal objectives * The challenges of 21st century communication * What makes an excellent point of Reception? And why is it so important? * Who and where are our customers? * As a customer, how do you like to be treated? * What makes people feel valued? * Objective and subjective aspects of customer service * 'Micro moments' that shape the relationship 2 COMMUNICATION ON RECEPTION * Definition of communication * Barriers to good communication * The 'recipe' of verbal, vocal and visual aspects of communication * Differences between communicating face-to-face and on the telephone * Communication 'leaks' * The primitive human response * The impact of visual communication - body language, gesture and facial expression * Voice - tone, speed, volume, pitch, clarity, inflection, pacing * Words - positive words and phrases compared with negative terminology * Professional greetings face-to-face * Steering the conversation with effective questioning 3 TELEPHONE EXCELLENCE * How we use the telephone * Qualities of the telephone * Non-verbal communication on the telephone - what aspects can be 'seen' by the other person? * Professional telephone etiquette * Taking and leaving messages - key points that can help customers, colleagues and the organisation * Clarifying information 4 LISTENING SKILLS FOR ACCURACY AND RELATIONSHIP BUILDING * How accurate are your listening skills? * What are the challenges for accurate listening? * Active / empathetic listening 5 CREATING A RAPPORT BY 'STYLE FLEXING' * Understanding how different people communicate * Shaping our message to the other person so that they feel understood * How changing situations can alter communication needs 6 CONFIDENCE AND ASSERTIVENESS * Recognising different styles of behaviour - aggressive, passive and assertive * Qualities of assertive communication - verbal, vocal and visual * Assertive techniques - basic, persistence, negotiation / empathetic * Demonstrating confidence 7 COPING IN A PRESSURISED ENVIRONMENT * Words - the most useful ones to use with stressed people and identifying the 'red rag' words * Challenging situations - what do you find difficult and how do you respond? * Dealing with outbursts of anger * Bringing non-stop talkers back from their tangent * Constructive ways to say 'no' 8 PULLING IT ALL TOGETHER * Action plans * Summary of key learning points

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

This one-day workshop is intended for participants who have a basic understanding of Outlook but who want to know how to use its advanced features to manage their email communications, calendar events, contact information and other communication tasks. This course will help participants: * Gain confidence using Outlook and its advanced features * Organise and prioritise email messages * Archive messages for safe-keeping * Use rules to process received or sent messages automatically * Manage scheduled meetings with others * Give others permission to view and manage their folders and items * Use contacts and commands to find out more about a person or company * Prioritise work-flow using tasks and assigning tasks to others 1 EMAIL MESSAGES * Combining multiple clicks with quick steps * Following up flag options * Saving multiple attachments * Attaching a folder of files * Recalling and replacing a message * Categorising messages with conditional formatting 2 MESSAGE OPTIONS * Adding options to messages * Marking a message as private * Receiving quick responses with voting buttons * Directing replies to specific users * Delaying sent messages * Inserting links in messages 3 STAY ORGANISED WITH RULES * Using rules to automate message flow * Moving messages with rules * Using the rules wizard * Setting up rules with conditions * Using rules that work whilst you are away 4 MESSAGE CLEAN-UP * Using conversation clean-up * Using mailbox clean-up * Moving messages to the archive folder * Archiving folder properties * Auto-archiving properties 5 MANAGING CALENDARS * Creating calendar groups * Sharing calendars with permissions * Setting up working days and times * Managing time zones * Categorise appointments with conditional formatting * Publishing a calendar 6 SCHEDULE MEETINGS * Scheduling a meeting * Managing meeting responses * Proposing new meeting times * Adding attendees to a meeting * Viewing multiple appointments 7 USING CONTACTS * Merging contacts to letters * Merging contacts to labels * Mail merging contacts in Word * Exporting contacts to Excel 8 MANAGING TASKS * Organising your workload with tasks * Categorising tasks * Assigning tasks to others * Sending a task status report * Allocating time for tasks * Regenerating a new task * Viewing your tasks in the calendar 9 ADDING MESSAGE ITEMS * Adding calendars to messages * Adding business cards to messages 10 EMAIL ACCOUNTS * Adding multiple user accounts * Adding account permissions