• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

175 Scala courses in London delivered On Demand

A to Z SQL Programming

4.7(160)

By Janets

Follow your dreams by enrolling on the A to Z SQL Programming course today and develop the experience, skills and knowledge you need to enhance your professional development. A to Z SQL Programming will help you arm yourself with the qualities you need to work towards your dream job. Study the A to Z SQL Programming training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The A to Z SQL Programming course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This A to Z SQL Programming course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the A to Z SQL Programming course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the A to Z SQL Programming course, to ensure you are supported every step of the way. Get a digital certificate as proof of your A to Z SQL Programming course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the A to Z SQL Programming course. The A to Z SQL Programming course is designed by industry experts and is tailored to help you learn new skills with ease.  The A to Z SQL Programming is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the A to Z SQL Programming when it suits you. Access the A to Z SQL Programming course modules from any internet-enabled device, including computers, tablets, and smartphones. The A to Z SQL Programming course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the A to Z SQL Programming now and start learning instantly! What You Get Out Of Studying A to Z SQL Programming With Janets: Receive a digital Certificate upon successful completion of the A to Z SQL Programming course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The A to Z SQL Programming training course is delivered through Janets' online learning platform. Access the A to Z SQL Programming content from any internet-enabled device whenever or wherever you want to. The A to Z SQL Programming course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the A to Z SQL Programming course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the A to Z SQL Programming course. After successfully passing the A to Z SQL Programming course exam, you will be able to apply for a CPD-accredited certificate as proof of your A to Z SQL Programming qualification. Certification All students who successfully complete the A to Z SQL Programming course can instantly download their digital certificate. You can also purchase a hard copy of the A to Z SQL Programming course certificate, which will be delivered by post for £9.99. Who Is This Course For: The A to Z SQL Programming is ideal for those who already work in this sector or are an aspiring professional. This A to Z SQL Programming course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The A to Z SQL Programming is open to all students and has no formal entry requirements. To study the A to Z SQL Programming course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The A to Z SQL Programming is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the A to Z SQL Programming and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Beginner Module: 01 Introduction FREE 00:16:00 Tools for Creating Views 00:11:00 Examples 00:21:00 Updating Data Using a View 00:13:00 Columns and Indexed Views 00:18:00 Module: 02 Introduction Stored Procedures 00:18:00 Creating Stored Procedures 00:19:00 Returning Data 00:14:00 Module: 03 Testing and Debugging 00:17:00 Execute with Result Sets 00:11:00 Creating Triggers 00:26:00 Module: 04 Overview and Scalar Functions 00:20:00 Inline Table Valued Functions 00:11:00 Multi Statement 00:16:00 Views and Stored Procedures 00:18:00 Module: 05 Transaction Concepts 00:30:00 Applications and Transactions 00:13:00 Creating Explicit Transactions 00:29:00 Structured Error Handling 00:25:00 Module: 06 Introduction to SQL CLR 00:08:00 Writing SQL CLR Code 00:24:00 Using SQL CLR Code 00:22:00 SQL CLR Code 00:13:00 SQL CLR Security 00:20:00 Intermediate Module: 01 Topic A Aggregates 00:27:00 Topic B User Defined Types 00:17:00 Topic C Table and Functions 00:10:00 Topic D Managing Code Modules 00:08:00 Module: 02 Topic A Introduction Data Tools 00:19:00 Topic B Connected Database Development 00:20:00 Topic C Updating a Connected Database 00:16:00 Module: 03 Topic A Creating New Objects with TSQL 00:12:00 Topic B Comparing Database Schemas 00:10:00 Topic C Offline Database Development 00:13:00 Topic D Database Project Settings 00:18:00 Module: 04 Topic A Using APPLY 00:15:00 Topic B MERGE Statement 00:23:00 Topic C Creating Recursive Queries 00:08:00 Topic D Grouping Sets 00:12:00 Module: 05 Topic A ROLLUP and CUBE Operators 00:12:00 Topic B Creating Pivot Queries 00:14:00 Topic C Executing Dynamic SQL 00:28:00 Module: 06 Topic A Complex Query Execution 00:26:00 Topic B Using Execution Plans 00:16:00 Topic C Execution Plan Operators 00:12:00 Topic D Common Join Operators 00:16:00 Module: 07 Topic A Hierarchy ID Data Type 00:12:00 Topic B Exploring a Hierarchy 00:09:00 Topic C Sparse Columns 00:16:00 Topic D Column Sets 00:12:00 Module: 08 Topic A Filtered Indexes 00:09:00 Topic B FILESTREAM Storage 00:22:00 Topic C Adding Sequences to Queries 00:22:00 Module: 09 Topic A Introduction to Spatial Data 00:13:00 Topic B Spatial Data in SQL Server 00:23:00 Topic C Manipulating Spatial Shapes 00:10:00 Topic D Interactions Between Objects 00:09:00 Advanced Module: 01 Topic A Partitioning 00:20:00 Topic B Creating Partition Tables 00:30:00 Topic C Querying Partitions 00:14:00 Topic D Managing Partitions 00:17:00 Module: 02 Topic A Complex Querying 00:22:00 Topic B Rankings 00:15:00 Topic C SubQueries 00:21:00 Topic D Common Table Expressions 00:17:00 Module: 03 Topic A Complex Data and Structures 00:26:00 Topic B Efficient Queries 00:36:00 Topic C Complex Queries 00:17:00 Module: 04 Topic A XML Data Type 00:28:00 Topic B XML Schemas 00:17:00 Topic C Querying XML 00:20:00 Topic D Best Practices 00:08:00 Mock Exam Mock Exam - A to Z SQL Programming 00:20:00 Final Exam Final Exam - A to Z SQL Programming 00:20:00

