5 Courses

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.

In the age of digitalisation, the art of storing goods efficiently is more crucial than ever. Dive deep into the world of 'Fundamentals of Warehousing and Storage: Optimising Inventory Control' to unlock the secrets of efficient storage and inventory control. Through this course, learners will embark on a transformative journey, uncovering the nuances of warehouse design, understanding the intricacies of processes, and staying ahead with the future trends in warehousing. Learning Outcomes * Understand the core principles of warehousing and its significance. * Gain insights into effective warehouse design and layout for maximum efficiency. * Master the techniques of inventory control and management to reduce wastage. * Learn about the essentials of warehouse safety, security, and risk management. * Analyse and utilise key performance metrics for warehouse optimisation. WHY BUY THIS FUNDAMENTALS OF WAREHOUSING AND STORAGE: OPTIMISING INVENTORY CONTROL? 1. Unlimited access to the course for forever 2. Digital Certificate, Transcript, student ID all included in the price 3. Absolutely no hidden fees 4. Directly receive CPD accredited qualifications after course completion 5. Receive one to one assistance on every weekday from professionals 6. Immediately receive the PDF certificate after passing 7. Receive the original copies of your certificate and transcript on the next working day 8. Easily learn the skills and knowledge from the comfort of your home CERTIFICATION After studying the course materials of the Fundamentals of Warehousing and Storage: Optimising Inventory Control 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 FUNDAMENTALS OF WAREHOUSING AND STORAGE: OPTIMISING INVENTORY CONTROL FOR? * Individuals keen on pursuing a career in warehouse management and operations. * Business owners aiming to improve their inventory control and storage solutions. * Logistics professionals seeking to update their knowledge in warehousing. * Students of business and supply chain management aiming for specialisation. * Consultants and advisors focusing on industrial storage and distribution. PREREQUISITES This Fundamentals of Warehousing and Storage: Optimising Inventory Control does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Fundamentals of Warehousing and Storage: Optimising Inventory Control 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 - Average Salary: £32,000 - £45,000 * Inventory Control Specialist - Average Salary: £25,000 - £37,000 * Logistics Coordinator - Average Salary: £23,000 - £30,000 * Supply Chain Analyst - Average Salary: £28,000 - £42,000 * Warehouse Health & Safety Officer - Average Salary: £24,000 - £36,000 * Warehouse Operations Analyst - Average Salary: £27,000 - £40,000. COURSE CURRICULUM Module 01: Fundamentals of Warehousing Fundamentals of Warehousing 00:14:00 Module 02: Warehouse Design and Layout Warehouse Design and Layout 00:13:00 Module 03: Warehouse Processes and Operations Warehouse Processes and Operations 00:14:00 Module 04: Inventory Control and Management Inventory Control and Management 00:09:00 Module 05: Warehouse Safety and Security Warehouse Safety and Security 00:16:00 Module 06: Warehouse Performance Metrics and Optimisation Warehouse Performance Metrics and Optimisation 00:14:00 Module 07: Emerging Trends and Future of Warehousing Emerging Trends and Future of Warehousing 00:18:00

Elevate your expertise in warehousing and storage with our comprehensive course for inventory managers. Explore fundamental principles, efficient warehouse design, streamlined operations, inventory control strategies, safety protocols, performance metrics, and emerging trends. Gain the knowledge to optimize your warehouse for success in the ever-evolving world of logistics and supply chain management.

OVERVIEW Our comprehensive course is designed to provide you with the necessary skills and knowledge to excel in your field. Developed by professionals with years of experience, this course is perfect for anyone looking to kick start their career or advance their skills. It features an audio-visual presentation and easy-to-learn modules, allowing for a self-paced learning experience. Our expert online support team is available during weekdays to assist you throughout the course. LEARNING OUTCOMES Upon completion of the course, you will be able to: * Understand the fundamentals and its applications. * Develop the necessary skills to succeed in the field . * Apply your newly acquired knowledge to real-world scenarios. * Create effective and efficient solutions for relevant topics. * Enhance your employability and career prospects. It is designed to provide you with the knowledge needed to stand out in the competitive job market. With lifetime access to course materials and the ability to learn at your own pace, this course is the perfect opportunity to improve your skills and advance your career. You can learn at your own pace, from the comfort of your home, as all course materials are accessible online at any time. WHY CHOOSE US? * Lifetime access to course materials * Full tutor support is available Monday through Friday for all courses * Learn  essentials skills at your own pace from the comfort of your home * Gain a thorough understanding of the course * Access informative video modules taught by expert instructors * 24/7 assistance and advice available through email and live chat * Study the course on your computer, tablet, or mobile device * Improve your chances of gaining professional skills and earning potential by completing the course. WHY SHOULD YOU STUDY THIS COURSE? The course offers a comprehensive introduction to the subject matter and provides a solid foundation for further study. It will also help students to gain knowledge and skills that can be applied in their professional or personal life. ASSESSMENT The course includes a series of quizzes that will test your understanding and retention of the material covered in the course. The quizzes will help you to identify areas where you may need further practice, and you will have the opportunity to review the course materials as needed. Upon successfully passing the final quiz, you will be able to order your certificate of achievement. CAREER PATH The course is designed to equip you with the skills and knowledge you need to succeed in the field. After completing the course, you will be able to pursue a variety of career opportunities in different industries. COURSE FEATURES * Lectures 14 * Quizzes 0 * Duration 6 Hours 30 Minutes * Skill level Beginner * Language English * Students 67 * Assessments Yes * WAREHOUSE MANAGEMENT * Lecture1.1 Introduction to Warehouse Management * Lecture1.2 Warehouse Operations * Lecture1.3 Warehouse Design and Layout * Lecture1.4 Inventory Management * Lecture1.5 Cross-Docking and Consolidation * Lecture1.6 Cold Chain and Temperature-Controlled Warehousing * Lecture1.7 E-commerce and Omnichannel Warehousing * Lecture1.8 Warehouse Management Systems (WMS) * Lecture1.9 Human Resource Management in Warehousing * Lecture1.10 Import and Export Compliance Show more items * ASSESSMENT * Lecture2.1 Assessment * ORDER YOUR CERTIFICATE * Lecture3.1 Order Your Certificate FAQs What is the format of the Warehouse Management? The course is self-paced and consists of video lectures, quizzes, and hands-on exercises. What is the duration of the course? The course is self-paced, so you can complete it at your own pace and schedule. Do I need any prior experience or qualifications to enrol in the course? No, there are no prerequisites for the course. Anyone with an interest in Warehouse Management can enrol. What type of support is available during the course? Full tutor support is available from Monday to Friday, and you can also access 24/7 help or advice from our email and live chat teams.

Learn to design, plan, and scale cloud implementations with Google Cloud Platform's BigQuery. This course will walk you through the fundamentals of applied machine learning and BigQuery ML along with its history, architecture, and use cases.