3736 Office Skills courses in Reigate delivered Online

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.

Database fundamentals training course description This three-day training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. What will you learn Describe core database concepts. Create database objects. Manipulate data. Describe data storage. Administer a database. Create a relational database consisting of 3 related tables. Database fundamentals training course details Who will benefit: Those working with databases. Prerequisites: None. Duration 3 days Database fundamentals training course contents Understanding core database concepts Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements. Creating database objects Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections. Manipulating data Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity. Understanding data storage Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table. Administering a Database Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.

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.

All in One Bundle Special Discount Offer Are you looking to enhance your Electrical Technician skills? If yes, then you have come to the right place. Our comprehensive courses on Electrical Technician will assist you in producing the best possible outcome by learning the Electrical Technician skills. CPD Accredited courses you will get: Course 01: Basic Electricity Course Course 02: Time Management Skills Course 03: Office Skills The Electrical Technician bundle is for those who want to be successful. In the Electrical Technician bundle, you will learn the essential knowledge needed to become well versed in Electrical Technician . Our Electrical Technician bundle starts with the basics of Electrical Technician and gradually progresses towards advanced topics. Therefore, each lesson of this Electrical Technician is intuitive and easy to understand. Why would you choose the Electrical Technician course from Compliance Central: Lifetime access to Electrical Technician courses materials Full tutor support is available from Monday to Friday with the Electrical Technician course Learn Electrical Technician skills at your own pace from the comfort of your home Gain a complete understanding of Electrical Technician course Accessible, informative Electrical Technician learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Electrical Technician bundle Study Electrical Technician in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Electrical Technician Course Improve your chance of gaining in demand skills and better earning potential by completing the Electrical Technician Curriculum of Course 01: Basic Electricity Course Module 01: Introduction and Basics Module 02: Electrical Units and Ohm's Law Module 03: Direct Current Module 04: Alternating Current Basics Module 05: Voltage and Resistance Module 06: Capacitance and Capacitors Module 07: Magnetism Module 08: Safety Precautions Curriculum of Course 02: Time Management Skills Module 01: Importance and Benefits of Time Management Module 02: Assess Your Current Work Practice Module 03: Identifying the Priorities Module 04: Say 'No' to Procrastination Module 05: Set Your Goals Module 06: Plan the Work Module 07: Work the Plan Module 08: Effective Time Management Techniques Module 09: Combat the Time Wasters Module 10: Time Management for Creative Work Module 11: The Art of Anticipating Module 12: Avoid Time Leaks Curriculum of Course 03: Office Skills Module 01: Core Office Skills Module 02: Self-Management Module 03: Organizing and Planning (i) Module 04: Organizing and Planning (ii) Module 05: Rapport Building CPD 30 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Electrical Technician bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Electrical Technician . It is also great for professionals who are already working in Electrical Technician and want to get promoted at work. Requirements To enrol in this Electrical Technician course, all you need is a basic understanding of the English Language and an internet connection. Career path The Electrical Technician course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Electrical Technician Certificates 3 CPD Accredited PDF Certificate Digital certificate - Included Get 3 CPD accredited PDF certificate for Free. Each CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hardcopy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

