• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

18759 Courses

Building ASP.net applications

5.0(3)

By Systems & Network Training

ASP.Net training course description Our hands on ASP.NET training course that will teach students how to create a simple ASP.NET application that delivers dynamic content to the web. The course is applicable for those using C# or VB.NET with ASP.NET. What will you learn Create a web form with server controls Separate page code from content with code-behind pages, page controls, and components. Display dynamic data from a data source by using ADO.NET and data binding. Debug ASP.NET pages by using trace. ASP.Net training course details Who will benefit: Programmers working with ASP.NET. Prerequisites: HTML5 development fundamentals VBNet_course.htm or C++ programming foundation Duration 3 days ASP.Net training course contents Working with ASP.NET Introducing ASP.NET. Creating web forms. Adding ASP.NET code to a page. Handling page events. Using Web Controls Web controls and HTML controls compared. Using intrinsic controls. Using input validation controls. Introduction to user controls. Using trace in ASP.NET pages Overview of tracing. Trace information. Page-level trace and application-level trace. Separating code from content Advantages of partitioning an ASP.NET page. Creating and using code-behind pages. Creating and using components and classes. Inheritance of classes. Interfaces. Using ADO .NET to access data Accessing text files. Overview of ADO .NET Connecting to a data source. Accessing data with DateSets. Using DataViews. Accessing data with DataReaders. Using XML data with a DataSet. Creating an ASP.NET Web Application Requirements of a web application. Sharing information between pages. Securing an ASP.NET application. Web services. Creating a simple web service using Visual Studio.NET Calling a web service using Visual Studio.NET

Building ASP.net applications
Delivered in Internationally or OnlineFlexible Dates
£2,367

Concise MPLS for engineers

5.0(3)

By Systems & Network Training

MPLS training course description A hands-on introduction to MPLS covering the basics of what MPLS is and how to configure it, through to more advanced concepts such as MPLS VPNs and traffic engineering with MPLS. What will you learn Describe MPLS Explain how MPLS works Describe the interaction between OSPF/IS-IS/BGP and MPLS Describe MPLS traffic engineering MPLS training course details Who will benefit: Anyone working with MPLS. Prerequisites: IP Routing BGP Duration 3 days MPLS training course contents What is MPLS? What does MPLS stand for? What is MPLS? Core MPLS, MPLS and the 7 layer model, MPLS is a protocol, MPLS is a standard, MPLS runs on routers, MPLS history, Why MPLS? For service providers, For enterprises. MPLS Architecture Label Switch Routers, two types of LSR, PE and P router roles, FEC, swapping labels, MPLS packet format, Loops, TTL control. Hands on: Building the base network. Enabling MPLS. Simple testing and troubleshooting of MPLS. Label distribution Label review, label switch path, label distribution methods, piggybacking, Label distribution Protocols, LDP, LDP operation, LDP packets, discovery messages, session messages, advertisement messages, notification message, Label Information Base, routing tables, the LFIB, MPLS forwarding, penultimate hop popping, handling labels, LSP control modes, when to distribute labels, how long to keep labels, aggregation, label merging. Hands on: LDP traffic analysis. MPLS TE and QoS What is MPLS TE? Why TE? TE versus shorted path, how MPLS TE works, CR-LDP, OSPF-TE, IS-IS-TE, TE with BGP, RSVP-TE, MPLS Fast reroute, MPLS QoS. Hands on: Enabling MPLS-TE. BFD BFD, hello the BFD protocol. MPLS VPN What is a VPN? MPLS VPN types, MPLS VPN comparison, MPLS L3 VPN, VRFs, MBGP, MPLS VPN architecture, VRF RD, VRF RT, the label stack, L2 VPNs, VPWS, AToM, VPLS. Hands on: MPLS L3 VPN setup, troubleshooting.

Concise MPLS for engineers
Delivered in Internationally or OnlineFlexible Dates
£2,367

Concise Cisco routing

5.0(3)

