Introduction to Transact-SQL

Name: Introduction to Transact-SQL
Availability: InStock

Gain a better understanding of what SQL and Transact-SQL are and learn how to query databases using T-SQL.

Published by

Saved For Later

Confident you have the skills to certify without completing the course content?

Learning Outcomes

Having completed this course you will be able to:

Set up an Azure SQL Database environment
Describe the different data types and their uses
Identify NULL functions and how they work with SQL queries
Identify how to remove duplicates from SQL query searches
Choose how to sort SQL query results
Construct a SQL query with predicates and filtering
Describe the concept and uses of a Join
Identify where to implement Joins in SQL queries
Identify where to apply the UNION operator in a SQL query to combine data from two different tables
Recognize where to add INTERSECT and EXCEPT operators in a SQL queries
Identify many of the built in Functions in Transact- SQL and where use them in SQL queries
State how to summarize data with Aggregating functions

Published by

Positive learner ratings

Learners Courses

Earn credentials that matter: Anyone can say they’re learning. A CPD-accredited Alison Certificate proves you followed through.
Get an edge over others: Add your Certificate to your CV, LinkedIn, and Alison Profile to strengthen job applications and promotion opportunities.
Show you’re serious about growth: A Certificate signals initiative, commitment, and a willingness to keep learning; qualities employers actively look for.