Microsoft Transact-SQL

by Koenig Solutions Claim Listing

Enroll for 2-day Querying Data with Microsoft Transact-SQL - DP-080T00 training course from Koenig Solutions accredited by Microsoft. In this course you will learn about the basics of Microsoft's dialect of the standard SQL language

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Koenig Solutions Logo

img Duration

2 Days

Course Details

Enroll for 2-day Querying Data with Microsoft Transact-SQL - DP-080T00 training course from Koenig Solutions accredited by Microsoft. In this course you will learn about the basics of Microsoft's dialect of the standard SQL language: Transact-SQL.

Through a blend of hands-on labs and interactive lectures, you will learn about 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.

 

Target Audience:

  • Data Analyst
  • Data Engineer
  • Data Scientist
  • Database administrator
  • Database Developer

 

Learning Objectives:

After completing this course, you will be able to:

  • 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
  • Norwood Branch

    C/- ABN AustraliaLevel 1, 8, Beulah Road, Norwood, Adelaide

Check out more SQL Server courses in Australia

CM Training Logo

Microsoft Introduction to SQL Databases

This course draws content from both Microsoft 10985 – Introduction to SQL Databases and Microsoft 20761 – Querying Data with Transact-SQL 2016

by CM Training [Claim Listing ]
Logitrain Logo

Oracle Database Administration I

The Oracle Database Administration I certification training course focuses on Oracle Database Architecture, Managing Users, Roles and Privileges, Moving Data, Managing Tablespaces and Datafiles, Restricting and Sorting Data and more.

by Logitrain
NobleProg (Australia) Logo

HBase For Developers Training Course

This course introduces HBase – a NoSQL store on top of Hadoop.  The course is intended for developers who will be using HBase to develop applications,  and administrators who will manage HBase clusters.

by NobleProg (Australia) [Claim Listing ]
Nexacu Software Skill Training Logo

SQL Beginner Course

Use SQL to access and query your data. A crucial skill for anyone working with data is the ability to access and analyse that data. Structured Query Language (SQL) enables users to access data from databases, combine data from multiple

by Nexacu Software Skill Training [Claim Listing ]
Computer Information System Lab Logo

SQL Server

Our CISLAB hands-on-Lab Training Programs and Job Oriented Training programs are very popular among individual customers.

by Computer Information System Lab [Claim Listing ]

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