1265 Courses

This workshop gives you the unique opportunity to experience the basics of two crafts in 1 day in your own personal pairs workshop with one to one tuition. The studios are located in the cottage garden of our home on the Cambridgeshire/Norfolk border. Your experience is private to you and there will be no other students in the studios. The "2 crafts in 1 day" workshop is aimed at those who want to have a go at both of these fun crafts, and come away having learnt some basic techniques for both disciplines. As this is basically a private tuition experience, the course is focused but fun, so would make a fantastic gift. The day can also be experienced by just 1 person (to book this, please refer to our other workshop ""2 Crafts in 1 Day!" 1-2-1 woodturning & pottery experience in 1 day for 1 person" where each person could experience the crafts singularly or together.  This makes for a wonderful Valentine's or anniversary experience, and can also be enjoyed by a parent and child. The morning is spent learning the ropes of woodturning - how to cut and shape wood on the lathe, understanding a little about the different tools required, and making a few pieces to take home. After a light farmhouse-style lunch (which we provide and which we tailor to your dietary requirements), the afternoon then continues with a pottery session. Students can have fun with clay, focusing on some basic hand building methods to get them used to handling the material using the techniques of pinching, coiling, slab building and also throwing on the wheel.  A total of 3 pieces can then be chosen for us to glaze and fire once they have dried sufficiently. When ready, they can either be collected by the student (if they live locally) or I can post them on (I have to charge postage & packaging). Refreshments are provided during both workshops, and a light, rustic farmhouse-style lunch is also included - catering to all dietary requirements. Depending on the weather/time of year, lunch can be taken either out in the cottage garden or in our country kitchen. The sessions are hands-on with expert 1-2-1 tuition - and the student will be able to use all the studio facilities. Each student will also be provided with a certificate of participation for both crafts. About a week before your workshop date, we'll e-mail you again with more details about parking etc. We also offer accommodation in the form of our Crafter's Retreat cabin (www.craftersretreat.co.uk) or we can advise of other local B&Bs.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.

Improve your flexibility in a safe and gentle way at Pole Twisters dance studios

Hello to all our fabulous dancers out there! Welcome to our Glamorous Strides Heels Dance Class, a class designed to sprinkle a dash of confidence and a whole lot of sass onto your dance journey. Lacing up your heels for this class is completely optional - but bringing your vibrant energy and giving it your all is non-negotiable! As we explore a dazzling array of poses and dance techniques, you'll also be learning some irresistibly fun and seductive choreography that's guaranteed to turn heads. If you love our energy and are ready to embark on an exhilarating journey of discovery and exploration, we can't wait to see your radiant smiles and determined spirits in our upcoming Heels Course. Here's a glimpse of what you'll begin to master in our Glamorous Strides class: Dance Technique & Flexibility: We'll sharpen your dance techniques and improve your flexibility, making every move look effortlessly graceful. Walking & Balancing in Heels: If you choose to wear heels, we'll teach you how to glide across the dance floor with poise and balance. Posing Techniques: Strike a pose! Learn how to accentuate your movements and exude confidence with our expert posing techniques. Stretching: Proper stretching is crucial in dance, and we'll ensure you learn how to do it right, promoting flexibility and preventing injury. Choreography and Performance: Last but not least, you'll learn captivating choreography and the art of performance, imbuing every dance with your unique style and charisma. So, ready to strut, spin, and unleash your inner diva in our Glamorous Strides Heels Dance Class? We can't wait to welcome you to the studio, ready to sparkle and shine on this exciting dance journey. Remember, heels dance is all about confidence, expression, and most importantly, having a fantastic time on the dance floor. Let's strut, spin, and let our spirits shine together in Glamorous Strides! See you in the studio!

Course Overview The database is a must for collecting, saving, sorting and finding out data of your website or software. An effective database can make your software more engaging and interactive. learn how to use Microsoft SQL Server from this Microsoft SQL Server Development course and boost the quality of your software. This Microsoft SQL Server Development course will teach you the functions of databases and querying from scratch. You will learn about Microsoft SQL Server, relational database management systems, various functions, tables and relationships from this course. You will be able to use the database for your software development and management. This course will also teach you the best practices for database development and management. Learning Outcomes Learn how to use Microsoft SQL management studio Familiarize with basic database design Learn how you can use select statements Be able to insert delete or update data into data tables Learn about the best practices for database development Create relationships among multiple tables Learn how you can use foreign keys Be able to create Complex database objects Understand how to backup and restore database Who is this course for? This course is helpful for anyone who wants to learn about the database management system and SQL servers. You will be able to understand the function of the database, logic and usability of the database for your Microsoft SQL server development. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Microsoft SQL Server Development is a useful qualification to possess and would be beneficial for any related profession or industry such as: Software Engineer Web Developers Data Security Officers Database Administrators Database Developers Introduction Introduction to SQL Server and Databases 00:04:00 Download and Install SQL Server Express 00:05:00 Manipulating Tables and Data Connect to Database Instance and Create a Database 00:06:00 Drop or Remove Database 00:04:00 What is a Database Table? 00:02:00 Create an SQL Database Table 00:32:00 Insert Data into the Table with SQL Script 00:15:00 Insert Data into the Table with Management Studio 00:05:00 Select Data from the Table with SQL Script 00:09:00 More Advanced Select Queries Part 1 00:18:00 Update Data in the Table 00:10:00 Update Data in the Table with Management Studio GUI 00:02:00 Delete Data from the Table with SQL Script 00:06:00 Delete Data from the Table with Management Studio GUI 00:01:00 Relationships and Foreign Keys What are Relationships, Foreign Keys and Normalization 00:11:00 Create a Relationship in SQL Server 00:19:00 Insert Records in Related Tables 00:13:00 Run Queries on Related Tables 00:19:00 Left, Right and Full Joins 00:11:00 Group By and Aggregate Functions Grouping Data using SQL GROUP BY Clause 00:12:00 SQL AVG Aggregate Function 00:11:00 SQL COUNT Aggregate Function 00:04:00 SQL MAX and MIN Aggregate Functions 00:04:00 SQL SUM Aggregate Function 00:04:00 Advanced SQL Server Objects and Concepts Create and Manage Views 00:23:00 Scalar Valued Functions 00:27:00 Inline Table Valued Functions 00:09:00 Multi Statement Table Valued Functions 00:12:00 Stored Procedures 00:28:00 Table Triggers 00:19:00 Database Scripting, Backup and Restore 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 3 Days 18 CPD hours This course is intended for This course is designed for project managers, Scrum masters, business analysts, and team leaders looking to effectively manage their development projects using Team Foundation Server 2017. Overview The course also demonstrates how TFS facilitates the use of storyboards to prototype experiences, request stakeholder feedback, foster team collaboration, and generate reports. The final two modules of the course provide an overview of how testers and developers can work effectively using appropriate tools in the Visual Studio family. In this course, attendees will plan a new software development project and go through the steps to initiate the project using Visual Studio 2017. This includes recording requirements, creating a product backlog, and estimating effort for backlog items. Introducing the Microsoft Visual Studio 2017 Family What?s new in Visual Studio 2017 Overview of the Visual Studio 2017 family Overview of product features Project workflow across the Visual Studio 2017 suite of products Initiating a New Project Organizing projects in TFS Understanding process templates Creating a new team project Setting team project properties Switching between team projects Work Item Primer Overview of work items Traceability between work items Searching and creating custom queries Work item charting and pinning charts Work item tagging Configuring project notifications Creating our Product Backlog Examining requirement types Creating backlog items Creating requirement hierarchies using features The importance of acceptance criteria Agile Estimation Introduction to estimation Using story points Planning Poker and other popular estimation techniques Adding your estimates to TFS work items Working from the Product Backlog Introducing the Kanban board Entering and editing details on the Kanban board Customizing columns, including using split columns and limiting WIP Recording our Definition of Done (DoD) Understanding the Cumulative Flow Diagram Working in Sprints Specifying your sprint schedule and your team capacity Selecting items for the sprint backlog using forecasting Decomposing requirements into tasks Using burndown charts to track progress Monitoring work using the task board Working with unparented work items Retrospectives The importance of retrospectives Conducting an efficient sprint retrospective What you should avoid in your retrospective Working with TFS Teams Configuring teams in our team project Managing work from a master backlog Allocating work to our teams Configuring iterations for TFS teams Enhancing Requirements Using Storyboards Overview of storyboarding capabilities Creating a storyboard to illustrate a requirement Linking a storyboard to a work item Getting Stakeholder Feedback Introducing the Microsoft Feedback Client Using the Microsoft Feedback Client to provide rich feedback to the team Adding continuous feedback into your workflow Fostering Team Collaboration An overview of the various clients The use of email in sharing information Choosing the appropriate client tool Creating and Customizing Reports Overview of reporting architecture Reviewing the out of the box reports Adding new reports Creating ad hoc reports using Excel Overview of Agile Testing The role of the tester in a sprint planning meeting A lap around web-based test management Creating a test plan Creating manual test cases from requirements Overview of Agile Development Using My Work to select tasks from the sprint backlog Understanding the value of linking changesets to work items The importance of unit testing Creating a continuous integration build Additional course details: Nexus Humans Managing Agile Projects Using TFS 2017 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 Managing Agile Projects Using TFS 2017 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.

Make your own willow stars, enjoy an evening workshop of willow weaving with homemade cakes.

Indulge in an Inspiration Day creative workshop at Beach Gallery to nurture your soul & awaken your creativity

Are you ready to dive into the captivating world of ceramic arts? Whether you're a beginner eager to explore or someone looking to refine your skills, the Ceramic Arts Fundamentals Course is the perfect way to ignite your creative spark. This course offers a complete introduction to ceramic techniques, from shaping and moulding to glazing and firing, all from the comfort of your own space. With clear, step-by-step guidance, you'll learn the core principles that form the foundation of this timeless craft. Through this course, you’ll gain a deeper understanding of various clay types, tools, and methods, enabling you to create stunning ceramic pieces. No prior experience is required—just a passion for learning and an interest in the craft. Designed for those who prefer learning at their own pace, the course provides all the insights needed to develop your skills and confidence. Whether you're looking to create functional pieces or artistic sculptures, the Ceramic Arts Fundamentals Course will help you unleash your creativity, one masterpiece at a time. Join us today and bring your vision to life, as you explore the endless possibilities that ceramic art has to offer. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 1: Introduction to Ceramic Arts Module 2: Ceramic Techniques and Processes Module 3: Clay and Glaze Chemistry Module 4: Ceramic Sculpture Module 5: Surface Decoration and Finishing Module 6: Kiln Firing and Ceramic Studio Practices Learning Outcomes: Develop foundational knowledge in Ceramic Arts techniques. Understand the intricacies of clay and glaze chemistry for optimal results. Master the art of sculpting clay into captivating, meaningful forms. Acquire skills in surface decoration and finishing for artistic finesse. Navigate kiln firing processes with precision and confidence. Establish effective studio practices for a seamless creative workflow. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring ceramic artists seeking foundational skills. Art enthusiasts eager to explore the world of ceramics. Creative individuals looking to express themselves through pottery. Students with a passion for sculptural arts and crafts. Hobbyists desiring a deeper understanding of ceramic processes. Individuals with a curiosity for clay and glaze chemistry. Beginners seeking a comprehensive introduction to Ceramic Arts. Those yearning to unleash their artistic potential through ceramics. Career path Ceramic Artist Pottery Instructor Studio Technician Ceramic Product Designer Exhibition Curator Craft Shop Manager Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

https://www.instagram.com/masterpeacelondon/