-
This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
-
Course Contents
-
- Getting Started with Transact-SQL
- Sorting and Filtering Query Results
- Using Joins and Subqueries
- Using Built-in Functions
- Modifying Data
The original Microsoft courseware is made available to you online.
-
Target Group
-
This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.
-
Knowledge Prerequisites
-
Participants should have some initial experience working with Microsoft SQL Server-based database systems. Participants who occasionally work with data or simply want to learn more about working with data are also well suited for this course.
-
Alternatives
-
Not sure which Azure certification is right for you and want to get an overview of the various levels and roles? Then check out our blog article Azure Certifications.
-
Course Objective
-
This training course teaches the basics of Transact-SQL, Microsoft's dialect of the SQL standard language.
-
Classroom training
- Do you prefer the classic training method? A course in one of our Training Centers, with a competent trainer and the direct exchange between all course participants? Then you should book one of our classroom training dates!
-
Online training
- You wish to attend a course in online mode? We offer you online course dates for this course topic. To attend these seminars, you need to have a PC with Internet access (minimum data rate 1Mbps), a headset when working via VoIP and optionally a camera. For further information and technical recommendations, please refer to.
-
Tailor-made courses
-
You need a special course for your team? In addition to our standard offer, we will also support you in creating your customized courses, which precisely meet your individual demands. We will be glad to consult you and create an individual offer for you.
You can find the complete description of this course with dates and prices ready for download at as PDF.-
This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.
-
Course Contents
-
- Getting Started with Transact-SQL
- Sorting and Filtering Query Results
- Using Joins and Subqueries
- Using Built-in Functions
- Modifying Data
The original Microsoft courseware is made available to you online.
-
Target Group
-
This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers.
-
Knowledge Prerequisites
-
Participants should have some initial experience working with Microsoft SQL Server-based database systems. Participants who occasionally work with data or simply want to learn more about working with data are also well suited for this course.
-
Alternatives
-
Not sure which Azure certification is right for you and want to get an overview of the various levels and roles? Then check out our blog article Azure Certifications.
-
Course Objective
-
This training course teaches the basics of Transact-SQL, Microsoft's dialect of the SQL standard language.
-
Classroom training
- Do you prefer the classic training method? A course in one of our Training Centers, with a competent trainer and the direct exchange between all course participants? Then you should book one of our classroom training dates!
-
Online training
- You wish to attend a course in online mode? We offer you online course dates for this course topic. To attend these seminars, you need to have a PC with Internet access (minimum data rate 1Mbps), a headset when working via VoIP and optionally a camera. For further information and technical recommendations, please refer to.
-
Tailor-made courses
-
You need a special course for your team? In addition to our standard offer, we will also support you in creating your customized courses, which precisely meet your individual demands. We will be glad to consult you and create an individual offer for you.
You can find the complete description of this course with dates and prices ready for download at as PDF.
Guaranteed with the next booking
Online Training
Trainer language German