15804 Basic courses

This Python BootCamp is Instructor-led, Practical. In the12-week Python course, learn start to in-depth, leading to a good Python career. -------------------------------------------------------------------------------- PYTHON BOOTCAMP: This 12-week Python Boot Camp is a practical, instructor-lead program, covering Python from start to in-depth. You will be fully fluent and confident as a Python programmer. If you have more questions goto https://pcworkshopslondon.co.uk/contact.html  [http://pcworkshopslondon.co.uk/contact.html], Or contact us on training@pcworkshopslondon.co.uk [https://pcworkshopslondon.co.uk/] Customise dates, course outline, arrange installments [https://pcworkshopslondon.co.uk/contact.htm] This course will give you enough practical experience and practical projects to code, to give you full confidence to enter into the coding profession.    Duration: 3 months: * 1 Python class per week, * Plus pratical work, * Plus personal trainer-mentor for 1-1 training, * Plus e-learning materials. Final project : Practical to upload to GitHub and show-case Date and times, choose: * Fridays in London or Online , 10am - 5pm, * or Saturdays in London or Online , 12noon-6pm, * or negotiate your date Study level: Start from beginners level to in-depth, ready to work professionally. Virtual attendance:  online instructor-led  Download: Anaconda.com Pre-requisites: General computer literacy. Oracle Qualification: PCWorkshops Python Programmer Certificate Payments:  You may apply to pay in installments for this Python Training course COURSE OUTLINE Week 1 - 4: Essentials 1. Python Coding Basics 2. Object Oriented programming: Python Object Orientated programming (OOP) 3. UX Principles: UX Principles and applying it on Front-ends with TKinter 4. Specialised topics: Dates, Localization, Strings, Maths Operation , Random Number, Lambdas Week 5 - 10 : All about data 1. Python Data Structures: Lists, Tuples, Sets, Exceptions, I/O Fundamentals , Reading and Writing file 2. Database: Database principles and SQL. Database Project: Python database connections and creating a database driven project 3. Data Analytics: Numpy. Pandas for data analytics and data queries. 4. Data Analytics: Pandas data cleaning and restructuring, interacticting with Excel, Csv, Json,etc. 5. Data visualisation: MatPlotLib 6. Prediction: Machine Learning Basics Week 11 and 12: The final touch 1. Python Concurrency and Multi-threading: Threads vs. Processes, Threading Module, Threading Event, Stop a Thread, Daemon Threads, Thread-safe Queue, Thread Pools, Locks 2. Python Unit Testing 3. Optional : Replace Week 11 or 12 with Scraping using Python, ot Tkinter Front-ends INCLUDED: * PCWorkshops Python Course Certificate on completion. * Python Course notes. * Practical Course exercises, Code Examples, Online Materials. * After the course, continuous assistance with practical and preparation for exams * Max group size on this is 4. * Portfolio: Post your Python project online. * Exam preparation and interview questions MORE ABOUT THE ONLINE CLASSROOM *  Attend from your internet connection *  Instructor-led, get instant answers to your questions *  Fully interactive *  Work clearly explained with demonstrations and examples *  Practical exercises to be tried out by delegate WHAT YOU WILL GAIN: * Skills & knowledge: Python coding knowledge and understanding with good practical application   * Certification: Internal PCWorkshops Python certificate * Portfolio: You will have an online portfolio of Python projects  * Experience: Our comprehensive practical makes you job ready -------------------------------------------------------------------------------- REFUND POLICY No Refunds

This video editing workshop equips you with the essential skills to create professional-looking videos for your business, even if you've never edited before.

DURATION 1 DAYS 6 CPD HOURS THIS COURSE IS INTENDED FOR INDIVIDUALS WITH BASIC COMPUTER SKILLS, FAMILIAR WITH CONCEPTS RELATED TO DATABASE STRUCTURE AND TERMINOLOGY, AND WHO WANT TO USE SQL TO QUERY DATABASES. OVERVIEW UPON SUCCESSFUL COMPLETION OF THIS COURSE, STUDENTS WILL BE ABLE TO: - CONNECT TO THE SQL SERVER DATABASE AND EXECUTE A SIMPLE QUERY. - INCLUDE A SEARCH CONDITION IN A SIMPLE QUERY. - USE VARIOUS FUNCTIONS TO PERFORM CALCULATIONS ON DATA. - ORGANIZE DATA OBTAINED FROM A QUERY BEFORE IT IS DISPLAYED ON-SCREEN. - RETRIEVE DATA FROM TABLES. - FORMAT AN OUTPUT, SAVE A RESULT, AND GENERATE A REPORT. DESCRIPTION IN THIS COURSE, STUDENTS WILL COMPOSE SQL QUERIES TO RETRIEVE DESIRED INFORMATION FROM A DATABASE. 1 - EXECUTING A SIMPLE QUERY * Connect to the SQL Database * Query a Database * Save a Query * Modify a Query * Execute a Saved Query 2 - PERFORMING A CONDITIONAL SEARCH * Search Using a Simple Condition * Compare Column Values * Search Using Multiple Conditions * Search for a Range of Values and Null Values * Retrieve Data Based on Patterns 3 - WORKING WITH FUNCTIONS * Perform Date Calculations * Calculate Data Using Aggregate Functions * Manipulate String Values 4 - ORGANIZING DATA * Sort Data * Rank Data * Group Data * Filter Grouped Data * Summarize Grouped Data * Use PIVOT and UNPIVOT Operators 5 - RETRIEVING DATA FROM TABLES * Combine Results of Two Queries * Compare the Results of Two Queries * Retrieve Data by Joining Tables * Check for Unmatched Records * Retrieve Information from a Single Table Using Joins 6 - PRESENTING QUERY RESULTS * Save the Query Result * Generate an XML Report

