39215 RES courses

Duration 2 Days 12 CPD hours This course is intended for This intermediate course is for operations personnel and technical staff who are directly involved in the installation, operation, systems support, and software support of their System z mainframe environment. Overview Identify the zEnterprise 196 and 114, System z10, System z9, and zSeries servers Describe the major differences of the function and features between the System z servers Describe and explain the concept of logical partitioning Identify how various resources are assigned to LPARs during initialization Describe the functions provided by the HMC and SE This course teaches you navigation, operation, and recovery techniques for the Hardware Management Console (HMC) in the System z environment. Through lecture and hands-on exercises, you learn setup and operating procedures for the HMC, gain indepth problem determination skills, practice HMC operations, and utilize recovery capabilities provided by the System z servers. WelcomeUnit 1: IBM mainframe server hardware: Overview Unit 2: Using the HMC classic style user interface Unit 3: Using the HMC tree style user interfaceUnit 4: Using the HMC to monitor System z servers Supporting labsReviewUnit 5: Activation profiles and operational tasksUnit 6: Single object operation: CPC session Supporting labs

Duration 5 Days 30 CPD hours This course is intended for This class is intended for DBAs and IT Professionals who are responsible for administration and maintenance of PostgreSQL, and want to increase proficiency and learn best practices. Targeted at: DBAs and Architects, and appropriate for Analysts, Support Engineers, and other IT professionals Overview Please refer to overview This is an immersive 5-day class that offers hands-on labs and combines the core topics from Foundations of Postgres Administration and Advanced PostgreSQL Administration into a one-week class, with significant savings over list price. Upon course completion, you will be prepared to manage mission critical PostgreSQL installations, and perform core administration tasks with confidence and skill. Course Outline 1 - POSTGRES SYSTEM ARCHITECTURE 2 - INSTALLATION AND GETTING STARTED 3 - CONFIGURATION, CREATING, MANAGING DATABASES 4 - USER TOOLS ? USING PSQL 5 - GUI TOOLS - USING PGADMIN 4 6 - SECURITY BASICS 7 - SQL PRIME BACKUP AND RECOVERY 8 - ROUTINE MAINTENANCE 9 - POSTGRES DATA DICTIONARY 10 - MOVING DATA 11 - SQL TUNING 12 - PERFORMANCE TUNING 13 - STREAMING REPLICATION 14 - TABLE PARTITIONING 15 - EXTENSION MODULES 16 - MONITORING 17 - UPGRADING BEST PRACTICES

Duration 4 Days 24 CPD hours This course is intended for IS Security Officers Privacy Officers Health IS Managers Risk Managers Information Security Managers Compliance and Privacy Officers Overview Upon completion, the student will be ready to take the Certified Healthcare Information Systems Security Practitioner exam by mile2. In addition, at the end of the CHISSP course, the student will be versed with best practices in the healthcare industry and will be able to establish a framework with current best practices in respects to privacy, regulation and risk management. The Certified Healthcare IS Security Practitioner, C)HISSP certification course covers the skills and knowledge to implement the best IT healthcare practices, as well as, regulatory compliance and standards in the healthcare industry. Because of growing industry regulations and privacy requirements in the healthcare industry, the C)HISSP was developed by Mile2. Graduates of this course have become vital in managing and protecting healthcare data and are tasked to protect patient information by implementing, managing, and assessing proper IT controls for patient health information integrity. Course Outline Intro to the Healthcare Industry Regulatory Environment Healthcare Privacy and Security Policies Information Governance Risk Management Third-Party Risk Management

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Database Administrators, Database Developers, BI professionals, and Business reporting users. Overview Upon successful completion of this course, students will be able to run Queries and retrieve results, perform conditional searches, and retrieve data from multiple tables. Before starting this course, make sure you meet at least one of the following prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Basic working knowledge of Relational Databases. In this course, students will gain a good understanding of the Transact-SQL language. They will be able to create queries, sort, filter the data, execute procedures with T-SQL. Course Outline 1.Introduction to Microsoft SQL Server 2.Introduction to T-SQL Querying 3.Writing SELECT Queries 4.Querying Multiple Tables 5.Sorting and Filtering Data 6.Working with SQL Server Data Types 7.Using DML to Modify Data 8.Using Built-In Functions 9.Grouping and Aggregating Data 10.Using Subqueries 11.Using Table Expressions 12.Using Set Operators 13.Using Windows Ranking, Offset, and Aggregate Functions 14.Pivoting and Grouping Sets 15.Executing Stored Procedures 16.Programming with T-SQL

