209 Educators providing Courses delivered Online

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing. Overview Create sophisticated SSIS packages for extracting, transforming, and loading data Use containers to efficiently control repetitive tasks and transactions Configure packages to dynamically adapt to environment changes Use Data Quality Services to cleanse data Successfully troubleshoot packages Create and Manage the SSIS Catalog Deploy, configure, and schedule packages Secure the SSIS Catalog SQL Server Integration Services is the Community Courseware version of 20767CC Implementing a SQL Data Warehouse. This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server. This course is similar to the retired Course 20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation. Prerequisites Working knowledge of T-SQL and SQL Server Agent jobs is helpful, but not required. Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of relational databases. Some experience with database design. 1 - SSIS Overview Import/Export Wizard Exporting Data with the Wizard Common Import Concerns Quality Checking Imported/Exported Data 2 - Working with Solutions and Projects Working with SQL Server Data Tools Understanding Solutions and Projects Working with the Visual Studio Interface 3 - Basic Control Flow Working with Tasks Understanding Precedence Constraints Annotating Packages Grouping Tasks Package and Task Properties Connection Managers Favorite Tasks 4 - Common Tasks Analysis Services Processing Data Profiling Task Execute Package Task Execute Process Task Expression Task File System Task FTP Task Hadoop Task Script Task Introduction Send Mail Task Web Service Task XML Task 5 - Data Flow Sources and Destinations The Data Flow Task The Data Flow SSIS Toolbox Working with Data Sources SSIS Data Sources Working with Data Destinations SSIS Data Destinations 6 - Data Flow Transformations Transformations Configuring Transformations 7 - Making Packages Dynamic Features for Making Packages Dynamic Package Parameters Project Parameters Variables SQL Parameters Expressions in Tasks Expressions in Connection Managers After Deployment How It All Fits Together 8 - Containers Sequence Containers For Loop Containers Foreach Loop Containers 9 - Troubleshooting and Package Reliability Understanding MaximumErrorCount Breakpoints Redirecting Error Rows Logging Event Handlers Using Checkpoints Transactions 10 - Deploying to the SSIS Catalog The SSIS Catalog Deploying Projects Working with Environments Executing Packages in SSMS Executing Packages from the Command Line Deployment Model Differences 11 - Installing and Administering SSIS Installing SSIS Upgrading SSIS Managing the SSIS Catalog Viewing Built-in SSIS Reports Managing SSIS Logging and Operation Histories Automating Package Execution 12 - Securing the SSIS Catalog Principals Securables Grantable Permissions Granting Permissions Configuring Proxy Accounts Additional course details: Nexus Humans 55321 SQL Server Integration Services training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the 55321 SQL Server Integration Services course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

The 'Warehouse' course provides a comprehensive understanding of warehouse management, covering essential topics such as functions, benefits, types of warehousing, and the role of technology in modern warehouse operations. Participants will delve into supply chain management concepts, warehouse safety, inventory control, and the pivotal role of human resource management. With a focus on improving efficiency and reducing costs, this course equips learners with the knowledge and skills needed to excel in warehouse management and contribute to the success of supply chain logistics. Learning Outcomes: Grasp the fundamental principles and benefits of warehouse management. Explore various types of warehousing and their functions in the supply chain. Understand the core functions of a warehouse management system. Identify challenges in warehouse management and strategies for overcoming them. Gain insights into technology's impact on warehouse operations. Comprehend supply chain management concepts and their application in warehouses. Learn about essential inventory management techniques and control flow. Enhance warehouse safety protocols and cost management strategies. Why buy this Warehouse? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Warehouse there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Warehouse does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Individuals seeking a career in logistics, warehouse management, or supply chain. Warehouse managers, supervisors, and personnel aiming to enhance their skills. Entrepreneurs or business owners involved in inventory and logistics management. Professionals interested in improving warehouse efficiency and reducing costs. Prerequisites This Warehouse was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Warehouse Manager - Median salary of $50,000 - $80,000 per year. Logistics Coordinator - Median salary of $40,000 - $60,000 per year. Inventory Control Specialist - Median salary of $40,000 - $60,000 per year. Supply Chain Analyst - Median salary of $50,000 - $70,000 per year. Operations Manager (with warehouse focus) - Median salary of $60,000 - $100,000 per year. Course Curriculum Warehouse Fundamentals of Warehouse Management 00:30:00 Warehousing: Function, Benefits and Types of Warehousing 00:30:00 Core Functions Of A Warehouse Management System 00:15:00 Challenges Of Warehouse Management 00:30:00 Technology In The Warehouse 00:45:00 Supply Chain Management Concepts 00:30:00 Warehouse Management Technologies to Adopt 00:15:00 Order Picking in the Warehouse 00:18:00 Managing Warehouse Inventory 00:15:00 Organize the Storage of Inventory in a Warehouse 00:15:00 Inventory Management Techniques 00:30:00 Inventory Control Flow of Processing 01:00:00 Logistics and Supply Chain In A Warehouse 00:30:00 Inventory Classification In The Warehouse 00:15:00 The Role Of Human Resource management In A Warehouse 00:30:00 Warehouse Safety 00:30:00 Warehouse Cost Management 00:15:00 Improve Warehouse Efficiency and Reduce Costs 00:15:00 Mock Exam Mock Exam- Warehouse 00:20:00 Final Exam Final Exam- Warehouse 00:20:00

