Module-1: Datatypes and related problems in SQL
The aim and purpose of this module is to get focus on the different datatypes that T-SQL supports. The focus is mostly on date and string type.
Module-2: Advanced SQL
In this module, you will be introduced to some advanced concepts in T-SQL.
- Common table expression
- Pivot and unpivot
- Ranking functions
Module-3: Variables and programming
In this module, we will introduce the different possibilities for programming in T-SQL.
- Declaration of variables
- Scope and lifetime
- IF, ELSE
- BEGIN, END
Module-4: Temporary tables and Table variables
In this module, we will introduce tables to store selected data temporary. We will also start using table variables and discus the pro´s and con´s of these objects.
- Creating temporary tables
- Creating Table variables
In this module, you will be introduced to different types of cursors. When and where to use them.
- Types of cursors
- Settings of cursors
Module-6: Dynamic SQL
In this module, we will introduce you to the use of Dynamic SQL, which is often used in Storedprocedures.
- Using EXEC
- Using sp_excutesql
Module-7: Introduction to Views
In this module, you will learn about Views. What is a view and why would you use a View. Creating Views to select, Insert, Update data and views to validate data.
- Create / Edit / Drop View
- Update with a view
- View options
Module-8: Introduction to functions
In this module, we will introduce the concept of user defined functions. How do you create your own function and how do you use it afterwards.
- Create / alter / drop function
- Scalar functions
- Table functions
Module-9: Introduction to stored procedures
In this module, you will be introduced to stored procedures. Stored procedures is a very important object on a Microsoft SQL Server. You will be working with stored procedures taking input parameters and having output.
- Create / alter / drop stored procedure
- Stored procedures with parameters
The purpose of this module is to introduce you to the concept of transactions. Transactions is one of the important tools to make sure that data in your database are valid. If errors occur in parts of a process you will be able to roll back all the actions you tried to perform.
- Commit / rollback