112 Wrap courses in London

Learn the ‘Essentials’ of gift wrapping in just 90 minutes (with your friends!) What’s included (and how it will help): Step by step tuition covering all the Essential Techniques of gift wrapping so you never need to grab a gift/bottle bag again Practical guidance on tying different styles of Ribbon Bow so you can confidently use them on any gift (and when it’s best to use each one) Learn Pro tips so you feel less overwhelmed & can gift wrap quickly at busy times With many years experience teaching classes, both one to one and in groups, you will complete the class feeling confident that your gift wrapping will never be an embarrassment to you again. 90 Minute Group Class No Replay £97 How to measure exactly how much gift wrapping paper you need so you always know how much to cut (and why this is important) Wrap a box using the paper & only 3 pieces of tape so you can do this quickly & easily Learn to tie 2 differnt styles of bow (and when to use them) How to pleat gift wrapping paper so you can add extra detail to a gift How to wrap a bottle so you never need to grab a bottle bag again 90 Minute Group Class Includes replay ££117 How to measure exactly how much gift wrapping paper you need so you always know how much to cut (and why this is important) Wrap a box using the paper & only 3 pieces of tape so you can do this quickly & easily Learn to tie 2 differnt styles of bow (and when to use them) How to pleat gift wrapping paper so you can add extra detail to a gift How to wrap a bottle so you never need to grab a bottle bag again Plus a replay of the class FREQUENTLY ASKED QUESTIONS 1. What's included in a 90 minute virtual class? Step by step tuition covering all the Essential Techniques of gift wrapping so you never need to grab a gift/bottle bag again Practical guidance on tying different styles of Ribbon Bow so you can confidently use them on any gift (and when it’s best to use each one) Learn Pro tips so you feel less overwhelmed & can gift wrap quickly at busy times 2. How much is a 90 minute virtual gift wrapping class?There are 2 options to choose from starting from £97 per person3. How long does a virtual gift wrapping class last?A group virtual gift wrapping class lasts 90 minutes but I recommend allowing 2 hours in case there are any tech issue (unlikely but better to be prepared).4. Are materials provided?No, materials are not provided. I will send you a list of what you need at least 2 weeks ahead of the class (or once your booking is confirmed if less than 2 weeks until the class)5. What is the difference between an in person & a virtual workshop?At a 90 minute virtual class you will get tuition on essential gift wrapping techniques, practical guidance on tying different styles of bow & learn pro tips. An in-person class ususally last a full day, includes lunch/refreshments and all materials which are not included with any virtual classes. 6. What if I can't attend the class - do I get a refund?If you can bo longer attend the date of the class you have chosen, you may move your booking to another date, once, at no extra charge. I do limit the number of people at a group virtual class so if your chosen date to move to is full, you may need to wait until another class becomes available. If no class is available then you will be eligible for a refund. 7. Who is a virtual class suitable for?The classes are suitable for any skill level from beginner to anyone that has already tried the basics and wants to learn more. A group class is ideal if want to attend with a group of friends but you struggle to attend an in person class that fits in with your schedule/commitments. 8. Who is a virtual class not suitable for? There are no exclusions to suitability 9. What results can I expect if I attend a virtual class?That all depends on you and if you’re prepared to go away and practice/use the skills you have learned in the class. 10. Is there a replay? You do have the option to buy a class that includes a recording. If you decide after the class that you’d like to purchase a recording, email me louise@louiselewis.co.uk