A to Z SQL Programming
Delivered Online On Demand21 hours 30 minutes
£9.99

Bridging the Gap: Traditional to Agile Project Management

By IIL Europe Ltd

Bridging the Gap: Traditional to Agile Project Management Learn how a large cloud-computing enterprise used Flawless ExecutionSM, a remarkably scalable agile business framework, across diverse business teams including their Marketing Team, Legal Team, C-Suite and even the Sales Group functional teams that are notorious for avoiding agile methodologies. As part of a major merger, the company sought to unite two sales teams that were not strategically aligned and didn't have a customer-focused mindset. Just as agile methodologies help developers keep the customer at the forefront of the conversation, this sales organization used the agile techniques and practices of Flawless ExecutionSM, to align around the customer's needs, scale best practices, and shift the culture to a more customer-centric mindset. Result: after an abysmal first half in 2016, the team rallied together after implementing Flawless Execution as their process of record over the summer and beat their sales forecast by 17% in Q4. This had an impact on morale for the 22,000-person company and even increased the stock price by 10%. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies.

Bridging the Gap: Traditional to Agile Project Management
Delivered Online On Demand15 minutes
£10

Java Programming Level 2

5.0(1)

By LearnDrive UK

Advance your Java skills with our Level 2 course. From mastering collections and file handling to understanding multi-threading and lambda expressions, this course culminates in building a User Authentication system, solidifying your Java expertise for real-world applications.

Java Programming Level 2
Delivered Online On Demand1 hour
£5

Python Django Training

4.7(160)

By Janets

Elevate your web development skills with our Python Django Training. Master the Django framework and unleash the power of Python for building robust, scalable, and feature-rich web applications. Join our comprehensive training program to gain hands-on experience, expert guidance, and propel your career in the world of web development. Start your journey today!

Python Django Training
Delivered Online On Demand11 hours
£9.99

Unlock Your Potential: SAA-C03 Questions Answers with AmazonAWSdumps

By Amazonawsdumps

