SQL Server 2014: T-SQL Fundamentals

Name: SQL Server 2014: T-SQL Fundamentals
Availability: InStock
Rating: 3.8 (14 reviews)

The free online course will help you master T-SQL fundamentals which is central to using Microsoft SQL Server.

Published by

Saved For Later

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

Learning Outcomes

In this free course, you will learn how to:

Outline the history and overview of SQL
Distinguish between data manipulation language (DLL) and data definition language (DDL)
State the operations of batches and scripts
Explain the functions of REPLACE, STUFF and SUBSTRING
Discuss the functions of LTRTIM and RTRIM in string expressions
Describe the GETDATE, DATEPART and DATENAME functions
Describe the ORDERBY and GROUPBY clauses
Explain the operations and functions of the Cartesian product
Distinguish between the inner and outer joins
Explain the functions of the DELETE and TRUNCATE statements
Describe the concepts and challenges of concurrency
Discuss the four isolation levels of SQL Server

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.