4517 Security courses in Thornton delivered Online

With the global financial markets in such turmoil, many people are looking for security in ways they may not have considered previously. This Creating a Business Start-Up course is designed for students who want to learn the skills and knowledge required to develop a start-up. It is crucial that you create an effective plan that will allow you to test your product or service and make any necessary changes and improvements. It all starts with developing a successful business idea. This Creating a Business Start-Up course comprises several modules that will look into a different aspects of this subject. It will provide learners with an understanding of the initial processes and requirements of a Start-Up, as well as knowledge of the first steps in Start-Up, including marketing, legal, and financial requirements, as well as an understanding of how to write a business plan. Learning Outcomes After completing this Creating a Business Start-Up course, you will be able to: Understand the steps for a business start-up. Understand what is required of you to start your own business. Polish your business idea. Build your competitive advantages. Increase self-awareness and aid personal development. Develop a Start-up Business Plan. Why Choose Business START UP Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Free PDF certificate as soon as completing the course. Other courses are included with Creating a Business Start-Up Bundle Course Course 01: Creating a Business Start-Up Course 02: Level 5 Diploma in Business Analysis Course 03: Level 7 Diploma in Facilities Management Course Course 04: Minute Taking Course Course 05: Level 5 Diploma in Risk Management Course Course 06: Level 7 Business Management Course Course 07: Level 7 Diploma in Leadership and Management Course ***Others Included in this Course Free 7 PDF Certificate Access to Content - Lifetime Exam Fee - Totally Free Free Retake Exam [ Note: Free PDF certificate as soon as completing the course ] ***Creating a Business Start-Up*** Detailed course curriculum Module 1: Fundamental Steps for a Business Start-up Basic Requirements of an Entrepreneur Identify the Type and Field of Business that is More Suitable for You Identify Your Skills and Creativity Related to New Business Opportunities Analyse the Commercial Potential of a Business Opportunity Module 2: Strategic Thinking about New Business Solving a Problem Beating the Deadlines Finding Products in Short Supply Opportunities Created by News or Events Investigating the Internet Thinking Start-to-finish Niche Strategies Demographic Trends Rethink Assumptions Module 3: The Best Business Ideas for You Case Study Screen Your Ideas List Field Study SWOT Analysis Module 4: Developing a Start-up Business Plan Introduction of Start-up Business Plan Executive Summary Company Description Products & Services Marketing Plan Operational Plan Management & Organisation Startup Expenses & Capitalization Financial Plan -------------- ***Level 5 Diploma in Business Analysis*** Module 01: What is a Business Analyst? Module 02: What Makes a Good Business Analyst? Module 03: Roles of the Business Analyst Module 04: The Business Analyst and the Solution Team Module 05: Define the Problem Module 06: Vision Phase Module 07: Process Phase - Gather The Information Module 08: Process Phase - Determine the Solution Module 09: Process Phase - Write the Solution Document Module 10: Production Phase - Producing the Product Module 11: Production Phase - Monitor the Product Module 12: Confirmation Stage -------------- ***Level 7 Diploma in Facilities Management Course*** Module 01: Introduction to Facilities Management Module 02: Developing a Strategy for Facilities Management Module 03: Facilities Planning Module 04: Managing Office WorkSpace Module 05: Vendor Management & Outsourcing Module 06: Managing Change Module 07: Managing Human Resources Module 08: Managing Risk Module 09: Facilities Management Service Providers Module 10: Managing Specialist Services Module 11: Public-Private Partnerships and Facilities Management Module 12: Health, Safety, Environment and UK Law -------------- ***Minute Taking Course*** Module 01: Introduction to Minute Taking Module 02: The Role of a Minute Taker Module 03: Minutes Styles & Recording Information Module 04: Techniques for Preparing Minutes Module 05: Developing Active Listening Skills Module 06: Developing Organizational Skills Module 07: Developing Critical Thinking Skills Module 08: Developing Interpersonal Skills Module 09: Assertiveness and Self Confidence Module 10: Understanding Workplace Meetings -------------- ***Level 5 Diploma in Risk Management Course*** Module 01: A Quick Overview of Risk Management Module 02: Risk and its Types Module 03: Others Types of Risks and its Sources Module 04: Risk Management Standards Module 05: Enterprise Risk Management Module 06: Process of the Risk Management Module 07: Risk Assessment Module 08: Risk Analysis Module 09: Financial Risk Management Module 10: The Basics of Managing Operational Risks Module 11: Technology Risk Management Module 12: Project Risk Management Module 13: Legal Risk Management Module 14: Managing Social and Market Risk Module 15: Workplace Risk Assessment Module 16: Risk Control Techniques Module 17: Ins and Outs of Risk Management Plan -------------- ***Level 7 Business Management Course*** Module 01: Introduction Module 02: Financial Resource and Investment Management Module 03: Succession Planning Module 04: Risk Management Module 05: Supply Chain Management Module 06: Human Resource Management Module 07: Leadership and Management Module 08: Change Management Module 09: Conflict Management Module 10: Project Management Module 11: Communication Management Module 12: Entrepreneurship and Small Business Management Module 13: UK Business Law -------------- ***Level 7 Diploma in Leadership and Management Course*** Module 1: Understanding Management and Leadership Module 2: Leadership over Yourself Module 3: Creativity and Innovation Module 4: Leadership and Teambuilding Module 5: Motivation and People Management Module 6: Communication and Leadership Module 7: Presentation, One-to-one Interview and Meeting Management Module 8: Talent Management Module 09: Strategic Leadership Module 10: Stress Management -------------- Assessment Method After completing each module of the Creating a Business Start-Up, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Creating a Business Start-Up This course is ideal for anyone who wants to start up his own business. Requirements Creating a Business Start-Up There are no specific requirements for this Creating a Business Start-Up course because it does not require any advanced knowledge or skills. Students who intend to enrol in this course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path Creating a Business Start-Up Upon successful completion of this course, you may choose to become a: Business Owner Entrepreneur Business Analyst Business and Enterprise Advisor Business Development Executive Certificates Certificate of completion Digital certificate - Included