Are you ready to take your career to new heights in the realm of cloud computing? The AWS Certified Solutions Architect - Associate (SAA-C03) certification is your gateway to success, and AmazonAWSdumps is here to guide you every step of the way. In this article, we'll delve into the intricacies of the SAA-C03 certification and explore how AmazonAWSdumps can help you achieve your goals. Understanding the SAA-C03 Certification The AWS Certified Solutions Architect - Associate (SAA-C03) certification is designed for individuals who possess the skills and knowledge necessary to design distributed systems on AWS. This certification validates your ability to architect and deploy secure and robust applications on the AWS platform, making you a valuable asset to any organization leveraging cloud technology. Exam Format Exam Type: Multiple choice and multiple response Number of Questions: Approximately 65 Duration: 130 minutes Passing Score: 720 out of 1000 Exam Domains Domain 1: Design Resilient Architectures Domain 2: Design High-Performing Architectures Domain 3: Design Secure Applications and Architectures Domain 4: Design Cost-Optimized Architectures Domain 5: Define Operationally Excellent Architectures Why Choose AmazonAWSdumps for Your SAA-C03 Preparation? Comprehensive Study Material Our SAA-C03 Dumps Is meticulously curated to cover all the essential topics and concepts tested on the exam. From architectural design principles to AWS services and best practices, our materials provide a comprehensive overview of everything you need to know to succeed. Expert Guidance and Support At AmazonAWSdumps, we understand that embarking on your certification journey can be daunting. That's why our team of experienced professionals is here to provide you with expert guidance and support every step of the way. Whether you have questions about specific concepts or need advice on study strategies, we're here to help. Realistic Practice Exams Practice makes perfect, and our realistic SAA-C03 practice Test designed to simulate the actual exam environment. Test your knowledge and skills under timed conditions, identify areas for improvement, and gain the confidence you need to ace the exam on your first attempt. Flexible Learning Options We understand that everyone has unique learning preferences and schedules. That's why we offer a variety of flexible learning options to suit your individual needs. Whether you prefer self-paced study with our comprehensive SAA-C03 study guide or interactive learning experiences with our test engine, we have the resources you need to succeed. Your Path to Success Starts Here: With AmazonAWSdumps as your trusted partner, you have everything you need to navigate the complexities of the SAA-C03 certification with confidence. Don't let this opportunity pass you by – unlock your potential and elevate your career in cloud computing today. Join the ranks of certified AWS professionals and embark on a journey of endless possibilities with AmazonAWSdumps by your side. FAQs About the SAA-C03 Exam: Q: Who should take the SAA-C03 exam? A: The SAA-C03 exam is ideal for individuals who have experience designing distributed systems on the AWS platform and wish to validate their skills as an AWS Solutions Architect. Q: What is the recommended experience level for the SAA-C03 exam? A: While there are no strict prerequisites, it is recommended that candidates have at least one year of hands-on experience designing available, cost-efficient, fault-tolerant, and scalable distributed systems on AWS. Start Your Journey with AmazonAWSdumps Today Don't let exam preparation hold you back from reaching your career goals. With AmazonAWSdumps as your trusted partner, you'll have everything you need to excel on your Amazon certification exams and take your career to new heights in cloud computing. Explore our extensive collection of exam dumps and study materials today and embark on your certification journey with confidence!

Unlock Your Potential: SAA-C03 Questions Answers with AmazonAWSdumps
Delivered Online On Demand14 months
FREE

Educators matching "Scala"

Show all 11
Theatre Skills Academy

theatre skills academy

Orpington

