Eventsize

MS SQL Server Advanced 2-Day Course, Birmingham Cover

MS SQL Server Advanced 2-Day Course, Birmingham

PCWorkshops Logo

PCWorkshops

0 フォロワー

日時

Thu, 29 五月 2025, 11:00 AM onwards

GMT +2.00

カレンダーに追加

会場の場所

One Victoria Square

B1 1BD, Birmingham, United Kingdom

地図を見る

このイベントについて

MS SQL Server Advanced Course Course summary SQL 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.)

地図を見る

One Victoria Square

B1 1BD, Birmingham, United Kingdom

イベント主催者

PCWorkshops Logo

PCWorkshops

0 フォロワー

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.We offer stress free training: we start at 11am, giving you time to attend to necessary tasks etc. before starting.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 Programming, Python Programming, Python data analytics, Python Machine Learning, Database design and Data Normalisation, SQL Courses, Data Analysis and MS Excel, data analyses with Excel, Excel VBA, Access Database Courses, MS Project Training, MS Office TrainingOur Style:Relaxed, Practical, UsefulMethods of instruction:Classroom training with max class-size 4 people, Instructor-led Virtual classrooms, 1-1 mentoring, Customised 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 who employ software developersCoders and new coders who need Accredited Java qualificationCustomisation:We can tailor all our courses. Email to customise location, times, content.Terms and Conditions:By booking a course with us, you agree to the terms and conditions specified on our website:https://pcworkshopslondon.co.uk/termsandconditions.html

United Kingdomの他の科学・技術イベント

Sewage Treatment Works tour - Leicestershire Cover

Sewage Treatment Works tour - Leicestershire

29 五月 @ Sysonby Grange Lane

SCI Project Showcase: Dr Enes Unal Cover

SCI Project Showcase: Dr Enes Unal

29 五月 @ Digital Humanities Seminar Room 1

Geography and a Geographer: A lecture in tribute to Ron Johnston

29 五月 @ School of Geographical Sciences, University of Bristol

Soil Myth Busting - Aberdeenshire Cover

Soil Myth Busting - Aberdeenshire

29 五月 @ Thainstone Centre

国を選択

イベントチケットを販売開始

イベントを企画していますか？支払い回収、自動リマインダー送信、チェックインの自動化が可能です。以下より登録してください：

クイックナビゲーション

Eventsizeは、世界中のイベント検索とオンラインチケット販売プラットフォームです。都市のイベントを簡単に見つけ、自分のイベントのチケットを販売するためのすべてのツールが揃っています。

© 2025 Eventsize. 無断転載を禁ず.