5331 AR courses 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

Stress. For a little word it sure creates a LOT of trouble and - well -there's certainly a LOT to be stressed about! Money, exams, work, relationships, health, family, the future. That's before we talk about global issues like human rights, energy and climate. Maybe we're now even stressed about our stress! It's easy to feel like we're sinking, like there's nothing can be done, that this is how it will always be. But, what if that's not the case? What if there's a way to have a different relationship with stress? What if you could boss your stress not the other way around?

Details A high energy dance party to get us moving and grooving. Expect a mix of music from 90s Boyband to Disco, Broadway classics to Latin tunes. We’ll start with a warm up then build up a routine then stretch it out. Classes are done via Facebook Live in a closed group so you can join live or replay (as many times as you like) at a time that suits you.   Instructions Find a clear and adequate space in your home with suitable flooring. Wear comfortable clothing and have water nearby. This class is suitable for all ages and abilities but please make sure you work within your own limits and what is safe for you. By joining in these online sessions you are doing so at your own risk. If you have any health concerns or are new to exercise please speak to your doctor before joining in.

An online zoom session where we as sewers and quilters can do some stitching and have a laugh at the same time.

Online fitness classes that you can do from the comfort of your own home, no equipment needed, all fitness levels welcome.

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

Tea 'N Chat discussing the new A-LEVEL ESA (Externally Lead Assessment) themes with fellow teachers

Details *30 min class* Stretch & De-stress will use techniques from Pilates and Yoga and will focus on strength and stretch in a calm environment. Using exercises for spinal mobility and core stability as well as working on those areas affected by modern life. Classes are done via Facebook Live in a closed group so you can join live or replay (as many times as you like) at a time that suits you.   Instructions Find a clear and adequate space in your home with suitable flooring. Wear comfortable clothing and have water nearby. This class is suitable for all ages and abilities but please make sure you work within your own limits and what is safe for you. By joining in these online sessions you are doing so at your own risk. If you have any health concerns or are new to exercise please speak to your doctor before joining in.

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!

Healthy boundaries start by knowing yourself at a deeper level. Learn how, who and when to say Yes or No to in a way that serves all.