Diploma in Databases and T-SQL (Free Online Course)

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

This free online Databases and T-SQL course will teach you the core concepts of databases and their structure. It will teach you how to retrieve data from a database using Structured Query Language (SQL) and Microsoft's variant Transact-SQL (T-SQL). You will learn about queries and the different constraints and clauses you can include in them. You will also study administrative tasks you can perform on a database.

What You Will Learn In This Free Course

• Describe a database and give an example of real-life uses
• List common database terms and explain their part in a database
• Explain three forms of normalization and referential integrity
• Describe different data types. - Discuss how to create a basic database
• Use the Select statement, including aggregate functions, to retrieve data from your database
• Modify your database using Insert, Update, and Delete
• Add users and set their permission levels. - Backup and restore your database
• Set up an Azure SQL Database environment
• Describe the different data types and their uses
• Explain Null functions, removal of duplicates and how they work with SQL queries
• Choose how to sort SQL query results

We are Alison, one of the world’s largest free learning platforms for education and skills training. Founded in 2007, we are a for-profit social enterprise dedicated to making it possible for anyone to study anything, anywhere, at any time - for free and online. Through our mission we are a catalyst for positive social change, creating opportunity, prosperity, and equality for everyone.

Build Your Career In 3 Easy Steps

Free Personality Assessment, Understand Who You Truly Are!

Alison’s free Workplace Personality Assessment gives you a simple scientific report of your top skills & strengths in just 12 minutes. Take the recommended free courses to boost your strengths!

Fast Track Your Career With Alison's Career Guide

From software developer and business manager to head nurse and chef, browse 600+ exciting careers and the courses you need to achieve them. Discover all you need to know about job responsibilities, and the experience you require, and get suggested courses to learn the skills to succeed!

Get Hired, Create a Job-Winning Resumé

Create a job-winning Resumé with Alison’s Resumé Builder and apply for your dream job

Advance Your Career. Learn In-demand Skills.

Upskill in business analytics, health care, graphic design, management and more.