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

17366 Addition courses

🔥 Limited Time Offer 🔥

Get a 10% discount on your first order when you use this promo code at checkout: MAY24BAN3X

Writing for the Business Professional

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Professionals desiring to be able to communicate clearly and concisely in their writing will benefit from this course. Overview Awareness of common spelling and grammar issues in business writing. Basic concepts in sentence and paragraph construction. Basic structure of agendas, email messages, business letters, business proposals, and business reports. Collaborative writing techniques, tools and best practices Tips and techniques to use when deciding the most appropriate format to use for agendas, email messages, business letters, business proposals, and business reports In this course, you will learn the essential skills needed to organize your thoughts and select the best words and phrases to clearly convey them in writing. Private classes on this topic are available. We can address your organization?s issues, time constraints, and save you money, too. Contact us to find out how. 1. WORKING WITH WORDS * Monitoring Spelling, Grammar, and Verb Tense * Creating a Reference Sheet 2. CONSTRUCTING SENTENCES * Recognizing Sentence Parts * Classifying Sentence Type * Increasing Readability with Punctuation 3. CREATING PARAGRAPHS * The Three Basic Components * Organization Methods 4. FINDING FACTS * Identifying and Using Key Resources * Fact-Finding and Information Gathering 5. COLLABORATIVE WRITING * Clarifying the Objective * Collaborative Writing Strategies and Patterns 6. TYPES OF COLLABORATIVE BUSINESS WRITING * Applying Different Construction Techniques * Cut & Paste, Puzzle, Sequential Summative * Integrating Construction 7. COLLABORATIVE TOOLS AND PROCESSES * Planning and Revision * Creating Outlines and Storyboards * Building Team Cohesion 8. WRITING MEETING AGENDAS * Choosing an Agenda Format * Structuring and Writing the Agenda 9. WRITING E-MAILS, REPORTS AND PROPOSALS * Addressing Your Message * Using Proper Grammar and Defining Acronyms * Structuring, Formatting, and Writing Your Report ADDITIONAL COURSE DETAILS: Nexus Humans Writing for the Business Professional 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 Writing for the Business Professional 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.

Writing for the Business Professional
Delivered Online3 days, May 22nd, 13:00
£1500

Presentation Skills

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This course is designed for individuals who need to present information effectively in a professional environment. Overview This program can benefit anyone who presents; a trainer, a meeting facilitator, speaker, or seminar discussion leader. No matter which role you are assuming, this workshop will help you become more efficient and proficient with the skills of providing information to others. In this course, students will learn active listening skills to facilitate the exchange of ideas in meetings and presentations. They will also organize your ideas to create coherent and convincing oral presentations. GETTING STARTED * Icebreaker * Housekeeping Items * The Parking Lot * Workshop Objectives CREATING THE PROGRAM * Performing a Needs Analysis * Writing the Basic Outline * Researching, Writing, and Editing CHOOSING YOUR DELIVERY METHODS * Basic Methods * Advanced Methods * Basic Criteria to Consider VERBAL COMMUNICATION SKILLS * Listening and Hearing: They Aren?t the Same Thing * Asking Questions * Communicating with Power NON-VERBAL COMMUNICATION SKILLS * Body Language * It?s Not What You Say, it?s How You Say It OVERCOMING NERVOUSNESS * Preparing Mentally * Physical Relaxation Techniques * Appearing Confident in Front of the Crowd CREATING FANTASTIC FLIP CHARTS * Required Tools * The Advantages of Pre-Writing * Using Colors Appropriately * Creating a Plan B CREATING COMPELLING POWERPOINT PRESENTATIONS * Required Tools * Tips and Tricks * Creating a Plan B WOW 'EM WITH THE WHITEBOARD * Traditional and Electronic Whiteboards * Using Colors Appropriately * Creating a Plan B VIBRANT VIDEOS AND AMAZING AUDIO * Required Tools * Tips and Tricks * Creating a Plan B PUMPING IT UP A NOTCH * Make Them Laugh a Little * Encourage Discussion * Dealing with Questions WRAPPING UP * Words from the Wise * Review of Parking Lot * Lessons Learned * Completion of Action Plans and Evaluations ADDITIONAL COURSE DETAILS: Nexus Humans Presentation Skills 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 Presentation Skills 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.