Abrasive Wheels Training Nearly half of the workplace accidents involving abrasive wheels are due to an unsafe work system or operator error. This indicates that many of these incidents can be avoided if the risks of working with abrasive wheels are clearly communicated, and the correct safety measures are adopted, Abrasive Wheels Training will eliminate most accidents with Abrasive Wheels. With the appropriate Abrasive wheels training in place, you could significantly reduce the risk of an injury such as friction burns, crushed fingers and loss of eyesight which are the most common amongst abrasive wheel operators with the misuse of machines. This Abrasive Wheels Training Course is designed to assist in reducing the risk of injury for anyone who uses abrasive wheels at work. It guides you through the different types of abrasive wheels, how to identify and store them, how they should be used safely, and how they should be inspected prior to use. Our Abrasive Wheels Training will give all candidates hands-on practical training. Book with Confidence at Vally Plant Training At Vally Plant Training, we guarantee unbeatable value with our Price Match Promise. When you choose us, you can book with confidence, knowing that we will not be beaten on price. If you find a lower price for the same NPORS Experienced Worker Test, we’ll match it—ensuring you receive top-quality training at the best possible rate. Your skills, our commitment—always at the best price. Abrasive Wheels Course Duration 3-4 Hours Petrol Cut Off Saw 1 Day for all candidates Certification NPORS Traditional card – lasts for 5 years and is mainly accepted with housebuilders, utilities, port and marine as proof of competence OR NPORS card with CSCS logo – accepted by all major building contractor’s. The initial card is the RED trained operator card which lasts for 2 years and can be upgraded to BLUE competent operator card further to completion of relevant NVQ. In house certificates: suitable as proof of operator competence accepted for insurance and HSE compliance. Introduction to Abrasive Wheels Definition of Abrasive Wheels Abrasive wheels are tools used for cutting, grinding, and polishing various materials. They are made from abrasive particles, like grit, bonded together to form a solid wheel. When these wheels spin at high speeds, they can shape or finish different surfaces effectively. Types of Abrasive Wheels Commonly Used in Industry Bonded Abrasive Wheels: These are made by combining abrasive particles with a bonding material to form a solid wheel. Bonded abrasive wheels are typically used for tasks like grinding, cutting, and finishing metal or stone. Coated Abrasive Wheels: These have an abrasive layer attached to a backing material, like paper or cloth. Coated abrasive wheels are commonly used for sanding and smoothing surfaces, often in woodworking or metalworking. Abrasive wheel training is essential for learning how to use these tools safely and effectively. Understanding the different types of abrasive wheels and their applications can help you choose the right wheel for your job, ensuring efficiency and safety. Importance of Proper Training Overview of the Risks Associated with Improper Use Using abrasive wheels without proper training can be very dangerous. The importance of proper training cannot be overstated when it comes to the safe and effective use of abrasive wheels. Improper use of abrasive wheels can lead to serious accidents, such as wheel breakage, which can cause flying debris and severe injuries. Other risks include cuts, burns, and eye injuries from sparks or fragments. Not knowing how to handle the equipment properly can also result in damaged materials and inefficient work, leading to wasted time and resources. Benefits of Trained Versus Untrained Usage Undergoing abrasive wheel training is crucial for several reasons: Safety: Trained individuals know how to handle abrasive wheels safely, reducing the risk of accidents and injuries. They learn to inspect the wheels for damage, choose the right type of wheel for the job, and use protective gear correctly. Efficiency: Training ensures that users understand how to use abrasive wheels effectively, leading to faster and more accurate work. Trained users can achieve better results with less effort and time. Cost-Effectiveness: Proper training helps prevent damage to the wheels and the materials being worked on, saving money on replacements and repairs. It also minimizes downtime due to accidents or improper usage. Compliance: Many industries require certification for using abrasive wheels. Completing abrasive wheel training ensures compliance with safety regulations and industry standards, which is essential for legal and insurance purposes. In summary, abrasive wheel training equips users with the knowledge and skills needed to use abrasive wheels safely and efficiently, making the workplace safer and more productive. Getting Started with Abrasive Wheels Essential Equipment and Setup Before using abrasive wheels, it’s important to have the right equipment and ensure everything is set up properly. Here’s what you need: Protective Gear: Always wear safety goggles, gloves, ear protection, and a dust mask to protect yourself from flying debris, noise, and dust. Abrasive Wheels: Have a selection of abrasive wheels suitable for the tasks you plan to perform. This includes grinding wheels, cutting wheels, and sanding discs. Mounting Equipment: Ensure you have the correct flanges, spacers, and mounting hardware to secure the wheel to the machine properly. Tools and Machines: Use the appropriate tools and machines for your abrasive wheels, such as grinders, sanders, or cut-off saws. Make sure these machines are in good working condition. Work Area: Set up your work area with adequate lighting, ventilation, and space to move around safely. Ensure there are no flammable materials nearby. Completing an abrasive wheels training course will guide you on how to properly set up and use this equipment. Selecting the Right Wheel for the Job Choosing the right abrasive wheel is crucial for getting the job done efficiently and safely. Here’s how to select the right wheel: Material to Be Worked On: Different materials require different types of wheels. For example, use a grinding wheel for metal and a sanding disc for wood. Wheel Specification: Check the specifications of the wheel, including its grit size, bonding material, and hardness. Finer grits are better for finishing, while coarser grits are used for rough grinding. Machine Compatibility: Ensure the wheel is compatible with your machine. Check the wheel’s size, speed rating, and mounting requirements. Type of Task: Match the wheel to the task. Use cutting wheels for cutting, grinding wheels for grinding, and polishing wheels for finishing tasks. Enrolling in a grinding wheel training course can provide detailed guidance on selecting and using the right wheels for different jobs. Proper selection and setup not only improve efficiency but also enhance safety and prolong the life of the abrasive wheels. Safe Operation Techniques Step-by-Step Guide on How to Operate Abrasive Wheels Safely Inspect the Wheel: Before using any abrasive wheel, inspect it for cracks, chips, or other damage. Do not use a damaged wheel. Mount the Wheel Properly: Ensure the wheel is properly mounted on the machine. Follow the manufacturer’s instructions for correct mounting and balancing. Check Machine Guards: Make sure all safety guards are in place and functioning correctly. Guards help protect you from flying debris and accidental contact with the wheel. Wear Protective Gear: Always wear safety goggles, gloves, ear protection, and a dust mask to protect against sparks, noise, and dust. Start the Machine Safely: Stand to the side of the machine when starting it, not directly in front of the wheel. Allow the wheel to reach full speed before using it. Use Proper Technique: Apply light, even pressure to the workpiece. Avoid forcing the wheel or using excessive pressure, as this can cause the wheel to break. Maintain Control: Keep a firm grip on the tool or workpiece to prevent it from slipping or catching. Avoid Overheating: Use intermittent cuts and allow the wheel to cool down to avoid overheating, which can weaken the wheel and cause it to break. Regular Breaks: Take regular breaks to avoid fatigue, which can lead to mistakes and accidents. Completing an abrasive wheel training course can provide practical demonstrations of these safety techniques. Comparison with Other Cutting Methods Feature Abrasive Wheels Saws (Circular/Band) Laser Cutters Versatility High: Can cut metals, stone, ceramics. Moderate: Best for wood and certain metals. High: Can cut metals, plastics, composites. Precision High: Provides precise cuts and finishes. Moderate: Effective for straight cuts, less precise for intricate designs. Very High: Capable of intricate designs and clean cuts. Cost Low: Generally cheaper initial and maintenance costs. Moderate: Higher initial cost than abrasive wheels but longer lifespan. High: Expensive initial investment and maintenance costs. Portability High: Many tools are portable for on-site cutting and grinding. Low: Often require stationary setups. Low: Typically not portable and integrated into fixed setups. Safety Risks High: Requires proper training to prevent accidents (e.g., HSE, OSHA). Moderate: High-speed blades can be dangerous, need safety measures. Moderate: Requires specialized training to handle safety risks (e.g., reflective materials). Dust/Debris High: Generates significant dust and debris. Low: Produces less dust and debris. Very Low: Minimal dust and debris, cleaner cutting process. Wear and Tear High: Abrasive wheels wear down with use and need regular replacement. Low: Blades have a longer lifespan, less frequent replacement needed. Low: Lasers do not wear down, but components may need maintenance. Training Availability High: Numerous training courses available (e.g., HSE, OSHA). Moderate: Training available but not as comprehensive as abrasive wheel training. High: Specialized training required for safe operation and maintenance. Compliance High: Training helps meet regulatory requirements (e.g., PUWER 1998). Moderate: Safety training helps meet general safety regulations. High: Requires adherence to safety standards and protocols. Operational Speed Moderate: Suitable for detailed work, not as fast as saws for straight cuts. High: Faster cutting speeds for straight cuts. Moderate: Speed depends on material and thickness, generally slower than saws for thicker materials. Common Mistakes and How to Avoid Them Using a Damaged Wheel: Mistake: Using an abrasive wheel with cracks or chips. Solution: Always inspect the wheel before use and replace damaged wheels immediately. Improper Mounting: Mistake: Incorrectly mounting the wheel, leading to imbalance and breakage. Solution: Follow the manufacturer’s instructions and ensure the wheel is securely mounted. Skipping Protective Gear: Mistake: Not wearing safety gear, increasing the risk of injury. Solution: Always wear the recommended protective equipment, including goggles, gloves, and ear protection. Excessive Pressure: Mistake: Applying too much pressure, which can cause the wheel to break. Solution: Use light, even pressure and let the wheel do the work. Incorrect Wheel for the Job: Mistake: Using the wrong type of wheel for the material or task. Solution: Select the appropriate wheel based on the material and the task. Refer to the specifications and guidelines provided during abrasive wheels training. By understanding and avoiding these common mistakes, you can ensure safer and more efficient use of abrasive wheels. Proper training, like an abrasive wheel course, is essential to master these techniques and avoid potential hazards. Maintenance and Care Tips for Maintaining Abrasive Wheels Regular Cleaning: Clean the abrasive wheels regularly to remove any debris or buildup. Use a brush or compressed air to clean the wheel, ensuring it remains effective and prevents clogging. Proper Storage: Store abrasive wheels in a dry, cool place to prevent moisture damage. Keep them on a flat surface or in a vertical position to avoid warping or deformation. Wheel Dressing: Dress the wheel regularly using a wheel dresser to maintain its shape and expose fresh abrasive particles. This helps keep the wheel sharp and efficient. Avoid Overloading: Do not overload the wheel by forcing it to cut or grind faster than its capacity. Overloading can cause excessive wear and reduce the wheel’s lifespan. Use Correct Speed: Always operate the wheel at the recommended speed. Check the maximum speed rating of the wheel and ensure your machine does not exceed this limit. Balanced Use: Use the entire surface of the wheel evenly to prevent uneven wear. Avoid focusing on one spot for too long, which can create grooves and weaken the wheel. Lubrication: If applicable, use the appropriate lubricant to reduce friction and heat buildup. This can extend the life of the wheel and improve performance. How to Check for Wear and Damage Visual Inspection: Before each use, visually inspect the wheel for cracks, chips, or other damage. A damaged wheel can be dangerous and should be replaced immediately. Sound Test: Perform a sound test by gently tapping the wheel with a non-metallic object (like a wooden handle). A clear ringing sound indicates the wheel is intact, while a dull sound suggests it may be cracked and unsafe to use. Check for Unusual Vibrations: When the wheel is running, check for unusual vibrations or wobbling. This can indicate imbalance or damage. Stop using the wheel if you notice these signs and inspect it further. Measure Wheel Wear: Measure the diameter of the wheel regularly to monitor wear. Replace the wheel when it reaches the minimum usable diameter specified by the manufacturer. Surface Condition: Examine the surface of the wheel for glazing or loading. A glazed wheel appears shiny and smooth, indicating it is worn out and needs dressing or replacement. A loaded wheel is clogged with material and may require cleaning or dressing. Mounting Hardware: Check the flanges, spacers, and other mounting hardware for wear or damage. Ensure they are secure and in good condition to maintain proper wheel alignment. Regular maintenance and careful inspection of abrasive wheels can significantly extend their lifespan and ensure safe, efficient operation. Abrasive wheels training provides detailed guidelines on maintaining and checking wheels for wear and damage, helping users develop good maintenance habits. Health and Safety Guidelines Detailed Safety Precautions and Protective Gear Wear Appropriate Protective Gear: Safety Goggles or Face Shield: Protect your eyes and face from flying debris and sparks. Gloves: Wear sturdy gloves to protect your hands from sharp edges and hot materials. Ear Protection: Use earplugs or earmuffs to protect your hearing from the noise produced by grinding operations. Dust Mask or Respirator: Prevent inhalation of dust and particles, especially when working with materials that produce harmful dust. Apron or Protective Clothing: Wear a durable apron or long-sleeved clothing to shield your body from sparks and debris. Machine Safety Checks: Guarding: Ensure all machine guards are in place and secure before operation. Speed Check: Confirm that the machine’s speed does not exceed the wheel’s maximum rated speed. Work Area: Keep the work area clean and free of clutter to prevent tripping hazards. Safe Operation Practices: Proper Setup: Mount the abrasive wheel correctly, following the manufacturer’s instructions. Ensure it is balanced and secure. Correct Usage: Use the abrasive wheel only for its intended purpose. Avoid side grinding unless the wheel is specifically designed for it. Pressure Application: Apply light, even pressure to avoid overloading the wheel and causing it to break. Regular Inspections: Pre-Use Inspection: Check the wheel for any cracks, chips, or signs of wear before each use. During Use: Monitor the wheel for unusual vibrations or noises, and stop the machine immediately if any issues arise. What to Do in Case of an Accident Immediate Response: Stop the Machine: Turn off the machine immediately to prevent further injury. First Aid: Administer first aid for minor injuries. This may include cleaning cuts, applying bandages, and using cold compresses for burns or abrasions. Seek Medical Help: For serious injuries, seek professional medical assistance immediately. Call emergency services if necessary. Report the Incident: Inform Supervisors: Report the accident to your supervisor or safety officer. Provide details about how the incident occurred and the extent of the injuries. Document the Incident: Fill out an accident report form, including information about the equipment used, the nature of the injury, and any contributing factors. Review and Improve Safety Practices: Incident Analysis: Analyze the accident to determine its cause. Review whether safety protocols were followed and identify any gaps in training or equipment maintenance. Safety Training: Consider additional abrasive wheels training or a refresher course to reinforce safe practices and prevent future accidents. Online courses can be a convenient way to update your knowledge. Preventive Measures: Review Procedures: Ensure that all safety procedures are up-to-date and that all employees are familiar with them. Safety Drills: Conduct regular safety drills to prepare for potential accidents and improve response times. Legal Requirements and Certifications Overview of Relevant Laws and Regulations Using abrasive wheels involves adhering to specific safety laws and regulations to ensure the safety and health of workers. Here’s an overview of the key legal requirements: Occupational Safety and Health Administration (OSHA): In the United States, OSHA sets standards for the safe use of abrasive wheels. Employers must comply with OSHA regulations, including proper machine guarding, employee training, and the use of personal protective equipment (PPE). Provision and Use of Work Equipment Regulations (PUWER): In the UK, PUWER requires that work equipment, including abrasive wheels, is suitable for its intended use, properly maintained, and only operated by trained personnel. European Safety Standards: In Europe, EN 12413 is the standard for bonded abrasive products. It sets out requirements for safety, marking, and product testing to ensure the safe use of abrasive wheels. Regular Inspections and Maintenance: Laws often require regular inspections and maintenance of abrasive wheels and related machinery to ensure they remain in safe working condition. Record Keeping: Employers must keep records of all training, inspections, and maintenance activities related to abrasive wheels. How to Get Certified in Abrasive Wheels Training Getting certified in abrasive wheels training involves completing a recognized course and passing the necessary assessments. Here’s how you can achieve certification: Find a Training Provider: Look for accredited training providers that offer courses on abrasive wheels. Valley Plant Training is a well-known provider that offers comprehensive abrasive wheel training courses. You can also search for “abrasive wheel training near me” to find local providers or explore online options. Enroll in an Abrasive Wheel Course: Choose a course that covers both theoretical and practical aspects of abrasive wheel safety. The course should include topics such as wheel selection, proper mounting, safe operation techniques, and maintenance. Valley Plant Training offers courses that meet these criteria. Complete the Training: Attend the training sessions and participate actively. Training can be done in-person or online, depending on your preference and availability. Online courses can be convenient and flexible for busy schedules. Pass the Assessment: At the end of the course, you’ll need to pass an assessment to demonstrate your understanding of the material. This may include a written test and a practical demonstration of your skills. Receive Your Abrasive Wheels Certificate: Upon successful completion of the course and assessment, you will receive an abrasive wheels certificate. This certificate is proof that you have been trained in the safe use of abrasive wheels. Regular Refresher Courses: It’s important to stay updated with the latest safety practices and regulations. Consider taking refresher courses periodically to keep your skills and knowledge current. Valley Plant Training also offers refresher courses to help you stay up-to-date. Obtaining an abrasive wheel training certification from Valley Plant Training or another reputable provider not only enhances your safety and efficiency but also ensures compliance with legal requirements. It demonstrates to employers and regulatory bodies that you are qualified to handle abrasive wheels safely and effectively. Frequently Asked Questions What is abrasive wheel training? This is a training course that teaches you how to safely use and take care of machines that have abrasive wheels, like grinders. It covers choosing the right wheel, setting it up, and learning safety rules to prevent accidents. How much does abrasive wheels training cost? The price can change depending on where you are and who’s teaching the course. Generally, it might cost between £150.00 and £250 for the basic training. How long does abrasive wheels training last? Most basic courses take about a day to complete, around 6 to 8 hours. More detailed courses might take longer, especially if they include hands-on practice. Can abrasive wheel training be done online? Yes, you can learn the theory part online at your own pace. For learning how to actually use the wheels, you might need to attend a session in person to get practical experience. What are the two types of abrasive wheels? There are two main kinds: bonded and coated abrasive wheels. Bonded wheels are made of abrasive particles stuck together and are used for tasks like grinding or cutting. Coated wheels have a layer of abrasive glued to a backing material and are used for smoothing surfaces. What are the rules for abrasive wheels? The main rules include setting up the wheel correctly, wearing the right safety gear, checking the wheel regularly for damage, and following specific steps when using it to stay safe. There are also official safety standards you need to follow. Testing Of Candidates We will assess the delegates throughout the course on their levels of participation and understanding, they will demonstrate the inspection of various Abrasive wheels for damage and suitability. Then the delegates will complete a 25 question assessment paper at the end of the course. Successful delegates will be issued with the NPORS operator card Abrasive Wheels Training Covers: The requirements of the HASAW and PUWER and all associated regulations in respect of Abrasive Wheels. Hazards arising from the use of Abrasive Wheels and the precautions that should be taken. How to identify the Abrasive Wheel types and characteristics. Storage, handling and transportation of Abrasive Wheels. Inspecting and testing Abrasive Wheels. Personal protective equipment. Abrasive Wheels Training Available 7 days a week to suit your business requirements. VPT have a team of friendly and approachable instructors, who have a wealth of knowledge of abrasive wheels and the construction industry We have our own training centre for abrasive wheels conveniently located close to the M5 junction 9, In Tewkesbury. With its own purpose-built practical training area to simulate an actual working environment. Our abrasive wheels training and test packages are priced to be competitive. Discounts are available for multiple bookings We can send a fully qualified NPORS abrasive wheels Tester to your site nationwide, to reduce the amount of time away from work Other course: Enhance your skills with our specialized courses, including Lift Supervision Training, Appointed Person Training, Telehandler Training, Cat & Genny Training, Slinger Signaller Training, Lorry Loader Training and Crusher Training. Each program is designed to equip you with the expertise needed for excellence in your field.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for SQL Server administrators who work in a Windows network environment. At least one year of experience administering SQL Servers and using PowerShell is recommended. Overview After completing this course, students will be able to: •Install and Configure SQL Server and all its components using PowerShell •Manage day-to-day SQL Server Administration with PowerShell •Maintain the SQL Server environment using PowerShell scripting and programming options This course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. Students will learn how to manage day-to-day and scheduled maintenance tasks. Install and Configure SQL Server with PowerShell Install SQL Server Configure Database Settings Configure SQL Server Settings Configure SQL Server Policy-Based Management Lab 1: Configuring SQL Server with PowerShell Administering SQL Servers with PowerShell Managing Users and Roles Managing Database Performance Managing Database Availability Managing SQL Server Features Lab 1: Administering SQL Servers with PowerShell Maintaining SQL Server with PowerShell Managing Backups and Restores Maintaining Database Integrity and Performance Monitoring and Auditing Task Automation Generating Reports Lab 1: Maintaining SQL Servers with PowerShell

