11030 Courses

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

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

Our new 20 day part time program is designed to develop students over a longer period to develop their skillset, knowledge and learn all things barbershop in a barbershop environment. You will be taken on a journey by our experienced Educators with in-depth lectures and demonstrations. Students will work initially on real hair mannequin heads before transitioning to clients, all provided by the Academy, learning the renowned Sid Sottung method of hair design. Our nurturing educators work to develop each student until services can be performed independently.

Foundation • Advanced • Masterclass 8 CPD POINTS 1 DAY INTENSIVE COURSE  ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! Additional information ATTENDANCE ONLINE (theory), IN-CLINIC (Practice) COURSE LEVEL BEGINNER | Foundation Course, INTERMEDIATE | Advanced Course, EXPERT | Masterclass Course, ALL LEVELS 10% OFF

Join local artist Lou Davis for a relaxing watercolour painting session at The Arienas Collective in Edinburgh's beautiful Georgian New Town City Centre

Qualsafe Food Allergen Awareness (RQF) Half day course This course gives learners the knowledge and understanding of food allergens and foods that commonly cause intolerances Teaches how to minimise the risk of cross-contamination from allergenic ingredients Benefits of this course: This qualification is aimed at food handlers and other staff involved in food preparation and services It provides knowledge and understanding of food allergens and foods that commonly cause intolerances Many people are allergic to foods, or have a food intolerance There is a duty in law for food handlers to ensure these people do not come to harm, either by going into anaphylactic shock and their potential death, or by making them feel really ill for a long period after consuming the food. Course Contents: The characteristics and consequences of food allergies and intolerances How to identify and control contamination from allergenic ingredients Ways to accurate communicate of allergen information to consumers Accredited, Ofqual regulated qualification: This Food Allergen Awareness training course is a nationally recognised, Ofqual regulated qualifications accredited by Qualsafe Awards. This means that you can be rest assured that your Food Allergen Awareness Certificate provides information for best practice to make a real difference to the lives of people who suffer from food allergies or intolerances. It also helps to stay on the right side of the law! The Ofqual Register number for this course is 610/0114/8 Classroom £95.00 pp Enquire about this course Half day course This course gives learners the knowledge and understanding of food allergens and food intolerances Teaches how to minimise the risk of cross-contamination from allergenic ingredients Enquire about this courseCourse ContentsUpcoming Dates Face to Face / Classroom Courses Would you like this course? Contact us and we'll set a date. We also run short, CPD Accredited training sessions in Food Allergens and Intolerances. Enquire about this courseCourse Contents Benefits of this course: This qualification is aimed at those who are working in, or preparing to work in a food handling, food retail or food manufacturing role It provides knowledge and understanding of food allergens and intolerances Many people are allergic to foods, or have a food intolerance There is a duty in law for food handlers to ensure these people do not come to harm, either by going into anaphylactic shock and their potential death, or by making them feel really ill for a long period after consuming the food. This is an Ofqual regulated qualification, showing your due diligence and care for your customers Enquire about this course Course Contents The characteristics of food allergens, food intolerance and coeliac disease The importance of, and procedures for identifying and controlling food allergen risks How to provide accurate food allergen information Enquire about this course Our Reviews Facebook 5.0 Rating READ FACEBOOK REVIEWS "Informative and very enjoyable!" Google Reviews 5.0 Rating READ GOOGLE REVIEWS Accredited, Ofqual regulated qualification This Food Allergen Awareness training course is a nationally recognised, Ofqual regulated qualifications accredited by Qualsafe Awards. This means that you can be rest assured that your Food Allergen Awareness Certificate provides information for best practice to make a real difference to the lives of people who suffer from food allergies or intolerances. It also helps to stay on the right side of the law! The Ofqual Register number for this course is 610/0114/8

When it comes to booking a resin course, either for a career in resin flooring, or for your own resin pouring projects, you are in absolutely the best place. Our courses not only provide you with the knowledge and skill you’ll need to work with resin surfaces, but the enthusiasm too. You will leave us full of ideas and a desire to get started pouring the flooring, immediately! Our resin installers are not just resin trainers, we work in the industry, completing regular resin installations for both residential and commercial clients and we pass all of our knowledge through experience onto you, our clients. Our courses will give you both practical and theoretical knowledge in order to understand all aspects of a resin business. Depending on the course you undertake, you will learn about: Health and Safety aspects to working with resin. The benefits of Epoxy Resin Flooring. How to calculate quantities of resin products according to the size of your project. How to prime your surfaces for resin pouring, and which surfaces are suitable. How to apply long lasting top coats. How to deal with potential issues and troubleshooting with resin products. How to use resin to create other stunning surfaces - not just floors! How to effectively cost your epoxy resin projects, whether it's for flooring or any other resin surface. Unique sales and marketing advice for your resin business. We have an expert team of graphic designers, copy writers and website designers, all experienced in the resin industry. Our experts are highly trained and experienced when it comes to resin pouring. We have completed a huge number of installations and trained many people to do the same. Our passion and enthusiasm is infectious and we do not leave you behind once you have finished your resin floor training course.  We offer ongoing advice and support, discount on resin products and resin specific industry business advice. We are also on hand to help you with your own resin installations should you need an extra hand. A brilliant asset to have whilst establishing your own resin pouring company.  Our resin training courses leave you INSPIRED, EDUCATED and RARING TO GET STARTED. We cannot wait to meet you!    1 Day Taster Course – £295 Everything you need to know to start working with resin and create stunning resin floors. You will leave this one day taster session knowing how to successfully install a range of resin products, the maintenance and aftercare. Lunch included. 3 Day Intensive Course – £995 The training programme spans over three days of immersive learning, with both theory and hands-on workshops. The resin course will be held in our training unit where you will have your own individual training bay, enabling you to get a true sense of installing on a real floor. You will work with our industry experts, learning all steps to working with resin products to create visually stunning, long lasting floors.  Full resin floor installation process from preparation through to the finish. Detailed run through of all products used in the creation of resin flooring. Our course teaches you how to create special flooring effects using our resin products. Learn the secrets to creating similar floor designs as seen on our social media pages. Create your own sample board to take home. Lunch provided. Training manuals provided. Advice on costing installation. Full technical support and exclusivity to a range of our resin floor products. 5 Day 1-1 training – £3500 The most advanced course we offer. This 1 to 1 training is in-depth and is a complete journey into the world of resin. Learning 1 to 1 with industry professionals. Completing a full installation process, from preparation through to the finish. In-depth presentation and theory. Learn how to create special flooring effects using our products. Learn the secrets to creating similar floor designs as seen on our social media pages. Create your own sample board to take home. Lunch provided. Training manuals provided. Advice on costing installation. Marketing advice on how to create a successful business. Full technical support and exclusivity to a range of our products. On Site Masterclass – £POA Every so often we bring you the most unique experience by joining us for an on-site masterclass. If you’re keen to learn more, please let us know and we’ll add you to the list! What support do I get after a course? Rest assured we remain on hand to give you any advice you may need. From product choices to technical questions, we remain contactable. We also offer ongoing business support with a range of bespoke packages to get you set up.  We have helped many people start their resin flooring businesses and know what works! We have ongoing support for marketing / graphic design / websites with bespoke packages. Please let us know and we’ll talk you through.

Package beauty courses

Do you want a rewarding career working directly with people? Would you like to make a difference to their everyday lives? If you are warm, open and compassionate and can bring a patient and non-judgemental attitude, a career in counselling could be for you. The Level 3 Certificate is the second stage on the journey to becoming a qualified counsellor.