Call us: 02045797300
Email us: info@trainingdeals.co.uk
For all your training needs.
Lines are open 24 Hours, Monday to Sunday
Advanced SQL
- Our Advanced SQL training courses help you master this programming language
- SQL developers are highly respected for their skills and knowledge and can command high salaries
- Enrol today for expert SQL tuition from trusted SQL trainers in
- Introduction level also available
Sorry, we do not have any courses matching your criteria
FAQs
What time shall I arrive at the venue?
Please arrive at the venue for 08:45am
What are the pre-requisites?
Some previous programming or database experience would be useful
Overview
Course Content
Stored Procedure Basics
Pros and cons of stored procedures
Creating stored procedures
Three ways to execute
System stored procedures
Variables
Declaring variables
SET versus SELECT
Tricks with variables and rowsets
So-called global variables
Parameters and Return Values
Passing parameters
Default values and WHERE clauses
Output parameters
Using RETURN
Avoiding Scalar Functions
What are scalar functions?
Some examples
Disadvantages of scalar functions
Three alternatives
Testing Conditions
IF / ELSE statement
Using CASE where possible
Looping
Syntax of 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
Creating Tables
Creating tables in SQL
Inserting data
Inserting single rows
Inserting multiple rows
Temporary Tables and Table Variables
Using temporary tables
Creating table variables
Pros and cons of each approach
Table Valued Functions
In-line table-valued functions
Mult-statement table-valued functions
Limitations of user-defined functions
Derived Tables and CTEs
Using dervied tables
Common Table Expressions (CTEs)
Recursive CTEs
Subqueries
The concept of a subquery
Using ALL, ANY and IN
Correlated subqueries
Using EXISTS
Cursors
Syntax of fetching rows
When to use (and when not to)
Error-Handling
Using TRY / CATCH
System error functions
Custom error messages
The obsolete @@error function
Debugging
Version differences
The Visual Studio debugger
The SQL Server debugger
Debugging (breakpoints, etc.)
What's Included
- Courseware Book
- Manual
- Certificate
- Experienced Instructor
- Refreshments
Testimonials
There hasn't been any testimonials submitted to this course
Video
We do not currently have a video for this course