4574 Security courses in Sutton-in-Ashfield delivered Online

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.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for Data Warehouse Administrator, Database Administrator, Database Designer, Support Engineer, and Technical Administrator. Overview Upon successful completion of this course, students will be able to Install Oracle Grid Infrastructure for a Standalone Server, Configure ASMLIB and create ASM disk groups, Apply the latest patch set updates to the Grid Infrastructure software, Install Oracle Database software, Use Oracle Restart to manage components, Prepare the Linux operating system for Oracle software installation, Upgrade Oracle Database, Create a container database, Install Oracle Grid Infrastructure for an Independent Server, Create an Oracle Database using DBCA, and Install the latest patch set updates to the Oracle database software. This Oracle Database: Deploy, Patch and Upgrade Workshop gives you detailed information to help you install Oracle Database software. In this course, you will be introduced to Oracle Database Cloud Service. Oracle Database Overview Oracle Database Introduction Oracle Database Architecture Overview Oracle Database Instance Configurations Oracle Database Memory Structures Process Structures Database Storage Architecture Logical and Physical Database Structures Container and Pluggable Database Overview Installing Oracle Grid Infrastructure for a Standalone Server Overview of Oracle Grid Infrastructure for a Standalone Server System Requirements for Oracle Grid Infrastructure Configuring Storage for Oracle Automatic Storage Management (ASM) Installing Oracle Grid Infrastructure for a Standalone Server Upgrading Oracle Grid Infrastructure for a Standalone Server Installing Oracle Database Software Planning Your Installation System Requirements for Oracle Database Preparing the Operating System Using 4 KB Sector Disks Setting Environment Variables Checking the System Requirements Using the Oracle Universal Installer (OUI) Performing a Silent Mode Installation Creating an Oracle Database by Using DBCA Planning the Database Storage Structure Choosing non-CDB or CDB Types of Databases (based on workload) Choosing the Appropriate Character Set Understanding How Character Sets are Used Setting the NLS_LANG Initialization Parameter Using the Database Configuration Assistant (DBCA) Using Oracle Restart Oracle Restart Overview Oracle Restart Process startup Controlling Oracle Restart Choosing the Correct SRVCTL Utility Oracle Restart Configuration Using the SRVCTL Utility Obtaining Help for the SRVCTL Utility Starting Components by Using the SRVCTL Utility Introduction to Upgrading to Oracle Database Upgrade Methods Data Migration Methods Supported Releases for Direct Upgrade Overview of Upgrade Process Performing a Rolling Upgrade Upgrading a CBD Preparing to Upgrade to Oracle Database Developing a Test Plan Performance Testing Requirements for Databases Using Oracle Label Security or Oracle Database Vault Requirement for Databases Using Oracle Warehouse Builder Using the Pre-Upgrade Information Tool Backing Up the Database Installing the Oracle Database Software Preparing the New Oracle Home Upgrading to Oracle Database Upgrading by Using the Database Upgrade Assistant (DBUA) Manually Upgrading to Oracle Database Migrating a non-CDB to a CDB Performing Post-Upgrade Tasks Migrating to Unified Auditing Performing Post-Upgrade Tasks Following a Manual Upgrade Migrating Data by Using Oracle Data Pump Data Pump Overview Migrating by Using Data Pump Importing by Using a Network Link

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

