Loading
Alison Logo

Introduction to Transact-SQL

  • Description
  • Outcome
  • Certification
  • In the free online course Introduction to Transact-SQL you will learn about querying a database using Transact-SQL. This course introduce you to constructing queries using the select statement. You will learn to refine your select statements search with various clauses that can be applied to the select statement. This also includes sorting and filtering queries and the method used to do so, along with combining data from different sources within the database.

    The course begins by introducing you to what SQL and Transact-SQL. You will learn about the select statement for creating queries and the clauses you can apply to the select statement. You will learn about the various data types that a database can hold, as well as working with NULL values in your database.

    Next, you will learn further ways of refining your select statement results by removing duplicates and sorting query results. You then learn about using predicates to further refine your query to filter out results you don’t need. This course also teaches you query multiple tables using joins and different types of joins. You will also learn about combining queries using the Intersect and Except queries.

    In the end, you will be introduced to Functions and aggregating data. You will learn about scalar functions and their tasks. You will learn about logical functions and how they work. You will also learn about window functions and aggregate functions and applying them to your queries. This course teaches you filtering using the group by subclause and Having clause.

    This course will be of great interest to anyone who wishes to learn about querying a database or would like to learn Microsoft variation of SQL, Transact-SQL.

  • 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.
    - Explain how to summarized data using GROUP BY and Filtering functions.

  • All Alison courses are free to study. To successfully complete a course you must score 80% or higher in each course assessments. Upon successful completion of a course, you can choose to make your achievement formal by purchasing an official Alison Diploma, Certificate or PDF.

    Having an official Alison document is a great way to share your success. Plus it’s:

    • Ideal for including in CVs, job applications and portfolios
    • An indication of your ability to learn and achieve high results
    • An incentive to continue to empower yourself through learning
    • A tangible way of supporting the Alison mission to empower people everywhere through education.

Introduction to Transact-SQL
  • Free

  • 2-3 Hours

  • Channel 9

  • Assessment

  • Certification

  • 50 Pts

Modules List( 5 )
  • Introduction to Transact-SQL
  • Introduction to Transact-SQL - Course Resource Files View Resource
  • Module
    1
    Introduction to Transact-SQL
    • In this module you will learn about what Transact-SQL is and what its used for. You will learn about querying your database using the select statement and the clauses you can include within a select statement. You will learn about the different datatypes that a database might hold. You will learn about NULL values in your database.
    • Learning Outcomes
    • Course Introduction
    • Introduction to Transact-SQL
    • The SELECT Statement
    • Data Types and working with NULL
    • Lesson Summary
  • Module 2: Querying tables with the Select statement
    • In this module you will learn about the select statement and further ways of refining your select statement. You will learn about removing duplicates from your query results. You will learn about sorting your query’s results using the Order by clause. You will learn about filtering your select statements search using predicates.
    • Learning Outcomes
    • Removing Duplicates and Sorting
    • Filtering and Using Predicates
    • Lesson Summary
  • Module 3: Querying Multiple Tables with Joins and using set operators
    • In this module you will learn about the concepts and syntax of joins. You will learn about each of the different types of joins you can use in your queries and what each type does. You will learn about combining result of multiple queries using the Union operator. You will learn about Intersect and Except queries.
    • Learning Outcomes
    • Join Concepts and Syntax
    • Inner Joins
    • Outer Joins
    • Cross Joins
    • Self Joins
    • Union Queries
    • Intersect Queries and Except Queries
    • Lesson Summary
  • Module 4: Functions and Aggregating Data
    • In this module you will learn about different functions you can include in your queries. You will learn about Scalar functions and what they do. You will learn about logical functions and how they work. You will also learn about window functions and aggregate functions and applying them to your queries. You will learn about filtering using the group by subclause and Having clause.
    • Learning Outcomes
    • Scalar Functions
    • Logical Functions
    • Window and Aggregate Functions
    • Group by and Filtering with Having
    • Lesson Summary
  • END OF COURSE ASSESSMENT
  • Module 5: Introduction to Transact-SQL Assessment
    • You must score 80% or more to pass this assessment.
    • Introduction to Transact-SQL Assessment
Reviews and Rate
This course has no reviews yet.