Microsoft

ITM4110 - Database Management

(ANC-ITM4110.AA1)
Lessons
Lab
TestPrep
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Understand Core Database Concepts

  • Understand How Data is Stored in Tables
  • Understand Relational Database Concepts
  • Understand Data Manipulation Language (DML)
  • Understand Data Definition Language (DDL)
  • Summary
2

Create Database Objects

  • Choose Data Types
  • Understand Tables and How to Create them
  • Create Views
  • Create Stored Procedures and Functions
  • Summary
3

Manipulate Data

  • Select Data
  • Insert Data
  • Update Data
  • Delete Data
  • Transaction Controls
  • Summary
4

Understand Data Storage

  • Understand Normalization
  • Understand Primary, Foreign, and Composite keys
  • Understand Indexes
  • Summary
5

Administer a Database

  • Understand Database Security Concepts
  • Understand Database Backups and Restore
  • Summary

1

Understand Core Database Concepts

  • Creating a Database
  • Adding a Column to a Table
  • Renaming a Table
  • Modifying a Column in a Table
  • Dropping a Column from a Table
  • Using the SELECT Command
  • Using the CREATE Command
2

Create Database Objects

  • Handling NULL Values
  • Inserting Values into a Table using the Stored Procedure
  • Using the CREATE VIEW Syntax
  • Creating a Stored Procedure
  • Altering a Stored Procedure
3

Manipulate Data

  • Using the SELECT DISTINCT Statement
  • Using the SELECT, FROM, and WHERE Clauses
  • Using the ORDER BY Keyword
  • Using a Simple Inner Join
  • Using the INSERT statement
  • Using the UPDATE Statement
  • Using the DELETE Statement
4

Understand Data Storage

  • Using Referential Integrity Constraints
  • Creating a Function-Based Index
  • Using a Function-Based Index
  • Creating a Non-Clustered Index
5

Administer a Database

  • Adding a New Login
  • Accessing the Database Roles
  • Creating a Backup

Related Courses

All Courses