Overview: Strengthen your expertise to create beautiful cyberpunk artwork. This exclusively designed Cyberpunk - Photoshop Compositing Training course will show you how to use expert Photoshop compositing techniques to achieve realistic compositing. We have designed this comprehensive Cyberpunk - Photoshop Compositing Training course with the best photo composition tools and techniques to help you improve your photos. We'll create fantastic cyberpunk artwork during the learning session, with each step discussed in depth to help you understand the process. You'll be able to work with colors, contrast, and textures more effectively, as well as create special effects. Enrol today to learn how to create great cyberpunk art and plan a successful professional path. Learning Outcomes: Strengthen your expertise to perfectly combine images in Photoshop Know how to effectively work with layers, masks and blending modes Understand how to work with colours and contrast Have an in-depth understanding of how to work with textures Learn about backlights for the bike Gain an excellent understanding of puddles and reflection on the ground Learn step-by-step how to add special effects to your images Who is this course for? Anyone interested in creating fantastic cyberpunk artwork can take this Cyberpunk - Photoshop Compositing Training course. This course will help you to create opportunities in different professional careers related to Photoshop Compositing. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Cyberpunk - Photoshop Compositing Training is a useful qualification to possess and would be beneficial for any related profession or industry such as: Graphics Designer Motion Capture Designer 3D Designer Digital Sketch Artist Illustration Photography Cyberpunk - Photoshop Compositing Training Module 01: Placing images and set perspective 00:07:00 Module 02: Depth of field 00:05:00 Module 03: Highlights and reflexes 00:15:00 Module 04: Backlights for the bike 00:07:00 Module 05: Puddles and reflections on the ground 00:09:00 Module 06: Color correction and special effects 00:16:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 1 Days 6 CPD hours This course is intended for This class is designed for experienced administrators who are responsible for setting up, configuring, and managing Experience Cloud Sites in their organization. As a Salesforce Administrator, you should have a solid understanding of Salesforce functionality and concepts, and at least 6 months of experience using Salesforce. Overview Enable Digital Experiences in your organization. Describe the capabilities of sites and how they work. Create a new Experience Cloud Site for partner sales. Create an Experience Cloud Site for self-service support. Measure a site's success using dashboards. Keep the site active and engaged with native tools. Connect with your employees, customers, and partners using Experience Cloud Sites. In this 1-day class, you?ll discover how to build a branded space where you can share information and collaborate with people who are key to your organization. Our Salesforce experts will walk you through how to enable Digital Experiences in your organization, create sites for partners and customers, and measure and drive audience participation. This class also provides an overview of the Salesforce Experience Cloud Consultant certification exam objectives to help support you on your journey toward earning your credential. Exam Overview Review Exam Topics Review Exam Logistics Digital Experiences Get to Know Experiences Understand How Sites Work Implement Digital Experiences Understand Deployment Types Build Partner Sites Leverage Experience Builder Templates to Quickly Build Sites Security and Customization Understand Site Limits, Licensing, and Users Create and Customize Your Sites with Experience Builder Enable Experience Cloud for Mobile Serve International Audiences with Multilingual Sites Self-Service Sites Understand Self-Service/Public Site Functionality Go Further with Experience Builder Classify Articles, Questions, and Ideas with Data Categories and Knowledge Build a Site Using the Customer Service Template Add CMS Content to Your Site Build Responsive Sites with Experience Builder Templates Success Metrics Measure Success Install Dashboards and Insights from the AppExchange Site Engagement Drive Engagement Moderate Sites Recognize and Reward Member Participation with Reputation Highlight Topic Experts with Knowledgeable People Additional course details: Nexus Humans Salesforce Create and Manage Experience Cloud Sites (ADX271) 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 Salesforce Create and Manage Experience Cloud Sites (ADX271) 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.