Are you interested in learning Vehicle Wrapping, and have you been thinking 'Where can I find a Vehicle Wrapping Course near me?'. Well, you are at the right place. You can now learn all the basics of Vehicle Wrapping and its best practices from your home. Welcome to our comprehensive vehicle wrapping course solely dedicated to enthusiasts, beginners, and professionals who share a desire to transform automobiles into works of art. This course is designed to provide the skills and information you need to improve your car customisation game. Whether you are a DIY enthusiast or an aspiring professional, this training will meet your learning goals. Each session will gradually increase your knowledge of everything from fundamental automobile preparation to advanced vinyl wrapping techniques. Through this course, you will learn the fundamentals of vehicle care and the art of washing; car detailing essentials and the details of vinyl wrapping a hood; the art of wrapping different car panels, including doors, fenders, and rear quarters; Inlays, emblem, and badge removal techniques for a seamless finish; and Wrapping additional components such as trunks, side skirts, bumpers, and even side mirrors. In addition, you also learn invaluable tips and tricks, such as adding a buffer to the squeegee, cutting edges with precision, and utilising specialised tools like Knifeless Tape. These insights ensure you learn the techniques and adopt industry best practices. By the end of this course, you will be a knowledgeable automotive detailing and automobile wrapping expert. With competence in handling every panel, corner, and logo, you will be confident in transforming any car from ordinary to eye-catching. What are you waiting for? Dive deep into the vinyl wrapping course to unleash your imagination and let your creativity flow. Prepare to dazzle with your newly gained skills in automotive customising as you redefine vehicle aesthetics! What you will learn from this Vehicle Wrapping Course Fundamentals of vehicle care and washing techniques. Car detailing and preparation processes for effective wrapping. Proper usage of tools, including adding a buffer to the squeegee, cutting edges with precision, and utilising Knifeless Tape. Wrapping techniques for various automotive parts, including the hood, fenders, doors, rear quarter panels, trunks, side skirts, bumpers, front bumper, and mirrors. Removal and application techniques for various components, such as bumpers, headlights, door handles, emblems, and badges. Inlay creation and its appropriate use in vinyl wrapping. Tips for efficient material usage and cutting to save resources. Entry Requirement Anyone interested in learning more about this subject should take this Vehicle Wrapping Course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. 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 The Vehicle Wrapping Course will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Vehicle Wrapping Course Module 01: Vehicle Wash 00:04:00 Module 02: Car Detailing & Preparation of the vehicle 00:05:00 Module 03: How To Use The Squeegee 00:08:00 Module 04: How To Vinyl Wrap A Hood With Air Vents 00:04:00 Module 05: How To Remove Bumpers & Headlights 00:05:00 Module 06: How To Vinyl Wrap A Fender 00:07:00 Module 07: How To Cut The Vinyl Wrap Material For Each Panel To Save Material 00:05:00 Module 08: How To Remove The Door Handles 00:08:00 Module 09: How To Vinyl Wrap The Doors for Vehicle Wrapping 00:06:00 Module 10: Door Handle Vinyl Wrap for Vehicle Wrapping 00:08:00 Module 11: How To Wrap the Rear Quarter Panel for Vehicle Wrapping 00:08:00 Module 12: How To Make an Inlay and When To Use an Inlay for Vehicle Wrapping 00:05:00 Module 13: Trunk Vinyl Wrap for Vehicle Wrapping 00:07:00 Module 14: Side Skirts Vinyl Wrap for Vehicle Wrapping 00:09:00 Module 15: How to Remove the Roof Antenna for Vehicle Wrapping 00:10:00 Module 16: How To Vinyl Wrap the Roof for Vehicle Wrapping 00:06:00 Module 17: How To Vinyl Wrap The Rear Bumper for Vehicle Wrapping 00:08:00 Module 18: How To Vinyl Wrap The Front Bumper for Vehicle Wrapping 00:10:00 Module 19: Side Mirrors Vinyl Wrap for Vehicle Wrapping 00:11:00 Module 20: How to install the Emblems the correct way 00:09:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

If you are a newbie in the field of ethical hacking or want to become an ethical hacker, this course is just what will get you started. This is a comprehensive course with real-world examples to help you understand the fundamentals of hacking and cyber security.

