8513 Courses

Face to face One to one.

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

Launch your Detailing Career Combining two of our syllabus levels into a 5-day period, this course has been specially created to accommodate those travelling from further afield, and international detailer training. UK Detailing Academy's recommended syllabus path remains that structured learning over a longer period remains the most effective way to deliver vocational education. It's the reason we disagree with supposed one-week 'master detailer' courses in principle, there's just too much information in a short space of time. However, we recognise that, for some, the logistical challenges can be both burdensome and financially off-putting. With that in mind, we have taken the decision to introduce an allowance to book Levels One and Two of our detailer syllabus back to back for those travelling long distances to attend. Attendees will still need to complete the coursework and take the online exams for both levels in order to achieve our certification. For more information on the syllabus of both courses, please read through the full course description below. Notes: Mondays are the only start day available online as this is a 5-day course. If you need to start on another day due to travel and run over into the following week, please contact us to discuss. To book this course using Paypal Credit, please contact the office as it exceeds the advertised maximum payment limit, which we can then negotiate. Combining two of our syllabus levels into a 5-day period, this course has been specially listed to accommodate those travelling from further afield and international detailer training. UK Detailing Academy's recommended syllabus path remains that structured learning over a longer period remains the most effective way to deliver vocational education. It's the reason we disagree with supposed 5-day 'master detailer' courses in principle. However, we recognise that for some the logistical challenges can be both burdensome and financially off-putting. With that in mind, we have taken the decision to introduce an allowance to book Levels One and Two of our detailer syllabus back to back for those travelling long distances to attend. Attendees will still need to complete the coursework and take the online exams for both levels in order to achieve our certification.   The aim of Level One is ideal for those just about to, or have recently entered the detailing industry, or those who wish to reset and refresh their skills. the aim is to familiarise the candidate with the processes and maintenance of vehicles from a professional and business view, teaching the foundations of correct vehicle cleaning up to the final familiarisation of entry-level dual action machine polishers. Business practices and health and safety are explored covering areas such as pricing, marketing, SDS and environmental conformity. Along the way topics covered will be: Washing stages Wash media Environmental considerations Drying methods Bonded contamination and its removal Wheel care and maintenance Glass and hard surfaces Engine bay cleaning Vulnerable surfaces Efficiency and process PPE and safety Clothing and working practices Risk assessment Chemical knowledge Van set-ups Interior detailing Leather and soft surface care Fillers/glazing Dual action machine polishers intro Minor defect identification Paint types LSPs Final presentation Marketing Conflict resolution and customer care Financing Insurance Pricing and quotes Business Administration Memberships Social Media Manual handling Safe working practices Pre-work inspection Level 2 Following your introduction skills learnt in Level One you will be progressing onto more advanced machine polishing and cleaning techniques. Machines introduced at this level include forced rotation dual action polishers, every inception of Dual action polishers, both in throw and size. We'll also look at pad types, heavy cutting options and defect identification to assess what can be rectified and how. Interiors are explored in greater depth with higher yield services with dry steam cleaning, odour removal, leather protection and treatment, and stain removal with the associated chemistry. • Pad types • Compound grades • Rubber and plastic protection • Coatings after-care • Polymer and PTFE exterior LSPs • Glass sealants • Troubleshooting • Accreditations • Financial management • Insurance • Marketing • Pricing • Spot Sanding • Targeting your customer base • Safe working practice • Workshop planning • Intermediate chemical knowledge • Efficiency and time management • Matt finishes • Environmental considerations • Advanced cleaner chemistry • Bonded overspray and concrete • LSPs • Engine bay detailing • Plastic trim restoration • Odour removal • Steam cleaning • Stain removal & chemical principles • Fabric and leather protection • Paint types and their principles • Long and short throw DA machines • Forced action machines • Lighting • Defect identification All levels are accompanied by a full course booklet to revisit topics covered when needed. Practical assessment takes place as part of the original training session, at the end of the course you will be assigned a (manageable) series of case studies and exercises to complete over the period of 3 months to cement the knowledge. There is then an externally assessed online exam, to ensure there are no weaker/problem areas and to assess the candidate's knowledge. After which the Level One and Two accreditations are awarded and you can either progress or choose to practice the skills gained with ongoing support. We would again stress that, if able to attend both courses separately, candidates are likely to better retain the information delivered. However, if logistics are a challenge, then this is the ideal course to get your detailing career started.   Course Length 3 Days (0930 - 1600) Group Size One-to-One Location UK Detailing Academy, 2 Purlieus Barn, Ewen, Cirencester, GL7 6BY Experience / Qualification Open to all Refreshments or Lunch Refreshments included

