es

My SQL Database Admistration Certification Training  Edureka

My SQL Database Admistration Certification Training Edureka

Mundial 31 dic. 2023
mina7 blog

mina7 blog

organización científica, Examinar oportunidades similares

DETALLES DE LA OPORTUNIDAD

organización científica
Área
País anfitrión
Fecha límite
31 dic. 2023
Nivel de estudio
Tipo de oportunidad
Oportunidad de financiación
No financiación
Países elegibles
Esta oportunidad está destinada a todos los países
Región elegible
Todas las regiones

SQL skills are highly sought after in web development, programming, data analysis and reporting environments. Learn how to write SQL (Structured Query Language) using Microsoft's SQL Server Management Studio from scratch with SQL Essentials training course.

Online Self Learning Courses are designed for self-directed training, allowing participants to begin at their convenience with structured training and review exercises to reinforce learning. You'll learn through videos, PPTs and complete assignments, projects and other activities designed to enhance learning outcomes, all at times that are most convenient to you.

Goal: Data Definition Commands defines the syntax of a database and manipulate database objects. 

 

Module Objectives: 

  • RDBMS (Relational Database Management System) Introduction
  • Normalization in RDBMS
  • Create database objects i.e. Create Table
  • Delete database objects i. e. Delete Database
  • Alter database objects i.e. Change Column Name
  • Create, alter and delete constraints 

 

Topics:

  • Relation Database Management System (RDBMS)
  • Normalization
  • Create Database objects
  • Data Types in SQL
  • Alter Table Statements
  • Drop Table Statements
  • Various Constraints
  • Creating Views

Hands-on/Demo/Use-case:

  • Create Table With Predefine Columns
  • Add New Column to Existing Table
  • Check the constraints on a table
  • Add Primary Key and Foreign Key on Table
  • Remove Unique Constraint

Otras organizaciones


Elige tu destino de estudios


Elige el país al que quieres viajar para estudiar gratis, trabajar o hacer voluntariado

Encuentre también