229 Courses in London

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

A relaxed and informal Blackwork Embroidery course in the lovely setting of a converted 18th Century cotton mill in Warwick Bridge, Carlisle. This course has been designed to guide the complete beginner or act as a refresher for those who may have dabbled in Blackwork embroidery in the past. We will cover the history, styles of Blackwork embroidery, threads and techniques.

– BAG MAKING COURSE – LEATHER GOODS MAKING COURSE: MAKE A STITCHLESS LEATHER BAG – WHAT IS THIS COURSE ABOUT?This is one of our group leather goods making courses for beginners that we organise at our London studio.Using beautiful vegetable-tanned leather, basic leather tools and simple metal fittings, you will make a stitchless leather bag while learning five basic leather working techniques.You will customise your bag by choosing between two designs (see photo gallery) and selecting your preferred colours of leather and fittings.No sewing skills or experience is required!At the end of the course, you won’t just take home a beautiful bag made entirely by you but also an understanding of working with leather and essential leather tools.WHAT WILL I LEARN?During our leather goods making courses, you will always receive an introduction to:-Different leather types-Essential leather tools You will then learn these 5 basic leather working techniques:-Marking leather-Cutting leather-Folding leather-Punching leather-Burnishing leather In the second part of the course, you will apply the techniques learnt by hand-cutting and assembling your beautiful bag using screw studs. No sewing is required.INCLUDED IN THE COURSE:All materials and tools are supplied.WHAT ARE THE ENTRY REQUIREMENTS?This course on making a stitchless leather bag is suitable for beginners.You should be able to use measurements and understand verbal and written English instructions. ADDITIONAL MATERIAL PROVIDEDIn addition to the course, you will receive the following useful handouts to take home with you:– An introduction to leather types and features – A glossary of leather craft tools which includes images and helpful descriptions – A list of the basic fittings used in handbag making, including images and descriptions – A list of reputable suppliers to buy leather and fittings from (in London and online)HOW LONG IS THIS TUITION?:This tuition will require up to 7 hours to complete.We aim to provide customised and high quality tuition services and by only allowing up to 5 students at a time, we are able to focus on each person needs and interests.As every student has a different level of ability and previous experience, this course might lead some students to complete the core aspects of the lesson in a shorter time frame than others.Students who complete the course early will be welcome to stay and use the studio facilities to exercise on the topics of the lesson.

Salsa Cuban Style workshop For Couples only - every first Sunday of the month @ 4 PM until 6 PM

Hello little stars and welcome to our Ballet Beginners Dance Class, lovingly designed for our tiniest dancers aged between 3 and 5. Ready to dip your toes into the magical world of ballet and take your first dance steps? If your heart is saying a big "Yes!", then we are thrilled to welcome you on board! Ballet is more than just a dance form; it's an enchanting story told through movement and grace. Our Ballet Beginners class is a gentle introduction to this beautiful dance style. From the moment your little one steps into our ballet studio, they'll be embarking on an exciting journey of discovery and growth. In our class, we'll start with the very basics of ballet. We'll be learning essential dance steps, from the lovely "plié" to the elegant "relevé". Our caring and professional instructors will guide your child through these first steps, ensuring they learn in a nurturing and fun environment. But ballet is about more than just dance steps. We'll also be focusing on balance, coordination, and posture, helping to develop muscle strength and flexibility. Through a variety of fun activities and exercises, your child will not only become a budding ballet dancer but also develop as a confident little mover! Yet, Ballet Beginners is not just about learning ballet. We believe that dance is a powerful tool for building life skills. Through ballet, your child will boost their self-esteem, learn to express themselves, and even develop discipline and patience. Each step, twirl, and leap is a step towards confidence and self-belief! Friendship is another delightful aspect of our class. Your child will make wonderful friends who share their love for ballet. They'll form bonds that go beyond the dance studio, creating beautiful memories along the way. So, pull on your little ballet slippers, tiny dancers! It's time to twirl, leap, and discover the joy of ballet in our Ballet Beginners class. We can't wait to guide you on this exciting journey. Remember, ballet is about expressing yourself, developing grace, and most importantly, enjoying the journey. So, let's step, leap, and love the ballet beat together in our Ballet Beginners class! See you at the barre!

Giving your child the gift of music while they are still young can be one of the most meaningful investments you could make in their life, and our London piano lessons for kids are structured to support the musical goals you have for your children. Your child’s or grandchild’s life will be permanently enriched from music lessons, whether they continue with music as a career, enjoy it as a serious amateur pursuit, or play casually for their own benefit and that of their friends and family.

Time: 4pm Date: Friday 8th December Location: Studio A Come and celebrate the work of your fellow CFS students and staff, as we showcase short films that have been made within our academic community! Featuring a wide variety of different visual stories, genres, themes and ideas, we are proud to be showcasing all these films in Studio A on the big screen! Be sure to book your ticket to come along to our school's own miniature film festival!

Hello to our sparkling dancers and welcome to our Ballet Brilliance Level 1 Class, an engaging progression for our ballet enthusiasts aged between 5 and 8. Ready to leap into the next stage of your ballet journey, further enhancing your graceful moves? If your hearts are fluttering with excitement, we are overjoyed to accompany you on this magical adventure! Ballet is a delightful dance form that combines elegance, precision, and expressiveness. Our Ballet Level 1 class is here to guide you deeper into this exquisite world of dance. As you step into our welcoming ballet studio, you'll continue to cultivate your love for ballet and refine your dance skills. Our class goes beyond the basics, delving into the core elements of ballet. You'll polish your essential dance steps and explore new ones, from the twirling "pirouettes" to the leaping "jetés". Our attentive and qualified instructors will be right by your side, fostering a supportive and engaging learning environment. But Ballet Level 1 isn't just about dance steps. We'll place special emphasis on coordination, balance, and posture, key components in forming a strong ballet foundation. You'll also be working on stretching exercises and aiming to master the perfect splits. Your flexibility and muscle strength will grow in leaps and bounds, just like your ballet skills! We'll also introduce the exciting world of ballet jumps and turns. These dynamic movements not only add spectacle to your dance but also help develop agility and spatial awareness. Each jump and turn is a testament to your growth as a budding ballet dancer! Our Ballet Level 1 class is more than a ballet lesson; it's a holistic learning experience. You'll boost your self-esteem, learn valuable life skills, and form bonds with your fellow ballet dancers. Each plie and pirouette is a step towards self-confidence and resilience! The friendships you'll make in our class are truly special. Ballet is about harmony and teamwork, and our class is a testament to this ethos. You'll create shared memories that will last a lifetime, all while nurturing a shared love for ballet. So, tie up your ballet slippers and prepare to pirouette, plie, and pursue your ballet dreams in our Ballet Level 1 class. We can't wait to see you at the barre, ready to take on the next chapter of your ballet journey! Remember, ballet is about expressing grace, demonstrating precision, and most importantly, enjoying every twirl and leap. Let's plie, pirouette, and pursue our ballet dreams together in Ballet Level 1! See you in the studio!

DATE: Tuesday 14th May TIME: 4:00pm LOCATION: Studio A On Tuesday 14th May we'll be hosting an International Students Event in Studio A, an opportunity for our international students to come together, get to know one another and share short films from their home countries and states, followed by some casual drinks and finger food.If you are planning on attending, please fill in this form where you can submit the film you wish to present. All films should be accessible for free online using platforms such as YouTube or Vimeo.

SCREEN ACTING COURSE London for Beginners will teach you effective on-camera skills, compelling auditioning & camera acting techniques.