"When I was 13 I relocated from Leeds to London to take up a full time scholarship place at the prestigious Sylvia Young Theatre School, I received some of the best training and opportunities a young girl could wish for. After finishing school I was fortunate enough to be chosen for another full time scholarship place at Millennium Dance 2000 College for 3 years performing arts training. Even with all this incredible training I still look back fondly at the small performing arts school I attended one night a week in Leeds : Scala Kids. I owe a lot of my skills to the training I received there and would look forward to going to my classes every week without the pressure of taking exams or doing competitions. I was made to feel like part of the "Scala" family and felt free to be creative and express my talents. This is how I want the Theatre Skills Academy to be- a place where kids can come to be creative, build confidence, feel equal, learn new skills, improve their talents, and have FUN. I look forward to welcoming you all into the TSA family." Sheney Delaney. All the teachers at TSA have vast experience as both a professional performer and teacher and have a lot of knowledge to offer the children. Every lesson will work on different theatrical skills, whether it be building confidence, improving co-ordination, developing facial expressions, or performance technique. The classes run during term times, with holiday courses on offer in all the main school breaks. Each term will finish with a presentation for family and friends to come and see how their budding little performers have developed. Members also have the option to join TSA Children's Agency with the opportunity to attend professional castings for shows, film, TV and radio.

Makris Music Society

makris music society

London