GDPR: GDPR Training Course Online Enrol in our GDPR: GDPR Training Course to safeguard sensitive information from theft and misuse! Are you open to pursuing a career in the area of legislation that updated and standardized data privacy regulations across the European Union? Our GDPR: GDPR Training Course will outline the regulation's extensive effects. The knowledge and abilities required to oversee all parts of compliance will be developed with the aid of GDPR: GDPR Training Course. You can run your business more effectively once you have successfully completed the GDPR: GDPR Training Course. Additionally, GDPR: GDPR Training Course can help you advance within your present organisation or launch your business venture with the greatest likelihood of success. Improve your professional opportunities for life by adding a certificate from a GDPR: GDPR Training Course to your resume. Main Course: GDPR Training Course Free Courses included with GDPR: GDPR Training Course Along with GDPR: GDPR Training Course you will get free Security Management Diploma Along with GDPR: GDPR Training Course you will get free Level 5 Diploma in Cyber Security Special Offers of this GDPR: GDPR Training Course: This GDPR: GDPR Training Course includes a FREE PDF Certificate. Lifetime access to this GDPR: GDPR Training Course Instant access to this GDPR: GDPR Training Course 24/7 Support Available to this GDPR: GDPR Training Course GDPR: GDPR Training Course Online You'll learn about the new GDPR: GDPR Training Course regulations for protecting personal information and the most important new developments in this GDPR: GDPR Training Course session. The duties of data controllers and processors are also included in GDPR: GDPR Training Course. With our GDPR: GDPR Training Course, you will also receive instruction on how to handle sensitive personal data and data protection jargon. You will have knowledge of what is required of businesses in terms of handling data protection by the end of the GDPR: GDPR Training Course. You may put into practice a GDPR: GDPR Training Course compliance strategy for your company with the aid of GDPR training. Who is this course for? GDPR: GDPR Training Course Online Anyone can take this GDPR: GDPR Training Course who is really interested in learning about the GDPR industry and the accompanying topics, such as: Data Protection Advisor Data Manager Data Protection Officer Data Protection Analyst Cybersecurity Analyst Risk Analyst and Security Consultant Requirements GDPR: GDPR Training Course Online To enrol in this GDPR: GDPR Training Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our GDPR: GDPR Training Course. Be energetic and self-motivated to complete our GDPR: GDPR Training Course. Basic computer Skill is required to complete our GDPR: GDPR Training Course. If you want to enrol in our GDPR: GDPR Training Course, you must be at least 15 years old. Career path GDPR: GDPR Training Course Online This GDPR: GDPR Training Course will open doors for you and point you in the direction of numerous employment options with lucrative salaries ranging from £21,000 to £100,000 annually. GDPR Manager, Data Manager, Data Protection Officer, Cyber Security Analyst, and other relevant jobs can be obtained with a GDPR: GDPR Training Course certificate.