Enhance your skills in inventory and warehouse management with our comprehensive course. Learn about warehouse functions, inventory management techniques, and the role of technology in optimizing operations. Perfect for business owners, managers, and logistics professionals.

Warehouse Management If you employ individuals who have responsibility for running and managing the warehouse of your company, this Level 2 Warehouse Management Certification course is a great choice, to provide them with the skills that they need, in order to do so successfully. The course provides a thorough introduction to all of the information that a warehouse manager will need, from warehouse safety to equipment, stock and managing a team. Students will come away with a comprehensive overview of what successful warehouse management looks like and how to achieve it. What's Covered in the Course? This wide-ranging course covers a wealth of useful information relating to warehouse management, such as: An overview of the functions and importance of a warehouse in a successful business and the key role that it plays; The different types of warehouse equipment, what it is used for and how technology is an increasingly important part of warehouse management; Key warehouse processes and how to design, implement and manage them, for maximum success; How to use picking processes in a warehouse; Tips on managing and controlling stock and inventory, to ensure appropriate stock flow and minimise wastage; What supply chains are and how they link to warehouse management; How to manage warehouse staff in the most effective way; The importance of health and safety in a warehouse environment and how to promote it; How efficient warehouse processes can play a part in controlling business costs and practical tips on how to effectively minimise costs. What are the Benefits of the Course? This course provides your team member with lots of great benefits, in order to help them accelerate their learning of warehouse management. These include: By supporting them to undertake this course, you are helping your team member's career progression and giving them the opportunity to achieve an industry-recognised certification in warehouse management; Their new skills in warehouse management will ensure maximum success for your business; Students can easily combine work and study, due to the flexible nature of the course and the fact that there are no time limits on completing the course; While they undertake the course, learners benefit from ongoing online support, which is available around the clock.

Warehouse management provides learners with the fundamental knowledge and skills needed to efficiently manage warehouse operations.

This online warehouse management course is ideal for supervisors and warehouse managers who have had very little formal training. It is also ideal for warehouse and logistics managers who want to know what new tools, techniques and technologies are available to them to improve their operations and become more efficient and cost effective. The course is endorsed by the Chartered Institute of Logistics and Transport. It has been written by Gwynne Richards who has over 35 years of experience in the logistics sector and is the author of Warehouse Management, published by Kogan Page.

The Warehouse Operative or warehouse management course equips individuals with fundamental competencies crucial for effective warehouse management.

