Querying Data with Microsoft Transact-SQL
kod szkolenia: DP-080 / ENG DL 2d
- Database administrator
- IT specialist
- Data analyst
- Microsoft SQL
- Azure SQL
- Azure Synapse Analytics
- Databases
The course will teach Microsoft dialect fundamentals in standard SQL language: Transact-SQL.
Topics include both querying and data modifications in relational databases, which are hosted in database systems based on Microsoft SQL Server, including: Microsoft SQL Server, Azure SQL Database i Azure Synapse Analytics.
- The use of SQL Server querying tools
- Instrukcje SELECT instructions to download columns from one or more tables
- Sorting and filtering selected data
- Using built-in features to return data values
- Creating data groups and aggregating results
- Data modification using Transact-SQL: INSERT, UPDATE, DELETE i MERGE
DP-080 course may be beneficial for everyone who needs to:
- write basic SQL or Transact-SQL queries
or works:
- with data as:
- data analyst
- data engineer
- scientist
- database administrator
- database developer
- it may also be useful for other people engaged peripherally in data or who would like to know more about working with data, such as solution architects, students and technology managers.
To make your work more convenient and training more effective, we suggest using an additional screen. Lack of such screen does not exclude participation in the training; however, it significantly influences working comfort during classes.
You can find information and requirements of participation in Distance Learning trainings at: https://www.altkomakademia.pl/distance-learning/#FAQ
- Training: English
- Materials: English
https://learn.microsoft.com/pl-pl/training/
- access to Altkom Akademia student
Training method:
- theory
- demos
- individual laboratories
- 50% theory
- 50% practice
- Introduction to Transact-SQL
- Using SELECT instruction
- Sorting and filtering query results
- Sorting query results
- Data filtering
- The use of connections and subqueries
- The use of JOIN operation
- Using subqueries
- The use of embedded functions
- First steps with scalar functions
- Grouping aggregated results
- Data modification
- Placing data in tables
- Modifying and deleting data