Querying Data with Microsoft Transact-SQL (DP-080) (English) Save as favorite Share this page Print Duration 3 dagen Price € 1795,- 8,9 Reviews 1000+ reviews Location Nieuwegeinvirtueel Schedule Planning ophalen... Classroom Vijfhart-Flex Enroll More information Download brochure In this Microsoft DP-080 course from Vijfhart, you will learn how to use Transact-SQL to query and modify data in relational, Microsoft SQL Server-based database systems such as Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics. We cover writing SELECT statements to retrieve columns from one or more tables, after which you will discover how to sort and filter query results. You will not only work with simple queries, but also learn how to use joins and subqueries to combine data from multiple tables. In addition, you will be introduced to built-in functions to manipulate or calculate values, and learn how to group data and aggregate results. For example, you will be able to calculate totals and averages and directly apply them in analyses relevant to your daily work. You will also practice modifying data with INSERT, UPDATE, DELETE, and MERGE, so you gain experience not only in retrieving data but also in maintaining and updating the database. During the course, you will work in a training environment with real data structures and use the SQL Server query tools, so you directly experience how these techniques function in practice. This way, you will quickly become proficient in Transact-SQL in a manner that suits your way of working and the challenges you encounter in your organization. This course is guaranteed to run. Objectives By the end of the course, you will be able to independently write Transact-SQL queries to analyze, filter, and modify data. You will build a solid foundation for further development in areas such as business intelligence, data engineering, or database administration. Target audience This DP-080 course is designed for anyone working with relational data who wants to learn how to query and manage data using Transact-SQL, such as data analysts, engineers and administrators. Requirements Basic knowledge of databases, SQL, and relational database concepts. Particularities This course is also available in Dutch: Querying Data with Microsoft Transact-SQL (DP-080). Persoonlijk advies? Fabian Klostermann accountmanager T. 026 - 791 15 57 E. f.klostermann@vijfhart.nl Topics Introduction to Transact-SQL Sort and filter results in T-SQL Combine multiple tables with JOINs in T-SQL Write Subqueries in T-SQL Use built-in functions and GROUP BY in Transact-SQL Modify data with T-SQL Schedule & Price * * This course event is guaranteed to run. *Een cursus met valt onder de actie Summer Academy. All prices are exclusive of VAT. Meer informatie over incompany of maatwerk Cursus: Querying Data with Microsoft Transact-SQL (DP-080) (English) Vul onderstaand formulier in en je ontvangt meer informatie over de incompany- en maatwerkmogelijkheden van deze cursus. Fout: Contact formulier niet gevonden. We are happy to help you. Please fill in the request form below and you will receive the requested information as soon as possible. Request quote Download brochure Request information Type of training Group training at the location of your choiceCustomized training to meet your specific goals Agree to follow-up and privacy conditionsI accept the privacy policy Akkoord met opvolging en privacyvoorwaardenI accept theprivacy policy Akkoord met opvolging en privacyvoorwaardenI accept theprivacy policy Related courses Er zijn geen gerelateerde cursussen. Tags: active learningDataDatabaseEnglishMicrosoftOnline cursusSQLSQL ServerVijfhart-active learningVirtuele training Share: Share Share Share Share
Vijfhart