Presentation Skills
Delivered OnlineTwo days, May 22nd, 13:00 + 2 more
£395

Make your own handmade paper

5.0(37)

By Stitching Kitchen

Learn to make your very own recycled paper

Make your own handmade paper
Delivered In-Person in Brackley2 hours 30 minutes, May 22nd, 11:30
£40

Screen Acting Weekly with Showreel

By Actors Studio

With Actress, Acting and Audition Coach Sarah Hannah -------------------------------------------------------------------------------- INTRODUCTION Join our internationally recognised Screen Acting Weekly Course and develop your technical performance skills and character understanding over 5 Weekly Evening Sessions before applying your new skills on a professional set at Pinewood Studios as you participate in filming two showreel scenes. Over weekly sessions, the Director will use practical techniques to build your confidence in performance and help you master the technical requirements to be a successful screen actor. You will focus on the importance of character preparations, how to portray emotion, comedy and drama on camera in addition to career advice before shooting a professional acting showreel. Upon completion of the Screen Acting Weekly course, you will emerge with a heightened sense of assurance and confidence in your screen acting abilities and the tools to progress with your acting career, whether you’re new to the industry or a Drama School Graduate looking for more acting opportunities in TV & Film. MEET YOUR TUTOR Sarah Hannah Acting Coach https://www.imdb.com/name/nm0161404/ Sarah Hannah is a highly experienced Professional Actress, Acting and Audition Coach. Bringing her extensive experience of working on stage and on screen, Sarah will focus on enhancing your presence on camera and cover the technical skills required of a professional screen actor. -------------------------------------------------------------------------------- Course Outline The course led by Acting Coach Sarah Hannah is held at The Audition House, Central London, and the first 5 weekly sessions run for 3 hours (6-9pm). There are 3 additional showreel filming sessions at Pinewood Studios. You will be required for 2 out of the 3 filming sessions.  We film during the day and you will be given a specific filming time and will not be required all day.   As this course is inclusive of all levels of ability, it offers a comprehensive overview of screen acting skills, starting from the basics and progressing to more advanced concepts. It will include resources, material and instructional stratergies that cater to beginners while also offering challenges for those with more advanced skills. -------------------------------------------------------------------------------- BOOKING OPTIONS Select a course date and add to cart to proceed with payment. This course has limited availability and spaces are first come first served. Please read our Terms and Conditions before proceeding with your booking. £750.00 Weds 24th April-Thurs 30th May 2024 Lesson 1: Wednesday 24th April 2024 – 6-9pm Central London Lesson 2: Wednesday 1st May 2024 – 6-9pm Central London Lesson 3: Wednesday 8th May 2024– 6-9pm Central London Lesson 4: Wednesday 15th May 2024 – 6-9pm Central London Lesson 5: Wednesday 22nd May 2024 – 6-9pm Central London Filming Sessions: Tuesday 28th, Wednesday 29th and Thursday 30th May 2024 at Pinewood Studios. You are required for 2 of the 3 filming sessions. Weds 18th Sept-Thurs 24th Oct 2024 Lesson 1: Wednesday 18th September 2024 – 6-9pm Central London Lesson 2: Wednesday 25th September 2024 – 6-9pm Central London Lesson 3: Wednesday 2nd October 2024– 6-9pm Central London Lesson 4: Wednesday 9th October 2024 – 6-9pm Central London Lesson 5: Wednesday 16th October 2024 – 6-9pm Central London Filming Sessions: Tuesday 22nd, Wednesday 23rd and Thursday 24th October 2024 at Pinewood Studios. You are required for 2 of the 3 filming sessions. -------------------------------------------------------------------------------- ADDITIONAL INFORMATION FEATURES Practical acting training for screenShoot two scenes for your professional acting showreel with our Award Winning CrewSuitable if you are (17 yrs+) and committed to improving your screen acting skillsAttracts a varied age range from 17 yrs+. International Students WelcomeThe course is taught in English, so it is important that you have proficient English language skillsSmall Class Size LEARNING OUTCOMES Learn techniques to effectively analyse a Film/TV ScriptCreate truthful and inspirational charactersBuild confidence performing in-front of cameraUnderstanding the workflow of a busy film setAudition preparationCareer advice and direction – how to market yourself COURSE LOCATION Training Sessions (1-5)   6pm – 9pm The Audition House, 129A Whitfield Street, Fitzrovia, London, W1T 5EQThe Audition House is a two minute walk from Warren Street tube and 5 minutes from Euston Station Filming Sessions (6-8) Between 8am and 4pm Actors Studio, Pinewood Studios, Pinewood Road, Iver Heath, Buckinghamshire, SL0 0NH Free Parking available at Pinewood StudiosFree frequent shuttle bus service from London Uxbridge Tube Station, Slough and Gerrards Cross. Transfer from station to Pinewood Studios – 10 minutesCanteen and Coffee shops on siteExcellent transport links from London

