12799 Courses delivered Online

This workshop covers the five main types of payment for exports, from advance payment to open account. It includes the use of Bills of Exchange with and without documents

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.

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

Success = Value + People + Process With innovation happening more than ever, the new agile project economy requires more and more people across organisations to manage projects successfully, leading to many of us quietly slipping into the role of the unofficial project manager! The problem is very few people receive formal training on how to do it. Stakeholders, scope creep, limited training, and a lack of process all combine to raise the probability of project failure costing organisations time, money, and employee morale Is it any wonder 65% of all projects fail* each year! The good news is—unofficial project managers can build confidence to lead high-value projects and engage teams in a way that inspires them to volunteer their best efforts. Source: *Nieto-Rodriguez, A. (2021). “The Project Economy Has Arrived.” Harvard Business Review; Nov/Dec 21. Outcomes Project Management for the Unofficial Project Manager™ combines best practices from agile and waterfall project management to equip learners with the mindset, skillset, and toolset to engage and inspire team members. Success starts with the core agile principle of value—a project must deliver value to Noble! Once value is established, it is people who make projects successful through a consistent process. Project management isn’t just about managing logistics and hoping the project team is ready to play to win. The skills of “informal authority” are more important than ever before, so team members are inspired to contribute to project success! This course will help learners: Build strong informal authority that inspires project teams to consistently volunteer their best efforts. Utilise a consistent process to start and finish high-value projects on time and with quality. Influence and engage others to define a clear project scope, including clear deliverables and risk strategies. Model openness and agility to apply proactive change management and deliver high-value projects. Project Management Framework The Project Management Framework guides you through five distinct elements in the life of any project. Coupled with the foundational behaviours taught in the programme, this framework can help you deliver highly successful projects again and again. Who Should Attend? This programme is for anyone who finds themselves leading projects at work, regardless of whether or not their job title says, Project Manager! It is NOT a deep dive into project management processes, nor is it a qualification based programme. Whilst it would be helpful to either be involved in or to be leading a project, during the programme, this is clearly not essential. However, it is advisable that the participants have had some experience, whether as a project member or as the person who is leading the project (officially or not)! Project Management Institute (PMI) FranklinCovey is a member of the Project Management Institute (PMI) Authorised Training Partners (ATP) Programme and this course has been designed to satisfy the project management education requirement for PMI Certifications as well as Professional Development Education units (PDUs) needed by PMI credential holders.

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

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before The world runs on logistics. Every product you buy, every gift you send, relies on a complex network of warehouses and transportation. Want to be the mastermind behind the scenes? This Level 4 Diploma in Warehouse Operations is your key. Become a logistics ninja, equipped with the knowledge and skills to conquer any warehouse challenge. With a projected growth of 2 million jobs by 2030, there's never been a better time to advance your career in this dynamic industry. Our training program is designed to be a one-stop shop for your warehouse operations education. You'll gain a thorough understanding of core warehousing functions like receiving, picking, packing, and dispatching goods. Learn about essential import/export procedures, master forklift operation for safe and efficient stock movement, and prioritise safety in the workplace through dedicated training. This program also covers broader logistics concepts like transport and legal considerations, ensuring you have a well-rounded knowledge base. This Warehouse Operations at QLS Level 4 course is endorsed by The Quality Licence Scheme and accredited by CPD QS (with 120 CPD points) to make your skill development & career progression more accessible than ever! With a single payment, you will gain access to Warehouse Operations course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Diploma in Warehouse Operations at QLS Level 4 Bundle Contains 11 of Our Premium Courses for One Discounted Price: Course 01: Diploma in Warehouse Operations at QLS Level 4 Course 02: Import/Export Processing Course 03: Forklift Training Course 04: Warehouse Safety Training Course 05: Transport and Logistics Management Course 06: Anti Money Laundering (AML) Course 07: DSEAR Course 08: Workplace Health and Safety Course 09: Handyperson Course 10: Commercial Law Course 11: LOLER Training Enroll today and commence your journey into the riveting world of Warehouse Operations, opening up a realm of career opportunities that are both rewarding and crucial in today's global market. Learning Outcomes of Warehouse Operations Understand and implement effective warehouse operations procedures. Apply import/export regulations and navigate international trade processes. Operate forklifts safely and efficiently, adhering to industry standards. Implement health and safety protocols in accordance with DSEAR and workplace regulations. Demonstrate a strong understanding of commercial law principles. Apply Anti-Money Laundering (AML) practices in a warehouse environment. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of Warehouse Operations Get a free student ID card with Warehouse Operations Training program (£10 postal charge will be applicable for international delivery) The Warehouse Operations is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Warehouse Operations course materials The Warehouse Operations comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: Diploma in Warehouse Operations at QLS Level 4 Module 01: Introduction To Warehousing Module 02: Inventory And Stock Module 03: Order Picking Strategies Module 04: Warehouse Automation And Equipment Module 05: Warehouse Processes Module 06: Warehouse Communication Module 07: Warehouse Layout Module 08: Warehouse Safety Module 09: The Future Of Warehousing Course 02: Import/Export Processing Module 01: Introduction To Import Export Module 02: Organising The Import Export Operation Module 03: Products For Your Import Export Business Module 04: Target The Marketing And Find Your Customers Module 05: Searching, Marketing, And Distribution Module 06: Documentation And Supply Chain Management Module 07: Pricing, Payment And Shipping Procedure Module 08: Necessary Tools For Trading Course 03: Forklift Training Module 01: Introduction To Forklifts Module 02: Types Of Forklifts Module 03: Operating Forklifts Safely Module 04: Moving And Handling Loads Safely Module 05: Refuelling And Recharging Safely Module 06: Operational Risks And Hazards Module 07: Regulations And Safety Measures =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your QLS Endorsed Certificates and CPD Accredited Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £99) CPD 230 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 bundle. This bundle is ideal for: Individuals keen on gaining theoretical knowledge of warehouse operations. Professionals looking to broaden their understanding of warehouse safety regulations. Those interested in import/export processing within a warehouse environment. People who aim to learn about commercial law and its impact on transport and logistics management. Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Warehouse Manager: (£30,000 - £45,000) Import/Export Specialist: (£23,000 - £35,000) Forklift Operation Supervisor: (£20,000 - £28,000) Warehouse Safety Officer: (£25,000 - £40,000) Transport and Logistics Manager: (£35,000 - £60,000) Commercial Law Consultant in logistics: (£45,000 - £70,000) Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. Diploma in Warehouse Operations at QLS Level 4 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Learn to craft top-notch videos for your business using your mobile phone in this interactive workshop. Enhance marketing, visibility, and attract more clients through video. All-in-one workshop for diving into the world of business videos. #VideoCreation #BusinessBoost