Course Name: SQL Server
Functions (Advance T - SQL)
Software
Requirement for Lab:
o
Windows
Platform that support SQL 2012 or 2014 express edition
o Learning Database (Download link
available in Practical session)
Candidate’s
prior knowledge:
Before
attending this course, it is recommended that students have the following
skills:
o
Understanding
of RDBMS concepts, Records, Tables, Data types, SQL Server management Studio
o Basic understanding about writing SQL
queries like Select, Insert, update statement, with knowledge of search condition,
Groups, basic of Flow Control (IF- Else), variables etc.
Who
Should Take This Course:
This is an intermediate level of T-SQL (SQL server Function)
course and intended for:
o
Beginning
T-SQL Programmers, DBAs, Architects, and Analysts
o Those who need to write T-SQL code in
SQL Server 2008, 2012, 2014, and 2016
You will learn how to:
o
Understand
several types of Function with examples and create user defined function
o
Implementing
IF-ELSE, Case When, WHILE and BEGIN-END blocks, Nesting of function
o
Declaring
and manipulating variables and parameters
o
Computation
using function and return scalar values
o
Create
Function that can output table - set of records
o
Provide
several input parameters types in Function – Int, Date, varchar etc.
o
Method
of usage of specific function in CRUD (Create Read Update Delete) statement
o
How
to debug Function
o Advantage and Limitation of Function
Outline:
o
Introduction to Function
System Defined Function: There are many categories of functions
available in MSDN (https://msdn.microsoft.com/en-us/library/ms174318.aspx) but we will cover only those functions which are most
frequently used in IT industry with real scenario.
▪ String Functions: It Perform operations on a string (char or varchar)
input value and return a string or numeric value.
●
Ascii(),
●
Charindex(),
●
Left(),
●
Len(),
●
Lower(),
●
Upper(),
●
Ltrim(),
●
Rtrim(),
●
Patindex(),
●
Replace(),
●
Replicate(),
.
..
.
..
.
.
.....
More will be shared as you attend my course !
.
..
.
o
Debugging
user defined function
o
Advantage
& Limitation of Function
o Projects & Stored procedure usage and advantage
over function – Bonus