Overview This comprehensive course on SQL NoSQL Big Data and Hadoop will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This SQL NoSQL Big Data and Hadoop comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this SQL NoSQL Big Data and Hadoop. It is available to all students, of all academic backgrounds. Requirements Our SQL NoSQL Big Data and Hadoop is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 14 sections • 130 lectures • 22:34:00 total length •Introduction: 00:07:00 •Building a Data-driven Organization - Introduction: 00:04:00 •Data Engineering: 00:06:00 •Learning Environment & Course Material: 00:04:00 •Movielens Dataset: 00:03:00 •Introduction to Relational Databases: 00:09:00 •SQL: 00:05:00 •Movielens Relational Model: 00:15:00 •Movielens Relational Model: Normalization vs Denormalization: 00:16:00 •MySQL: 00:05:00 •Movielens in MySQL: Database import: 00:06:00 •OLTP in RDBMS: CRUD Applications: 00:17:00 •Indexes: 00:16:00 •Data Warehousing: 00:15:00 •Analytical Processing: 00:17:00 •Transaction Logs: 00:06:00 •Relational Databases - Wrap Up: 00:03:00 •Distributed Databases: 00:07:00 •CAP Theorem: 00:10:00 •BASE: 00:07:00 •Other Classifications: 00:07:00 •Introduction to KV Stores: 00:02:00 •Redis: 00:04:00 •Install Redis: 00:07:00 •Time Complexity of Algorithm: 00:05:00 •Data Structures in Redis : Key & String: 00:20:00 •Data Structures in Redis II : Hash & List: 00:18:00 •Data structures in Redis III : Set & Sorted Set: 00:21:00 •Data structures in Redis IV : Geo & HyperLogLog: 00:11:00 •Data structures in Redis V : Pubsub & Transaction: 00:08:00 •Modelling Movielens in Redis: 00:11:00 •Redis Example in Application: 00:29:00 •KV Stores: Wrap Up: 00:02:00 •Introduction to Document-Oriented Databases: 00:05:00 •MongoDB: 00:04:00 •MongoDB Installation: 00:02:00 •Movielens in MongoDB: 00:13:00 •Movielens in MongoDB: Normalization vs Denormalization: 00:11:00 •Movielens in MongoDB: Implementation: 00:10:00 •CRUD Operations in MongoDB: 00:13:00 •Indexes: 00:16:00 •MongoDB Aggregation Query - MapReduce function: 00:09:00 •MongoDB Aggregation Query - Aggregation Framework: 00:16:00 •Demo: MySQL vs MongoDB. Modeling with Spark: 00:02:00 •Document Stores: Wrap Up: 00:03:00 •Introduction to Search Engine Stores: 00:05:00 •Elasticsearch: 00:09:00 •Basic Terms Concepts and Description: 00:13:00 •Movielens in Elastisearch: 00:12:00 •CRUD in Elasticsearch: 00:15:00 •Search Queries in Elasticsearch: 00:23:00 •Aggregation Queries in Elasticsearch: 00:23:00 •The Elastic Stack (ELK): 00:12:00 •Use case: UFO Sighting in ElasticSearch: 00:29:00 •Search Engines: Wrap Up: 00:04:00 •Introduction to Columnar databases: 00:06:00 •HBase: 00:07:00 •HBase Architecture: 00:09:00 •HBase Installation: 00:09:00 •Apache Zookeeper: 00:06:00 •Movielens Data in HBase: 00:17:00 •Performing CRUD in HBase: 00:24:00 •SQL on HBase - Apache Phoenix: 00:14:00 •SQL on HBase - Apache Phoenix - Movielens: 00:10:00 •Demo : GeoLife GPS Trajectories: 00:02:00 •Wide Column Store: Wrap Up: 00:05:00 •Introduction to Time Series: 00:09:00 •InfluxDB: 00:03:00 •InfluxDB Installation: 00:07:00 •InfluxDB Data Model: 00:07:00 •Data manipulation in InfluxDB: 00:17:00 •TICK Stack I: 00:12:00 •TICK Stack II: 00:23:00 •Time Series Databases: Wrap Up: 00:04:00 •Introduction to Graph Databases: 00:05:00 •Modelling in Graph: 00:14:00 •Modelling Movielens as a Graph: 00:10:00 •Neo4J: 00:04:00 •Neo4J installation: 00:08:00 •Cypher: 00:12:00 •Cypher II: 00:19:00 •Movielens in Neo4J: Data Import: 00:17:00 •Movielens in Neo4J: Spring Application: 00:12:00 •Data Analysis in Graph Databases: 00:05:00 •Examples of Graph Algorithms in Neo4J: 00:18:00 •Graph Databases: Wrap Up: 00:07:00 •Introduction to Big Data With Apache Hadoop: 00:06:00 •Big Data Storage in Hadoop (HDFS): 00:16:00 •Big Data Processing : YARN: 00:11:00 •Installation: 00:13:00 •Data Processing in Hadoop (MapReduce): 00:14:00 •Examples in MapReduce: 00:25:00 •Data Processing in Hadoop (Pig): 00:12:00 •Examples in Pig: 00:21:00 •Data Processing in Hadoop (Spark): 00:23:00 •Examples in Spark: 00:23:00 •Data Analytics with Apache Spark: 00:09:00 •Data Compression: 00:06:00 •Data serialization and storage formats: 00:20:00 •Hadoop: Wrap Up: 00:07:00 •Introduction Big Data SQL Engines: 00:03:00 •Apache Hive: 00:10:00 •Apache Hive : Demonstration: 00:20:00 •MPP SQL-on-Hadoop: Introduction: 00:03:00 •Impala: 00:06:00 •Impala : Demonstration: 00:18:00 •PrestoDB: 00:13:00 •PrestoDB : Demonstration: 00:14:00 •SQL-on-Hadoop: Wrap Up: 00:02:00 •Data Architectures: 00:05:00 •Introduction to Distributed Commit Logs: 00:07:00 •Apache Kafka: 00:03:00 •Confluent Platform Installation: 00:10:00 •Data Modeling in Kafka I: 00:13:00 •Data Modeling in Kafka II: 00:15:00 •Data Generation for Testing: 00:09:00 •Use case: Toll fee Collection: 00:04:00 •Stream processing: 00:11:00 •Stream Processing II with Stream + Connect APIs: 00:19:00 •Example: Kafka Streams: 00:15:00 •KSQL : Streaming Processing in SQL: 00:04:00 •KSQL: Example: 00:14:00 •Demonstration: NYC Taxi and Fares: 00:01:00 •Streaming: Wrap Up: 00:02:00 •Database Polyglot: 00:04:00 •Extending your knowledge: 00:08:00 •Data Visualization: 00:11:00 •Building a Data-driven Organization - Conclusion: 00:07:00 •Conclusion: 00:03:00 •Assignment -SQL NoSQL Big Data and Hadoop: 00:00:00