Screen Acting Weekly with Showreel
Delivered in London or Online3 hours, May 22nd, 17:00 + 11 more
£750

Python Programming Beginners Evenings Course, Webinar, Virtual Classroom.

By Pcw Courses Ltd

Python coding, interactive, instructor-led, hands-on, practical. From basics to working with professionals. Python Part Time. Python Coding. -------------------------------------------------------------------------------- Python Beginners Evenings Course COURSE SUMMARY This Python Programming course has become essential to all professional who would like to do code using Python. Learn evenings, work while studying. Work and study Python Part Time. It is a Python beginners course and teaches Python coding from scratch to intermediate. Hands-on, practical. We code some real life examples in this course. Duration: 3 Evenings, once per week for 3 weeks 6pm-8pm, of which the first date only shows on the booking. Virtual Classroom: You could attend in our classroom, or attend online via virtual classroom, by select the appropriate ticket. Who Should Attend? This course is intended for beginner programmers who need to code in Python. Fast-paced, Quite intensive. Course Outline: Session 1: Basics * Python Data Types, Variables, * Operators and Expressions: Arithmetic operators; Relational operators; Assignment operator; Logical operators. * Decision Making: If statement; If - else statement; If- elif - else statement; Nested if - else; * Using Loops: The while, while-else; do-while and the for loop; Enhanced for loop; Jump statements: break, continue; Nesting loops. Session 2: Lists. Dictionaries, Json * Python Data Structures: Lists. Data Structures: 2-d Lists, Tuples. Dictionary, Nested Disctionary. Session 3: Built-in functions: * Python Date Functions. Random. Math Functions. String Functions. Python Regex. Session 4: Database: * Connect to a database, create Database, create a table, insert, delete, update records, query a database and display results. Drop database, drop table. Session 5: Files * Exception Handling in Python: Fundamentals of exception handling; Exception types; Using try and except. * Files, streams: Create, Open, Traverse and Read Files: Csv, txt and Json Files. * API: Connecting to API’s Session 6: M ethods, Classes and Objects * Creating and using Function, Working with parameters, Calling functions. * Object-Oriented Programming (OOP) principles. Modules and Classes, Creating an Object; Using an Object; Adding Instance variables; Controlling accessibility; Naming conventions for class member.s FAQ Do I need Python on my Laptop? Ideally spoken yes, but if not possible, you could use our online platform. Can I pay by BACS? Yes, simply email us, a Python course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com Can I pay with PayPal? Yes, simply email us, a course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com Do I get an invoice? Yes, on request. Can I pay with a PO (Purchase Order Number)? Yes, simply email us, a Python course consultant will contact you. training@pcworkshopslondon.co.uk or pcworkshopslondon@gmail.com Do I get a certificate? Yes, a PCWorkshops Certificate Can I attend in classroom? Yes, on request, and it would incur an additional charge, depending on your location. We have offices in London, Manchester, Birmingham, Portmouth, Southend-on-Sea, Milton Keynes. Can beginners follow this course? Yes, this is a Python beginner friendly course. We offer Python courses with max 4 people, so we make sure each delegates fully understand the material covered Can I customise the course? Yes, all our Python courses are customisable. We can customise the dates, times, location. course outline. -------------------------------------------------------------------------------- REFUND POLICY No Refunds

