17843 Courses delivered Online

Be it a career change, an exciting new hobby, perfecting existing skills or simply enhancing professional employment prospects– we help you unlock creativity through our industry aligned all-encompassing Graphic Design Course. " Having done my level 1 and level 2 in graphic design, I felt that I still had gaps in my knowledge and I wasn't comfortable with what I knew. I signed up with Blue Sky Graphics and I am really glad I did. I am definitely better now than when I started and this is all thanks to my tutor and Blue Sky Graphics 🙂 " A Comprehensive Advanced Course The graphic design course is a structured academic and industry aligned advanced course suitable for complete beginners, intermediates or those wanting to improve their existing skill set. The graphic design course is comprehensive and through our teaching methodology is designed to train participants to become professional Graphic Designers. There is an emphasis on corporate illustration, composition, painting and logos as well as advertisement designs while focusing on vectors, lines, features, shapes, and spaces. All this will be integrated into how graphic elements are printed after they are processed in graphic design software for the purpose of visually illustrating emotions and messages. During the course you will be exposed to: advertisements, magazines, newspapers, corporate graphic designs particular to company cultures and brand identity, stationery, letterheads, business cards, logos, books, packaging and much more. The graphic design course teaches you to understand and learn how to operate a labyrinthine yet amazing world of Adobe software. With this software we explore the uses of words, shapes, textures, forms, sizes and colours to communicate by combining ideas and images to make a new concept. Graphic design through common misconception is not just about layout and typography, but much more about ideas behind visual meaning. Graphic design can make a company more successful in the world if it makes communication smart, attractive and able to captivate its audience. Graphic design can effectively be used by businesses to make (or break) their brand identity, increase sales, promote web traffic or promote services and products through advertising on their websites to convey complex data to its readers in a clear way. Elements of graphic design include: Colour, Size, Texture, Line, Shape, Space and, Form. It is important that each element is understood correctly, and this is one of the key principles we teach on our graphic design course. In other terms, graphic design communicates certain ideas or messages through visuals. These visuals can be as simple as a business logo, or as complex as pages of web design. This course goes beyond just the practical side of graphic design and includes the theory and substance behind modern graphic design. Your teacher will guide you on: What salary you can expect at the start of your career? How to get new clients for your business for freelance designers ? How to find work for the new graphic designer starting out in the big world? How to quickly integrate into the graphic design field? How to combine working from home versus working at a studio ? Begin one-to-one online learning with your very own private tutor Interested? Our course is 7 months long, consisting of 1 hour 30 minutes of online one-to-one sessions. When you enrol at Blue Sky Graphics expect at least 90 minutes of class sessions and 2 – 4 hours of homework per week. If we accommodate the course delivery into a shorter time frame, (for e.g. over 4 months instead of 7 months the Flexi 3 doubles from £265.00 to £450.00 over 4 months) the instalment is billed at the delivery rate.  The cost of traditional schooling is typically more expensive than online courses, but in the end it all comes down to how good the tutors are. With our online courses you can gain skills that are a necessity for graphic design remotely. That’s right! Learn the skills needed to use Photoshop, Illustrator, InDesign and portfolio! The online courses cost £1799.00 (VAT inclusive) with no extra hidden costs and there are affordable instalment options too. Pay via debit or credit card or use a payment plan. A deposit of £294.00 is required to secure your position.

Level 4 Certificate in Education and Training: Take your teaching career to new heights! Acquire advanced pedagogical skills, curriculum design expertise, and leadership in education.

