Understand Data Definition Language (DDL)

February 18, 2014 By

You cannot view this unit as you're not logged in yet.

Microsoft MTA - Database Fundamentals

Module 1	Course Introduction and Exam Information	+
Unit 1	Welcome to the Course
Module 2	Understanding Core Database Concepts	-
Unit 1	Understand How Data is stored in Tables
Unit 2	Understand Relational Database Concepts
Unit 3	Understand Data Manipulation Language (DML)
Unit 4	Understand Data Definition Language (DDL)
Module 3	Creating Database Objects	+
Unit 1	Choose Data Types - Part 1
Unit 2	Choose Data Types - Part 2
Unit 3	Understand Tables and How to Create Them
Unit 4	Create Views
Unit 5	Create Stored Procedures and Functions
Module 4	Manipulating Data	+
Unit 1	Select Data - Part 1
Unit 2	Select Data - Part 2
Unit 3	Insert and Update Data
Unit 4	Delete Data
Module 5	Understanding Data Storage	+
Unit 1	Understand Normalization
Unit 2	Understand Primary, Foreign and Composite Keys
Unit 3	Understand Indexes
Module 6	Administering a Database	+
Unit 1	Understand Database Security Concepts
Unit 2	Understand Database Backups and Restore
Module 7	Bonus Exams	+
Unit 1	Bonus Exam 1
Unit 2	Bonus Exam 2