Duration 1 Days 6 CPD hours This course is intended for The ProxySG 6.6 Diagnostics and Troubleshooting course is intended for students who wish to gain familiarity with ProxySG troubleshooting techniques and tools. Overview By the completion of this course, you will be able to:Describe the troubleshooting methodology as recommended by Symantec.Diagnose and solve a variety of access and performance issues using tools such as sysinfo files, packet captures, and policy traces. The ProxySG 6.6 Diagnostics and Troubleshooting course provides a structured approach to diagnosing and solving common troubleshooting issues related to ProxySG deployments. The course will emphasize hands-on experience, with extensive opportunities to build competency in the use of the powerful diagnostic tools available on the ProxySG. ProxySG Secure Web Gateway? Overview of Typical Troubleshooting Issues Overview of common issues related to internal resources, external dependencies, SSL interception, and policy efficiency. Introduction to how to use sysinfo files to gain useful troubleshooting information. Troubleshooting Issues Related to External Dependencies Methods for diagnosing and solving authentication issues. Methods for diagnosing and solving DNS issues. Troubleshooting SSL Interception Issues Methods for diagnosing and solving issues related to SSL interception. Troubleshooting Performance Issues Related to Policy Efficiency Methods for optimizing performance through tips for creating more efficient policies.

Duration 4 Days 24 CPD hours This course is intended for Project administrators and ETL developers responsible for data extraction and transformation using DataStage. Overview Describe the uses of DataStage and the DataStage workflowDescribe the Information Server architecture and how DataStage fits within itDescribe the Information Server and DataStage deployment optionsUse the Information Server Web Console and the DataStage Administrator client to create DataStage users and to configure the DataStage environmentImport and export DataStage objects to a fileImport table definitions for sequential files and relational tablesDesign, compile, run, and monitor DataStage parallel jobsDesign jobs that read and write to sequential filesDescribe the DataStage parallel processing architectureDesign jobs that combine data using joins and lookupsDesign jobs that sort and aggregate dataImplement complex business logic using the DataStage Transformer stageDebug DataStage jobs using the DataStage PX Debugger This course enables the project administrators & developers to acquire the skills necessary to develop parallel jobs in DataStage. Students will learn to create parallel jobs that access sequential & relational data, and combine and transform the data. Course Outline Introduction to DataStage Deployment DataStage Administration Work with Metadata Create Parallel Jobs Access Sequential Data Partitioning and Collecting Algorithms Combine Data Group Processing Stages Transformer Stage Repository Functions Work with Relational Data Control Jobs

