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

Wardy IT Solutions Logo

Introduction to SQL Databases

Introduction to SQL Databases course is offered by Wardy IT Solutions. As a Microsoft Partner we’ve been awarded with the Silver Learning competency. Every training session we run is taught by a Microsoft Certified Trainer.

by Wardy IT Solutions [Claim Listing ]
Victorian Institute of Technology Logo

SQL (Database)

SQL (Database) course is offered by Victorian Institute of Technology for all skill level. VIT provides you with a smart start to your education and gives you a better and brighter future.

by Victorian Institute of Technology [Claim Listing ]
Koenig Solutions Logo

MySQL Fundamentals Ed 1 Course

To mastering MySQL, the world's most popular open source database, it is recommended to learn MySQL fundamentals before. Develop a solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools. In this course. you will be introduced to the MySQL Cloud S...

by Koenig Solutions [Claim Listing ]
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 ]
New Horizons Learning Centre Logo

SQL Server 2016 Training

SQL Server 2016, the latest version of Microsoft’s flagship DBMS allows organisations to build intelligent mission-critical applications and gain real-time insights across their transactional and analytical data. Master SQL Server 2016 Database Administration, development and business intelligenc...

by New Horizons Learning Centre [Claim Listing ]

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