Professional Learning Podcast Treasury Lesson Plans Personal Workspace Site Search ALEXville Learning Assets Home Courses of Study
Back

Information Technology, Grade 9 - 12, Database Design III, 2009

1.) Compare Structured Query Language (SQL) to other languages to determine the needs of the client.

2.) Analyze predefined software packages for uses and benefits.

3.) Implement an advanced database design project.

4.) Determine how to handle errors and utilize the troubleshooting process.

5.) Analyze declaring variables, SQL functions, and trapping exceptions to build an advanced database.

6.) Construct different kinds of conditional and iterative control statements.

7.) Use cursors in multiple rows of tables.

8.) Demonstrate the use of stored procedures and functions.

9.) Demonstrate the procedure for accessing objects in the data dictionary.

10.) Utilize mathematics skills in evaluating system and software requirements for database designs.

11.) Create Programming Language/Structured Query Language (PL/SQL) packages parts, including specification and body.

12.) Describe procedures of creating database triggers.

13.) Implement Data Management Language (DML) components as used with triggers.

14.) Construct objects to meet program requirements.

15.) Demonstrate steps of the software development process.

16.) Demonstrate the use of large object (LOB) data types in a database design.

17.) Describe implications of procedural dependencies.

18.) Utilize research results to determine career and entrepreneurial opportunities, responsibilities, and educational and credentialing requirements in specialized database design.

Alabama Virtual Library
Alabama Virtual Library

Hosted by Alabama Supercomputer Authority
The University of Alabama at Birmingham
The University of Alabama at Birmingham
The Malone Family Foundation
The Malone Family Foundation
Thinkfinity
Thinkfinity
Best of the Web

Web Design by: Digital Mason LLC