By Systems & Network Training

Concise Cisco routers course description A fast paced practical hands on introduction to Cisco routers concentrating on basic product knowledge needed for the real world. Starts with the basics of routing through configuring static routes, RIP, OSPF, and EIGRP ending with access lists. Hands on sessions follow all the major chapters with a major practical at the end to reinforce all that was learnt in the course. What will you learn Use the Cisco setup script. Use the Cisco command line. Perform basic troubleshooting. Configure - Interfaces - RIP, IGRP - OSPF, EIGRP Concise Cisco routers course details Who will benefit: Anyone who will be working with Cisco routers. In particular: Network Administrators, Field engineers, Network support personnel Prerequisites: None, although a knowledge of the TCP/IP protocols would be advantageous. Duration 3 days Concise Cisco routers course content Basics of routing What are routers? Network protocols, Routing protocols. The Cisco routers Router models, The IOS, DRAM, SRAM, NVRAM, Flash, ROM and boot flash. Getting started Accessing the router, installing a Cisco, using the setup script. The command line interface User and privilege modes, online help show, debug, basic troubleshooting Configuring Ciscos The configuration editor, Global, major and sub commands, enable, secret and other passwords, telnet. Miscellaneous exercises Buffered logging, web access, CDP… Subnetting IP addressing rules. The need for subnetting, subnet masks, Calculating network numbers. Configuring Interfaces Basics, Ethernet, Serial lines, PPP, DCE, loopback interfaces. Static routes Why use static routes? Configuring static routes, default routes. Configuring RIP and IGRP How they work, configuration, troubleshooting. OSPF Configuration and troubleshooting. EIGRP Configuration and troubleshooting. Housekeeping Configuration management, offline editing and TFTP usage. Cisco boot sequence, IOS upgrades. Bypassing Cisco passwords. Access lists What are access lists? General rules, basic and extended IP access lists. Putting it all together A series of exercises based around, installs, adds, moves, changes, upgrades and troubleshootin

Concise Cisco routing
Delivered in Internationally or OnlineFlexible Dates
£2,367

Definitive Segment Routing for engineers

5.0(3)

By Systems & Network Training

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.

Definitive Segment Routing for engineers
Delivered in Internationally or OnlineFlexible Dates
£2,367

MySQL Performance & Tuning

5.0(3)

By Systems & Network Training

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

MySQL Performance & Tuning
Delivered in Internationally or OnlineFlexible Dates
£2,367

Web development fundamentals

5.0(3)

By Systems & Network Training

