10864 Office courses

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are Application Consultants/Modelers and Project team members. Overview Get an overview of SAP HANA SPS09 and in-memory computing.Build an analytic data model with native HANA modeling tools.Understand the different approaches to provision data into SAP HANA.Learn how to connect to SAP HANA and consume HANA models. In this course, students get an overview of SAP HANA SPS09 and in-memory computing. Students will also gain an understanding of the different approaches to provision data into SAP HANA. Key concepts of SAP HANAWorking with SAP HANA StudioArchitecture of SAP in-memory computingModeling with SAP HANA Attribute Views Analytic Views Calculation Views Overview of data provisioning in SAP HANA with the tools Flat file upload SAP BusinessObjects Data Services SAP Landscape Transformation Replication Server SAP Replication Server SAP Direct Extractor Connection Smart Data Access Smart Data Integration / Smart Data Quality Smart Data Streaming SAP HANA Interfaces to BI client tools SAP BusinessObjects Analysis for Office SAP Design Studio SAP Lumira Additional course details: Nexus Humans HA100 SAP HANA - Introduction training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the HA100 SAP HANA - Introduction course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Corporate and Business Finance Optimisation bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 40 course mega bundle that will exceed your expectations within your budget. The Corporate and Business Finance Optimisation related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Corporate and Business Finance Optimisation bundle will help you build a solid foundation to become a proficient worker in the sector. This Corporate and Business Finance Optimisation Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 :Financial Consultant Training Course 02 :Making Budget & Forecast Course 03 :Business Model Canvas for Business Plan Course 04 :Dealing With Uncertainity: Make Budgets and Forecasts Course 05 :Financial Modeling Using Excel Course 06 :Debt Management - Online Course Course 07 :Financial Management Course 08 :Financial Statements Fraud Detection Training Course 09 :Anti-Money Laundering (AML) Training Course 10 :Document Control Course 11 :Corporate & Strategic Communication Skills for Managers Course 12 :Excel Vlookup, Xlookup, Match and Index Course 13 :Basic Data Analysis Course 14 :Pension UK Course 15 :GDPR Course 16 :Bookkeeper Training Course Course 17 :Xero Accounting and Bookkeeping Online Course 18 :Quickbooks Online Course 19 :Sage 50 Accounts Course 20 :Commercial Law Course 21 :UK Tax Accounting Course 22 :Cost Control & Project Scheduling Course 23 :Dynamic Excel Gantt Chart and Timelines Course 24 :Understanding Financial Statements and Analysis Course 25: Financial Reporting Course 26: Learn to Read, Analyse and Understand Annual Reports Course 27: Accounting Basics Course 28: Excel Pivot Tables for Data Reporting Course 29: Personal Productivity Course Course 30: Time Management Training - Online Course 10 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Course 04 :Video Job Interview for Job Seekers Course 05 :Create a Professional LinkedIn Profile Course 06 :Business English Perfection Course Course 07 :Networking Skills for Personal Success Course 08 :Boost Your Confidence and Self-Esteem Course 09 :Public Speaking Training Course 10 :Learn to Fight Procrastination Learning Outcome This tailor-made Corporate and Business Finance Optimisation bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Corporate and Business Finance Optimisation Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 400 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Corporate and Business Finance Optimisation bundle! This bundle is also ideal for professionals looking for career advancement. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Corporate and Business Finance Optimisation Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Do you struggle with assessing vocational skills and competence effectively? The Level 3 Certificate in Assessing Vocational Achievement (RQF) is your key to unlocking expertise in this field. Recognised and regulated by Ofqual, and awarded by Focus Awards, this course doesn't just educate; it transforms your educational profile. This qualification equips you with the skills and knowledge to excel in this pivotal role. It solves the problem of uncertainty in assessment by providing you with a comprehensive toolkit for making informed judgments. As a result, you'll ensure the success and industry relevance of your learners. Elevate your career and gain a competitive edge with a qualification that adds tangible value to your educational profile. Join us on this journey. Learning Outcomes Develop proficiency in assessing vocational skills and competence effectively. Understand diverse assessment methods and their appropriate application. Demonstrate legal and ethical compliance in assessment practices. Acquire skills for planning, conducting, and documenting assessments. Cultivate quality assurance techniques for enhancing assessment processes. Why Choose Focus Awards? Choosing Focus Awards for your educational and training programs provides several significant benefits. As an accrediting body overseen by Ofqual, their certifications are widely recognized internationally and globally, guaranteeing you are held to the highest educational standards. Focus Awards is a dynamic choice for a relevant and unique learning experience because of its commitment to professionalism, rapid expansion, and numerous qualification offerings. Choosing Focus Awards improves your professional chances, personal development, and educational accomplishments. Benefits you will gain Benefits you will enjoy include: Exceptional customer service. Recognised qualification. Compliance with standards. User-friendly online platform. 24/7 module access. High-quality virtual learning materials. Guided Learning Hours "Guided Learning Hours" includes all direct teaching and support given to a learner by educators, trainers, or supervisors. For this qualification, there are a total of 84 Guided Learning Hours provided. Total Qualification Time Total Qualification Time (TQT) combines guided learning hours (GLH) and the hours students are expected to spend on independent learning, study, and assessments, all under the guidance of educational staff but without direct supervision. Qualification credit values are based on TQT, where one credit equals 10 learning hours. This particular qualification has a Total Qualification Time of 150 hours. Method of Assessment Assessment tasks involve a series of concise assignments that you need to finish to demonstrate your understanding of the material and include references in your work. Unit 2 and Unit 3 require mandatory observation videos that should each last at least 30 minutes. Unit 1 involves a written assessment. You're required to submit all assignments through the online portal. To pass, you must fulfil all the learning objectives; there are no grades assigned. Progression After completing the Level 3 Certificate in Assessing Vocational Achievement (CAVA), learners often have several course progression options to further their education and career development: Level 4 Award in the Internal Quality Assurance of Assessment Processes and Practice (IQA): This qualification is suitable for those who wish to become internal quality assurers, ensuring that assessment processes and practices meet industry standards. Level 4 Certificate in Education and Training (CET): For those interested in becoming educators or trainers, this qualification focuses on the skills and knowledge required to teach in various learning environments. Level 4 Certificate in Leading the Internal Quality Assurance of Assessment Processes and Practice (IQA): This qualification is designed for individuals who want to take on leadership roles in quality assurance within assessment processes. Level 5 Diploma in Education and Training (DET): This advanced qualification is suitable for educators and trainers looking to enhance their teaching skills and knowledge Progression to higher education: Completing CAVA can also be a stepping stone for individuals interested in pursuing a higher education degree in education, training, or related fields. Specialised training courses: Depending on career goals, learners can choose from a variety of specialised training courses in areas such as leadership, management, or specific vocational subjects. Qualification Purpose The main goal of this certification is to confirm an individual's competence in a specific job role, in accordance with industry standards. This in-depth Level 3 Certificate in Assessing Vocational Achievement (RQF) course equips learners with the necessary knowledge and abilities to accurately assess occupational competence, whether in a workplace or other contexts. Who is this course for? Aspiring vocational assessors Educators and trainers HR professionals seeking assessment expertise Career changers entering the education sector Requirements This qualification has no specific entry requirements and is accredited for learners aged 19 years and above, including those with a minimum of a high school education and Level 3 AET (Award in Education and Training). Career path Vocational Assessor: £20,000 - £40,000 per year Educational Trainer: £25,000 - £50,000 per year HR Learning and Development Specialist: £30,000 - £60,000 per year Further Education Lecturer: £24,000 - £50,000 per year Quality Assurance Officer: £25,000 - £45,000 per year Training Coordinator: £22,000 - £40,000 per year Note: Registration, Assessment, Certification fee included with this price.

