Structured Query Language (SQL) is the most popular language used for querying relational databases. SQL supports a number of advanced features that make your queries more intelligent and efficient and take a lot of the work away from the middle ware.
This course is specifically only for Microsoft SQL Server. For an advanced SQL course focused on Oracle, please contact us.
In this course you will learn how to:
Use loops and branches in queries
Create user defined functions and stored procedures
Manage constraints and triggers
Control multiple simultaneous updates
Price (excl. VAT)
Save up to 10% by booking and paying
10 business days before the course.
Information may change without notice.
Database Administrators, Programmers.
Course Outline / Curriculum
Viewing sequence details
NEXT VALUE FOR
IF ... ELSE
Converting rows into columns
IIF, COALESCE, ISNULL
Creating a running total
ROW_NUMBER, RANK and DENSE_RANK
LEAD AND LAG
FIRST_VALUE and LAST_VALUE
User Defined Functions
Restrictions on functions
Table Valued Functions
CROSS APPLY and OUTER APPLY
Common Table Expressions
Schedule Dates and Booking
To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.
Thu 24 Jun 2021
Thu 16 Sep 2021
Thu 9 Dec 2021