5522 Courses in Cardiff delivered Live Online

About this Training Course Petrophysics remains a vital component to many facets of the petroleum industry, from quantification of hydrocarbon reserves to developmental strategies to real-time decision making for reservoir navigation. Targeted at awareness to knowledge level, this course addresses the tenets of petrophysics and formation evaluation, using integrative perspective of multiple datasets, including geological, geophysical, and logging and core data. Significant worldwide case histories are included, as well as several exercises designed to provide hands-on experience. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives By attending this course, the participants will be able to: Understand better the latest geological, geophysical, and logging/core technologies and their role in petrophysical analysis, formation evaluation, and reservoir characterization. Address the pros and cons of key datasets, with emphasis on need for integrative studies and calibration of datasets. Apply quick-look qualitative techniques as well as quantitative aspects to understand vital aspects such as volume of shale/clay, porosity, permeability, and water saturation determinations. Select tool combinations to resolve key issues and for specific applications. Assess uncertainty in petrophysical measurements and techniques and its influence on reserve estimation. Target Audience This course is recommended for development and exploration geologists, petrophysicists, log and core analysts, geophysicists, petroleum engineers, managers, and technical personnel. Course Level Intermediate Trainer Your expert course leader received his B.S. and M.S. degrees in Geology from the now University of Louisiana-Lafayette in 1989 and 1990 respectively, and his Ph.D. as a National Science Foundation fellow at Baylor University, Waco, Texas, in 1993. From 1994 - 1996, he studied planetary tectonics as a NASA-funded postdoctoral fellow at Southern Methodist University. In 1996, he returned to UL-Lafayette, where he was awarded in 1997 the Hensarling-Chapman Endowed Professorship in Geology. He began independent consulting activities in 1991, and in 2001, he left academia for full-time consulting for clients ranging from one-man shops to supermajors. He rejoined UL-Lafayette as an adjunct professor from 2011 - 2018. He is an active researcher, receiving several million dollars in grants from federal, state, and industry sources, presenting numerous talks, including a 2019 AAPG Levorsen award, and publishing on a diversity of geoscience topics, including a Grover E. Murray Best Published Paper award in 2017. He is co-author of the inaugural GCAGS/GCSSEPM Transactions Best Student Paper award in 2018. He served as the GCAGS Publisher since 2006 and in various GCAGS/GCSSEPM Transactions editing capacities since 2006, including the 2014 and 2017 - 2022 Editor (named Permanent Transactions Editor in 2017), and Managing Editor since 2011, receiving a GCAGS Distinguished Service Award in 2018. He served as the General Chair for GeoGulf 2020 (70th GCAGS/GCSSEPM Convention), the 1st hybrid geoscience conference in the world. He is a Past President of the Lafayette Geological Society and served as its Editor and Publisher from 2002 - 2018. In 2018, he founded the Willis School of Applied Geoscience, reformulating decades of industry-training experience to provide alternative opportunities for graduate-level education. In 2020, he received an Honorary Membership from GCSSEPM. He also joined the LSU faculty as an adjunct professor in 2020. In 2021, he co-founded the Society of Applied Geoscientists and Engineers, serving as its President, General Chair for the SAGE 2022 Convention & Exposition, and Vice-Chair for the Benghazi International Geoscience & Engineering Conference 2022 (BIGEC 2022). POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

