What are you looking for?

close

close

Or select from our popular topics

Press esc to close

close

close

Talk to a learning expert

Fill out your contact details below and our training experts will be in touch.

alertIf you wish to make any changes to your course, please log a ticket and choose the category ‘booking change’

Fill out your  contact details  below

WHO WILL BE FUNDING THE COURSE?

+44

By submitting your details you agree to be contacted in order to respond to your enquiry

close

close

Press esc to close

close

close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

Close
close

close

Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

Close
close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

Close

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

Show moredowndown
Inquire now

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. 

Show moredowndown

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)

Show moredowndown

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.

Virtual_Works_on_all_devices-min
Virtual_Recording_&_transcripts-min
Virtual_whiteboard-min
Virtual_See_trainers_screen-min
Virtual_Share_documents-min
Inquire now
Learn more in our FAQs image image

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.

online_certificates
online_immediate access
online_work_all
online_exams_included
image
Inquire now
Learn more in our FAQs image image

What our customers are saying

quote

He was excellent

Everistus Oputa

starstarstarstarstar
quote

He is good and the example provided was the best help.

sonali Mishra

starstarstarstarstar

Advanced SQL FAQs

FAQ's

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.

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

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

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.

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.

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

The price for Advanced SQL certification in Canada starts from CAD1995

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

Please see our SQL Training courses available in Canada
Inquire now

Why choose us

icon

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.

icon

Many delivery methods

Flexible delivery methods are available depending on your learning style.

icon

High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"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

santander logo
bmw Logo
Google Logo

Related courses

Introduction to SQLnext Java Programmingnext Website Design Coursenext C++ Programming (C Plus Plus)next PHP Programmingnext

Looking for more information on SQL Training?

What is SQL TrainingimageHistory of SQL TrainingimageSQL Training ExamsimageSQL Training FAQsimageSQL Training QualificationsimageWhat to do after SQL TrainingimageSQL Training PDFsimageSQL Training JobsimageSQL Training Booksimage
backBack to course information

DELIVERY METHOD

Online Instructor-led Online Self-paced Onsite

Power BI and SQL Package

Save upto 40%
4 courses
Included courses:

Introduction to SQLCAD1395

Advanced SQLCAD1995

Microsoft Power BI Certification TrainingCAD1395

DAX TrainingCAD1395

Total without package:  CAD6180

Package price:  CAD3695 (Save CAD2485)

Purchase now

Limited budget?

To help and support our clients we are providing a limited number of 250 daily discount codes. Hurry, first come, first served!
warning If you miss out, enquire to get yourself on the waiting list for the next day!
Inquire now for code(172 left)

We use cookies that are essential for our site to work. Please visit our cookie policy for more information. To accept all cookies click 'Accept & close'.

Accept & close