WeUni docsity Logo
Carreras de Grado
Programa de Máster
Doctorados
Online
Principales áreas de estudio
Bg HeroCard

Diploma en Bases de Datos y T-SQL (Curso Online Gratuito)

Alison Free Online Learning


Ubicación

Irlanda

Formato de estudio

Online

Idioma del programa

Inglés

Áreas de estudio

Informática

Ritmo de estudio

A tiempo completo, A tiempo parcial

Nivel

Cursos

Costos de Matriculación

Solicita información

Descripción del programa

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

Detalles de la institución

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.

Programas similares

Certificado en línea en Ingeniería de Sistemas Embebidos

University of California, Irvine - Division of Continuing Education

logo University of California, Irvine - Division of Continuing Education

Online

Estados Unidos de América (EE.UU.)

Informática, Ciencias de la Computación, Ingeniería, Ingeniería eléctrica

Cursos


Inglés

9 Meses

Descubre más

Certificado Online en Ciencia de Datos

University of California, Irvine - Division of Continuing Education

logo University of California, Irvine - Division of Continuing Education

Online

Estados Unidos de América (EE.UU.)

Informática, Ciencia de Datos

Cursos


Inglés

9 Meses

Descubre más

Certificado en línea en Diseño Instruccional E-Learning

University of California, Irvine - Division of Continuing Education

logo University of California, Irvine - Division of Continuing Education

Online

Estados Unidos de América (EE.UU.)

Informática, Ciencias de la Educación

Cursos


Inglés

9 Meses

Descubre más

Programa de Estudios Especializados en Línea en Aprendizaje Automático y Deep Learning

University of California, Irvine - Division of Continuing Education

logo University of California, Irvine - Division of Continuing Education

Online

Estados Unidos de América (EE.UU.)

Informática, Ciencias de la Computación, Inteligencia Artificial

Cursos


Inglés

9 Meses

Descubre más