35301 Design courses delivered Online

The Node JS: API Development with Swagger Interface Description Language course provides comprehensive training in creating APIs using Node.js and Swagger Interface Description Language. Participants will learn to develop robust APIs, design API specifications using Swagger, handle authentication, and implement API security. This course offers practical insights into building efficient APIs for web applications. Learning Outcomes: Understand the fundamentals of API development and its significance in web applications. Learn to set up and configure Node.js for building APIs. Explore the Swagger Interface Description Language for designing API specifications. Develop RESTful APIs using Node.js and Swagger for effective communication between applications. Implement authentication mechanisms and secure APIs using JWT (JSON Web Tokens). Master error handling and validation techniques for ensuring reliable API performance. Gain insights into API documentation and automatic generation using Swagger tools. Create interactive API documentation and test APIs using Swagger UI. Why buy this Node JS: API Development with Swagger Interface Description Language? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Node JS: API Development with Swagger Interface Description Language there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Web developers interested in enhancing their API development skills. Node.js enthusiasts looking to build efficient and secure APIs. Backend developers aiming to understand Swagger for API specification. Software engineers seeking to master API authentication and security. Professionals wanting to improve their web application development knowledge. Prerequisites This Node JS: API Development with Swagger Interface Description Language does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Node JS: API Development with Swagger Interface Description Language was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Node.js Developer: Specialize in building web applications using Node.js and APIs. Backend Developer: Design and implement APIs to support various web applications. API Developer: Develop, maintain, and optimize APIs for seamless data exchange. Web Application Developer: Create robust and efficient web applications using APIs. Software Engineer: Leverage API development skills for software product development. Course Curriculum Unit 01: Course Introduction Module 01: Introduction 00:01:00 Module 02: Goals & Prerequisites 00:03:00 Module 03: About the Instructor 00:01:00 Module 04: Open API Specification (OAS), Swagger & Node.js 00:09:00 Unit 02: Introduction to Swagger Module 01: Http and Swagger 00:09:00 Module 02: Swagger Tools 00:06:00 Module 03: Setup 00:06:00 Unit 03: Open API Specification (OAS) Module 01: Project Configuration 00:08:00 Module 02: Intro to Swagger Editor 00:06:00 Module 03: Project Explanation + GET Endpoint 00:13:00 Module 04: POST Endpoint 00:06:00 Module 05: PUT + DELETE Endpoint 00:08:00 Module 06: Challenge: Comments Endpoints 00:17:00 Unit 04: Node.js & Swagger Module 01: Get 00:11:00 Module 02: Post 00:08:00 Module 03: Put 00:07:00 Module 04: Delete 00:06:00 Module 05: Challenge: Add comment logic 00:18:00 Module 06: Deploy API in Heroku 00:06:00 Unit 05: Swagger Authorization with Json Web Tokens Module 01: Introduction to Json Web Tokens 00:07:00 Module 02: Authentication with Swagger and JWT 00:07:00 Unit 06: Final words Module 01: Thank you! 00:01:00 Assignment Assignment - Node JS: API Development with Swagger Interface Description Language 00:00:00