Immerse yourself in Zen music, diffusing essential oils, cuppa green tea and interact with the sand. Good choice for relaxation! About the workshop Rocks, sand, plants and rakes. These are the elements of forming a Japanese zen garden. It is a kind of Japanese traditional art that you can find in Japanese temples especially in Kyoto and Tokyo. Using different kinds of sand rakes and bamboo rakes to create your own gravel pattern. In the workshop, you will be introduced the concepts and basic techniques of Japanese Zen Garden. An individual table set of zen garden materials will be provided. At the end of the soul calming journey, you will have a cuppa of Japanese green tea as a curtain fall of the workshop. - Each session is 1.5 hours at Plus X Brighton, by GetFun Garden Ltd. - Individual table set of Zen Garden materials will be provided. - No experience is needed -Private group sessions are available by reservation (8-10 people). Please feel free to contact us by email for a 20% discount. www.getfungarden.com [https://www.getfungarden.com] *View the past workshops: https://www.instagram.com/stories/highlights/17971768625498102/

The UK's first and only Level 4 qualification in Phlebotomy (equivalent to Ireland Level 6) FDSc (Foundation Degree Level) qualification Nationally Recognised certificate Dually accredited: Open College Network and CPD Covers both aspirated and evacuated systems Covers specialised blood collection systems & methods Classroom or Virtual Classroom learning options Comprehensive Training Kit is provided when booking our Virtual Classroom option (yours to keep) Complete your training from beginner to advanced level This course either follows on from our Introduction to Phlebotomy Course or can be combined with our introductory course as part of a course package (see below) Available to candidates who have completed (or are currently enrolled to complete) our Introduction to Phlebotomy Course or have previous phlebotomy practical experience.

Barista Skills teaches the essential practical skills needed behind the espresso bar, such as how to set your grinder, make espresso, foam and texture milk for cappuccinos, and create latte art, as well as an exploration of health and safety issues, customer service protocols, and basic business practices. The Barista Skills Intermediate course builds on the concepts and skills introduced in the Foundation course. It is ideal for someone who has barista skills experience and wants to explore how to improve coffee quality and prepare for more complex job functions found in the barista profession. Through this interactive course, learners will gain a deeper understanding of the coffee itself, specifically, the impact of a coffee’s variety, origins and processing methods on flavour; the parameters of coffee quantity, grind texture, water quality, and shot time and their interaction when dialling in a brew recipe; drink construction and taste differences; workflow management and efficiency, sensory aspects of the espresso extraction; milk handling and techniques as well as latte art. In addition to coffee preparation, this course also covers key concepts regarding health and safety, customer service, and basic business practices. A written exam tests Intermediate course knowledge, while a practical exam assesses the learner’s ability in terms of grinder calibration, espresso extraction analysis, latte art skills and drinks construction.

The Roasting Intermediate course builds upon the introductory concepts of the Foundation course. It is ideal for someone who has roasting and desires to gain a deeper understanding of the roast profile, how the profile relates to color, the relationship between roast profile and sensory expression, and the impact of development time. Learners will further explore the physical and chemical changes as well as basic thermodynamics and heat transfer that occurs during the roast. Thereafter there will be an introduction to sample roasting and a review of safety and maintenance protocols in the roasting plant. A written exam tests intermediate course knowledge while a practical exam assesses the learner’s ability to roast correctly and remove the coffee at the correct color using a reference, while accurately completing the roast log form.

This accredited qualification is for people who have a specific responsibility at work, or in voluntary and community activities, to provide help to people in a range of emergency first aid situations The certificate will last for 3 years

THIS COURSE PACKAGE INCLUDES: 1: INTRODUCTION TO PHLEBOTOMY COURSE (GPT003) - Level 3 (Ireland Level 5) 2: ADVANCED PHLEBOTOMY COURSE (GPT005) - Level 4 (Ireland Level 6) 3: GEOPACE COMPETENCY CERTIFICATE - CPD Certified (optional with Virtual Classroom) Learn how to take blood ... train as a Phlebotomist FAST-TRACK YOUR PHLEBOTOMY TRAINING WITH OUR COMPLETE TRAINING PACKAGE 20% off - Multi-Course Discount Cover all stages from beginner through to Level 4 Available as Classroom or Virtual Classroom Complete your beginner to advanced training in 2 days Awards 2 accredited qualifications - Introduction to Phlebotomy and Advanced Phlebotomy qualifications Both courses are dually accredited (OCN & CPD) Geopace Certificate of Competency included with classroom attendance or available as an option when booking virtual classroom Covers all steps up to live blood draw Learn advanced skills and techniques Virtual Classroom options include comprehensive Practise@Home Training Kits (yours to keep) Basic understanding of English language required OPEN TO ALL APPLICANTS

Learn how to take blood ... train as a Phlebotomist Nationally Recognised Qualification No previous experience or qualifications needed OCN Accredited - Level 3 (advanced) CPD Accredited (The CPD Certification Service) Covers all steps up to live blood draw Practise on artificial arm and fake blood! Basic understanding of English language required OPEN TO ALL APPLICANTS