3722 Office Skills courses in London delivered Online

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.

Level 7 QLS Endorsed Diploma | 180 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

In the dynamic landscape of the UK job market, staying abreast of industry demands is paramount. The recent surge in construction hazards in the UK has underscored the critical need for adept professionals in Payroll Management. Our comprehensive diploma courses not only address this pressing issue but also equip you with a multifaceted skill set crucial for diverse financial roles. Learning Outcomes Upon completion of this Payroll Management bundle, you should be able to: Master payroll administration for effective financial management. Navigate accounting complexities with a diploma in accounting and bookkeeping. Understand the intricacies of UK pension systems for sound financial planning. Enhance legal acumen through Law and Contracts - Level 2. Harness the power of Sage 50 Accounts for streamlined financial processes. Develop essential office skills and advanced proficiency in Microsoft Excel. Gain expertise in GDPR data protection and anti-money laundering practices. Our curriculum, ranging from Payroll Management to Bookkeeping and Payroll Administration, not only delves into the intricacies of financial management but also extends to areas like pension schemes, legalities, and data protection. Moreover, our courses integrate practical tools such as Sage 50 Accounts and Microsoft Excel Level 3, ensuring you are proficient in the latest technologies. This Payroll Management Bundle Consists of the following Premium courses: Course 01: Payroll Management - Diploma Course 02: Bookkeeping and Payroll Administration Diploma Course 03: Payroll Management - Diploma Course 04: Diploma in Accounting and Bookkeeping Course 05: Pension UK Course 06: Law and Contracts - Level 2 Course 07: Sage 50 Accounts Course 08: Office Skills Course 09: Microsoft Excel Level 3 Course 10: GDPR Data Protection Course 11: Certificate in Anti-Money Laundering (AML) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals seeking a comprehensive understanding of financial management. Professionals aiming to enhance their proficiency in payroll administration. Aspirants looking to broaden their knowledge in accounting and bookkeeping. Those interested in gaining insights into pension schemes and financial planning. Individuals keen on advancing their legal acumen in contracts and legislation. Anyone desiring expertise in data protection and anti-money laundering practices. Requirements No requirements to enrol this Payroll Management Training course. Career path Payroll Administrator: £25,000 - £35,000 per annum Bookkeeper: £22,000 - £30,000 per annum Accounting Assistant: £23,000 - £32,000 per annum Legal Support Officer: £26,000 - £35,000 per annum Compliance Analyst: £30,000 - £40,000 per annum Data Protection Officer: £35,000 - £45,000 per annum Certificates CPDQS Accredited e-Certificate Digital certificate - Included CPDQS Accredited Hard-Copy Certificate Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Payroll Management - Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that in the UK, 82% of new managers are appointed with little to no formal training? This can lead to challenges in motivating teams, achieving goals, and navigating complex situations. Are you ready to step up and become a confident and effective leader? This comprehensive New Manager Training Bundle equips you with the essential skills and knowledge to excel in your new role. From mastering administrative tasks and performance management to building strong teams and navigating legal aspects, this programme covers everything you need to succeed. Gain valuable insights into corporate behavior, health and safety regulations, and information management, all while developing your proficiency in Microsoft Office Suite essentials. With a single payment, you will gain access to New Manager course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This New Manager Bundle Package includes: Main Course : Award in New Manager at QLS Level 2 10 Additional CPDQS Accredited Premium Courses - Course 01: Admin, Secretarial & PA Course 02: Office Skills Training Course 03: Corporate Paralegal Course 04: Performance Management Course 05: Team Management Course 06: Microsoft Word, PowerPoint & Outlook Course 07: Health and Safety in the Workplace, Level 2 Course 08: Diploma in Business Management: Corporate Behaviour Course 09: Workplace First Aid Training Course 10: Information Management Take control of your career development and enroll in the New Manager Training Bundle today! Sharpen your skills, boost your confidence, and become the leader your team deserves. Learning Outcomes of New Manager Develop administrative, secretarial, and office management skills for operational efficiency. Understand corporate paralegal work and performance management principles. Learn effective team management strategies and leadership techniques. Gain proficiency in Microsoft Office tools for enhanced productivity. Acquire knowledge of health and safety regulations and corporate behavior. Develop skills in information management and workplace first aid. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of New Manager Get a free student ID card with New Manager Training program (£10 postal charge will be applicable for international delivery) The New Manager is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the New Manager course materials The New Manager comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Main Course : Award in New Manager at QLS Level 2 Module One: Managers Are Made, Not Born Module Two: Create A Management Track Module Three: Define And Build Competencies Module Four: Managers Learn By Being Managed Well Module Five: Provide Tools Module Six: Provide Support Module Seven: Identify Strong Candidates Early Module Eight: Clearly Define The Management Track Module Nine: Empower New Managers Module Ten: Provide Growth Opportunities Course 01: Admin, Secretarial & PA Module 01: Personal Assistant Module 02: Admin Support Module 03: Administrative Management Module 04: Organisational Skills Module 05: Telephone Etiquette Module 06: Business Writing Module 07: Time Management Module 08: Body Language And Effective Communication Module 09: Meeting Management Module 10: Excel Basics Module 11: PowerPoint Basic Course 02: Office Skills Training Module 01: Personal Assistant Module 02: Admin Support Module 03: Administrative Management Module 04: Organisational Skills Module 05: Telephone Etiquette Module 06: Business Writing Module 07: Time Management Module 08: Body Language And Effective Communication Module 09: Meeting Management Module 10: Excel Basics Module 11: PowerPoint Basic =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £79) CPD 255 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: New Managers Team Leaders Supervisors HR Professionals Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Management Consultant Project Manager Operations Manager Director CEO Certificates Award in New Manager at QLS Level 2 Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. Award in New Manager at QLS Level 2 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Complete Microsoft Office 2019 Overview The Microsoft Office 2019 is designed to educate you with everything you need to use the universal software - Microsoft Office to your advantage and boost your work efficiency. Through this course, you will master the incredibly useful applications of Microsoft Office such as Word, Excel, PowerPoint, Access, and Outlook. This comprehensive Microsoft Office course at QLS Level 7 course also helps in identifying new and enhanced features of all applications in MS Office. In addition, you will get the chance for improving your Microsoft Office skills for work, new career prospects, or simply enhancing your CV. Successful completion of this course will give an edge to your career and help to build your abilities in using the applications more confidently and efficiently. Why Choose this Course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. Furthermore, there are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of- Video lessons Online study supplies Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £119. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. When the student passes the assessment, thry can apply for a certificate. Who is this course for? The Microsoft Office 2019 is suitable for anyone who wants to gain extensive knowledge, potential experience, and expert skills in the related field. This is also a great opportunity for all student from any academic backgrounds to learn more about this subject.