GDPR: GDPR Training Course Online Enrol in our GDPR: GDPR Training Course to safeguard sensitive information from theft and misuse! Are you open to pursuing a career in the area of legislation that updated and standardized data privacy regulations across the European Union? Our GDPR: GDPR Training Course will outline the regulation's extensive effects. The knowledge and abilities required to oversee all parts of compliance will be developed with the aid of GDPR: GDPR Training Course. You can run your business more effectively once you have successfully completed the GDPR: GDPR Training Course. Additionally, GDPR: GDPR Training Course can help you advance within your present organisation or launch your business venture with the greatest likelihood of success. Improve your professional opportunities for life by adding a certificate from a GDPR: GDPR Training Course to your resume. Main Course: GDPR Training Course Free Courses included with GDPR: GDPR Training Course Along with GDPR: GDPR Training Course you will get free Security Management Diploma Along with GDPR: GDPR Training Course you will get free Level 5 Diploma in Cyber Security Special Offers of this GDPR: GDPR Training Course: This GDPR: GDPR Training Course includes a FREE PDF Certificate. Lifetime access to this GDPR: GDPR Training Course Instant access to this GDPR: GDPR Training Course 24/7 Support Available to this GDPR: GDPR Training Course GDPR: GDPR Training Course Online You'll learn about the new GDPR: GDPR Training Course regulations for protecting personal information and the most important new developments in this GDPR: GDPR Training Course session. The duties of data controllers and processors are also included in GDPR: GDPR Training Course. With our GDPR: GDPR Training Course, you will also receive instruction on how to handle sensitive personal data and data protection jargon. You will have knowledge of what is required of businesses in terms of handling data protection by the end of the GDPR: GDPR Training Course. You may put into practice a GDPR: GDPR Training Course compliance strategy for your company with the aid of GDPR training. Who is this course for? GDPR: GDPR Training Course Online Anyone can take this GDPR: GDPR Training Course who is really interested in learning about the GDPR industry and the accompanying topics, such as: Data Protection Advisor Data Manager Data Protection Officer Data Protection Analyst Cybersecurity Analyst Risk Analyst and Security Consultant Requirements GDPR: GDPR Training Course Online To enrol in this GDPR: GDPR Training Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our GDPR: GDPR Training Course. Be energetic and self-motivated to complete our GDPR: GDPR Training Course. Basic computer Skill is required to complete our GDPR: GDPR Training Course. If you want to enrol in our GDPR: GDPR Training Course, you must be at least 15 years old. Career path GDPR: GDPR Training Course Online This GDPR: GDPR Training Course will open doors for you and point you in the direction of numerous employment options with lucrative salaries ranging from £21,000 to £100,000 annually. GDPR Manager, Data Manager, Data Protection Officer, Cyber Security Analyst, and other relevant jobs can be obtained with a GDPR: GDPR Training Course certificate.