About this Virtual Instructor Led Training (VILT) The 5 half-day Piping Stress Engineering Virtual Instructor Led Training (VILT) course will systematically expose participants to: The theory and practice of piping stress engineering, with special reference to ASME B 31.1 and ASME B 31.3 Standards. The basic principles and theories of stress and strain and piping stress engineering, through a series of lessons, case study presentations, in-class examples, multiple-choice questions (MCQs) and mandatory exercises. Principal stresses and shear stresses which form the backbone of stress analysis of a material. Expressions for these quantities will be derived using vector algebra from fundamentals. Thermal stress-range, sustained and occasional stresses, code stress equations, allowable stresses, how to increase flexibility of a piping system, cold spring. The historical development of computational techniques from hand calculations in the 1950s to the present-day software. Training Objectives On completion of this VILT course, participants will be able to: Identify potential loads the piping systems and categorise the loads to primary and secondary. Determine stresses that develop in a pipe due to various types of loads and how to derive stress-load relationships, starting from scratch. Treat the primary and secondary stresses in piping system in line with the intent of ASME Standards B 31.1 and B 31.3 and understand how the two codes deal with flexibility of piping systems, concepts of self-springing and relaxation/shake down, displacement stress range and fatigue, what is meant by code compliance. Understand the principles of flexibility analysis, piping elements and their individual effects, flexibility factor, flexibility characteristic, bending of a curved beam and importance of virtual length of an elbow in the flexibility of a piping system. Learn stress intensification factors of bends, branch connections and flanges. Understand how the stresses in the material should be controlled for the safety of the piping system, the user and the environment. Examine how codes give guidance to determine allowable stresses, stress range reduction due to cyclic loading, and effects sustained loads have on fatigue life of piping. Confidently handle terminal forces and moments on equipment. Understand the supplementary engineering standards required to establish acceptance of the equipment terminal loads and what can be done when there are no engineering standard governing equipment terminal loads is available and learn the techniques of local stress analysis. Get a thorough understanding of the concepts and the rules established by the ASME B 31.1 and ASME B 31.3 Standards. Perform flange load analysis calculations based on Kellogg's Equivalent Pressure method & Nuclear Code method. Perform the same using a piping stress analysis software and check for flange stresses and leakage. Confidently undertake formal training of piping stress analysis using any commercial software, with a clear understanding of what happens within the software rather than a 'blind' software training and start the journey of becoming a specialist piping stress engineer.   Target Audience The VILT course is intended for: Recent mechanical engineering graduates who desire to get into the specialist discipline of Piping Stress Engineering. Junior mechanical, chemical, structural and project engineers in the industry who wish to understand the basics of Piping Stress Engineering. Engineers with some process plant experience who desire to progress into the much sought-after specialist disciplines of Piping Stress Engineering. Mechanical, process and structural engineers with some process plant experience who desire to upskill themselves with the knowledge in piping stress engineering and to become a Piping Stress Engineer. Any piping engineer with some pipe stressing experience in the industry who wish to understand the theory and practice of Piping Stress Engineering at a greater depth. A comprehensive set of course notes, practice exercises and multiple-choice questions (MCQs) are included. Participants will be given time to raise questions and participants will be assessed and graded based on responses to MCQs and mandatory exercises. A certificate will be issued to each participant and it will carry one of the three performance levels: Commendable, Merit or Satisfactory, depending on how the participant has performed in MCQs and mandatory exercises. Training Methods The VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total). Trainer Your expert course leader is a fully qualified Chartered Professional Engineer with over 40 years of professional experience in Oil & Gas (onshore and offshore), Petrochemical and Mining industries in engineering, engineering/design management and quality technical management related to plant design and construction. At present, he is assisting a few Perth based oil & gas and mining companies in detail engineering, piping stress analysis, feasibility study and business development work related to plant design. He is a pioneer in piping stress engineering in Western Australia. His recent major accomplishments include the following roles and challenges: Quality Technical Support Manager of USD 54 billion (Gorgon LNG Project). This encompassed management of quality technical services connected with Welding, Welding Related Metallurgy, Non-Destructive Examination, Insulation /Refractory /Coating, AS2885 Pipelines Regulatory Compliance and Pressure Vessel Registration. Regional Piping Practice Lead and Lead Piping Engineer of Hatch Associates. In this role, he was responsible for providing discipline leadership to several mining projects for BHP Billiton (Ravensthorpe), ALCOA-Australia (Alumina), Maáden Saudi Arabia (Alumina), QSLIC China (Magnesium), COOEC China (O&G Gorgon). He was actively involved in the development of piping engineering practice in WA, including training and professional development of graduate, junior and senior engineers. This also includes the formation of the Piping Engineering Specialist Group. Lead Piping/Pipe Stress Engineer on ConocoPhillips' (COP) Bayu Undan Gas Recycle, Condensate production and processing platform. He was able to develop several novel design methodologies for the project and provided training to engineers on how to implement them. These methodologies were commended by COP and the underwriters of the project Lloyds Register of Shipping, UK. Creator of Piping Engineering Professional Course aimed at global engineering community. Professional Affiliations: Fellow, Institution of Mechanical Engineers, UK (IMechE) Fellow, Institution of Engineers, Australia (EA), National Register of Engineers (NER) Member American Society of Mechanical Engineers, USA (ASME) Honorary Life Member, Institution of Engineers, Sri Lanka (IESL)   POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

