128 Courses in Glasgow delivered Live Online

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

Learners will be introduced to Voice Alarm (VA) systems as part of the fire alarm solutions.

PRINCE2® Foundation: In-House Training Projects fail for a variety of reasons including poor planning, lack of defined quality criteria, poor understanding of the business drivers, inadequate control, and lack of senior management involvement in other words, lack of a structured best practice approach to project delivery. PRINCE2® (6th Edition is the current version) is a structured, process-based approach to project management providing a methodology which can be easily tailored and scaled to suit all types of projects. It is the de facto standard for project management in the UK Government and is used extensively in more than 150 countries worldwide with in excess of 20,000 organizations already benefiting from its powerful approach. It can be used easily in combination with PMI®'s PMBOK® Guideto provide a robust project management methodology, or to augment an existing PMBOK®-based methodology with additional rigor around areas such as Quality, Organization, and Benefits Realization. The goals of this course are to provide participants with a thorough grounding in PRINCE2® and its benefits and to prepare them to sit the Foundation exam. What you will Learn You'll learn how to: Identify the benefits and principles underlying a structured approach to project management Define the PRINCE2® method in depth, including the principles, themes, and processes Prepare and practice for the Foundation exam Getting Started Introductions Course structure Course goals and objectives Overview of the PRINCE2® Foundation exam PRINCE2® Introduction Introducing PRINCE2® The structure of PRINCE2® What PRINCE2® does not provide What makes a project a 'PRINCE2® project'? Project Management with PRINCE2® Defining a project Managing a project Controlling the variables The Project Manager's work PRINCE2 Principles PRINCE2® Principles The Seven Principles Tailoring and Adopting PRINCE2® Defining tailoring Defining embedding What can be tailored? Who is responsible for tailoring? Introduction to the PRINCE2® Themes What is a PRINCE2® Theme? What are the PRINCE2® Themes? Tailoring the themes Format of the theme chapters Business Case Need for a business case Elements of a business case How a business case is developed Managing Benefits Organization Need for a special type of organization PRINCE2® organization structure Roles in a PRINCE2® project Combining roles Quality Relevance of quality to project work Quality, quality control, and quality assurance Quality management approach and the quality register Who is responsible for quality? Plans Need for plans and their hierarchy Approach to planning Content of a PRINCE2® plan Product-based planning Risk The need to manage risks What is a risk? Risk and continued business justification A risk management option Change Change is inevitable Different types of change Baselines and configuration management Issue and change control in PRINCE2® Progress Controlling a PRINCE2® project The application of tolerance Types of control Raising exceptions Introduction to Processes Processes and the project lifecycle The PRINCE2® journey Structure of the process chapters Tailoring the processes Starting up a Project Appointing people to the PRINCE2® roles Establishing some baselines Should we go further with this work? Planning for initiation Directing a Project Should we start / continue the project? Responding to internal / external influences Should we close this project? Initiating a Project Establishing the project's approaches Creating the project plan Refining the business case Assembling the PID Controlling a Stage Authorizing and reviewing work Monitoring and reporting Handling non-planned situations Triggering the next process Managing Product Delivery Accepting work from the Project Manager Getting the work done by the team Routine and non-routine reporting Handing back the completed work Managing a Stage Boundary Taking stock of what we have done Updating the PID Consider the options for continuing / stopping Producing exception plans Closing a Project PRINCE2® at the end of a project Transition of product to operational use How well did we do? Tying up all the loose ends

