15901 Basic courses

Beginner Ballroom Course Waltz, Rumba, Cha-cha, Foxtrot, Tango, Jive

Does your child want to be Merida, Robin Hood, Katniss or Hawkeye? Now's their chance! At Kids' Archery Durham children can learn the basics of archery safety and technique, work towards in-house, national and international awards and most importantly have lots of fun!

Python coding, interactive, instructor-led, hands-on, practical. From basics to working with professionals. Python Part Time. Python Coding. -------------------------------------------------------------------------------- Python Beginners Evenings Course COURSE SUMMARY This Python Programming course has become essential to all professional who would like to do code using Python. Learn evenings, work while studying. Work and study Python Part Time. It is a Python beginners course and teaches Python coding from scratch to intermediate. Hands-on, practical. We code some real life examples in this course. Duration: 3 Evenings, once per week for 3 weeks 6pm-8pm, of which the first date only shows on the booking. Virtual Classroom: You could attend in our classroom, or attend online via virtual classroom, by select the appropriate ticket. Who Should Attend? This course is intended for beginner programmers who need to code in Python. Fast-paced, Quite intensive. Course Outline: Session 1: Basics * Python Data Types, Variables, * Operators and Expressions: Arithmetic operators; Relational operators; Assignment operator; Logical operators. * Decision Making: If statement; If - else statement; If- elif - else statement; Nested if - else; * Using Loops: The while, while-else; do-while and the for loop; Enhanced for loop; Jump statements: break, continue; Nesting loops. Session 2: Lists. Dictionaries, Json * Python Data Structures: Lists. Data Structures: 2-d Lists, Tuples. Dictionary, Nested Disctionary. Session 3: Built-in functions: * Python Date Functions. Random. Math Functions. String Functions. Python Regex. Session 4: Database: * Connect to a database, create Database, create a table, insert, delete, update records, query a database and display results. Drop database, drop table. Session 5: Files * Exception Handling in Python: Fundamentals of exception handling; Exception types; Using try and except. * Files, streams: Create, Open, Traverse and Read Files: Csv, txt and Json Files. * API: Connecting to API’s Session 6: M ethods, Classes and Objects * Creating and using Function, Working with parameters, Calling functions. * Object-Oriented Programming (OOP) principles. Modules and Classes, Creating an Object; Using an Object; Adding Instance variables; Controlling accessibility; Naming conventions for class member.s FAQ Do I need Python on my Laptop? Ideally spoken yes, but if not possible, you could use our online platform. Can I pay by BACS? Yes, simply email us, a Python course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com Can I pay with PayPal? Yes, simply email us, a course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com Do I get an invoice? Yes, on request. Can I pay with a PO (Purchase Order Number)? Yes, simply email us, a Python course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com Do I get a certificate? Yes, a PCWorkshops Certificate Can I attend in classroom? Yes, on request, and it would incur an additional charge, depending on your location. We have offices in London, Manchester, Birmingham, Portmouth, Southend-on-Sea, Milton Keynes. Can beginners follow this course? Yes, this is a Python beginner friendly course. We offer Python courses with max 4 people, so we make sure each delegates fully understand the material covered Can I customise the course? Yes, all our Python courses are customisable. We can customise the dates, times, location. course outline. -------------------------------------------------------------------------------- REFUND POLICY No Refunds

