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

General Assembly Melbourne Logo

Intro To SQL

In this free, two-hour livestream, you’ll get a foundational understanding of SQL. We’ll cover the basics of SQL structure, querying databases, filtering and aggregating data, and JOINing tables. All in real time, taught by an industry professional.

by General Assembly Melbourne [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 ]
Learn Quest Logo

Quick Microsoft SQL Server 2012 Analysis Services

This fast-paced instructor-led course is intended for IT professionals

by Learn Quest [Claim Listing ]
InterSkill Australia Logo

Oracle Pl/SQLProgramming Advanced

This 2-day Oracle PL/SQL Programming Advanced training course will help the PL/SQL student take advantage of language features, advanced techniques, and packages and facilities provided by Oracle to develop and tune efficient and effective PL/SQL subprograms

by InterSkill Australia [Claim Listing ]
Corporate Training Solutions Australia Logo

SQL Essentials

This course offers end-users a sound background on the concepts of a Relational Database Management System. It is primarily aimed at end-users who need to understand SQL in order to effectively and efficiently query their corporate database

by Corporate Training Solutions Australia [Claim Listing ]

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