Free Online Diploma Databases and Transact-SQL Course | Alison

Diploma in Databases and T-SQL

Learn about database technology and how to program using T-SQL, and get a strong boost to your IT career development.

Free Course
Understanding database technology, how it works and what it can be used for, is essential for any aspiring programmer. Databases underlie a huge range of programming applications, and businesses are becoming more and more invested in using databases to monitor markets. This free course is designed to teach you all you need to know about database technology and how to program using T-SQL, so you can boost your IT career in just a few short hours.
  • Duration

    6-10 Hours
  • Assessment

  • Certification

  • Publisher

    Channel 9





View course modules


This course begins by introducing you to databases and the key components of a database structure - normalization and referential integrity. The course then teaches you about the Data Definition Language and how to create, alter and delete databases. You will then be introduced to DML or Data Manipulation Language. This includes how to use essential statements and the functions and clauses that come with them, such as the SELECT statement and INTERSECT and EXCEPT functions. This will help you with the next lesson where you will learn how to update and delete data in a database.

Next, you will learn how to program in T-SQL, how to sort and remove duplicates, and how to use and understand the most important types of joins. In this section you will also be introduced to subqueries and their function. Next, the course will teach you about security levels and applying security to your databases. You will then learn to use apply operators, present your data with views, build temporary tables, and pivot your data. Finally, and very importantly, you will learn about errors in a database engine, and how to delete them.

Any aspiring computer programmer who wants to boost their career needs to learn about database technology eventually. If you want to gain a solid understanding of this area, then this is the clear and simple course for you. By the end of the course, you will be up-to-speed on database technology and will have the ability to program in T-SQL. That’s a great reward for a free course that takes less than 10 hours. So why wait? Give yourself a great professional boost today.


Start Course Now


Module 1: Core Database Concepts

Module 2: Relational Concepts

Module 3: Creating Databases and Database Objects

Module 4: Using DML Statements

Module 5: SQL Server Administration Fundamentals

Module 6: Diploma in Databases and T-SQL - First Assessment

Module 7: Introducing Transact-SQL

Module 8: Querying Tables with SELECT

Module 9: Querying Multiple Tables with Joins and Using Set Operators

Module 10: Using Functions and Aggregating Data

Module 11: Working with Subqueries, Table Expressions and Data

Module 12: Modifying Data and using T-SQL in Programming

Module 13: T-SQL - Error Handling and Transactions

Module 14: Diploma in Databases and T-SQL - Second Assessment

Module 15: Diploma in Databases and T-SQL - Final Assessment

Learning Outcomes

Having completed this course you will be able to: - Describe a database and give an example of real life uses. - List common database terms and explain their part in a database. - Describe normalization. - Explain three forms of normalization. - Describe referential integrity. - Recognize how constraints are part of referential integrity. - Describe different data types. - Discuss how to create a basic database. - Describe Data Definition Language (DDL) statements for creating databases. - Use the SELECT statement to retrieve data from your database. - Modify your database using INSERT, UPDATE AND DELETE. - Use aggregate functions with the SELECT statement. - Secure your database and its objects. - Add users and set their permission levels. - Backup and restore your data base. - 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 programming 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 enrol, study and complete. To successfully complete this Diploma course and become an Alison Graduate, you need to achieve 80% or higher in each course assessment. Once you have completed this Diploma course, you have the option to acquire an official Diploma, which is a great way to share your achievement with the world. Your Alison Diploma is:

Ideal for sharing with potential employers - include it in your CV, professional social media profiles and job applications
An indication of your commitment to continuously learn, upskill and achieve high results
An incentive for you to continue empowering yourself through lifelong learning

Alison offers 3 types of Diplomas for completed Diploma courses:

Digital Diploma - a downloadable Diploma in PDF format, immediately available to you when you complete your purchase
Diploma - a physical version of your officially branded and security-marked Diploma, posted to you with FREE shipping
Framed Diploma - a physical version of your officially branded and security-marked Diploma in a stylish frame, posted to you with FREE shipping

All Diplomas are available to purchase through the Alison Shop. For more information on purchasing Alison Diplomas, please visit our FAQs. If you decide not to purchase your Alison Diploma, you can still demonstrate your achievement by sharing your Learner Record or Learner Achievement Verification, both of which are accessible from your Dashboard. For more details on our Diploma pricing, please visit our Pricing Page.


    Need Some Help?

    What is a database?
    What are the best free online database courses?
    How much does an online database course cost?
    New course

    This Course has been revised!

    For a more enjoyable learning experience, we recommend that you study the mobile-friendly republished version of this course.

    Take me to revised course.

    You have received a new notification

    Click here to view them all