All in One Bundle Special Discount Offer Are you looking to enhance your Biomedical Science Analyst skills? If yes, then you have come to the right place. Our comprehensive courses on Biomedical Science Analyst will assist you in producing the best possible outcome by learning the Biomedical Science Analyst skills. CPD Accredited courses you will get: Course 01: Biomedical Science Course 02: Time Management Skills Course 03: Office Skills The Biomedical Science Analyst bundle is for those who want to be successful. In the Biomedical Science Analyst bundle, you will learn the essential knowledge needed to become well versed in Biomedical Science Analyst . Our Biomedical Science Analyst bundle starts with the basics of Biomedical Science Analyst and gradually progresses towards advanced topics. Therefore, each lesson of this Biomedical Science Analyst is intuitive and easy to understand. Why would you choose the Biomedical Science Analyst course from Compliance Central: Lifetime access to Biomedical Science Analyst courses materials Full tutor support is available from Monday to Friday with the Biomedical Science Analyst course Learn Biomedical Science Analyst skills at your own pace from the comfort of your home Gain a complete understanding of Biomedical Science Analyst course Accessible, informative Biomedical Science Analyst learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Biomedical Science Analyst bundle Study Biomedical Science Analyst in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Biomedical Science Analyst Course Improve your chance of gaining in demand skills and better earning potential by completing the Biomedical Science Analyst Curriculum of Course 01: Biomedical Science Module 01: Introduction to Biomedical Science Module 02: Genetics and Biochemistry Module 03: Microbiology and Cell Biology Module 04: Biochemical Engineering and Enzyme Discovery Module 05:Toxicology, Pharmaceuticals and Fine Chemicals Module 06: Systems and Synthetic Biology Module 07: Global Health Challenges Curriculum of Course 02: Time Management Skills Module 01: Importance and Benefits of Time Management Module 02: Assess Your Current Work Practice Module 03: Identifying the Priorities Module 04: Say 'No' to Procrastination Module 05: Set Your Goals Module 06: Plan the Work Module 07: Work the Plan Module 08: Effective Time Management Techniques Module 09: Combat the Time Wasters Module 10: Time Management for Creative Work Module 11: The Art of Anticipating Module 12: Avoid Time Leaks Curriculum of Course 03: Office Skills Module 01: Core Office Skills Module 02: Self-Management Module 03: Organizing and Planning (i) Module 04: Organizing and Planning (ii) Module 05: Rapport Building CPD 30 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Biomedical Science Analyst bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Biomedical Science Analyst. It is also great for professionals who are already working in Biomedical Science Analyst and want to get promoted at work. Requirements To enrol in this Biomedical Science Analyst course, all you need is a basic understanding of the English Language and an internet connection. Career path The Biomedical Science Analyst course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Biomedical Science Analyst. Certificates 3 CPD Accredited PDF Certificate Digital certificate - Included Each CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hardcopy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

All in One Bundle Special Discount Offer Are you looking to enhance your AutoCAD Design Principles skills? If yes, then you have come to the right place. Our comprehensive courses on AutoCAD Design Principles will assist you in producing the best possible outcome by learning the AutoCAD Design Principles skills. CPD Accredited courses you will get: Course 01: Autocad Electrical Design Course 02: Time Management Skills Course 03: Office Skills The AutoCAD Design Principles bundle is for those who want to be successful. In the AutoCAD Design Principles bundle, you will learn the essential knowledge needed to become well versed in AutoCAD Design Principles . Our AutoCAD Design Principles bundle starts with the basics of AutoCAD Design Principles and gradually progresses towards advanced topics. Therefore, each lesson of this AutoCAD Design Principles is intuitive and easy to understand. Why would you choose the AutoCAD Design Principles course from Compliance Central: Lifetime access to AutoCAD Design Principles courses materials Full tutor support is available from Monday to Friday with the AutoCAD Design Principles course Learn AutoCAD Design Principles skills at your own pace from the comfort of your home Gain a complete understanding of AutoCAD Design Principles course Accessible, informative AutoCAD Design Principles learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the AutoCAD Design Principles bundle Study AutoCAD Design Principles in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your AutoCAD Design Principles Course Improve your chance of gaining in demand skills and better earning potential by completing the AutoCAD Design Principles Curriculum of Course 01: Autocad Electrical Design Unit 1- Introduction to Autocad Unit 2- Electrical Design Drawing of Distribution System Unit 3- Voltage Drop and Short Circuit Analysis Unit 4- Earthing System Unit 5- Generator Sizing Curriculum of Course 02: Time Management Skills Module 01: Importance and Benefits of Time Management Module 02: Assess Your Current Work Practice Module 03: Identifying the Priorities Module 04: Say 'No' to Procrastination Module 05: Set Your Goals Module 06: Plan the Work Module 07: Work the Plan Module 08: Effective Time Management Techniques Module 09: Combat the Time Wasters Module 10: Time Management for Creative Work Module 11: The Art of Anticipating Module 12: Avoid Time Leaks Curriculum of Course 03: Office Skills Module 01: Core Office Skills Module 02: Self-Management Module 03: Organizing and Planning (i) Module 04: Organizing and Planning (ii) Module 05: Rapport Building CPD 30 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The AutoCAD Design Principles bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in AutoCAD Design Principles . It is also great for professionals who are already working in AutoCAD Design Principles and want to get promoted at work. Requirements To enrol in this AutoCAD Design Principles course, all you need is a basic understanding of the English Language and an internet connection. Career path The AutoCAD Design Principles course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to AutoCAD Design Principles Certificates 3 CPD Accredited PDF Certificate Digital certificate - Included Get 3 CPD accredited PDF certificate for Free. Each CPD Accredited Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hardcopy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

