SQL for Data Science, Data Analytics and Data Visualization Course Overview: This course offers a comprehensive introduction to SQL, designed for those looking to enhance their skills in data science, data analytics, and data visualisation. Learners will develop the ability to work with SQL databases, efficiently query and manage data, and apply these techniques for data analysis in both SQL Server and Azure Data Studio. By mastering SQL statements, aggregation, filtering, and advanced commands, learners will be equipped with the technical skills required to manage large datasets and extract meaningful insights. The course provides a solid foundation in data structures, user management, and working with multiple tables, culminating in the ability to perform complex data analysis and visualisation tasks. Course Description: This course covers a broad range of topics essential for anyone working with data in a professional capacity. From setting up SQL servers to mastering database management tools like SQL Server Management Studio (SSMS) and SQL Azure Data Studio, the course provides a thorough grounding in SQL. Learners will gain expertise in data structure statements, filtering data, and applying aggregate functions, as well as building complex SQL queries for data analysis. The course also includes instruction on SQL user management, group by statements, and JOINs for multi-table analysis. Key topics such as SQL constraints, views, stored procedures, and database backup and restore are also explored. The course incorporates SQL visualisation tools in Azure Data Studio, empowering learners to visualise data effectively. By the end of the course, learners will be proficient in SQL queries, data manipulation, and using Azure for data analysis. SQL for Data Science, Data Analytics and Data Visualization Curriculum: Module 01: Getting Started Module 02: SQL Server Setting Up Module 03: SQL Azure Data Studio Module 04: SQL Database Basic SSMS Module 05: SQL Statements for DATA Module 06: SQL Data Structure Statements Module 07: SQL User Management Module 08: SQL Statement Basic Module 09: Filtering Data Rows Module 10: Aggregate Functions Module 11: SQL Query Statements Module 12: SQL Group By Statement Module 13: JOINS for Multiple Table Data Analysis Module 14: SQL Constraints Module 15: Views Module 16: Advanced SQL Commands Module 17: SQL Stored Procedures Module 18: Azure Data Studio Visualisation Module 19: Azure Studio SQL for Data Analysis Module 20: Import & Export Data Module 21: Backup and Restore Database (See full curriculum) Who is this course for? Individuals seeking to enhance their data management and analysis skills. Professionals aiming to progress in data science, data analytics, or database administration. Beginners with an interest in data analysis and SQL databases. Anyone looking to gain expertise in SQL for Azure and SQL Server environments. Career Path: Data Analyst Data Scientist Database Administrator SQL Developer Business Intelligence Analyst Data Visualisation Specialist
Our courses have been designed by experienced teachers to make getting TEFL qualified as convenient as possible. These online courses are entirely self-paced, meaning you can fit study around your life in a way that works best for you. Throughout the course, you will have the support of your own personal tutor who is with you from beginning to end to mark your work, provide helpful feedback, and answer all your questions. 120-hour Premier Online TEFL Course: 50-hour Online TEFL Course Learn about classroom management, teaching styles and advanced TEFL methodology. Includes units on business English, young learners, and teaching English one-to-one. Study with a personal tutor and meet fellow students on our course forums. 30-hour Online Grammar Course Do not know your irregular verbs from auxiliary verbs? This course will improve your basic grammar and give you the grounding you will need to communicate complicated language rules to a student audience. 20-hour Online Video Course Seeing an English teacher in action is a potent learning tool and really brings the theory to life. Feel free to steal the ideas in these video courses to use in your first lessons. We do not mind! Two 10-hour specialist mini-modules. Two mini-modules designed for specific TEFL jobs, which will help your CV stand out. One 10-hour unit is about teaching online, and the other 10-hour unit will help you teach large classes. Included in the 120-hour Premier Online TEFL Course: Lifetime access to the TEFL Job Centre The TEFL Virtual Educators course doesn’t just train you to teach; it helps you find and be offered great TEFL jobs around the world. From exclusive access to our job vacancies to a lifetime of free TEFL career advice, we’re here to help you kick-start your new career. Internationally recognised TEFL certificate – hard copy & PDF A widely-recognised certificate posted straight to your door which shows your achievements on our course, something you can show to TEFL employers to secure you a job. Personal online TEFL tutor Work through your course with the help of an experienced and qualified TEFL tutor. Throughout the course, you’ll have the same tutor, so you have one point of contact for advice and assistance. Online TEFL Class breakdown Lesson Planning Teaching English Vocabulary Teaching Pronunciation Understanding English Grammar Teaching Receptive Skills: Listening and Reading Teaching Productive Skills: Speaking and Writing Teaching English Grammar Principles of Teaching English as a Foreign Language Materials and Aids for Teaching English/Classroom Management Strategies Using Resources Effectively when Teaching English as a Foreign Language Case Study, CV and Cover Letter, Job Sites and Resources You will explore the latest theories in topics such as second language acquisition and social discourse and have the chance to apply these to your own classroom practice and curriculum development. You will also learn to conduct your own research, compile and analyse qualitative and quantitative data and develop your critical-evaluative skills. These skills will be used on your own research project at the end of the course, as well as in your future career. Core modules: Second Language Acquisition You will focus on the major themes that have emerged from literature on second language learning over the last three decades. You will examine some of the research on the second-language acquisition process, look critically at reports of second-language research, and examine some of the theories which endeavour to interpret research evidence. You will be encouraged to use your own language learning and teaching experience to assess the relative merits of such materials. Discourse in Society You will examine the relationship between language and society and the construction of discourse in various domains. You will explore sociological and sociolinguistic models and theories, such as speech communities, communities of practice and ethnolinguistic vitality, with a particular focus on social variation and stratification across various linguistic levels (phonology, lexicon, syntax). You will explore discourse's notion (or notions) in both its linguistic and wider meaning and its construction in and through society and language use. You will study methods for collecting and transcribing data and discover various linguistic and discourse analysis approaches. These methods and approaches will then be put into context and used in the analysis of the relevant social spheres and domains, such as educational or institutional discourse. Research Methods in Applied Linguistics This module will provide you with an introduction to research methods in preparation for the MA dissertation. It will familiarise you with the basic processes of conducting research, including general methodological approaches as well as research ethics. You will analyse and discuss both qualitative and quantitative data in order to develop your critical-evaluative skills. Materials and Course Design You will explore the factors involved in the design of language courses and teaching materials, reflecting on one possible course design process. You will start with an analysis of the context in which the course will take place, the needs of the learners, and current theories of language and language learning. You will move on to consider how course content can be selected and ordered in a principled way, how assessment relates to course design, and how and when courses should be evaluated. Finally, you will consider the evaluation, adaptation, and creation of course materials. Classroom Theory and Practice You will examine current research on modern classroom operations, exploring key concepts and issues through relevant professional and academic literature. A more practical element will be realised through filmed observation of teachers in practice. You will also be encouraged to reflect on your teaching and learning experience and analyse and discuss your beliefs and attitudes towards learning and teaching. Major Project This module will support you in the preparation and submission of a master’s dissertation, allowing you to explore in-depth a particular topic that reflects your academic interest. Assessment You will show your understanding of theoretical issues and their practical application through a combination of portfolios, classroom observation tasks and critical essays. After completing your final module, you will also research and prepare a 15,000-word dissertation.
Students who complete the PV201L workshop will be able to: Perform power and energy calculations Obtain and apply specifications for PV modules and determine their performance given various environmental and operating conditions Safely operate various types of digital multimeters Diagram and determine the power, current, and voltage characteristics of PV modules in different series and parallel configurations Install various mounting systems (ground, pole, roof, and trackers). Decipher balance-of-system equipment specification sheets to determine the critical information needed for system design Install a residential grid-direct system including the array, inverter, circuit conductors, and overcurrent protection Safely operate equipment grounding, system grounding, and components and conductors used for grounding Work with wires and components on schematics of residential grid-direct systems: disconnects, inverter, equipment grounding conductors, ungrounded conductors, grounded conductors, the grounding electrode(s), and the AC and DC system grounds Identify potential safety hazards and demonstrate the proper use of personal protective equipment for working on grid-direct PV systems List the order of installation, commissioning, and decommissioning of a grid-direct PV system Note: This class is a great complement to PV301L, the Solar Electric Lab Week (Battery-Based).
Students who complete the PV201L workshop will be able to: Perform power and energy calculations Obtain and apply specifications for PV modules and determine their performance given various environmental and operating conditions Safely operate various types of digital multimeters Diagram and determine the power, current, and voltage characteristics of PV modules in different series and parallel configurations Install various mounting systems (ground, pole, roof, and trackers). Decipher balance-of-system equipment specification sheets to determine the critical information needed for system design Install a residential grid-direct system including the array, inverter, circuit conductors, and overcurrent protection Safely operate equipment grounding, system grounding, and components and conductors used for grounding Work with wires and components on schematics of residential grid-direct systems: disconnects, inverter, equipment grounding conductors, ungrounded conductors, grounded conductors, the grounding electrode(s), and the AC and DC system grounds Identify potential safety hazards and demonstrate the proper use of personal protective equipment for working on grid-direct PV systems List the order of installation, commissioning, and decommissioning of a grid-direct PV system Note: This class is a great complement to PV301L, the Solar Electric Lab Week (Battery-Based). This Women's Solar Electric Lab Week is powered by:
Syllabus: Holistic Protection and Energetic Practices Course Overview This course introduces essential spiritual practices for grounding, protection, and clearing. These skills create a foundation for personal and energetic stability, enhancing focus, clarity, and resilience. Through visualisation, meditation, and energy exercises, students will develop a profound understanding of grounding techniques, protective boundaries, and clearing practices. Module 1: Grounding - Core Techniques: Visualise roots or boulders for grounding; use the tree visualisation for strength. - Daily Application: Practical tips for staying present and connected. - Reflection: Journaling prompts to track emotional and physical responses. Module 2: Protection - Creating Boundaries: Use protective visualisations like light shields and cloaks. - Protective Tools: Elemental circles, crystals (e.g., black tourmaline), and symbols (Ankh, Eye of Horus). - Invocation Practices: Call upon Archangels and guides for energetic support. - Reflection: Journaling to observe the effects of protection techniques. Module 3: Clearing - Clearing Practices: Techniques for personal and environmental energy clearing. - Crystal Grids: Setup for maintaining energetic cleanliness. - Advanced Visualisations: Use the violet flame for thorough cleansing. - Reflection: Journaling on the experience of clearing exercises.
Students who complete PV202 will be able to: Define the purpose of the National Electrical Code (NEC®) and NEC® terminology for PV equipment Determine procedures for proper installation of equipment and conductors, including minimum requirements for working space Examine methods for PV wire management and determine where expansion fittings are required Describe and identify electrical services, including split-phase and three-phase Wye (Y) and Delta (â) Evaluate electrical service details to collect and record during solar site evaluation Identify options for NEC®-compliant PV system interconnection to the utility grid and determine whether a supply side, load side, or additional service connection is appropriate Identify code-compliant methods for connecting an inverter to an existing AC feeder Calculate PV module voltage based on temperature to ensure compatibility with system components and NEC® Section 690.7, and explore other options for maximum PV system DC voltage calculations Identify NEC® requirements and sizing of disconnects and overcurrent protection devices (OCPDs) in grid-direct PV systems Define inverter grounding configurations Evaluate inverter choices and system configurations, including string inverters, central inverters, and module level power electronics (MLPE) Identify requirements for equipment grounding, equipment grounding conductors (EGC), and grounding electrode conductors (GEC), and size the conductors according to the NEC® Identify common causes of ground-faults and arc-faults Describe ground-fault and arc-fault protection devices Describe benefits and appropriate locations of surge protection devices (SPD) Demonstrate the use of sun charts and perform calculations to determine row spacing and minimize inter-row shading Identify how Codes detailing access for first responders impact PV array roof layout Examine fire classifications that affect racking and module selection Detail NEC rapid shutdown requirements and options for implementation Identify load and structural considerations for low- and steep-slope roof-mounted PV systems Calculate wind uplift force and select appropriate lag bolts Review issues related to planning, design, and installation of ground-mount PV arrays Review PV system circuit terminology, definitions, and conductor types Calculate minimum overcurrent protection device (OCPD) size and conductor ampacity using appropriate adjustment and correction factors Calculate voltage drop and verify system operation within acceptable limits Examine requirements for PV system labeling Calculate the maximum and minimum number of modules per PV source circuit, and number of PV source circuits per inverter Determine size of residential grid-direct PV system based on site and customer-specific considerations including the number and wiring layout of modules, conductor and OCPD sizes, and the AC interconnections Determine the size of a large, multiple inverter, grid-direct PV system based on site and customer-specific considerations, including the quantity and layout of modules and inverters and the AC interconnection Define large-scale PV and review associated NEC® allowances and requirements Describe importance of Data Acquisition Systems (DAS) Identify common DAS equipment and hardware Review DAS design, installation, and commissioning processes and common problems associated with DAS Show how reports can be generated and utilized to remotely assess health of system
Students who complete PVOL202 will be able to: Define the purpose of the National Electrical Code (NEC®) and NEC® terminology for PV equipment Determine procedures for proper installation of equipment and conductors, including minimum requirements for working space Examine methods for PV wire management and determine where expansion fittings are required Describe and identify electrical services, including split-phase and three-phase Wye (Y) and Delta (â) Evaluate electrical service details to collect and record during solar site evaluation Identify options for NEC®-compliant PV system interconnection to the utility grid and determine whether a supply side, load side, or additional service connection is appropriate Identify code-compliant methods for connecting an inverter to an existing AC feeder Calculate PV module voltage based on temperature to ensure compatibility with system components and NEC® Section 690.7, and explore other options for maximum PV system DC voltage calculations Identify NEC® requirements and sizing of disconnects and overcurrent protection devices (OCPDs) in grid-direct PV systems Define inverter grounding configurations Evaluate inverter choices and system configurations, including string inverters, central inverters, and module level power electronics (MLPE) Identify requirements for equipment grounding, equipment grounding conductors (EGC), and grounding electrode conductors (GEC), and size the conductors according to the NEC® Identify common causes of ground-faults and arc-faults Describe ground-fault and arc-fault protection devices Describe benefits and appropriate locations of surge protection devices (SPD) Demonstrate the use of sun charts and perform calculations to determine row spacing and minimize inter-row shading Identify how Codes detailing access for first responders impact PV array roof layout Examine fire classifications that affect racking and module selection Detail NEC rapid shutdown requirements and options for implementation Identify load and structural considerations for low- and steep-slope roof-mounted PV systems Calculate wind uplift force and select appropriate lag bolts Review issues related to planning, design, and installation of ground-mount PV arrays Review PV system circuit terminology, definitions, and conductor types Calculate minimum overcurrent protection device (OCPD) size and conductor ampacity using appropriate adjustment and correction factors Calculate voltage drop and verify system operation within acceptable limits Examine requirements for PV system labeling Calculate the maximum and minimum number of modules per PV source circuit, and number of PV source circuits per inverter Determine size of residential grid-direct PV system based on site and customer-specific considerations including the number and wiring layout of modules, conductor and OCPD sizes, and the AC interconnections Determine the size of a large, multiple inverter, grid-direct PV system based on site and customer-specific considerations, including the quantity and layout of modules and inverters and the AC interconnection Define large-scale PV and review associated NEC® allowances and requirements Describe importance of Data Acquisition Systems (DAS) Identify common DAS equipment and hardware Review DAS design, installation, and commissioning processes and common problems associated with DAS Show how reports can be generated and utilized to remotely assess health of system
FAA Level 2 Award In First Aid For Mental Health (RQF) Classroom (1 day course) or Virtual (3 x 2½ hour sessions) Gives learners knowledge of Mental Health First Aid Gives learners the skills to help those with mental health problems and improve mental health in the workplace Course Contents: What is Mental Health? Why people develop mental health conditions What the role of a mental health first aider is Knowing how to provide advice and practical support Knowing how to recognise and manage stress Understand the impact of substance abuse on mental health Understand the first aid action plan for mental health and be able to put it in place Know how to implement a positive mental health culture in the workplace Recognising a range of mental health conditions: Depression Anxiety Psychosis Eating disorders Suicide Self-harm Benefits of this course: 37% of all work-related ill-health is due to mental health problems Problems with mental health cover 45% of all working days lost A whopping 12.8 million working days, or 49, 042 years, were lost due to mental health problems in 2018/19 602,000 workers suffered from work-related stress, depression or anxiety in 2018/19 One in four people will have a mental health problem at some point during their lives Whether work is causing or aggravating mental health problems, employers have a legal responsibility towards their employees Work-related mental health issues must to be assessed to measure the levels of risk to staff Where a risk is identified, steps must be taken to remove it or reduce it as far as reasonably practicable This full day Mental Health First Aid course gives a good grounding to help others in the workplace Accredited, Ofqual regulated qualification Our Mental Health First Aid Courses are nationally recognised, Ofqual regulated qualifications accredited by First Aid Awards Ltd in association with NUCO Training. This means that you can be rest assured that your Mental Health First Aid Certificates fulfill the upcoming legal requirements and are a very good way to make sure you and your employees have a supporting workplace to deal with staff's mental health conditions. The Ofqual Register number for this course is 603/3769/2
RFID training course description This training course focuses on the technologies used in Radio Frequency Identification (RFID). What will you learn Describe the RFID architecture. Design RFID systems. Evaluate tag types. Recognise common RFID problems. RFID training course details Who will benefit: RFID technologists and system engineers. Prerequisites: RF fundamentals. Duration 2 days RFID training course contents What is RFID? Review of RF basics, what is RFID, RFID history, RFID base system architecture, frequency bands used by RFID, comparison with barcodes. RFID applications Supply chain, asset tracking, theft reduction, retail, access control, tolls. Tags Tag features, types of tag, passive and active, chips, read only, read write, affixing tags, selecting location to affix a tag, tag orientation and location, tag stacking, impact of rate of movement, tag data formats. Interrogators/readers Interrogation zones, interrogator types, antennas, read distance tests, multiple interrogators, synchronisation, dense interrogator environment issues. RFID peripherals. Standards and regulations Global regulatory requirements, regional regulatory requirements, ISO, ETSI, FCC, EPC, safety regulations/issues. Testing and troubleshooting Read rate problems, improperly tagged items, tag failure. RFID system design Antenna types, interference, antenna location and spacing, how many antennas? How many interrogators? tag types, grounding considerations, cabling, site diagrams.
This highly interactive program focuses on building the business focus on value to be achieved from initiatives. The practices in this program apply equally to projects and programs. Participants will gain insight into the capabilities needed to develop the culture, processes, and tools behind validation, what true initiatives' success looks like, which can be closely linked to achieving value. They will learn and experiment with a variety of value definition and management techniques. Working in small groups, they will collaborate with others to brainstorm, share experiences, and apply concepts to the ongoing value confirmation goal. Participants will also discover the importance of designing metrics around value and addressing blind spots that could happen when the focus is on the wrong metrics and how that could lead to the wrong behaviors being practiced. Participants will also gain insights into key skills for leading and working in the future. Hands-on experimentation activities enhance the theoretical learning, grounding it in real life and giving opportunities to practice creativity in capturing value.
Personal development groups for practitioners with Bárbara Godoy A playground for therapists to expand our perception to metaphor, as a way to connect directly with the experience of the other, guided by folklore and fairytales. "Supportive, thought-provoking, emancipating, grounding" Tuesday Evenings Group 6 pm to 7.15 pm (UK Time) Friday Lunchtime Group 12.30 pm to 1.45 pm (UK time) Spring Term Phase One - 2025 22 and 29 April 6, 13, 20 and 27 May 3, 10, 17 and 24 June Autumn Term Phase Two - 2025 23 and 30 September 7, 14, 21 and 28 October 4, 11, 18 and 25 November Winter Term Phase Three - 2026 20 and 27 January 3, 10, 17 and 24 February 3, 10, 17 and 24 March Winter Term Phase One - 2025 24 and 31 January 7, 14, 21, 28 February 7, 14, 21 and 28 March Spring Term Phase Two - 2025 25 April 2, 9, 16, 23 and 30 May 6, 13, 20 and 27 June Autumn Term Phase Three - 2025 26 September 3, 10, 17, 24 and 31 October 7, 14, 21 and 28 November Venue: Online (Zoom) Fee: £350 per term or £900 the whole year Bárbara Godoy M.A., Adv. Dip. Exi. Psy. Existential Psychotherapist Group Leader, Counsellour, Lecturer and Supervisor, MBACP & UKCP accredited, SEA Professional Member, Director of Therapy Harley StreetBárbara’s academic contributions in London since 2008 include lecturing and researching on the theory and practice of Phenomenological Existential Therapy on Doctorate, MA and professional courses at the School of Psychotherapy and Counselling Psychology, Regent’s University and the New School of Psychotherapy and Counselling directed by Emmy van Deurzen. Bárbara has facilitated and designed therapeutic Group Work since 1997. She brought her earliest workshop: “Experiences” to large groups in The Netherlands, Italy, France, UK and Argentina. These awareness-intensive processes are a legacy of the human potential movement (HPM) of the 1960s, with techniques such as AUM Meditation Marathons, Psychodrama, Bioenergetics and Primal Feelings work. Organized by:
Multimode system configurations Load analysis and battery bank sizing PV array sizing Specifying multimode inverters Advanced multimode functions Code compliance, best practices, and installation considerations Charge controllers for multimode systems DC coupled multimode battery backup design example AC coupled system design considerations AC coupled multimode battery backup design example Energy Storage Systems (ESS) overview ESS residential sizing example Large-scale multimode system design and use cases Note: SEI recommends working closely with a qualified person and/or taking PV 202 for more information on conductor sizing, electrical panel specification, and grounding systems. These topics will part of this course, but they are not the focus.