Kursusmål On this course, you will be introduced to techniques and subjects relevant for the experienced and more advanced user of T-SQL, on a Microsoft SQL server.
Since you are going to work with UPDATE, DELETE, CREATE, DROP statements you must have more extended rights on your database. The course will also be relevant for you, if you just want to get some knowledge about the possibilities on the platform. If you work on other platforms than Microsoft, the course may still be of interest for you since the same possibilities exists on other platforms.
On the course, you will learn to
- Work with variables and programming structures
- Create and work with temporary tables
- Work with Common Table Expressions (CTE) and ranking functions
- Create and alter views, functions, and stores procedures
- Create and alter tables and constraints
- Use transactions
The course will be conducted in English.
Deltagere We strongly recommend that you participate in our course SQL-basic before entering this course, or in other ways have ...
... achieved the expected basic knowledge about T-SQL and relational databases.
Apart from that, we recommend that you show up in time on the day of the course, willing to learn, and we can promise you the best possible course experience.
Feel free to contact us on 33 14 71 44, firstname.lastname@example.org or via our chat. We are looking forward to seeing you!
Kursusmateriale A course that consists of a both theory and practical exercises. We know the importance of having practical exercises and hands-on is always in focus during the courses. You will get a course material you can use as an encyclopedia after the course and downloads of course exercises.
Kursus indhold 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.
- Date / Time
In this module, you will be introduced to some advanced concepts in T-SQL.
- Common table expression
- Pivot and unpivot
- Ranking functions
In this module, we will introduce the different possibilities for programming in T-SQL.
- Declaration of variables
- Scope and lifetime
- IF, ELSE
- BEGIN, END
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
In this module, we will introduce you to the use of Dynamic SQL, which is often used in Storedprocedures.
- Using EXEC
- Using sp_excutesql
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
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
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
Har du spørgsmål?
Hvis du har yderligere spørgsmål til dette produkt eller ønsker at få fremsendt materiale i forbindelse med produktet, er du velkommen til at benytte kontaktformularen herunder.