35949 Design courses in Lowestoft delivered Online

This course aims to provide a comprehensive understanding of decision-making processes and dynamics at the managerial level. The course aims to equip learners with knowledge and skills to apply various decision-making models, including decision support systems (DSS) and system modelling, to support effective organisational decision-making. Additionally, the course will enable learners to identify and prepare for trends in decision support and business intelligence and understand how management information systems can aid in decision-making. After the successful completion of the course, you will be able to learn about the following, Understand Decision-Making dynamics and process Types of decision-making, especially at the managerial level. Understanding and applying the decision-making models, including the decision support system (DSS) and its components. Analysing the Information Requirements of Key Decision-making Groups in a Firm. Identifying and preparing for trends in Decision Support and Business Intelligence. Understanding System Modelling and its Types. Learn about how Management Information Systems help in Decision Making. This course covers the fundamentals of decision-making processes and dynamics, including the types of decision-making at the managerial level. Learners will explore various decision-making models and their applications, focusing on decision support systems (DSS) and system modelling. They will gain an understanding of the components of DSS and their role in supporting effective decision-making. This course covers the fundamentals of decision-making processes and dynamics, including the types of decision-making at the managerial level. Learners will explore various decision-making models and their applications, with a particular focus on decision support systems (DSS) and system modeling. They will gain an understanding of the components of DSS and their role in supporting effective decision-making. VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Understanding the Role of MIS in Decision Making, System Design, and Modeling Self-paced pre-recorded learning content on this topic. Understanding the Role of MIS in Decision Making and Modeling Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the learner's knowledge in the field. This certificate is for everyone eager to know more and get updated on current ideas in their respective field. We recommend this certificate for the following audience. Managers at all levels Business analysts Decision support specialists IT professionals. Consultants & Project managers Entrepreneurs and business owners Average Completion Time 2 Weeks Accreditation 3 CPD Hours Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

*** Year-End Deals Are Here!*** Are you looking to improve your current abilities or make a career move? Our unique Recruitment Business course might help you get there! Expand your expertise with high-quality training - study the Recruitment Business course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the Recruitment Business online training course. The Recruitment Business course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Recruitment Business course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Recruitment Business training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Recruitment Business course: Module 01: Introduction to Business Management What Is Business Management? Business Management in Industry The Roles of a Business Owner Characteristics of Management Functions of Management Understanding Organisational Structure The Impact of Organisation Design Module 02: Business Development and Succession Planning Definition of Business Development Laying the Groundwork to Develop a Business SWOT Analysis Process of Business Development Succession Planning Understanding the value of Succession Planning Elements of a Succession Plan Development of a Succession Plan Module 03: Business Process Management Fundamentals of Business Process Improvement The Vision Phase The Design Phase The Modelling Phase The Execution Phase The Monitoring Phase The Optimising Phase Module 04: Introduction to Recruitment: Importance and Implications What is Recruitment? Importance of hiring the right employees Negative effects of not being able to find the right candidates Function of recruitment consultants Module 05: An Overview of the Recruitment Industry Brief Overview of the Inception of the Recruitment Industry The UK Recruitment Industry Industry Suppliers How to become a successful Recruiter Module 06: The UK Recruitment Legislation Requirement of license Recruitment agency regulations Other vital laws Reforms and Laws that have Shaped the Face of the Recruitment Industry Objectives of implementing a code of ethics Recruitment Industry Bodies Recruitment and Employment Confederation (REC) and the Associate of Professional Staffing Companies (APSCo) Principles of the REC Code of Practice The Association of Professional Staffing Companies (APSCo) Objectives of APSCo Membership guideline for APSCo Module 07: Sales and Selling in the Recruitment Industry Why recruiters need sales techniques How do sales and selling concepts work for the recruitment industry? Selling techniques, ideas, and tips What helps distinguish your recruitment consultancy from others? Module 08: The Recruitment Process Process Planning Identifying Vacancy Job Analysis Job Description Job Specification Job Evaluation Strategy Development Searching Internal Sources External Sources Screening Reviewing of Resumes and Cover Letters Conducting Telephonic or Video Interview Identifying the top candidates Evaluation and Control What is the need for a recruitment process and what it involves The recruitment cycles Candidate Management Client Acquisition Client Strategy Candidate Attraction Module 09: Key Performance Indicators for the Recruitment Industry Key Performance Indicator Why Key Performance Indicators are Important to Success Developing Key Performance Indicators Activity Levels Manage your time Four key rules Divide up your day Working nearest the placement Running a search Characteristics of High-Quality Key Performance Indicators Assessment Process Once you have completed all the modules in the Recruitment Business course, you can assess your skills and knowledge with an optional assignment. Certificate of Completion The learners have to complete the assessment of this Recruitment Business course to achieve the CPDQS accredited certificate. Digital Certificate: £10 Hard Copy Certificate: £29 (Inside UK) Hard Copy Certificate: £39 (for international students) CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Everyone wants to be an expert in his/her desired skill or profession. But, some people can't achieve their target due to lack of proper skill based training. The Microsoft Word 2016 Complete Course - Beginner, Intermediate & Advanced will be ideal training for you to improve your knowledge and skills about Microsoft Word. This Microsoft Word Course will teach you from scratch to become a pro in Microsoft Word 2016. Microsoft Word 2016 is Microsoft's word-processing program that allows you to format and design your written documents as well as view and edit PDF documents. Through this course, you will learn the basic concepts of the program, including paragraph formatting, managing lists, creating tables, Thesaurus, spell check, comments, margins, and printing. Apart from these, learn how to use the editing tools, place and size images, wrap text around images, use borders and effects, and more.  This word processing training will help you to learn the advanced features, such as using footnotes and endnotes, inserting bibliographies and indexes, using comments, and many more. Enrol now to start boosting your Microsoft Word 2016 skills! Key topics to be covered Getting Started with Word Formatting Tables and Charts Controlling the Flow of a Document Image Manipulation Custom Graphic Elements References and Links Securing a Document Manage Content Macros Learning Outcomes The Microsoft Word 2016 Complete Course - Beginner, Intermediate & Advanced online course will provide you the following outcomes: Know how to become an expert in workbooks - Microsoft Word 2016. You will learn about the basics of text and paragraph formatting, adding document references and links Learn how to work more efficiently with our Microsoft Word 2016 tutorial. Know how to manage lists, add tables, insert graphic objects, control page appearance, and prepare a document to publish. Know how to customise styles and themes, tables and charts, insert content using quick parts, and use templates to automate document formatting. Gain a comprehensive understanding of simplifying and managing long documents, using mail merge to create letters, envelopes, and labels. Learn how to collaborate on documents, use forms to manage content, and automate repetitive tasks with macros. Who is this course for? Anyone who wants to improve their Microsoft Word skills Anyone who wants to learn word processing Students Those who have a keen career interest in the corporate industry Why Choose this Course Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design Microsoft Word 2016 Complete Course - Beginner , Intermediate & Advanced is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of- Video lessons Online study supplies Mock tests Multiple-choice evaluation Career path On successful completion of the Microsoft Word 2016 Complete Course - Beginner , Intermediate & Advanced course, learners will have both practical and theoretical knowledge of Word processing and documentation skills.  This Microsoft Word Course will turn you into a professional Word document expert. Through this word processing online course, you will be able to apply your new skills in any office role in the corporate world. Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate. A print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. What are you waiting for? Enrol in the Professional Childcare and Nannying Courses now!

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.

