About this Training Course Comprising 5 full-day sessions, this intermediate to advanced level course is specifically designed for senior exploration geoscientists currently active in hydrocarbon play and prospect mapping, to optimise conceptual geological input into their technical evaluation. The course focuses on seismic stratigraphic analysis in different basin settings - i.e., passive, convergent, extension and oblique - in order to construct a coherent geological story line, underpinning hydrocarbon play and prospect evaluation. The course is largely based on seismic stratigraphic case histories and exercises, with the support of seismic, well log and outcrop examples. Training Objectives Through short, focused presentations and a series of industry case history-based examples and exercises, participants will learn to optimise conceptual geoscience input into technical subsurface analysis. This will help to produce coherent geological subsurface interpretations for use in Play-based, Prospect and Appraisal evaluations. Target Audience This course is intended for senior geoscientists with more than five years of work experience, with a background in play and/or prospect evaluation and experience in seismic interpretation. Course Level Intermediate Advanced Training Methods Participants will be exposed to short lectures throughout the 5 days, followed by hands-on individual and team exercises in a variety of geological settings. 'Let the data tell their story' is a key recurring theme in this course. Trainer Your expert course leader has 38 years of experience as Exploration Geologist for Shell globally, with field experience in a/o Egypt, NW Borneo, MENA, China, Madagascar, North Sea, Oman and The Netherlands (Shell EP Research and Training Centre in Rijswijk). He has strong evaluation and project lead skills in Play-based Exploration, Prospect Maturation, Opportunity Screening and NFE / Appraisal disciplines. He developed key geoscience skills in Seismic and Sequence Stratigraphy as well as Reservoir Characterization, including sedimentology and diagenesis. He has extensive supervisory, teaching, and coaching experience as well as a strong interest in Geoscience (Depositional Systems, Regional and Reservoir Geology) and Petroleum Geology Learning. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations
Junos Intermediate Routing training course description This course provides students with intermediate routing knowledge and configuration examples. The course includes an overview of protocol-independent routing features, load balancing and filter-based forwarding, OSPF, BGP, IP tunneling, and high availability (HA) features. Junos Intermediate Routing (JIR) is an intermediate-level course. What will you learn Describe typical uses, configure & monitor static, aggregate, and generated routes. Configure and share routes between routing instances. Explain the operations of OSPF. Describe BGP and its basic operations. Configure and monitor GRE and IP-IP tunnels. Junos Intermediate Routing training course details Who will benefit: Engineers responsible for configuring and monitoring devices running the Junos OS. Prerequisites: Intro to the Junos Operating System Duration 2 days Junos Intermediate Routing training course contents Protocol-Independent Routing Static Routes Aggregated Routes Generated Routes Martian Addresses Routing Instances Lab 1 Protocol-Independent Routing Load Balancing and Filter-Based Forwarding Overview of Load Balancing Configuring and Monitoring Load Balancing Overview of Filter-Based Forwarding Configuring and Monitoring Filter-Based Forwarding Lab 2 Load Balancing and Filter-Based Forwarding Open Shortest Path First Overview of OSPF Adjacency Formation and the Designated Router Election OSPF Scalability Configuring and Monitoring OSPF Basic OSPF Troubleshooting Lab 3 Open Shortest Path First Border Gateway Protocol Overview of BGP BGP Attributes IBGP Versus EBGP Configuring and Monitoring BGP Lab 4 Border Gateway Protocol IP Tunneling Overview of IP Tunneling GRE and IP-IP Tunnels Implementing GRE and IP-IP Tunnels Lab 5 IP Tunneling High Availability Overview of High Availability Networks Graceful Restart Graceful RE Switchover Nonstop Active Routing BFD VRRP Lab 6 High Availability Appendix A: IPv6 Introduction to IPv6 Routing Protocol Configuration Examples Tunneling IPv6 over IPv4 Lab 7 (Optional) IPv6 Appendix B: IS-IS Overview of IS-IS Overview of IS-IS PDUs Adjacency Formation and DIS Election Configuring and Monitoring IS-IS Basic IS-IS Troubleshooting Lab 8 (Optional) IS-IS Appendix C: Routing Information Protocol Introduction to RIP RIP Configuration Examples Monitoring and Troubleshooting RIP
3G training course description This course is designed to give the delegate an understanding of the technologies used within a 3G UMTS mobile network. During the course we will investigate the UMTS air interface and the use of Wideband-Code Division Multiple Access (WCDMA) to facilitate high speed data access, together with HSPA to offer mobile broadband services. We will describe the use of soft handover rather than hard handover procedures and soft capacity sharing. The course includes a brief exploration of the UMTS protocol stack and the use of PDP Context and QoS support features. What will you learn Explain the 3G UMTS architecture. Describe the role of a Drifting & Serving RNC. Explain the use of ARQ & HARQ for mobile broadband. Describe how IMS integrates into the architecture. Describe the use of Media Gateway Controllers. Identify the temporary identities used within 3G UMTS. 3G training course details Who will benefit: Anyone working within the telecommunications area, especially within the mobile environment. Prerequisites: Mobile communications demystified Telecommunications Introduction Duration 2 days 3G training course contents D3GPP specifications 3GPP standards body, Evolution path, Frequency and bandwidth, Conceptual model, UMTS general architecture, UTRAN architecture & radio access bearer. CDMA principles CDMA principle, Code characteristics, Code requirements. CDMA requirements Synchronization, Power control, Soft handover, Rake receiver, Antenna consideration, Multi-user detection. Radio interface protocol architecture Access stratum & non-access stratum, Overall protocol structure, Logical and transport channels, Physical channels, Protocol termination. Layer 2 Protocols Medium Access Control (MAC) Protocol, Radio Link Control (RLC) Protocol, Packet Data Convergence Protocol (PDCP) protocol, Radio Interface for Broadcast/Multicast Services. Radio Resource Control (RRC) Protocol RRC Architecture, RRC Protocol State, Broadcast of information, RRC connection management, Radio bearer management, RRC connection mobility functions, Power control, Ciphering and Integrity. Mobile procedures Mobility management states and transitions, UMTS identities, Procedures in Idle mode (location updates, cell selection/ re-selection), Circuit-switched call set-up, Packet-switched context activation and context preservation, Data transfer initialization, Soft-handover procedure. Introduction to HSPA The need for high speed data, Fast HARQ, Improved scheduling, Additional channels, Soft combining, HS-DSCH codes, Uplink HSPA vs downlink HSPA, Full HSPA, Use of MIMO, Enhanced CELL_FACH.
Introducing Celebrity Therapist London Package: Discreet and Customized Counseling for Public Figures Are you a public figure seeking confidential and personalized counseling in London? Miss Date Doctor’s Celebrity Therapist London Package offers you discreet and specialized therapy services tailored to meet the unique needs and challenges faced by individuals in the public eye. Being a public figure can come with its own set of stressors and pressures. Our experienced celebrity therapists are dedicated to providing you with a safe and non-judgmental space to address personal concerns, manage stress, and find support for emotional well-being. Here’s how the Celebrity Therapist London Package can support you: Confidentiality: Our celebrity therapists are well-versed in maintaining confidentiality and respecting your privacy at all times. Specialized Support: We offer customized counseling, recognizing the specific challenges that public figures may encounter in their personal and professional lives. Emotional Regulation: Therapy can assist you in managing emotions related to public scrutiny, criticism, and constant attention. Stress Management: We’ll work on stress management techniques to help you navigate the demands of your public role. Coping Strategies: Our therapists will equip you with effective coping strategies to manage the unique stressors you may face. Balancing Personal and Professional Life: Therapy can help you find a balance between your personal life and the demands of your public career. Building Resilience: We’ll focus on developing resilience to handle the challenges of public life with strength and grace. Self-Care and Well-being: Our celebrity therapists emphasize self-care practices to support your emotional and mental well-being. The Celebrity Therapist London Package at Miss Date Doctor is designed to cater to your specific needs as a public figure, offering you a supportive and understanding space to navigate challenges and enhance your overall well-being. Invest in your emotional health and take the first step towards confidential support with the Celebrity Therapist London Package. Embrace the opportunity to receive specialized therapy services tailored to your unique experiences and demands as a public figure. Let our experienced celebrity therapists guide you towards greater emotional resilience, balance, and well-being. 6×1 hour sessions https://relationshipsmdd.com/product/celebrity-therapist-london-package/
In this Advanced Bridal Hair and Makeup Course you are taught 20+ Bridal Makeup Looks and 37+ Bridal Hairstyles with scope to creating more than 50 makeup looks and more than 50 hairstyles. This course is suitable for beginners (no experience required) and professionals wishing to update their existing knowledge and skills and add new ones. The course is accredited by the Guild of Beauty Therapists, one of the largest trade bodies in the beauty industry. Accredited certificates help to obtain liability insurance, discounts (upto 35%) from makeup brands, and access to specialised hairstyling products through trade only companies. Whereas, non-accredited courses run by many academies are unable to provide such benefits. Students Work After Course All makeup, hairstyling, jewellery and outfit setting is done solely by the student. Practice Sessions All makeup, false eyelashes, hair pieces, padding, hair products tools and equipment will be provided for students to use during the course in their practice sessions. During this Advanced Bridal Hair and Makeup Course you will be given full details of all products and tools used, both high end and cheaper alternatives. A lot of information is covered therefore students should take suitable notes and photographs to assist in further practice after the course. For the first 4 days you will be practising makeup techniques learnt on the course on a model which you can bring, or one can be provided for you for an extra fee of £60 per day. Training heads / mannequins will be provided for students to use during the hairstyling part of the course. It is not practical to use live models as multiple hairstyles are demonstrated each day and it is necessary to use different hair products and backcombing. Continuous backcombing and application of strong hair products on a live model would cause severe damage to the hair. View Content for Advanced Bridal Course: Day 1, Makeup : Health and Safety including safety practices for covid-19. Importance of using correct PPE. Keeping Products and equipment clean – brush cleaners and makeup sanitisers. Different types of lighting, makeup chairs, additional equipment for speed and efficiency. How to make your business cost effective. Different types of primers for eye makeup and face makeup, and which ones to use according to skin type and skin tone. Different types of foundations. How to assess different skin types and skin tones. How to select the correct eye primer, face primer and foundation. Different makeup removers. Different moisturisers for different skin types. Recommendations for eyeshadow palettes especially for beginners. How to blend eyeshadows seamlessly. How to do eyebrows, ombre, natural, and 3D. Different types of eyebrow products. Different types of eyelashes. How to correctly apply false lashes. Different types of colour correctors, and how to use them. How to highlight and contour. Highlights and contouring products. How to apply blusher. Recommendations for blusher colours for different looks. How to identify different skin undertones to help select correct face and eye products. How to set makeup for lasting results. How to avoid creasing under eyes and around mouth. How to stop lipstick bleeding. Covering dark circles and blemishes. How to apply lipstick including over-lining lips. Different types of lipsticks.x How to do eyeliner including winged eyeliner. How to do smokey eyes. Which brushes to use. Different types of eyeliner and how to preserve gel eyeliner. Traditional Asian Bridal Makeup. How to change soft bridal makeup to bold bridal makeup. Foundation colours required for different ethnicities. How to do Glitter makeup How to apply mascara. Day 2, Makeup : Smokey eye makeup Registry makeup Mehndi makeup Engagement makeup How to transform one makeup look into a completely different makeup look to save time where clients have booked for more than one event on the same day, and time constraints apply. Bold Makeup – how to Smokey Eye Makeup. Spotlight or halo makeup Subtle makeup. Ombre Makeup. Ombre glitter makeup How to apply pigments. How to use or apply liquid foundation. Different tools for different applications. Where to purchase makeup tools and makeup products. How to apply for pro makeup artist discount schemes. Soft cut crease makeup Different types of setting sprays. How to use different highlighting products. How to prevent creasing under the eye and mouth. How to makeup last longer. How to conduct client trials. How to manage bookings. How to avoid scams. How to conduct phone consultations. How to deal with difficult / fussy clients. Must have products for beginners and how to build up your kit. Reverse highlighting and contouring. Colour correction theory. How to use an artist colour wheel to coordinate eyeshadow colours. Customer care. How to use glitter. Day 3, Makeup : How to highlight and contour for different face shapes i.e. corrective highlighting and contouring. How to identify different eye shapes. How to apply makeup for different eye shapes. Advanced foundation makeup technique for flawless bridal makeup. Monolid eye makeup Protruding eye makeup Hooded eye makeup. Downturned eye makeup. How to select the correct style of lashes for different eye shapes. How to make small eyes look bigger. Different lip shapes and how to correct them. Ombre lips. How to make lips look bigger. Arabic makeup Cut crease makeup Double cut crease makeup Floating cut crease makeup Glitter cut crease makeup Day 4, Makeup : Photographic makeup technique. How to make your client look more than 2 tones lighter than their natural skin tone without skin looking grey or ashy. Dos and Don’ts of baking. Sweatproof / waterproof makeup. How to set makeup for hot weather and destination weddings in hot countries such as Dubai, etc. Glass skin technique and products. Nude lipstick for different skin tones. 3D eye makeup How to customise / change foundation colour for different skin tones. Makeup products for dark skin tones Mature ladies makeup techniques and products. Marketing and social media. How to organise your own photoshoots. Advice and tips on photography to showcase your work. European bridal makeup Day 5, Hairstyling : Health and Safety including safety practices for covid-19. Importance of using correct PPE. Advice on purchasing mannequins for further practice after the course. How to wash the mannequins hair and which products to use. How to apply for trade cards for specialist hair products. Must have hair products, high end and cheaper alternatives. Must have tools for hairstyling, high end and cheaper alternatives. What advice to give clients for prepping hair. How to conduct trials. How to prepare and conduct bookings. Customer care. How to avoid customer scams. Phone consultations. Which hair pieces required for different hairstyles and where to purchase. Different types of padding required for different hairstyles. How to make your own padding. Traditional bridal bun. How to create different designs on a bridal bun. How to section hair. How to create a vintage fringe with side parting. How to backcomb correctly. Half up half down. Layered vintage fringe with middle parting. Messy Plait. Low messy / curly bun. How to change one hairstyle into another to save time for clients with multiple bookings. How to pop synthetic hair. Different types of pins. How to secure jewellery where padding has been used in the hairstyle. How to secure the dupatta where padding has been used in the hairstyle. Day 6, Hairstyling : Side bun 1. Side bun 2. Greek braid 1. Greek braid 2. Structured bun. Simple curls (barrel or ringlet). Hollywood waves. How to prep hair. Products required to create different textures for different hairstyles. Textured updo. Messy updo. Textured updo. Messy updo. Textured fringe. How to curl synthetic hair. Mermaid hair. How to make curls last longer. Sleek bun. Sleek low bun. How to secure jewellery when no padding has been used for the hairstyle. How to secure the dupatta when no padding has been used for the hairstyle. Day 7, Hairstyling : French braid. Fishtail braid. Boho pull through braid. Textured plait. How to create extra long plaits for asian brides. Solutions for thinning hair. How to create volume for fine hair and medium thickness hair. Backcombing to create volume. How to apply clip-in hair extensions. Boho frech braid updo. French braid bridal updo. French twist. Textured hairstyle for the and / or short hair. Plaited fringe. Dutch twist braid. Dutch braid. Day 8, Hairstyling : Textured High Bun / Top Knot Low Textured Bun Textured Low Bun with Pulled Lines 3D Curls Half Up Half Down Textured Low Curly Bun Introduction to Russian / textured hairstyling. How to prep Hair for Russian Hairstyles. Products and tools required for Russian Hairstyling. How to create Texture for Russian Hairstyles. How to create lines for Russian Hairstyles. Different types of padding for Russian Hairstyling. Correct way to crimp hair. Correct way to backcomb hair. Optional Day 9, Photoshoot You will receive professionally edited images for your portfolio to kick start your new career. The model, photographer, jewellery and outfit are all provided. The tutor is present to provide guidance with the hairstyle and makeup thus reinforcing all that has been learnt on the course. Photoshoots take place on Tuesdays, Wednesdays, and Thursdays following the end of the hair and makeup course. The Photoshoot is Evidence of the Students Achievement The students portfolio work is strictly the students work only i.e. the student has done all the makeup, all the hairstyle, and all the jewellery and outfit setting by themselves at the end of the course without any physical help from the tutor or anyone from her team. Many other teaching establishments pass off pictures as students work whereas the tutor or helper usually do all the hairstyling, and dupatta and jewellery setting themselves, and the student only does the makeup, and in some instances makeup by the student is done on only half the face, whereas the tutor has done makeup on the other half. The whole point of doing a hair and makeup course should be so that the student can complete total hair and makeup looks by themselves by the end of the course without any further help. Course Benefits The Advanced Bridal Hair and Makeup Course teaches students to confidently style hair and apply makeup on asian, middle eastern and European brides and party guests for different functions. You will learn about hair and makeup products and tools. You will be able to offer your clients different styles of makeup both bold and subtle. You will be taught how to deal with clients with different features and skin tones (including dark skin tones). You are taught advanced bridal makeup techniques on the fourth day of the course. We teach you how to create several hairstyles from one basic foundation. We also show you how to transform one hairstyle into another within minutes. You will learn how to prep different hair textures. Students are taught a huge range of hairstyles including advanced bridal hairstyles. On the eighth day of the course students are taught how to create some Russian hairstyles and the latest textured hairstyles.You will gain a detailed knowledge of techniques and products both high end and cheaper brands. You will be able to start your business as a professional hair and makeup artist without wasting money on unnecessary products and equipment. Successful completion of the course rewards students with 3 accredited certificates: Asian Bridal Makeup, Asian Bridal Hairstyling, and Professional Standards for Therapists. Thus enabling students to apply for makeup discount schemes, and gain access to specialised tools and products from trade only companies for professional hairstylists. This course is designed to maximise the success of your business and earning potential. We teach you not just the current makeup trends and hairstyles but also the types of looks and hairstyles expected to be in demand in the near future. We are probably the only training academy offering students advice and tips on how to create their own portfolio to suit their budget. Fees & Enrolment for Advanced Bridal Course Class Size: All courses are limited to a maximum of 3 students per class. Each student receives plenty of individual attention in all aspects of learning to fully benefit from the course. Course Location: Slough, near Heathrow, Hounslow and Southall. Easily accessible by road (Junction 5 of M4) and train (Slough Station – Elizabeth Line (London Underground) and National Rail (15 minutes from Paddington station, central London)). Course Timings: 10am – 5pm Course Fee: £1595 for 8 Days without photoshoot or £2400 for 9 Days with photoshoot Course Dates are below. If these dates are not suitable then we may be able to accommodate provided we have 1-2 months advance notice, please ask. (Refreshments and lunch is provided free of charge)
Administering Microsoft SQL Server course description This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on how to use SQL Server 2016 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server 2016, but also the important capabilities across the SQL Server data platform. What will you learn Describe core database administration tasks and tools. Configure SQL Server databases and storage. Import and export data. Monitor SQL Server. Trace SQL Server activity. Manage SQL Server security. Audit data access and encrypt data. Administering Microsoft SQL Server course details Who will benefit: Individuals who work with SQL Server databases. Individuals who develop applications that deliver content from SQL Server databases. Prerequisites: Introduction to data communications & networking. Duration 3 days Administering Microsoft SQL Server course contents Introduction to SQL Server administration Database administration, SQL Server platform, database management tools and techniques. Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server. Working with databases and storage Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Hands on Configuring tempdb storage, creating databases, attaching a database. Importing and exporting data Transferring data, importing and exporting table data, copying or moving a database. Hands on import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function. Monitoring SQL Server 2014 Monitoring SQL Server, dynamic management views and functions, performance monitor. Hands on Baseline metrics, monitoring a workload. Tracing SQL Server activity Tracing workload activity, using traces. Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations. Managing SQL Server security SQL Server security, server-level security, database-level principals, database permissions. Hands on SQL Server security. Testing access.
Oracle SQL training course description The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create SQL statements to query database tables. Use standard aggregate functions and related SELECT statement clauses. Join Tables. Use basic subqueries and the set operators. Use numeric, character and date functions. Use conversion and other miscellaneous functions. Use SQL parameters. Use complex subqueries. Create and alter tables and views. Insert, update and delete rows in database tables. Manage sequences and synonyms. Oracle SQL training course details Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. Prerequisites: None. Duration 3 days Oracle SQL training course contents Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.
Definitive Segment Routing course description This Segment Routing (SR) training course is a comprehensive program designed to equip network professionals with the knowledge and skills needed to implement and manage SR in modern networking environments. Segment Routing is a cutting-edge network architecture that enhances network flexibility, scalability, and efficiency. This course offers in-depth coverage of SR principles, protocols, and practical implementation techniques. Hands on sessions are used to reinforce the theory rather than teach specific manufacturer equipment. What will you learn Explain packet paths when implementing SLB. Explain how Segment Routing works. Explain the relationship between SR and MPLS. Use SR for Traffic Engineering. Troubleshoot Segment Routing. Implement TI-LFA using Segment Routing Definitive Segment Routing course details Who will benefit: This course is ideal for network engineers, architects, and administrators who want to stay up-to-date with the latest networking technologies and enhance their expertise in Segment Routing. Prerequisites: Concise MPLS for engineers Duration 3 days Definitive Segment Routing course contents Introduction to Segment Routing (SR) What is SR? Source based routing, SPRING, history, segments, why SR? SR benefits.SR usage: Traffic Engineering, Shortest path, local protection. Relationship between SR and MPLS, SRv6. Hands on Investigating the base network. Segment Routing architecture SR domains, SR paths, SR segments. Segment types. Segment IDs, combining segments, IGP extensions, control plane components. Hands on Configuring SR, exploring how SR works, Segment Routing protocols SR-MPLS. MPLS label stack operations. Segment Routing Global Block (SRGB). SRLB. IS-IS and OSPF extensions for SR. Prefix segments, adjacency segments. SRGB/IGP interactions. Multidomain SR policies. SPF, Strict SPF. Hands on Analysing IGP SR extension operation. Investigating the SRGB. Segment Routing Traffic Engineering RSVP-TE versus SR-TE. SR policies. Anycast and binding SIDs. SR flexible algorithm flex-algo, Performance measurement delay. Hands on Optimising network paths for various applications. SR integration with 'older' technologies MPLS and LDP integration with SR. Hands on Integration. Topology Independent Loop Free Alternative Classic LFA and IP/MPLS protection mechanisms. TI-LFA protection options. Hands on TI-LFA operation with SR and LDP traffic. Scenarios SDN. Managing SR with SR controllers. Analyse, optimise, automate. Network slicing. BGP peering segments Path Computation Elements, BGP Link State. BGP prefix segments, BGP peer segments. Egress peer engineering. SR enabled VPNs. Hands onBGP segment routing. Troubleshooting Segment Routing IP toolkit: ping and traceroute. MPLS toolkit: MPLS ping, MPLS echo request/reply, MPLS ping, MPLS traceroute and path discovery. Router show commands. Hands on Used throughout the course during exercises. SRv6 Note this is an optional extra day. See our one day SRv6 course for details. IPv6 headers review, routing headers, IPv6 segment, SRv6 segment Identifiers. IPv6 Segment Routing Header. SRH procedures. Hands on Configuring SRv6, Analysing SRv6 operation.
MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.
5G training course description This course is designed to give the delegate an understanding of the technologies and interworking requirements of the next generation of cellular communications. It is not a definitive set of descriptions but a possibility of the final deployment. During the course we will investigate the 10 pillars for 5G, which will include various Radio Access Technologies that are required to interwork smoothly. Hence we will look at the 4G Pro features and other RATs. What will you learn List the ten pillars of 5G deployment. Explain the 5G Internet and Software Distributed Networks (SDN). Explain carrier aggregation, the mobile cloud and RAT virtualisation. Explain an overall picture of 5G architecture. 5G training course details Who will benefit: Anyone who is looking to work with next generation networks. Prerequisites: Mobile communications demystified Duration 3 days 5G training course contents Drivers for 5G 5G Road Map, 10 Pillars of 5G, evolving RATs, small cell, o SON, MTCm, mm-wave, backhaul, EE, new spectrum, spectrum sharing, RAN virtualisation. 4G LTE advanced features *MIMO, Downlink & uplink MIMO R8, MIMO technology in LTE advanced, Downlink 8-layer SU-MIMO, Downlink MU-MIMO, Uplink MU-MIMO, Uplink transmit diversity, Coordinated multi-point operation (CoMP), Independent eNB & remote base station configurations, Downlink CoMP, * Uplink Multi-Cell Reception. ICIC & eICIC ICIC, Homogeneous to heterogeneous network, eICIC, Macro-pico scenario, Macro-femto scenario, Time orthogonal frequencies. Almost Blank Subframe (ABS). Carrier aggregation Component carriers (CC), * CC aggregation, Intra-band contiguous solutions, Intra-band non-contiguous solutions, Inter-band non-contiguous solutions, CA bandwidth classes, Aggregated transmission bandwidth configurations (ATBC), Possible carrier aggregation configurations (Rel 9, 10 & 12). Enhanced Interference Mitigation & Traffic Adaptation (eIMTA) TDD UL-DL reconfiguration for traffic adaptation, Reconfiguration mechanisms, Interference mitigation schemes, Dynamic & flexible resource allocation. 5G architectures 5G in Europe, horizon 2020 framework, 5G infrastructure PPP, METIS project, innovation centre, 5G in North America, research, company R & D, 5G specifications. The 5G internet Cloud services, IoT & context awareness, network reconfiguration & virtualization support, hypervisors, SDN, the controller, service-oriented API, OpenFlow switches, SDN operation, SDN control for traffic flow redirection, OpenFlow controllers, how SDN works, application, control and infrastructure layers, a programmable network, how SDN & NFV tie together, SDN's downside, SDN orchestration, Mobility, architectures for distributed mobility management, MEDIEVAL & MEDIVO projects, a clean slate approach, mobility first architecture, network virtualization (VNet), INM, NetInf, ForMux, MEEM, GP & AM, QoS support, network resource provisioning, IntServ, RSVP, DiffServ, CoS, aggregated resource provisioning, SICAP, MARA, Emerging approach for resource over-provisioning, example use case architecture for the 5G internet, integrating SDN/NFV for efficient resource control, control information repository, service admission control policies, network resource provisioning, control enforcement functions, network configurations, network operations. Small cells for 5G Average spectral efficiency evolution, What are small cells? WiFi & Femto cells as candidate small-cell technologies, Capacity limits & achievable gains with densifications, gains with multi-antenna techniques, gains with small cells, Mobile data demand, approach & methodology, subscriber density projections, traffic demand projections, global mobile data traffic increase modelling, country level backhaul traffic projections, 2020 average spectrum requirement, Small cell challenges, backhaul, spectrum, automation. Cooperation for next generation wireless networks Cooperative diversity & relaying strategies, Cooperative ARQ & MAC protocols, NCCARQ & PRCSMA packet exchange, Physical layer impact on MAC protocol, NCCARQ overview, PHY layer impact, Performance evaluation, simulation scenario and results. Mobile clouds; technology & services for future communications platforms Mobile cloud, software, hardware and networking resources, Mobile cloud enablers, mobile user domain, wireless technologies, WWAN WLAN and WPAN range, Bluetooth, IEEE.802.15.4, software stacks, infrared, near field communications (NFC), store & forward vs compute & forward, random/linear network coding. Security for 5G communications Potential 5G architectures, Security issues & challenges in 5G, user equipment, mobile malware attacks, 5G mobile botnets, attacks on 4G networks, C-RNTI & packet sequence numbers based UE location tracking, false buffer status reports attacks, message insertion attacks, HeNB attacks, physical attacks, attacks on mobile operator's network, user data & identity attacks, DDoS attacks, amplification, HSS saturation, external IP networks.