Module I. Review of basic SQL statements.
· Information selection (Select…, From…, Distinct, Alias).
· Specifying information selection criteria (Where…).
· Logical, mathematical and wildcard operators (In, Like, Between).
· Null values and ordering information (Order by).
· Grouping information and group functions (Group by, Having).
· Sorting data.
· Filtering data with statements.
· Filtering data with TOP and OFFSET – FETCH.
· Working with unknown values.
Module II. Working with SQL Server data types.
· Introduction to SQL Server data types.
· Working with character data types.
· Working with date and time data types.
Module III. Using set operators.
· Developing queries with the UNION operator.
· Using EXCEPT and INTERSECT.
· Using APPLY.
Module IV. Using DML to manipulate data.
· Insert data.
· Modify and delete data.
Module V. Using built-in functions.
· Query development with built-in functions.
· Using conversion functions.
· Using logical functions.
· Use of functions for handling null values.
Module VI. Using pivoting and grouping sets.
· Preparing queries with Pivot.
· Query development with Pivot.
Module VII. Transaction control.
· Commit and Rollback.
· Commit and Rollback by phases.
Module VIII. Control statements.
· If-then-else-end if.
· Case.
· While loop.
· Labels.
· Try – Catch.
Module IX. Using stored procedures.
· Declaration of variables.
· Types of procedures.
· Creation of procedures.
· Execution of procedures.
· Elimination of procedures.
· Parameter passing.
Module X. Cursor implementation.
· Characteristics.
· Declaration, opening, use and closing.
Module XII. Trigger implementation.
· Characteristics.
· Creating triggers.
· Deleting triggers.