Create 3 useful desktop applications with web technologies using Electron

Learn the Essentials of Gift Wrapping & have some fun with your team this festive season  What’s included (and how it will help): Step by step tuition covering all the Essential Techniques of gift wrapping so they never need to grab a gift/bottle bag again Practical guidance on tying different styles of Ribbon Bow so they can confidently use them on any gift (and when it’s best to use each one) Learn Pro tips so you feel less overwhelmed & can gift wrap quickly at busy times Plus all materials are provided A class is a great opportunity for team building/bonding so that people get to know each other outside of a work setting and/or meet people in person. It’s an inclusive alternative to a Christmas party (boozy meals/discos aren’t for everyone) and everyone gets to take away a gift at the end of the class. Packages start from £597 for groups of up to 10 people. Dates & times can be booked to suit. Book a call below to discuss your requirements.

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! Are you ready to embark on a journey of scientific discovery? The Organic Chemistry Diploma bundle is your passport to unlocking the secrets of the chemical world. Let these courses transport you to the very heart of organic chemistry, biochemistry, genetics, and more. With a QLS-endorsed Organic Chemistry course as the star of the show, you'll receive a hardcopy certificate upon completion - a symbol of your dedication to the scientific field. And the best part? This is just the beginning. You'll have access to ten other courses, all of which are CPD-QS accredited, each offering a unique perspective on the fascinating world of organic chemistry. From mastering the fundamentals of microbiology to understanding the intricacies of biomedical science, this bundle offers something for everyone. Discover the chemical building blocks of life, explore the secrets of genetics, and learn how to keep yourself and your lab safe with courses like Chemical Spill and Infection Prevention & Control Training. And with remote teaching strategies and lesson planning for teaching, you'll even learn how to pass on your newfound knowledge to others. So what are you waiting for? Dive into the world of organic chemistry with this exceptional bundle and join the ranks of the world's top chemists. The future is yours to discover! This Organic Chemistry Diploma Bundle Package includes: Course 01: Advanced Diploma in Organic Chemistry at QLS Level 7 10 Premium Additional CPD QS Accredited Courses - Course 01: Biomedical Science Course 02: Biochemistry Course 03: Lab Analyst Training Course 04: Chemical Spill Course 05: Microbiology Laboratory Technician Course 06: Chemistry for Everyone Course 07: Genetics Course 08: Infection Prevention & Control Training Course 09: Remote Teaching Strategies Course 10: Lesson Planning for Teaching Why Prefer This Organic Chemistry Diploma Bundle? You will receive a completely free certificate from the Quality Licence Scheme Option to purchase 10 additional certificates accredited by CPD Get a free Student ID Card - (£10 postal charges will be applicable for international delivery) Free assessments and immediate success results 24/7 Tutor Support After taking this Organic Chemistry Diploma bundle courses, you will be able to learn: Develop a thorough understanding of organic chemistry, biochemistry, genetics, and more. Master the fundamentals of microbiology and learn how to keep yourself and your lab safe. Explore the chemical building blocks of life and discover the secrets of biomedical science. Learn to plan and execute chemical experiments with confidence. Develop critical thinking skills and the ability to analyse complex scientific data. Learn how to teach others about the world of organic chemistry. Gain a valuable QLS-endorsed certificate to enhance your CV. ***Curriculum breakdown of Organic Chemistry*** Section 01: Alkane series Introduction to the Alkane Series Conjugation and Homologous Series of the Alkane Nomenclature of the Alkane Series Chemistry of the Alkane Series Relevance and Importance of the Alkene Family Section Wrap Up Section 02: Alkene Series Introduction to the Alkene series Nomenclature of the Alkene Series Chemistry of the Alkene Series Relevance and Importance of the Alkene Family Section Wrap Up Section 03: Alkanol Series Introduction to the Alkanol Series Nomenclature of the Alkanol Series Chemistry of the Alkanol Series Relevance and Importance of the Alkanol Family Section Wrap Up Section 04: Alkyne series Introduction to the Alkyne Series Nomenclature of the Alkyne Series Chemistry of the Alkene Series Importance and Relevance of the Alkene Family Section Wrap Up Section 05: Alkanals and Aldehydes Introduction to the Alkanals/Aldehydes and Ketones/Alkanones Family How is the Organic Chemistry Diploma Bundle Assessment Process? You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you successfully pass the exams. CPD 280 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle of courses is ideal for: Students who want to pursue a career in the scientific field. Professionals who wish to expand their knowledge of organic chemistry. Teachers who want to enhance their teaching skills in the scientific field. Anyone interested in gaining a deeper understanding of the chemical world. Career path This bundle will be beneficial for anyone looking to pursue a career as: Laboratory Analyst: £20,000 - £35,000 per annum. Microbiologist: £25,000 - £40,000 per annum. Biomedical Scientist: £24,000 - £43,000 per annum. Chemical Engineer: £30,000 - £60,000 per annum. Genetics Counselor: £24,000 - £70,000 per annum. Science Teacher: £25,000 - £45,000 per annum. Certificates Advanced Diploma in Organic Chemistry at QLS Level 7 Hard copy certificate - Included After successfully completing thecourse, you can order an original hardcopy Certificate of Achievement endorsed by the Quality Licence Scheme. This certificate will be delivered to your home, free of charge. To obtain the additional Quality Licence Scheme Endorsed Certificate, you will need to pay the corresponding fee based on the level of the courses: Level 1: £59 Level 2: £79 Level 3: £89 Level 4: £99 Level 5: £119 Level 6: £129 Level 7: £139 CPD QS Accredited Certificate Digital certificate - £10 Upon successfully completing the Bundle, you will need to place an order to receive a PDF Certificate for each course within the bundle. These certificates serve as proof of your newly acquired skills, accredited by CPD QS and will cost you £10 for each course. Also, the certificates are recognised throughout the UK and internationally. CPD QS Accredited Certificate Hard copy certificate - £29 International students are subject to a £10 delivery fee for their orders, based on their location.

