SQL Training | SQL Exam
Course
In Cardiff
Description
-
Type
Course
-
Location
Cardiff (Wales)
-
Duration
2 Days
-
Start date
Different dates available
The Knowledge Academy Courseware Book Manual Certificate Experienced Instructor Refreshments
Facilities
Location
Start date
Start date
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 8 years
Subjects
- Global
- Syntax
- Visual Studio
- Testing
- Server
- IT
- Approach
- SQL
Course programme
This two day course assumes that you know how to query data using SQL, and shows you how to really progam in SQL Server
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.)
Additional information
- Recommended for those who are already familiar with SQL
- Develop knowledge on analysing applications on the network
- Some previous programming or database experience would be useful
- GUARANTEED LOWEST PRICE IN THE INDUSTRY
- Learn about mult-statement table-valued functions
- Courses delivered by world class training instructors in luxury venues
- Advanced SQL includes material and manuals
- Book Online or Call 01344 203999 to speak to a training advisor today
SQL Training | SQL Exam