1192 Courses

Learn to sew a tote bag, add French seams to your sewing skills with this sewing skills building workshop.

This comprehensive course will show you how to use SQL Server, ASP.NET Core, Angular 14, and Bootstrap to build a blog from scratch.

Enjoy a glass of bubbly while you have fun pimping your wellies with paints, glitter, diamantes, jewels and all colours of the rainbow in the Flamingo Studio.

A beginner friendly embroidery workshop at Studio Dawn with Stephie from Hoop & Fred

Course Description Get instant knowledge from this bite-sized Voiceover Artist Training Part - 3 course. This course is very short and you can complete it within a very short time. In this Voiceover Artist Training Part - 3 course you will get fundamental ideas of voiceover, the key understanding of the UK voice acting industry, the studio and so on. Enrol in this course today and start your instant first step towards learning about how to record your voice. Learn faster for instant implementation. Learning outcome Understand how to record your voice Understand the UK voice acting industry Learn about the studio Know how to promote your voice How Much Do Voice Over Artists Earn?  Senior - £62,000 Average - £36,000 Starting - £21,000 Requirement Our Voiceover Artist Training Part - 3 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Voiceover Artist Training Part - 3 Module 01: Record Your Voice 00:15:00 Module 02: The Studio 00:25:00 Module 03: Promoting Your Voice 00:12:00 Module 04: UK Voice Acting Industry 00:24:00 Assignment Assignment - Voiceover Artist Training Part - 3 00:00:00

With this course, you will learn the bare-bone basics of C# by building console applications from scratch. You will first develop the application and then test it to gain a solid understanding of C# fundamentals. You will also explore the latest features released in C# 7.

This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals. Learning Outcomes: Set up and configure SQL Server and SQL Azure Data Studio for data analysis. Master SQL statements for data manipulation, data structure, and user management. Utilize SQL queries, joins, and aggregate functions for efficient data analysis. Understand SQL constraints, views, and advanced commands for in-depth data exploration. Create and implement SQL stored procedures to automate tasks. Leverage Azure Data Studio for data visualization and perform data analysis with SQL. Why buy this SQL for Data Science, Data Analytics and Data Visualization? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the SQL for Data Science, Data Analytics and Data Visualization there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This SQL for Data Science, Data Analytics and Data Visualization course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Getting Started Introduction 00:03:00 How to get course requirements 00:03:00 Getting started on Windows, Linux or Docker 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: SQL Server setting up Section Introduction 00:02:00 Microsoft SQL Server Installation 00:19:00 SQL Server Management Studio (SSMS) Installation 00:08:00 How to connect MS SQL (Windows Authentication) 00:04:00 How to connect MS SQL (SQL Server Authentication) 00:03:00 Download and Restore Sample Database 00:07:00 Section 03: SQL Azure Data Studio What is Azure Data Studio 00:06:00 Azure Data Studio Installation steps 00:07:00 Azure Data Studio to Connect SQL Server 00:09:00 Create a Database 00:07:00 Create a Table 00:09:00 Insert Data rows 00:07:00 View the Data returned by Query 00:03:00 Section 04: SQL Database basic SSMS Section Introduction 00:01:00 Overview of Databases8 00:11:00 Creating Database 00:05:00 SQL Data Types 00:03:00 Column Data Types on SSMS 00:04:00 Creating Table 00:09:00 Overview of Primary Key and Foreign Key 00:04:00 Primary Key 00:04:00 Foreign Key 00:07:00 Creating Temporary tables 00:06:00 Section 05: SQL Statements for DATA Section Introduction 00:01:00 Insert statement 00:08:00 Update statement 00:05:00 Delete statement 00:03:00 Section 06: SQL Data Structure statements Section Introduction 00:01:00 CREATE table statement 00:03:00 DROP statement 00:02:00 ALTER statement 00:05:00 TRUNCATE statement 00:04:00 COMMENT in query 00:01:00 RENAME 00:02:00 Section 07: SQL User Management Create Database user 00:04:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 08: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:07:00 SELECT DISTINCT 00:03:00 SELECT with column headings 00:03:00 Column AS statement 00:02:00 Section 09: Filtering Data rows SELECT WHERE Clause - theory 00:04:00 SELECT WHERE Clause - practical 00:07:00 Section 10: Aggregate functions Sum() 00:08:00 Min()-Max() 00:06:00 Section 11: SQL Query statements Order By statement 00:05:00 SELECT TOP clause in SQL 00:04:00 BETWEEN command 00:08:00 IN operator 00:04:00 Wildcard Characters and LIKE 00:05:00 Section 12: SQL Group by statement Section Introduction 00:01:00 Group by - theory8 00:03:00 Group by - practical 00:05:00 HAVING statement 00:04:00 Section 13: JOINS for Multiple table Data Analysis Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:08:00 Left outer join 00:03:00 Right outer join 00:02:00 Full outer join 00:01:00 Union 00:03:00 Cartesian Product with the Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 14: SQL Constraints Section introduction 00:01:00 Check constraint 00:07:00 NOT NULL constraint 00:08:00 UNIQUE constraint 00:05:00 Section 15: Views Creating Views 00:04:00 Reporting with multiple tables 00:03:00 Section 16: Advanced SQL commands Section Introduction 00:01:00 Timestamp 00:04:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:04:00 String functions 00:05:00 Sub Query 00:03:00 SELECT with calculations 00:06:00 Section 17: SQL Stored procedures Create stored procedure 00:05:00 Stored procedure with parameter 00:04:00 Section 18: Azure Data Studio Visualization Installing SandDance Extension 00:03:00 Visualization Charts 00:05:00 Multiple Table Data Charts 00:06:00 Section 19: Azure Studio SQL for Data Analysis Type Decision for Data Analysis 00:13:00 Data Analysis with Case Statement and String Text 00:09:00 Section 20: Import & Export data Section Introduction 00:01:00 Import Flat File 00:05:00 Import .csv or excel file 00:03:00 Export Data to Excel or any format 00:06:00 Section 21: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:04:00 Restoring Database backup 00:04:00

