Skip to main content

Tivoli Implementation Foundation Skills: Database Administrator Essentials

Tivoli software

Course description


At a glance

Course description

This course provides a basic introduction to relational database management systems. Basic relational database concepts, SQL usage and syntax, and how to create database objects will be covered. Students will be able to perform basic database administration, import and export data, and back up and restore data. Hands-on exercises build on each other and on the knowledge gathered as the student goes through the course.

Objectives

Student will be able to:

  • Articulate relational database concepts and terminology.
  • Perform database startup and shutdown procedures.
  • Create, modify or remove database objects.
  • Articulate the concepts, usage, and syntax of SQL.
  • Use basic SQL to manipulate data and database objects.
  • Create and populate a database.
  • Import and export data.
  • Back up and restore the database.

Course outline

  1. Introduction to Relational Databases
  2. Database Objects
  3. Database Administration
  4. Introduction to SQL
  5. Using SQL
  6. Creating a Database Schema
  7. Importing and Exporting Data
  8. Back up and Restoring Data

Who will benefit from this course

This course is intended for students who desire a basic understanding of relational database management systems concepts, SQL and database administration.

Required skills/knowledge

  • Rudimentary understanding of regular expressions
  • Familiarity with the Windows operating system environment

Recommended courses

None

We're here to help

live-assistance

Easy ways to get the answers you need.


Or call us at:
877-426-3774
Priority code:
104CBW62

Code

Code

Continuous file backup without scheduling, tapes or worries!


Related links