Main MenuMain Menu
Course Code: IT 468
285 Course Visits
Advanced SQL
Course Sector:
Information Technology
Course Dates and Locations
Choose a date and location to book your seat
No.
Date
Days
Location
Fees
Enrollment
01
5 Days
Dubai, UAE $4,250
02
5 Days
Los Angeles , USA $5,950
Introduction
Training course introducion / brief
This training course is designed to provide participants with the advanced, new, and complex SQL techniques, allowing the delegates to understand the core innovative SQL concepts. This course creates capable SQL users, confident in executing more complicated commands when viewing and managing tables and running complex queries.
Training Course Methodology
The training course is designed to be interactive and participatory, and includes various learning tools to enable the participants to operate effectively and efficiently in a multifunctional environment. The course will use lectures and presentations, exercises, experiential and exposure to real world problems and policy choices confronting delegates.
Course Objectives
At the end of the training course, participants will be able to
- Apply advanced techniques in managing SQL such as advanced queries, how to add, update, and delete data, tables, views, and indexes.
- Enable the production of Databases and Apps.
- Scale emerging and dynamic technological networks
- Confidently execute more complicated commands when viewing and managing tables and running complex queries.
Course Audience
Who is this course for, and can benefit the most
- Cloud Computing Engineer
- Computer Network Specialist
- Computer Support Specialist
- Database Administrator
- Information Technology Analyst
- Information Technology Leadership
- Information Security Specialist
- Software/Application Developer
- Web Developer
- Technology sales consultant
Course Outline
The course aims and learning outcomes
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.
Providers and Associations
Providing the best training services and benefits to our valued clients
Boost certificate of completion
BOOST's Professional Attendance Certificate “BPAC” is always given to the delegates after completing the training course, and depends on their attendance of the program at a rate of no less than 80%, besides their active participation and engagement during the program sessions.
ENDORSED EDUCATION PROVIDER
Flexible deadlines
Customized dates accordance to your schedule
Shareable Certificate
Earn certificate upon completion
COURSE METHODOLOGY
Our Training programs are implemented by combining the participants' academic knowledge and practical practice (30% theoretical / 70% practical activities).
At The end of the training program, Participants are involved in practical workshop to show their skills in applying what they were trained for. A detailed report is submitted to each participant and the training department in the organization on the results of the participant's performance and the return on training. Our programs focus on exercises, case studies, and individual and group presentations.
Since 2001, we have been pioneering the training field in the middle east, we managed to unlock potential and help individuals, teams and organisations to be the best that they can be with our full and integrated solutions.
Quick Links
Our sister companies in Egypt and United Arab Emirates
MOST TRENDING
And Recommended Training Courses
trending
Artificial Intelligence for Leaders
Date: Feb 17, 2025
Location:Abu Dhabi, UAE
trending
Leading and Building a Positive, Motivated, and Empowered Teams
Date: Jan 20, 2025
Location:Online, Virtual
trending
The Risk Management Professional (PMI-RMP Exam Preparation)
Date: Jun 30, 2025
Location:Istanbul, Turkey
We believe in progress for everyone.
We helped more than 10.000 clients over 20 countries on 4 continents in boosting their knowledge, skills and careers.
Boost Training And Consulting © All Copyrights Reserved 2025