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

SAS Institute Inc Logo

Designing The Database To Support SAS® Marketing Automation

This course prepares you to optimally design a database to support SAS Marketing Automation.

by SAS Institute Inc [Claim Listing ]
Trainocate Singapore Logo

Oracle Database 18c: Administration Workshop

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. You learn how to create database storage structures appropriate for the business applications supported by your database.

by Trainocate Singapore [Claim Listing ]
St.Hua Private School Logo

SQL Essentials

SQL (Structured Query Language) is a standard language for storing, manipulating and retrieving data in databases. This course is designed to help users understand the most common language for database wrangling.

by St.Hua Private School [Claim Listing ]
Ccisg Logo

Fundamentals Of Microsoft SQL Server 2019

Master the fundamentals of SQL Server 2019, the industry-leading database management platform from Microsoft. In this course, beginners will learn the core skills they need to create and manage SQL Server databases.

by Ccisg [Claim Listing ]
League Of Coders Logo

SQL Server For Developer

Microsoft SQL Server (MSSQL) is a suite of database software which includes a relational database engine, an ETL aka SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and also SQL Server Analysis Services (SSAS) published by Microsoft.

by League Of Coders [Claim Listing ]

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