CWAP training course description This WiFi analysis course consists of hands-on learning using the latest enterprise wireless LAN analysis and troubleshooting tools. The course takes an in-depth look at the functionality of WLANs, intended operation of the 802.11 protocol and Wi-Fi Alliance specifications, WLAN frame formatting and structure, troubleshooting methodology, and protocol analysis. It also includes extensive training in modern spectrum analysis with a focus on advanced RF behaviour analysis, data collection methods, interpreting spectrum plots and charts, and understanding advanced features of WLAN spectrum analysers. What will you learn Analyse WiFi frames using Wireshark. Explain 802.11 protocol operation. Troubleshoot WiFi networks using Wireshark. Troubleshoot WiFi networks using spectrum analysers. CWAP training course details Who will benefit: Technical Network Staff Anyone looking to become a CWAP Prerequisites: Certified Wireless Network Administrator Duration 4 days CWAP training course contents Principles of WLAN Communication 802.11 Working Group, OSI reference model and the 802.11 PHY and MAC, Communication sublayers and data units, WLAN architecture components, Organization of station forwarding Addressing and internetworking operation, Modern WLAN product architectures. Physical (PHY) and MAC Layer Formats and Technologies Physical layer functions, Preamble function and format, Header purpose and structure, Analysis of PHY problems, Physical PPDU formats, 802.11b, 802.11a, 802.11g, 802.11n, MAC frame components, MAC encapsulation, Fields and subfields of the MAC header, Frame Control, Frame types and subtypes and their uses, Addressing, Frame body, Data frame format, Control frame format, Management frame format, Information elements and fields. Beaconing and synchronization Scanning, Client state machine, 802.11 contention, QoS, Admission control, Band steering and airtime fairness mechanisms Fragmentation, Acknowledgments and Block acknowledgments, Protection mechanisms and backward compatibility, Power management, Dynamic Frequency Selection (DFS) and Transmit Power Control (TPC), Security components, methods, and exchanges, Roaming procedures exchanges, Future protocol enhancements. 802.11n Transmit beamforming, Spatial multiplexing, Maximal Ratio Combining (MRC), Space-Time Block Coding, 40 MHz channels, Frame aggregation, HT-OFDM format, Modulation and Coding Schemes (MCS), HT frame formatting and more. Protocol Analysis Tools and Methodology Troubleshooting methodology, Protocol analyser types, Analysis NIC/adapter selection and constraints, Interpreting results based on location, Analyzer settings and features, Filtering and channel scanning, Interpreting decodes, Using advanced analysis features, Assessing WLAN health and behaviour factors, Evaluating network statistics, Troubleshooting common problems, Wired analysis to support wireless network issues. Spectrum Analysis Tools and Methodology Radio frequency behaviour review, Visualizing RF domains using spectrum measurement tools, Spectrum analyser types and operation, Analyser specifications and characteristics, Understanding spectrum data presentation, Interpreting plots and charts, Common WLAN spectrum analyser features, Identifying transmit patterns, Device classification and network impact, Recognizing transmit signatures. Hands on lab exercises Wireshark Setup, Use, and In-Depth Analysis Wireshark is fundamental to troubleshooting. Labs include: - Capabilities, configuration, and data display - Opening, collecting, saving, and modifying capture files. - Filtering traffic, and using colouring rules as analysis aides. - Live captures based on a set of desired collection criteria. - Identify and isolate network problems. - Conversation analysis. - Remote packet capture with an AP. Understanding Frame Components Familiarity with the frame structure and contents is essential in real -world troubleshooting efforts. Labs include: - Understanding the MAC header - Comparing the three major frame types and their subtypes - Analysing frame formats of individual frame types - Analysing 802.11n frame components - Additional information is reported by protocol analysers - Information not visible in protocol analysers Frame Exchanges Understanding frame exchange rules and behaviors is critical to identifying expected and unexpected. It is also necessary to understand what is normal so that aberrations can be properly troubleshot. Labs include: - Connectivity exchanges and sequences - Legacy and modern security exchanges - ERP and HT protection mechanisms - Power save behaviour - Acknowledgments, block acknowledgments, and supporting action frames - Dynamic rate switching - Band steering Troubleshooting Common Problems This lab exposes students to hands-on troubleshooting skills by setting up common problems in WLANs and allowing students to attempt to solve them. - Trouleshooting connectivity exchanges - Troubleshooting 802.1X and EAP exchanges - Troubleshooting roaming Spectrum Analyzer Setup, Use, and In-Depth Analysis Specifically, it will explore the plots and charts used to display spectrum data and how to interpret this data to define a transmitter's impact on the network. The following are covered: - Installing the analyser and using display and navigation - The 'RF perspective' provided by each plot and chart - Using built-in features and automated device identification - Characterizing the behaviours of an interference source - Assessing the impact of an interference source - Determining the impact of transmitter proximity on interference. - Identifying signatures of common transmitters - Remote spectrum analysis with an AP