Duration 5 Days 30 CPD hours This course is intended for Anyone whose position requires CCSP certificationIndividuals whose responsibilities involve procuring, securing, and managing cloud environments or purchased cloud services Overview In-depth coverage of the six domains required to pass the CCSP exam:Architectural concepts and design requirementsCloud data securityCloud platform and infrastructure securityCloud application securityOperationsLegal and compliance This course is the most comprehensive review of cloud security concepts and industry best practices covering the six domains of the CCSP Common Body of Knowledge (CBK). You will gain knowledge in identifying the types of controls necessary to administer various levels of confidentiality, integrity, and availability, with regard to securing data in the cloud. You will identify the virtual and physical components of the cloud infrastructure with regard to risk management analysis, including tools and techniques necessary for maintaining a secure cloud infrastructure. You will gain an understanding in cloud software assurance and validation, utilizing secure software, and the controls necessary for developing secure cloud environments. You will identify privacy issues and audit processes utilized within a cloud environment, including auditing controls, assurance issues, and the specific reporting attributes. Architectural Concepts and Design Requirements Cloud Data SecurityCloud Platform and Infrastucture Security Cloud Application SecurityOperations Legal and compliance

Duration 5 Days 30 CPD hours This course is intended for Application Consultants, Business Analysts, Program/Project Managers, System Architects Overview At the end of this course, students will be able to explain and use major features of SAP Extended Warehouse Management. This course will give you a solid fundamental and comprehensive overview of SAP Extended Warehouse Management and is a mandatory prerequisite for all other EWM courses. Warehousing Structures and Master Data Differentiating the SAP Solutions for Warehouse Management Outlining Organizational Structures Maintaining Master Data for SAP EWM Warehouse Monitoring & Processing with Mobile Devices Managing the Warehouse Outlining the Radio Frequency (RF) Framework Additional Functions in SAP EWM Applying Storage Control Employing Serial Numbers Processing Batches Mapping Quality Inspection Processes Applying Value-Added Services Warehouse Organization Performing Slotting Applying Replenishment Methods Performing a Physical Inventory Optimization of Resources Applying Wave Management Applying Labor Management Executing the Production Supply Process Executing Expected Goods Receipts Processes Applying Cross Docking Warehouse Extensions Planning the Shipping and Receiving of Products Controlling the Material Flow System (MFS) SAP EWM Rapid Deployment Solution Accelerating Implementation Processes Combined Inbound and Outbound Processes Executing an End-to-End Process with SAP EWM