MS SQL Server Advanced Course, 2-Day , Live Online Classroom
Date and time
Location
Online event
Refund policy
No Refunds
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