Python Programming Beginners Evenings Course, Webinar, Virtual Classroom.
Delivered Online & In-Person in London1 hour 30 minutes, May 22nd, 17:00 + 19 more
£120 to £210

Silk shading embroidery: Live Zoom class

By Ecole Saint Clare

Learn the art of silk shading from home

Silk shading embroidery: Live Zoom class
Delivered Online3 hours, May 22nd, 17:00
£209

Balkan Melody Mastery

5.0(2)

By North West London Music Lessons

MAGIC BALKAN MUSIC ACADEMY BALKAN MELODY MASTERY Learn great Balkan tunes and how to play them amazingly. When? Wednesday evenings, 19:00 – 20:30h GMT Where? Online on ZOOM, limited spaces in-person in Kenton, London HA3 This course will explore authentic Balkan tunes, emphasizing essential techniques for playing with precision and expression. The curriculum is taught via a mixture of by-ear learning and sheet music, allowing participants to delve into dynamic phrasing, articulation, ornamentation, tone, and speed. The course also offers exercises to enhance overall technique and flexibility. DETAILS Wednesday evenings, 19:00 – 20:30h GMT Start on the 17th January 2024. The course will run weekly throughout the year, expect school holidays. Booking either annually on a 6-weekly direct debit or by booking 5-lesson units (more info below) Location: Online on zoom – limited in-person spaces in London HA3 Participants: players of melodic instruments from intermediate to advanced. Fee: £60/£45 concessions for 1 Unit of 5 weeks (half a term).          Discounts when signing up until the end of the academic year   Booking Page: Click here to read details of payment and sign up for the course. Read below for extra events, extra discounts and all-inclusive fees. Watch Information Videos and including small demonstrations. -------------------------------------------------------------------------------- DETAILED INFORMATION The Balkan region is known for its rich and diverse musical heritage, which has been influenced by various cultures and traditions over the centuries. I am launching this new course to share the finer things about Balkan music. The correct notes can be played by any musician, but how often do I find myself in tears when listening to a great musician who gets it so wrong, simply because they did not have the opportunity to travel, listen, and learn from native masters? Instead, they might have learned it third-hand or from a piece of sheet music. Western classical music notation cannot fully capture the essence of other types of music, and a metronome can stifle the authentic phrasing of asymmetric Balkan rhythms. I am not a native Balkan music master either, but I feel very privileged that I had the opportunity to learn from several of them, and engage in endless, wild jam sessions. In this course, I aim to convey not only the right musical feel but also the fervour and passion for this music. The weekly course primarily targets melodic instruments. Tunes will be taught by ear, initially using the voice (sheet music will be sent out beforehand), and then practiced on the instrument. Special attention will be devoted to phrasing, articulation, and, of course, the typical charisma of Balkan music to give it that truly magical sound. Whilst I am a violinist and will demonstrate and lead with the violin and voice, the course is suitable for any melodic instrument. The level is aimed at intermediate to advanced players, although ambitious and diligent lower-intermediate players will also do well. We will briefly cover accompaniment aspects, including chord progressions, rhythm patterns, and techniques. Dedicated workshops for chordal instruments and percussion will be offered as we progress. The course will run weekly and continuously, with no regular sessions during usual UK school holidays. Booking will be in advance in 5-session units. Each unit can be booked individually, or you can sign up for an annual booking and pay in 6 instalments distributed over the whole year, receiving a 20% discount on the total course fee. For precise dates and a detailed payment plan please visit the BOOKING page. -------------------------------------------------------------------------------- INFORMATION VIDEOS about the general aims and philosophy of the course how to achieve expressive ornamentation how the accompaniments relate to the tunes -------------------------------------------------------------------------------- ADDITIONAL EVENTS Balkan Academy Jam Session: A music making session, 3 times a year (towards the end of each term), online and in person, where course participants and their friends can play the studied material with a full-on group, including rhythm section and vocals.  Fee: £9 for course participants, £12 for others - sheet music downloads included Dates to be announced.   Chord Progressions and Accompaniment Special: A special workshop three times a year for guitars, accordions, pianos, bass players, and similar instruments, both online and in person. This workshop delves into the details of chord progressions and accompaniment patterns, including riffs and breaks. It will be co-hosted by an experienced guitarist. Fee: £9 for course participants, £12 for others. Dates to be announced. Balkan Percussion Special: A workshop designed for percussionists to study the rhythm patterns and techniques related to the course material. This workshop will be co-hosted by an experienced Balkan percussionist. It is tailored to friends and bandmates of the Balkan Melody Mastery course participants, allowing the pieces to be performed together in your own groups and jam sessions.  Fee: £9 for course participants, £12 for others. Dates to be announced.

Balkan Melody Mastery
Delivered Online1 hour 30 minutes, May 22nd, 18:00 + 1 more
£45 to £65

London Yoga Teacher Training Course

By Catherine Annis Yoga

Intelligent Yoga Teacher Training (IYTT) is unique amongst teacher training courses. We offer an incisive, thoughtful and intelligent approach to yoga teacher training, driven by the most current scientific developments in anatomy and movement research. Delivered by an elite group of senior yoga teachers at the top of their field, IYTT offers a spacious, immersive modular structure which provides time and space for profound learning, integration and growth. Each of the teaching team draws on decades of practical experience of yoga, including particularly the work of Vanda Scaravelli and somatic, embodied practices.

London Yoga Teacher Training Course
Delivered Online & In-Person in London4 days, May 23rd, 08:15 + 2 more
£500 to £1500

Guitar Building Course 3 Days

5.0(45)

By Guitar Tech Courses

GUITAR BUILDING COURSE THE AIM The aim of this electric guitar building course is teach you how to assemble a Stratocaster, Telecaster or Jazzmaster style bolt-on-neck design electric guitar to a very high standard as well as gain understanding and knowledge in not only the assembly but also a good understanding of its inner workings and overall function. WHAT TO EXPECT In this electric guitar building course you’ll focus on making the most successful electric guitar of all time: the bolt-on-neck design. In almost any music store, these guitars outnumber others five-to-one. The course will cover Body & Neck assembly, Pickup Installation & Installation of all Electronics and the Professional Setting up of an Electric Guitar The course will commence daily at 09:30 with lectures & discussions on topics relating to each part of the guitar construction and then followed by the practical application of these topics under supervision, finishing at 17:30. The course and workshop located in Cross in Hand, East Sussex, designed for a maximum of 4 people per course enabling a very close learning experience. All Lutherie tools needed to complete the course are supplied. NO Experience necessary! UPON COMPLETION Upon completion of the build your own guitar course you will leave with a great Custom made Guitar! The end product will be a Custom Tele, Strat or Jazzmaster that You will have made and one that will give many standard models a run for their money in tone and feel. PERSONAL ATTENTION The course does have a set agenda but we often meander around topics and are happy to do so, most of us have had many different guitars and they nearly always have some curious tales and they are always good to discuss. BREAK DOWN OF GUITAR COURSE TOPICS BY DAY DAY 1 BODY & NECK Wood choice and body design play a large part in the tone of an electric guitar. If you were to play several solid body guitars unamplified you’ll notice distinct differences between various wood types. A solid body that sounds good acoustically generally will sound good amplified. We’ll discuss the different woods used to make electric guitars and the effect of different body styles on tone and sustain. Just as wood affects the body, when making a neck you have to pay attention to wood choice in order to have a good sounding guitar. The hardware that goes into making a great guitar also plays a large role, not only the quality in the parts but also their fitting. You will be instructed on how best to fit all the component parts with skill and accuracy enabling you to create a great custom made guitar.. Topics covered: Body & Neck styles Wood choices Neck joints Adjustable Truss Rods Fitting neck to body Scale lengths Tremolo Bridge placement (Incl Claw & Springs) Fretboard radius Machine head installation Preparing the Nut Slot Making & Cutting a Bone Nut (Requires working with the belt sander) All the hardware fitted to the guitar will be quality Japanese Gotoh vintage parts, these are particularly well made; tuners hold tune well and the Gotoh bridge is of very good quality, all of this goes together to make a great custom built guitar. DAY 2 ELECTRONICS & FRET DRESSING Once you’ve learnt why and how a great guitar goes together as well as practically applying the previous topics, you now learn to install the best pickups and wiring. For these custom built guitars we will be using Bare Knuckle Boot Camp pickups: very high quality pickups designed to suit our specifications of wood choice and body style. These pickups are hand wound in the UK and are widely regarded as the best pickups on the market today. Choose between Old Guard, True Grit or Brute Force. The key to having a great sounding electric is not just down to the Pickups but also the choice of components that go with it, often overlooked with most mass manufactured guitars, the guitar you make will have highest quality components and will subsequently sound great and work extremely well. Custom CTS Pots, Sprague Capacitor and a CRL (USA) switch as well as vintage cloth wiring all go together to make a very well appointed loaded scratchplate! Topics covered: Schematics Pickup installation Wiring volume & tone pots Wiring 5 way selector switch Wiring output jack Bridge and string grounding Fret Dressing both Theory & Practise DAY 3 FINAL ASSEMBLY The guitar will now be ready for final assembly. Today you will learn how to fully assemble and set up your electric guitar to a professional standard. The topics covered will be very useful for your regular maintenance of the guitar you have made as well as any others that you may have. Topics covered: Professional Setups Theory Fitting and filing the Bone Nut Pickguard placement Installing strap buttons Installing Decals (Personalised custom Decals) Final Setting and fitting the neck Stringing up String tree placement Bridge set up Action height adjustment and setting Pick up height Intonation CUSTOMISING YOUR GUITAR BUILD INCLUSIVE FROM £999 We are more than happy to work with you in order to get the custom build you want, so please contact us if you have a specific body colour scheme or neck choice, which Bare Knuckle pickups you want as well as hardware and we will try help achieve exactly that. If you’re unsure what works best, just get in touch and we will advise where we can. ALL CUSTOM OPTIONS ARE SUBJECT TO AVAILABILITY AND IT IS ALWAYS BEST TO HAVE A 1ST & 2ND CHOICE, THERE ARE SOME COLOURS/PARTS ETC THAT MAY INCUR ADDITIONAL COST. TWEED HARD CASES ARE AVAILABLE FOR AN ADDITIONAL £75, £90 FOR THE JAZZMASTER. (SOFT GIG BAG INCLUDED) SOME ADDITIONAL CHARGES CAN APPLY FOR CUSTOM COLOURS OR SPECS OR IF YOU WOULD LIKE SPECIFIC MADE TO ORDER BARE KNUCKLE PICKUPS

