Join millions using the Alison App – faster, easier, and made for learning on the move... 📲 Learn On The Go With
The Alison App
Get App
Explore

Your Recent Searches

    en
    LMS
    en
    Site language

    Your Learner Verification

    This is to verify that Carlo Frasca has completed the course Diploma in Databases and T-SQL on Alison.

    Carlo Frasca

    Alison ID: 56460660

    Course Completed: Diploma in Databases and T-SQL

    Date of Completion: 9th March 2026

    Email: [email protected]

    Total Study Time: 81h 15m

    Final Assessment Score:

    Alison courses requires at least
    80% to pass the final assessment

    90%
    CPD Hours Completed:

    CPD approved learning hours
    completed through this course

    80-82h

    Course Information

    Learn about the core concepts of database including the structure by studying this free Databases and T-SQL course.

    This course begins by discussing the fundamental concepts of a database. You will be introduced to databases, SQL, DBMS, and RDMS. You will also learn about SQL Server Management Studio and how GUI can be used to manage an SQL Server, its databases, and the content contained within the databases. You will study the relational concepts of a database, datatype and its categories, the Data Manipulation Language and the SELECT statement, and the fundamentals of SQL Server Administration.

    You will then look into Transact-SQL. SQL stands for Structured Query Language, and is generally used as a standard across the industry for interrogating databases. Transact-SQL, on the other hand, is Microsoft's implementation of SQL syntax which is the same as standard SQL with a few Microsoft specific twists, used for Microsoft's database products. You will also learn how to use functions and aggregate data, work with subqueries, modify data and use T-SQL in programming, handle error and transactions, and more!

    Learn more about databases and the use of T-SQL to create queries for retrieving data from databases with this free online course. It will greatly enhance your computer programming skills and keep you ahead of your peers. You will not only learn the key components of a database structure but learn administrative tasks that you can perform on a database, from security to dealing with errors. These are highly valuable skills so make sure to check out this course now! 

    Modules Completed

    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: Course assessment

    Tell us why you need your learner verification?



    professional/learner-record.learner_verification.Save