About this Training Course This 5 full-day training course looks at the setup of economic analysis cases, including the estimation of recoverable reserves, production profiles, commodity prices, and project costs - CAPEX, OPEX, taxes, royalties, transportation, depreciation, before-tax (BTAX) cash-flow, after-tax (ATAX) cash-flow and international fiscal regimes (production sharing agreement and concessionary system). The course begins from the basic required parameters of inflation, interest and time value of money. These concepts are then transformed into profitability indicators. Last but not the least, the profitability indicators are then used to make investment decisions. The emphasis of this course is to bridge the gap between theoretical concepts and their practical limitations. The participants will be able to appreciate the amount of information that they never thought of. Another emphasis of this course is also on the use of Excel's financial functions. This understanding is very critical when it comes to building economic cash-flow models. Over the years, we have seen that participants really struggle with using the Excel functions correctly and this leads to mistakes that can be easily avoided. In each session, multiple choice problems are provided to participants to reinforce their understanding of the concepts covered in the course. Many quick or tips not widely known, are also shared with the participants. The concepts covered in this course are not restricted to downstream, upstream or petrochemical projects. These concepts can be used to evaluate any type of investment under consideration. Participants will require access to computers/laptops with Excel to solve problems during the course. Training Objectives Upon completion of this course, participants will be able to fully understand the gas market dynamics and Investment Evaluation. They will be able to: Learn how to reduce exposure and mitigate risks in projects by handling uncertainty Clarify concepts such as time value of money, cash-flow models, capital budgeting, IRR, NPV, income producing investments Maximise the return on investments through good decision-making processes based on the commercial viability of projects Improve their decision process, investment and opportunity analysis Acquire the hands-on experience in building their own economic evaluation models and solving case study-based examples   Target Audience The following oil & gas company personnel will benefit from the knowledge shared in this course: Facilities and Planning engineers Project and procurement personnel Oil & gas engineers Geologists Financial Analysts Commercial managers Economists Government officials Business advisors Asset managers E&P managers Product and business development personnel   Course Level Basic or Foundation Training Methods     Organisational Impact     Trainer Your expert course leader is a globally recognised subject matter expert in petroleum/project economics and international gas market analysis. He is a recipient of the 2021 Society of Petroleum Engineers (SPE) International Management Award, an award that recognises individuals who make significant technical and professional contributions to the petroleum engineering profession and to the worldwide oil and gas industry. He has 40 years of diversified experience in petroleum engineering, reservoir engineering, project economics and decision analysis. He had been involved in evaluating multi-billion-dollar oil and gas field development, NGL, LNG, GTL, Aluminum smelter, refinery, petrochemical, power and production sharing projects. He has worked with major oil companies such as Saudi Aramco, ZADCO, Qatar Petroleum and companies in USA. He is a registered professional Engineer in the state of Colorado, USA. He is the author of six books: Petroleum Engineering Handbook for the Practicing Engineer, Vol. I and Vol. II, published by PennWell Books, Tulsa, Oklahoma, USA. Project Economics and Decision Analysis, Vol. I and Vol. II, published by PennWell Books, Tulsa, Oklahoma, USA. These books are used as textbooks in universities worldwide to teach petroleum economics to undergraduates and graduate students. Tip & Tricks in Excel based Financial Modeling, Vol. 1 & 2, published by Business Expert Press, New York, USA. He has also authored several papers in the Oil & Gas Journal, The Log Analyst, World Oil, SPE Journals, and Oil & Gas Financial Journal. He has delivered lectures in more than 25 countries around the globe. He has always received excellent feedback, as an expert presenter, from the participants of his courses. Daily daily_agenda     POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Social anxiety test Emotional intelligence training Self-regulation training Self-improvement coaching Confidence building Social skills OCD Resolving social phobia Addressing intense anxiety issues Social anxiety disorder Addressing issues in the anxiety spectrum Exposure hierarchy therapy Objective goals Guidance and support Addressing pain points Social anxiety disorder exercises Homework and self-help guide (dating advice and relationship advice optional) 6 sessions https://relationshipsmdd.com/product/m-d-d-social-anxiety-course-package/

