Return to Catalog Home     Return to Curriculum Listing

Databases – Database Manager Resources

Duration

4 hours

Overview

This course starts by providing you with the methods used to create a database and its components. It then introduces you to the commands used to alter database component attributes and shows you how to remove data. You will see how commonly used instructions can be saved as a stored procedure, and the benefits they provide. You will then look at user-defined functions (UDFs), how they are created, and how they differ from stored procedures. Finally, you will be presented with various methods for securing your database.

Audience

This course is suitable for Systems Programmers or DBAs whose responsibility is to create and manage databases, and their management systems.

Prerequisites

Successful completion of the following Interskill courses:

• Databases – Introduction to Databases and Database Managers
• Databases – Introduction to SQL

or equivalent knowledge.

Objectives

After completing this course, the student should be able to:

• Identify basic database resources and describe how they are created
• View, alter, and remove basic database resources
• Explain how Stored Procedures are used
• Describe the purpose of User-Defined Functions, and their benefits
• Identify other commonly used RDBMS Resources
• Describe how RDBMSs Secure Data and Resources

Course Content

Stored Procedures and User-Defined Functions

Creating a Stored Procedure
Procedural SQL
Passing Parameters
External Stored Procedures
Stored Procedure Capabilities
Calling Stored Procedures
DBMS-Supplied Stored Procedures
Benefits of Using Stored Procedures
DBMS Functions
Creating a User-Defined Function (UDF)
Comparing UDFs and Stored Procedures

Databases – Database Manager Resources Mastery Test

Search our catalog