Register on the SQL Server : Basic Microsoft SQL Server today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The SQL Server : Basic Microsoft SQL Server is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The SQL Server : Basic Microsoft SQL Server Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the SQL Server : Basic Microsoft SQL Server, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Unit 01: Course and Instructor Introduction Course and Instructor Introduction 00:05:00 Unit 02: Laying out the foundation - Overview & Installation Pre-requisites & Different Editions of SQL Server 00:06:00 Downloading Express Edition & sample database 00:03:00 Installing the downloads & Configuration 00:19:00 The sa Login 00:04:00 Wrap up - what we went over! 00:01:00 Unit 03: Core concepts - Taming the RDBMS beast! What is RDBMS? 00:12:00 Where does SQL Server fit in? 00:02:00 Basic database objects 00:16:00 Different Files that got installed - MDF & LDF 00:03:00 Wrap up - what we went over! 00:01:00 Unit 04: Tool of the trade - SQL Server Management Studio Getting started with SSMS 00:07:00 Getting around Object Explorer 00:05:00 Query Window 00:06:00 Pre-built DB - system database 00:04:00 Wrap up - what we went over! 00:01:00 Unit 05: Simple SELECT Bare Minimum: SELECTING a literal 00:05:00 Retrieving / querying data from a table - using FROM clause 00:06:00 Playing with Column Names 00:03:00 Rearranging columns to your liking 00:01:00 Wrap up - what we went over! 00:01:00 Unit 06: Filtering out unwanted data Narrowing down and ordering result set - WHERE and ORDER clause 00:17:00 Narrowing down result set - BETWEEN / NOT BETWEEN 00:09:00 Narrowing down result set - IN and NOT IN operator 00:05:00 Narrowing down result set - Pattern Matching: LIKE and Wildcards 00:11:00 Wrap up - what we went over! 00:01:00 Unit 07: Expressions and Functions Dealing with nothing: NULL 00:06:00 Working with strings: Concatenation and other string functions 00:15:00 Working with dates: Date Functions 00:07:00 Some System Functions 00:05:00 Wrap up - what we went over! 00:02:00 Unit 08: Getting data out of multiple tables Joining multiple tables - INNER JOIN 00:09:00 Join types - OUTER JOIN - LEFT / RIGHT / FULL 00:08:00 Join types - CROSS JOIN 00:02:00 Holy UNION! 00:03:00 Subqueries 00:04:00 Wrap up - what we went over! 00:02:00 Unit 09: Summarizing and Grouping data DISTINCT and ALL Predicates 00:02:00 Aggregate Functions 00:03:00 GROUP BY clause / HAVING clause 00:04:00 WHERE and ORDER BY in aggregate queries 00:04:00 Wrap up - what we went over! 00:01:00 Unit 10: Bonus Bonus_Section 00:01:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Total H.248 training course description A course focusing purely on the H.248 protocol. Anyone working through the ITU standards documents can testify to the need of a training course to explain how H.248 really works. This course already assumes knowledge of other VoIP protocols and starts by positioning H.248 in relation to the other protocols. The course then looks at H.248 architectures and concepts before analysing H.248 messages and call flows. What will you learn Describe what H.248 is Recognise where H.248 fits in relation to other VoIP protocols. Explain how H.248 works. Analyse H.248 packets Total H.248 training course details Who will benefit: Technical staff working with H.248 Prerequisites: Voice Over IP. Duration 2 days Total H.248 training course contents What is H.248? Review of VoIP protocols: RTP, RTCP, SIP, SDP, H.323. The PSTN and SS7. Where H.248 fits into the picture. H.248 history. MGCP. The IETF. Megaco. ITU standards. H.248v1, v2, v3. H.248 architectures Media Gateways, Media Gateway Controllers, Gateway Control functions, Signalling Gateways. Reference architectures: IMS/TISPAN: IBCF, IWF, I-BGF, SPDF. MSF: S-SBG-NC, D-SBG-NC. GSMA: IPX Proxy. Softswitches. H.248 concepts The connection model, terminations, streams, contexts. Termination properties: descriptors, context properties. Events, signals, packages. H.248 messages Protocol stack, UDP, TCP. Message structure. Transactions, actions, commands. Requests, replies, acknowledgements. Sample message flows. Binary encoding, ASN syntax, Text encoding. H.248 commands Termination manipulation: Add, Subtract, Move, Modify. Event reporting: Notify. Management: AuditCapability, AuditValue, ServiceChange. H.248 Descriptors What are descriptors? Relationship with messages and commands. Basic descriptors, Descriptors composed of other descriptors. The 19 descriptors. Defaults. H.248 Transactions Groups of commands, transaction Ids, relationship with actions and commands. Requests and replies. H.248 wrap up What is a package? Basic packages. H.248 security. H.248 - SIP interoperation. H.248 interoperation with other protocols.