Web development training course description This three-day course helps build a foundation in the development of Web applications. This is not a HTML course but covers the technologies needed to develop web applications. Technologies covered include: ASP.NET, XML, AJAX and HTTP error codes. What will you learn Program Web applications. Work with data and services. Troubleshoot and debug Web applications. Work with client side scripting. Configure and deploy web applications. Web development training course details Who will benefit: Anyone looking for an introduction to web development. Prerequisites: None. Duration 3 days Web development training course contents Programming web applications Customise the layout and appearance of a web page CSS; tables; embedding images; page layout for navigation. Understand ASP.NET intrinsic objects Request; Server; Application; Session; Response; HttpContext. Understand state information in web applications Understand how state is stored based on application design and hardware; understand different types such as session state, view state, control state and application state. Understand events and control page flow Application and page life cycle events; page events; control events; application events; session events; cross-page posting; Response.Redirect; Server.Transfer; IsPostBack; setting AutoEventWireup. Understand controls Understanding various types of controls, including user, server, web and validation controls; know which is the appropriate type of control for a scenario. Understand configuration files Understanding the usage of web.config and machine.config, and the settings that can be made. Working with data and services Read and write XML data Understanding XML, XML validation Does not include: Web services; XPath syntax; XmlDocument; XPathNavigator; XPathNodeIterator; XPathDocument; XmlReader; XmlWriter; XmlDataDocument; XmlNamespaceManager. Distinguish between DataSet & DataReader objects The ability to choose the proper data object to use based on application requirements/design. Call a service from a web page Creating a basic WCF service or web service so that it can be consumed; App_WebReferences; configuration. Understand DataSource controls LinqDataSource: ObjectDataSource; XmlDataSource; SqlDataSource. Bind controls to data by using data binding syntax Ensure that data is updated and displayed in data-aware controls. Manage data connections and databases Database connections; connection objects; connection pools; transaction objects. Troubleshooting and debugging web applications Debug a web application Use in conjunction with custom error pages to display appropriate error information to the appropriate user; implement tracing of a web application, Trace.axd, Trace=True on @Page directive. Handle web application errors HTTP error codes. Working with client-side scripting Understand client-side scripting Purpose of client-side scripting; various client-side scripting languages. LE/370 and Intrinsic Functions. Understand AJAX concepts ASP.NET AJAX implementation; working with client-side libraries, EnablePartialRendering, Triggers, ChildrenAsTriggers, Scripts, Services, UpdateProgress, Timer, ScriptManagerProxy, extender controls. Configuring and deploying web applications Configure authentication and authorisation Forms authentication, Windows authentication; authorisation; file authorisation; impersonation Does not include: Windows Cardspace authentication, Passport (Windows Live ID) authentication, Custom authentication. Configure projects, solutions and reference assemblies Local assemblies; shared assemblies (GAC); web application projects; solutions; configuration files; AppSettings. Publish web applications Choosing the appropriate method to deploy an application based on existing or intended environment; updatable vs. not updateable; MSI deployment; Internet Information Server (IIS) installation and configuration. Understand application pools Purpose of application pools; effect of application pools on web applications.

Web development fundamentals
Delivered in Internationally or OnlineFlexible Dates
£2,367

Essential 5G

5.0(3)

By Systems & Network Training

Essential 5G training course description This course is designed to give delegates an explanation 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. we will investigate the 10 pillars for 5G which will include various Radio Access Technologies that are required to interwork smoothly. We will look at the 4G Pro features and other RATs. What will you learn List the ten pillars of 5G deployment. Describe the 5G Internet. Explain virtualization and RAT virtulization. Describe Software Defined Networks (SDN). Explain carrier aggregation. Describe the mobile cloud. Explain an overall picture of 5G architecture. Essential 5G training course details Who will benefit: Anyone looking for an understanding of the technologies and interworking requirements of the next generation of cellular communications. Prerequisites: None. Duration 3 days Essential 5G training course contents Drivers for 5G 5G Road Map, 10 Pillars of 5G, evolving RATs, oSON, MTCm, mm-wave, backhaul, EE, new spectrum, spectrum sharing, RAN virtualisation. 4G LTE Advanced MIMO technology in release 8, 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. ICIC & eICIC ICIC, Homogeneous to heterogeneous network evolution, Introduction to eICIC, Macro-pico scenario, Macro-femto scenario, Time orthogonal frequencies. Almost Blank Subframe (ABS). Carrier aggregation Component carriers (CC), CC aggregation deployments, 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 configs. eIMTA TDD UL-DL reconfig. for traffic adaptation, Reconfig. mechanisms, Interference mitigation schemes, Dynamic & flexible resource allocation. 5G architectures 5G in Europe, horizon 2020 framework, 5G infrastructure PPP, METIS project, 5G in North America, academy research, company R&D, 5G specifications. The 5G internet High-level view of Cloud Services, The Internet of Things & context awareness, Network reconfiguration & virtualization support, server proliferation, how VMs fix underutilised server problem, enter the hypervisor, why are VM such a big deal? SDN, evolution of the data centre network, high availability, low latency, scalability, security, cost model explodes, service-oriented API. OpenFlow switches, OpenFlow controllers, how SDN works. The big picture, pulling it all together, why the network had to change, how SDN & NFV tie together. Evolutionary approach to the internet, architectures for distributed mobility management, MEDIEVAL & MEDIVO projects, a clean slate approach, mobility first architecture. VNet, INM, NetInf, ForMux, MEEM. Generic Path (GP) & anchorless mobility (AM), Quality of Service support, network resource provisioning, resourcing inside a network. IntServ, RSVP, DiffServ, CoS. Emerging approach for resource over- provisioning, example use case architecture for scalable resource control scenarios in the 5G internet. Integrating SDN/NFV for efficient resource over-reservation control, control information repository, service admission control policies, network resource provisioning, control enforcement functions, network configurations & operations. Small cells for 5G Average spectral efficiency evolution, WiFi & Femto cells, Capacity limits. Achievable gains with densifications, multi-antenna techniques, small cells. Mobile data demand, approach & methodology, subscriber density and traffic demand projections to 2020. Demand versus capacity, global mobile data traffic increase modelling, country level backhaul traffic projections, Small cell challenges, backhaul, spectrum, automation. Cooperation for next gen wireless networks Diversity & relaying strategies, cooperation & network coding, ARQ & MAC protocols, NCCARQ & PRCSMA packet exchange, Physical layer impact on MAC protocol analysis, NCCARQ overview, PHY layer impact, Case study on NCCARQ. Mobile clouds Mobile cloud, 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). Network coding, store & forward vs compute & forward, linear network coding, random linear coding. Security for 5G communications Potential 5G communication systems architectures, Security issues & challenges. Mobile malware attacks targeting the UE, 5G mobile botnets, access networks, attacks on 4G networks, C-RNTI & packet sequence number based UE location tracking, false buffer status reports attacks, message insertion attacks, HeNB attacks, physical attacks, credential attacks, configuration and protocol attacks, attacks on MON, user data & identity attacks, mobile operator's core network, DDoS attacks targeting MON, signalling amplification, HSS saturation, external IP networks.