Alexander Polyanichko, an internationally renowned conductor and educator regularly leads conducting masterclasses in cooperation with organizations such as Peter the Great Music Academy, Royal Baltic Festival, Hermitage Theatre, and St. Petersburg Chamber Philharmonic. A graduate of the Leningrad State Conservatory and the former student and assistant of the eminent conductor and pedagogue Ilya Musin (whose students were Yuri Temirkanov, Semyon Bychkov, and Valery Gergiev, among others), maestro Polyanichko has been one of Musin’s biggest proponents, carrying the great tradition of the St. Petersburg school of conducting. Maestro Polyanichko’s artistry, knowledge, his genuine willingness to share his experiences, his sense of humour, as well as his friendly and respectful manner of communication create a free exchange of ideas and a spirit of collaboration, while he and his students search for ways to resolve emerging issues related to the mastery of conducting, in a comfortable and productive masterclass atmosphere. Masterclasses traditionally consist of two parts: First Part, where the music conducted is being accompanied by two experienced pianists; and the Second Part where the students have the opportunity to work with a professional symphony orchestra. The dress rehearsal preceding the concert is where the conductors have a full assestment of their skills, as well as the final public concert (professionally recorded) as the culmination of the masterclass. During his twenty or so years of teaching at masterclasses, aestro MAlexander Polyanichko has worked with conductors from countries around the world including Argentina, Australia, Austria, Belgium, Brazil, Canada, Chile, China, Czech Republic, Denmark, Egypt, France, Germany, Italy, Japan, Mexico, New Zealand, Oman, Singapore, South Korea, Spain, Sweden, Switzerland, Serbia, Turkey, United Kingdom and the United States of America. His students have consistently expressed their appreciation on his pedagogical skills and the masterclasses, and have gone to conduct many successful performances of their own in their respective countries and beyond. Formerly a violinist in the Leningrad (St. Petersburg) Philharmonic Orchestra under Evgeny Mravinsky, Alexander Polianichko studied conducting at the St. Petersburg Conservatoire with Prof. Iliya Musin. In December 1988, he was awarded first prize in the Sixth All-Union Conducting Competition. In February 1989, he was invited by Maestro V. Gergiev to join to the Mariinsky (Kirov) Theatre as a House Conductor. Alexander toured with the Company throughout Europe, Asia, and the United States. In 1994, Polianichko made his London debut conducting English National Opera’s production of Eugene Onegin. This led to him conducting two productions of Tchaikovsky’s operas with the Royal Opera Covent Garden: a revival of The Queen of Spades with Placido Domingo, and a new production of The Tsarina’s Slippers by Francesca Zambello of Cherevichki. As a guest conductor, Polianichko has appeared at many renowned opera houses, including the Bolshoi Theatre in Moscow, Royal Opera House, La Scala, Deutsche Oper, San Francisco Opera, Australian Opera, English National Opera, Welsh National Opera, Danish Royal Opera, Stuttgart Oper, Colorado Opera, Lyric Opera of Kansas City, Norwegian Royal Opera, and Swedish Royal Opera. In 1996, he was invited to take the Opéra National de Paris to New York for their appearances at the Met. The symphonic orchestras he has conducted around the world include the Saint Petersburg Philharmonic Symphony Orchestra, Russian National Orchestra, Chicago Symphony Orchestra, London Philharmonic Orchestra, BBC Scottish Symphony Orchestra, BBC National Orchestra of Wales, Royal Scottish National Orchestra, City of Birmingham Symphony, Hallé Orchestra, Bergen Philharmonic Orchestra, Danish National Radio Orchestra, English and Irish Chamber Orchestras - among many others. From 1986 to 1989, Polianichko was the Principal Conductor and Artistic Director of the Belorussian State Chamber Orchestra in Minsk. He also taught conducting in Belorussian and Leningrad State Conservatoires. From 1996 to 1999, he was the Principal Conductor of the Bournemouth Sinfonietta. From 2012 to 2015, he was the Artistic Director and Principal Conductor of the Rostov Academic Symphony Orchestra. He also served as the professor of the conducting department of the Rostov State Conservatoire. He was awarded the Honoured Artist of Russia title in 2009. Polianichko appears at many prestigious music festivals in Russia and abroad, including Edinburgh, Aldeburgh and Savonlinna, Golden Mask, White Nights and Chaliapin Opera Festivals, and had the privilege to work with many world-famous artists and singers, such as Anna Netrebko, Anne Sofie von Otter, Elena Obraztsova, Dawn Upshaw, Olga Borodina, Makvala Kasrashvili, Larissa Diadkova, Irina Bogacheva, as well as Placido Domingo, Jonas Kaufmann, Vladimir Galuzin, Ildar Abdrazakov, Sir Thomas Allen, Pata Burchuladze, Sergey Leiferkus, John Tomlinson and many others. He participated as the Jury member at the Rimsky-Korsakov Opera Singers’ Competition (1996), the BBC Cardiff Singer of the World competition (2011), and the Makris International Conducting Competition (2019). His featured recordings on DVD include Romeo & Juliet with Royal Sweden Ballet (2013); Cherevichki/Tsarina’s Slippers with Royal Opera House Covent Garden (2009); Beyond the Score with the Chicago Symphony Orchestra (2008); as well as television recordings and live radio broadcasts worldwide. His is featured on various CD/audio recordings on the label Melodia in Russia. Since 2005, Polianichko gave orchestral masterclasses for the Swedish National Orchestra Academy, Symphony Orchestra of the Royal College of Music, London, Chamber Orchestra of the Cambridge University, and Britten-Pears Youth Orchestra. Since 2002, he has been holding annual conducting masterclasses in St. Petersburg organized by Peter the Great Music Academy, the Royal Baltic festival, and the Theatre of Hermitage Museum, to which students come from all over the world.

Nexus Human

nexus human

London

Nexus Human, established over 20 years ago, stands as a pillar of excellence in the realm of IT and Business Skills Training and education in Ireland and the UK.  For over two decades, Nexus Human has been a steadfast source of reliable and high-quality training solutions, catering to a diverse range of professional and educational needs. With a strong reputation in the Training Industry, Nexus Human has consistently demonstrated its commitment to equipping individuals and organisations with the skills and knowledge required to thrive in today's dynamic world.  Our training programs span a wide spectrum, encompassing IT certifications, business skills, and much more.   What sets Nexus Human apart is our unwavering dedication to staying at the forefront of industry trends and technology advancements.  Our expert instructors, coupled with cutting-edge training resources, ensure that students receive the most up-to-date and relevant knowledge available. The impact of Nexus Human extends far and wide, helping individuals enhance their career prospects and aiding businesses in achieving their goals.  This 20-year journey has solidified our institution's standing as a trusted partner in personal and professional growth, offering reliable, excellent training that continues to shape the future.  Whether you seek to upskill, reskill, or simply stay ahead of the curve, Nexus Human is the place to turn for an educational experience marked by quality, reliability, and innovation.