Organisational Skills for Administrators Organisational skills are something that successful business owners share. The ability to organise work and resources is key to running a successful business. Today's competitive business environment calls for strong organisational skills. A small business succeeds when deadlines and appointments are kept and met, without any wastage of time. Managers use organisational skills to steer their companies forward. Time management, scheduling, task prioritisation and planning are critical aspects of an administrator's organisational skills. Just like receptionists and secretaries, administrators are often associated with greeting guests at the office and answering phone calls. However, they are the core of businesses. They enable each member of the business team to get their jobs done. They communicate on behalf of executives, organise schedules, develop and maintain contact lists and offer support, among other roles. They are integral to business teams and, thus, must possess the right skill set to get their jobs done. This course covers various facets of an administrator's organisational skills. You Will Learn: The definition of organisational skills and what they entail The benefits of organisational skills Over 10 organisational skills for administrators and what they involve Benefits of Taking This Course: Taking this course will help you: Understand organisational skills and their role in business settings Determine the organisational skills that you possess Learn how to develop and improve your organisational skills Learn the benefits of possessing organisational skills Learn how organisational skills benefit both the administrator and the company or employer Determine if you have got what it takes to become an administrator Identify the skills to work on as an administrator Determine the skills to include in your CV, as an administrator who is looking for better job opportunities

Manual Handling Manual dealing with is a fundamental piece of pretty much every work all through the UK. Everybody from office laborers to the individuals who work on processing plant floors participate in some type of manual dealing with every single day. It is essential to find out about the dangers implied and how to lift, convey, push, and pull stacks securely. This is the most ideal approach to lessen the pace of working environment wounds, the majority of which are brought about by ill-advised manual taking care of practices. This course gives you a far reaching manual for manual dealing with. It starts by giving you a prologue to the idea of manual taking care of, including models and influenced work environments. It at that point broadly expounds on the commitments bosses and representatives should satisfy to protect their work environment. The particular kinds of dangers and risks, just as instances of how to deal with materials securely are likewise given. You Will Learn: The commitments bosses should satisfy as per the Manual Handling Operations Regulations The commitments representatives should satisfy as indicated by the Manual Handling Operations Regulations The dangers and perils that are implied with inappropriate manual taking care of, including the improvement of musculoskeletal issues and monotonous movement wounds Methods for protected and compelling manual dealing with Pragmatic arrangements and tips to remember with regards to manual taking care of and work environment security Advantages of Taking This Course Finding out about manual dealing with and how predominant it is in the present work environments Understanding the rights and commitments of representatives in the working environment with regards to manual taking care of Finding out about the particular dangers and perils that representatives face when they handle things inappropriately Figuring out how to physically deal with loads appropriately