Windows PowerShell training course description This course is intended for IT Professionals who are already experienced in general Windows Server and Windows Client administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of Windows PowerShell, or any scripting language, is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Exchange Server, SharePoint Server, SQL Server, System Center, and others. What will you learn Work with Windows PowerShell pipeline. Query system information by using WMI and CIM. Work with variables, arrays, and hash tables. Write advanced scripts in Windows PowerShell. Administer remote computers. Use advanced Windows PowerShell techniques. Windows PowerShell training course details Who will benefit: IT professionals. Prerequisites: Supporting Windows Server Duration 5 days Windows PowerShell training course contents Getting started with Windows PowerShell Overview and background of Windows PowerShell, Understanding command syntax, Finding commands. Hands on Configuring Windows PowerShell console & ISE application. Hands on Finding and running basic commands, Using the About files. Cmdlets for administration Active Directory administration cmdlets, Network configuration cmdlets, Other server administration cmdlets. Hands on Windows Administration. Creating and managing Active Directory objects, Configuring network settings on Windows Server, Creating a web site. Working with the Windows PowerShell pipeline Understanding the pipeline, Selecting, sorting, and measuring objects, Filtering objects out of the pipeline, enumerating objects in the pipeline, Sending pipeline data as output. Hands on Using the pipeline. Selecting, sorting, and displaying data. Hands on Filtering objects. Hands on Enumerating objects. Hands on Sending output to a file. Exporting user information to a file. Understanding how the pipeline works Passing the pipeline data, Advanced considerations for pipeline data. Hands on Working with pipeline parameter binding. Predicting pipeline behaviour. Using PSProviders and PSDrives Using PSProviders, Using PSDrives. Hands on Using PSProviders and PSDrives Creating files and folders on a remote computer, Creating a registry key for your future scripts, Create a new Active Directory group. Querying system information by using WMI and CIM Understanding WMI and CIM, Querying data by using WMI and CIM, Making changes with WMI/CIM. Hands on Working with WMI and CIM. Querying information by using WMI, Querying information by using CIM, Invoking methods. Working with variables, arrays, and hash tables Manipulating variables, arrays and hash tables. Hands on Working with variables, Using arrays, Using hash tables. Basic scripting Introduction to scripting, Scripting constructs, Importing data from files. Hands on Basic scripting. Setting a script, Processing an array with a ForEach loop, Processing items by using If statements, Creating a random password, Creating users based on a CSV file. Advanced scripting Accepting user input, Overview of script documentation, Troubleshooting and error handling, Functions and modules. Hands on Accepting data from users. Querying disk information from remote computers, Updating the script to use alternate credentials, Documenting a script. Hands on Implementing functions and modules. Creating a logging function, Adding error handling to a script, Converting a function to a module. Administering Remote Computers Using basic Windows PowerShell remoting, Using advanced Windows PowerShell remoting techniques, Using PSSessions. Hands on Using basic remoting. Enabling remoting on the local computer, Performing one-to-one remoting, Performing one-to-many remoting. Hands on Using PSSessions. Using implicit remoting, Managing multiple computers. Using background jobs and scheduled jobs Using background jobs, Using scheduled jobs. Hands on Using background jobs and scheduled jobs. Starting and managing jobs, Creating a scheduled job. Using advanced Windows PowerShell techniques Creating profile scripts, Using advanced techniques. Hands on Practicing advanced techniques. Creating a profile script, Verifying the validity of an IP address, Reporting disk information, Configuring NTFS permissions, Creating user accounts with passwords from a CSV file. Hands on Practicing script development (optional)

