Loading
Alison Logo

Transact-SQL - Programming Techniques and Error Handling Free Course

certifcate icon
  • Description
  • Outcome
  • Certification
  • In the free online Transact-SQL - Programming Techniques and Error Handling you will learn about the many different options you have for queries and subqueries. You will learn to modify your data and use program within your queries. You will learn about the process of handling, raising and catching errors.

    The course begins by introducing you to Subqueries, what they are and their function. You will learn to apply operators within your queries and presenting data with views and temporary table. You will also learn about table valued functions, derived tables, how to pivot data and unpivot the pivoted data. This course also teaches about grouping sets subclause of the group by clause.

    Next, you will learn about modifying your data with the insert and update functions. You will learn about deleting data from your table, batches, comments and declaring variables for your queries. You will also learn about creating conditional branching and looping within your queries.

    In the end, you will be introduced to the elements of database engine errors. You will learn about raising and handling errors. This course also teaches you to try catch block and use transactions in your queries.

    This free Alison course would be of interest to those who wish to learn more about using queries in a database and deepen their knowledge of Transact-SQL.

  • Having completed this course you will be able to:
    - Identify the elements of database engine errors.
    - Recognize the process error handling and catching errors in Transact-SQL code.
    - Discuss the concept of transactions.
    - Distinguish how to add data to a database using the INSERT function.
    - Indicate how to update and delete data from a database using the respective functions.
    - Explain creating variables for use within SQL queries.
    - Illustrate the importance of comments to describe SQL code
    - Identify programing constructs such as IF statements and loops in SQL queries.
    - Illustrate how to use subqueries within your queries.
    - Describe using APPLY operator to use SQL query results in another SQL query.
    - Describe a Temporary table, its uses and drawbacks.
    - Identify common table expressions(CTEs) in SQL queries.
    - Explain how to group data using GROUPING SET sub-clause of GROUP BY clause.
    - Describe pivoting data and unpivoting data using the PIOVT and UNPIVOT operators.

  • 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.

Modules List( 4 )
  • Transact-SQL - Programming Techniques and Error Ha...
  • Transact-SQL - Programming Techniques and Error Handling - Course Resource Files
  • Module 1: Working with Subqueries, Table Expressions and Data
    • Learning Outcomes
    • Subqueries
    • APPLY Operator
    • Views
    • Temporary Tables and Table Variables
    • Table Valued Functions
    • Derived Tables
    • Common Table Expressions
    • Grouping Sets
    • Pivoting Data
    • Lesson Summary
  • Module 2: Modifying Data and using T-SQL in Programming
    • Learning Outcomes
    • Inserting Data
    • Update and Delete
    • Batches, Comments and Variables
    • Conditional Branching and Looping
    • Stored Procedures
    • Lesson Summary
  • Module 3: T-SQL - Error Handling and Transactions
    • Learning Outcomes
    • Error Message and Raising Errors
    • Catching and Handling Errors
    • Transactions
    • Lesson Summary
  • END OF COURSE ASSESSMENT
  • Module 4: Transact-SQL - Programming Techniques and Error Handling Assessment
    • Transact-SQL - Programming Techniques and Error Handling Assessment
Topics List ( 11 )
Module 1: Working with Subqueries, Table Expressions and Data
In this module you will learn about Subqueries what they are and how they work. You will learn about the Apply operators and using them within your queries. You will learn about presenting your data with views and temporary tables. You will learn about table valued functions and derived tables, how they work and uses. You will also learn how pivot and unpivot your data, as well as the Grouping sets subclause of the group by clause.
Topics List ( 7 )
Module 2: Modifying Data and using T-SQL in Programming
In this module you will learn about how to insert data in to your database tables, and the constraints involved in inserting new data. You will learn about the update and delete functions and how to properly use them. You will learn about batches, comments and declaring variables. You will also learn about Conditional branching and looping within your queries.
Topics List ( 5 )
Module 3: T-SQL - Error Handling and Transactions
In this module you will learn about elements of a database engine errors. You will learn about how to handle errors as well as raise them. You will learn about use the try catch block if some code could cause an error. You will learn about transactions and how they work.
Topics List ( 1 )
Module 4: Transact-SQL - Programming Techniques and Error Handling Assessment
You must score 80% or more to pass this assessment.
Course Features
  • Duration

    2-3 Hours

  • Publisher

    Channel 9

  • Video

    Yes

  • Audio

    Yes

  • Assessment

    Yes

  • Certification

    Yes

  • Price

    Free

  • Reward

    50 Pts

  • Responsive

    No

Reviews and Rate
This course has no reviews yet.
Tags