MS SQL Server Advanced Course, 2-Day , Live Online Classroom

MS SQL Server Advanced Course, 2-Day , Live Online Classroom

Actions and Detail Panel

£600

Advanced SQL Course. More about DML, DDL Queries and automation. Instructor-led. Practical. Online.

About this event

SQL Advanced Course

Duration: 2 consecutive days, the first thereof showing as the booking date

Pre-requisite: Basic understanding of SQL queries.

Location: Online, booking link emailed upon booking.

This SQL Advanced course is excellent for delegates who work daily on SQL. Read more

SQL Advanced Course details

Revising MS SQL Server query basics, joins, aggregates, string and date functions

SQL Sub-queries

  • Derived Tables and CTEs

Views, Indexes, Sequencing

SQL Stored Procedure 

  • Variables
  • Parameters and Return Values
  • Looping

Functions

  • User defined Functions
  • Table Valued Functions
  • Scalar Functions
  • Cursors
  • Triggers

Creating Tables in SQL

Constraints:

  • Not Null
  • Unique
  • Default
  • Check
  • Primary Key
  • Foreign Key
  • Identity / Auto-increments

SQL Temporary Tables and 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.)

System requirements: Your SQL Database, query interface and sample data must be ready before the course starts.

Read more: https://pcworkshopslondon.co.uk/sql-advanced-course.html

Share with friends

Save This Event

Event Saved