Duration 1 Days 6 CPD hours This course is intended for This course is intended for people who use PowerPoint for their business communication needs. Overview To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to open and close applications, navigate basic file structures, and manage files and folders. This course is intended for those who wish to take advantage of the application for high quality business presentations and reports. Presentations Create Attractive Presentations from Existing PowerPoint Templates Creating Presentations Quickly using Outline to build a Structure Incorporating and reusing slides from other presentations into your own Templates and Customization Using Slide Layouts Using the Slide Master Creating Custom Slide Layout Working with Charts and Tables Create and Modify Tables Create Charts and Graphs Copying Charts into PowerPoint Link Vs Embed Add Visual Elements to a Presentation Create and Modify Shapes Add Images Create SmartArt to Make Easily Modifiable graphics Use SmartArt to Give Dull Text a More Visual Appeal Working with Media and Animation Add Audio to A Presentation Add Video to A Presentation Add and Customize Animations Add and Customize Transitions Preparing to Present Add Notes to A Presentation Presenter View And Slide Show Controls Create A Custom Slide Show Saving and Sharing the Presentation Printing Options and Handouts Additional course details: Nexus Humans Microsoft PowerPoint for the Business User 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 Microsoft PowerPoint for the Business User 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.
THIS COURSE PACKAGE INCLUDES: 1: INTRODUCTION TO PHLEBOTOMY COURSE (GPT003) - Level 3 (Ireland Level 5) 2: ADVANCED PHLEBOTOMY COURSE (GPT005) - Level 4 (Ireland Level 6) 3: GEOPACE COMPETENCY CERTIFICATE - CPD Certified (optional with Virtual Classroom) Learn how to take blood ... train as a Phlebotomist FAST-TRACK YOUR PHLEBOTOMY TRAINING WITH OUR COMPLETE TRAINING PACKAGE 20% off - Multi-Course Discount Cover all stages from beginner through to Level 4 Available as Classroom or Virtual Classroom Complete your beginner to advanced training in 2 days Awards 2 accredited qualifications - Introduction to Phlebotomy and Advanced Phlebotomy qualifications Both courses are dually accredited (OCN & CPD) Geopace Certificate of Competency included with classroom attendance or available as an option when booking virtual classroom Covers all steps up to live blood draw Learn advanced skills and techniques Virtual Classroom options include comprehensive Practise@Home Training Kits (yours to keep) Basic understanding of English language required OPEN TO ALL APPLICANTS
Next step of dog training for dogs 10 months and older. This 6 week course where the classes encompasses a comprehensive range of essential skills and behaviours. You will attend 6 x 30-minute training classes Mancetter Memorial Hall, Old Farm Road, Mancetter, Atherstone, Warwickshire, CV9 1QN.
Airline Cabin Crew also known as: Air Hostess, Flight Attendant and Stewardess. This intensive class based – 10 weeks, part-time (lessons once a week) course will give you all information and tools you will need to succeed. Enter the world of possibilities, adventure and travel with leading Airline Cabin Crew course Provider in the UK. Flight Attendant, Cabin Crew, Stewardess, Air Hostess – Regardless of what this career is called in your part of the world, we have the training program for you. Join the elite team of flight attendants and experience the thrill of flying while making a difference in people’s journey. Fly the world and get paid for it! Join our Airline Cabin Crew course and take the first step towards an exciting career in the skies. Our Airline Cabin Crew course is designed to make you ready for the job. This intensive class based 10 weeks (part time) Airline Cabin Crew course will give you all information and tools you will need to become successful job candidate. You will have one class per week for ten consecutive weeks. Our Aviation Team provide full support to each candidate who wish to become Airline Cabin Crew or start a career in Aviation. We provide A-Z guidance starting from before and after the course. Our graduates are flying around the globe and we are confident that we can help to make your dream a reality! 98% Employment rate after completion of the course. Who is a Flight Attendant? Flight attendant/Airline Cabin Crew/Stewardess/Air Hostess are the most visible, glamorous jobs of all airline employees. A Flight Attendant is someone whose primary duty is to ensure the safety and comfort of passengers during a flight. They are members of an aircrew team , who operate a commercial, business or even military aircraft while travelling domestically or internationally. Flight Attendant benefits: Getting paid for travelling the world Lifestyle Flexible Work Schedules Meeting Interesting People Free Food & Accommodation Excellent Compensation The uniforms Working Environment How to become Flight Attendant?Airline companies look for individuals who share their values and can act as ambassadors for the company’s brand. Airline Cabin Crew are the face of the airline company which means they deliver a fantastic service that makes airline world famous. Airline companies prefer candidates with knowledge of Cabin Crew role. Airline companies have selection day or online tests as a first stage of recruitment, after which, they will take a closer look at applicants CV, skills and experience. If you completed Airline Cabin Crew course at least 70 hours (we offer 90 hour training), your application will stand out and you can get an offer from the first round. You will be able to pass all tasks during interview process as you will have knowledge about Cabin Crew role. Student – Cabin Crew Flying Support Group As a market leading Airline Cabin Crew Training Company with a wealth of experience in Aviation, we constantly upgrading our course and going extra nautical mile to guide and support all our students to ensure they can reach their goals. Graduates who are already flying, offer their full support to us and new students. They share an insight of the airline they already fly with, and help new students through the process of joining them at that airline. It gives a flying start to a career to new learners. Why London Waterloo Academy? Top Airline Cabin Crew course provider in London 98% Employment rate after completion of the course Individual support on the journey from the course to a job placement With years of experience in Airline Cabin Crew industry, London Waterloo Academy has been recognised by major TV, radio channels who have invited our Aviation Team for expert advice or interview. We are recognised by major airline companies in Europe and overseas who have approached London Waterloo Academy to deliver internal cabin crew training, corporate training and to recruit our graduates as a result of their high qualification standards and knowledge. Our graduates are now flying with Etihad, Saudi Air, Hainan Airlines, Small Planet, British Airways, Qatar, EasyJet, Thomas Cook, Ryanair, Cubana de Aviación, Air France,Titan, Norwegian B737 Short Haul and many more. You will become a qualified Cabin Crew, meet the standards and requirements by employers globally On successful completion you will hold: Airline Cabin Crew certificate in Current Airline Training Standards and Equipment, TUI, British Airways or Virgin Atlantic certificates for the SEP (Safety Equipment & Procedures) training Exclusive class visit by Leading Airline Representatives (questions and answers sessions) Exclusive practical training with TUI, Virgin Atlantic or British Airways We will enhance your CV Successful students will get an exclusive VIP hangar tour and a private aircraft recognition certificate of attendance Guidance through the job application process (free of charge) Gain an insight into the airline selection process and final one-to-one interview The vast global experience of our instructors Great working relationship with Corporate Crew Solution This course has been developed in accordance with EASA PART-CC We have a community feel atmosphere where each individual values and respects one another. This may be the reason why our graduates, even those who have completed the course many years ago, continue to come back not only for a chat and a cuppa, but also to share personal issues, tell us of their experience and give us invitations, among many other reasons. Working together – Starting a new career isn’t easy and often it can seem like a lonely and impossible process. Our Aviation Department stays behind each learner, supporting every step of the way. We give you tools, skills and assistance you need to succeed. Our success, built on the success of our students and a long list of graduates with successful stories. How will you learn? The course based on theory and external practical classes with British Airways, Virgin Atlantic or TUI Aviation includes: Aircraft door operations and Passenger Evacuation drills from the crew seat. A320 slide decent, Fire and Smoke drills. Pilot Incapacitation and Immediate Care drills including CPR and Defibrillator training. Course Entry Requirements: English Language at B2 (CEFR) level or above. We accept a huge range of international qualifications so don’t worry. Pop in for a chat with us if you’re unsure (or drop us a line – info@waterlooacademy.co.uk; or, if you prefer speaking to a human voice, +44(0)7484 014980). This is quite important because, for better or for worse, English is the international language. Therefore, your future fly-mates and customers would expect you to speak English. What if I speak broken English or have a strong accent? What can I do? Frantic mode ON. Don’t panic! As a multi-disciplinary Academy, we have a huge range of English language coursesclick here. Our English Language Department is one of the best in London. We are here to help. We won’t let you be deterred simply because of language issues. Courses can be combined, it will also boost your confidence when applying for the job or having an interview. What else do I need? Nothing! Our cabin crew course, as we’ve alluded before, is really good. We teach you everything you need to know from scratch. Since aviation is so different from other fields, we think, as long as you have the passion and determination, we are absolutely honoured to have you on board (pun most certainly intended)! Course dates (please choose one for your course): 15 May 2024 – 17 July 2024, Wednesday classes 18 September 2024 – 20 November 2024, Wednesday classes 14 November 2024 – 16 January 2025, Thursday classes Course duration – 10 weeks, once a week classes. Available Study mode – class based, Virtual (via Zoom) and hybrid Time – 10am to 5pm Registration fee for UK/EU candidates– £300 (includes: examination, Airline Cabin Crew certificate in Current Airline Training Standards and Equipment, participation certificate by TUI/British Airways or Virgin Atlantic in Introduction to SEP (Safety Equipment & Procedures, please note this is not a Cabin Crew attestation)) Tuition fee – £829 (we offer flexible payment plan and accept weekly instalments) International Candidates – Check if you need a UK visa here – £1,729 must be paid in full on registration. In case of visa refusal only £300 will be refunded.
Duration 5 Days 30 CPD hours This course is intended for This course is designed for anyone seeking CCNA certification. The course also provides foundational knowledge for all support technicians involved in the basic installation, operation, and verification of Cisco networks. The job roles best suited to the material in this course are: Entry-level network engineer Network administrator Network support technician Help desk technician Overview This course will help you: Learn the knowledge and skills to install, configure, and operate a small- to medium-sized network Gain a foundation in the essentials of networking, security, and automation Earn 30 CE credits toward recertification The Implementing and Administering Cisco Solutions (CCNA) v2.0 course gives you a broad range of fundamental knowledge for all IT careers. Through a combination of lecture, hands-on labs, and self-study, you will learn how to install, operate, configure, and verify basic IPv4 and IPv6 networks. The course covers configuring network components such as switches, routers, and wireless LAN controllers; managing network devices; and identifying basic security threats. The course also gives you a foundation in network programmability, automation, and software-defined networking. This course helps you prepare to take the 200-301 Cisco© Certified Network Associate (CCNA©) exam. By passing this one exam, you earn the CCNA certification. This course also earns you 30 Continuing Education (CE) credits towards recertification. Course Outline Exploring the Functions of Networking ? Lecture Introducing the Host-to-Host Communications Model ? Lecture Operating Cisco IOS Software ? Lecture Introducing LANs ? Lecture Exploring the TCP/IP Link Layer ? Lecture Starting a Switch ? Lecture Introducing the TCP/IP Internet Layer, IPv4 Addressing, and Subnets ? Lecture Explaining the TCP/IP Transport Layer and Application Layer ? Lecture Exploring the Functions of Routing ? Lecture Configuring a Cisco Router ? Lecture Exploring the Packet Delivery Process ? Lecture Troubleshooting a Simple Network ? Lecture Introducing Basic IPv6 ? Lecture Configuring Static Routing ? Lecture Implementing VLANs and Trunks ? Lecture Routing Between VLANs ? Lecture Introducing OSPF ? Lecture Building Redundant Switched Topologies ? Self-study Improving Redundant Switched Topologies with EtherChannel ? Lecture Exploring Layer 3 Redundancy ? Self-study Introducing WAN Technologies ? Self-study Explaining Basics of ACL ? Lecture Enabling Internet Connectivity ? Lecture Introducing QoS ? Self-study Explaining Wireless Fundamentals ? Self-study Introducing Architectures and Virtualization ? Self-study Explaining the Evolution of Intelligent Networks ? Lecture Introducing System Monitoring ? Lecture Managing Cisco Devices ? Lecture Examining the Security Threat Landscape ? Self-study Additional course details: Nexus Humans Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA) 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 Cisco Implementing and Administering Cisco Solutions v2.0 (CCNA) 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 “ISO 22301:2019 Lead Implementer ” course provides comprehensive training in the ISO 22301:2019 standard and all its requirements from the Implementer ’s point of view, as well as basic skills necessary to execute the requirements. It’s a practical-oriented training that should be considered “a must” for every ISO 22301:2019 Implementer. This intensive course is specifically designed to participants to serve as ISO 22301:2019 Lead Implementers. The interactive training program, complete with quizzes, will provide the necessary technical knowledge and understanding of all ISO 22301:2019 requirements to implement the requirement of the standard.
Develop your technical report writing and presentation skills with EnergyEdge's course designed for oil & gas professionals. Sign up now!
Duration 5 Days 30 CPD hours This course is intended for The Certified Ethical Hacking v12 course will significantly benefit security officers, auditors, security professionals, site administrators, and anyone who is concerned about the integrity of the network infrastructure. Overview Information security controls, laws, and standards. Various types of footprinting, footprinting tools, and countermeasures. Network scanning techniques and scanning countermeasures Enumeration techniques and enumeration countermeasures Vulnerability analysis to identify security loopholes in the target organization?s network, communication infrastructure, and end systems. System hacking methodology, steganography, steganalysis attacks, and covering tracks to discover system and network vulnerabilities. Different types of malware (Trojan, Virus, worms, etc.), system auditing for malware attacks, malware analysis, and countermeasures. Packet sniffing techniques to discover network vulnerabilities and countermeasures to defend against sniffing. Social engineering techniques and how to identify theft attacks to audit human-level vulnerabilities and social engineering countermeasures. DoS/DDoS attack techniques and tools to audit a target and DoS/DDoS countermeasures. Session hijacking techniques to discover network-level session management, authentication/authorization, and cryptographic weaknesses and countermeasures. Webserver attacks and a comprehensive attack methodology to audit vulnerabilities in webserver infrastructure, and countermeasures. Web application attacks, comprehensive web application hacking methodology to audit vulnerabilities in web applications, and countermeasures. SQL injection attack techniques, injection detection tools to detect SQL injection attempts, and countermeasures. Wireless encryption, wireless hacking methodology, wireless hacking tools, and Wi-Fi security tools. Mobile platform attack vector, android vulnerability exploitations, and mobile security guidelines and tools. Firewall, IDS and honeypot evasion techniques, evasion tools and techniques to audit a network perimeter for weaknesses, and countermeasures. Cloud computing concepts (Container technology, serverless computing), the working of various threats and attacks, and security techniques and tools. Penetration testing, security audit, vulnerability assessment, and penetration testing roadmap. Threats to IoT and OT platforms and defending IoT and OT devices. Cryptography ciphers, Public Key Infrastructure (PKI), cryptography attacks, and cryptanalysis tools. CEH provides an in-depth understanding of ethical hacking phases, various attack vectors, and preventative countermeasures. It will teach you how hackers think and act maliciously so you will be better positioned to setup your security infrastructure and defend against future attacks. An understanding of system weaknesses and vulnerabilities helps organizations strengthen their system security controls to minimize the risk of an incident. CEH was built to incorporate a hands-on environment and systematic process across each ethical hacking domain and methodology, giving you the opportunity to work towards proving the required knowledge and skills needed to achieve the CEH credential. You will be exposed to an entirely different posture toward the responsibilities and measures required to be secure. Now in its 12th version, CEH continues to evolve with the latest operating systems, tools, tactics, exploits, and technologies. 1 - Introduction to Ethical Hacking Information Security Overview Cyber Kill Chain Concepts Hacking Concepts Ethical Hacking Concepts Information Security Controls Information Security Laws and Standards 2 - 2 - Foot-printing and Reconnaissance Footprinting Concepts Footprinting through Search Engines Footprinting through Web Services Footprinting through Social Networking Sites Website Footprinting Email Footprinting Who is Footprinting DNS Footprinting Network Footprinting Footprinting through Social Engineering Footprinting Tools Footprinting Countermeasures 3 - Scanning Networks Network Scanning Concepts Scanning Tools Host Discovery Port and Service Discovery OS Discovery (Banner Grabbing/OS Fingerprinting) Scanning Beyond IDS and Firewall Draw Network Diagrams 4 - Enumeration Enumeration Concepts NetBIOS Enumeration SNMP Enumeration LDAP Enumeration NTP and NFS Enumeration SMTP and DNS Enumeration Other Enumeration Techniques Enumeration Countermeasures 5 - Vulnerability Analysis Vulnerability Assessment Concepts Vulnerability Classification and Assessment Types Vulnerability Assessment Solutions and Tools Vulnerability Assessment Reports 6 - System Hacking System Hacking Concepts Gaining Access Escalating Privileges Maintaining Access Clearing Logs 7 - Malware Threats Malware Concepts APT Concepts Trojan Concepts Virus and Worm Concepts Fileless Malware Concepts Malware Analysis Countermeasures Anti-Malware Software 8 - Sniffing Sniffing Concepts Sniffing Technique: MAC Attacks Sniffing Technique: DHCP Attacks Sniffing Technique: ARP Poisoning Sniffing Technique: Spoofing Attacks Sniffing Technique: DNS Poisoning Sniffing Tools Countermeasures Sniffing Detection Techniques 9 - Social Engineering Social Engineering Concepts Social Engineering Techniques Insider Threats Impersonation on Social Networking Sites Identity Theft Countermeasures 10 - Denial-of-Service DoS/DDoS Concepts DoS/DDoS Attack Techniques BotnetsDDoS Case Study DoS/DDoS Attack Tools Countermeasures DoS/DDoS Protection Tools 11 - Session Hijacking Session Hijacking Concepts Application Level Session Hijacking Network Level Session Hijacking Session Hijacking Tools Countermeasures 12 - Evading IDS, Firewalls, and Honeypots IDS, IPS, Firewall, and Honeypot Concepts IDS, IPS, Firewall, and Honeypot Solutions Evading IDS Evading Firewalls IDS/Firewall Evading Tools Detecting Honeypots IDS/Firewall Evasion Countermeasures 13 - Hacking Web Servers Web Server Concepts Web Server Attacks Web Server Attack Methodology Web Server Attack Tools Countermeasures Patch Management Web Server Security Tools 14 - Hacking Web Applications Web Application Concepts Web Application Threats Web Application Hacking Methodology Web API, Webhooks, and Web Shell Web Application Security 15 - SQL Injection SQL Injection Concepts Types of SQL Injection SQL Injection Methodology SQL Injection Tools Evasion Techniques Countermeasures 16 - Hacking Wireless Networks Wireless Concepts Wireless Encryption Wireless Threats Wireless Hacking Methodology Wireless Hacking Tools Bluetooth Hacking Countermeasures Wireless Security Tools 17 - Hacking Mobile Platforms Mobile Platform Attack Vectors Hacking Android OS Hacking iOS Mobile Device Management Mobile Security Guidelines and Tools 18 - IoT and OT Hacking IoT Hacking IoT Concepts IoT Attacks IoT Hacking Methodology IoT Hacking Tools Countermeasures OT Hacking OT Concepts OT Attacks OT Hacking Methodology OT Hacking Tools Countermeasures 19 - Cloud Computing Cloud Computing Concepts Container Technology Serverless Computing Cloud Computing Threats Cloud Hacking Cloud Security 20 - Cryptography Cryptography Concepts Encryption Algorithms Cryptography Tools Public Key Infrastructure (PKI) Email Encryption Disk Encryption Cryptanalysis Countermeasures Additional course details: Nexus Humans EC-Council Certified Ethical Hacker (CEH) v.12 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 EC-Council Certified Ethical Hacker (CEH) v.12 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.
Duration 5 Days 30 CPD hours This course is intended for This course is intended for anyone who is new to software development and wants, or needs, to gain an understanding of programming fundamentals and object-oriented programming concepts. They will typically be high school students, post-secondary school students, or career changers, with no prior programming experience. They might want to gain an understanding of the core programming fundamentals before moving on to more advanced courses such as Programming in C#. Overview Explain core programming fundamentals such as computer storage and processing. Explain computer number systems such as binary. Create and use variables and constants in programs. Explain how to create and use functions in a program. Create and use decisions structures in a computer program. Create and use repetition (loops) in a computer program. Explain pseudocode and its role in programming. Explain the basic computer data structures such as arrays, lists, stacks, and queues. Implement object-oriented programming concepts. Create and use classes in a computer program. Implement encapsulation, inheritance, and polymorphism. Describe the base class library (BCL) in the .NET Framework. Explain the application security concepts. Implement simple I/O in a computer program. Identify application errors and explain how to debug an application and handle errors. Identify the performance considerations for applications. In this 5-day course, students will learn the basics of computer programming through the use of Microsoft Visual Studio 2022 and the Visual C# and Visual Basic programming languages. The course assumes no prior programming experience and introduces the concepts needed to progress to the intermediate courses on programming, Programming in C#. The focus will be on core programming concepts such as computer storage, data types, decision structures, and repetition by using loops. The course also covers an introduction to object-oriented programming covering classes, encapsulation, inheritance, and polymorphism. Coverage is also included around exception handling, application security, performance, and memory management. 1 - Introduction to Core Programming Concepts Computer Data Storage and Processing Application Types Application Lifecycle Code Compilation 2 - Core Programming Language Concepts Syntax Data Types Variables and Constants 3 - Program Flow Introduction to Structured Programming Concepts Introduction to Branching Using Functions Using Decision Structures Introducing Repetition 4 - Algorithms and Data Structures Understand How to Write Pseudocode Algorithm Examples Introduction to Data Structures 5 - Error Handling and Debugging Introduction to Program Errors Introduction to Structured Error Handling Introduction to Debugging 6 - Introduction to Object-Oriented Programming Introduction to Complex Structures Introduction to Structs Introduction to Classes Introducing Encapsulation 7 - More Object-Oriented Programming Introduction to Inheritance Introduction to Polymorphism Introduction to .NET and the Base Class Library 8 - Introduction to Application Security Authentication and Authorization Code Permissions on Computers Introducing Code Signing 9 - Core I/O Programming Using Console I/O Using File I/O 10 - Application Performance and Memory Management Value Types vs Reference Types Converting Types The Garbage Collector Additional course details: Nexus Humans 55337 Introduction to Programming 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 55337 Introduction to Programming 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.
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.