Step into the captivating world of persuasive communication with 'The Art of Persuasive Communication'. This course deciphers the delicate art of swaying opinions and moving audiences, offering a nuanced dive into tailoring messages for specific listeners and bolstering your credibility as a speaker. By delving into emotional appeal, rational logic, and potent storytelling, learners will unravel the intricacies of impactful communication. By the end, participants will be poised to captivate, convince, and convey with unparalleled efficacy. Learning Outcomes Differentiate between informative and persuasive messaging strategies. Adapt communication techniques to resonate with distinct audiences. Develop a robust understanding of ethos, pathos, and logos in crafting compelling narratives. Design persuasive messages that maintain ethical standards and bolster credibility. Implement a comprehensive approach to persuasive communication, from hooking listeners to presenting solutions. Why buy this The Art of Persuasive Communication course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the The Art of Persuasive Communication there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this The Art of Persuasive Communication course for? Individuals aiming to enhance their persuasive speaking capabilities. Marketers and salespeople wishing to strengthen their pitch and presentation skills. Leaders and managers seeking to influence team members or stakeholders. Teachers and trainers looking to make their content more engaging and impactful. Anyone desiring to become a more persuasive communicator in both professional and personal settings. Prerequisites This The Art of Persuasive Communication does not require you to have any prior qualifications or experience. You can just enrol and start learning.This The Art of Persuasive Communication was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Public Relations Specialist: £25,000 - £50,000 Marketing Manager: £30,000 - £60,000 Corporate Trainer: £30,000 - £55,000 Sales Manager: £28,000 - £58,000 Speechwriter: £30,000 - £60,000 Communication Consultant: £35,000 - £65,000 Course Curriculum Section 1: Introduction Welcome & Course Overview 00:03:00 Section 2: Lessons on Persuasive Communication Moving from an Informative to Persuasive Message 00:04:00 Tailoring Your Message to Specific Listeners 00:04:00 Increasing Your Identification with Listeners 00:06:00 Your Credibility as a Speaker (Ethos) 00:03:00 How to Communicating Your Competence 00:06:00 How to Communicate Your Character 00:03:00 How to Communicate Your Goodwill 00:04:00 Appealing to Listeners' Emotions (Pathos) 00:02:00 How to Tell Stories to Appeal to Listeners' Emotions 00:06:00 How to Use Creative Language to Add Impact 00:07:00 How to Use Your Emotions: Emotional Contagion 00:03:00 Appealing to Listeners' Minds (Logos) 00:02:00 Practical Ways to Appeal to Listeners' Minds 00:08:00 How to Design Your Overall Message for Maximum Persuasion 00:06:00 How to Hook Your Listeners 00:04:00 How to Show Listeners the Real Problem that Needs to be Fixed 00:04:00 How to Explain Your Solution Clearly 00:05:00 How to Help Listeners Visualize the Benefits of Your Solution 00:05:00 How to Explain the Potential Downside to Stay Ethical & Maintain Credibility 00:05:00 How to Make Your 'Ask' the Easy Way 00:07:00 Putting it All Into Practice (Application, Review, and Template Walk-Through) 00:07:00 Wrap Up & Next Steps 00:01:00 Assignment Assignment - The Art of Persuasive Communication 00:00:00

