01344 203999
- Available 24/7
Send us your message.
We'll get back to you as soon as we can.
We have your course. Please kindly fill below your contact details to receive full course information and pricing.
Any queries, give us a call
01344 203999
(24 Hours Monday - Sunday)
Courses
In-House Training
Locations
About
At The Knowledge Academy, our classroom-based training courses allow delegates to study and learn in a friendly, engaging,
and interactive environment. We ensure the very best level of teaching, with first-rate instructors, resources,
and state-of-the-art facilities. We provide courses of varying durations and can arrange weekend and residential
courses in order to suit your requirements.
Furthermore, our classroom courses are carried out in thousands
of locations worldwide, making training easily accessible wherever you are. Our courses typically
begin at 9.00 am and continue until 5.00 pm each day, with breaks and refreshments provided. ,
As our most popular form of training available,
we pride ourselves in continuously delivering an outstanding learning experience for our delegates in the classroom.
Our online-based training courses aim to provide you with a complete training experience. Due to their
flexibility, these courses are greatly suited to busy working professionals, or any individual who would prefer the
convenience of an online training course.
Our Computer-Based Training (CBT) courses remove the time and cost
associated with travelling to course locations. You can complete your chosen course in any location, and work at your own pace,
as the learning portal can be accessed 24/7. All of our online training courses have technical and administrative
support and mobile access. Furthermore, each course has been
carefully designed to incorporate informative, instructive, and engaging content. In this way, online
learning can guarantee a valuable and enjoyable training solution.
Our In-House training option allows you to select any of our courses and receive training at a venue of your choice,
by any method of your choice.
In-House courses deliver training to multiple employees at once,
thus reducing travel expenses and providing you with the ultimate convenience and value for money. In addition,
this option allows you to receive a training course that has been specifically tailored to meet your business needs,
ensuring first-class quality, applicability, and value.
By choosing to bring bespoke training to the office,
you can improve business performance, and make your organisation more streamlined, resourceful, and profitable.
With over 25 years’ of experience, we are the market-leaders of In-House training.
Our Virtual training courses provide you with the option to learn using a specialised simulated virtual environment.
In this environment, our expert training instructors will be able to convey information and provide you with the
all the knowledge you require to earn your qualification with The Knowledge Academy. As the largest global
training provider, this method of training allows us to extend our training scope to those who may not
be able to attend a classroom course itself, but would like to receive direct training and support from an instructor.
Using this training delivery method, you would benefit from the convenience of remote access and the elimination
of the time and cost associated with travelling to a training venue.
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 advantages
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
Multi- Statement table-valued functions
Limitations of user-defined functions
Derived Tables and CTEs
Using derived 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.)
SQL (Structured Query Language) is the world’s most widely used database language, utilised by a large variety of database systems for creating queries and manipulating data. Advanced SQL Developers are currently greatly in demand by the IT industry, and a high level of understanding of advanced SQL techniques can put individuals at an advantage when planning to enter into this field of work, or when wishing to enhance their position within their current SQL-based working environment.
This Advanced SQL training course, which has a duration of two days, builds upon the prior knowledge and understanding of SQL, as taught in the Introduction to SQL course. Thus, this Advanced SQL course focusses on sharing new, complex SQL techniques, allowing the delegates to understand the core innovative SQL concepts currently present in the database world. This course creates capable SQL users, confident in executing more complicated commands when viewing and managing tables and running complex queries.
SQL techniques taught during the course include creating and managing tables, Data Manipulation Language (DML), enabling the production of Databases and Apps, and scaling emerging and dynamic technological networks. On completion of the training course, delegates will have a thorough understanding of these techniques, and will have obtained the skills necessary to effectively manage a relational database.
This course is for individuals who are familiar with SQL and would like to improve their skills and expand on their knowledge.
It is required that delegates have prior understanding of SQL, and so it is neccessary for delegates to have attended the Introduction to SQL training course before enrolling on this Advanced SQL course.
No exam is required in order to pass this course.
Available delivery methods for this course:
Classroom
In-house
Online
Virtual
Best Value
CURRENT DEAL - Save £400
SQL Spring Special Offer
Limited Spaces Remaining - Ends 30th April 2018Select your preferred delivery method
Attend your course from the office or home
Interactive support from experienced trainers
Simple to setup and easy to use on any device
We have the guaranteed best price for our courses in the industry
Resources are included for a comprehensive learning experience
Flexible delivery methods are available depending on your learning style
"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"
Joshua Davies, Thames Water
"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."
Diane Gray, Shell
Back to top
