en

My SQL Database Admistration Certification Training  Edureka

My SQL Database Admistration Certification Training Edureka

Worldwide 31 Dec 2023
mina7 blog

mina7 blog

Scientific organisation, Browse similar opportunities

OPPORTUNITY DETAILS

Scientific organisation
Area
Host Country
Deadline
31 Dec 2023
Study level
Opportunity type
Opportunity funding
Not funding
Eligible Countries
This opportunity is destined for all countries
Eligible Region
All Regions

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

Other organizations


Choose your study destination


Choose the country you wish to travel to study for free, work or volunteer

Please find also