This course provides the fundamentals of databases.

starstarstarstarstar_outline

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Gain the foundational knowledge you need to take the first steps on this topic.

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

Audience

This course is for anyone intersted in learning about databases.

Language

English

Prerequisites

There are no rerequisites for this course.

Length: 365.0 days ( hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...