13144 Courses in Coventry delivered Online

10 QLS Endorsed Courses for Supply Chain Manager | 10 QLS Hard Copy Certificates | Lifetime Access | Tutor Support

Level 4 Certification 13 credits This package entitles you to the relevant required courses to achieve a Level 4 Certification and is equal to 13 credits. After purchase, we will be in touch to discuss your module & assessment options. Please see individual module pages for more details, as well as applicable dates & times.   This course includes a choice of 1 of the following assessments: Creating an Export Strategy Creating an Import Strategy Creating an Import Procedure Manual Creating an Export Procedure Manual Creating a Supply Chain Sustainability Report Completing an Import CDS Customs Entry

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.

A complete course on Sqoop, Flume, and Hive: Ideal for achieving CCA175 and Hortonworks Spark Certification

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.

Day 1 of the Industrial Electrical Maintenance Part 1 consists of: Electricity at Work Regulations 1989, requirements and implementation Working safely, including the importance of isolation procedures and lock out systems Switches and Push Buttons, an explanation of the various types of switches and push buttons, the terminology and electrical symbols which are used in industry today, along with practical testing of functionality Relays and Contactors, principles of operation, purpose and uses Circuit design using BS electrical symbols and ladder diagrams, simple retaining circuits Construction of the above circuit, demonstrating the techniques of cable termination. Day 2 of the Industrial Electrical Maintenance Part 1 consists of: 3 phase induction motors, synchronous and asynchronous Description of the component parts of a 3 phase induction motor Demonstration of how a 3 phase rotating magnetic field is produced and how to reverse it Explanation of synchronous and asynchronous speed and slip Effect of the number of poles on motor speed Frame sizes Practical identification of various motors. Day 3 of the Industrial Electrical Maintenance Part 1 consists of: Principles of 3 phase induction motor control systems Overload protection principles of operation and use Design and operation of a DOL (direct on line) starter Construction of a DOL starter Inspection and testing procedure for the above starter Motor testing procedures. Day 4 of the Industrial Electrical Maintenance Part 1 consists of: DOL starter modifications Importance of updating documentation Design, construction and verification of reversing starter control and power circuits. Day 5 of the Industrial Electrical Maintenance Part 1 consists of: Star delta starters, principles of operation and uses Design, construction and verification of star delta starter control and power circuits.

The qualification is designed for learners who have responsibility for promoting health choices within the workplace, or who would like to get involved in championing workplace health. This level 2 course is delivered online across two sessions, both must be attended in order to achieve the qualification. Session 1: Introduction The importance of workplace health to employers and their employees The role of a Workplace Health Champion Factors affecting physical and mental health Session 2: Recap Key behaviour change principles The need to safeguard adults as a Workplace Health Champion Key elements involved in planning and preparing for a sport of physical activity session How to measure the success of a sport or physical activity session Tutor discussion / competence of qualification.

MySQL server admins training course description This MySQL Server administration course is designed for MySQL Server administrators who have a basic understanding of a MySQL database and a good working knowledge of SQL commands. The course provides an understanding of MySQL Architecture and practical experience in setting up, configuring and maintaining a MySQL server, backing up and recovering data and optimising query performance. This MySQL Server administration course also covers MySQL replication and its role in high availability and scalability. What will you learn Use MySQL Workbench. Install and configure a MySQL Server . Administer and tune a MySQL server. Configure log files and interpret error messages.. Secure the Server. Administer a replication topology. MySQL server admin training course details Who will benefit: Database administrators, Database developers and Technical consultants. Prerequisites: Introduction to MySQL Duration 5 days MySQL server admin training course contents Introduction to Oracle Application Express APEX concepts APEX main components Workspaces, database applications and websheet applications Creating a workspace The Workspace Administrator Upgrading APEX Logging into APEX Running an application SWL Workshop Use APEX to browse, create and modify objects Process ad hoc SQL statements Manage scripts in APEX Create, run and save SQL queries Build a database application Application components Create an application Create an application from a spreadsheet Create reports Create reports using wizards Edit report attributes Add links to reports Create a link to a printer-friendly version of a report Save and print reports in different formats Using files Uploading images Creating cascading stylesheet files Uploading static files Adding an Image as an application logo Adding a reference to a Javascript file Pages and regions Web form behaviour in APEX Create a form based on a table Create a form based on a procedure Create a form with a report Create a tabular form Format a form Locking in APEX forms Creating lists of values Overview of application express shared Components Dynamic and static lists of values Create a dynamic list of values Create a static list of values Use a list of values to control data in a report Create a cascading list of values Items and buttons Understand the different Types of items Create items Understand and edit item attributes Use Javascript with item Manipulate items in tabular forms Add dynamic items to a report Create and edit buttons Page Processing Page rendering and page processing Create computations Validate input data Process Data Understand application branching Create conditional branches Shared components Overview of application express navigation components Manage parent and standard tabs Create navigation bar entries Create and use lists and list items Manage breadcrumbs Create shortcuts Shared component subscription User interface defaults Display dynamic content Filter reports with dynamic queries Create charts with a wizard Format charts Create calendars Add links to calendars Create hierarchical trees State and debugging Understand session state Set a session state value Clear the session state Review the session state Review the messages in debug mode Enabling feedback Managing feedback and team development Themes and templates Switch to a different theme View existing templates Understand and manage templates Create a new template Add references to cascading stylesheet and Javascript files Dynamic actions and plug-in components Identify plug-in components and their types Plug In a component Create dynamic actions Use a plug-in in a dynamic action Building website applications Websheet applications and their components Create a websheet application Enable SQL and PL/SQL in a websheet application Add sections and pages to a websheet application Add links on a websheet page Add a data grid to a websheet application Create SQL reports ion websheet applications Add annotations to a websheet application Implementing security Authentication and authorization Provide an authentication scheme Create an authorization scheme using access control Enable and configure session state protection Deploy an appliction Define supporting objects Package an application Export an application Import an application Install supporting objects Administer Apex workspaces Manage workspaces and users Request a schema or storage Purge session state Monitor developer activity log Monitor workspace activity View activity reports Import a workspace Utility programs Import and export data Generate DDL statements View objects reports

