Introduction to Transact-SQL at Alison Overview
Duration | 4 hours |
Total fee | Free |
Mode of learning | Online |
Official Website | Explore Free Course  |
Credential | Certificate |
Introduction to Transact-SQL at Alison Highlights
- Earn a Certificate of completion from Alison
- Accredited by CPD
- Learn how to identify NULL functions and how they work with SQL queries
Introduction to Transact-SQL at Alison Course details
- 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
- Choose how to sort SQL query results
- Describe the concept and uses of a Join
- Identify where to implement Joins in SQL queries
- This free online Introduction to Transact-SQL course will teach you how to construct queries using the select statement
- Teach you how to refine your select statement search with various clauses that can be applied to it
- Learn how to sort and filter queries as well as combine data from different sources within the database
Introduction to Transact-SQL at Alison Curriculum
Introducing Transact-SQL
Introducing Transact-SQL - Learning Outcomes
Introducing Transact-SQL - Course Introduction
Introduction to Transact-SQL
The SELECT Statement
Data Types and Working with NULL
Introducing Transact-SQL - Lesson Summary
Querying Tables with Select
Querying Tables with Select - Learning Outcomes
Removing Duplicates and Sorting
Filtering and Using Predicates
Querying Tables with Select - Lesson Summary
Querying Multiple Tables with Joins and Using Set Operators
Querying Multiple Tables with Joins and Using Set Operators - Learning Outcomes
Join Concepts and Syntax
Inner Joins
Outer Joins
Cross Joins
Self Joins
Union Queries
Intersect Queries and Except Queries
Querying Multiple Tables with Joins and Using Set Operators - Lesson Summary
Using Functions and Aggregating Data
Using Functions and Aggregating Data - Learning Outcomes
Scalar Functions
Logical Functions
Window and Aggregate Functions
Group By and Filtering with Having
Using Functions and Aggregating Data - Lesson Summary
Course assessment
Introduction to Transact-SQL - Final Assessment
Other courses offered by Alison
Introduction to Transact-SQL at Alison Students Ratings & Reviews
2 Ratings- 2-31
Student Forum
Anything you would want to ask experts?