Description: Creative thinking and innovation are two critical components in our personal and professional lives. We do creativity on daily basis which helps us manage our daily chores. This Level 3 Diploma in Creative Thinking and Innovation will help you on how to recognize and hone your creative potential. In this course, you will learn to recognize the variation between creation and innovation, locate individual creativity, create their respective atmosphere, significance of creativity, problem solving methods and tools, people and group techniques and how to apply creative concept, etc. This course will ultimately help you to understand the importance of practicing to boost your creative and innovative skills. Learning Outcomes: How to recognise the variation between creativity and innovation How to locate their individual creativity Means to create their respective creative atmosphere The significance of creativity as well as innovation in business Problem solving methods and tools Personal and group techniques so as to assist produce creative concepts How to apply creative concepts Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Level 3 Diploma in Creative Thinking and Innovation is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Level 3 Diploma in Creative Thinking and Innovation is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Course Overview 00:15:00 What Is Creativity and Innovation? 00:15:00 Individual Creativity 00:30:00 Developing the Right Environment for Creativity 00:15:00 Creativity and Innovation in Business 00:15:00 Where Does Creativity Fit Into the Problem-Solving Process? 00:30:00 Defining the Problem 00:30:00 Creative Techniques 00:45:00 Encouraging Creativity In A Team 00:30:00 Putting It All Together 00:15:00 Mock Exam Mock Exam- Level 3 Diploma in Creative Thinking and Innovation 00:20:00 Final Exam Final Exam- Level 3 Diploma in Creative Thinking and Innovation 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Can you say that you are someone who treats gaming as part of your daily life? Do you consider having a career related to gaming? If so, then this course will help you achieve your dreams in game development! Description: You will first be introduced to the gaming basics and how it is used for game development. You will then be introduced to use different kinds of consoles needed for specific games. You will also discover games using your phone and internet. Then you would be knowledgeable on where to find free software that could be used for game development. Lastly, you will understand the accessories that deal with the gaming basics for development. Who is the course for: People who have an interest in becoming part of the game development industry Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Gaming Basics for Development Introduction 00:30:00 Understanding Consoles 01:00:00 Using Your Computer 01:00:00 Using Your Phone 01:00:00 Using the Internet 00:30:00 Where to Find Free Software 01:00:00 Understanding Accessories Dealing with Drugs 00:30:00 Wrapping Up 00:15:00 Mock Exam Mock Exam- Gaming Secrets 00:20:00 Final Exam Final Exam- Gaming Secrets 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Learn how to use culture for enhancing the employee performance with the Lean Leadership and Change Management Diploma course. The course is designed to teach you Lean leadership and change management. A lean leader will change the way your thinking and the way you lead your organisation. Lean leadership is the approach that teaches you how to improve the overall performance of your organisation by bringing change in its culture. You will learn about the lean culture and lean leadership. The course illustrates the history of lean, the essential principles and practices, and the fundamental functions of the lean leader. There are two ways of lean implementation. You can change and redesign the whole process, or you may acquire the habits of problem-solving and continuous improvement. The course covers these two processes and helps you to choose the right methods for you. The purpose of the course is to prepare you for applying the lean leadership approach of lean culture in your organisation. Who is this Course for? Lean Leadership and Change Management Diploma is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Assessment: This course does not involve any MCQ exams. Students need to answer 3 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work. Course Curriculum Introduction Why 00:04:00 What 00:04:00 Curriculum 00:05:00 How 00:04:00 What is Culture 00:06:00 Culture Drivers 00:08:00 Resources 00:05:00 Activity 1 00:03:00 The House of Lean House of Lean 00:03:00 Evolution 00:04:00 Shingo 00:09:00 Honda 00:09:00 Activity 2 00:02:00 Lean Culture Principles & Practices JIT 00:07:00 Kanban 00:08:00 Continuous Improvement and Leadership 00:04:00 Waste Intro 00:10:00 Forms of Waste 1 00:06:00 Management Waste 00:07:00 Activity3 00:02:00 Scientific Method 00:07:00 Gemba Walk 00:06:00 Heijunka 00:05:00 Visual Display 00:07:00 Activity 4 00:02:00 Kaizen 00:06:00 The Job of the Lean Leader - To Challenge and To Serve Lean Leadership Intro 00:07:00 The Mind of the Lean Leader 00:04:00 The Mind of the Lean Leader - Transitions 00:07:00 Lean Leadership1. External Challenge 00:05:00 Lean Leadership 2. Internal Challenge 00:06:00 Activity 5 00:02:00 Lead WSA 00:02:00 Be the Model 00:03:00 Coach Others 00:07:00 Motivation 00:04:00 Reinforce Your Strategy 00:04:00 Activity 6 00:01:00 Intrinsic Reinforcement 00:08:00 Getting to Lean - Designing the System for a New Culture Paths to Lean 00:05:00 How You Change 00:03:00 Design Thinking 00:08:00 Design Process 00:08:00 Capability Analysis 00:05:00 Charter 00:05:00 Activity 7 00:02:00 Design Team 00:06:00 Discovery 00:06:00 Discover the Process 00:07:00 Dream 00:07:00 Design technical 00:07:00 Design Structure 00:08:00 Social Design 00:06:00 Activity 8 00:03:00 VON Case Study 00:10:00 WSA Summary 00:04:00 Activity 9 00:02:00 The Habits of Continuous Improvement - The Team Kata Why Teams 00:06:00 Types of Teams 00:06:00 Team Charter 00:05:00 Team Maturity 00:05:00 Team Roles and Responsibilities 00:05:00 Team Agenda 00:05:00 Activity 10 00:02:00 Facilitation 1 00:06:00 Facilitation 2 00:04:00 Team Scoreboard 00:07:00 Activity 11 00:01:00 Map Team's Work 00:03:00 Attitudes 00:05:00 Five Whys 00:03:00 PDSA 1 00:04:00 PDSA 2 00:04:00 PDCA example 00:01:00 Activity 12 00:01:00 A3 00:05:00 Standard Work 00:05:00 Leader Standard Work 00:04:00 Activity 13 00:02:00 Summary 00:03:00 Resource Materials Resource Materials : Lean Leadership and Change Management Diploma 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Administering Microsoft SQL Server course description This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on how to use SQL Server 2016 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server 2016, but also the important capabilities across the SQL Server data platform. What will you learn Describe core database administration tasks and tools. Configure SQL Server databases and storage. Import and export data. Monitor SQL Server. Trace SQL Server activity. Manage SQL Server security. Audit data access and encrypt data. Administering Microsoft SQL Server course details Who will benefit: Individuals who work with SQL Server databases. Individuals who develop applications that deliver content from SQL Server databases. Prerequisites: Introduction to data communications & networking. Duration 3 days Administering Microsoft SQL Server course contents Introduction to SQL Server administration Database administration, SQL Server platform, database management tools and techniques. Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server. Working with databases and storage Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Hands on Configuring tempdb storage, creating databases, attaching a database. Importing and exporting data Transferring data, importing and exporting table data, copying or moving a database. Hands on import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function. Monitoring SQL Server 2014 Monitoring SQL Server, dynamic management views and functions, performance monitor. Hands on Baseline metrics, monitoring a workload. Tracing SQL Server activity Tracing workload activity, using traces. Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations. Managing SQL Server security SQL Server security, server-level security, database-level principals, database permissions. Hands on SQL Server security. Testing access.