Level 5 | Two Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

***24 Hour Limited Time Flash Sale*** Logistics, Supply Chain & Port Management (QLS) Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Immerse yourself in the dynamic world of Logistics, Supply Chain & Port Management with our comprehensive 8-course bundle! This package is loaded with three QLS-endorsed courses: Port Management, Logistic Management, and Supply Chain Management, all pivotal to understanding the modern logistics landscape. Elevate your knowledge further with five additional CPD QS accredited courses, each of them complementing and enhancing your logistics and management capabilities. These courses include: Transport Manager, Import/Export, Commercial Law, Logistic Management, and Warehouse Management Diploma. Experience the unique blend of theoretical knowledge, strategic insights, and core competencies that these courses offer. Each QLS-endorsed course comes with a hardcopy certificate, reinforcing your credentials and amplifying your professional appeal. Our meticulously designed CPD QS accredited courses provide a comprehensive understanding of pertinent aspects, empowering you to navigate through complex logistics, supply chain, and port management scenarios. Key Features of the Logistics, Supply Chain & Port Management (QLS) Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Logistics, Supply Chain & Port Management (QLS) bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Port Management QLS Course 02: Logistic Management QLS Course 03: Supply Chain Management 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Transport Manager Course 02: Import/Export Course 03: Commercial law Course 04: Logistic Management Course 05: Warehouse Management Diploma In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Logistics, Supply Chain & Port Management (QLS) courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Upon completion of this Logistics, Supply Chain & Port Management bundle, learners will be able to: Understand the principles and operations of Port, Logistic, and Supply Chain Management. Gain insights into the workings of Transport Management and its role in effective logistics. Grasp the complexities of Import/Export operations in global supply chains. Learn the fundamentals of Commercial Law and its application in logistics and supply chain. Obtain knowledge about Warehouse Management strategies and their impact on supply chain efficiency. Develop a holistic understanding of the logistical framework from a managerial perspective. Understand the benefits and challenges of logistics, supply chain, and port management in a global context. Each course within this bundle meticulously covers key areas, including Port Management, Logistic Management, and Supply Chain Management. Through these courses, you will understand the intricacies of port operations, logistical control, and efficient supply chain management strategies. Additionally, our CPD QS accredited courses provide an in-depth exploration of relevant areas such as Transport Management, Import/Export, Commercial Law, Logistic Management, and Warehouse Management. CPD 270 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring professionals seeking to step into logistics, supply chain, and port management fields. Current logistics and supply chain professionals looking to enhance their theoretical knowledge. Individuals interested in learning about global logistics and supply chain operations. Professionals looking to enhance their credentials with QLS-endorsed and CPD QS accredited courses. Career path Port Manager: £35,000-£70,000 Supply Chain Manager: £30,000-£60,000 Logistics Manager: £30,000-£60,000 Warehouse Manager: £25,000-£50,000 Import/Export Manager: £30,000-£60,000 Transport Manager: £30,000-£55,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included