Course SQL SERVER Transact-SQL
The SQL SERVER course is intended for people who need to retrieve data in the SQL Server environment.
Minimum input knowledge
Knowledge of SQL Server at user level.
Course dates SQL SERVER Transact-SQL
Daily courses (2 days): 09:00 - 15:00
Course price: 290.00 / 356.70 EUR
without VAT / incl. VAT
Training syllabus SQL SERVER Transact-SQL
Course Syllabus
- Overview of the SQL Server Management Studio environment and logging in to a database server.
- SQL Server Management Studio functions supporting productivity.
- Introduction to the T-SQL language, batch, GOTO, transaction, dirty pages, commit, Roll-back.
- Overview of data types and their use in practice.
- Converting data types.
- Local and global variables.
- SELECT command in detail, SELECT TOP, SELECT COUNT (*), aliases, nested SELECT.
- NULL value and its use in conditions.
- Sorting using ORDER BY, Collation.
- WHERE condition.
- Searching with LIKE.
- GROUP BY, HAVING clause.
- CASE expression.
- Joining multiple tables using JOIN (INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, SELF JOIN).
- Working with text.
- VIEWS.
- UNION and UNION ALL operators.
- STORED PROCEDURE.
- Programming (loops, branching, working with error states).
- Triggers.
- Azure Data Studio.
Output knowledge
After completing the course, participants will be able to retrieve data from SQL Server. They will get deeper into the T-SQL language.
Recommended courses after completing SQL SERVER Transact-SQL
Show all courses from category SQL, Oracle, Access courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews SQL SERVER Transact-SQL
Average rating