Oracle SQL training course description The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create SQL statements to query database tables. Use standard aggregate functions and related SELECT statement clauses. Join Tables. Use basic subqueries and the set operators. Use numeric, character and date functions. Use conversion and other miscellaneous functions. Use SQL parameters. Use complex subqueries. Create and alter tables and views. Insert, update and delete rows in database tables. Manage sequences and synonyms. Oracle SQL training course details Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. Prerequisites: None. Duration 3 days Oracle SQL training course contents Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.

Definitive Segment Routing course description This Segment Routing (SR) training course is a comprehensive program designed to equip network professionals with the knowledge and skills needed to implement and manage SR in modern networking environments. Segment Routing is a cutting-edge network architecture that enhances network flexibility, scalability, and efficiency. This course offers in-depth coverage of SR principles, protocols, and practical implementation techniques. Hands on sessions are used to reinforce the theory rather than teach specific manufacturer equipment. What will you learn Explain packet paths when implementing SLB. Explain how Segment Routing works. Explain the relationship between SR and MPLS. Use SR for Traffic Engineering. Troubleshoot Segment Routing. Implement TI-LFA using Segment Routing Definitive Segment Routing course details Who will benefit: This course is ideal for network engineers, architects, and administrators who want to stay up-to-date with the latest networking technologies and enhance their expertise in Segment Routing. Prerequisites: Concise MPLS for engineers Duration 3 days Definitive Segment Routing course contents Introduction to Segment Routing (SR) What is SR? Source based routing, SPRING, history, segments, why SR? SR benefits.SR usage: Traffic Engineering, Shortest path, local protection. Relationship between SR and MPLS, SRv6. Hands on Investigating the base network. Segment Routing architecture SR domains, SR paths, SR segments. Segment types. Segment IDs, combining segments, IGP extensions, control plane components. Hands on Configuring SR, exploring how SR works, Segment Routing protocols SR-MPLS. MPLS label stack operations. Segment Routing Global Block (SRGB). SRLB. IS-IS and OSPF extensions for SR. Prefix segments, adjacency segments. SRGB/IGP interactions. Multidomain SR policies. SPF, Strict SPF. Hands on Analysing IGP SR extension operation. Investigating the SRGB. Segment Routing Traffic Engineering RSVP-TE versus SR-TE. SR policies. Anycast and binding SIDs. SR flexible algorithm flex-algo, Performance measurement delay. Hands on Optimising network paths for various applications. SR integration with 'older' technologies MPLS and LDP integration with SR. Hands on Integration. Topology Independent Loop Free Alternative Classic LFA and IP/MPLS protection mechanisms. TI-LFA protection options. Hands on TI-LFA operation with SR and LDP traffic. Scenarios SDN. Managing SR with SR controllers. Analyse, optimise, automate. Network slicing. BGP peering segments Path Computation Elements, BGP Link State. BGP prefix segments, BGP peer segments. Egress peer engineering. SR enabled VPNs. Hands onBGP segment routing. Troubleshooting Segment Routing IP toolkit: ping and traceroute. MPLS toolkit: MPLS ping, MPLS echo request/reply, MPLS ping, MPLS traceroute and path discovery. Router show commands. Hands on Used throughout the course during exercises. SRv6 Note this is an optional extra day. See our one day SRv6 course for details. IPv6 headers review, routing headers, IPv6 segment, SRv6 segment Identifiers. IPv6 Segment Routing Header. SRH procedures. Hands on Configuring SRv6, Analysing SRv6 operation.

MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

About this Virtual Instructor Led Training (VILT) Preventive and Predictive maintenance are not new concepts. Both have been used across industry all over the world and when done properly, can yield impressive results (cost reductions of 20% or greater and a leap forward in equipment reliability and performance are very achievable). However, for every company using these concepts effectively, there are many others who are not. This 8 half-day Virtual Instructor Led Training (VILT) course has been derived from the Plant Performance Improvement Road Map developed by practitioners that guarantee the reliability of your operations. The VILT training focuses on how to improve profitability of any business by identifying the right maintenance strategy for any equipment. The aim of the VILT training is to help practitioners run programmes that will deliver real benefits as fast as possible with minimum zero wasted effort. The VILT training will also cover the core principles of Reliability Centred Maintenance, Total Productive Maintenance and Six Sigma and the increasingly important role of operations in achieving optimised asset performance. This is a certified course with the option of sitting for a short exam on the final day of the course to give participants the opportunity to gain a Certificate from petroEDGE and the Carcharodon Maintenance Academy. Training Objectives Master the critical skills by acquiring the following: An understanding of how maintenance can add profit The ability to develop improvement programmes that deliver maximum benefit in the shortest time A fundamental understanding of the principles of Preventive, Predictive and other maintenance types A practical understanding of the latest methods of solving problems at root cause level An appreciation of maintenance methodologies such as Reliability Centred Maintenance Strategies for ensuring your company gets value for money from your Contractors How to use the Maintenance Model of Excellence and Plant Performance Improvement Road Map Target Audience This VILT course has been designed for maintenance managers and engineers, reliability professionals, planners, project engineers, operations team members, and functional specialists. Training Methods The VILT course will be delivered online in 8 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 8 half-day sessions, 4 hours per session (32 hours in total). Trainer Your expert course leader is an award-winning consultant and trainer with 30 years' experience in maintenance and reliability improvement. He has worked across five continents, in a wide variety of environments from the world's largest oil refinery to a small drinks production line. He has 10 years of maintenance management experience in the process industry, so he brings a very practical approach to training. He moved into consulting with ABB Eutech as their global maintenance specialist where he led maintenance and reliability best practice panels, delivered a wide range of maintenance improvement projects and trained other consultants. He is a fully qualified CMRP professional, an approved SMRP* Proctor, authorised to conduct CMRP exams and a globally respected maintenance consultant and best practice trainer. He founded his consultancy and training business in 2002 to focus on maintenance and reliability improvement. As part of this, he developed a range of maintenance 'models of excellence' with inputs from authors, international lecturers and some of the world's leading consultants and operators. His work has been recognised as being at the leading edge of industry best practice, winning independent awards such as the UK Chemical Industries Association 'Excellence in Engineering' award. He remains close to the industry as a respected specialist helping operating companies to achieve changes in performance. This ongoing field work enables him to continue to refine and extend best practice and the learning from this is continually fed into his training. His unique experience of facilitating two major turnarounds when the Coronavirus escalated into lockdown have given him a unique insight into how events of this type can disrupt maintenance. Moreover, his involvement in developing management processes and leading a Coronavirus response on a major industrial asset means he can talk with direct experience about how to cope and innovate in this global pandemic. *SMRP refers to Society of Maintenance and Reliability Professionals. PetroEdge is not affiliated with SMRP 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