Courses of Study: Information Technology

Back
Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
1.) Compare Structured Query Language (SQL) to other languages to determine the needs of the client.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
2.) Analyze predefined software packages for uses and benefits.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
3.) Implement an advanced database design project.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
4.) Determine how to handle errors and utilize the troubleshooting process.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
5.) Analyze declaring variables, SQL functions, and trapping exceptions to build an advanced database.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
6.) Construct different kinds of conditional and iterative control statements.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
7.) Use cursors in multiple rows of tables.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
8.) Demonstrate the use of stored procedures and functions.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
9.) Demonstrate the procedure for accessing objects in the data dictionary.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
10.) Utilize mathematics skills in evaluating system and software requirements for database designs.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
11.) Create Programming Language/Structured Query Language (PL/SQL) packages parts, including specification and body.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
12.) Describe procedures of creating database triggers.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
13.) Implement Data Management Language (DML) components as used with triggers.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
14.) Construct objects to meet program requirements.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
15.) Demonstrate steps of the software development process.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
16.) Demonstrate the use of large object (LOB) data types in a database design.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
17.) Describe implications of procedural dependencies.

Information Technology (2009)
Grade(s): 9 - 12
Database Design III
All Resources: 0
Learning Activities: 0
Lesson Plans: 0
Multimedia: 0
Unit Plans: 0
18.) Utilize research results to determine career and entrepreneurial opportunities, responsibilities, and educational and credentialing requirements in specialized database design.