1099 Courses

This module aims to develop knowledge and understanding as to how an organisation develops an international trade strategy. It includes establishing export goals, undertaking research into potential markets, developing an international pricing strategy, investigating shipping and logistics, marketing and promotion, documentation, distribution and review and monitoring.

Total NetFlow training course description A comprehensive hands on course covering NetFlow. The course starts with the basics of flows moving swiftly onto configuring NetFlow and studying the information it provides. What will you learn Describe NetFlow. Configure generators and collectors. Recognise how NetFlow can be used. Describe the issues in using NetFlow. Compare NetFlow with SNMP, RMON and sflow. Total NetFlow training course details Who will benefit: Technical staff working with NetFlow. Prerequisites: TCP/IP Foundation Duration 2 days Total NetFlow for engineers What is NetFlow? Flows. Where to monitor traffic. Hands on Wireshark flow analysis. Getting started with NetFlow NetFlow configuration. Hands on Accessing NetFlow data using the CLI. NetFlow architecture Generators and collectors. When flows are exported. NetFlow reporting products. SolarWinds. Hands on Collector software. NetFlow features and benefits Real time segment statistics, real time top talkers, traffic matrices. Hands on Traffic analysis with NetFlow. NetFlow issues NetFlow impact, agent resources, server resources, comparing NetFlow with SNMP, RMON and sflow. Hands on Advanced NetFlow configuration. Export formats Flow aging timers, NetFlow versions, export formats, templates, IPFIX. Hands on NetFlow packet analysis. NetFlow MIBs The NetFlow MIB, configuration, retrieving NetFlow statistics. Hands on Integrating NetFlow with SNMP.

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.

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.

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

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. Overview Navigate the Report Builder Environment. - Create table reports. - Format reports. - Create basic and complex expressions. - Group report data. - Create matrix reports. - Sort and filter data. - Summarize data with charts. - Print and export reports. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. Prerequisites ?Familiarity with Windows. ?Creating and navigating folders. ?Opening programs. ?Manipulating windows. ?Copying and pasting objects. ?Formatting text. ?Saving files. 1 - Exploring the Report Builder Environment Introducing the Report Builder Environment Working with Existing Reports Lab 1: Exploring the Report Builder Application 2 - Adding Data to Table Reports Create Report Data Sources Create Report Datasets Work with the Tablix Data Region Create a Table Report Lab 1: Creating Table Reports 3 - Formatting Data and Creating Expressions in Reports Formatting Reports Sorting and Filtering Report Data Adding Data to a Dataset Creating Simple Expressions Creating Complex Expressions Lab 1: Formatting Reports 4 - Grouping Report Data Group Data in Reports Group Data Using an Expression Creating Subgroups and Group Aggregates Lab 1: Creating Reports with Groups and Aggregates 5 - Matrix Reports Creating and Modifying Matrix Data Regions Creating and Modifying Column Groups Lab 1: Creating Matrix Reports 6 - Charts Create and Modify Chart Wizard Reports Add Charts to Existing Reports Modify Charts in Reports Lab 1: Creating Charts and Chart Reports 7 - Printing and Exporting Reports Print Features and Print Options Export Reports Lab 1: Printing and Exporting Reports

***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.

10 QLS Endorsed Courses for Logistic Manager | 10 Endorsed Certificates Included | Life Time Access

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins