# Event Details - **Event Name**: MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led - **Event Start and End Date**: Thu, 02 Aug, 2018 at 11:00 am – Thu, 31 Dec, 2026 at 05:00 pm (+01:00) - **Event Description**: This SQL for advanced SQL topics is online instrcutor-led, Have a fun and very useful day with us.About this EventMS SQL Server Advanced CourseCourse summarySQL Sub-queries ·Sub-queries in the WHERE, SELECT, From or Having clauses ·Using SOME, ALL, ANY and IN clauses in the Where Clause ·Self-contained sub-queries ·Correlated sub-queries ·Sub-queries with the EXISTS predicateDerived Tables and CTEs ·Using SQL derived tables ·SQL Common Table Expressions (CTEs) ·Recursive CTEs Create, alter and drop Views, IndexesSQL Stored Procedure Basics ·Stored Procedure Principles ·Creating stored procedures ·Executing stored procedures ·System stored procedures Variables ·Declaring variables ·SET versus SELECT Parameters and Return Values ·Passing parameters ·Default values and WHERE clauses ·Output parameters ·Using RETURN Testing Conditions ·The IF/ELSE statement ·CASE ·CHOOSE Looping ·Syntax of SQL WHILE ·Breaking out of a loop ·Basic transactions ·Beginning a transaction ·Committing/rolling back ·Deleting and updating ·Using DELETE and UPDATE ·Sys.Objects ·Dropping objects User defined Functions Table Valued Functions ·In-line table-valued functions ·Multi- Statement table-valued functions ·Limitations of user-defined functions Scalar Functions ·What are scalar functions? ·Some examples ·Disadvantages of scalar functions ·Three advantages Cursors ·Syntax of fetching rows ·When to use (and when not to) Triggers Create or replace triggers Creating Tables in SQL ·Create, alter and drop Tables ·Inserting values, single rows and multiple rows using queries Constraints: Not Null Unique Default Check Primary Key Foreign Key Identity / Auto-increments Sequencing Indexes SQL Temporary Tables and Table Variables ·Create and use SQL temporary tables ·Create and use SQL table variables ·SQL Tables vs. Table Variables Error-Handling ·SQL TRY/CATCH ·SQL System error functions ·Customizing SQL error messages ·@@ error function Debugging ·The SQL Server debugger, Debugging (breakpoints, etc.) https://cdn-az.allevents.in/events1/banners/fef6b210-1f49-11f1-8ce5-afcd59d33ab9-rimg-w904-h740-dcfdfdfd-gmir.jpg https://cdn-az.allevents.in/events4/banners/ff6663d0-1f49-11f1-a80c-71aa7eb81ff0-rimg-w740-h740-dc000000-gmir.png https://cdn-az.allevents.in/events7/banners/ffb239e0-1f49-11f1-a80c-71aa7eb81ff0-rimg-w740-h740-dc0f75bd-gmir.jpg - **Event URL**: https://allevents.in/milton-keynes/ms-sql-course-advanced-2-day-course-online-instructor-led/1000048063067930 - **Event Categories**: workshops, virtual - **Interested Audience**: - total_interested_count: 0 - **Event Highlights**: - Duration: 6 hours - Location: London Trafalgar Square - Languages: English ## Ticket Details - **Ticket Price Range**: min: 647.39, max: 1294.19, currency: GBP ## Event venue details - **city**: Milton Keynes - **state**: EN - **country**: United Kingdom - **location**: London Trafalgar Square - **lat**: 52.0391848 - **long**: -0.7610688999999999 - **full address**: London Trafalgar Square, Golden Cross House, Milton Keynes, United Kingdom ## Event gallery - **Alt text**: MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led - **Image URL**: https://cdn-az.allevents.in/events8/banners/b2fa55adad8d45a80c2bc2b66b0ca07dea1c5c75e442a2b77cc9fd4c92b4d12f-rimg-w1200-h675-dc167ec8-gmir.jpg?v=1773453813 ## FAQs - **Q**: When and where is MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led being held? - **A:** MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led takes place on Thu, 02 Aug, 2018 at 11:00 am to Thu, 31 Dec, 2026 at 05:00 pm at London Trafalgar Square, Golden Cross House, Milton Keynes, United Kingdom. - **Q**: How much do tickets cost for MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led? - **A:** Ticket prices for MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led range from GBP 647 to GBP 1,294 depending on the ticket type. Here's a full breakdown of available ticket types:Ticket TypePriceAvailabilityMS SQL Server Advanced OnlineGBP 647 + GBP 47 feeAvailableMS SQL Server Advanced CLASSROOMGBP 1,294 + GBP 94 feeAvailable2 for 1 EntryGBP 647 + GBP 47 feeAvailable - **Q**: Who is organizing MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led? - **A:** MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led is organized by PCWorkshops. - **Q**: Who is this event for? Is it right for me? - **A:** MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led is ideal for curious learners, students, and skill-builders looking to gain hands-on knowledge and practical expertise in a focused, interactive setting. Whether you're a first-time attendee or a longtime enthusiast in Milton Keynes, this event is thoughtfully curated to deliver a standout experience worth every moment. If MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led sounds like your kind of event, don't wait - spots fill up fast. ## Structured Data (JSON-LD) ```json [ { "@context": "https://schema.org", "@type": "Event", "name": "MS SQL Course, Advanced, 2-Day Course, Online Instructor-Led", "image": "https://cdn-az.allevents.in/events8/banners/b2fa55adad8d45a80c2bc2b66b0ca07dea1c5c75e442a2b77cc9fd4c92b4d12f-rimg-w1200-h675-dc167ec8-gmir.jpg?v=1773453813", "startDate": "2018-08-02T11:00:00+01:00", "endDate": "2026-12-31T17:00:00+01:00", "url": "https://allevents.in/milton-keynes/ms-sql-course-advanced-2-day-course-online-instructor-led/1000048063067930", "eventStatus": "https://schema.org/EventScheduled", "location": { "@type": "Place", "name": "London Trafalgar Square", "address": { "@type": "PostalAddress", "streetAddress": "Golden Cross House", "postalCode": "WC2N 4JF", "addressLocality": "Milton Keynes", "addressRegion": "EN", "addressCountry": "GB" }, "geo": { "@type": "GeoCoordinates", "latitude": "52.0391848", "longitude": "-0.7610688999999999" } }, "eventAttendanceMode": "https://schema.org/OfflineEventAttendanceMode", "description": "This SQL for advanced SQL topics is online instrcutor-led, Have a fun and very useful day with us.", "offers": [ { "@type": "AggregateOffer", "availability": "https://schema.org/InStock", "priceCurrency": "GBP", "availabilityStarts": "2026-03-14", "availabilityEnds": "2026-12-31T17:00:00+01:00", "validFrom": "2026-03-14", "lowPrice": "647.39", "highPrice": "1294.19", "price": "647.39", "url": "https://allevents.in/milton-keynes/ms-sql-course-advanced-2-day-course-online-instructor-led/1000048063067930" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "GBP", "availabilityStarts": "2026-03-14", "availabilityEnds": "", "validFrom": "2026-03-14", "url": "https://allevents.in/milton-keynes/ms-sql-course-advanced-2-day-course-online-instructor-led/1000048063067930", "price": "647.39", "name": "MS SQL Server Advanced Online" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "GBP", "availabilityStarts": "2026-03-14", "availabilityEnds": "", "validFrom": "2026-03-14", "url": "https://allevents.in/milton-keynes/ms-sql-course-advanced-2-day-course-online-instructor-led/1000048063067930", "price": "1294.19", "name": "MS SQL Server Advanced CLASSROOM" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "GBP", "availabilityStarts": "2026-03-14", "availabilityEnds": "", "validFrom": "2026-03-14", "url": "https://allevents.in/milton-keynes/ms-sql-course-advanced-2-day-course-online-instructor-led/1000048063067930", "price": "647.39", "name": "2 for 1 Entry" } ], "organizer": [ { "@type": "Organization", "name": "PCWorkshops", "url": "https://allevents.in/org/pcworkshops/22620392", "description": "At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.More about us:training@pcworkshopslondon.co.ukOur classes are instructor led, in our Live Virtual ClassroomCourses well developed by registered, qualified instructors with a wealth of experience in software development and training.The maximum groups size that can access our Virtual Classroom, is 4.Every one gets personalised attention.Why learn with us at PCWorkshops:Excellent, up-to-date courses, following latest trends and technologies.Excellent trainers with professional experience.Award Winning Trainer21 Years In BusinessExcellent Client ReferencesPCWorkshops CertificateWeekdays, Evenings and WeekendsAt PCWorkshops, we love out job!We offer Training Courses in Software Packages:Java ProgrammingPython Programming, Python data analytics, Python Machine LearningDatabase design and Data NormalisationSQL CoursesData Analysis andMS Excel, data analyses with Excel. Excel VBAAccess Database Courses.MS Project TrainingMS Office TrainingOur Style:Relaxed, Practical, UsefulMethods of instruction:Classroom training with max class-size 4 peopleVirtual classrooms via online video links1-1 mentoringCustomised trainingCertification:Our PCWorkshops certificates are assessment based.Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.Our clients are:Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualificationCustomisation:We can tailor all our courses. Email to customise location, times, content." } ] } ] ```