Unlock the secrets of warehouse management with our comprehensive online course. Our program is designed to provide you with all the essential knowledge and skills to become a successful warehouse manager. We cover everything from the fundamentals of warehouse management to the latest technologies and inventory control techniques. Our course is CPD-accredited, which means that upon completion, you will receive a certification recognized by employers across the UK. Our curriculum is structured to ensure that you gain a thorough understanding of the core functions of warehouse management, including warehousing, supply chain management, inventory control, and cost management. Whether you're looking to start a career in warehouse management or simply want to improve your existing skills, our online course is the perfect solution. Join today and take your first step towards a successful career in warehouse management! Along with this Warehouse course, you will get 10 premium courses, an original hardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Warehouse Bundle Consists of the following Premium courses: Course 1: Warehouse Management Course 2: Freight Consultant Training Course 3: Manual Handling Level 2 Course 4: Operation Management and Retailing Course 5: Purchasing & Procurement Course - Level 3 Course 6: Risk Management Course 7: DSEAR Training Course 8: COSHH Awareness Level 3 Course 9: Fire Safety Awareness Level 2 Course 10: First Aid at Work Course 11: Time Management Enrol in Warehouse to advance your career, and use the premium study materials from Apex Learning. The Warehouse Management bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Warehouse expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. The course curriculum of Warehouse Management : Course 1: Warehouse Management Fundamentals of Warehouse Management Warehousing: Function, Benefits and Types of Warehousing Core Functions Of A Warehouse Management System Challenges Of Warehouse Management Technology In The Warehouse Supply Chain Management Concepts Warehouse Management Technologies to Adopt Order Picking in the Warehouse Managing Warehouse Inventory Organize the Storage of Inventory in a Warehouse Inventory Management Techniques Inventory Control Flow of Processing Cost Management Improve Warehouse Efficiency and Reduce Costs Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Warehouse Management course is ideal for: Logistics and supply chain professionals Warehouse managers and supervisors Operations managers Business owners and entrepreneurs Anyone interested in a career in warehousing Requirements This Warehouse course has been designed to be fully compatible with tablets and smartphones. Career path Warehouse Management Warehouse Manager - £25k-£50k/year Logistics Coordinator - £20k-£35k/year Supply Chain Analyst - £25k-£45k/year Inventory Control Specialist - £22k-£40k/year Operations Manager - £30k-£60k/year Shipping and Receiving Manager - £25k-£45k/year Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Warehouse) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Have you ever ordered something from Amazon and received the wrong product? Chances are, no, you haven't. That's because Amazon warehouse operatives are skilled and good at their job. Speaking of Amazon, with the ever-looming pandemic outside and everyone ordering things from home, companies like Amazon, TESCO, eBay and all these big eCommerce companies are hiring warehouse operatives in large numbers. This warehouse operative course is a quick and easy way to learn the essentials of working in a warehouse. With its step by step lessons and no fluff method of content delivery, the course saves you time and money as it's available at a discounted price at the moment. Warehouse Operative course Learning Outcomes: Upon successful completion of this highly appreciated Warehouse Operative course, you'll be a skilled professional, besides- The purpose of the warehouse and several Layouts. Principles, tools, and procedures in warehousing Techniques and tools for completing orders Examine the many storage devices utilised in warehouses. Implement the appropriate security measures. Good Practices for Warehousing Curriculum Breakdown of the warehouse operative Course Module 01: The Role Module 02: Introduction to Warehouse Safety Module 03: Health and Safety Management Module 04: General Warehouse Hazards Module 05: Manual and Mechanical Handling Module 06: Site Safety Each topic has been designed to deliver more information in a shorter amount of time. This makes it simple for the learners to understand the fundamental idea and apply it to diverse situations. Key Features of Warehouse Operative course: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced Course Modules Covers to Explore Multiple Job Positions So, without any further ado, get started now. The faster you learn, the sooner you can start building your career as a Warehouse Operative. Certification CPD Accredited (CPD QS) Certificate Digital (PDF) & Hardcopy certificates are available Who is this course for? Those looking to pursue a profession in warehouse management. A person who wishes to begin their career in supply chain management in a warehouse setting. Owners and partners of e-commerce businesses who need to grow and start their own warehouse processes. Jobseekers who are looking to ace their logistics and supply chain management interviews. Requirements Students seeking to enrol for Along with the warehouse course should meet the following requirements; Basic knowledge of English Language, which already you have Be age 16 years or above Basic Knowledge of Information & Communication Technologies for studying online or digital platform. Stable Internet or Data connection in your learning devices. Career path The course will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Warehouse Operative, such as- Warehouse Managers Supply Chain Officer Inventory Managers Logistics Manager international Business Managers Importers - Exporters Freight Managers and Supervisors Courier and Parcel operators E-Commerce Fulfilment Managers Business Consultants Certificates Certificate of completion Digital certificate - Included After successfully completing this course, you can get CPD accredited digital PDF certificate for free. Certificate of completion Hard copy certificate - Included After successfully completing this course, you can get CPD accredited hardcopy certificate for free. The delivery charge of the hardcopy certificate inside the UK is £3.99 and international students need to pay £9.99 to get their hardcopy certificate.

