Advanced SQL Training | SQL Training

Course Information

Advanced SQL Course Outline

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.)

Who is this SQL Training course for?

This course is for individuals who are familiar with SQL and would like to improve their skills and expand on their knowledge.

Prerequisites

It is required that delegates have a prior understanding of SQL, and so it is necessary for delegates to have attended the Introduction to SQL training course before enrolling on this Advanced SQL course.

Advanced SQL Course Overview

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 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.

What's included in this SQL Training Course?

A Comprehensive SQL Course Folder
Full Access to Training Slides and Trainer Notes
Certificate of Attendance
24/7 Support Before, During & After your Course
Refreshments Available Throughout the Day (Classroom Only)

Why choose us

Ways to take this course

Our easy to use Virtual platform allows you to sit the course from home with a live instructor. You will follow the same schedule as the classroom course, and will be able to interact with the trainer and other delegates.

Learn more in our FAQs

Our fully interactive online training platform is compatible across all devices and can be accessed from anywhere, at any time. All our online courses come with a standard 90 days access that can be extended upon request. Our expert trainers are constantly on hand to help you with any questions which may arise.

Learn more in our FAQs

This is our most popular style of learning. We run courses in 1200 locations, across 200 countries in one of our hand-picked training venues, providing the all important ‘human touch’ which may be missed in other learning styles.

Highly experienced trainers

All our trainers are highly qualified, have 10+ years of real-world experience and will provide you with an engaging learning experience.

State of the art training venues

We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible

Small class sizes

We limit our class sizes to promote better discussion and ensuring everyone has a personalized experience

Great value for money

Get more bang for your buck! If you find your chosen course cheaper elsewhere, we’ll match it!

Learn more in our FAQs

This is the same great training as our classroom learning but carried out at your own business premises. This is the perfect option for larger scale training requirements and means less time away from the office.

Tailored learning experience

Our courses can be adapted to meet your individual project or business requirements regardless of scope.

Maximise your training budget

Cut unnecessary costs and focus your entire budget on what really matters, the training.

Team building opportunity

This gives your team a great opportunity to come together, bond, and discuss, which you may not get in a standard classroom setting.

Monitor employees progress

Keep track of your employees’ progression and performance in your own workspace.

Learn more in our FAQs

What our customers are saying

Advanced SQL FAQs

FAQ's

What is SQL?

SQL (Structured Query Language) is the world’s most widely used database language, used by a large variety of database systems for creating queries and manipulating data. To find out more about SQL, take a look at our SQL Topic page.

What is included in the Advanced SQL training course?

On this SQL training course with The Knowledge Academy, you will be provided with: A courseware book, Manual, Certificate, and Refreshments

What are the advantages of SQL?

Following are advantages of SQL: • No coding needed • Well defined standards • Portability • Multiple data views • Interactive language • Security features are better.

What level of understanding of SQL should I have before attended this Advanced SQL course?

It would be useful for you to have some previous programming or database experience. The Introduction to SQL training course provided by The Knowledge Academy supplies candidates with this experience and as such, is considered a prerequisite for this Advanced SQL course.

3 Is SQL server a language?

SQL is a domain-specific language used in programming, designed for manipulating, and managing data in a relational database management system, or for stream processing in relational data stream management system.

What are the basic commands of SQL?

Here are some commands of SQL: CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE INDEX, DROP INDEX, SELECT, UPDATE, DELETE, INSERT INTO.

What is the cost/training fees for Advanced SQL certification in the United Kingdom?

The price for Advanced SQL certification in the United Kingdom starts from £1295

Which is the best training institute/provider of Advanced SQL in the United Kingdom?

The Knowledge Academy is the Leading global training provider in the world for Advanced SQL.

What are the best SQL Training courses in the United Kingdom?

Please see our SQL Training courses available in the United Kingdom

Why choose us

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Many delivery methods

Flexible delivery methods are available depending on your learning style.

High quality resources

Resources are included for a comprehensive learning experience.

"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