Duration 1 Days 6 CPD hours This course is intended for Sales Legal Marketing Business analysts Project managers AWS Academy students Other IT-related professionals Overview Summarize the working definition of AWS Differentiate between on-premises, hybrid-cloud, and all-in cloud Describe the basic global infrastructure of the AWS Cloud Explain the six benefits of the AWS Cloud Describe and provide an example of the core AWS services, including compute, network, databases, and storage Identify an appropriate solution using AWS Cloud services with various use cases Describe the AWS Well-Architected Framework Explain the shared responsibility model Describe the core security services within the AWS Cloud Describe the basics of AWS Cloud migration Articulate the financial benefits of the AWS Cloud for an organization?s cost management Define the core billing, account management, and pricing models Explain how to use pricing tools to make cost-effective choices for AWS services This course is for individuals who seek an overall understanding of the Amazon Web Services (AWS) Cloud, independent of specific technical roles. You will learn about AWS Cloud concepts, AWS services, security, architecture, pricing, and support to build your AWS Cloud knowledge. This course also helps you prepare for the AWS Certified Cloud Practitioner exam. Prerequisites General IT technical knowledge, General IT business knowledge 1 - INTRODUCTION TO AMAZON WEB SERVICES * Summarize the benefits of AWS * Describe differences between on-demand delivery and cloud deployments * Summarize the pay-as-you-go pricing model 2 - COMPUTE IN THE CLOUD * Describe the benefits of Amazon Elastic Compute Cloud (Amazon EC2) at a basic level * Identify the different Amazon EC2 instance types * Differentiate between the various billing options for Amazon EC2 * Describe the benefits of Amazon EC2 Auto Scaling * Summarize the benefits of Elastic Load Balancing * Give an example of the uses for Elastic Load Balancing * Summarize the differences between Amazon Simple Notification Service (Amazon SNS) and Amazon Simple Queue Services (Amazon SQS) * Summarize additional AWS compute options 3 - GLOBAL INFRASTRUCTURE AND RELIABILITY * Summarize the benefits of the AWS Global Infrastructure * Describe the basic concept of Availability Zones * Describe the benefits of Amazon CloudFront and Edge locations * Compare different methods for provisioning AWS services 4 - NETWORKING * Describe the basic concepts of networking * Describe the difference between public and private networking resources * Explain a virtual private gateway using a real life scenario * Explain a virtual private network (VPN) using a real life scenario * Describe the benefit of AWS Direct Connect * Describe the benefit of hybrid deployments * Describe the layers of security used in an IT strategy * Describe which services are used to interact with the AWS global network 5 - STORAGE AND DATABASES * Summarize the basic concept of storage and databases * Describe benefits of Amazon Elastic Block Store (Amazon EBS) * Describe benefits of Amazon Simple Storage Service (Amazon S3) * Describe the benefits of Amazon Elastic File System (Amazon EFS) * Summarize various storage solutions * Describe the benefits of Amazon Relational Database Service (Amazon RDS) * Describe the benefits of Amazon DynamoDB * Summarize various database services 6 - SECURITY * Explain the benefits of the shared responsibility model * Describe multi-factor authentication (MFA) * Differentiate between the AWS Identity and Access Management (IAM) security levels * Describe security policies at a basic level * Explain the benefits of AWS Organizations * Summarize the benefits of compliance with AWS * Explain primary AWS security services at a basic level 7 - MONITORING AND ANALYTICS * Summarize approaches to monitoring your AWS environment * Describe the benefits of Amazon CloudWatch * Describe the benefits of AWS CloudTrail * Describe the benefits of AWS Trusted Advisor 8 - PRICING AND SUPPORT * Understand AWS pricing and support models * Describe the AWS Free Tier * Describe key benefits of AWS Organizations and consolidated billing * Explain the benefits of AWS Budgets * Explain the benefits of AWS Cost Explorer * Explain the primary benefits of the AWS Pricing Calculator * Distinguish between the various AWS Support Plans * Describe the benefits of AWS Marketplace 9 - MIGRATION AND INNOVATION * Understand migration and innovation in the AWS Cloud * Summarize the AWS Cloud Adoption Framework (AWS CAF) * Summarize six key factors of a cloud migration strategy * Describe the benefits of various AWS data migration solutions, such as AWS Snowcone, AWS Snowball, and AWS Snowmobile * Summarize the broad scope of innovative solutions that AWS offers * Summarize the five pillars of the AWS Well-Architected Framewor 10 - AWS CERTIFIED CLOUD PRACTITIONER BASICS * Determine resources for preparing for the AWS Certified Cloud Practitioner examination * Describe benefits of becoming AWS Certified

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - INTRODUCTION TO TRANSACT-SQL * Work with schemas * Explore the structure of SQL statements * Examine the SELECT statement * Work with data types * Handle NULLs 2 - SORT AND FILTER RESULTS IN T-SQL * Sort your results * Limit the sorted results * Page results * Remove duplicates * Filter data with predicates 3 - COMBINE MULTIPLE TABLES WITH JOINS IN T-SQL * Understand joins concepts and syntax * Use inner joins * Use outer joins * Use cross joins * Use self joins 4 - WRITE SUBQUERIES IN T-SQL * Understand subqueries * Use scalar or multi-valued subqueries * Use self-contained or correlated subqueries 5 - USE BUILT-IN FUNCTIONS AND GROUP BY IN TRANSACT-SQL * Categorize built-in functions * Use scalar functions * Use ranking and rowset functions * Use aggregate functions * Summarize data with GROUP BY * Filter groups with HAVING 6 - MODIFY DATA WITH T-SQL * Insert data * Generate automatic values * Update data * Delete data * Merge data based on multiple tables ADDITIONAL COURSE DETAILS: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

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

Intelligent Yoga Teacher Training (IYTT) is unique amongst teacher training courses. We offer an incisive, thoughtful and intelligent approach to yoga teacher training, driven by the most current scientific developments in anatomy and movement research. Delivered by an elite group of senior yoga teachers at the top of their field, IYTT offers a spacious, immersive modular structure which provides time and space for profound learning, integration and growth. Each of the teaching team draws on decades of practical experience of yoga, including particularly the work of Vanda Scaravelli and somatic, embodied practices.

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE * Topic A: Explore Crystal Reports * Topic B: Use Crystal Reports Help * Topic C: Customize Report Settings 2 - WORKING WITH REPORTS * Topic A: Create a Report * Topic B: Modify a Report * Topic C: Display Specific Report Data * Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS * Topic A: Create a Formula * Topic B: Edit a Formula * Topic C: Filter Data by Using a Formula * Topic D: Work with Advanced Formulas and Functions * Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS * Topic A: Create a Parameter Field * Topic B: Use a Range Parameter in a Report * Topic C: Create a Prompt 5 - GROUPING REPORT DATA * Topic A: Group Report Data * Topic B: Modify a Group Report * Topic C: Group by Using Parameters * Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT * Topic A: Format a Report * Topic B: Insert Objects in a Report * Topic C: Suppress Report Sections * Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA * Topic A: Create a Report Based on Excel Data * Topic B: Modify a Report Generated from Excel Data * Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA * Topic A: Export Data * Topic B: Create Mailing Labels 9 - APPENDIX * Appendix A: Setting Up and Configuring Data Sources * Appendix B: Using Report Processing Techniques * Appendix C: Using Functions in Formulas

Course Description: Become equipped to handle workplace emergencies with our Level 3 Award in Emergency First Aid at Work (RQF) Course. This comprehensive training covers various first aid scenarios, empowering participants to qualify as Emergency First Aiders and fulfil the statutory requirements of the Health and Safety (First Aid) Regulations 1981. Recognized by OFQUAL at level 3, this course prepares learners to administer crucial first-aid interventions in the workplace. Learning Outcome: Upon completion of the course, participants will master key first-aid techniques, including: * Prioritizing first aid incidents * Administering CPR and resuscitation * Managing bleeding, shock, and minor injuries * Conducting casualty examinations * Providing adults with basic life support * Addressing strains, sprains, burns, and suspected spinal injuries * Understanding responsibilities and reporting protocols * Maintaining and utilizing first aid kits * Handling head injuries and concussion return-to-play protocols Course Audience: Ideal for individuals with specific responsibilities to provide first aid at work or in voluntary/community activities. Our industry-specific emergency first aid at work courses cater to various sectors, including transport, security, catering, construction, office environments, supermarkets, and entertainment venues. Assessment and Re-qualification: Participants, aged at least 14 years, must communicate effectively in English. The course involves practical activities and ongoing assessment. Certification is awarded upon meeting the criteria. Typically delivered over 1 day (6 hours, including a lunch break). Corporate or Group Booking: Enjoy special discounts for corporate or group bookings. Our trainers can conduct on-site training tailored to your organization's needs. Course Fee: Enroll in our Level 3 Award in Emergency First Aid at Work Course for a special price of £79.99, covering all charges. How to Book: Book online via PayPal, debit/credit card, invoice, or bank transfer. Alternatively, visit our office or contact us by phone to secure your spot. Booking confirmation will be emailed instantly. Assistance Needed? For inquiries or assistance, contact our dedicated team via phone or email. We're committed to supporting you throughout your learning journey. Contact us today for guidance and assistance.

This Python Machine Learning online instructor led course is an excellent introduction to popular machine learning algorithms. -------------------------------------------------------------------------------- Python Machine Learning 2-day Course Prerequisites: Basic knowledge of Python coding is a pre-requisite. Who Should Attend? This course is an overview of machine learning and machine learning algorithms in Python SciKitLearn. Practical: * We cover the below listed algorithms, which is only a small collection of what is available. However, it will give you a good understanding, to plan your Machine Learning project * We create, experiment and run machine learning sample code to implement a short selected but representative list of available the algorithms.  Course Outline: Supervised Machine Learning: * Classification Algorithms: Naive Bayes, Decision Tree, Logistic Regression, K-Nearest Neighbors, Support Vector Machine * Regression Algorithms: Linear, Polynomial Unsupervised Machine Learning: * Clustering Algorithms: K-means clustering, Hierarchical Clustering * Dimension Reduction Algorithms: Principal Component Analysis Latent Dirichlet allocation (LDA) * Association Machine Learning Algorithms: Apriori, Euclat Other machine learning Algorithms: * Ensemble Methods ( Stacking, bagging, boosting ) Algorithms: Random Forest, Gradient Boosting * Reinforcement learning Algorithms: Q-Learning * Neural Networks and Deep Leaning Algorithms: Convolutional Network (CNN) Data Exploration and Preprocessing: * The first part of a Machine Learning project understands the data and the problem at hand. * Data cleaning, data transformation and data pre-processing are covered using Python functions to make data exploration and preprocessing relatively easy. What is included in this Python Machine Learning: * Python Machine Learning Certificate on completion   * Python Machine Learning notes * Practical Python Machine Learning exercises and code examples * After the course, 1 free, online session for questions or revision Python Machine Learning. * Max group size on this Python Machine Learning is 4. -------------------------------------------------------------------------------- REFUND POLICY No Refunds