Duration 4 Days 24 CPD hours This course is intended for The primary audience for this course is data professionals, data architects, and business intelligence professionals who want to learn about data engineering and building analytical solutions using data platform technologies that exist on Microsoft Azure. The secondary audience for this course includes data analysts and data scientists who work with analytical solutions built on Microsoft Azure. In this course, the student will learn how to implement and manage data engineering workloads on Microsoft Azure, using Azure services such as Azure Synapse Analytics, Azure Data Lake Storage Gen2, Azure Stream Analytics, Azure Databricks, and others. The course focuses on common data engineering tasks such as orchestrating data transfer and transformation pipelines, working with data files in a data lake, creating and loading relational data warehouses, capturing and aggregating streams of real-time data, and tracking data assets and lineage. Prerequisites Successful students start this course with knowledge of cloud computing and core data concepts and professional experience with data solutions. AZ-900T00 Microsoft Azure Fundamentals DP-900T00 Microsoft Azure Data Fundamentals 1 - Introduction to data engineering on Azure What is data engineering Important data engineering concepts Data engineering in Microsoft Azure 2 - Introduction to Azure Data Lake Storage Gen2 Understand Azure Data Lake Storage Gen2 Enable Azure Data Lake Storage Gen2 in Azure Storage Compare Azure Data Lake Store to Azure Blob storage Understand the stages for processing big data Use Azure Data Lake Storage Gen2 in data analytics workloads 3 - Introduction to Azure Synapse Analytics What is Azure Synapse Analytics How Azure Synapse Analytics works When to use Azure Synapse Analytics 4 - Use Azure Synapse serverless SQL pool to query files in a data lake Understand Azure Synapse serverless SQL pool capabilities and use cases Query files using a serverless SQL pool Create external database objects 5 - Use Azure Synapse serverless SQL pools to transform data in a data lake Transform data files with the CREATE EXTERNAL TABLE AS SELECT statement Encapsulate data transformations in a stored procedure Include a data transformation stored procedure in a pipeline 6 - Create a lake database in Azure Synapse Analytics Understand lake database concepts Explore database templates Create a lake database Use a lake database 7 - Analyze data with Apache Spark in Azure Synapse Analytics Get to know Apache Spark Use Spark in Azure Synapse Analytics Analyze data with Spark Visualize data with Spark 8 - Transform data with Spark in Azure Synapse Analytics Modify and save dataframes Partition data files Transform data with SQL 9 - Use Delta Lake in Azure Synapse Analytics Understand Delta Lake Create Delta Lake tables Create catalog tables Use Delta Lake with streaming data Use Delta Lake in a SQL pool 10 - Analyze data in a relational data warehouse Design a data warehouse schema Create data warehouse tables Load data warehouse tables Query a data warehouse 11 - Load data into a relational data warehouse Load staging tables Load dimension tables Load time dimension tables Load slowly changing dimensions Load fact tables Perform post load optimization 12 - Build a data pipeline in Azure Synapse Analytics Understand pipelines in Azure Synapse Analytics Create a pipeline in Azure Synapse Studio Define data flows Run a pipeline 13 - Use Spark Notebooks in an Azure Synapse Pipeline Understand Synapse Notebooks and Pipelines Use a Synapse notebook activity in a pipeline Use parameters in a notebook 14 - Plan hybrid transactional and analytical processing using Azure Synapse Analytics Understand hybrid transactional and analytical processing patterns Describe Azure Synapse Link 15 - Implement Azure Synapse Link with Azure Cosmos DB Enable Cosmos DB account to use Azure Synapse Link Create an analytical store enabled container Create a linked service for Cosmos DB Query Cosmos DB data with Spark Query Cosmos DB with Synapse SQL 16 - Implement Azure Synapse Link for SQL What is Azure Synapse Link for SQL? Configure Azure Synapse Link for Azure SQL Database Configure Azure Synapse Link for SQL Server 2022 17 - Get started with Azure Stream Analytics Understand data streams Understand event processing Understand window functions 18 - Ingest streaming data using Azure Stream Analytics and Azure Synapse Analytics Stream ingestion scenarios Configure inputs and outputs Define a query to select, filter, and aggregate data Run a job to ingest data 19 - Visualize real-time data with Azure Stream Analytics and Power BI Use a Power BI output in Azure Stream Analytics Create a query for real-time visualization Create real-time data visualizations in Power BI 20 - Introduction to Microsoft Purview What is Microsoft Purview? How Microsoft Purview works When to use Microsoft Purview 21 - Integrate Microsoft Purview and Azure Synapse Analytics Catalog Azure Synapse Analytics data assets in Microsoft Purview Connect Microsoft Purview to an Azure Synapse Analytics workspace Search a Purview catalog in Synapse Studio Track data lineage in pipelines 22 - Explore Azure Databricks Get started with Azure Databricks Identify Azure Databricks workloads Understand key concepts 23 - Use Apache Spark in Azure Databricks Get to know Spark Create a Spark cluster Use Spark in notebooks Use Spark to work with data files Visualize data 24 - Run Azure Databricks Notebooks with Azure Data Factory Understand Azure Databricks notebooks and pipelines Create a linked service for Azure Databricks Use a Notebook activity in a pipeline Use parameters in a notebook Additional course details: Nexus Humans DP-203T00 Data Engineering on Microsoft Azure training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DP-203T00 Data Engineering on Microsoft Azure course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.