PRINCE2® Foundation: Virtual In-House Training Projects fail for a variety of reasons including poor planning, lack of defined quality criteria, poor understanding of the business drivers, inadequate control, and lack of senior management involvement in other words, lack of a structured best practice approach to project delivery. PRINCE2® (6th Edition is the current version) is a structured, process-based approach to project management providing a methodology which can be easily tailored and scaled to suit all types of projects. It is the de facto standard for project management in the UK Government and is used extensively in more than 150 countries worldwide with in excess of 20,000 organizations already benefiting from its powerful approach. It can be used easily in combination with PMI®'s PMBOK® Guideto provide a robust project management methodology, or to augment an existing PMBOK®-based methodology with additional rigor around areas such as Quality, Organization, and Benefits Realization. The goals of this course are to provide participants with a thorough grounding in PRINCE2® and its benefits and to prepare them to sit the Foundation exam. What you will Learn You'll learn how to: Identify the benefits and principles underlying a structured approach to project management Define the PRINCE2® method in depth, including the principles, themes, and processes Prepare and practice for the Foundation exam Getting Started Introductions Course structure Course goals and objectives Overview of the PRINCE2® Foundation exam PRINCE2® Introduction Introducing PRINCE2® The structure of PRINCE2® What PRINCE2® does not provide What makes a project a 'PRINCE2® project'? Project Management with PRINCE2® Defining a project Managing a project Controlling the variables The Project Manager's work PRINCE2 Principles PRINCE2® Principles The Seven Principles Tailoring and Adopting PRINCE2® Defining tailoring Defining embedding What can be tailored? Who is responsible for tailoring? Introduction to the PRINCE2® Themes What is a PRINCE2® Theme? What are the PRINCE2® Themes? Tailoring the themes Format of the theme chapters Business Case Need for a business case Elements of a business case How a business case is developed Managing Benefits Organization Need for a special type of organization PRINCE2® organization structure Roles in a PRINCE2® project Combining roles Quality Relevance of quality to project work Quality, quality control, and quality assurance Quality management approach and the quality register Who is responsible for quality? Plans Need for plans and their hierarchy Approach to planning Content of a PRINCE2® plan Product-based planning Risk The need to manage risks What is a risk? Risk and continued business justification A risk management option Change Change is inevitable Different types of change Baselines and configuration management Issue and change control in PRINCE2® Progress Controlling a PRINCE2® project The application of tolerance Types of control Raising exceptions Introduction to Processes Processes and the project lifecycle The PRINCE2® journey Structure of the process chapters Tailoring the processes Starting up a Project Appointing people to the PRINCE2® roles Establishing some baselines Should we go further with this work? Planning for initiation Directing a Project Should we start / continue the project? Responding to internal / external influences Should we close this project? Initiating a Project Establishing the project's approaches Creating the project plan Refining the business case Assembling the PID Controlling a Stage Authorizing and reviewing work Monitoring and reporting Handling non-planned situations Triggering the next process Managing Product Delivery Accepting work from the Project Manager Getting the work done by the team Routine and non-routine reporting Handing back the completed work Managing a Stage Boundary Taking stock of what we have done Updating the PID Consider the options for continuing / stopping Producing exception plans Closing a Project PRINCE2® at the end of a project Transition of product to operational use How well did we do? Tying up all the loose ends

Whether you are embarking on your coaching journey or boast a wealth of coaching experience, Systemic Coaching Supervision presents a vibrant resource for professional and personal growth. This unique approach employs a systemic perspective to review your interactions with teams, organisations, couples, and individuals, while also delving into the dynamics within yourself. You will take another stride toward mastering the art of working with complex systems through Systemic Coaching Supervision. Guided by one of our seasoned supervisors, this process will:   1. Heighten your self-awareness as a coach. 2. Unearth strategies to enhance the depth and breadth of your coaching practice. 3. Strengthen your commitment to ethical conduct and best coaching practices. 4. Recharge and rejuvenate yourself for the demands of this rewarding but challenging work.   Within a nurturing cohort, you will encounter the same level of collaboration and wisdom that you have grown to rely on in Organisation and Relationship Systems Coaching (ORSC™). CRR Global’s coaching supervision, rooted in systemic principles, provides invaluable support for the vital work you undertake with teams and intricate systems.   Our team coaching supervision sessions fulfil the requirements for yourAdvanced Certification for Team Coaches (ACTC) accreditation via the ICF. · Intimate groups · Engage in a virtual program consisting of four 75-minute sessions · Cultivate this beneficial routine for coaching professionals · Partake in systems-inspired introspection led by an experienced ORSC coaching supervisor · Further enrich your skills in team and systems coaching, elevate self-awareness, and explore ethical standards and best practices · Utilise a framework that facilitates system alignment and collective action · Eligible for five hours of ICF resource development credits   Fulfil the required five hours of group coaching supervision needed for the Advanced Certification in Team Coaching (ACTC). Explore the transformative power of reflective practice in enhancing your coaching skills. Utilising CRR Global’s Meet, Reveal, Align & Act model as your guide, you will reinforce your capacity for systems thinking and unpack your experiences to evolve as a more proficient practitioner.

Complete VBA programming training course description This course helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience, you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. We start at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language in Word, Excel, Outlook, and PowerPoint. What will you learn Record, write and run macros. Work with VBA Editor. Use the huge library of built-in functions. Create simple dialog boxes and complex forms. Customize Word, Excel, PowerPoint, Outlook, and Access. Program the Office 2016 ribbon. Complete VBA programming training course details Who will benefit: Anyone looking to extend the capabilities of the entire Office suite using VBA. Prerequisites: None. Duration 5 days Complete VBA programming training course contents Macros and getting started in VBA VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. Working with VBA 1 VBA syntax, variables, constants, and enumerations, array variables, finding objects, methods, and properties. Decisions, loops and functions Built-in functions, creating your own functions, making decisions in your code, using loops to repeat actions. Using message boxes, input boxes, and dialog boxes Getting user input with message boxes and input boxes, creating simple custom dialog boxes, creating complex forms. Creating effective code Building modular code and using classes, debugging your code and handling errors, building well-behaved code, exploring VBA's security features. Programming the Office applications The Word object model and key objects, working with widely used objects in Word, the Excel object model and key objects, working with widely used objects in Excel, the PowerPoint object, model and key objects, working with shapes and running slide shows, the Outlook object model and key objects, working with events in Outlook, the Access object model and key objects, manipulating the data in an Access database via VBA, accessing one application from another application, programming the Office 2016 ribbon.