Skype for Business Certification Intended for a professional workplace, Skype for Business permits clients to rapidly associate and speak with numerous individuals all at once. From community oriented online group meetings to streaming a gathering or joining a gathering from a telephone, Skype for Business gives a straightforward and productive climate for clients to collaborate across a worldwide scattered organization. This course takes an inside and out take a gander at how Skype for Business functions and how different highlights like texting, sound and video calls, presence pointers and the Skype for Business communitarian apparatuses can be utilized to improve the general efficiency and specialized techniques for a business. You will learn: Step by step instructions to introduce Skype for Business and incorporate it with the Microsoft Office 365 set-up of items. The most effective method to add contacts from inside and outside of your association and how the Skype for Business presence pointers work. The most effective method to text and settle on sound and video decisions with single and different members. The different ways that a Skype for Business internet meeting can be planned and joined. Instructions to viably utilize the coordinated effort devices that Skype for Business offers, including screen sharing, PowerPoint introductions, whiteboards, surveys and Q&A. Advantages of taking this course: You will figure out how to go through Skype for Business to set and run more successful gatherings. You will find how Skype for Business can help take your gatherings to a higher level with its different sharing and coordinated effort instruments. You will acquire understanding into the different specialized techniques Skype for Business offers, which will empower you to assist your business with conveying productively. Your insight will permit you to decide if Skype for Business is the correct decision for your business.

This level 3 award first aid at work training course helps you comply to first aid training requirements. We are based in Crawley West Sussex but will head anywhere in the UK fo a group of upto 12 people.

MySQL server admins training course description This MySQL Server administration course is designed for MySQL Server administrators who have a basic understanding of a MySQL database and a good working knowledge of SQL commands. The course provides an understanding of MySQL Architecture and practical experience in setting up, configuring and maintaining a MySQL server, backing up and recovering data and optimising query performance. This MySQL Server administration course also covers MySQL replication and its role in high availability and scalability. What will you learn Use MySQL Workbench. Install and configure a MySQL Server . Administer and tune a MySQL server. Configure log files and interpret error messages.. Secure the Server. Administer a replication topology. MySQL server admin training course details Who will benefit: Database administrators, Database developers and Technical consultants. Prerequisites: Introduction to MySQL Duration 5 days MySQL server admin training course contents Introduction to Oracle Application Express APEX concepts APEX main components Workspaces, database applications and websheet applications Creating a workspace The Workspace Administrator Upgrading APEX Logging into APEX Running an application SWL Workshop Use APEX to browse, create and modify objects Process ad hoc SQL statements Manage scripts in APEX Create, run and save SQL queries Build a database application Application components Create an application Create an application from a spreadsheet Create reports Create reports using wizards Edit report attributes Add links to reports Create a link to a printer-friendly version of a report Save and print reports in different formats Using files Uploading images Creating cascading stylesheet files Uploading static files Adding an Image as an application logo Adding a reference to a Javascript file Pages and regions Web form behaviour in APEX Create a form based on a table Create a form based on a procedure Create a form with a report Create a tabular form Format a form Locking in APEX forms Creating lists of values Overview of application express shared Components Dynamic and static lists of values Create a dynamic list of values Create a static list of values Use a list of values to control data in a report Create a cascading list of values Items and buttons Understand the different Types of items Create items Understand and edit item attributes Use Javascript with item Manipulate items in tabular forms Add dynamic items to a report Create and edit buttons Page Processing Page rendering and page processing Create computations Validate input data Process Data Understand application branching Create conditional branches Shared components Overview of application express navigation components Manage parent and standard tabs Create navigation bar entries Create and use lists and list items Manage breadcrumbs Create shortcuts Shared component subscription User interface defaults Display dynamic content Filter reports with dynamic queries Create charts with a wizard Format charts Create calendars Add links to calendars Create hierarchical trees State and debugging Understand session state Set a session state value Clear the session state Review the session state Review the messages in debug mode Enabling feedback Managing feedback and team development Themes and templates Switch to a different theme View existing templates Understand and manage templates Create a new template Add references to cascading stylesheet and Javascript files Dynamic actions and plug-in components Identify plug-in components and their types Plug In a component Create dynamic actions Use a plug-in in a dynamic action Building website applications Websheet applications and their components Create a websheet application Enable SQL and PL/SQL in a websheet application Add sections and pages to a websheet application Add links on a websheet page Add a data grid to a websheet application Create SQL reports ion websheet applications Add annotations to a websheet application Implementing security Authentication and authorization Provide an authentication scheme Create an authorization scheme using access control Enable and configure session state protection Deploy an appliction Define supporting objects Package an application Export an application Import an application Install supporting objects Administer Apex workspaces Manage workspaces and users Request a schema or storage Purge session state Monitor developer activity log Monitor workspace activity View activity reports Import a workspace Utility programs Import and export data Generate DDL statements View objects reports

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