🚀 Unlock Your Presentation Potential with PowerPoint Mastery Basics! 🚀 Are your presentations lacking that wow factor? Do you find yourself struggling to engage your audience and convey your message effectively? It's time to transform your presentations into captivating masterpieces with our groundbreaking course - PowerPoint Mastery Basics!   🌟 Why PowerPoint Mastery Basics? ✅ Unleash Your Creativity: Discover the hidden features of PowerPoint that will turn your slides from dull to dynamic. Learn how to design visually stunning presentations that captivate your audience's attention. ✅ Boost Your Efficiency: Say goodbye to hours spent tweaking your slides. Master time-saving techniques and shortcuts that will streamline your workflow, allowing you to create impactful presentations in record time. ✅ Command Attention: Learn the art of storytelling through slides. Understand how to structure your content for maximum impact, keeping your audience engaged from start to finish. ✅ Professionalism Redefined: Elevate your presentations to professional standards. Discover design principles, formatting tricks, and visual hierarchy techniques that will make your slides stand out in any professional setting. ✅ Interactive Learning: Our course is not just about theory; it's a hands-on experience. Dive into practical exercises and real-world examples that reinforce your learning and ensure immediate application of newfound skills. ✅ Lifetime Access and Updates: Get unlimited access to the course content and benefit from future updates. Stay ahead of the curve as PowerPoint evolves, and continue to refine your skills over time.   🌐 Who Can Benefit? 👩‍💼 Business Professionals: Impress your clients and colleagues with polished presentations that convey your ideas persuasively. 👨‍🏫 Educators: Transform your classroom experience with engaging presentations that enhance learning and retention. 👩‍💻 Entrepreneurs: Pitch your ideas with confidence and leave a lasting impression on potential investors and partners. 👨‍🎓 Students: Stand out in your academic presentations with visually compelling slides that showcase your understanding of the subject matter.   👉 Don't miss out on this opportunity to revolutionize your presentations and leave a lasting impact! Join PowerPoint Mastery Basics today! Course Curriculum Basic Overview 02:46 Using The Right Mouse Button 02:49 The Home Menu - Clipboard Sub Menu - Editing Sub Menu 02:56 The Home Menu - Slides Sub Menu 03:24 The Home Menu - Font and Paragraph Sub Menus 03:19 The Home Menu - Drawing Sub Menu - Dictation Sub Menu 06:14 The Home Menu - Importing from Keynote and Google Docs 00:00 The Insert Menu - 3D Models and Add Ins 00:00 The Insert Menu - The Images Sub Menu 00:00 The Insert Menu - Media Sub Menu 00:00 The Design Menu 00:00 The Transitions Menu 00:00 The Animations Menu - Part One 00:00 The Animations Menu - Part Two 00:00 The Slide Show Menu 00:00 The Presenter View 00:00 The Review Menu 00:00 Sharing and Collaboration 00:00 The View Menu 00:00 View and Outline Command Example 00:00 Advanced Overview and Workspace 00:00 The File Menu - Export Command 00:00 The File Menu - Options Sub Menu 00:00 Adding Sections 00:00 Using Smart Art 00:00 Hyperlinks 00:00 Adding 3D Images 00:00 Using the Actions Button 00:00 Using the Zoom Feature 00:00 Using the Screen Recorder 00:00 Using the Picture Background 00:00 Slide Master - Picture Background 00:00 Slide Master - Part 2 00:00 Using the Slide Sorter View 00:00 Using the Presenter View (1) 00:00 Using the Presenter View (2) 00:00 Present Your Presentation Online 00:00 Insert Menu - Add Ins (1) 00:00 Insert Menu - Add Ins (2) 00:00 Conclusion and Collaboration 00:00