This course is designed for anyone who needs to contact customers that they have never contacted before. This is never easy nor enjoyable. However, it is by far and away the most successful way of contacting new customers, quickly qualifying them and then arranging a first meeting.

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

This one-day workshop is ideal for those looking to work with existing databases as well as creating a new Access database. You will learn effective ways to enter and extract data and convert data into a well-presented format for reports. This course will help participants: Plan and create a database Sort and filter records Use field data types Work with tables Create and manage a query Create and work with forms, and use the form wizard View, create and print reports 1 Access introduced Planning a database Creating a blank database Opening an existing database Security warnings The navigation pane Previewing database components Closing an Access database 2 Tables introduced Viewing and navigating table data Navigating using keyboard shortcuts Editing table data Adding records to tables Selecting and deleting records Finding and replacing data Filtering tables Summing table data 3 Queries introduced Opening a query in datasheet view Opening a query in design view Adding fields to a query Sorting query results Modifying datasheet view Saving and closing queries 4 Forms introduced Working with form data Sorting records Filtering records Working in design and layout views Changing object attributes 5 Reports introduced Opening and viewing reports Viewing a report in design view Previewing and printing report data Creating reports with auto report Creating reports with the report wizard Changing field attributes 6 Creating a new database Creating database tables Creating table fields Selecting field data types 7 Table relationships Introducing relationships Establishing table relationships The one-to-many relationship type Establishing referential integrity 8 Creating queries Streamline query criteria using wildcards Creating summary queries Creating queries based on criteria Running date queries Formatting field properties Building queries from multiple tables Summing in queries 9 Creating forms Creating a new form Inserting form fields Working with the property sheet The command button wizard The command button wizard Programming without typing Creating forms with embedded sub forms Creating forms with the sub form wizard Creating forms with the form wizard 10 Creating reports What are report bands? Managing report controls Basing reports on multiple tables Basing reports on queries Sorting and grouping records

Learn the foundations of HTML and CSS and use them to create high-quality websites with the help of this beginner's friendly course. We will start with HTML fundamentals and build simple web pages in the first half of the course. In the second half, we will focus on CSS and learn to style websites beautifully.

Course Overview Learn how to identify primary challenges that face a company and be capable of overcoming them by taking this course on Strategic Business Planning Level 2. All organisations will face barriers and obstacles to achieving their goals. The key to success is knowing how to knock them down to size. With this training, you will be taught the skills you need to analyse information from various sources and formulate the best ways to use that knowledge in the market. This Business Planning tutorial provides an innovative and reliable way to absorb the competencies to become a strategic planner in an organisation. You will be shown how to match objectives with mission statements, deliver formal business strategies, and evaluate finances and resources. This all-encompassing learning experience focuses on the capabilities that form the foundations of good strategic planning. Enrol now and prepare for the future. This best selling Strategic Business Planning Level 2 has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Strategic Business Planning Level 2 is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Strategic Business Planning Level 2 is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Strategic Business Planning Level 2 is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Strategic Business Planning Level 2, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Strategic Business Planning Level 2 will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Strategic Business Planning Level 2 to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

If you work with adults and young people and wish to gain a knowledge of the principles and practice of assessment as well as the practical aspects of carrying out assessment, then Level 3 Certificate in Assessing Vocational Achievement is for you.

Ink drawing and painting course Japanese inspired style.