CPD Accredited, Interactive Short Course - 1.5 hr session - Learn from the comfort of your own home or workplace - Learn how to deal with wounds, burns, sprains & strains, and other injuries Course Contents: What is classed as Display Screen Equipment (DSE) Who is a DSE user Illnesses and Injuries caused by the incorrect use of DSE How to set up your workstation so as to avoid injuries and musculoskeletal disorders DSE Assessment Checklist Work routine and the importance of taking breaks Eyes and eyesight testing Identifying training needs Working from home and home working assessments Benefits of this Short Course: In 2018/2019, nearly half a million people suffered from work-related musculoskeletal disorders, most of them having suffered from this for a while Though 138,000 of them only started having problems this year These conditions can significantly affect a person's life, and limit their mobility and dexterity This leads to being forced to retire early from work, earn less and have less of a social life I enjoyed the minor injuries webinar as it refreshed my memory in these areas and gave me the confidence to deal with any of these now. The training was delivered with practical demonstrations and I enjoyed the chance to use my brain during the lockdown.DEBBIE GROSCH-SQUANCE

If you have a lots of going on in your life and feel a bit lost, craving for some relaxing time and creativity, join me online for an hour of journaling, mindful breathing, drawing and lettering

Course Objectives At the end of this course you will be able to: Record and edit a Macro Assign macros to keyboard shortcuts, Quick Access Toolbar, Buttons and Shape objects. Use the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks Create an error handling routine in case things go wrong with VBA code ' 1 year email support service Take a closer look at the consistent excellent feedback from our growing corporate clients visiting our site ms-officetraining co uk Customer Feedback Best Training Ever! Just finished a bespoke 1-1 training course in Excel Advanced, Macros & VBA. Pedro is an excellent trainer, imparting his skills and knowledge in the best way - appropriately to audience skills, knowledge and ability. Pedro is always approachable, encouraging and supportive, giving delegates the optimum learning environment. I would not hesitate to recommend Pedro as a trainer, whatever your level of ability. Amanda Morris - Treasury & Systems Accountant at Reall - Real Equity for All The trainer was very knowledgeable, kept everyone involved and was enthusiastic. A great experience.. Simon Harper - Lloyd's of London My learning experience was awesome. Perdinand Reagan - Subsea7 Very nice and relaxed approach to teaching. Was definitely a good learning experience. Jerome Pupe - S5 Agency World The Trainer – Very positive + patient + helpful + thorough Agnes Souza - Direct Wines ' With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Our competitive rates start from £550.00 per day of training Tailored training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introduction to Macros and VBA Introducing Visual Basic for Applications Recording a Macro Naming conventions for Macro Procedures Running a Macro Absolute or Relative Cell Referencing Saving and Opening Files with Macros Making macros always available Adding Macros to Keyboard Shortcuts, Quick Access Toolbar, Buttons and Shapes Editing a Macro in the Visual Basic Editor Understanding the Development Environment Customising the Editor Tips for General Typing in VBA Using Visual Basic Help Working with Procedures Program Design Understanding Modules Naming Rules Creating a Module Understanding Procedures Programming Macro Concepts Creating a Subroutine Creating a Function Understanding Arguments Exiting Procedures Calling Procedures Objects, Properties, Methods and Events Understanding Objects Properties, Methods, and Events Navigating the Object Hierarchy Understanding Collections Accessing a Member of a Collection Understanding Hierarchy Using the Object Browser Using the With Statement Working with Properties Working with Methods Creating an Event Procedure Reserved Macro Names Using Expressions, Variables and Intrinsic Functions Understanding Expressions and Statements Declaring Variables Understanding Data Types Determining the Value of Variables Working with Variable Scope Using Built-in VBA Functions Understanding Constants Using Message Boxes Controlling the Answer to a Message Box Using Input Boxes Declaring and Using Object Variables Controlling Program Execution Understanding Control-of-Flow Structures Using the If...End If Decision Structures Nested If Statements Using the Select Case ... End Select Structure Using the Do ... Loop Structure Using the For ... Next Structure Using the For Each ... Next Structure Guidelines for Use of Control-of-Flow Structures Debugging and Handling Errors Understanding Errors Using Debugging Tools Setting Breakpoints and Using Break Mode Stepping Through Code Trapping Errors with the On Error Statement Understanding the Err Object Working with Inline Error Handling Writing an Error-Handling Routine Working with Forms and Controls Understanding UserForms Creating a Form Displaying and Removing a Form Aligning and Sizing Controls Using the Toolbox Working with a Form's Properties, Methods, and Events Working with Form and Control Properties, Methods and Event Setting the Tab Order Populating a Control Who is this course for? Who is this course for? This course is designed to give proficiency in the Visual Basic Editor (VBE), predominantly making use of Excel objects, understanding Object's Properties, Events and Methods, basic VBA Object oriented programming, event handling, control structures, and debugging tools. Requirements Requirements Preferably, delegates should have attended the Excel Advanced course. Certificates Certificates Certificate of completion Digital certificate - Included

Feedback Mastery Unleashed: 28 day online mini-programme to ignite high performance leadership for high achieving teams