Join Wildside London in the creative studio at West 16th for a Pumpkin Vase workshop on Tuesday 29th October at 7pm.  Get into the spirit of the spooky season and learn a few floral tricks and treats while creating a fabulous pumpkin vase with an array of autumnal florals. The displays will last a few weeks and make a fantastic halloween edition to your doorstep, dinner table or kitchen counter. Our workshops are fun, immersive and relaxed and we provide all the materials and instruction to enable you to design and build a fabulous display. Drinks and treats from the West 16th kitchen will be served alongside the pumpkin vase tutorial and are included in the ticket cost.

If you've always wanted to make handmade pottery but have no idea where to begin, this beginner-friendly wheel throwing class could be just the pottery workshop for you & your friends!

Craft workshop where you have a go at simple glass cutting before layering your chosen colours up with textural details to produce your own Big Bold Hanging. Fused Glass Workshop – Big Bold Hangings I want to share my 15+ years of experience with you. This in person fused glass workshop is held at my Derbyshire studio and gallery space in the middle of Wirksworth near Matlock. About this fused glass workshop For this workshop I’ll give you a base piece of clear glass (precut and with a hole drilled (approx 30x5cm) for you to decorate with stripes of your favourite colours. I prepare lots of transparent glass to give you lots of strips to cut to length yourself. Build a design and layer as you like with extra textural details to really personalise your make. This is a great introduction to glass cutting, anyone can do it with the tips and tricks I’ll show you. The main thing to remember is to have fun! You will play with different types of decorative glass elements and learn a little about how the kiln firing will change them. Simply complete your design during the session and leave it at the studio for me to fire, clean and finish with a lovely ribbon, ready for you to display and enjoy. We will arrange for you to collect your piece after a few weeks or I can post your finished piece at cost. I will talk through all the Health & Safety in the session but I want you to know now, you will be handling precut glass pieces, they have pointy ends but with the right handling, they won’t hurt you. Recommended for ages 13+, all under 16s to be accompanied by a paying adult. Photos shown here (and on my facebook page) are previous students makes. Book with friends or come on your own for a supportive and fun creative fused glass workshop experience. All fused glass workshop attendees receive a 10% discount on purchases from the gallery shop on the day, just a little way I can say thank you for joining me! Things to bring with you: A bottle of water or travel cup of coffee/tea. An apron or old clothes so you don’t have to worry about getting glue or other materials on them. Pictures or images that inspire you, even if it’s just for colour reference but remember we will be a limited to the effects achievable with the materials and tools though. An open mind and willingness to experiment. Booking When booking make sure your email address is correct at checkout as I will email you any further information needed for the workshop. Please also include a contact phone number in the unlikely event that I need to cancel a workshop at short notice. Venue: Create Space Studio & Gallery, 27 Market Place, Wirksworth, Matlock DE4 4ET  Currently, the washroom facilities in the studio shop aren’t the best, they probably won’t ever be perfect but I do have a working w.c and sink now, just behind a curtain. I would still recommend considering supporting one of the independent cafés, restaurants and pubs who would welcome some extra business in return for a comfort break. Workshop T&Cs: Please read through the Terms & Conditions for Glass Fusing Workshops and Courses that are booked here online. When you book a place,you are agreeing to the following terms and conditions. Bookings and cancellations Bookings – If you can not attend a workshop, for what ever reason, please contact Stevie as soon as possible. Firstly we will work together to transfer your place onto another day, suitable for your needs. Another option is for you to offer your place out to a friend or family member. If this is not possible and your cancellation has been more less than 21 days in advance of the event, a refund can be offered. If your cancellation has been made less than 21 days before the event and you can not transfer onto a future date, every effort will be made to fill your place, from further advertising and/or the reserves list. If your space can not be filled by another attendee and you are unable to arrange a replacement yourself unfortunately, no refund can be offered. In the unlikely event that Stevie has to cancel a class, you will be offered either a full refund or a transfer to another date. As much notice as possible will be given, however, Stevie cannot be held responsible for your travel or accommodation costs. Accessibility Accessibility – Workshops at Create Space, Wirksworth: Entrance to the Studio Gallery has 2 stone steps. The workshop table is fixed and also up one step, the main table is high, you will be stood or sat on a tall chair.  Please contact Stevie for information about the suitability of her courses for ages and abilities before booking. Health & Safety Stevie reserves the right to exclude any student we feel may be a danger to themselves or other students.