Linux training course description A Linux foundation appropriate for all flavours of Linux, focussed on getting network engineers up and running with Linux. The command line is used throughout. The course progresses from the basics of Linux commands onto useful tools such as grep, then shell features such as piping and then onto shell scripting. Administration aspects covered are the tasks network engineers are most likely to encounter such as software installation. Hands on exercises concentrate on network related tasks such as installing net-snmp and using shell scripts to provide network automation. What will you learn Use Linux commands to perform a variety of tasks from manipulating files to handling processes. Create and edit files with vi. Work with permissions. Write simple shell scripts. Install software packages. Configure base networking. Linux training course details Who will benefit: Network engineers. Prerequisites: TCP/IP Foundation Duration 5 days Linux training course contents What is Linux? Linux distributions, open source software. Getting started Logging in, changing passwords, logging out. Hands on Basics and root access. Linux basics Command structure. The Linux manuals, basic commands (who, date, tty, uname, echo, banner...). Hands on Using the CLI. Connecting to a network IP configuration, DHCP, static addressing, routing, ifconfig, ping, netstat, traceroute, dig. Hands on Network configuration and testing. Managing Software Package Concepts, Comparison of package formats, RPM, rpm Commands, Yum, Debian Packages, dpkg, apt-cache, apt-get, dselect, aptitude, Converting Between Package Formats, Dependencies and Conflicts, Startup Script Problems, Shared Libraries, Library Management Hands on Installing network packages such as nmap and net-snmp. Processes and log files ps, kill, background processes, at, exec, priorities. Managing Linux log files. Syslogd. Setting the time. Cron and cronjobs. Managing Processes, the Kernel: The First Process. Hands on Controlling daemons and services. Setting up a TFTP server. Filesystem commands Home directories, manipulating files and directories, Filesystem layout, Pathnames, hard and symbolic links. Viewing files. Hands on Exploring the filesystem, working with network device configuration files. The Linux editors ed, vi, shell escapes, .exrc. Hands on Editing network device configuration files. Extracting data from files grep, find, cut, sort and paste… Hands on Working with syslog files. Permissions Theory, chmod, chown, newgrp. Hands on Handling permission problems. The shell Metacharacters, piping and redirection. Hands on Running SNMP commands and working with their output. Basic shell scripting What are shell scripts? Simple scripts, control structures. Variable. Setting variables, using variables, set, scope, export, sourcing, environmental variables, read. Positional parameters: $0 to $9, $#, $* and others. shift parameter substitution. Control statements: The test command, if , while loops, for loops, the case statement. Hands on Automating network tasks. Customising your environment Environmental variables, stty, .profile and other startup files. Hands on Customising Linux. Introduction to administration The root user, su. Managing users and groups. Hands on The power of root. Archiving files Backups, tar, cpio, dd, gzip. Hands on Working with tar files. Booting Linux and Editing Files Installing Boot Loaders, GRUB Legacy, GRUB 2, Alternative Boot Loaders, the Boot Process, Boot Messages, Runlevels and the Initialization Process, Runlevel Functions, Runlevel Services, Alternative Boot Systems , Upstart, system. Hands on Installing network services on Linux.