Guitar Building Course 3 Days
Delivered In-Person in Heathfield3 days, May 23rd, 08:00 + 1 more
£999

DP-080T00 Querying Data with Microsoft Transact-SQL

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - INTRODUCTION TO TRANSACT-SQL * Work with schemas * Explore the structure of SQL statements * Examine the SELECT statement * Work with data types * Handle NULLs 2 - SORT AND FILTER RESULTS IN T-SQL * Sort your results * Limit the sorted results * Page results * Remove duplicates * Filter data with predicates 3 - COMBINE MULTIPLE TABLES WITH JOINS IN T-SQL * Understand joins concepts and syntax * Use inner joins * Use outer joins * Use cross joins * Use self joins 4 - WRITE SUBQUERIES IN T-SQL * Understand subqueries * Use scalar or multi-valued subqueries * Use self-contained or correlated subqueries 5 - USE BUILT-IN FUNCTIONS AND GROUP BY IN TRANSACT-SQL * Categorize built-in functions * Use scalar functions * Use ranking and rowset functions * Use aggregate functions * Summarize data with GROUP BY * Filter groups with HAVING 6 - MODIFY DATA WITH T-SQL * Insert data * Generate automatic values * Update data * Delete data * Merge data based on multiple tables ADDITIONAL COURSE DETAILS: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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.

DP-080T00 Querying Data with Microsoft Transact-SQL
Delivered Online3 days, May 23rd, 08:30 + 7 more
£1190