WeUni docsity Logo
Bachelor's Degree
Master's Degree
Doctoral Degrees
Online
Main fields of study

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

Alison Free Online Learning


Location

Ireland

Study Format

Online

Course language

English

Study Fields

IT & Computer Science

Academic pace

Full Time, Part-time

Degree

Courses

Tuition Fee

Request info

Program Description

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

About the School

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.

Similar programs

Online Certificate in Embedded Systems Engineering

University of California, Irvine - Division of Continuing Education

logo University of California, Irvine - Division of Continuing Education

Online

United States of America (USA)

IT & Computer Science, Computer Science, Engineering, Electrical Engineering

Courses


English

9 Months

Find out more

Online Certificate in Data Science

University of California, Irvine - Division of Continuing Education

logo University of California, Irvine - Division of Continuing Education

Online

United States of America (USA)

IT & Computer Science, Data Science

Courses


English

9 Months

Find out more

Online Certificate in E-Learning Instructional Design

University of California, Irvine - Division of Continuing Education

logo University of California, Irvine - Division of Continuing Education

Online

United States of America (USA)

IT & Computer Science, Education

Courses


English

9 Months

Find out more

Online Specialized Studies Program in Machine and Deep Learning

University of California, Irvine - Division of Continuing Education

logo University of California, Irvine - Division of Continuing Education

Online

United States of America (USA)

IT & Computer Science, Computer Science, Artificial Intelligence

Courses


English

9 Months

Find out more