DP-080T00 | Querying Data with Microsoft Transact-SQL

by Avantus Training Claim Listing

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.

S$1300

Contact the Institutes

Fill this form

Advertisement

Avantus Training Logo

img Duration

2 Days

Course Details

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.

 

Who Is The Course For?

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.

 

Attainable Skills

• Use SQL Server query tools
• Write SELECT statements to retrieve columns from one or more tables
• Sort and filter selected data
• Use built-in functions to returned data values
• Create groups of data and aggregate the results
• Modify data with Transact-SQL using INSERT, UPDATE, DELETE and MERGE

 

Learning Pathway

  • Module 1: Getting Started with Transact-SQL

  • Module 2: Sorting and Filtering Query Results

  • Module 3: Using Joins and Subqueries

  • Module 4: Using Built-in Functions

  • Module 5: Modifying Data

  • East Branch

    80 Jurong East Street 21, #04-04 Devan Nair Institute, East

Check out more SQL Server courses in Singapore

New Horizons Singapore Logo

SQL Server Training And Certification

Get hands-on SQL Server training to master the most widely used database management system and open the door to new career possibilities.

by New Horizons Singapore [Claim Listing ]
NobleProg (Singapore) Logo

Oracle SQL Intermediate - Data Extraction

The objective of the course is to enable participants to gain a mastery of how to work with the SQL language in Oracle database for data extraction at intermediate level.

by NobleProg (Singapore) [Claim Listing ]
The IT Enabling Company Logo

Oracle Database SQL Certified Expert

This course teaches participants queries, insert, update and delete SQL statements, Data Definition language and Data Control Language, the optimizer, tales and indexes, data modeling and normalization. You will also learn how to use SQL to create and manipulate tables in an Oracle Database.

by The IT Enabling Company [Claim Listing ]
ITEL Learning Systems Logo

SQL Server

SQL Server is a relational database management system (RDBMS) from Microsoft that is designed for the enterprise environment.

by ITEL Learning Systems [Claim Listing ]
NTUC LearningHub Logo

Querying Data With TransactSQL (SF)

The main purpose of this course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

by NTUC LearningHub [Claim Listing ]
  • Price
  • Start Date
  • Duration

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy