Course code: NP1893
This beginner-level course introduces learners to Transact-SQL (T-SQL), Microsoft’s implementation of the SQL standard. Participants will learn how to query and modify data in relational databases hosted on Microsoft SQL Server, Azure SQL Database, Azure Synapse Analytics, and Microsoft Fabric. The course is ideal for anyone working with data or interested in learning SQL fundamentals.Professional
and certified lecturers
Internationally
recognized certifications
Wide range of technical
and soft skills courses
Great customer
service
Making courses
exactly to measure your needs
Starting date: Upon request
Guaranteed
Type: Self-paced
Course duration: 16 hours
Language: en
Price without VAT: 285 EUR
Starting date: Upon request
Guaranteed
Type: Self-paced
Course duration: 16 hours
Language: en
Price without VAT: 75 EUR
| Starting date |
Place |
Type | Course duration |
Language | Price without VAT | ||
|---|---|---|---|---|---|---|---|
| G | Upon request | Self-paced | 16 hours | en | 285 EUR | Register | |
| G | Upon request | Self-paced | 16 hours | en | 75 EUR | Register | |
| G | Guaranteed course | ||||||
Use SELECT and JOIN to retrieve related data.
Apply INSERT, UPDATE, DELETE to manage database entries.
Use WHERE and ORDER BY for refined queries.
Understand T-SQL and manage cloud-hosted environments.
Module 1: Introduction to Transact-SQL
Module 2: Sort and Filter Results in T-SQL
Module 3: Combine Multiple Tables with JOINs in T-SQL
Module 4: Write Subqueries in T-SQL
Module 5: Use Built-in Functions and GROUP BY in Transact-SQL
Module 6: Modify Data with T-SQL
