- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
Overview This comprehensive course on Inventory Management Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Inventory Management Training comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Inventory Management Training. It is available to all students, of all academic backgrounds. Requirements Our Inventory Management Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 7 sections • 33 lectures • 04:29:00 total length •Introduction to Inventory Management: 00:04:00 •Introduction to Inventory Management Continues: 00:10:00 •Objective of Inventory Management: 00:11:00 •Level For Inventory: 00:12:00 •Maximum Stock Level: 00:06:00 •Example of Maximum Stock Level: 00:07:00 •Example of Maximum Stock Level Continues: 00:08:00 •Minimum Stock Level: 00:11:00 •Example of Minimum Stock Level: 00:12:00 •Ordering Level: 00:06:00 •Example Ordering Level: 00:08:00 •Danger Or Safety Stock Level: 00:12:00 •Economic Order Quantity: 00:07:00 •Cost Of Inventory: 00:07:00 •Optimal Quantity to Order: 00:08:00 •Optimal Quantity to Order Continues: 00:06:00 •EOQ: 00:07:00 •Example of EOQ: 00:10:00 •Price Discount and EOQ Example: 00:09:00 •Price Discount and EOQ Example Continues: 00:07:00 •EOQ Lead Time: 00:10:00 •ABC Analysis: 00:07:00 •Illustration: 00:06:00 •Procurement Process: 00:07:00 •Procurement Process Continues: 00:07:00 •Pricing Of Stores Receipts: 00:04:00 •Illustration Pricing Of Stores: 00:10:00 •Methods of Inventory Valuations: 00:11:00 •FIFO Inventory Valuation: 00:09:00 •FIFO Inventory Valuation Continues: 00:07:00 •LIFO Inventory Valuation Continues: 00:08:00 •Average Cost Methods: 00:07:00 •Just In Time Inventory: 00:08:00
Logistics Management Training
By Training Tale
Logistics Management Online Do you want to start a career in Logistics Management? Are you interested in learning the Logistics management skills and knowledge needed for this role but do not know where to start? To expand your professional career, enrol in this Logistics Management course right now. This Logistics Management course is designed to provide you with a solid understanding of logistics, ensuring that you are familiar with the components of a logistics system as well as the many types of logistics management. This Logistics Management course will also introduce you to the topic of business logistics and the goals of logistics management. This Logistics Management Course comprises a series of easy-to-digest, in-depth lessons that will offer you a deep, expert level of knowledge. This course will provide you with the skills you need to land your dream job. Enrol this Course now and start learning. Logistics Management Learning Outcomes After completing this Logistics Management course, you will be able to - Describe logistics management as well as what it entails. Build a strong logistics system. Describe supply chain management and supply chain movement. Know about sourcing, purchasing, and procurement. Explain various distribution networks. Keep track of your supplier relationships. Investigate resource management and planning. Recognize the connection between transportation and logistics. Certification After completing the MCQ/Assignment assessment for this Logistics Management course, you will be entitled to a Certificate of Completion from Training Tale. Logistics Management Course 1:14:00 1: Logistics Management Course 1:14:00 PDF Who is this course for? Logistics Management Training This Logistics Management course is perfect for - Job Seekers, Fresh Graduate, Organisational Manager, Company Owner. Requirements Logistics Management There are no specific requirements for this Logistics Management course. Career path Logistics Management You may be able to find the position you want in the industry with the help of our Logistics Management course. Certificates Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.
Material Management & Handling
By NextGen Learning
*** A Better Pathway for Rapid Growth! Limited Time Opportunity; Hurry Up! *** Ignite your dynamic career and strengthen your deep insight knowledge by signing up for Material Management & Handling. This course is the ideal approach for you to obtain a thorough understanding and knowledge of the subject. We are concerned about the progression of your career. Therefore, after conducting extensive studies and consulting with experienced personnel, we formulated this outstanding course to improve your pertinent skills. In this easy-to-digest Material Management & Handling course, you will get exclusive training, which will enable you to stand out in this competitive market. However, the Material Management & Handling course covers all of the recent materials in order to keep you up to date with the job market and make you a good fit for your career. This top-notch course curriculum comprises basic to advanced levels of modules that will increase your skillsets. After completing this Programme, you will attain the productivity to succeed in your organisation. So, if you are eager to see yourself in a gratifying Material Management & Handling career, then enrol in our course today! What will make you stand out? On completion of this Material Management & Handling online course, you will gain the following: CPD Certified Material Management & Handling Course After successfully completing the Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of Material Management & Handling learning materials. The Material Management & Handling course online test with immediate results Enroling in the Course has no additional costs. You can study and complete the course at your own pace. Study for the course using any internet-connected device, such as a computer, tablet, or mobile device. The substantial Material Management & Handling is designed to help you demonstrate the preliminary to in-depth level of learning regarding this topic. Moreover, you will be provided with the most knowledgeable and informative modules for your lifetime by enroling in this course just once. Furthermore, as you proceed through the modules of this course, you will discover the fundamentals of Material Management & Handling and explore the key topics such as: Material Management & Handling Module 01: Introduction to Material Management Module 02: Purchasing and Supply Chain Management Module 03: Inventory Management, Planning and Control Module 04: Stores Management and Control Module 05: Forecasting Module 06: Material Requirements Planning Module 07: Materials Handling Therefore, reinforce your knowledge and furnish your skills by enroling in our Material Management & Handling course. Take one step closer to achieving your goal. Show off your new skills with a certificate of completion When you have finished all of the Material Management & Handling course lectures, a digital certificate will be available for download. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Material Management & Handling Course the Right Option for You? This Material Management & Handling course is recommended for anyone who is interested in learning more about this topic. You'll learn the fundamental ideas and gain a comprehensive understanding of the topic by taking this course. This Material Management & Handling course is open to everybody. You can access the course materials from any location in the world and there are no requirements for enrolment. You should enrol in this course if you: Aspire to understand Material Management & Handling better. Already working on it and eager to learn more. Is a student pursuing a relevant field of study? Trying to get a job in Material Management & Handling-related fields. Requirements Without any formal requirements, you can delightfully enrol in this Material Management & Handling course. Just get a device with internet connectivity and you are ready to start your learning journey. Thus, complete this Material Management & Handling course at your own pace. Career path The aim of this exclusive Material Management & Handling course is to help you toward your dream career. So, complete this Material Management & Handling course and enhance your skills to explore opportunities in relevant areas.
Introduction to supply chain management (In-House)
By The In House Training Company
This comprehensive one-day programme has been designed to provide participants with an overview of basic supply chain principles and concepts and to identify potential opportunities for reducing costs, minimising risks and adding value across the supply chain. This could include reducing inventory, procurement, transport and storage costs. Fundamentally, the object of the programme is to empower participants to be able to collaborate with all key stakeholders across the supply chain. This course will help participants: Appreciate the importance of the supply chain as a source of competitive advantage Understand the tools and techniques available to improve supply chain performance Analyse and mitigate risks across the supply chain Identify opportunities for improvements in their respective supply chains Demonstrate competence in the pro-active management of the supply chain
Online Options
Show all 52455321 SQL Server Integration Services
By Nexus Human
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
Warehouse Management Level 2
By OnlineCoursesLearning.com
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
By Apprise Consulting Ltd
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.
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.
Warehouse - CPD Accredited
By Compliance Central
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.
DP-203T00 Data Engineering on Microsoft Azure
By Nexus Human
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.