All in One Bundle Special Discount Offer Are you looking to enhance your Biochemist - CPD Accredited Course skills? If yes, then you have come to the right place. Our comprehensive courses on Biochemist - CPD Accredited Course will assist you in producing the best possible outcome by learning the Biochemist - CPD Accredited Course skills. CPD Accredited courses you will get: Course 01: Biochemistry Course 02: Time Management Skills Course 03: Office Skills The Biochemist - CPD Accredited Course bundle is for those who want to be successful. In the Biochemist - CPD Accredited Course bundle, you will learn the essential knowledge needed to become well versed in Biochemist - CPD Accredited Course . Our Biochemist - CPD Accredited Course bundle starts with the basics of Biochemist - CPD Accredited Course and gradually progresses towards advanced topics. Therefore, each lesson of this Biochemist - CPD Accredited Course is intuitive and easy to understand. Why would you choose the Biochemist - CPD Accredited Course course from Compliance Central: Lifetime access to Biochemist - CPD Accredited Course courses materials Full tutor support is available from Monday to Friday with the Biochemist - CPD Accredited Course course Learn Biochemist - CPD Accredited Course skills at your own pace from the comfort of your home Gain a complete understanding of Biochemist - CPD Accredited Course course Accessible, informative Biochemist - CPD Accredited Course learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Biochemist - CPD Accredited Course bundle Study Biochemist - CPD Accredited Course in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your Biochemist - CPD Accredited Course Course Improve your chance of gaining in demand skills and better earning potential by completing the Biochemist - CPD Accredited Course Curriculum of Course 01: Biochemistry Module 01: Introduction to Biochemistry Module 02: Introduction to Cells Module 03: Organic Chemist Module 04: Biomolecules Module 05: Protein Module 06: Biomolecules of Nucleic Acids Module 07: Genetics Module 08: Metabolism Curriculum of Course 02: Time Management Skills Module 01: Importance and Benefits of Time Management Module 02: Assess Your Current Work Practice Module 03: Identifying the Priorities Module 04: Say 'No' to Procrastination Module 05: Set Your Goals Module 06: Plan the Work Module 07: Work the Plan Module 08: Effective Time Management Techniques Module 09: Combat the Time Wasters Module 10: Time Management for Creative Work Module 11: The Art of Anticipating Module 12: Avoid Time Leaks Curriculum of Course 03: Office Skills Module 01: Core Office Skills Module 02: Self-Management Module 03: Organizing and Planning (i) Module 04: Organizing and Planning (ii) Module 05: Rapport Building CPD 30 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Biochemist - CPD Accredited Course bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Biochemist - CPD Accredited Course . It is also great for professionals who are already working in Biochemist - CPD Accredited Course and want to get promoted at work. Requirements To enrol in this Biochemist - CPD Accredited Course course, all you need is a basic understanding of the English Language and an internet connection. Career path The Biochemist - CPD Accredited Course course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Biochemist - CPD Accredited Course. Certificates 3 CPD Accredited PDF Certificate Digital certificate - Included Get 3 CPD accredited PDF certificate for Free. Each CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hardcopy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

This workshop helps you understand the neuroscience behind why working ‘harder’ isn’t the answer to being effective at work. You'll get to recognise your default behaviour and helpful alternatives to managing competing requests on your time.

