Key points about this course

Duration: 2 Days*
Pre-requisites: - Introduction to SQL
Dates & Prices EnquireSend us your message.
XWe have your course. Please kindly fill below your contact details to receive full course information and pricing.
Duration: 2 Days*
Pre-requisites: - Introduction to SQL
Dates & Prices EnquireAvailable delivery methods for this course
Classroom
Onsite
Online
Live Virtual
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.
Stored Procedure Basics
Variables
Parameters and Return Values
Avoiding Scalar Functions
Testing Conditions
Looping
Creating Tables
Temporary Tables and Table Variables
Table Valued Functions
Derived Tables and CTEs
Subqueries
Cursors
Error-Handling
Debugging
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.
Duration: 2 Days*
Pre-requisites: - Introduction to SQL
Dates & Prices EnquireBest price in the industry
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
Various delivery methods
Flexible delivery methods are available depending on your learning style.
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
"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."
Diane Gray, Shell
Don't miss out on our Valentines offers!