Cours M40364-A
Database Administration Fundamentals

Doelstelling
  • Understand Core Database Concepts
  • Create Database Objects
  • Manipulate Data
  • Understand Data Storage
  • Administer a Database
Inhoud

Core Database Concepts

  • Database Concepts
  • Data Manipulation Language (DML)
  • Data Definition Language (DDL)

Creating Database Objects

  • Key Terms
  • Data Types
  • Creating and Using Tables
  • Creating Views
  • Creating Stored Procedures

Manipulating Data

  • Using Queries to Select Data
  • Using Queries to Insert Data
  • Updating Data and Databases
  • Deleting Data

Data Storage

  • Normalizing a Database
  • Primary, Foreign, and Composite Keys
  • Clustered and Non-Clustered Indexes

Administering a Database

  • Securing Databases
  • Backing Up and Restoring Databases

Details

Duur
4 dagen
Deelnemers
8
Bestemd voor
IT-specialist
Voorkennis
  • None