3722 Office Skills courses in London delivered Online

Supporting Microsoft SQL server course description A concise hands on course enabling delegates to manage and administer a Microsoft SQL server database. What will you learn Install SQL server. Backup SQL server databases. Recover SQL server databases. Secure SQL server databases. Perform routine maintenance. Automate tasks. Supporting Microsoft SQL server course details Who will benefit: Anyone working with Microsoft SQL server Prerequisites: Supporting Windows server. Duration 3 days Supporting Microsoft SQL server course contents SQL server introduction Platform, Tools, services. Installation. Creating databases. Backups Back up types, transaction logging, restoring from a backup: Full database, individual files. Security Users, server roles, database roles. Permissions. Monitoring Routine database maintenance. Performance data. Jobs and alerts The SQL server agent, database mail, alerts, jobs.

Administering Microsoft SQL Server course description This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on how to use SQL Server 2016 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server 2016, but also the important capabilities across the SQL Server data platform. What will you learn Describe core database administration tasks and tools. Configure SQL Server databases and storage. Import and export data. Monitor SQL Server. Trace SQL Server activity. Manage SQL Server security. Audit data access and encrypt data. Administering Microsoft SQL Server course details Who will benefit: Individuals who work with SQL Server databases. Individuals who develop applications that deliver content from SQL Server databases. Prerequisites: Introduction to data communications & networking. Duration 3 days Administering Microsoft SQL Server course contents Introduction to SQL Server administration Database administration, SQL Server platform, database management tools and techniques. Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server. Working with databases and storage Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Hands on Configuring tempdb storage, creating databases, attaching a database. Importing and exporting data Transferring data, importing and exporting table data, copying or moving a database. Hands on import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function. Monitoring SQL Server 2014 Monitoring SQL Server, dynamic management views and functions, performance monitor. Hands on Baseline metrics, monitoring a workload. Tracing SQL Server activity Tracing workload activity, using traces. Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations. Managing SQL Server security SQL Server security, server-level security, database-level principals, database permissions. Hands on SQL Server security. Testing access.

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.

Database design training course description Although this course mentions Microsoft Access the same course can be run with a variety of different databases. The duration of the course is dependent on the experience of the delegates. What will you learn Name and give 3 types of database structure. Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to query and define databases. Describe the principles of relational database design and 3 types of relational joins. Normalise a given flat file table into relational tables. Database design training course details Who will benefit: Anyone who needs to be able to design an efficient, watertight database following the best practice of the principles of Relational Database design. Prerequisites: None. Duration 3 days Database design training course contents Database structure and terminology. Principles of Relational Database Design. Types of relationship. Normal Forms. Practical examples of relational database design. Hands-on creation of a database. On paper design a relational database applicable to the delegates work.

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 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

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

All in One Bundle Special Discount Offer A recent report by Grant Thornton shows that 72% of Finance Directors believe strong financial leadership is critical for business growth. The Finance Director plays a pivotal role in shaping a company's financial health and strategic direction. This comprehensive CPD-accredited Finance Director training equips you with the knowledge and skills to excel in this crucial position. CPD Accredited courses you will get: Course 01: Banking and Finance Accounting Statements Financial Analysis Course 02: Time Management Skills Course 03: Office Skills The Finance Director Training bundle is for those who want to be successful. In the Finance Director Training bundle, you will learn the essential knowledge needed to become well versed in Finance Director Training . Our Finance Director Training bundle starts with the basics of Finance Director Training and gradually progresses towards advanced topics. Therefore, each lesson of this Finance Director Training is intuitive and easy to understand. Why would you choose the Finance Director Training course: Lifetime access to Finance Director Training courses materials Full tutor support is available from Monday to Friday with the Finance Director Training course Learn Finance Director Training skills at your own pace from the comfort of your home Gain a complete understanding of Finance Director Training course Accessible, informative Finance Director Training learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Finance Director Training bundle Study Finance Director Training in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Finance Director Training course Course 01: Banking and Finance Accounting Statements Financial Analysis Section 01: Introduction and Welcome to the Course Section 02: Introduction to Accounting Section 03: Introduction to Financial Statements Section 04: Understanding Working Capital Section 05: Introduction to Financial Analysis Section 06: Financial Analysis - Case Study and Assignment Section 07: Financial Ratio Analysis in Corporate Finance Section 08: Financial Modelling for Mergers and Acquisitions Section 09: Course Summary and Wrap Up 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 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 Finance Director Training bundle is Ideal for: Finance professionals seeking to become Finance Directors and develop strategic leadership skills. Existing Finance Directors looking to strengthen their financial acumen and climb the corporate ladder. Business owners and managers who want to gain a deeper understanding of financial analysis for better decision-making. Individuals transitioning into finance roles that require a strong foundation in financial statements and analysis. Requirements To enrol in this Finance Director Training course, all you need is a basic understanding of the English Language and an internet connection. Career path The Finance Director role offers a rewarding career path with excellent earning potential. This Finance Director course positions you for success in various industries, including: Banking and Financial Services Manufacturing Technology Retail Healthcare Non-profit Organizations Government Agencies 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