Offer Type
Offered
Event Type
Consumer Goods
MS SQL Server Advanced Course
Course summarySQL Sub-queries
Derived Tables and CTEs
Views
Indexes
Sequencing
SQL Stored Procedure
Variables
Parameters and Return Values
Looping
User defined Functions
Table Valued Functions
Scalar Functions
Cursors
Triggers
SQL Stored Procedure
Variables
Parameters and Return Values
Looping
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.)
Venue:
PCWorkshops at Regus, Near Trafalgar Square
Golden Cross House 8 Duncannon Street London, WC2N 4JF
Dates