LINX II training course description An intensive hands on IP routing course leading to LINX Accredited Internet Technician stage 2 focusing on routing in an IP environment. The course concentrates on OSPF and IS-IS but also covers BGP and MPLS. Hands on sessions are used to reinforce the theory rather than teach specific manufacturer equipment. A multiple choice exam, leading to the LAIT II certification, is available after the course. The exam consists of 60 questions and lasts 2.0 hours. What will you learn Calculate subnet numbers in seconds. Configure and troubleshoot static routes Explain how OSPF works. Build resilient networks with VRRP and OSPF. Implement and troubleshoot OSPF, IS-IS, simple BGP and simple MPLS. Evaluate and choose appropriate routing protocols for particular scenarios. LINX II training course details Who will benefit: Network engineers. Prerequisites: LAIT I attendance and 55%+ exam score OR LAIT I exam only and pass (70%+) OR CCNA and take LAIT I exam on this course. Duration 5 days LINX II training course contents Basic routing Review of LAIT I routing, reading routing tables. Hands on Setting up a routed network. Static routes Why use static routes? Default routes. Hands on Configuring static routes. First hop redundancy Default gateways, VRRP/HSRP/GLBP. Load sharing, critical IP addresses. Hands on VRRP. Basic OSPF What is OSPF? Process IDs, passive interfaces. Hands on Simple OSPF. Subnetting Bit boundary subnetting, calculating network numbers. Exercise: Subnetting. OSPF overview Metrics, convergence, DV vs. Link state, IGPs, classless, OSPF features, load sharing, OSPF authentication. Hands on OSPF features. OSPF within an area How OSPF works, LSAs, LSDB, router IDs, hellos, configuring hellos, exchange protocol. Hands on Investigating OSPF structures. OSPF areas Scalability, why areas? Area IDs, area 0, ABRs, ABR resilience, areas & LSDBs & LSAs, virtual links. Hands on Multi area OSPF. Redistribution Multiple routing protocols, common scenarios, routing distance, External LSAs, E1 and E2. Type 4 LSAs. OSPF and default routes. Hands on Configuring static route redistribution. Route aggregation Route summarisation. How to aggregate, CIDR, ASBR summarisation. Hands on OSPF address summarisation. OSPF packet formats OSPF packets, protocol stack, packet flows, OSPF headers, neighbours, neighbour states, DRs, adjacencies, BDRs, DR election. Hands on Analysing OSPF packets, troubleshooting. OSPF OSPF stub areas LSA types, area types, area architecture, stub areas, default routes, benefits & disadvantages of stub areas, TSSAs, NSSAs, Type 7 LSAs. Hands on Stub and TSSA configuration. IS-IS End systems, Intermediate systems, how IS-IS works, IS-IS router ID, Level 1, Level 2, IS-IS hierarchy. Hands on Configuring IS-IS, troubleshooting IS-IS. The Internet Autonomous systems, Peering, transit, looking glasses. Hands on Internet routing tables. Basic BGP IGPs, EGPs, What's BGP? BGP RIB, in/out process, tables peers, adding routes. Hands on Simple configuration and troubleshooting. Routing IPv6 Multi protocol routing, IPv6 addressing, IPv6 routing tables, IPv6 static routes, OSPFv3, IS-IS and IPv6. Hands on Routing IPv6. STP and L2 routing STP, RSTP, L2 IS-IS, Multi system link aggregation. Hands on RSTP. MPLS Core MPLS, MPLS and the 7 layer model, MPLS protocol, MPLS standard, MPLS runs on routers, MPLS history, Why MPLS?, LSRs, PE and P router roles, FEC, swapping labels, MPLS packet format. Hands on Enabling MPLS. Testing and troubleshooting of MPLS. Appendix EIGRP: How EIGRP works, DUAL.