All in One Bundle Special Discount Offer Are you looking to enhance your UX Consultant - UI/ UX skills? If yes, then you have come to the right place. Our comprehensive courses on UX Consultant - UI/ UX will assist you in producing the best possible outcome by learning the UX Consultant - UI/ UX skills. CPD Accredited courses you will get: Course 01: Advanced Diploma in User Experience UI/UX Design Course 02: Time Management Skills Course 03: Office Skills The UX Consultant - UI/ UX bundle is for those who want to be successful. In the UX Consultant - UI/ UX bundle, you will learn the essential knowledge needed to become well versed in UX Consultant - UI/ UX . Our UX Consultant - UI/ UX bundle starts with the basics of UX Consultant - UI/ UX and gradually progresses towards advanced topics. Therefore, each lesson of this UX Consultant - UI/ UX is intuitive and easy to understand. Why would you choose the UX Consultant - UI/ UX course from Compliance Central: Lifetime access to UX Consultant - UI/ UX courses materials Full tutor support is available from Monday to Friday with the UX Consultant - UI/ UX course Learn UX Consultant - UI/ UX skills at your own pace from the comfort of your home Gain a complete understanding of UX Consultant - UI/ UX course Accessible, informative UX Consultant - UI/ UX learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the UX Consultant - UI/ UX bundle Study UX Consultant - UI/ UX in your own time through your computer, tablet or mobile device. A 100% learning satisfaction guarantee with your UX Consultant - UI/ UX Course Improve your chance of gaining in demand skills and better earning potential by completing the UX Consultant - UI/ UX Curriculum of Course 01: Advanced Diploma in User Experience UI/UX Design UX/UI Course Introduction Introduction To The Web Industry Foundations of Graphic Design UX Design (User Experience Design) UI Design (User Interface Design) Optimization Starting a Career in UX/UI Design Curriculum of Course 02: Time Management Skills Module 01: Importance and Benefits of Time Management Module 02: Assess Your Current Work Practice Module 03: Identifying the Priorities Module 04: Say 'No' to Procrastination Module 05: Set Your Goals Module 06: Plan the Work Module 07: Work the Plan Module 08: Effective Time Management Techniques Module 09: Combat the Time Wasters Module 10: Time Management for Creative Work Module 11: The Art of Anticipating Module 12: Avoid Time Leaks Curriculum of Course 03: Office Skills Module 01: Core Office Skills Module 02: Self-Management Module 03: Organizing and Planning (i) Module 04: Organizing and Planning (ii) Module 05: Rapport Building CPD 35 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The UX Consultant - UI/ UX bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in UX Consultant - UI/ UX . It is also great for professionals who are already working in UX Consultant - UI/ UX and want to get promoted at work. Requirements To enrol in this UX Consultant - UI/ UX course, all you need is a basic understanding of the English Language and an internet connection. Career path The UX Consultant - UI/ UX course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to UX Consultant - UI/ UX. Certificates 3 CPD Accredited PDF Certificate Digital certificate - Included Get 3 CPD accredited PDF certificate for Free. Each CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hardcopy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each

Oracle SQL Advanced training course description The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features. What will you learn Retrieve data using correlated subqueries, in-line views and multi-column subqueries. Use the WITH Clause. Inserting and Updating Rows Using Complex Subqueries Create Hierarchical Queries. Use ROLLUP, CUBE and GROUPING SETS group by enhancements. Implement the GROUPING and GROUPING_ID functions. Manage large data sets. Insert data conditionally and unconditionally. Merge Rows in a Table. Create TIMESTAMP and INTERVAL Datatypes. Use TIMESTAMP, TIMEZONE and INTERVAL functions and literals. Use regular expressions and implement related functions. Manage objects with the data dictionary. Manage schema objects. Perform flashback operations. Create and using external tables. Control user access to database objects. Oracle SQL Advanced training course details Who will benefit: Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. Prerequisites: Delegates should have attended the Oracle SQL course or have a similar level of experience. Duration 2 days Oracle SQL Advanced training course contents Retrieve data using subqueries ANY, ALL or SOME operators, Correlated subqueries, In-Line views, The Exists operator, The WITH clause, Multi-Column subqueries, Insert and update using a query, Correlated update and delete. Hierarchical queries Hierarchical data, The START WITH and CONNECT BY clauses, The LEVEL pseudo-column, Sequencing the output, Eliminating nodes and branches. Enhanced grouping features Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions. Manage large data sets Multi-table Inserts, Conditional and unconditional Inserts, Merging data into a table, Table and view based merge, A sub query based merge. Flashback technology Flashback query, The AS clause, Flashback table, Flashback drop. Date, time and time zone support Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters. Regular expression support Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions. Manage objects with the Data Dictionary The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary. Manage schema objects Column operations, Constraint operations, Creating and dropping Indexes, B-Tree indexes, Function based indexes, Descending indexes, Creating and using external tables. Access control System privileges and roles, Create users, Alter user details, Grant and revoke object privileges.