The “Microsoft SQL Server - Transact-SQL language - basic level” training is dedicated for anyone who wants to learn the use of relational databases from scratch. Our training will help you in performing your daily duties as a programmer, database administrator and analyst. Interested in mastering Microsoft SQL? Sign up for our training!
The training is designed for anyone wishing to learn the technique of using relational databases. The skills acquired during the training can be useful in performing daily tasks in work of a programmer, database administrator and analyst creating various reports and statements.
During the training the participants will gain knowledge on the construction of a relational database and the principles of using SQL language for data processing. Knowledge of the basics of SQL can be used to independently obtain and transform data from databases operated in the organization. This is a valuable competency for people who deal with the generation of various statements, reports and analyses on a daily basis. The examples of SQL language application discussed during the course come from the most common scenarios of data presentation and analysis.
After completing the course, the participant will be able to:
The training is intended for people who want to learn the technique of using relational databases. The skills acquired during the training can be useful in the daily work of a programmer, database administrator as well as an analyst creating various reports and statements.
Participants of the training are required to know the Windows environment. Familiarity with basic relational database topics will be an added advantage.
3 days each of 8 lesson hours
The training is conducted in the form of alternating mini lectures and practical exercises. It combines technical expertise with practical examples of its use in the work environment.
Microsoft SQL Server tools for working with T-SQL language.
SQL Server Management Studio.
Selecting data - SELECT command.
Filtering data - the WHERE clause.
Formatting the result of a query
Creating expressions in T-SQL language
Use of functions that operate on values:
Use of ordinary and correlated subqueries.
Common Table Expressions (CTE) - ordinary and recursive.
Data modification - commands:
Transactions, data locking.
Use of indexes to optimize query performance
After completing the training, it is recommended to take the following courses:
Interested in a course? Contact us: firstname.lastname@example.org
He has several years of teaching and training experience, the main area of training specialization is the application and administration of the Oracle database. He also teaches PostreSQL, MySQL and SQL syntax in MS SQL Server databases.
+48 12 687 78 11
+48 608 646 465