# CTE Resource Center - Verso - Database Design and Management (Oracle) Microsoft Imagine Academy Resources Correlation by Task

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Microsoft Imagine Academy Resources Correlation by Task

In this course, the following tasks/competencies reinforce the standards listed beside them. Teachers may identify additional reinforcements in locally developed instructional materials.

Task/Competency Number Task/Competency Statement Standards
34 Identify Internet safety issues and procedures for complying with acceptable use standards. Microsoft Imagine Academy Resources: [2.011] Microsoft Digital Literacy: Internet and the World Wide Web
40 List the major types of databases. Microsoft Imagine Academy Resources: [2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6 ♦ [4.017] Access 2010: Understanding Microsoft Access 2010—Lesson 1 ♦ [5.033] Access 2010: Project 1
43 Identify the characteristics of a relational database. Microsoft Imagine Academy Resources: [2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6 ♦ [4.017] Access 2010: Understanding Microsoft Access 2010—Lesson 1 ♦ [5.033] Access 2010: Project 1
47 Apply business concepts to the database model. Microsoft Imagine Academy Resources: [4.017] Access 2010: Understanding Microsoft Access 2010—Lesson 1 ♦ [5.033] Access 2010: Project 1
48 Define entities among elements of significance. Microsoft Imagine Academy Resources: [4.018] Access 2010: Create Database Tables Using Access—Lesson 2 ♦ [5.034] Access 2010: Project 2
49 Define attributes of each entity. Microsoft Imagine Academy Resources: [2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6 ♦ [4.018] Access 2010: Create Database Tables Using Access—Lesson 2 ♦ [5.034] Access 2010: Project 2
50 Select unique identifiers (UIDs). Microsoft Imagine Academy Resources: [2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6 ♦ [4.018] Access 2010: Create Database Tables Using Access—Lesson 2 ♦ [5.034] Access 2010: Project 2
54 Distinquish among relationship types. Microsoft Imagine Academy Resources: [2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
56 Name relationships. Microsoft Imagine Academy Resources: [2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
61 Illustrate business rules in an entity-relationship model. Microsoft Imagine Academy Resources: [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
62 Define the normalization process. Microsoft Imagine Academy Resources: [2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6
63 Perform the normalization process. Microsoft Imagine Academy Resources: [2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6
64 Resolve many-to-many relationships. Microsoft Imagine Academy Resources: [2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
68 Define relational-database terminology. Microsoft Imagine Academy Resources: [2.022] Microsoft Digital Literacy: Productivity Programs—Lesson 6 ♦ [4.017] Access 2010: Understanding Microsoft Access 2010—Lesson 1 ♦ [5.033] Access 2010: Project 1
74 Identify data constraints. Microsoft Imagine Academy Resources: [3.005] Access 2010: Intermediate Skills—E-Learning Module 1 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
75 Map relationships to foreign keys. Microsoft Imagine Academy Resources: [3.005] Access 2010: Intermediate Skills—E-Learning Module 1 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
76 Describe SQL. Microsoft Imagine Academy Resources: [3.005] Access 2010: Intermediate Skills—E-Learning Module 1
77 Distinguish among categories of SQL statements. Microsoft Imagine Academy Resources: [3.005] Access 2010: Intermediate Skills—E-Learning Module 1
79 Demonstrate methods for selecting columns and arithmetic expressions (selection). Microsoft Imagine Academy Resources: [4.022] Access 2010: Query a Database—Lesson 6 ♦ [5.038] Access 2010: Project 6
82 Describe methods for displaying a table. Microsoft Imagine Academy Resources: [3.176] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 2 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
83 Restrict data, using the WHERE clause. Microsoft Imagine Academy Resources: [3.176] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 2 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
84 Define comparison operators (e.g., =, >, <, >=, <=, <>, !=) Microsoft Imagine Academy Resources: [3.176] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 2 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
85 Restrict data, using the BETWEEN ... AND and IN clauses. Microsoft Imagine Academy Resources: [3.176] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 2 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
86 Restrict data, using wildcards and patterns within the LIKE condition. Microsoft Imagine Academy Resources: [3.177] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 3 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
87 Demonstrate the use of the ESCAPE character with wildcard characters. Microsoft Imagine Academy Resources: [3.177] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 3 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
88 Restrict (or specify) data containing nulls, using the IS (NOT) NULL clause. Microsoft Imagine Academy Resources: [3.177] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 3 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
89 Demonstrate the use of two or more conditional statements using logical operators (i.e., AND, OR, NOT). Microsoft Imagine Academy Resources: [3.176] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 2 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
90 Sort data by using ResultSet with the ORDER BY clause. Microsoft Imagine Academy Resources: [3.150] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 4 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
93 Demonstrate restricting data using ANY and ALL. Microsoft Imagine Academy Resources: [3.171] SQL Server 2008 Release 2: Working with Subqueries Using Microsoft SQL Server 2008—E-Learning Module 1 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.037] Access 2010: Project 5
96 Demonstrate the use of character, number, and date functions in SELECT statements. Microsoft Imagine Academy Resources: [3.175] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 1 ♦ [4.020] Access 2010: Creating Forms—Lesson 4 ♦ [5.036] Access 2010: Project 4
98 Demonstrate the use of null character handling. Microsoft Imagine Academy Resources: [3.150] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 4 ♦ [3.177] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 3
99 Demonstrate the use of conditional expressions. Microsoft Imagine Academy Resources: [4.020] Access 2010: Creating Forms—Lesson 4 ♦ [5.036] Access 2010: Project 4
100 Describe the concept of joining data from two or more tables. Microsoft Imagine Academy Resources: [3.162] SQL Server 2008 Release 2: Joining Data from Multiple Tables in Microsoft SQL Server 2008—E-Learning Module 1 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
103 Define group/aggregate functions. Microsoft Imagine Academy Resources: [3.158] SQL Server 2008 Release 2: Grouping and Summarizing Data in Microsoft SQL Server 2008—E-Learning Module 2 ♦ [5.037] Access 2010: Project 5
104 Describe how to write a query containing group functions. Microsoft Imagine Academy Resources: [3.158] SQL Server 2008 Release 2: Grouping and Summarizing Data in Microsoft SQL Server 2008—E-Learning Module 2 ♦ [5.037] Access 2010: Project 5
105 Construct SQL code by applying a GROUP BY clause that uses column, alias, and number. Microsoft Imagine Academy Resources: [3.158] SQL Server 2008 Release 2: Grouping and Summarizing Data in Microsoft SQL Server 2008—E-Learning Module 2 ♦ [5.037] Access 2010: Project 5
106 Construct code by applying a HAVING clause. Microsoft Imagine Academy Resources: [3.158] SQL Server 2008 Release 2: Grouping and Summarizing Data in Microsoft SQL Server 2008—E-Learning Module 2 ♦ [5.037] Access 2010: Project 5
107 Demonstrate additional functionality of the GROUP BY clause. Microsoft Imagine Academy Resources: [3.158] SQL Server 2008 Release 2: Grouping and Summarizing Data in Microsoft SQL Server 2008—E-Learning Module 2 ♦ [5.037] Access 2010: Project 5
108 Describe the types of problems that subqueries can solve. Microsoft Imagine Academy Resources: [3.171] SQL Server 2008 Release 2: Working with Subqueries Using Microsoft SQL Server 2008—E-Learning Module 1 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
109 Define subqueries. Microsoft Imagine Academy Resources: [3.171] SQL Server 2008 Release 2: Working with Subqueries Using Microsoft SQL Server 2008—E-Learning Module 1 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.037] Access 2010: Project 5
110 Construct a single-row subquery. Microsoft Imagine Academy Resources: [3.171] SQL Server 2008 Release 2: Working with Subqueries Using Microsoft SQL Server 2008—E-Learning Module 1 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.037] Access 2010: Project 5
111 Construct a multi-row subquery. Microsoft Imagine Academy Resources: [3.171] SQL Server 2008 Release 2: Working with Subqueries Using Microsoft SQL Server 2008—E-Learning Module 1 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.037] Access 2010: Project 5
112 Construct a correlated subquery. Microsoft Imagine Academy Resources: [3.171] SQL Server 2008 Release 2: Working with Subqueries Using Microsoft SQL Server 2008—E-Learning Module 1 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.037] Access 2010: Project 5
113 Write a multiple-column subquery. Microsoft Imagine Academy Resources: [3.171] SQL Server 2008 Release 2: Working with Subqueries Using Microsoft SQL Server 2008—E-Learning Module 1 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.037] Access 2010: Project 5
114 Explain the behavior of subqueries when null values are retrieved. Microsoft Imagine Academy Resources: [3.171] SQL Server 2008 Release 2: Working with Subqueries Using Microsoft SQL Server 2008—E-Learning Module 1 ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.037] Access 2010: Project 5
116 Describe integrity constraints. Microsoft Imagine Academy Resources: [3.005] Access 2010: Intermediate Skills—E-Learning Module 1
117 Insert rows into a table. Microsoft Imagine Academy Resources: [3.167] SQL Server 2008 Release 2: Modifying Data in Tables with Microsoft SQL Server 2008—E-Learning Module 3  ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
118 Update data within a table. Microsoft Imagine Academy Resources: [3.169] SQL Server 2008 Release 2: Modifying Data in Tables with Microsoft SQL Server 2008—E-Learning Module 5  ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3
119 Delete rows in a table. Microsoft Imagine Academy Resources: [3.170] SQL Server 2008 Release 2: Modifying Data in Tables with Microsoft SQL Server 2008—E-Learning Module 6  ♦ [4.019] Access 2010: Modify Database Tables—Lesson 3 ♦ [5.035] Access 2010: Project 3