Introduction to AI for Business

24-Hour Flash Sale! Prices Reduced Like Never Before!! Step into the world of Facilities Management, where every detail counts and operational efficiency is crucial. In the UK, facilities management plays a crucial role, directly impacting over £111 billion of the GDP annually. This sector not only ensures the smooth operation of buildings and services but also significantly influences productivity and well-being. The Facilities Management bundle equips you with the essential skills to excel in this dynamic field, combining strategic oversight with practical applications. Our comprehensive Facilities Management course bundle provides insight into the core aspects of managing large-scale operations effectively. Starting with a foundation in facilities management principles, the courses extend into Project Management, Strategic Planning, and specialised training in Human Resources Management. You will learn to implement Quality Management systems, including ISO 9001 standards, understand essential office skills, and master document control. Courses Are Included in this Facilities Management Bundle: Course 01: Facilities Management at QLS Level 5 Course 02: Project Management Course 03: Strategic Planning Process Course 04: Certificate in Human Resources Management at QLS Level 3 Course 05: HR, Recruitment and Laws Course 06: Quality Assurance (QA) Manager Course 07: Quality Management Course 08: Performance Management Level 3 Course 09: Quality and Strategic Training - ISO 9001 Course 10: Office Skills (Administration, Communication and Management) Diploma Course 11: Document Control Joining this Facilities Management course will set you apart in the workforce, providing you with the tools to significantly enhance operational efficiencies and employee satisfaction. Enrol today to become a leader in Facilities Management, where your influence can lead to substantial improvements in your organisation's environment and operations! Learning Outcomes of this Bundle: Master essential facilities management operations at a professional level. Execute project management tasks efficiently from planning to completion. Formulate and implement effective strategic planning processes. Acquire critical HR management skills, including recruitment and law. Implement and manage ISO 9001 quality management systems. Enhance workplace productivity through advanced office skills and document control. This Diploma in Facilities Management at QLS Level 5 course is endorsed by The Quality Licence Scheme and accredited by CPD QS (with 150 CPD points) to make your skill development & career progression more accessible than ever! Why Prefer this Course? Get a Free CPD Accredited Certificate upon completion of the course Get a Free Student ID Card with this training program (£10 postal charge will be applicable for international delivery) The course is Affordable and Simple to understand Get Lifetime Access to the course materials The training program comes with 24/7 Tutor Support Start your learning journey straight away! Moreover, this diploma offers learners the opportunity to acquire skills that are highly valued in the field of Facilities Management. With this Certification, graduates are better positioned to pursue career advancement and higher responsibilities within the Facilities Management setting. The skills and knowledge gained from this course will enable learners to make meaningful contributions to Facilities Management-related fields impacting their Facilities Management experiences and long-term development. Course Curriculum Course 01: Facilities Management at QLS Level 5 Module 01: Introduction Module 02: Space Management Module 03: Managing Workplace Services Module 04: Human Resource and Contract Management Module 05: Lease-Purchase and Vendor Management Module 06: Health and Safety at Work Module 07: Sustainable Facility Management Module 08: Maintenance and Repairs Module 09: Project Management Module 10: Business Development and Succession Planning Course 02: Project Management Module 01: Introduction to Project Management Module 02: PMBOK and PMI Module 03: Global Project Management Module 04: Project Life Cycle Module 05: Quality Management Module 06: Effective Planning & Scheduling Module 07: Human Resource Management Module 08: Performance Management Module 09: Organising Meeting and Conferences Module 10: Managing Resources Module 11: Change Management Module 12: Business Resilience and Crisis Management Module 13: Conflict Management Course 03: Strategic Planning Process Module 01: Preparing for the Strategic Planning Process Module 02: Establish a Committee Module 03: Gather Operational Data Module 04: Develop a Mission Statement Module 05: Develop a Vision Statement Module 06: Assess Internal and External Environments Module 07: Performing SWOT Analysis Module 08: Prioritise What the Strategic Plan Will Address Module 09: Set Goals and Objective Module 10: Develop Strategy for Achieving Goals Module 11: Draft the Strategic Plan Module 12: Assign Responsibility and Authority Module 13: Establish a Monitoring System =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) CPD Hard Copy Certificate: Free (For The First Course: Previously it was £29.99) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Aspiring facility managers. HR professionals. Quality assurance managers. Project managers. Administrative officers. Strategic planners. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Facilities Manager: $55,000 - $85,000 Project Manager: $60,000 - $90,000 HR Manager: $50,000 - $70,000 Quality Assurance Manager: $58,000 - $88,000 Operations Manager: $65,000 - $95,000 Strategic Planner: $60,000 - $85,000 Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now A Legal Secretary or PA plays a crucial role in reducing costs and the success of legal professionals. Moreover, with technological advances and fierce competition in the law industry, the demand for the Legal Secretary and PA is constantly rising. To become a legal secretary or PA, you need to acquire certain office skills and learn multiple laws such as- business law, international law, employment law, etc. Along with this Legal Secretary course, you will get 10 premium courses, an original hardcopy, 11 PDF Certificates ( Legal Secretaries Advanced Diploma + Additional Courses) Student ID card as gifts. This Legal Secretary Bundle Consists of the following Premium courses: Course 1: Legal Secretaries Advanced Diploma Course 2: Business Law Course 3: Contract Law UK Level 3 Course 4: Employment Law Level 3 Course 5: International Law Course 6: Medical Law Course 7: Family Law 2021 Course 8: Understanding Wills and Probate Laws - Level 2 Course 9: Criminal Law and Criminology Diploma Course 10: Level 2 Effective Minute Taking Course Course 11: Office Skills So, enrol now to advance your Legal Secretary career! Benefits you'll get from choosing Apex Learning for this Legal Secretary: Pay once and get lifetime access to 11 CPD courses, including this Legal Secretary Course Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the Legal Secretary course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules of Legal Secretary designed by expert instructors Learn about course at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills Curriculum of Legal Secretary Training Course 1: Legal Secretaries Advanced Diploma Legal Secretary Meeting Management & Minute Taking Other Secretarial Roles and Responsibilities Customer Service Role Telephone Etiquette Organizing Work Using MS Word Proof Reading And much more... How will I get my Certificate? After successfully completing the Legal Secretary course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 130 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Legal Secretary Training Bundle. Requirements This Training Course has been designed to be fully compatible with tablets and smartphones. Career path Completion of this Legal Secretary bundle will pave the way to different career opportunities for the learners; few examples: Legal Assistant Legal Administrative Assistant Legal Receptionist Legal Admin Assistant Legal Receptionist Legal Support Assistant Legal Administrator Team Legal Secretary For these career opportunities, the average salary generally varies from £15,000 to £40,000 a year. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Legal Secretaries Advanced Diploma) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins