4383 PE courses in Cardiff delivered Live Online

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

Free relationships and sex education training for professionals working in North Wales. Cwmni Addysg Rhyw - Sex Education Company has been commissioned to deliver relationships and sex education (RSE) training to BCUHB staff and partner organisations in North Wales. The aim of this training is to increase confidence and skills to work more effectively with issues concerning sexual health and vulnerable young people. 'The best training I have ever attended!' 'Fun & informative' Attend the first day of the course if you simply want to update your RSE information and attend both days if you want to gain skills and confidence in delivering RSE to individuals or groups. Day one Vulnerable clients Attitudes and values in relation to practice The law and sex Key sexual health issues, including safer sex Gender identity and sexual orientation Communication and sexual health Relevant resources Day two - Additional second day/module for delivering RSE - participants must have completed day one before attending day two. Assessing learning needs Developing purpose and learning outcomes Managing safety and boundary issues Planning, delivering and evaluating sessions Each day will run from 9.30am to 4.30pm via Teams or Zoom. For more information and/or to be added to our mailing list contact Mel Gadd mel@sexeducationcompany.org Terms & conditions: Cwmni Addysg Rhyw facilitates externally funded training to staff that work in the public, private, voluntary and independent sectors. There is significant investment of resources in terms of time, planning and budget to deliver this service and due to repeated incidents of non-attendance without notice it has now become necessary to introduce a charging policy for cancellation and non attendance. Although this course is free of charge to attend we will charge late cancellation administration fees as follows: No notification of non-attendance - £50, less than 48 hours notice of non-attendance £30, Less than 1 weeks notice of non-attendance £25. By registering on the course you agree to these charges on late cancellation or failure to attend. As we usually have a reserve list for our courses we ask you to only book on the course if you can attend the whole day. Arriving late or leaving early will be classed as non-attendance and may be charged as such. We will be delivering this training via Teams or Zoom. It is your responsibility to ensure you can use the platform before booking. If you are unable to access the training on the day because you can't access the platform this will be classed as non attendance and will be charged as such. If you want to check that you can access the training via teams/zoom before booking please contact us. We are happy to set up a quick call for you to check access.

Affordable, online, weekly dance classes for all abilities. Boogie Bold is a supportive environment where you can have fun and feel great.

NEEODANCE contemporary dance class in studio & online. Skills. Hobby. Network. Exam/audition support.

An hour exploring Autism, including the communication differences, strengths, sensory differences and unique experiences.

An interactive workshop with Karen Hale. Learn how to gain the confidence, skills and techniques to speak up so you can be heard. "There are two types of speakers: Those who get nervous and those who are liars." - Mark Twain Is this you? Promotions not applied for, jobs roles not tried for, networking events not attended? Parties avoided, family ceremonies not spoken at, too much left unsaid? Do you have excellent ideas that get lost in time because you are fearful of voicing them. Have you missed opportunities because it involves showing up? Do you stay silent in meetings? Do you have a brilliant business idea that isn’t being pursued because you know it will involve some kind of networking or public speaking? If the answer to any/most of these is YES, then read on... This workshop is strange by its nature. Why would someone who disliked public speaking, go to a place where they would speak in public? This is why.... Because Karen has analysed what makes a good communicator when speaking informally to people; she has taken those aspects and developed a group of exercises that allows you to use these exact techniques when speaking at networking events and in public. Added to that, Karen provides a smorgasbord of methods on how to control nerves to ensure you communicate at your authentic best. Please note: everybody in the room will be there for the same reason as you! You will be supported and encouraged and will learn how to turn fear into empowerment! About Karen: An empowerment and public speaking coach with over 30 years experience in coaching and advising individuals and business leaders from a diverse range of sectors on effective communication skills. It takes a second to form a first impression about a person. Your body language, clothes, speech and personal presence convey messages about your background, skills and expertise. Karen works with her clients to ensure they make that first impression powerful and authentic so they get remembered for the right reasons. By creating a confident and authentic presence you increase your visibility and your credibility. “Karen is a truly special individual. She made me feel totally at ease and was able to help me stand and speak confidently for the first time and she did that all with huge warmth and a lot of humour.” She fulfils her greatest passion on a daily basis, helping people present themselves to the outside world in the very best way. She has enabled hundreds of people to move on in their life and careers and build their growth, confidence and image. Karen works across a huge spectrum - from CEOs in FTSE 100 companies to Foundation Class university students at UAL coaching presentation skills. She coaches senior individuals and consults to leading global banks, private banks and family offices, advising business leaders and their teams. She is Central School of Speech and Drama trained. Kind words about Karen... I have had the absolute pleasure of working with Karen numerous times over the past 16 years to assist me in my various corporate roles. Karen has always been the person I have turned to first and foremost when I have needed help with my personal brand, presence and communication, helping me develop confidence in public speaking and showing up in front of the camera. A HUGE thank you for Monday – you were wonderful. The feedback we have had has been unbelievable – I can honestly say in all my years in this industry I have never heard such positive comments on every aspect. Karen has an incredible gift of making you feel completely at ease and is able to bring the best out of a person with ease. She is friendly, approachable and warm and I now refer Karen to everybody I know who needs assistance with any type of public speaking, communication and confidence requirement. The results speak for themselves. Highly recommend! You can contact Karen at: https://www.linkedin.com/in/karen-hale-8925862b/ / 07956626740 For any questions regarding this event, please contact the organiser lara@themotivationclinic.co.uk / 07817247727 - thank you!

We will learn about the patterns in nature through looking at different leaf shapes and using these to create monoprints.

We would love to invite you to Art in the Park's ONLINE Life Drawing with harp player, Tatyana!

We would love to invite you to Art in the Park's ONLINE Life Drawing with Cuban born, Singer-Song writer: Jesús Cutiño!

We would love to invite you to Art in the Park's ONLINE Portrait Drawing Session with Claudio Giuseppe posing live for us!