The NCSP® 800-53 Practitioner accredited (APMG International), certified (NCSC/GCHQ-UK), and recognized (DHS-CISA-USA) certification course teaches Digital Business, Operational Stakeholders, Auditors, and Risk Practitioners a Fast-Track approach to adopting and adapting the NIST Cybersecurity Framework and its 800-53 controls across an enterprise and its supply chain.The course also teaches candidates how to build a Digital Value Management System (DVMS) CPD overlay model capable of enabling the quick adoption and adaption of new frameworks and models (NIST-CSF, NIST Privacy Framework, CMMC, etc.) that may be required to address internal, external (regulatory), and cyber threat landscape changes. Finally, the course teaches candidates how to ensure the organization's DVMS is designed for use within the organization and auditable by government regulators looking to verify regulatory outcomes. The NCSP Practitioner 800-53 course is designed for both the Implementer and Auditor topics and participants select the exam they want to take (or an additional exam can be ordered to be certified as both an implementer and auditor).

Gain a deep understanding of Production Sharing Contracts (PSC) and related agreements through our expert-led course. Enroll now and excel in your field with EnergyEdge.

QA Level 2 Award In Food Safety For Retail (RQF) Face to Face: Full day course Virtual Classroom: Spread over 3 sessions of 2½ hr duration Food business operators are required by law, to ensure that food handlers receive appropriate supervision and instruction/training in food hygiene in line with their work activity and should enable them to handle food safely Recommended by HSE and Environmental Health Officers (EHO's) Course Contents: The Importance of Food Safety Food Safety Laws Legal Responsibilities of Food Handlers Types of Contamination and the Associated Risks Bacteriology Food Poisoning Foodborne Illnesses An Introduction to Hazard Analysis and Critical Control Points (HACCP) Personal Hygiene Work Flow, Work Surfaces and Equipment Cleaning and Disinfection Waste Disposal Pest Control Safe Food Handling Practices including Time and Temperature Controls Preparation Cooking and Reheating Chilling Cooling Thawing Hot holding Displaying food Core temperatures Food Preservation Storage Stock Control Procedures Benefits of this course: Businesses have a duty to their customers to produce food that is safe for consumption. There are one million cases of food poisoning in the UK each year. More than 6,000 are admitted to hospital. In 2014/2015, businesses in Chesterfield were issued 344 written enforcement notices. Derby received 1,116. Doing our Ofqual regulated, nationally accredited course ensures that nothing of importance is left out. EU and UK regulations state that all food handlers must receive appropriate training in food safety practices relevant to their duties. The Food Standards Agency says that 'Food business operators are required by law, to ensure that food handlers receive appropriate supervision and instruction/training in food hygiene in line with their work activity and should enable them to handle food safely’. Our QA Level 2 Award in Food Safety in Catering (RQF) is a nationally accredited qualification especially suitable for people working in, or planning to work in, the food retail industry, and complies with the training regulations.

Who is this course for? The Diploma in Visual Effects for Film and Television Animation is tailored for individuals aspiring to work in the Visual Effects, TV, Film, and 3D animation industry. Gain essential skills necessary for a successful career in these fields. Click here for more info: Website Duration: 120 hours of 1-on-1 Training. When can I book: 9 am - 4 pm (Choose your preferred day and time once a week). Monday to Saturday: 9 am - 7 pm (Flexible timing with advance booking).  Course Overview for a 120-Hour Diploma Program in Game Design and Development Term 1: Introduction to Game Design and 3D Modeling (40 hours) Module 1: Introduction to Game Design (1 hour) Understanding the game development industry and current trends Exploring game mechanics and fundamental design principles Introduction to the game engines and tools utilized in the program Module 2: 3D Modeling with 3ds Max (25 hours) Familiarization with 3ds Max and its user interface Mastering basic modeling techniques like box modeling and extrusion Advanced modeling skills including subdivision and topology Texturing and shading techniques tailored for game development Module 3: Character Design and Animation (10 hours) Introduction to character design and its developmental process Creating and rigging characters specifically for games Keyframe animation techniques for character movement Term 2: Game Development and Unity 3D (40 hours) Module 4: Unity 3D Basics (20 hours) Navigating Unity 3D and understanding its interface Grasping fundamental game development concepts within Unity Creating game objects, writing scripts, and designing scenes Introduction to scripting using C# Module 5: Advanced Game Development with Unity 3D (10 hours) Constructing game mechanics including UI, scoring, and game states Working with physics and collision systems in Unity Crafting intricate game environments and level designs Module 6: Game Assets with Photoshop (10 hours) Exploring Photoshop tools and features for game asset creation Crafting game elements such as textures, sprites, and icons Optimizing assets for seamless integration into game development Term 3: Advanced Game Design and Portfolio Development (40 hours) Module 7: Advanced Game Design (20 hours) Delving into advanced game design concepts like balancing and difficulty curves Understanding player psychology and methods for engaging audiences Implementing game analytics and user testing for refinement Module 8: Portfolio Development (24 hours) Building a comprehensive portfolio showcasing acquired skills Effective presentation techniques for showcasing work Establishing a professional online presence and networking strategies Final Project: Creating and presenting a collection of best works in collaboration with tutors and fellow students Please note: Any missed sessions or absence without a 48-hour notice will result in session loss and a full class fee charge due to the personalized one-to-one nature of the sessions. Students can request pauses or extended breaks by providing written notice via email. What can you do after this course: Software Proficiency: Master industry-standard design tools for architectural and interior projects. Design Expertise: Develop a deep understanding of design principles and spatial concepts. Visualization Skills: Acquire advanced 2D/3D rendering and virtual reality skills for realistic design representation. Communication and Collaboration: Enhance communication skills and learn to collaborate effectively in design teams. Problem-Solving: Develop creative problem-solving abilities for real-world design challenges. Jobs and Career Opportunities: Architectural Visualizer Interior Designer CAD Technician Virtual Reality Developer 3D Modeler Project Coordinator Freelance Designer Visualization Consultant Students can pursue these roles, applying their expertise in architectural and interior design across various professional opportunities. Course Expectations: Maintain a dedicated notebook to compile your study notes. Schedule makeup sessions for any missed coursework, subject to available time slots. Keep meticulous notes and maintain a design folder to track your progress and nurture creative ideas. Allocate specific time for independent practice and project work. Attain certification from the esteemed professional design team. Post-Course Proficiencies: Upon successful course completion, you will achieve the following: Develop confidence in your software proficiency and a solid grasp of underlying principles. Demonstrate the ability to produce top-tier visuals for architectural and interior design projects. Feel well-prepared to pursue positions, armed with the assurance of your software expertise. Continued Support: We are pleased to offer lifetime, complimentary email and phone support to promptly assist you with any inquiries or challenges that may arise. Software Accessibility: Access to the required software is available through either downloading it from the developer's website or acquiring it at favorable student rates. It is important to note that student software should be exclusively utilized for non-commercial projects. Payment Options: To accommodate your preferences, we provide a range of payment options, including internet bank transfers, credit cards, debit cards, and PayPal. Moreover, we offer installment plans tailored to the needs of our students. Course Type: Certification. Course Level: Basic to Advanced. Time: 09:00 or 4 pm (You can choose your own day and time once a week) (Monday to Friday, 09 am to 7 pm, you can choose anytime by advance booking. Weekends can only be 3 to 4 hrs due to heavy demand on those days). Tutor: Industry Experts. Total Hours: 120 Price for Companies: £3500.00 (With VAT = £4200) For Companies. Price for Students: £3000.00 (With VAT = £3600) For Students.

Why Vectorworks 2D Basics Level Training Course? Vectorworks excels in 2D design, delivering exceptional results and serving as a robust 2D design tool. The Fundamentals course provides customizable tools for precise 2D drawings, while VectorWorks Architect streamlines the process with user-friendly, easy-to-learn tools. Click here for more info: Website Course Details: 10 hrs, Flexible 1-on-1 sessions, in-person or online. 9 am and 7 pm (Mon-Sat).10 hours, split as needed for your schedule. Module 1: Understanding CAD and Vectorworks The Role of CAD in Design Introduction to Vectorworks Software Module 2: Setting Up Your Workspace Workspace Configuration Basic Options and Preferences Module 3: Foundational Drawing Skills Drawing Techniques Selecting Objects Module 4: Advanced Object Editing Combining Shapes Mirroring Objects Rotating Objects Grouping Objects Module 5: Precision Drawing and Scaling Working with Scale Setting Preferences Saving Templates Module 6: Accurate Object Placement Drawing Precision Moving Objects Precisely Module 7: Advanced Editing Techniques Using Fillet Employing Offset Module 8: Introduction to Object Attributes and Groups Basic Attributes Editing Object Groups Module 9: Duplicating Objects Linear Duplicates Rectangular Duplicates Circular Duplicates Module 10: Creating Room Plans Designing Walls Incorporating Windows and Doors Module 11: Room Plan Development Room Plan Drawing Methods Module 12: Utilizing Additional Attributes Hatch Patterns Gradients Image Fills Module 13: Drawing Elevations Elevation Techniques Effective Methods Module 14: Importing Images for Graphics Graphic Illustration Image Integration Module 15: Symbols and Resource Management Creating Symbols Introduction to Resource Browser Module 16: Organizing Drawings with Design Layers Design Layer Usage Module 17: Labeling Drawings and Title Blocks Drawing Labels Title Block Text Module 18: Plotting and Printing User Interface and Terminology Printing Techniques Module 19: Creating Drawing Sheets A1, A2, and A3 Sheets Module 20: Utilizing Viewports Multiple Views Module 21: Professional Model Presentation Paper Space Presentation Converting to PDFs Module 22: Managing Files and Projects Module 23: Displaying Objects and Terminology Module 24: Objects and Data Management Module 25: Precise Object Placement Object Snaps Quick Select Module 26: Dividing and Measuring Objects Module 27: Dimensioning and Annotation Module 28: Working with Text Module 29: Custom Tool Palettes Module 30: Organizing Tool Palettes Module 31: Effective Tool Palette Usage Module 32: Standard Views and Drawing Techniques Module 33: Drawing Curves Arcs, Donuts, and Ellipses Module 34: Real-World Units and Measurements Module 35: Object Manipulation Changing Object Angles Module 36: File Management Saving, Exiting, and Opening Projects Module 37: Creating Mirror Images Module 38: Introduction to 3D Modeling Creating Extrusions Basic 3D Concepts Outcomes and Vectorworks Jobs: Vectorworks Proficiency: Gain expertise in using Vectorworks software for design tasks. 2D Design Skills: Create accurate 2D drawings and architectural plans. Advanced Editing: Efficiently manipulate and edit objects in your designs. Precision Drawing: Develop skills for precise scaling and drawing. These skills open doors to careers in design, architecture, engineering, entertainment, and more. Potential Jobs: Architectural Drafter Interior Designer Landscape Designer AD Technician Graphic Designer Construction Estimator Product Designer Set Designer Event Planner Urban Planner Vectorworks 2D Training Course Our Vectorworks training is thoughtfully designed to educate and inspire designers at every skill level. Whether you're just starting or a seasoned pro, our courses will furnish you with fresh skills, streamline your workflows, and unleash the full potential of your Vectorworks software. Online Training Choices Tailored Online Sessions: Customized training sessions tailored to your specific requirements and skill level. Virtual Classroom: Participate in interactive virtual classes from the convenience of your workspace. Getting Started Guides: Comprehensive guides to assist you in navigating the fundamentals of Vectorworks. In-Person Training Opportunities Customized On-Site Sessions: Hands-on training delivered directly to your office or at regional events. One-to-One: Engage in interactive learning at our training locations. Download Vectorworks https://www.vectorworks.net Personalized One-on-One Training: Get individualized attention and customized instruction. Flexible Scheduling: Choose your preferred training time and day to suit your schedule. Post-Course Assistance: Access free online support after course completion. Comprehensive Learning Materials: Receive PDF notes and handouts to enhance your learning. Certificate of Completion: Earn a recognition certificate upon successfully finishing the course. Affordable Rates: Enjoy cost-effective training rates. Software Setup Assistance: Receive help setting up the software on your computer. Referral Benefits: Recommend a friend and receive discounts on future courses. Group Training Discounts: Special discounts available for group training sessions. Convenient Availability: Access training sessions from Monday to Sunday, with extended hours. Tailored Training: Receive customized, bespoke training tailored to your specific requirements.

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.