Definitive IP routing training course description An intensive hands on IP routing course leading to LINX Accredited Internet Technician stage 2 focusing on routing in an IP environment. The course concentrates on OSPF and IS-IS but also covers BGP and MPLS. Hands on sessions are used to reinforce the theory rather than teach specific manufacturer equipment. A multiple choice exam, leading to the LAIT II certification, is available after the course. The exam consists of 60 questions and lasts 2.0 hours. What will you learn Calculate subnet numbers in seconds. Configure and troubleshoot static routes. Explain how OSPF works. Build resilient networks with VRRP and OSPF. Implement and troubleshoot OSPF, IS-IS and VLANS. Evaluate and choose appropriate routing protocols for particular scenarios. An optional multiple choice exam, leading to the LAIT II certification, is included at the end of the course. The exam consists of 60 questions and lasts 2.0 hours. Definitive IP routing training course details Who will benefit: Network engineers Prerequisites: TCP/IP Foundation for engineers Duration 5 days Definitive IP routing training course contents Basic routing Review of LAIT I routing, reading routing tables. Hands on Setting up a routed network. Static routes Why use static routes? Default routes. Hands on Configuring static routes. First hop redundancy Default gateways, VRRP/HSRP/GLBP. Load sharing, critical IP addresses. Hands on VRRP. Basic OSPF What is OSPF? Process IDs, passive interfaces. Hands on Simple OSPF. Subnetting Bit boundary subnetting, calculating network numbers. Exercise: Subnetting. OSPF overview Metrics, convergence, DV vs. Link state, IGPs, classless, OSPF features, load sharing, OSPF authentication. Hands on OSPF features. OSPF within an area How OSPF works, LSAs, LSDB, router IDs, hellos, configuring hellos, exchange protocol. Hands on Investigating OSPF structures. OSPF areas Scalability, why areas? Area IDs, area 0, ABRs, ABR resilience, areas & LSDBs & LSAs, virtual links. Hands on Multi area OSPF. Redistribution Multiple routing protocols, common scenarios, routing distance, External LSAs, E1 and E2. Type 4 LSAs. OSPF and default routes. Hands on Configuring static route redistribution. Route aggregation Route summarisation. How to aggregate, CIDR, ASBR summarisation. Hands on OSPF address summarisation. OSPF packet formats OSPF packets, protocol stack, packet flows, OSPF headers, neighbours, neighbour states, DRs, adjacencies, BDRs, DR election. Hands on Analysing OSPF packets, troubleshooting. OSPF OSPF stub areas LSA types, area types, area architecture, stub areas, default routes, benefits & disadvantages of stub areas, TSSAs, NSSAs, Type 7 LSAs. Hands on Stub and TSSA configuration. IS-IS End systems, Intermediate systems, how IS-IS works, IS-IS router ID, Level 1, Level 2, IS-IS hierarchy. Hands on Configuring IS-IS, troubleshooting IS-IS. The Internet Autonomous systems, Peering, transit, looking glasses. Hands on Internet routing tables. Basic BGP IGPs, EGPs, What's BGP? BGP RIB, in/out process, tables peers, adding routes. Hands on Simple configuration and troubleshooting. Routing IPv6 Multi protocol routing, IPv6 addressing, IPv6 routing tables, IPv6 static routes, OSPFv3, IS-IS and IPv6. Hands on Routing IPv6. STP and L2 routing STP, RSTP, L2 IS-IS, Multi system link aggregation. Hands on RSTP. MPLS Core MPLS, MPLS and the 7 layer model, MPLS protocol, MPLS standard, MPLS runs on routers, MPLS history, Why MPLS?, LSRs, PE and P router roles, FEC, swapping labels, MPLS packet format. Hands on Enabling MPLS. Testing and troubleshooting of MPLS. Appendix EIGRP: How EIGRP works, DUAL.

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for: Database architects Database administrators Database developers Data analysts and scientists Overview This course is designed to teach you how to: Discuss the core concepts of data warehousing, and the intersection between data warehousing and big data solutions Launch an Amazon Redshift cluster and use the components, features, and functionality to implement a data warehouse in the cloud Use other AWS data and analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3, to contribute to the data warehousing solution Architect the data warehouse Identify performance issues, optimize queries, and tune the database for better performance Use Amazon Redshift Spectrum to analyze data directly from an Amazon S3 bucket Use Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data Module 1: Introduction to Data Warehousing Relational databases Data warehousing concepts The intersection of data warehousing and big data Overview of data management in AWS Hands-on lab 1: Introduction to Amazon Redshift Module 2: Introduction to Amazon Redshift Conceptual overview Real-world use cases Hands-on lab 2: Launching an Amazon Redshift cluster Module 3: Launching clusters Building the cluster Connecting to the cluster Controlling access Database security Load data Hands-on lab 3: Optimizing database schemas Module 4: Designing the database schema Schemas and data types Columnar compression Data distribution styles Data sorting methods Module 5: Identifying data sources Data sources overview Amazon S3 Amazon DynamoDB Amazon EMR Amazon Kinesis Data Firehose AWS Lambda Database Loader for Amazon Redshift Hands-on lab 4: Loading real-time data into an Amazon Redshift database Module 6: Loading data Preparing Data Loading data using COPY Data Warehousing on AWS AWS Classroom Training Concurrent write operations Troubleshooting load issues Hands-on lab 5: Loading data with the COPY command Module 7: Writing queries and tuning for performance Amazon Redshift SQL User-Defined Functions (UDFs) Factors that affect query performance The EXPLAIN command and query plans Workload Management (WLM) Hands-on lab 6: Configuring workload management Module 8: Amazon Redshift Spectrum Amazon Redshift Spectrum Configuring data for Amazon Redshift Spectrum Amazon Redshift Spectrum Queries Hands-on lab 7: Using Amazon Redshift Spectrum Module 9: Maintaining clusters Audit logging Performance monitoring Events and notifications Lab 8: Auditing and monitoring clusters Resizing clusters Backing up and restoring clusters Resource tagging and limits and constraints Hands-on lab 9: Backing up, restoring and resizing clusters Module 10: Analyzing and visualizing data Power of visualizations Building dashboards Amazon QuickSight editions and feature