Lawful Intercept training course description Packet based networks require a different approach to Lawful Intercept (LI) than that used in circuit switched networks. This course focuses on what Lawful Interception and Data Retention (DR) means to communications service providers in the IP and NGN areas. The course assumes a basic knowledge of IP networking (i.e. DNS, TCP/UDP, IP, RTP) and the building of services on an IP platform (e.g. SIP, SDP, FTP, HTTP). The course first looks at the regulatory context for LI and DR and how this is translated to a practical architecture. What will you learn Recognise the legal and regulatory obligations to provide LI and DR. Identify the components of the handover architecture for each of LI and DR. Identify the preferred location of points of interception and points of retention in the IP network. Map intercepted material to handover protocols. Understand the data mapping defined in the available standards for both LI and DR. Lawful Intercept training course details Who will benefit: Technical and managerial staff needing to implement public networks. Prerequisites: TCP/IP Foundation Duration 1 day Lawful Intercept training course contents What is meant by LI and DR? Review of regulation: Data protection Directive; Data Retention Directive; RIPA. LI architectures Handover and Interception: ETSI standards ES 201 671 and TS 102 232. LI handover protocol IRI and CC handover; correlation; manual interfaces. DR architectures Handover of query results; points of retention. DR query command set Retrieval of retained records. Security concerns Operation privacy; target privacy; storage and transmission integrity. Implementation Identifying PoI and PoR for provided services. LI and DR wrap up Interaction with other services, storage obligations (volume, time, availability).