Essential 5G
Delivered in Internationally or OnlineFlexible Dates
£2,367

Chemical Engineering for Non-Chemical Engineers

By EnergyEdge - Training for a Sustainable Energy Future

Enhance your knowledge of chemical engineering with EnergyEdge's course for non-chemical engineers. Enroll now to gain valuable insights.

Chemical Engineering for Non-Chemical Engineers
Delivered In-PersonFlexible Dates
£2,899 to £3,099

ASIAN BRIDAL HAIRSTYLING and MAKEUP COURSE (8 DAYS) – Accredited, Certified, & Insurable

5.0(48)

By Asian Bridal Looks

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)

ASIAN BRIDAL HAIRSTYLING and MAKEUP COURSE (8 DAYS) – Accredited, Certified, & Insurable
Delivered In-PersonFlexible Dates
£1,595 to £2,400

Introduction to SQL

5.0(3)

By Systems & Network Training

Intro to SQL training course description A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms. What will you learn Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to define databases. Intro to SQL training course details Who will benefit: Anyone working with databases. Prerequisites: None. Duration 2 days Intro to SQL training course contents What is SQL? What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends. Database basics RDBMS, Tables. Hands on Investigating a database. Basic SQL commands SQL Overview: SQL DML, SQL DDL, SQL queries. SELECT, WHERE and ORDER BY clauses. Combining conditions. IN, LIKE and BETWEEN. Hands on Querying a database from existing tables. SQL data retrieval Scalar functions. Hands on Selecting data from an existing database. More SQL data retrieval Scalar functions, variations. Aggregate functions, GROUP BY. HAVING. Hands on Selecting data from an existing database. Table joins Multiple tables, joins, keys, inner joins, left joins, right joins. Hands on Selecting data from an existing database. SQL basic data manipulation INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK. Hands on Modifying data in tables. SQL Data Definition USE, CREATE, DROP, TRUNCATE, ALTER. Hands on Managing new tables and columns. Data control GRANT, REVOKE. Hands on Defining permissions.

Introduction to SQL
Delivered in Internationally or OnlineFlexible Dates
£1,497