Get ready for an exceptional online learning experience with the Electrician, Electrical Engineering, HVAC, Circuit Analysis bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The Electrician, Electrical Engineering, HVAC, Circuit Analysis is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the Electrician & Electrical Engineering package has something for everyone. As part of the Electrician, Electrical Engineering, HVAC, Circuit Analysis package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the Electrician & Electrical Engineering bundle to confidently navigate your career path or personal development journey. Enrol today and start your career growth! This Bundle Comprises the Following CPD Accredited Courses: Course 01: Electrician Complete Training Course 02: Electrical Engineering for Electrical Substations Course 03: Electrical Machines for Electrical Engineering Course 04: Certificate in HVAC Fundamentals Course 05: High Voltage Generation for Electrical Engineering Course 06: Electric Circuits for Electrical Engineering Course 07: Electrical Engineering DC Circuit Analysis Course 08: Electronic & Electrical Devices Maintenance & Troubleshooting Course 09: Energy Engineer Course Course 10: Light Current Systems for Electrical Engineering Course 11: Distribution Station & Feeder Protection Course 12: Symmetrical Components for Three-Phase Power Analysis Course 13: Data Center Training Essentials: Power & Electrical Course 14: MATLAB Simulink for Electrical Power Engineering Course 15: Working at Height Level 2 Course 16: Career Development Plan Fundamentals Course 17: CV Writing and Job Searching Course 18: Learn to Level Up Your Leadership Course 19: Networking Skills for Personal Success Course 20: Ace Your Presentations: Public Speaking Masterclass Learning Outcome: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the Electrician & Electrical Engineering Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the Electrician & Electrical Engineering. Build a strong knowledge base in your chosen course via the Electrician & Electrical Engineering. Benefit from the flexibility and convenience of online learning. With the Electrician & Electrical Engineering package, validate your learning with a CPD certificate. Each course in this bundle holds a prestigious CPD accreditation, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This bundle promises not just education but an evolving learning experience. Engage with this extraordinary collection, and prepare to enrich your personal and professional development. Embrace the future of learning with the Electrician, Electrical Engineering, HVAC, Circuit Analysis, a rich anthology of 15 diverse courses. Each course in the Electrician & Electrical Engineering bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This Electrician, Electrical Engineering, HVAC, Circuit Analysis bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the Electrician, Electrical Engineering, HVAC, Circuit Analysis bundle offers you the flexibility and convenience to learn at your own pace. Make the Electrician & Electrical Engineering package your trusted companion in your lifelong learning journey. CPD 215 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Electrician, Electrical Engineering, HVAC, Circuit Analysis bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements Without any formal requirements, you can delightfully enrol in this Electrician, Electrical Engineering, HVAC, Circuit Analysis bundle. Career path This Electrician, Electrical Engineering, HVAC, Circuit Analysis bundle will help you to pursue: Electrical Technician HVAC Technician Electrical Engineer Energy Engineer Data Center Specialist Power Systems Engineer Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

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