In this practical and engaging workshop there is input on team building, problem solving as a team, improving communication and handling conflict. This is participatory day of paper, pens, graphics, music and activity. There are no PowerPoint slides or even a projector and screen! Course Category Team Building and Leadership Early Years Inclusion Description Want a really creative, effective, inclusive team? In this practical and engaging workshop there is input on team building, problem solving as a team, improving communication and handling conflict. This is participatory day of paper, pens, graphics, music and activity. There are no PowerPoint slides or even a projector and screen! We keep the focus on interpersonal processes for getting the best out of the team. Making teams both creative and inclusive is fully explored and processes for maximising this examined. Effective leadership and management, which can transform teamwork through collaboration and consensus-building processes is covered. We refocus the team on its capacities and gifts as well as give insights into what to do when individuals are off track. The Native American medicine wheel guides us through four quadrants of leadership, vision, community and management.Harrison Owen in his work on ‘Open Space Technology’ depicts the ancient Medicine Wheel (Owen, 2003). This is derived from centuries of tradition among First Nation Americans and has informed many cultures in different ways. We have found this an extremely powerful metaphor for understanding the process of team and organisational change and renewal. The wheel of change begins in the north with a leading idea, for us – there is a better way of creating a team for inclusion. Travelling clockwise to the east we develop a shared vision of what this could look like in our setting, school or community. Then moving south we ask who needs to come with us on the journey. We wish to take as many community members along with us as we can. In an Early Years setting , this would mean enrolling the support of manager, the wider staff group, parents and ultimately children. Finally, at the west, we manage and implement the idea. We take action and turn the inclusive team into reality. The cycle of this medicine wheel is an excellent way to view change processes for any team, organisation or community. When we contemplate change, the risk is always that we will jump prematurely from the big ideas (leadership) to practice (management) and ignore the other two important phases of creating vision and engaging the wider community. When the going gets tough and the inclusion of a child or young person is beginning to seem extremely difficult if not impossible many will conclude that the child should no longer be present. We would like to challenge this. Why do we move so quickly to assuming the child is in the wrong place? Surely the real question should not be ‘do they belong here?’ – but rather – ‘what team support is needed here for this to work?’ Or even more fundamental, ‘who needs a team around them at this time?’ Who needs the team? Who is struggling with the inclusion most? Is it the young person, their practitioner or teacher, their headteacher, setting manager, their parent or even a member of the local support services? Whatever the answer a team may need to be built, rallied or reformed. The nature of and number of that team will depend upon the situation. Diversity of membership will most surely be important to strengthen the quality of the support and of the ideas generated. Use radical rethinking when creating a new team or when revitalising an existing one. Creating effective teams for inclusion requires a courageous capacity for understanding and nurturing change both within the team and with those who the team work with. Testimonials ‘What a fun, enjoyable day its been. Motivating and made me laugh not fall asleep!’?? ‘This was everything a team building day was supposed to be. I have learned a lot about the people I work with and my role within the organisation’ ‘I had reservations about attending yet another team building day but this was executed by two great facilitators and they worked with us so we truly understood what we were thinking and feeling.’ ‘Innovative and refreshing’ Learning Objectives Empowerment of team players Deepened insights into team processes Practical strategies for team building learned Processes for enhancing creativity of team members explored Celebration and recognition of existing strengths and talents   Who Is It For ? Any team Course Content This course answers the following questions: How can we re-energise our team? How can we make our team more inclusive? What tools can we use to work creatively in our team? We work around the ancient medicine wheel as it guides us through the four processes of leadership, vision, community and management. We place leading ideas in front of your team including ‘no kvetching’ and shared promises. We create a shared vision of how your team would love to be. We explore who the team is. When are they at their best? What happens when someone is off track? What do they really need? How do we take the community with us at a time of change? Finally we look at the management role of the team. Getting things done together. We use problem solving together as our focus for this. Finally your team will be asked to reflect. What has the training meant to them? If you liked this you may like: SUPPORT AND SUPERVISION FOR LEADERS

Gain expertise in oil & gas financial modelling with our advanced Excel course. Unlock techniques for effective investment decisions.

In-depth Pointe shoe fitting course for dance shop owners, teachers and students

Learn the skills you need to copy an existing garment without deconstructing it - Sewing is your superpower

Simply speaking, Life Coaching is about raising awareness of how we can move from A to B. Sometimes we don't know what place B is, and we can use Coaching to gain clarity on what B looks and feels like. Life Coaching is non-directive, which means as a Coach, I help you to unlock your potential rather than tell you what to do. The experience creates a space for accountability and motivation to take positive action. ​ My role as your Holistic Coach is to provide you with a safe space for you to ground, explore & embrace your emotions, claim your personal power to design & live your dream life.

Phoenix Pottery and Art Studio offer a calendar of events including pottery courses and classes, glass fusing, art classes, watercolour painting classes and a variety of one off creative workshops. Situated in Golborne, with easy motorway access for the Northwest UK. Approx 20 miles from Liverpool and Manchester.