Description: Nowadays almost every job in the business world involves office products. Whether you're an administrative assistant, office manager, sales professional or business manager, utilizing all of the powerful features of Microsoft Office will make you more efficient and subsequently more marketable. The Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced is designed to provide you all the basics of relational database design and through the creation of database objects. You will learn how to use forms, query tables and reports to manage data. You will understand the interface, customization and creation editing of the many objects available within the Microsoft Access application. This course is divided into three separate levels being Basic Microsoft Access, Intermediate Microsoft Access and Advanced Microsoft Access. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Microsoft Access - Beginner Orientation to Microsoft Access FREE 00:39:00 Create a Simple Access Database 00:10:00 Get Help and Configure Options in Microsoft Access 00:06:00 Modify Table Data 00:17:00 Sort and Filter Records 00:05:00 Create Basic Queries 00:15:00 Sort and Filter Data in a Query 00:14:00 Perform Calculations in a Query 00:08:00 Create Basic Access Forms 00:07:00 Work with Data on Access Forms 00:23:00 Create a Report 00:23:00 Add Controls to a Report 00:12:00 Enhance the Appearance of a Report 00:05:00 Prepare a Report for Print 00:03:00 Organize Report Information 00:15:00 Format Reports 00:12:00 Microsoft Access - Intermediate Relational Database Design FREE 00:16:00 Create a Table 00:09:00 Create Table Relationships 00:09:00 Create Query Joins 00:14:00 Relate Data Within a Table.avi 00:04:00 Work with Subdatasheets from 00:05:00 Use Field Validation 00:16:00 Use Form and Record Validation 00:14:00 Create Parameter Queries 00:12:00 Summarize Data 00:06:00 Create Subqueries 00:07:00 Create Action Queries 00:05:00 Create Unmatched and Duplicate Queries 00:06:00 Data Normalization 00:10:00 Create a Junction Table 00:04:00 Improve Table Structure 00:06:00 Include Control Formatting in a Report 00:04:00 Add a Calculated Field to a Report 00:05:00 Add a Subreport to an Existing Report 00:07:00 Microsoft Access - Advanced Add Controls to Forms FREE 00:11:00 Enhance Navigation and Organization of Forms 00:14:00 Apply Conditional Formatting 00:04:00 Import Data into Access 00:08:00 Export Access Data 00:06:00 Link Tables to External Data Sources 00:05:00 Create a Mail Merge 00:02:00 Create a Macro 00:08:00 Restrict Records by Using a Condition 00:04:00 Validate Data by Using a Macro 00:05:00 Automate Data Entry by Using a Macro 00:04:00 Manage a Database 00:08:00 Determine Object Dependency 00:04:00 Manage a Database 00:07:00 Determine Object Dependency 00:04:00 Document a Database 00:04:00 Splitting a Database for Multiple User Access 00:05:00 Implement Security 00:03:00 Convert an Access Database to an ACCDE File 00:04:00 Package a Database with a Digital Signature 00:01:00 Create a Database Switchboard 00:05:00 Modify a Database Switchboard 00:02:00 Set Start up Options 00:04:00 Mock Exam Mock Exam- Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced 00:30:00 Final Exam Final Exam- Microsoft Office 2016 Access Complete Video Course - Beginner, Intermediate & Advanced 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Since 1999, the Diploma in Port Management has been recognised as a leading qualification for port managers, governments, terminal operators, and port companies. Human proficiency is the most crucial factor in the effective operation of port and transport services. A successful and well-run port contributes to the economy; therefore port personnel must be apprised and updated with all the relevant innovations available.  The Port Management Diploma is ideal for port management professionals needing to build on their knowledge in order to meet their day-to-day challenges more effectively. It is designed to give you the skills to develop professionally in port administration, port and harbour management and port operations for the global maritime supply chain. This course will provide opportunities for you to thoroughly understand the role of port especially in the international trade and logistic chain as the 'economic engine' of development. Who is this course for? Port Management Diploma is suitable for anyone who want to gain extensive knowledge, potential experience and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our Port Management Diploma is open to all from all academic backgrounds and there is no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Featured Reviews Dave WRead More I've just completed the Port Management Diploma. I recommend this course to all management persons currently in a port role, or thinking of joining the world of Ports. The course is presented well, and easy to follow on line. The pre quiz helps you to prepare for the final assessment. Alessandra Antonella NapoliRead More This Port Management Course is well organised. The learning materials provided it is very consistent and well explained. You earn a lot of knowledge about operations and management. I loved it. Course Curriculum Port Management Module 01: Introduction to Port 00:28:00 Module 02: Legal Aspects of Port 00:20:00 Module 03: Introduction to Port Management 00:26:00 Module 04: Port Management: Planning & Performance 00:27:00 Module 05: Port Management: Safety & Security 00:18:00 Module 06: Environmental Risks & Protection 00:29:00 Module 07: Port Equipment 00:24:00 Module 08: Growth & Development of Port 00:23:00 Module 09: Cargoes and Ships 00:22:00 Module 10: Impact of Changing Ship Technology on Ports 00:23:00 Mock Exam Mock Exam - Port Management Diploma 00:20:00 Final Exam Final Exam - Port Management Diploma 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Duration 2 Days 12 CPD hours This course is intended for There is no specific prerequisite for the CDRP© course. However, participants who have at least three years' experience in a data centre and/or IT infrastructures will be best suited. Overview After completion of the course, the participant will be able to: 1. Understand the different standards and methodologies for risk management and assessment 2. Establish the required project team for risk management 3. Perform the risk assessment, identifying current threats, vulnerabilities and the potential impact based on customised threat catalogues 4. Report on the current risk level of the data centre both quantitative and qualitative 5. Anticipate and minimise potential financial impacts 6. Understand the options for handling risk 7. Continuously monitor and review the status of risk present in the data centre 8. Reduce the frequency and magnitude of incidents 9. Detect and respond to events when they occur 10. Meet regulatory and compliance requirements 11. Support certification processes such as ISO/IEC 27001 12. Support overall corporate and IT governance Introduction to Risk Management Risk management concepts Senior management and risk Enterprise Risk Management (ERM) Benefits of risk management Data Centre Risk and Impact Risk in facility, power, cooling, fire suppression, infrastructure and IT services Impact of data centre downtime Main causes of downtime Cost factors in downtime Standards, Guidelines and Methodologies ISO/IEC 27001:2013, ISO/IEC 27005:2011, ISO/IEC 27002:2013 NIST SP 800-30 ISO/IEC 31000:2009 SS507:2008 ANSI/TIA-942 Other methodologies (CRAMM, EBIOS, OCTAVE, etc.) Risk Management Definitions Asset Availability/Confidentiality/Integrity Control Information processing facility Information security Policy Risk Risk analysis/Risk assessment/Risk evaluation/ Risk treatment Threat/Vulnerability Types of risk Risk Assessment Software The need for software Automation Considerations Risk Management Process The risk management process Establishing the context Identification Analysis Evaluation Treatment Communication and consultation Monitoring and review Project Approach Project management principles Project management methods Scope Time Cost Cost estimate methods Context Establishment General considerations Risk evaluation, impact and acceptance criteria Severity rating of impact Occurrence rating of probability Scope and boundaries Scope constraints Roles & responsibilities Training, awareness and competence Risk Assessment - Identification The risk assessment process Identification of assets Identification of threats Identification of existing controls Identification of vulnerabilities Identification of consequences Hands-on exercise: Identification of assets, threats, existing controls, vulnerabilities and consequences Risk Assessment - Analysis and Evaluation Risk estimation Risk estimation methodologies Assessment of consequences Assessment of incident likelihood Level of risk estimation Risk evaluation Hands-on exercise: Assessment of consequences, probability and estimating level of risk Risk Treatment The risk treatment process steps Risk Treatment Plan (RTP) Risk modification Risk retention Risk avoidance Risk sharing Constraints in risk modification Control categories Control examples Cost-benefit analysis Control implementation Residual risk Communication Effective communication of risk management activities Benefits and concerns of communication Risk Monitoring and Review Ongoing monitoring and review Criteria for review Risk scenarios Risk assessment approach Data centre site selection Data centre facility Cloud computing UPS scenarios Force majeure Organisational shortcomings Human failure Technical failure Deliberate acts Exam: Certified Data Centre Risk Professional Actual course outline may vary depending on offering center. Contact your sales representative for more information.

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.